Senior SQL DBA

USA-NC-Fayetteville

Job Description

Primary Responsibilities:

Will be responsible for the installation, configuration, administration and management of Microsoft SQL Server 2005/2008R2/2012 and Microsoft SQL Reporting Services 2005/2008R2/2012.  Must have a strong understanding of database schema object management, data modeling and architecture. Will facilitate, implement, monitor and test database backups and recovery methodologies and processes. Will monitor and optimize the performance of the production SQL server databases. Responsible for database security, integrity, reliability, high availability and disaster recovery solutions. Identify and troubleshoot database issues and the ability to analyze, design, build, test and implement solutions. Implement and troubleshoot triggers, views, stored procedures and data integrity constraints. Monitor file system space, database allocation; verify efficient use of disk storage; optimize space allocation; prevent out-of-space situations; and proactively plan for increased capacity and scalability. Participate in non-core business hours monthly patching.

Education

BA/BS

Qualifications

Knowledge, Skills and Abilities

  • 8+ Years of Experience
  • Expert understanding of Structured Query Language (SQL) and Transact-SQL (T-SQL)
  • Experience with virtual environments (preferably Hyper-V) and SQL clustered environments
  • Experience with SQL Server Integration Services (SSIS) packages
  • Exposure to Resource Governor, Tuning Advisor, SQL Profiler and Windows Reliability and Performance Monitor
  • Ability to work in a dynamic fast paced environment that requires team interaction and coordination
  • Excellent communication skills to including technical writing and the ability to work in a collaborative team environment
  • Ability and willingness to expand knowledge and experience base
  • Ability to be detail oriented and to prioritize and complete assigned tasks within required deadlines
  • Exceptional problem solving and decision making capabilities, including troubleshooting technical issues, successfully resolving project issues and challenges, and developing creative solutions for process improvement and understanding user requirements
  • Strong understanding of database schema objects management, data modeling and architecture
  • Administration and maintenance of Oracle 11g Database Server and Microsoft SQL Server 2016 Database Server

Search for Our SQL DBA Jobs by Location:

USA-NC-Fayetteville

SEARCH FOR JOBS

FEATURED OPPORTUNITIES