SQL DBA

Title: SQL DBA
Location: Southfield, MI (Open relo, hybrid)
Duration: 6+ Months Contract to hire
Visa: GC-EAD, TN
Interview Mode: Video

Job Description

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 restorals 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 make recommendations on 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 the migration of on-premises databases to cloud-based platforms, including Azure SQL services where applicable;
• Improve current and, if missing, 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; and
• Perform other related duties as assigned.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or related field;
• 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 is a plus;
• Understanding of cybersecurity principles and best practices related to database security;
• Experience supporting healthcare, financial, or other highly regulated environments is preferred;
• Familiarity with monitoring and performance management tools such as SQL Server Management Studio (SSMS), Redgate, SolarWinds, SentryOne, or similar platforms is a plus;
• Excellent troubleshooting skills with the ability to analyze complex database issues;
• Strong organizational and multitasking skills;
• Strong writing skills for creating technical documentation, operational procedures, and compliance-related materials;
• Ability to work independently, as well as part of a team; and
• Flexibility to work evenings and weekends as needed.