Job Description

Database Administrator (Oracle (PL/SQL) + PostgreSQL DBA)

Location: 44 Holland Ave., Albany, NY or 330 Fifth Ave., New York, NY 10001

Maintain responsibility for implementing and maintaining OPHE complex Oracle and AWS PostgreSQL databases. Analyze the design, development, and delivery or implementation of data solutions, including architecture design, prototyping of concepts to proof of concept, analysis of the development of standards, design, and test plans, code, module design development and testing, data solution debugging, design and implementation of a solution that follows efficient design techniques, and development that meets and exceeds the intent of the design of the data solution. Assist with the planning and engineering of the OPHE databases. Monitor performance, scalability, and security and evaluate existing database design to determine the necessary updates and integration requirements of a new design and to ensure final solutions meet OMH OPHE needs.

Responsibilities

• Install, Configure, Administer, Maintains, Develops and implements policies and procedures for ensuring the security and integrity of all varieties of databases.
• Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, capacity issues, replication, and other distributed data issues
• Formulates and implements backup procedures for all OPHE cloud databases
• Perform database related development as dictated by departmental or project demands
• Develop Oracle stored procedure, packages, and triggers to support applications and integrate in-house applications with cloud-based software
• Experience with Cloud database technologies, preferably AWS
• Strong experience with AWS Cloud products (EC2, EBS, S3, Lambda, Aurora, Dynamo DB, EMR, DMS data migration, Athena, Glue, Kinesis, SQS/SNS, etc.)
• Strong experience with the automation tools /scripting or processes
• Must have DB Concept on Security, Backup and recovery strategies, performance tuning, System Copies, high availability and disaster recovery strategy, export-import, replication
• Hands-on experience with operating high-uptime Databases in both AWS and On-premises environments
• Must have experience with performance management/measurement methods, tools, and techniques

Qualifications

Minimum Qualifications

• At least 8+ years of increasing responsibility Administering, Optimizing, and maintaining relational databases PostgreSQL and Oracle DB
• At least 8+ years of with SQL and Oracle PL/SQL utilizing Packages, Types, Objects, Triggers and Advanced Queuing utilizing Oracle version 19c and above
• to support web API and applications.
• Experience designing and implementing logical and physical database models, including indexes, primary keys, foreign keys, and constraints
• Proficiency in database management systems such as Oracle and PostgreSQL
• Strong SQL programming skills and experience with query optimization techniques
• Demonstrated skill of database operations, including backup strategy, data security and Cloud platform
• Proficiency in JSON and PostgreSQL support for JSON.
• Experience performing Extract, Transform, and Load (ETL) techniques
• Experience with AWS Cloud Database Technologies (DynamoDB, AWS CLI, EC2, EBS, S3, Lambda, Aurora, EMR, DMS data migration, Athena, Glue, Kinesis, SQS/SNS, etc.)
• Experience in Automation tools (Puppet, Ansible)
• Experience in Log Analysis, Database cloud observability/monitoring tools (Splunk, solar winds)
• Bachelor’s degree in Computer or Information technology.

Regards

Vinay S

vinay.s@themesoft.com

Job Tags

Similar Jobs