Own your opportunity to support our nation's defense. Make an impact by connecting and securing critical operations across the globe, keeping our country safe and secure.
General Dynamics Information Technology (GDIT) seeks a highly motivated and experienced Senior Database Administrator to support a Defense Threat Reduction Agency (DTRA) mission in Albuquerque, NM. This position will support the Defense Stockpile Management Systems (DSMS) which includes: Defense Integration and Management of Nuclear Data Services (DIAMONDS), Joint Application Design Environment (JADE), Nuclear Inventory Management and Cataloging System (NIMACS), Government Acceptance Testing (GAT), and DIAMONDS Accountability Training System (DATS).
Essential Duties and Responsibilities:
Resolve complex issues involving database performance, database capacity, resiliency, stability, replication, and other key aspects of distributed database technology.
Perform testing, analysis, and modification of existing database SQL stored procedures.
Evaluate, refine, and tune existing Oracle objects in support of application. Install, upgrade, patch, secure, diagnose system problems, user accessibility, and troubleshoot Oracle Database versions 12.2 through 19.26.
Digest onsite concepts, design, implementation, limitations, and configuration of complex database environments.
Ability to define, troubleshoot, document, and escalate issues as needed. Work closely with application development team to implement and support data-oriented development efforts.
Work closely with support center to expeditiously resolve issues or problems as they arise.
Assist with analysis and documentation of user requirements.
Implement system security patches & Security Technical Implementation Guides (STIGs).
Maintain electronic repository of all database baseline, changes, and documentation.
Research and recommend solutions that best meet program needs and operational requirements.
Work alongside senior application development managers to gather business rules and requirements.
Evaluate existing database structures and propose solutions to enhance efficiency while maintaining date integrity.
Create database schemas and objects such as tables, columns, triggers, stored procedures, scheduled jobs etc.
Create database models based on current and future requirements outlined from customer.
Evaluate, review, revise, and integrate database change requests.
Utilize tools such as Visual Studio, Toad Data Modeler, SQLPLUS, Team Foundation Server, Azure Devops, Jira, and Solarwinds Helpdesk.
Required Knowledge, Skills, and Abilities:
Robust experience administering Oracle Database Enterprise Editions.
Advanced degree of analytical ability. Advanced skills in problem solving.
Skillful time management and organizational skills to set and meet deadlines.
Ability to work both independently and within a team.
Strong understanding of Oracle Data Guard Replication and Recovery Manager. Experience with Linux and Windows based operating systems administration and troubleshooting.
Extensive knowledge of relational database concepts; Database Modeling, Design and Database Creation.
Demonstrated proficiency in creating database schemas and objects pursuant to current oracle database industry standards and best practices.
Ability to create, clone, plug and unplug pluggable databases in a multitenant environment.
Experience working with programming languages such as SQL, PL/SQL, Shell Scripts, and Batch Scripts.
Proven troubleshooting and problem-solving skills for critical database, application, network, and system administration issues.
Ability to work efficiently under pressure and with a high degree of independence.
Critical thinking skills, ability to accurately analyze information and make sound decisions.
Strong knowledge of Oracle Database best practices, concepts, and technologies.
Must be versatile, flexible, and proactive when resolving technical issues. Ability to handle diverse situations and rapidly changing priorities with deadlines.
Graduate comprehension and understanding of the Open Systems Interconnection (OSI) model.
Ability to demonstrate relational database constructs leveraging primary and foreign keys, check constraints, and creation of objects via command line.
Preferred Knowledge, Skills, and Abilities:
Positive experience in database administration with at least 7 years in a junior to mid-level position.
Experience installing, configuring, and troubleshooting Oracle 19c software. Exposure to other RDBMS systems such as MSSQL and PostgreSQL is a plus.
Bachelor’s degree in a related field, such as Computer Science, Data Processing, Information Systems, or equivalent experience.
Experience with features such as Automatic Storage Management and Data Guard.
Sound efficiency in developing PL/SQL code and genuine relational database management.
****Minimum Education and Experience:
Oracle 19c Certified Associate (OCA), Oracle 19c Certified Professional (OCP) prior to hire.
5+ years of direct DBA experience working with Oracle Enterprise Editions .
7+ years of increasing responsibilities in Oracle Application Development and Database Administration.
5+ years of direct IT experience supporting database environments on RHEL and Windows system platforms.
DoD final Secret security clearance is required, with ability to gain and hold Top Secret.
Comptia “Security +” certification in accordance with DoD Directive 8140.01 Cyberspace Workforce Management requirements upon hire.
#gditpriority
#armajobs
Years of Experience
7 + years of related experience
* may vary based on technical training, certification(s), or degree
Certification
Travel Required
None
Citizenship
U.S. Citizenship Required
...inclusion, trust, and empowerment while protecting the environment and operating safely - all of which are top priorities for the enterprise.... ...'s point of origin to the BYOT yard utilizing assigned tow truck and equipment. Negotiate with vehicle sellers to obtain the...
Job OverviewWere looking for a reliable and organized Virtual Assistant to support daily administrative tasks from home. This role is ideal for someone who enjoys structured work, communicates clearly, and can manage multiple responsibilities without constant supervision...
...exposure. Plan, organize, and coordinatescientific/technical research to assess the environmental fate and transport of pesticides in... ...week. Special Requirements ~ The position(s) require(s) Medical Clearance prior to being hired. ~ Theposition(s) is (are)...
Execute coordinated content management and distribution efforts for Content Licensing unit. Manage digital logging and library functionality and assist in production execution for third-party distribution. Identify and elevate key challenges and coordinate on a daily basis...
...Personal Assistant to Founders Emerging Venture Program Europe / USA / Asia The Role We're hiring an exceptional Personal Assistant to support a small founding team (3+) inside our Emerging Venture Program. This is not a desk job, and it isn't a job where you...