Jobgether
Senior Database Consultant (PostgreSQL)
Accountabilities
- 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.
- Contribute to process improvements, tooling enhancements, and documentation for better service delivery and operational efficiency.
- 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; relevant certifications are a plus.
- Fully remote work with flexibility to operate from anywhere in India.
- Competitive compensation package aligned with experience and expertise.
- Comprehensive health, medical, and wellness support programs.
- Annual training budget and access to professional certifications and learning resources.
- Home office setup support, including equipment and workspace allowance.
- Paid vacation, sick leave, and additional wellness days.
- Opportunities to work on large-scale, global enterprise database environments.
- Strong culture of technical excellence, collaboration, and continuous learning.
Requirements
Benefits
How Jobgether works:
We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team.
We appreciate your interest and wish you the best!
Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.
#LI-CL1
Jobgether runs the largest remote job platform, effectively linking job seekers with over 200,000 flexible and remote opportunities that match their unique skills and preferences. Our focus is on enhancing the hiring process, ensuring efficiency while prioritizing the candidate experience, particularly in the growing health and wellness sector.
- Founded
- Founded 2020
- Employees
- 11-50 employees
- Industry
- Professional Services
Consultant