Job Location USA-NC-Fayetteville
    Requisition ID
    # of Openings
    Job Function
    Information Technology
    Security Clearance Level
    Full/Part Time
    Full Time
  • 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




    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. #DefenseCampFtBelvoir #DPOST  #DefenseCamp


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed!

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.