Database Administrator

As a PostgreSQL DBA (L2 & L3), you will be responsible for database administration tasks including installing, configuring, and managing PostgreSQL databases across different environments such as production, staging, and development. You should have experience working with PostgreSQL versions 11, 12, 13, 14, 15, and all other versions. Your role will involve implementing and managing backup strategies, WAL archiving, and Point-In-Time Recovery (PITR) to ensure data protection. You will be expected to utilize tools like EXPLAIN ANALYZE, tuning techniques, and indexing strategies to optimize query performance. Configuring and managing High Availability (HA) solutions such as Streaming Replication and Logical Replication will be part of your responsibilities to ensure the availability of HA clusters. Additionally, you will handle security aspects by managing roles, implementing SSL/TLS encryption, role-based access control (RBAC), auditing, and ensuring GDPR/security compliance. Troubleshooting database issues, analyzing logs, resolving deadlocks, replication lag, slow queries, and performance bottlenecks will be crucial tasks in your role. You will also be involved in developing automation scripts for maintenance and monitoring purposes. Supporting database design tasks like schema normalization, partitioning, and sharding for large-scale deployments will be expected from you. You will also play a key role in managing patch updates, minor/major version upgrades, and security patches with minimal downtime. Experience in managing PostgreSQL databases in both on-premises and cloud environments is essential. Collaborating with developers, DevOps teams, and system administrators to optimize database performance and reliability will also be part of your job. If you have 5-10 years of experience in PostgreSQL database administration and are looking for a challenging opportunity, this role based in Mumbai, Pune, Delhi, Kolkata, Hyderabad, or Bangalore might be the right fit for you. The notice period for this position is 0-45 days only.,