Oracle Database Administrator

h3 Technologies, LLC; Maryland; On-site; USD 120,000 - 170,000; Full time

Job summary

h3 Technologies, LLC seeks a Database Administrator to guide and support database engineering for large-scale, distributed systems. The role interfaces with technical managers, engineers, and customers in an Agile environment, providing database design, migration, tuning, and administration across Oracle, PostgreSQL, and MongoDB.

Some MD travel for quarterly PI Planning may be required. The ideal candidate has a TS/SCI Full Scope Polygraph, 10+ years of DBA experience, a technical bachelor's

Qualifications

• Must hold TS/SCI Full Scope Polygraph through MD Customer, last poly within 6 years
• Experience as a Database Administrator including data migration, replication, user administration, backup/recovery, performance tuning
• Strong understanding of relational and NoSQL databases (Oracle, PostgreSQL, MongoDB)
• Proficient in Oracle SQL/PLSQL and SQL
• Programming knowledge including Java
• Committed to best practices and disciplined task planning
• Capable of high-quality work independently or in a fast-moving team

Responsibilities

• Support database design, development, implementation, storage and retrieval, data flow and analysis
• Evaluate system improvements, optimization and maintenance efforts
• Develop long-term and short-term requirements for database administration and design
• Develop databases, database parser software and loading software
• Translate requirements into usable schemas and create/update queries and macros
• Develop database structures that fit the overall system architecture
• Provide recommendations from project inception to conclusion within a business/IT domain
• Travel to MD for quarterly PI Planning sessions as needed

Skills

Security clearance TS/SCI

Database Administration

Oracle SQL/PLSQL

Java

Data migration

NoSQL databases

Plan and prioritize tasks

Independent and team collaboration

Education

Bachelor's Degree in technical discipline

Tools

MongoDB

PostgreSQL

Oracle

Job description

The selected candidate will provide guidance and support for database engineering of large-scale systems, major system elements, and interfacing systems that are part of a large complex network environment with geographically distributed components. She/he will interface with technical managers, system and software integration engineers, test engineers, information assurance engineers, and other project team members in an Agile environment. The selected candidate will be responsible for implementing database engineering practices to ensure the proper degree of engineering rigor is applied to all assigned tasks. She/he will be responsible for communicating with and effectively collaborating with internal technical professionals on a day-to-day basis, and with POCs from customer organizations when necessary. The selected individual will actively participate in Program Increment Planning and related Agile team activities. Assigned duties may include:

• Supporting database design, development, implementation, information storage and retrieval, data flow, and analysis activities.
• Supporting the analysis and evaluation of system improvements, optimization, development, and/or maintenance efforts.
• Supporting the development of long-term and short-term requirements for database administration and design.
• Assisting in developing databases, database parser software, and database loading software.
• Translating requirements and data into usable database schemas by creating or recreating ad hoc queries, scripts and macros, making updates to existing queries, and creating new queries to manipulate data into a master file.
• Assisting in the development of database structures that fit into the overall architecture of the system under development.
• Developing requirement recommendations from a project's inception to its conclusion for a particular Business and IT subject matter area (i.e. simple to complex systems).
• Developing database structures that fit into the overall architecture of the system under development.
• If not located at the MD location, some short-duration travel may be required to support quarterly PI Planning sessions in MD.

Required Skills:

• Clearance: TS/SCI Full Scope Polygraph through MD Customer. Last poly must be within the past 6 years, no CCAs
• Must have experience as a Database Administrator to include proficiency in tasks such as data migration, data replication, user administration, backup and recovery, performance tuning, issue investigation, issue resolution, and general administration.
• Must have a good understanding of databases, primarily Oracle and/or other relational and non-relational/NoSQL databases such as PostgreSQL and MongoDB.
• Must have experience using Oracle SQL/PLSQL, and SQL in general.
• Must have knowledge of programming languages to include Java.
• Must be committed to adopting and adhering to best practices.
• Must be able to effectively plan and prioritize tasking.
• Must be capable of performing high quality work both independently, and with a team, in a fast-moving environment.

Preferred Skills:

• Bachelor's Degree in a technical discipline.
• At least 10 years of high-level, in-depth database experience.
• Experience with the Scaled Agile Framework (SAFe) methodology and/or as a member of an Agile team.
• Experience with Cassandra.
• Experience with MongoDB.

Skills and Certifications:

TS/SCI Full Scope Polygraph through MD Customer. Last poly must be within the past 6 years, no CCAs

Security Clearance Required: Yes

Ideal Candidate:

Must have an FS poly through the MD Customer, last poly must be within the past 6 years, no CCAs. Database Administrator - Level 2 (Senior) Ten (10) years’ experience as a DBA in programs and contracts of similar scope, type, and complexity is required. Bachelor’s degree in a technical discipline from an accredited college or university is required. Four (4) years of additional DBA experience may be substituted for a bachelor’s degree.