Key skills
Microsoft SQL ServerAzure SQL DatabaseT-SQLStored proceduresIndexing strategiesData modelingNormalizationDenormalizationPerformance tuningQuery optimizationAzure MonitorSQL ProfilerQuery StoreBackup and recoveryDisaster recoveryTable partitioningData stripingETL pipelinesELT pipelinesAzure Data FactorySSISHigh availabilityFailover clusteringPythonSQLPowerShellETLELTData WarehousingAnalyticsBIPower BIAzureAzure SQLSQL ServerPerformance OptimizationCI/CD
About this role
Dice is seeking a Database Engineer specializing in Azure and on-premises solutions. The role involves designing both OLTP and OLAP database architectures while ensuring performance optimization and maintenance of database systems.
Responsibilities:
- Designing both OLTP and OLAP database architectures
- Develop normalized database schemas (1NF through BCNF) to eliminate redundancy and ensure data integrity
- Apply denormalization techniques when appropriate to optimize read performance for analytics and reporting
- Collaborate with development and analytics teams to translate business requirements into efficient logical and physical models
- Monitor and tune database performance through indexing, query optimization, and resource utilization management
- Implement proactive monitoring using tools such as Azure Monitor, SQL Profiler, or Query Store
- Maintain efficient backup, recovery, and disaster recovery procedures
- Demonstrated experience in data normalization and relational schema design
- Table partitioning and data striping implementation
- Performance tuning and query optimization for large-scale data systems
- Hands-on experience with ETL/ELT pipelines and Azure Data Factory or SSIS
- Familiarity with high availability, failover clustering, and disaster recovery techniques
Requirements:
- Designing both OLTP and OLAP database architectures
- Bachelor s degree in computer science or a related technical field
- Minimum of 4 years of experience as a Database Engineer, Database Administrator, or equivalent technical role
- Proven proficiency in Microsoft SQL Server (2016 or newer) and Azure SQL Database
- Strong command of T-SQL, stored procedures, views, and indexing strategies
- Develop normalized database schemas (1NF through BCNF) to eliminate redundancy and ensure data integrity
- Apply denormalization techniques when appropriate to optimize read performance for analytics and reporting
- Collaborate with development and analytics teams to translate business requirements into efficient logical and physical models
- Monitor and tune database performance through indexing, query optimization, and resource utilization management
- Implement proactive monitoring using tools such as Azure Monitor, SQL Profiler, or Query Store
- Maintain efficient backup, recovery, and disaster recovery procedures
- Demonstrated experience in data normalization and relational schema design
- Table partitioning and data striping implementation
- Performance tuning and query optimization for large-scale data systems
- Hands-on experience with ETL/ELT pipelines and Azure Data Factory or SSIS
- Familiarity with high availability, failover clustering, and disaster recovery techniques
- Knowledge of data warehousing, dimensional modeling, and BI integration (Power BI, SSAS)
- Exposure to DevOps and CI/CD pipelines for database deployments
- Scripting experience using PowerShell, Python, or similar languages
- Knowledge of MISMO is a plus