Job Requirements
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
Work Experience
- 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).
