SQL DBA

Title: SQL DBA
Location: Southfield MI (Open relo hybrid)
Duration: 6 Months Contract to hire
Client: Confidential
Rate:$40-$45/hr on W2 (Max)
Visa: USC GC GC EAD TN
Interview Mode: Video

SUBMISSION REQUIREMENTS:
Need Genuine LinkedIn- NO RECENT OR MULTIPLE LINKEDIN
UPDATED LINKEDIN PROFILE PICTURE REQUIRED
Must have Visa Copy with the submission (FOR GC and EADs)
Must have full educational details with University Name and year of completion in resume.
WITHOUT ABOVE MENTIONED PREREQUISITE RESUME WILL BE DEEMED AS FAKE.

Job Description:
Need someone stronger Hands on with SQL.
Be able to work and mentor Developers on SQL to advise on best SQL practices
Validate Backup Upgrades.

They are mostly On Prem. So they need to be hands on from a SQL side on prem.

Dont want someone that just trouble shoots SQL tickets

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:
Bachelors 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.

Required Skills:

POWERSHELLMICROSOFT SQL SERVERSQLT-SQL