SQL Server Database Administrator Consultant

Position Description: Miscellaneous/Niche/Other Skills Required: Miscellaneous/Niche/Other Skills Preferred: The candidate needs to possess advanced technical skills with the following: • SQL Server versions 2008 through 2022 • Idera Database Management Tools or equivalent • SQL Server BI stack (SSRS, PowerBI, SSIS, SSAS) • SQL Server Always Groups 2012 and newer • SQL Server database features including TDE, TLS, Certificates, relational modeling, partitioning, gMSA, DTC and indexing • Migrate and manage databases in MS Azure or equivalent • Ability to configure and maintain backups utilizing on premise and cloud based tools • Perform Database Performance Tuning and Troubleshooting utilizing on premise and cloud based tools • Troubleshoot application and ETL database issues • Proficient with Active Directory Integration, Kerberos, SPNs, and PowerShell • Skilled in SQL and TSQL code reviews The candidate must also possess a high level of competence with the following soft skills: • SDLC Change management including maintenance of multiple development, test, QA, and production environments. • Responsible for deploying approved changes to production • Work with development project teams to design and implement database solutions to meet business requirements • Develop and implement Database security policies and procedures in line with applicable governance • Ability to work and coordinate with teams of diverse domain disciplines. (e.g. finance, healthcare, security, network operations, system admins., developers) • Develop in-house custom installation and configuration guides • End to end processing and resolution of work requests and trouble tickets • Provide consultation, training, and knowledge transfer to staff • Draft/formulate documentation of policies, procedures, and standards relating to database management. • Adhere to strict IT and Data Security Requirements e.g. HIPAA Experience Required: Miscellaneous/ Niche/ Other Experience Preferred: • 5 years or more experience installing, configuring, tuning, troubleshooting and maintaining Idera Database Management Tools or equivalent • 10 Years or more experience installing, configuring, tuning, troubleshooting and maintaining SQL Server • 10 years or more experience installing, configuring, tuning, troubleshooting and maintaining SQL Server BI stack (SSRS, PowerBI, SSIS, SSAS) • 10 years or more experience installing, configuring, tuning, troubleshooting and maintaining Windows Server • 5 years or more experience with SQL Server database features including Availability Groups, TDE, TLS, Certificates, relational modeling, partitioning, gMSA, DTC, indexing • 10 years or more experience working as a SQL Server Enterprise DBA in medium to large scale environments Education Required: Miscellaneous/ Niche/ Other Education Preferred: High School Diploma Additional Information: Position Description: The Database Administrator Consultant will serve as an active hands-on member of the Database Administrator (DBA) team. The DBA team is responsible for the implementation, operation, and maintenance of the SQL Server Enterprise Farm, including, but not limited to, designing, planning, coordinating, monitoring, tuning and troubleshooting the database environment. The SQL Farm supports critical patient care systems that are 24/7/365 therefore must be willing to provide support as needed after hours, on weekends and holidays. The position is a hybrid work environment, partly in the physical workplace, and partly remotely. The physical office location is Downtown Los Angeles, CA. A live scan is required for this position.