Database Engineer (Azure & On-Premises)
Posted Today by Source Code Technologies LLC
Negotiable
Undetermined
Remote
Remote
Summary: The Database Engineer (Azure & On-Premises) is responsible for designing and maintaining OLTP and OLAP database architectures, requiring expertise in data modeling and performance optimization. The role demands a strong background in Microsoft SQL Server and Azure SQL Database, along with proficiency in T-SQL and stored procedures. The ideal candidate will collaborate with development and analytics teams to ensure data integrity and optimize database performance. This position is fully remote, allowing for flexible work arrangements.
Key Responsibilities:
- Develop normalized database schemas to ensure data integrity and eliminate redundancy
- Optimize database performance through indexing and query optimization
- Maintain efficient backup, recovery, and disaster recovery procedures
- Collaborate with development and analytics teams to translate business requirements into logical and physical models
- Implement ETL/ELT pipelines and monitor data integration processes
- Ensure high availability and failover clustering for database systems
Key Skills:
- Bachelor's degree in computer science or related field
- Minimum of 4 years of experience as a Database Engineer or Administrator
- Proficiency in Microsoft SQL Server and Azure SQL Database
- Strong command of T-SQL, stored procedures, and indexing strategies
- Experience with data modeling, normalization, and relational schema design
- Hands-on experience with ETL/ELT pipelines and Azure Data Factory or SSIS
- Knowledge of high availability, failover clustering, and disaster recovery techniques
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Position Title: Database Engineer (Azure & On-Premises) - Remote
Introduction
The Database Engineer (Azure & On-Premises) will be responsible for designing and maintaining both OLTP and OLAP database architectures. This role will require expertise in data modeling, database performance optimization, and maintenance. The ideal candidate will have a strong background in Microsoft SQL Server and Azure SQL Database, as well as experience with T-SQL, stored procedures, and indexing strategies.
Responsibilities
- Develop normalized database schemas to ensure data integrity and eliminate redundancy
- Optimize database performance through indexing and query optimization
- Maintain efficient backup, recovery, and disaster recovery procedures
- Collaborate with development and analytics teams to translate business requirements into logical and physical models
- Implement ETL/ELT pipelines and monitor data integration processes
- Ensure high availability and failover clustering for database systems
Requirements
Required Skills
- Bachelor''s degree in computer science or related field
- Minimum of 4 years of experience as a Database Engineer or Administrator
- Proficiency in Microsoft SQL Server and Azure SQL Database
- Strong command of T-SQL, stored procedures, and indexing strategies
- Experience with data modeling, normalization, and relational schema design
- Hands-on experience with ETL/ELT pipelines and Azure Data Factory or SSIS
- Knowledge of high availability, failover clustering, and disaster recovery techniques
Preferred Skills
- Knowledge of data warehousing, dimensional modeling, and BI integration
- Exposure to DevOps and CI/CD pipelines for database deployments
- Scripting experience using PowerShell, Python, or similar languages
- Knowledge of MISMO is a plus
Core Competencies
- Strong analytical and problem-solving skills
- Exceptional attention to detail and data accuracy
- Ability to work independently and manage multiple priorities effectively
- Clear and professional communication skills, both written and verbal
- Collaborative mindset with a focus on continuous improvement