General Dynamics Information Technology
Oracle DBA, Senior
General Dynamics Information Technology, Albuquerque, New Mexico, United States, 87101
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). Active secret security clearance required.
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. Assist with analysis and documentation of user requirements. Implement system security patches & Security Technical Implementation Guides (STIGs). Evaluate existing database structures and propose solutions to enhance efficiency while maintaining data integrity. Create database schemas and objects such as tables, columns, triggers, stored procedures, scheduled jobs etc. Utilize tools such as Visual Studio, Toad Data Modeler, SQLPLUS, Team Foundation Server, Azure Devops, Jira, and Solarwinds Helpdesk. Required Knowledge, Skills, and Abilities:
Skillful time management and organizational skills to set and meet deadlines. Excellent written and oral communication skills. 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. Strong knowledge of Oracle Database best practices, concepts, and technologies. Graduate comprehension and understanding of the Open Systems Interconnection (OSI) model. 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:
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. B.S. Degree required or direct work experience may substitute for education (1 year experience = 1 year education). Oracle 19c Certified Associate (OCA), Oracle 19c Certified Professional (OCP) prior to hire. CompTIA “Security +” certification in accordance with DoD Directive 8140.01 Cyberspace Workforce Management requirements upon hire. GDIT is your place: 401K with company match • Comprehensive health and wellness packages • Internal mobility team dedicated to helping you own your career • Professional growth opportunities including paid education and certifications • Cutting-edge technology you can learn from • Rest and recharge with paid vacation and holidays
#J-18808-Ljbffr
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). Active secret security clearance required.
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. Assist with analysis and documentation of user requirements. Implement system security patches & Security Technical Implementation Guides (STIGs). Evaluate existing database structures and propose solutions to enhance efficiency while maintaining data integrity. Create database schemas and objects such as tables, columns, triggers, stored procedures, scheduled jobs etc. Utilize tools such as Visual Studio, Toad Data Modeler, SQLPLUS, Team Foundation Server, Azure Devops, Jira, and Solarwinds Helpdesk. Required Knowledge, Skills, and Abilities:
Skillful time management and organizational skills to set and meet deadlines. Excellent written and oral communication skills. 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. Strong knowledge of Oracle Database best practices, concepts, and technologies. Graduate comprehension and understanding of the Open Systems Interconnection (OSI) model. 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:
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. B.S. Degree required or direct work experience may substitute for education (1 year experience = 1 year education). Oracle 19c Certified Associate (OCA), Oracle 19c Certified Professional (OCP) prior to hire. CompTIA “Security +” certification in accordance with DoD Directive 8140.01 Cyberspace Workforce Management requirements upon hire. GDIT is your place: 401K with company match • Comprehensive health and wellness packages • Internal mobility team dedicated to helping you own your career • Professional growth opportunities including paid education and certifications • Cutting-edge technology you can learn from • Rest and recharge with paid vacation and holidays
#J-18808-Ljbffr