SQL Database Administrator
- LKA & Associates LLC
- Lansing, Michigan
today
Job Description
Requirements:
- 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.
Security & Compliance:
- Required. 3–5 years.
- Enforce data masking, encryption (TDE), and Row-Level
- Security for internal customers.
Database Maintenance:
- 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.
Performance Tuning & Monitoring Hybrid Performance Monitoring:
- 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.
Hybrid Infrastructure Management:
- Required. 2–3 years.
- Manage connectivity between on-premises SQL Servers and cloud environments.
Azure SQL / AWS RDS/GCS:
- 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:
- Preferred. 1–2 years.
- Schema deployment automation via Azure DevOps/GitHub Actions using Flyway or Redgate.
Skills
- SQL
- TDE
- Server
- Powersell
Key Job Details
Location:
Lansing, Michigan.- Salary: $87.4K - $87.4K PY
- Experience: 3-5 years
- Education: Bachelor's degree
- Job Type: Temporary Employees
- Preferable Shift: General Shift
- Functional Area: Information Technology (IT)