Senior Database Developer

Entire It Design; Sector 10; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

Entire It Design in Noida (Hybrid) seeks an experienced Senior Database Developer to design, develop, optimize and maintain mission-critical SQL Server and PostgreSQL databases for enterprise SaaS apps.

You will lead data migration, ETL, and tooling efforts, ensure data integrity across multi-tenant environments, and collaborate with架olution Architect, DevOps, and Frontend/Backend teams to align database design with platform goals. Strong English communication is essential.

Qualifications

• 8-10 years of database development/administration.
• Hands-on production-grade experience as a senior database developer with ownership of mission-critical databases.
• Expert SQL Server scripting, querying, and stored procedures development and optimization.
• Expert PostgreSQL query writing, performance tuning, and administration.
• Experience with large-scale data migration across multiple source systems.

Responsibilities

• Write, optimize, and maintain complex SQL scripts, queries, and stored procedures across SQL Server and PostgreSQL.
• Lead ETL activities across multiple SQL Server databases with data partners and QA teams.
• Design and maintain import templates and reusable extraction scripts for client onboarding.
• Investigate and resolve data integrity and production issues across multi-tenant environments.
• Perform health checks, performance audits, and query optimization to resolve bottlenecks.
• Document schemas, procedures, and data flows for knowledge sharing.
• Collaborate with Solution Architect, DevOps, and Full Stack teams on database design alignment.
• Act as technical escalation point for complex database issues and guide best practices.
• Manage maintenance activities including performance tuning, indexing, security, access control.

Skills

SQL scripting

Database design

Performance tuning

Data migration

Multi-tenant databases

English communication

Tools

SQL Server

PostgreSQL

ETL

Version control

AWS RDS

Job description

Position: Senior Database Developer

Employment Type: Full-Time, Permanent

Experience: 8-10 Years

Location: Noida (Hybrid)

Work Timings: 7:00 AM to 3:30 PM IST

Role Overview

We are seeking an experienced Senior Database Developer to design, develop, optimize and maintain mission-critical SQL Server and PostgreSQL databases supporting enterprise SaaS applications.

Key Responsibilities

• Write, optimize, and maintain complex SQL scripts, queries, and stored procedures across both SQL Server (preferred) and PostgreSQL environments.
• Lead data migration, extraction, transformation, and loading (ETL) activities across multiple SQL Server databases while collaborating with data partners and QA teams.
• Design and maintain customized database import templates and reusable extraction scripts to support client onboarding, reducing reliance on one-off manual scripting.
• Investigate and resolve data integrity and production issues, including deduplication, data consistency across multi-tenant environments, and root cause analysis.
• Perform regular database health checks, performance audits, and query optimization to proactively identify and resolve bottlenecks.
• Document database schemas, stored procedures, and data flows to support knowledge sharing and maintain technical documentation.
• Collaborate with the Solution Architect, DevOps, and Full Stack Development teams to align database design with overall platform architecture.
• Act as the technical escalation point for complex database issues and provide guidance on database best practices.
• Manage database maintenance activities, including performance tuning, indexing strategy, security, access control, and capacity planning.

Required Experience & Skills

• 8-10 years of database development/administration.
• Significant hands-on, production-grade experience as a Database Developer senior level, with demonstrated ownership of mission-critical database systems.
• Expert-level proficiency writing complex SQL Server scripts, queries, and stored procedures able to design, optimise, and troubleshoot at an advanced level without supervision.
• Expert-level proficiency with PostgreSQL query writing, performance tuning, and administration, equivalent in depth to SQL Server expertise.
• Proven experience with large-scale data migration projects extraction, transformation, and loading (ETL) across multiple source systems into a target platform.
• Strong understanding of data integrity principles deduplication logic, referential integrity, and data validation methodology.
• Experience working with multi-tenant or multi-client database architectures, with clear separation of client data.
• Familiarity with version control for database change management (migration scripts, schema versioning).
• Strong written and verbal English communication skills this role works directly with Australian product, architecture, and engineering leadership.
• Demonstrated ability to work independently, take ownership of ambiguous data problems, and escal risk clearly and early.

Information Security Responsibilities (SOC 2)

• Comply with the organization's Information Security and Acceptable Use policies.
• Protect confidential, customer, and company information by following data classification and handling requirements.
• Implement and maintain least-privilege database access controls.
• Ensure secure database configurations, encryption, backup, and recovery practices.
• Promptly report information security incidents, vulnerabilities, or suspected breaches.
• Support security audits and compliance activities by maintaining accurate documentation.
• Follow secure change management practices for database deployments and schema changes.
• Ensure database activities comply with applicable legal, regulatory, and company requirements.

Preferred Experience

• Prior experience in workforce management, staffing/recruitment, payroll, or other compliance-heavy SaaS domains.
• Experience supporting legacy framework migrations (e.g. .NET version upgrades) from a database compatibility perspective.
• Experience working with containerized database deployments or cloud-hosted database infrastructure (AWS RDS or equivalent).
• Exposure to payroll or workforce management software

What Success Looks Like

• Successfully deliver complex database migration projects with high data accuracy, quality, and adherence to project timelines.
• Ensure business continuity by establishing well-documented, repeatable database processes and eliminating single points of failure.
• Maintain stable, secure, and high-performing SQL Server and PostgreSQL environments through proactive monitoring and performance optimization.
• Build strong collaboration with the Solution Architect, DevOps, and Engineering teams, communicating database risks, technical challenges, and effective solutions.

Why Join Us?

• Product-based SaaS company serving international markets
• Work directly with Australian engineering and product teams
• Modern cloud-based database environment
• Opportunity to lead SQL Server to PostgreSQL migration initiatives
• Hybrid work model (2 WFH + 3 WFO)