General Dynamics Information Technology Sr. Oracle Database Administrator- Polygraph in Herndon, Virginia
Responsible for designing, planning, implementing and administering databases, including security, access, and documentation.
Participates in the design, maintenance, enhancement, coding, and administration of relational databases.
Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities.
Coordinates new data development ensuring consistency and integration with existing data warehouse structure.
Reviews business requests for data and data usage, researches data sources for new and better data feeds.
Participates in continuous improvement efforts in enhancing performance and providing increased functionality, including performing proactive maintenance such as ensuring continued space availability, monitoring activity, and documenting problems, changes, and solutions.
Assignments may include design of data dictionaries, database structure and layout, installing, upgrading, and managing database applications.
Provides guidance and work leadership to less experienced Analysts, and may have supervisory responsibilities.
May serve as technical team or task leader.
Stay current on vendors' best security practices in relation to organizational requirements.
Maintains current knowledge of relevant technologies as assigned.
Install new databases and apply maintenance fixes/patches supplied by vendor
Perform setup and tuning of system parameters
Tune the database for the OS platform of choice
Ensure appropriate storage for the DBMS (capacity planning)
Enable the DBMS to work with storage devices and storage management software
Interface with any other technologies required by database applications
Install and maintain third-party DBA tools
Create and maintain replication
Monitor database health
Upgrade DBs to most recent stable version
Ensure database security
Plan and implement backups and recovery
Create new schemas and user accounts with required privileges
Setup automated jobs within database for loading, backups or status notification
Provide import or export support for datasets
Support scheduled database or application outages
Maintain documentation for Standard Operating Procedures, After Action Reports, configuration setup and installation and patching procedures.
Participates in special projects as required.
Bachelors Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience.
Experience with Oracle RAC 11g and 12c
Experience with Oracle Grid Infrastructure, Oracle Enterprise Manager, Oracle Data Guard
Experience with shell scripting
Experience supporting an enterprise software development environment
Experience with customer encryption-at-rest products
Experience with database networking security, including PKI certificates, Oracle wallets, Java Keystores, and configuring SSL/TLS
Experience with UNIX-based environments
Experience supporting MySQL
Experience with Oracle replication technologies Oracle Streams, Oracle GoldenGate.
Experience installing and configuring Galera Cluster for MySQL
Familiarity with SQL Developer or SQL Work Bench
10-15 years of related database analysis and/or administration experience.
As a trusted systems integrator for more than 50 years, General Dynamics Information Technology provides information technology (IT), systems engineering, professional services and simulation and training to customers in the defense, federal civilian government, health, homeland security, intelligence, state and local government and commercial sectors.With approximately 32,000 professionals worldwide, the company delivers IT enterprise solutions, manages large-scale, mission-critical IT programs and provides mission support services.GDIT is an Equal Opportunity/Affirmative Action Employer - Minorities/Females/Protected Veterans/Individuals with Disabilities.