Database Administrator

CODE Plus, Inc., an experienced IT government contractor in Fairfax, VA with offices in Huntsville, AL and Oak Ridge, TN have been in business for 30 years and have been servicing different agencies within the Federal sector. Our mission is to deliver high-quality, cost-effective solutions that empower our clients to achieve their goals. At CODEplus, we value teamwork, integrity, and technical excellence, and we pride ourselves on maintaining long-standing partnerships built on trust and results.

Currently seeking we are seeking a Mid-Level Database Administrator with 2–5 years of experience to join our team in Merrifield Virginia. 

Skills and Responsibilities:

•            Design and Implement Data Solution to meet the existing system requirement of Data Integrity, Security, Efficiency, Maintainability, Interoperability and Extensibility

•            Analyze and Model system data requirement and produce logical design of properly normalized database schemas to balance conflicting requirements.

•            Work with Sysadmin to produce and implement the physical design of the database, placement, multiplexing, partitioning.

•            Serving as the Data Solution Expert to advise the development team through the entire life cycle of system development.

•            Advise the development team for solutions of complicated access path / query, primary key, foreign key, unique key relationship, view, and materialized view.

•            Installation and configuration, upgrading and patching of Database System.

•            System Capacity Planning, proactively monitor and anticipate the growth of system load and provide recommendation on system resource procurement.

•            Performance Analysis and Optimization, identify performance issue and provide recommendation to solve performance issue.

•            Troubleshooting system issue by working with sysadmin, network admin and development team to identify and locate issue properly.

•            Design and Implement Data Loading, Import and Export, Transformation.

•            Design and Implement High Availability solution with RAC and Data Guard.

•            Design and Implement Recovery Solution with RMAN à Design, Implement, and Test backup and recovery solutions utilizing RMAN for data protection and disaster recovery.

•            Implement and maintain security controls, manage user permissions, and protect sensitive data from unauthorized access. 

•            Install, configure, and upgrade database software and systems, and perform routine maintenance tasks. 

•            Effectively communicate with diverse stakeholders, including users, developers, and management.  

•            Typically reports to the team lead of the development group.

Education and Experience:

•            Bachelor’s Degree, preferably in area of specialty

•            5+ years of experience in the field or in a related area

Additional Requirements:

•            Must be familiar with Relational Database Analysis and Design

•            Must be familiar with Relational Normalizing / De-normalizing for High Performance System

•            Must be familiar with Index Tuning / Analysis

•            Must be familiar with Oracle RDBMS 19c

•            Must be familiar with SQL DML/DDL

•            Experienced on RDBMS Performance Analysis and Optimization, SGA/PGA, REDO/UNDO, Partitioning

•            Experienced on OLTP / OLAP System Tuning

•            Experienced on Ad-hoc Reporting

•            Experienced on DTL / DLT Data Loading, import/export

•            Familiar with Query Troubleshooting, Execution Plan Analysis and Optimization

•            Familiar with System Capacity Planning

•            To be able to demonstrate current work is a plus

 A public trust is required.

The current work schedule is based on 4 days onsite and one day remote.