Sr. Database Analyst - Military veterans preferred

2019-04-11
General Dynamics Information Technology (www.gdit.com)
Other

/yr

  full-time   employee


Washington
District of Columbia
United States

Responsibilities:

  • Experience with Oracle’s Human Capital Management (HCM) Extract functionality to design, develop and maintain DON data extracts programs in support of DCHRMS and DONCADS interfaces.
  • Experience with Oracle's BI Publisher (and OTBI) would be a plus.
  • Experience with documenting HCM Extract programs, data requirements, schedules, and extract requirements in support of Information Security Agreements for authorized DON civilian workforce data extracts from DONCADS to authorized DON systems as identified by Systems Integration Branch Head.
  • Provide software installation, configuration, and maintenance of Oracle Database Management System (DBMS).
  • Provide Oracle DBMS Security Administration.
  • Provide Oracle DBMS optimization or tuning to maximize system performance and efficiencies.
  • Provide Oracle DBMS Backup and Recovery procedures in coordination with data center personnel.
  • Provide Administration of DBMS objects such as tables, indexes, views, packages, and procedures.
  • Provide database administration to multiple databases within OCHR's Civilian HR Portfolio, including DONCADS, Recruitment, Benefits, IComplaints, and various Oracle or related relational databases adhering to OPM, DoD, or DON HR regulations and mandates.
  • Provide data warehousing functions to DONCADS utilizing Cognos Data Manager; integrating Oracle databases within DONCADS.
  • Provide analysis, design, and support the development of metadata models by HRSD's application developers, requiring experience and knowledge of federal HR policies, procedures, and regulations as outlined in the CFR.
  • Provide analysis, design, development, and maintenance for interface programs between Oracle databases for the purposes of extracting and combining information from different databases, consolidation of similar databases, improving performance, streamlining existing interfaces and generating queries/reports.
  • Ensure optimum database access and performance, meeting minimum or acceptable performance level defined by HRSD Operations Branch Head. Expeditiously (same day) identify, coordinate, and resolve any database access or performance problems with HRSD Operations Branch. Monitor disk utilization of the databases.
  • Perform daily monitoring of all database log files to detect errors and potential problems. Analyze throughput processing to provide tuning alternatives and more efficient/effective CPU utilization. Monitor and maintain database disk space allocation and utilization. Troubleshoot and resolve any user reported Oracle database problems.
  • Perform maintenance, upgrades, testing, and verification of interface programs between DCPDS and DONCADS as defined by HRSD Managers; monitor nightly interfaces and resolve any errors encountered.
 

Qualifications:

5-8 years of related database analysis and/or administration experience.

 

The minimum qualifications for these tasks are:
a) Five (5) years of database administration experience on HP UNIX and Windows operating systems
b) Five (5) years of Oracle DBMS experience within large-scale database enterprise system
c) Five (5) years of related work experience supporting Enterprise level systems
d) Three (3) years of experience performing ETL operations using IBM Cognos Data Manager
e) Must have completed a Network+, Security+, or higher as defined by DoD CIO Information Assurance (IA) training course

 

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.

Education:

Bachelors Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience.