Responsibilities:

• Define canonical data models, normalization/denormalization strategy, and standards for OLTP and OLAP systems.
• Design schemas, partitioning, indexing, and storage strategies to ensure scalability, maintainability, and performance.
• Lead query tuning, execution plan analysis, and workload management for mission-critical environments.
• Architect and implement High Availability (HA) and Disaster Recovery (DR) solutions including clustering, Always On/AGs, replication, log shipping, and backup/restore strategies aligned with RPO/RTO objectives.
• Establish robust security frameworks—RBAC, row/column-level security, encryption (TDE/at-rest/in-transit), auditing, data masking, and compliance controls.
• Define data retention, archiving, and lifecycle policies across environments.
• Architect and manage cloud database services (Azure SQL/MI, AWS RDS/Aurora, GCP Cloud SQL/Spanner) and hybrid deployments.
• Optimize database costs through right-sizing, tiering, and IaC automation (Terraform/Bicep/CloudFormation).
• Collaborate with data engineering teams on ETL/ELT patterns (SSIS, ADF, Databricks, Airflow, Fivetran), CDC, and real-time streaming ingestion.
• Support semantic layers, views, materialized views, and data marts for BI and analytics.
• Define and enforce coding standards, naming conventions, and migration/versioning practices (Flyway/Liquibase).
• Mentor DBAs and data engineers; conduct design reviews and guide performance optimization.
• Troubleshoot Sev-1 production incidents, ensuring stability and timely resolution.
• Implement monitoring and alerting (Query Store, Extended Events, pg_stat_*, CloudWatch, Log Analytics) and lead capacity planning and SLO management.

Technical Requirements

• 5–7+ years of hands-on experience with enterprise RDBMS (SQL Server, PostgreSQL, or Oracle).
• 3+ years in a lead or architect role with demonstrated ownership of database design and governance.
• Expert in SQL and query optimization, with strong understanding of execution plans, indexing, partitioning, and concurrency/locking.
• Proven experience designing HA/DR architectures, backup/restore strategies, and resolving complex performance issues at scale.
• Strong knowledge of security architecture (RBAC, encryption, auditing) and regulatory compliance (GDPR, PCI, HIPAA).
• Hands-on experience with major cloud data platforms (Azure, AWS, GCP).
• Familiarity with Infrastructure as Code (IaC) tools such as Terraform, Bicep, or CloudFormation.
• Experience with ETL/ELT orchestration tools (SSIS, ADF, Databricks, Airflow, Fivetran).
• Proficiency in monitoring and observability tools (Query Store, Extended Events, CloudWatch, Log Analytics).
• Skilled in establishing database CI/CD pipelines, code review, and release/versioning processes.

Non-Technical Requirements

• Strong leadership and mentorship skills with a proven ability to guide and upskill technical teams.
• Excellent analytical thinking and problem-solving capabilities under pressure.
• Effective communication skills—able to translate complex technical issues for non-technical stakeholders.
• High degree of ownership, accountability, and attention to detail.
• Strong collaboration mindset with experience partnering across product, data engineering, and DevOps teams.
• Strategic thinking to align data architecture with long-term business goals.
• Commitment to continuous improvement, innovation, and standards-driven engineering culture.