Vacancy expired!
- Implement and administer Microsoft SQL Server databases within a multi-tiered environment.
- Adding or modifying system/user permissions to databases or database servers.
- Perform capacity planning, cluster set up, performance tuning and monitoring.
- Troubleshoot SQL DB slowness, Disk/Memory/CPU utilization and suggest resolutions.
- Analyze processing issues and data anomalies and identify solutions.
- Responsible for ensuring availability and performance of all databases.
- Work with Infrastructure Teams to ensure that needed system resources are allocated to the databases and to ensure high availability and optimal performance of the databases.
- Troubleshoot query performance issues and provide recommendations
- Schedule and perform regular SQL DB maintenance operations according to workload patterns and usage of the SQL DB
- Perform requested changes, updates and modifications to database structure and data.
- Perform database patches and upgrades without downtime.
- Assist with SQL database build and task automation
- Ensure that the database configuration items are properly maintained in the Configuration Repository
- Build Operations and Maintenance (O&M) checklists to maintain the service (daily, weekly, monthly, yearly O&M checklists); build Tactics, Techniques and Processes (TTPs) and Standard Operating Processes (SOPs) associated with SQL databases
- Ensure proactive engagement in Incident Management process, working with cross-functional teams to minimize the impact of database outages.
- Provide 24x7 Oncall support for critical production systems
- Minimum 9 years of hands-on SQL Server DBA experience
- Excellent communication skills. Ability to interact well with other teams
- Hands-on knowledge of install/configure/monitor/support SQL Server 2014/2016/2017. SQL Server 2019 experience is a plus
- Hands-on knowledge of install/configure/support SQL Server AlwaysOn/Log Shipping/Replication features
- Hands-on Knowledge of SQL Clustering and of ability to install/configure/support SQL clusters on VMware virtual servers
- Hands-on knowledge of install/configure/support SQL Server databases on AWS/Azure
- Hands-on knowledge of install/configure/monitor/support SSIS/SSRS/SSAS components
- Hands-on knowledge of SQL Server upgrades, database migrations & applying SQL security patches
- Good Windows PowerShell programming skills
- Working knowledge of IDERA SQL Server Diagnostic Manager monitoring
- Working knowledge of Active Directory and how SQL Server interacts with Active Directory
- ID: #23465268
- State: North Carolina Charlotte 28201 Charlotte USA
- City: Charlotte
- Salary: DoE
- Job type: Permanent
- Showed: 2021-11-25
- Deadline: 2022-01-23
- Category: Et cetera