Sr. SQL Database Administrator in Fort Mill, North Carolina at AccruePartners

Date Posted: 7/24/2020

Job Snapshot

Job Description

WHO OUR CLIENT IS:

  • A stable, privately held company in the energy sector with various locations throughout the US.
  • One of the largest providers of Energy Solutions in the United States, with the senior management team fielding more than 150 years combined experience in the electric industry.
  • Our client provides engineering, construction and maintenance for distribution and transmission powerlines, substations, Engineering, Procurement and Construction (EPC) projects and renewable energy projects.


WHY YOU SHOULD CONSIDER THIS OPPORTUNITY:

  • Opportunity to be a part of a highly visible, transformational IT initiatives.
  • Competitive base pay and benefit package.
  • A company culture that offers a family friendly environment and promotes internal growth.

WHAT YOU WILL DO:

  • Optimize production system and identify bottlenecks, ensuring high levels of data availability.
  • Liaise with Developers and Engineers and provide SQL Server database expertise as needed.
  • Monitors business critical production SQL Server clusters during peak hours and respond to incidents to ensure high levels of availability
  • Performs SQL Server (versions 2008-2019) cluster and standalone installation and configuration in accordance with documented standards
  • Collects detailed SQL Servers performance metrics and makes tuning recommendations
  • Investigates root cause for database related application errors (Blocking, SQL timeouts, deadlocks, unexpected data condition etc.) in real time, provides document explaining root cause and recommends fixes (including recommending changes to application stored procedures) to avoid future recurrences
  • Coordinates the database portion of the disaster recovery plan and participates in the planning, testing and implementation of recovery procedures
  • Manages SSRS data warehouse and provides guidance and assistance to reports developers working to meet business reporting requirements
  • Monitors and optimizes schedules for SQL Server Agent based maintenance jobs (backups, statistics maintenance, index maintenance, etc.)
  • Evaluates, coordinates and executes capacity planning
  • Establish and document standards for database administration relevant to the RUN application
  • Assist application developers with complex query tuning, schema refinement, and stored procedure optimization according to company conventions and best practices
  • Writes or peer reviews DML scripts to correct data conditions and processes scripts through issue management system
  • Reviews other Database Developer's code for accuracy, standards, good coding practices, and adherence to documentation standards
  • Ensures data security by enforcing team security standards
  • Provides SQL Server DBA support for non-production SQL Server environments
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
  • Create automation for repeating database tasks
  • Provide 24x7 support for critical production systems
  • Perform scheduled maintenance and support release deployment activities after hours

HOW YOU ARE QUALIFIED

  • Bachelor’s degree in Computer Science, Computer Applications, Information Technology, Information Systems, Data Science, Business Administration, Engineering or related field
  • 7+ years of experience supporting enterprise SQL Server database applications with focus on Database Administration
  • Experience with cloud services (Microsoft Azure) a plus
  • Experience conducting database administration, implementing and maintaining database security, production and non-production databases, optimizing database access
  • Deep knowledge of backup and disaster recovery
  • Detailed knowledge of relational database management systems (RDBMS), object-oriented database management systems (OODBMS), and XML database management systems
  • Demonstrated experience in performance optimization