Today
Public Trust
Mid Level Career (5+ yrs experience)
IT - Database
Merrifield, VA (On-Site/Office)
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.
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.
group id: 10124632
