This site uses cookies. To find out more, see our Cookies Policy

SQL DBA in Fayetteville at General Dynamics Information Technology

Date Posted: 2/13/2019

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    Fayetteville
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
    2/13/2019
  • Job ID:
    2019-53865

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

Job Requirements

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

For more than 50 years, General Dynamics Information Technology has served as a trusted provider of information technology, systems engineering, training and professional services to customers across federal, state, and local governments, and in the commercial sector. Over 40,000 GDIT professionals deliver enterprise solutions, manage mission-critical IT programs and provide mission support services worldwide. GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.

#ARMA #SPECOPS #CJPOST #DPOST



WIH09