SQL Server Database Administrator
Role details
Job location
Tech stack
Job description
The SQL Database Administrator is responsible for database design, performance optimization, maintenance, and security across hybrid environments (on-premises and cloud). This role involves managing SQL Server environments, ensuring high availability, and supporting enterprise-level applications through efficient database operations., * Manage database systems including design, implementation, monitoring, and maintenance.
- Perform data analysis and support database management functions across applications.
- Design logical and physical data models and maintain data dictionaries.
- Configure database parameters for optimal performance and resource utilization.
- Monitor, troubleshoot, and optimize database performance using SQL tools and utilities.
- Implement database security, access controls, and compliance standards.
- Perform backup, recovery, and disaster recovery operations.
- Create and maintain production, development, and testing environments.
- Conduct performance tuning by optimizing queries, indexes, and system configurations.
- Collaborate with developers and analysts to implement database changes and improvements.
- Support migration and integration of databases across hybrid cloud infrastructure.
- Ensure data integrity, consistency, and minimal redundancy across systems.
- Provide technical support and guidance to internal teams.
Requirements
Do you have experience in Technology security practices?, Required Qualifications & SkillsDatabase Administration
- 3-5 years of experience in SQL Server database administration.
- Strong experience in backup and recovery strategies (native, cloud, hybrid).
- Hands-on experience with SQL Server installation and configuration across physical, virtual, and cloud environments.
- Experience managing database maintenance tasks such as indexing, statistics, and integrity checks.
Security & Compliance
- Experience implementing:
- Transparent Data Encryption (TDE)
- Data masking
- Row-Level Security
- Solid understanding of database security best practices.
Performance Tuning
- Expertise in:
- Query optimization (T-SQL)
- Index tuning
- Resolving locking and blocking issues
- Experience monitoring performance across hybrid environments.
Automation & Scripting
- 2-3 years of experience with:
- PowerShell
- Command-line automation tools (DBA tools, cloud CLI)
Hybrid & Cloud Technologies
- Experience managing hybrid infrastructure (on-prem + cloud).
- Hands-on experience with:
- Azure SQL (Database/Managed Instance)
- AWS RDS for SQL Server
- Knowledge of cloud migration tools (Azure DMS, AWS SMS) is preferred.
CI/CD & Version Control (Preferred)
- Exposure to:
- Azure DevOps or GitHub Actions
- Database deployment tools such as Flyway or Redgate, * SQL Server Administration (3-5 years)
- Backup & Recovery Strategies (Hybrid/Cloud)
- Database Security & Compliance (TDE, Data Masking)
- Performance Tuning (Query & Index Optimization)
- PowerShell / Automation (2-3 years)
Benefits & conditions
4.54.5 out of 5 stars Lansing, MI 48916 Hybrid work $60 - $65 an hour - Contract