Job Title :Senior SQL Server Database Administrator Azure & ETL
Position 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.
What Makes HTC A Great Place To Build Your Future
HTC Global Services wants you to join our team. Come build new things with us and advance your career. At HTC Global, you ll collaborate with experts, work alongside clients, and be part of high-performing teams driving success together. You ll have long-term opportunities to grow your career and develop skills in the latest emerging technologies.
At HTC Global Services, our employees have access to a comprehensive benefits package. Benefits can include Group Health (Medical, Dental, and Vision), Paid Time Off, Paid Holidays, 401(k) matching, Group Life and Disability insurance, Professional Development opportunities, Wellness programs, and a variety of other perks.
Our success as a company is built on inclusion and diversity. HTC Global Services is committed to providing a workplace free from discrimination and harassment, where every employee is treated with dignity and respect. We celebrate differences and believe that diverse cultures, perspectives, and skills drive innovation and success. HTC is an Equal Opportunity Employer and a proud National Minority Supplier. We seek to empower each individual, fostering an environment where everyone feels valued, included, and respected.
#LI-ST1 #LI-NC1 #SQLServer #AzureDatabaseServices #DatabaseAdministrator #SeniorDBA #ETLDevelopment #TSQL #SQLDataModeling #AzureDevOps #PowerShell #DatabaseManagement #DataEngineering #DataWarehouse #DatabaseArchitecture #SSRS #CloudMigration #Scrum #CEDS #12PlusYearsExperience
