Database Administrator with Security Clearance

CODEplus is seeking a Database Administrator in Merrifield, VA.

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.

Employee