MS SQL DBA - INA Solution Inc

Role: MS SQL DBA
Location: St. Louis, MO
Duration: Long Term Contract

Experience Level: 10 + Years

Day one onsite

USC/GC only.

• Experience with Database Administration for MSSQL Server.
• Actively and consistently supports all efforts to simplify and enhance the customer experience.
• Designs and maintains access and security administration.
• Designs, implements and maintains backup and recovery strategies on Database Management Systems.
• Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.
• Troubleshoots alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues.
• Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
• Experience with backups, restores and recovery models.
• Experience with SQL in a virtualized environment (ESX and Azure).
• Knowledge of Always-On, High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
• Experience in implementing operational automation using scripts.
• Identify areas of the SQL environment that are suited for automation and then implement a solution using a variety of tools from applications such as HPSA or through scripting (PowerShell, TSQL).
• Knowledge of indexes, index management, and statistics.
• Experience working with Windows server, including Active Directory and proper disk configurations.
• Performs capacity planning of SQL server environment and provides recommendations to management to sustain business growth.
• Designs, implements, maintains Disaster Recovery (DR) methodologies and creates documentation.
• Gathers business requirements and designs, implements multiple projects along with the production support.
• Creates standard operational procedures and templates.
• Acts as mentor for Database Administrators and Associate Database Administrators.
• Performs research and provides plans to remediate complex business problems.