SQL DBA

USA-NC-Fayetteville

Job Description

Primary Responsibilities

  • Create SSIS packages to load legacy data from Oracle databases into newly created CRM applications
  • Provide support to development team throughout the Software Development Life Cycle (SDLC)
  • Facilitate, implement, monitor and test database backups and recovery methodologies and processes
  • Identify and troubleshoot database issues
  • Implement and troubleshoot triggers, views, stored procedures and data integrity constraints
  • Participate in non-core business hours monthly patching
  • Provide 24/7 on-call support on a rotational basis

Secondary Responsibilities

  • Responsible for the installation, configuration, administration and management of Microsoft SQL Server 2016, SSRS, and SSIS servers
  • Responsible for the installation, configuration, administration and management of Oracle 11g database servers
  • Monitor and optimize the performance of the production SQL Server databases
  • Responsible for database security, integrity, reliability, high availability and disaster recovery solutions
  • Monitor file system space, determine database allocation, and proactively plan for increased capacity and scalability
  • Experience in an Always On environment

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