Job Description :
Description:
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.
Note: The candidate must have the flexibility to work overtime, as needed, to include weekends, holidays, and off-hours.
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, Full Vacuum, 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 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 clusters with enterprise security such as, PAM authentication, Kerberos authentication, encrypted storage mechanism.
A minimum of four (4) years of experience in developing and implementing best practices for database issues/problems found during performance tuning of PostgreSQL DB
A minimum of four (4) years of experience in disaster recovery principles and practices, including planning and validating backup and restore database backups in production and lower environments.
A minimum of four (4) years of experience implementing efficient disaster prevention and Recovery Strategies and High availability like Database Backup and Restore, Database Snapshot, Log shipping, Clustering and Database Mirroring for PostgreSQL.
A minimum of five (5) years of experience working with the PMO processes, policies and procedures.
A minimum of three (3) years of experience in managing enterprise RDBMS and NoSQL databases on cloud platforms such as Amazon Web Services (AWS