Job Title :Senior SQL Server Database Administrator - Azure & ETLPosition Overview Be part of a large-scale database modernization initiative involving enterprise SQL Server environments, data warehouse management, and the transition of ETL processes from on-premises infrastructure to cloud servers.
This role offers the opportunity to work as a technical Subject Matter Expert (SME), driving database administration, data modeling, ETL development, performance optimization, and database security across complex data environments.
The position requires extensive experience in Microsoft SQL Server, Azure Database Services, SQL data modeling, and ETL development, along with the ability to independently manage database architecture and data administration activities.
What You'll Do / Key Responsibilities - Design, implement, maintain, and continuously expand data pipelines through extraction, transformation, and loading (ETL) activities.
- Perform data preparation, data analysis, and data reporting.
- Troubleshoot ETL jobs, conduct root cause analysis, and provide technical expertise.
- Manage database maintenance, enhancements, data dictionaries, logical and physical database models, and performance tuning.
- Coordinate physical database changes, code, test, and implement database structures.
- Establish physical database parameters and use SQL, Data Definition Language (DDL), and Data Control Language (DCL) to manage database objects and access.
- Monitor database performance using database utilities and third-party tools.
- Evaluate requests for new data elements and systems and integrate them into the existing shared data environment.
- Ensure data integrity, control redundancy, and perform database loading and reorganization.
- Perform logical and physical data modeling, design relational database models, and create physical data models from logical models.
- Manage database security, backup, recovery, and disaster recovery procedures.
- Collaborate with developers, business teams, programmers, and analysts to ensure high-quality data delivery.
- Monitor and upgrade the server infrastructure supporting the database environment.
- Support the transition of ETL processes from on-premises infrastructure to cloud servers.
Required Qualifications - Minimum 12 years of overall experience.
- Bachelor's degree required.
- 8-10 years of T-SQL experience.
- 6-8 years of ETL development experience.
- 5 years of PowerShell experience.
- 5 years of Azure DevOps experience.
- 5 years of Scrum experience.
- Strong expertise in Azure Database Services.
- Strong knowledge of SQL data modeling and database structures.
- Extensive hands-on ETL development experience.
#LI-ST1 #LI-NC1 #SQLServer #AzureDatabaseServices #DatabaseAdministrator #SeniorDBA #ETLDevelopment #TSQL #SQLDataModeling #AzureDevOps #PowerShell #DatabaseManagement #DataEngineering #DataWarehouse #DatabaseArchitecture #SSRS #CloudMigration #Scrum #CEDS #12PlusYearsExperience
