SQL DBA
Steneral Consulting · Southfield, MI · 3 wk ago
On-siteInformation TechnologyFull-time
Location: Hybrid – Southfield, MI | Duration: 6 months | Interview type: Video | Visa restrictions: No sponsorship available
Required Skills
- Proven experience (4 years) administering Microsoft SQL Server databases in a production environment
- Thorough knowledge of SQL Server administration, T‑SQL development, database performance tuning, indexing, and query optimization
- Experience managing SQL Server security, permissions, authentication, auditing, and encryption
- Experience with PowerShell or other scripting languages for automation (a plus)
- Understanding of cybersecurity principles and best practices related to database security
- Experience supporting healthcare and financial environments
Responsibilities
- Maintain and administer Microsoft SQL Server databases across development, test, and production environments
- Monitor database performance, availability, capacity, and resource utilization to ensure optimal operation
- Monitor database growth and proactively recommend storage, performance, and scalability improvements
- Troubleshoot and resolve database performance issues and other database‑related incidents
- Design, implement, and maintain database maintenance plans, including index management, statistics updates, and integrity checks
- Implement and maintain database backup, recovery, and disaster recovery solutions to meet recovery objectives
- Perform database restorations and periodically validate backup integrity and recoverability
- Participate in disaster recovery and business continuity testing activities
- Collaborate with software development and business analysis teams to review and recommend database design, schema changes, and application deployments
- Implement and maintain database security controls, including user access management, role‑based permissions, encryption, and auditing
- Work alongside IT security and compliance teams to ensure databases meet HIPAA, PCI DSS, and other regulatory requirements
- Develop and maintain SQL scripts, stored procedures, automation processes, and database documentation
- Assist with migration of on‑premises databases to cloud‑based platforms, including Azure SQL services where applicable
- Improve existing, or create new, processes and procedures for database administration, troubleshooting, and operational support
- Stay up to date on emerging database technologies, security practices, and industry standards
- Provide on‑call and after‑hours support as needed
- Perform other related duties as assigned