PostgreSQL

As a PostgreSQL DBA (L2 & L3), your primary responsibilities will include: - Installing, configuring, and managing PostgreSQL databases (versions 11, 12, 13, 14, 15/All Versions) in production, staging, and development environments. - Implementing and managing backup, WAL archiving, and PITR (Point-In-Time Recovery) for data protection. - Utilizing EXPLAIN ANALYZE, tuning, and indexing strategies for query optimization. - Configuring and managing Streaming Replication, Logical Replication for HA clusters to ensure High Availability. - Managing roles, implementing SSL/TLS encryption, role-based access control (RBAC), auditing, and GDPR/security compliance for security and compliance. - Analyzing logs, resolving deadlocks, replication lag, slow queries, and performance bottlenecks for troubleshooting and issue resolution. - Developing automation scripts for maintenance and monitoring tasks to enhance efficiency. - Supporting schema normalization, partitioning, and sharding for large-scale deployments in Database Design & Capacity Planning. - Applying PostgreSQL minor/major version upgrades and security patches with minimal downtime in Patch Management & Version Upgrades. - Managing PostgreSQL databases in on-premises/Cloud environments for Cloud & Hybrid Database Management. - Collaborating with developers, DevOps, and system administrators to optimize database performance and reliability in Cross-Team Collaboration. Qualifications required for this role: - 5-10 years of experience in PostgreSQL database administration. - Strong expertise in PostgreSQL versions 11, 12, 13, 14, 15/All Versions. - Proficiency in performance tuning, optimization, and troubleshooting techniques. - Experience in High Availability (HA) setup, replication, and security implementations. - Ability to work collaboratively with cross-functional teams for database management and optimization. (Note: No additional details about the company were provided in the job description.) As a PostgreSQL DBA (L2 & L3), your primary responsibilities will include: - Installing, configuring, and managing PostgreSQL databases (versions 11, 12, 13, 14, 15/All Versions) in production, staging, and development environments. - Implementing and managing backup, WAL archiving, and PITR (Point-In-Time Recovery) for data protection. - Utilizing EXPLAIN ANALYZE, tuning, and indexing strategies for query optimization. - Configuring and managing Streaming Replication, Logical Replication for HA clusters to ensure High Availability. - Managing roles, implementing SSL/TLS encryption, role-based access control (RBAC), auditing, and GDPR/security compliance for security and compliance. - Analyzing logs, resolving deadlocks, replication lag, slow queries, and performance bottlenecks for troubleshooting and issue resolution. - Developing automation scripts for maintenance and monitoring tasks to enhance efficiency. - Supporting schema normalization, partitioning, and sharding for large-scale deployments in Database Design & Capacity Planning. - Applying PostgreSQL minor/major version upgrades and security patches with minimal downtime in Patch Management & Version Upgrades. - Managing PostgreSQL databases in on-premises/Cloud environments for Cloud & Hybrid Database Management. - Collaborating with developers, DevOps, and system administrators to optimize database performance and reliability in Cross-Team Collaboration. Qualifications required for this role: - 5-10 years of experience in PostgreSQL database administration. - Strong expertise in PostgreSQL versions 11, 12, 13, 14, 15/All Versions. - Proficiency in performance tuning, optimization, and troubleshooting techniques. - Experience in High Availability (HA) setup, replication, and security implementations. - Ability to work collaboratively with cross-functional teams for database management and optimization. (Note: No additional details about the company were provided in the job description.)