What are the responsibilities and job description for the SQL DBA position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Techridge, Inc., is seeking the following. Apply via Dice today!
Job ID: 158630
Position: SQL Database Administrator
Duration: 12 months Contract
Location: Lansing, MI (Locals Only)
Direct Client: State of Michigan
Note from the client:
Top Skills & Years of Experience:
Database Administration Backup & Recovery:
Job ID: 158630
Position: SQL Database Administrator
Duration: 12 months Contract
Location: Lansing, MI (Locals Only)
Direct Client: State of Michigan
Note from the client:
- Candidate must be available for Onsite from Day 1, Tue/Wed mandatory, may transition to 5 days onsite)
- Interview Process: Vendor required to upload screenshot picture of candidate if interview is requested.
- Must be able to work onsite Tuesday & Wednesday each week (8 hours per day).
- Must be willing to transition to 5 days onsite if required (no remote-only option).
Top Skills & Years of Experience:
- 3 5 years - Implement native, cloud-native, and hybrid cross-site backup and recovery strategies. Installation & Configuration.
- 3 5 years. Enforce data masking, encryption (TDE), and Row-Level Security for internal customers.
- 3 5 years. Manage automated indexing, statistics, and integrity checks across fragmented environments.
- PowerShell / CLI Automation: Required. 2 3 years. Automate hybrid environment configuration using PowerShell, dba tools, and Cloud CLIs.
- Query & Index Optimization: Required. 3 5 years. Identify bottlenecks, rewrite T-SQL, and resolve locking/blocking issues.
Database Administration Backup & Recovery:
- Required. 3 5 years - Implement native, cloud-native, and hybrid cross-site backup and recovery strategies. Installation & Configuration:
- Required. 3 5 years - Configure SQL Server on physical hardware, VMs, and cloud IaaS virtual machines.
- Required. 3 5 years. Enforce data masking, encryption (TDE), and Row-Level Security for internal customers.
- Required. 3 5 years. Manage automated indexing, statistics, and integrity checks across fragmented environments.
- PowerShell / CLI Automation: Required. 2 3 years. Automate hybrid environment configuration using PowerShell, dba tools, and Cloud CLIs.
- Required. 2 3 years. Analyze metrics across physical servers, IaaS VMs, and PaaS endpoints.
- Query & Index Optimization: Required. 3 5 years. Identify bottlenecks, rewrite T-SQL, and resolve locking/blocking issues.
- Required. 2 3 years. Manage connectivity between on-premises SQL Servers and cloud environments.
- Required. 2 3 years. Configure Azure SQL Database, Managed Instances, or AWS RDS SQL Server. Cloud Migration: Preferred. 1 2 years. Move workloads from on premises to cloud using Azure Database Migration Service or AWS SMS.
- Preferred. 1 2 years. Schema deployment automation via Azure DevOps/GitHub Actions using Flyway or Redgate. Multi-Tenant
Salary : $60