Senior Database Consultant (PostgreSQL)
New
Fully remote work with flexibility to operate from anywhere in India.Full-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 5+ years
- Required Skills
- AWSPostgreSQLPythonBashGCPAzureTerraformAnsible
Requirements
- 5+ years of experience in database administration or consulting, with strong hands-on expertise in PostgreSQL.
- Proven experience managing PostgreSQL in cloud environments such as AWS, GCP, or Azure.
- Strong knowledge of high availability and replication solutions (e.g., Patroni, repmgr) and disaster recovery strategies.
- Experience with backup and recovery tools such as pgBackRest, Barman, and pg_basebackup, including PITR and WAL archiving.
- Strong scripting skills in Bash and/or Python, with exposure to automation and infrastructure tools like Ansible, Terraform, Puppet, or Chef.
- Experience with database monitoring and observability tools such as Prometheus, Grafana, Datadog, or similar platforms.
- Hands-on experience with database migration projects across major engines and cloud platforms.
- Strong debugging and troubleshooting skills with the ability to resolve complex production issues.
- Excellent documentation, communication, and client-facing consulting skills.
- Bachelor’s degree in Computer Science, IT, or a related field.
Responsibilities
- Design, implement, configure, and maintain PostgreSQL database solutions across on-premises, cloud, and hybrid environments, ensuring high availability and performance.
- Lead database architecture efforts including data modeling, schema design, migration planning, and performance optimization.
- Manage backup, recovery, replication, clustering, and disaster recovery strategies to ensure data integrity and system resilience.
- Monitor database health, troubleshoot incidents, and proactively resolve performance or reliability issues using observability tools.
- Develop and maintain automation scripts and infrastructure-as-code solutions using tools such as Bash, Python, Ansible, or Terraform.
- Support database migrations from legacy systems (Oracle, MySQL, MSSQL) to PostgreSQL with minimal downtime and strong validation processes.
- Collaborate with clients to define requirements, provide recommendations, and ensure alignment with best practices and operational standards.
- Participate in on-call rotations and ensure timely resolution of production issues affecting critical systems.
View Full Description & ApplyYou'll be redirected to the employer's site
