SQL DBA

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).

Max rate is $60/hrs all inclusive on Corp to Corp

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.

Requirements:

Database Administration Backup & Recovery:

1. Required. 3 5 years - Implement native, cloud-native, and hybrid cross-site backup and recovery strategies. Installation & Configuration:
2. Required. 3 5 years - Configure SQL Server on physical hardware, VMs, and cloud IaaS virtual machines.

Security & Compliance:

1. Required. 3 5 years. Enforce data masking, encryption (TDE), and Row-Level Security for internal customers.

Database Maintenance:

1. Required. 3 5 years. Manage automated indexing, statistics, and integrity checks across fragmented environments.
2. PowerShell / CLI Automation: Required. 2 3 years. Automate hybrid environment configuration using PowerShell, dba tools, and Cloud CLIs.

Performance Tuning & Monitoring Hybrid Performance Monitoring:

1. Required. 2 3 years. Analyze metrics across physical servers, IaaS VMs, and PaaS endpoints.
2. Query & Index Optimization: Required. 3 5 years. Identify bottlenecks, rewrite T-SQL, and resolve locking/blocking issues.

Hybrid Infrastructure Management:

1. Required. 2 3 years. Manage connectivity between on-premises SQL Servers and cloud environments.

Azure SQL / AWS RDSS:

1. 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.

CI/CD & Database Versioning:

1. Preferred. 1 2 years. Schema deployment automation via Azure DevOps/GitHub Actions using Flyway or Redgate. Multi-Tenant

Regards,
Subhash @ Techridge .net