Location
Patna | India
Job description
Location - Patna , Bihar ( WFO ))
Profile - DBA Administration
Exp- 7 Yrs - 10 Yrs
Qualification - MCA
Mandatory - PostgreSQL , SQL, MYSQL
Key Responsibilities
- PostgreSQL Database DBA on Linux
- The job includes working with the various technology teams, vendors, and management of new hardware and operating systems infrastructure.
- Responsible for the installation, configuration database servers /Replication, Pgpool etc.
- Responsible for interacting with DB OEM team for raising tickets & get resolutions.
- Responsible for monitoring & maintaining database servers in Development, QA, Staging & Production environment.
- Atleast 7 years of experience as a DBA of PostgreSQL in production environment including backup recovery, replication, high availability, monitoring diagnosing and optimizing database performance.
- Ability to detect and troubleshoot database-related CPU, memory, IO, disk space, and other resourceÂ
- contention issues.
- Proficient with database tuning and use of PostgreSQL tools such as PgBadger, EDBs PgStatsPack, EDBs DRITA
- Proficient with PostgreSQL replication technologies Binary Streaming Replication, xDB Replication,Â
- Logical Replication
- Proficient with PostgreSQL networking, HBA and connection pooling (PgBouncer, PgPool)
- Knowledge of high availability, disaster recovery and replication solutions and best practices
- Demonstrated experience implementing deploying database servers.
- Expertise in writing SQL queries, analyzing query performance using query plans and tuning queryÂ
- performance.
- Database Performance Tuning and Optimization, using native monitoring and 3rd party tools.
- Strong communications skills and ability to document and present complex designs to a wider audience.
Job tags
Salary
