Job Description

Designation: Sr Database Administrator \xe2\x80\x93 PostgreSQL Admin (5+ years)Location: Bangalore (work from office) \xe2\x80\x93 5 daysKey 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 database-related issues, provide technical guidance, and support application development and deployment efforts.Requirements:\xc2\xb7 Bachelor\xe2\x80\x99s degree in Computer Science, Information Technology, or a related field (or equivalent experience).\xc2\xb7 Proven experience as a PostgreSQL Database Administrator or similar role in a production environment.\xc2\xb7 In-depth knowledge of PostgreSQL architecture, configuration, performance tuning, and troubleshooting.\xc2\xb7 Proficiency in SQL and database query optimization techniques.\xc2\xb7 Experience with database backup and recovery solutions, including point-in-time recovery (PITR) and disaster recovery planning.\xc2\xb7 Familiarity with database security best practices and regulatory compliance requirements (e.g., GDPR, HIPAA).\xc2\xb7 Strong scripting skills (e.g., Bash, Python) for automation and task orchestration.\xc2\xb7 Experience with database migration, replication, clustering, and high availability solutions (e.g., PostgreSQL replication, Patroni, Pgpool-II).\xc2\xb7 Excellent communication and collaboration skills, with the ability to work effectively in a cross-functional team environment.Preferred Qualifications:\xc2\xb7 PostgreSQL certification (e.g., PostgreSQL Certified Administrator) is must.\xc2\xb7 Experience with other database technologies (e.g., MySQL, Oracle, MongoDB) \xe2\x80\x93 Good to have\xc2\xb7 Knowledge of cloud platforms and database services (e.g., AWS RDS, Google Cloud SQL, Azure Database for PostgreSQL).\xc2\xb7 Familiarity with DevOps practices and tools (e.g., Docker, Kubernetes, Terraform).\xc2\xb7 Experience with performance monitoring and diagnostic tools (e.g., pg_stat_statements, pgBadger, pg_top).

Recruiter Wings Consultancy