PL/SQL DBA

Optimized Technical Solutions, Inc.; Montgomery (AL); Remote; USD 100,000 - 130,000; Full time

Job summary

Optimized Technical Solutions (OTS) is seeking a PL/SQL Database Administrator to support ERP CS environments and OCI migration efforts. The role focuses on developing, maintaining, and optimizing PL/SQL components to ensure performance, integrity, and operational readiness through migration and sustainment phases.

The candidate will collaborate with the DBA Lead, MP DBA team, ERP CS technical teams, and stakeholders to implement secure database operations, perform tuning, backups, and

Qualifications

• Must be U.S. citizen.
• Active CompTIA Security+ certification required.
• Experience administering and supporting Oracle databases.
• Experience configuring, administering, or supporting Oracle Enterprise Manager.
• Working knowledge of OCI migrations.
• Understanding of SQL, database performance tuning, backup and recovery, and database security.
• Ability to troubleshoot issues and collaborate across technical teams.
• Strong technical documentation and communication skills.

Responsibilities

• Develop, maintain, and optimize PL/SQL procedures, functions, packages, triggers, and scripts to support ERP CS database environments and application requirements.
• Support database migration planning, execution, validation, testing, and post-migration stabilization activities.
• Analyze and troubleshoot PL/SQL code, SQL queries, database performance issues, and application-related database errors.
• Collaborate with SIT/UAT teams to identify, troubleshoot, and resolve database defects and support retesting efforts.
• Coordinate with Mission Partner teams and vendors to resolve technical issues and implement corrective actions.
• Monitor and optimize database queries and stored procedures to ensure performance and data integrity.
• Develop and maintain technical documentation, database scripts, and runbooks for post-migration sustainment.

Skills

Oracle databases

SQL

Troubleshooting

Documentation

Communication

Education

CompTIA Security+ certification

Tools

Oracle Enterprise Manager

OCI Migration tooling

Job description

Job Summary

Optimized Technical Solutions (OTS) is looking for a PL/SQL Database Administrator (DBA) to support the ERP CS shared services environments and associated Oracle Cloud Infrastructure (OCI) migration efforts. The PL/SQL DBA is responsible for developing, maintaining, optimizing, and troubleshooting Oracle database procedures, functions, packages, and scripts to support database operations, application functionality, and migration activities. This position works closely with the DBA Lead, Mission Partner (MP) DBA team, ERP CS technical teams, and other stakeholders to ensure database performance, integrity, and operational readiness throughout the migration and post-migration sustainment phases.

Job Title: PL/SQL DBA

Location: Remote

Clearance: Tier 3 (T3) Investigation

Job Responsibilities/Duties

• Develop, maintain, and optimize PL/SQL procedures, functions, packages, triggers, and scripts to support ERP CS database environments and application requirements.
• Work with the DBA Lead and ERP CS technical teams to support database migration activities and associated OCI infrastructure requirements.
• Support database migration planning, execution, validation, testing, and post-migration stabilization activities.
• Analyze and troubleshoot PL/SQL code, SQL queries, database performance issues, and application-related database errors.
• Support database integration and operational requirements across the MilAUDIT, Oracle Enterprise Manager (OEM), and Oracle Single Sign-On (SSO-OAM, OIM, OUD) environments, as applicable.
• Execute Oracle-provided tools and database scripts necessary to support migration, configuration, and operational activities.
• Collaborate with System Integration Testing (SIT) and User Acceptance Testing (UAT) teams to identify, troubleshoot, and resolve database-related defects and support retesting efforts.
• Coordinate with Mission Partner teams, infrastructure teams, and product vendors to resolve technical issues and implement approved corrective actions.
• Monitor and optimize database queries, stored procedures, and other PL/SQL components to ensure performance, reliability, and data integrity.
• Develop and maintain technical documentation, database scripts, standard operating procedures, and operational runbooks to support post-migration sustainment.

Contingent Upon Award

Requirements

• Must be U.S. citizen
• Must hold an active CompTIA Security+ certification and maintain it throughout employment.
• Experience administering and supporting Oracle databases.
• Experience configuring, administering, or supporting Oracle Enterprise Manager.
• Working knowledge of OCI and database or monitoring-platform migrations.
• Understanding of SQL, database performance tuning, backup and recovery, and database security.
• Ability to troubleshoot issues and collaborate across technical teams.
• Strong technical documentation and communication skills.

Work Environment

Office environment. Requires ability to provide clear, concise, accurate and timely communication, both verbally and in writing (100%). Requires ability to interact professionally with co-workers, management, and client (100%). Occasional business travel may be required. Only requested and approved expenses will be covered by OTS.

EEO Statement

OTS is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/Affirmative Action-Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or protected veteran status. U.S. Citizenship is required for most positions.