West Advanced Technologies
SQL Server Database Administrator
West Advanced Technologies, Los Angeles, CA, United States
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
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