Senior Database Engineer

Overview

About the Job-

• Position: Senior Database Engineer
• Experience: 3 to 10 years
• Location: Sector 144, Noida
• Job Type: Full-time
• Work Mode: On-site / Hybrid

About the Role-

We are seeking an experienced and passionate Senior Database Engineer to join our technology team. The ideal candidate will have strong expertise in SQL development, PostgreSQL, and Python scripting to support data-intensive applications. The role requires designing and optimizing databases, building data pipelines, and ensuring seamless migration of customer data into new product hosted on AWS cloud.

Key Responsibilities-

• Design, implement, and optimize PostgreSQL databases for scalability, security, and performance.
• Develop and maintain complex SQL queries, procedures, views, and triggers to support application requirements.
• Write Python or sql scripts for database automation, ETL processes, and data validation.
• Collaborate with product, engineering, and DevOps teams to define database strategies and data models.
• Support data migration activities, including mapping, transformation, and validation of legacy data to new portals/products.
• Ensure high availability, backup/recovery, and disaster recovery strategies for database environments.
• Monitor and tune performance using database metrics, indexing strategies, and query optimization.
• Deploy and manage databases in AWS environments (postgres, S3, etc.).
• Ensure compliance with security, privacy, and regulatory standards in handling sensitive data.

Required Qualifications-

• Bachelors or Masters degree in Computer Science, Information Systems, or related field.
• 3 to 10 years of professional experience as a Database Engineer/Administrator/Developer.
• Strong knowledge of SQL (PostgreSQL preferred) with proven ability to optimize queries and schema design.
• Hands-on experience with Python for database scripting and automation.
• Good understanding of data modeling, normalization, and relational database design principles.
• Experience in performance tuning (indexes, partitions, query optimization).
• Exposure to AWS database services (RDS for PostgreSQL, EC2, S3, IAM, and VPC.).

Nice to Have-

• Experience in data migration projects, especially migrating existing customers to new portals/products.
• Familiarity with ETL tools and frameworks (e.g., Airflow, AWS Glue, dbt).
• Understanding of NoSQL databases (MongoDB, DynamoDB) as a complement to relational systems.
• Knowledge of DevOps practices for CI/CD integration of database changes.
• Experience with database monitoring tools like Prometheus, Grafana, or Datadog.