Senior Database Engineer

About Us

Senior Database Engineer

client projects

Key Responsibilities

• Design, implement, and manage database solutions using

  PostgreSQL

  (primary) and optionally

  MySQL

  .
• Support one or more

  client projects

  , tailoring solutions to unique data and performance needs.
• Optimize performance through indexing, partitioning, query tuning, and sharding strategies.
• Plan and execute

  database upgrades, migrations, and version transitions

  with minimal downtime.
• Implement and monitor

  backup, recovery, and disaster recovery

  strategies.
• Ensure

  data security, availability

  , and

  compliance

  with client-specific policies and regulations.
• Develop and maintain

  comprehensive documentation

  —schemas, data models, stored procedures, and operational guides.
• Use monitoring and observability tools (e.g., pg_stat_statements, pgBadger, Prometheus, Grafana) to detect and resolve performance issues.
• Automate repetitive maintenance and monitoring tasks using scripting or DevOps tooling.
• Collaborate with client-side stakeholders when needed to propose data solutions and address performance concerns.
• Work with DevOps teams to integrate database changes into

  CI/CD pipelines

  using tools like Flyway or Liquibase.
• Provide mentorship and guidance to junior database engineers and backend developers.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.

• 5+ years

  of experience in database engineering, with strong, proven expertise in

  PostgreSQL

  (required).
• Experience with

  MySQL

  is a bonus.
• Hands-on knowledge of

  indexing, partitioning, query tuning, and sharding

  techniques.
• Experience with

  database upgrades

  , cross-version

  migrations

  , and

  live data transitions

  .
• Deep understanding of

  data integrity

  ,

  security

  , and

  replication

  strategies.
• Strong problem-solving skills with the ability to troubleshoot complex database performance issues.
• Experience working in

  client-facing

  or

  multi-project environments

  is a plus.
• Familiarity with observability tools (e.g., pg_stat_statements, New Relic, Prometheus) and automation via scripting.
• Experience with

  cloud-based DB services

  (e.g., AWS RDS/Aurora, GCP Cloud SQL) is a plus.
• Relevant certifications in PostgreSQL, MySQL, or cloud platforms are a plus.
• Awareness of data compliance standards (e.g., GDPR, HIPAA, SOC2) is an added advantage.