Senior Database Administrator

Designation: Sr Database Administrator – PostgreSQL Admin (5 years)

Location: Bangalore (work from office) – 5 days

Key Responsibilities:

1. Database Administration: Manage monitor and maintain PostgreSQL database systems to ensure optimal performance reliability and security.

2. Performance Tuning: Proactively identify and address performance bottlenecks and optimize SQL queries and database configurations for improved efficiency.

3. Backup and Recovery: Develop and implement robust backup and recovery strategies to safeguard data integrity and minimize downtime in case of system failures.

4. High Availability and Disaster Recovery: Design implement and manage high availability (HA) and disaster recovery (DR) solutions such as replication clustering and failover mechanisms.

5. Security: Implement and enforce security policies and access controls to protect sensitive data against unauthorized access data breaches and other security threats.

6. Capacity Planning: Monitor database growth trends and plan for future capacity requirements by scaling resources and infrastructure as needed.

7. Automation and Scripting: Develop automation scripts and tools to streamline database administration tasks deployments and maintenance processes.

8. Database Upgrades and Patching: Plan and execute database upgrades patches and migrations in coordination with the development and operations teams to ensure minimal disruption to business operations.

9. Documentation: Maintain comprehensive documentation of database configurations procedures and best practices for reference and knowledge sharing.

10. Collaboration: Work closely with developers system administrators and other stakeholders to troubleshoot databaserelated issues provide technical guidance and support application development and deployment efforts.

Requirements:

.

Bachelor’s degree in Computer Science Information Technology or a related field (or equivalent experience).

.

Proven experience as a PostgreSQL Database Administrator or similar role in a production environment.

.

Indepth knowledge of PostgreSQL architecture configuration performance tuning and troubleshooting.

.

Proficiency in SQL and database query optimization techniques.

.

Experience with database backup and recovery solutions including pointintime recovery (PITR) and disaster recovery planning.

.

Familiarity with database security best practices and regulatory compliance requirements (e.g. GDPR HIPAA).

.

Strong scripting skills (e.g. Bash Python) for automation and task orchestration.

.

Experience with database migration replication clustering and high availability solutions (e.g. PostgreSQL replication Patroni PgpoolII).

.

Excellent communication and collaboration skills with the ability to work effectively in a crossfunctional team environment.

Preferred Qualifications:

.

PostgreSQL certification (e.g. PostgreSQL Certified Administrator) is must.

.

Experience with other database technologies (e.g. MySQL Oracle MongoDB) – Good to have

.

Knowledge of cloud platforms and database services (e.g. AWS RDS Google Cloud SQL Azure Database for PostgreSQL).

.

Familiarity with DevOps practices and tools (e.g. Docker Kubernetes Terraform).

.

Experience with performance monitoring and diagnostic tools (e.g. pgstatstatements pgBadger pgtop).