SQL DBA in Fayetteville, NC at APEX Systems

Date Posted: 10/16/2019

Job Snapshot

Job Description

Job #:  1004643



Our client is looking for a TS/SCI cleared SQL DBA in Ft Bragg NC. Please reach out to bbessette@apexsystems.com if you are interested!


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

 
 
 
 
 
 
 
 
EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at 844-463-6178-6178.