What are the responsibilities and job description for the Database Engineer/Oracle DBA - Senior Level - (20+ Yrs Exp) position at Prodigy One, LLC?
Prodigy One, LLC. is a software engineering and consulting firm providing more than 45 years of service to state and federal customers. By combining unparalleled experience and capabilities, our company provides big data, cloud development, and enterprise management solutions. We are focused on product usability and end user presentation to help our customers make the best decisions possible. Given our length of service in the industry, Prodigy One knows the importance of a competitive salary and benefits package. That's why our total compensation package can be tailored to meet employees personal needs.
A CLEARANCE IS REQUIRED TO BE CONSIDERED FOR THIS ROLE
Clearance required: Active TS/SCI clearance with Polygraph
Location: Aurora, CO
Job Description
Level 3 - 15 yrs of experience BS degree or additional 5 years of experience
210K-222K
(The compensation of this position starts at the lower amount of the stated salary range while higher amounts may be achieved by the candidate accepting less PTO, waiving Healthcare, or both.)
Benefits:
Prodigy One, LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
Prodigy One, LLC provides wage ranges in accordance with State Pay Transparency Laws to support Title VII Equal Pay initiatives. These pay ranges are subject to change at any time, and pay will be commensurate with experience and/or other factors allowable by law.
A CLEARANCE IS REQUIRED TO BE CONSIDERED FOR THIS ROLE
Clearance required: Active TS/SCI clearance with Polygraph
Location: Aurora, CO
Job Description
Database Engineer/Oracle Database Administrator
The selected candidate will support a complex system with exacting interface, performance, and security requirements, and will provide database engineering expertise in one or more of the following areas: architecture, design, development, requirements analysis, data flow, network design/implementation, testing, and documentation. She/he will analyze user requirements and system requirements specifications and will develop system architecture and system design documentation. She/he will support the development of system configuration documentation, including designs for capacity and performance planning. The selected individual will perform database engineering activities to include risk assessments and analyses of alternatives for a variety of system related issues and concerns. She/he will provide solutions to challenging technical problems in distributed data replication, concurrent data access, and high availability.
Primary Responsibilities
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:
The selected candidate will support a complex system with exacting interface, performance, and security requirements, and will provide database engineering expertise in one or more of the following areas: architecture, design, development, requirements analysis, data flow, network design/implementation, testing, and documentation. She/he will analyze user requirements and system requirements specifications and will develop system architecture and system design documentation. She/he will support the development of system configuration documentation, including designs for capacity and performance planning. The selected individual will perform database engineering activities to include risk assessments and analyses of alternatives for a variety of system related issues and concerns. She/he will provide solutions to challenging technical problems in distributed data replication, concurrent data access, and high availability.
Primary Responsibilities
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.
Basic Qualifications
- 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 experience scripting with JavaScript, Bash/Linux shell scripting ﴾in general﴿, Perl, and/or Python.
- 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 Qualifications
- 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.
Level 3 - 15 yrs of experience BS degree or additional 5 years of experience
210K-222K
(The compensation of this position starts at the lower amount of the stated salary range while higher amounts may be achieved by the candidate accepting less PTO, waiving Healthcare, or both.)
Benefits:
- Healthcare for Employee and Spouse and/or Children that is fully funded by Prodigy One
- 10% Employer Contribution to 401K; Immediately Vested
- 7 Weeks Paid Time Off (PTO)
- $2500 for Professional Development
Prodigy One, LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
Prodigy One, LLC provides wage ranges in accordance with State Pay Transparency Laws to support Title VII Equal Pay initiatives. These pay ranges are subject to change at any time, and pay will be commensurate with experience and/or other factors allowable by law.
