Position: SQL Server Database Administrator

Location: Los Angeles, CA

Duration: 12+ months

Onsite Role

Required Skills:

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.

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.

High School Diploma

Regards,

Sangeetha

West Advanced Technologies, Inc.

Serving government agencies for 22 Years

E: sangeetha.p@wati.com , D: 279 895 6797

www.wati.com