Lead Database Administrator REMOTE

Overview

Job Position : Lead Database Administrator

Job Location : Remote

Duration : 12-month contract

Job Description :

Performs all Postgres and Oracle Database Administration-related activities for major ETS projects independently with minimal supervision.

Responsibilities :

Participates in projects as assigned providing expertise related to Cloud Database Architecture (AWS or Azure). Analyzes database and information needs of projects and applications in order to recommend and implement cost-effective solutions.

Conduct systems design, feasibility, and cost studies and recommend cost-effective cloud-native solutions.

Develop standardized machine images and Cloud formation automation scripts for building non-prod and prod environments on AWS.

Experience in managing, maintaining, patching, upgrading, and ensuring operational continuity of both Postgres and Oracle Databases and associated components using the following products : Pegol Cluster, Postgres tools, Oracle Enterprise Manager, Data Guard, RMAN

Must have good UNIX, Linux knowledge and scripting skills

Schedules and coordinates database maintenance activities.

Strong capability and ability to resolve highly technical and complex database and infrastructure-related issues on their own before they impact production and the ETS business.

Provides technical expertise to the development of solutions for such items as DBMS tools and utility usage, database administration, backup and recovery, database performance tuning, and monitoring.

Ability to influence development organizations to comply with database best practices and database standards and practices.

Trouble-shoots database and / or software problems as they apply to design implementation or installation activities.

Performs database migrations, upgrades, and structure migrations.

Participates in 7×24 on-call, overnight off-hour production problem resolution activities as needed in the rotation.

Knowledge, Skills, and Abilities :

Must have experience supporting Postgres and Oracle Databases.

Must have experience with administration of Databases on AWS Cloud using RDS and / or EC2.

PostgreSQL Database Administrator in versions 9.x and 12.x with Postgres Advanced Server using Enterprise Manager and SQL analyzer.

Demonstrate recent, professional exposure to support alternate RDBMS database flavors like MS SQL SERVER, Aurora, & NoSQL.

7-10 years of experience, with at least the last 5-7 years as Lead DBA on all aspects of Postgres and Oracle Database Administration in a large / challenging database environment.

Experience with automation tools (Ansible, Jenkins) & container technologies (Docker, CoreOS) is a big plus and desired.

Experience supporting internet / web-based database applications with heavy concurrent user volume.

Education :

The contractor should have a bachelor’s degree or master’s in Computer Science or 7 to 10 years of related experience in IT or a related field