Job Description

Mallow Technologies is dedicated to leveraging web and mobile technologies to build impactful digital solutions. As part of our growing backend and infrastructure team, we are looking for a

Senior Database Engineer

who will work across one or more

client projects

to ensure database systems are scalable, secure, and highly performant. If you're passionate about databases and eager to take ownership in a fast-paced, client-driven environment, we'd love to talk to you.

As a Senior Database Engineer, you'll play a key role in designing, optimizing, and managing database infrastructure, primarily for

client projects

. The role requires

deep hands-on expertise in PostgreSQL

and a solid foundation in database architecture and performance tuning. Experience with

MySQL

is a bonus. You'll work closely with product, engineering, and DevOps teams to ensure database reliability, scalability, and compliance across client engagements.

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.
Job Types: Full-time, Permanent

Pay: ₹1,000,000.00 - ₹1,600,000.00 per year

Benefits:

Cell phone reimbursement Flexible schedule Health insurance Internet reimbursement Provident Fund
Language:

English (Preferred)
Work Location: In person