Database Administrator - PostgreSQL (4-6 yrs)

Job Description - Database Administrator (DBA)

Responsibilities :

Please note that we require Database Administrators.

Experience : 4+ years

Remote

- Diagnose and resolve database-related issues, including performance bottlenecks, connectivity problems, and data inconsistencies. Collaborate with cross-functional teams to address and prevent recurring issues.

- Analyze and optimize database performance by fine-tuning queries, indexing, and configuration settings. Implement best practices to enhance system efficiency.

- Administer, maintain, and monitor multiple database environments, ensuring data integrity, security, and high availability.

- Collaborate with the DevOps team to automate database provisioning, deployments, and monitoring. Implement CI/CD pipelines for database changes.

- Implement and enforce security policies, access controls, and encryption mechanisms to protect sensitive data. Ensure compliance with industry standards and regulations.

- Create and maintain comprehensive documentation for database configurations, procedures, and troubleshooting guides.

- Work closely with developers, system administrators, and other IT professionals to support application development and infrastructure initiatives.

Technical Skills :

- Excellent communication skills and collaborative approach

- Strong proficiency in PostgreSQL database administration and management.

- Proficient in End-to-end database migrations from on-prem to public cloud preferably GCP.

- Should be able to lead the migrations and share the knowledge with the team members.

- Proficient in Postgres database performance tuning.

- Perform heterogeneous migrations ( from Oracle to Postgres/ MySQL to Postgres)

- Develop Stored procedures, load balancing, and High Availability.

- Proficient in backup and recovery in Community and EDB Postgres

- Primary core competency is PostgreSQL database with a mix of other Oracle and MySQL as secondary.

- Through understanding of database design, performance tuning, and optimization techniques.

- Proficient in troubleshooting and solving complex performance problems.

- Experience managing operations on core and cloud-based infra environments.

- Investigate and troubleshoot database-related issues, including connectivity problems, performance degradation, and data inconsistencies.

- Provide timely resolution and root cause analysis for the Incidents.

- Generate comprehensive documentation supporting database issues arising from customer queries.

- Good knowledge of EDB database tools like Barman, EFM, etc.