Job Title: PL/SQL DBA
Location: Remote
Clearance: Tier 3 (T3) Investigation
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 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.