Req ID: RQ182126

Type of Requisition: Regular

Clearance Level Must Be Able to Obtain: Top Secret/SCI

Public Trust/Other Required: None

Job Family: Database Analysis/Design

Skills:

Database Management,Database Structures,Oracle Database,Relational Database Management System (RDBMS),Structured Query Language (SQL)

Certifications:

Security+, CE - CompTIA-Security+ CE

Experience:

5 + years of related experience

US Citizenship Required:

Yes

Job Description:

Database Analyst Sr Advisor

Deliver insights to help our clients turn data into action as a Database Analyst Sr Advisor at GDIT. Your work will provide transformative solutions to our clients’ big-data obstacles and help advance the mission. Here, you can make a meaningful impact on our clients’ mission and on your career. At GDIT, people are our differentiator. As a Database Analyst Sr Advisor, you will help ensure today is safe and tomorrow is smarter.

General Dynamics Information Technology (GDIT) seeks a highly motivated and experienced Senior Database Administrator to support a Defense Threat Reduction Agency (DTRA) mission in Fort Belvoir, VA . 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).

HOW A DATABASE ANALYST SR ADVISOR WILL MAKE AN IMPACT

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.23.

• 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.

• Perform directed tasks in a timely and efficient manner.

• 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.

WHAT YOU’LL NEED TO SUCCEED:

Required Knowledge, Skills, and Abilities:

• Robust experience administering Oracle Database Enterprise Editions.

• Advanced degree of analytical ability.

• Advanced skills in problem solving.

• Committed to a positive work ethic and active desire to learn.

• Skillful time management and organizational skills to set and meet deadlines.

• Excellent written and oral communication skills.

• 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, networking, 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 5 years in a junior or 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.

• Ability to work effectively in a team environment.

Minimum Education and Experience:

• Required: 5+ years of direct DBA experience working with Oracle Enterprise Editions

• Required: 3+ years of increasing responsibilities in Oracle Application Development and Database Administration.

• Required: 2+ years of direct IT experience supporting database environments on RHEL and Windows system platforms.

• Required: Fully adjudicated Secret security clearance to start w/ TS SCI eligibility.

• Required: Oracle Certified Associate (OCA), Oracle Certified Professional (OCP) prior to hire.

• Required: DOD 8570 IAT Level II Certification. Ex. CompTIA Security + w/CE

• B.S. Degree required, or direct work experience may substitute for education.

GDIT IS YOUR PLACE:

● Full-flex work week to own your priorities at work and at home

● 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

The likely salary range for this position is $144,500 - $195,500. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.

Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.

We are GDIT. A global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government, defense and intelligence community. Our 30,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 30 countries worldwide, offering leading capabilities in digital modernization, AI/ML, Cloud, Cyber and application development. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology.

We connect people with the most impactful client missions, creating an unparalleled work experience that allows them to see their impact every day. We create opportunities for our people to lead and learn simultaneously. From securing our nation’s most sensitive systems, to enabling digital transformation and cloud adoption, our people are the ones who make change real.

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.