DBA Lead Engineer

We are seeking a highly skilled MS SQL Database Developer and Administrator to design, implement, and manage our enterprise-grade database systems for a new data modernization project.
The ideal candidate will have end-to-end expertise in Microsoft SQL Server (on-prem and Azure), data warehouse design, data lake integration, and NoSQL databases such as Cosmos DB and MongoDB.
This role demands strong database development, optimization, and administration capabilities, as well as hands-on experience with Azure cloud data services.

Key Responsibilities:

Database Design & Development

• Design and implement MS SQL Server databases (on-premises and Azure SQL Database).
• Develop optimized stored procedures, functions, triggers, and views following best practices.
• Design and maintain database schemas, tables, indexes, and constraints to support application and analytics needs.
• Build and optimize data warehouses and data marts using dimensional modeling (star/snowflake schema).
• Develop ETL/ELT pipelines using Azure Data Factory, SSIS, or equivalent tools.
• Integrate and manage data across Azure Data Lake, Cosmos DB, and MongoDB environments.
• Implement data ingestion, transformation, and synchronization across relational and NoSQL systems.
• Create and maintain automation scripts for database deployment and schema management (CI/CD pipelines).

Database Administration & Operations

• Install, configure, and maintain SQL Server instances (on-premises and cloud).
• Perform query tuning, index optimization, and database performance troubleshooting.
• Manage backup, restore, replication, and high availability configurations (AlwaysOn, Failover Clustering).
• Ensure database security, access management, and compliance with policies (encryption, data masking, auditing).
• Plan and execute database upgrades and migrations from on-prem to Azure.
• Monitor and optimize Azure SQL, Cosmos DB, and MongoDB performance and cost efficiency.
• Develop maintenance plans, monitoring scripts, and alerting mechanisms.

Data Lake, Cloud, and NoSQL Integration

• Integrate structured and semi-structured data between SQL databases, Data Lakes, and NoSQL systems.
• Design and implement data pipelines using Azure Data Factory, Azure Synapse, and Databricks (optional).
• Work with Cosmos DB (SQL API, Mongo API, or Table API) for scalable cloud-native data storage.
• Manage MongoDB clusters, sharding, replication, and schema design for application data.
• Ensure data consistency, latency management, and partitioning strategies across hybrid data stores.

Collaboration & Best Practices

• Collaborate with data engineers, architects, and developers to design efficient data solutions.
• Define and enforce database development standards, naming conventions, and security guidelines.
• Participate in code reviews, architecture planning, and data modeling discussions.
• Provide technical guidance and mentorship to junior developers.
• Contribute to project estimation, capacity planning, and architecture documentation.

Preferred Skills (Good to Have):

• Familiarity with Databricks, Delta Lake, or Synapse Pipelines.
• Experience with Power BI or other BI visualization tools.
• Understanding of data governance, security, and compliance frameworks (GDPR, HIPAA, etc.).
• Experience with DevOps and Infrastructure-as-Code (ARM Templates, Terraform).
• Microsoft Certifications:
  • Azure Database Administrator Associate
  • Data Engineer Associate
  • Azure Solutions Architect Expert

• Strong expertise in Microsoft SQL Server 2016/2019/2022 and Azure SQL Database.
• Proficiency in T-SQL programming (queries, stored procedures, functions, triggers, views).
• Solid experience in data modeling, index design, and query performance tuning.
• Hands-on experience with Azure Data Factory, Azure Data Lake Storage, and Synapse Analytics.
• Expertise in NoSQL databases – particularly Azure Cosmos DB and MongoDB (including schema design, indexing, and querying).
• Working knowledge of data warehouse concepts and ETL frameworks.
• Familiarity with CI/CD pipelines for database deployments (Git, Azure DevOps, Jenkins).
• Experience with backup and disaster recovery strategies.
• Knowledge of JSON, XML, and API-based data exchange.
• Experience with PowerShell, Python, or Azure CLI for automation (optional but preferred).