Application DBA/ Sr PL SQL Developer (100% remote)
Marathon TS is seeking an experienced Application DBA/ Sr PL SQL Developer to support our work with the DEA's Diversion Division. Responsibilities:
- Full SDLC support from requirements analysis, development, design, test, to deployment of custom Oracle applications
- Design, implement, and maintain database design and data dictionary
- Work in a high-performance, agile, enterprise, with the ability to coach other application developers.
- Develop scripts in SQL, PL/SQL for data conversion, implementing custom algorithms
- Practical, hands-on experience and demonstrable technical competence with development and operational tools
- Experience with Oracle Database 19c
- In-depth knowledge of Oracle database objects – tables, indexes, directories, sequences, triggers, packages, etc.
- Must be able to support Development, Test and Production environments for database Operations and Support and data integrity.
- Experience in writing complex SQL queries to provide reports on ad-hoc basis.
- Experience in code reviewing for standards and performance before deploying to DEV/TEST/PROD environments.
- Must be able to debug Oracle PL/SQL code for production issues.
- Must be able to support Development, Test and Production environments for databases and Operations Support.
- Experience in Unix shell scripting is a plus.
- Experience in AWS Oracle RDS environment is a plus.
- Experience in Golden Gate replication is a plus.
Requirements:
- A BS/BA in Engineering, Physics, Computer Science, Information Technology, Mathematics or related discipline is required
- 5-7 years of experience in the field.
- Must be a US Citizen (ability to obtain a Public Trust) and to successfully pass a DEA background investigation.
#cjjobs Marathon TS is committed to the development of a creative, diverse and inclusive work environment. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Marathon TS will be based on merit, qualifications, and abilities. Marathon TS does not discriminate against any person because of race, color, creed, religion, sex, national origin, disability, age or any other characteristic protected by law (referred to as "protected status "). Remote Skills: Algorithms, Amazon Relational Database Service (RDS), Code Reviews, Computer Science, Data Quality, Database Administration, Database Design, Database Technology, Debugging Skills, Information Technology & Information Systems, Mathematics, Operational Support, Oracle, Oracle Applications, Oracle Database, Oracle PL-SQL, Physics, Product Testing, Production Systems, Replication and Remote Mirroring, Reporting Skills, Requirements Management, SQL (Structured Query Language), Scripting (Scripting Languages), Software Development, Software Development Lifecycle (SDLC), Test Design, Test Plan/Schedule, United States Citizen, United States Drug Enforcement Agency (DEA), Unix Shell Programming undefined: Marathon TS