SQL Server Database Administrator (Onsite) - Charlotte, NC - Financial Services

SQL Server Database Administrator (Onsite) - Charlotte, NC - Financial Services

10 Aug 2024
North Carolina, Charlotte, 28201 Charlotte USA

SQL Server Database Administrator (Onsite) - Charlotte, NC - Financial Services

Vacancy expired!

This is a senior-level Microsoft SQL Server Database Administrator. This candidate will be well versed in data migration for Microsoft SQL Server database, and provide administration support to the development part of the Database Operations and Maintenance team. The resource will be capable of identifying challenges, offer alternative solutions, and advice on complex MS SQL related problems. Manages multiple, moderately complex projects and direct activities of a team related to special initiatives or operations.

Job Responsibilities

  • 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

Qualifications

  • 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

Related jobs

Job Details

Jocancy Online Job Portal by jobSearchi.