Job Description :
Job Title: PostgreSQL DBA

Location: Baltimore, MD

Duration: Multiyear

Position Summary:

The client is seeking a Senior Database Management Specialists to support them, provide highly technical expertise and support in the use of Database Management System (DBMS) and evaluate and recommend available DBMS products to support validated user requirements.

Duties and Responsibilities:

Perform PostgreSQL Server database administration, manage role based (RBAC) user accounts and system accounts, patch Management and maintain Replication/DR Environment.
Monitor all production database activity for operational improvements to include CPU, Disk and memory utilization, space utilization.
Monitor and manage PostgreSQL Enterprise Failover Manager (EFM
Perform Security infractions and overall performance of databases to develop and implement corrective measures for database issues/problems found during monitoring.
Analyze performance issues in the application and database tiers.
Perform disaster recovery principles and practices, including planning, testing backup/restore.
Maintain Replication/DR Environment of Postgres Hands on maintenance activities such as vacuum, full vacuum, analyze the PostgreSQL Database.
Perform database server maintenance, including upgrades of PostgreSQL Database, storage management of PostgreSQL and MongoDB.
Perform Installation and maintenance of MongoDB database for high availability.
Tune SQL queries for optimal performance on PostgreSQL, create and manage indices.
Tune No SQL queries on Mongo DB and create/manage indices.

Required Experience:

A minimum of six (6) years of experience in PostgreSQL Server database administration, patch management and maintenance of Replication/DR Environment
A minimum of four (4) years of experience monitoring all production database activity for operational improvements to include CPU, Disk, memory utilization, space utilization, security infractions and overall performance of databases.
A minimum of four (4) years of hands on experience with maintenance activities of PostgreSQL Database such as Vacuum, FullVacuum, analysis in production and lower environments.
A minimum of four (4) years of experience maintaining Replication/DR Environment of Postgres including patches and upgrades of PostgreSQL Database.
A minimum of four (4) years of experience in Installation and maintenance of MongoDB for high availability; designing MongoDB multi-shaded cluster and monitoring with Ops Manager.
A minimum of six (6) years of experience in installation, configuration of MS SQL Server 2008, 2008 R2, 2014 and 2016 on Windows 2008 R2 and 2012 R2 servers, applying patches, service packs, hot fixes.
A minimum of five (5) years of experience with providing enterprise database solutions and data warehouse management.
A minimum of five (5) years of experience in analyzing database entities, optimizing SQL queries, designing database models for web applications.
A minimum of five (5) years of experience in analyzing and optimizing stored procedures and custom database functions.
A minimum of three (3) years of experience in installing and configuring highly available PostgreSQL and MongoDB clusters with enterprise security such as, PAM authentication, Kerberos authentication, encrypted storage mechanism.

Education:

Bachelor’s Degree from an accredited college or university in Engineering, Computer Science, Information Systems, Business or other related Discipline. Master’s degree preferred.
             

Similar Jobs you may be interested in ..