Overview
On Site
Accepts corp to corp applications
Contract - W2
Skills
Microsoft SQL Server DBA
Analytics
Data Warehouse
Extract
Transform
Load
Data Integration
Database Architecture
Use Cases
Data Lake
Database Administration
Performance Tuning
Database Security
Policies and Procedures
Data Integrity
Regulatory Compliance
Collaboration
Application Development
Database Design
Microsoft Azure
Database
Servers
Microsoft SQL Server
High Availability
Data Modeling
Microsoft SSIS
Real-time
Problem Solving
Query Optimization
Mentorship
Training
Migration
Job Details
This role will be instrumental in ensuring the performance, availability, security, and integrity of our critical SQL Server database environments, both on-premises and within Azure Synapse. The ideal candidate will possess significant experience in working in complex SQL Server infrastructures, including AlwaysOn availability groups, as well as designing, implementing, and maintaining ETL processes using SQL Server Integration Services (SSIS). This individual will also be a key contributor in troubleshooting database issues, optimizing query performance, and ensuring the smooth operation of our data platforms.
Responsibilities:
Administer and monitor our Azure Synapse Analytics environment, including data warehousing and data integration components.
Design, develop, implement, and maintain ETL packages using SQL Server Integration Services (SSIS) to support data integration needs.
Provide recommendations to business unit on database architecture for new use cases
Take the lead on implementation of a new Data Lake in an Azure Synapse environment
Perform regular database maintenance tasks.
Monitor database performance, identify bottlenecks, and implement effective performance tuning strategies.
Troubleshoot database-related issues, including connectivity problems, query performance degradation, and data corruption.
Maintain database security policies and procedures, ensuring data integrity and compliance.
Collaborate with application development teams to optimize database design and query performance for new and existing applications.
Document database configurations, processes, and procedures.
Stay current with the latest SQL Server and Azure data platform technologies and best practices.
Experience:
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.