Responsibilities
- Administer and maintain the program's Oracle database environment, including user administration, role management, and monitoring of Oracle backups and recoveries.
- Collaborate with government data center and cloud database administrators and system engineers to provide system configuration and administration support.
- Conduct biannual performance tuning to ensure optimal server capacity, speed, and network performance, including data model evaluation for indices and data accommodation, hardware platform and operating system statistics analysis, and network performance assessment.
- Evaluate custom application code across Forms, Java, PL/SQL, application programming interfaces, and workflow components for database performance impact, and produce recommendations and best practices documentation.
- Develop and execute database upgrade and migration plans, data models, data entity and field additions, and data upload and supply scripts.
- Support enhancements and change requests to existing platform modules, and maintain current database documentation.
- Recommend and implement approved database performance improvements, including infrastructure changes such as cloud or container-as-a-service solutions.
- Support data quality, data profiling, governance, and data integration between platform data and other agency data sets.
Requirements
- Bachelor's degree in computer science, information systems, or a related technical field. An additional four years of directly relevant database administration experience may substitute for the degree.
- 8 or more years of database administration experience, including 5 or more years administering Oracle databases in a production enterprise environment.
- Current database administrator certification. The contract mandates no specific certifying organization; Oracle Database certification is the recommended DMI screening standard given the program's Oracle environment.
- Hands-on experience with Oracle Database 19c or later, including backup and recovery, performance tuning, and upgrade or migration execution.
- Demonstrated PL/SQL development and tuning experience, and the ability to evaluate application code for database performance impact.
- Experience operating databases in a cloud or managed relational database service environment.
- Ability to obtain and maintain a Moderate Risk (Tier 2) Public Trust background investigation and a government PIV credential.
- Must be a U.S. Citizen
Nice to Have
- Oracle Certified Professional, Oracle Database Administrator credential at the current or immediately prior release.
- Experience supporting Oracle WebLogic and Oracle Single Sign-On integrated application stacks.
- Experience with Apache Solr indexing or Documentum content repositories.
- Experience supporting databases under federal continuous monitoring and security control requirements.
- Experience with database change management under a formal release and configuration management process.
Benefits
- Convenience/Concierge – Virtual health visits, commuter perks, pet insurance, and entertainment discounts that make life easier.
- Development – Annual performance reviews, tuition assistance, and internal career growth opportunities to help you thrive.
- Financial – Generous 401(k) matches, life and disability insurance, and financial wellness tools to support your future.
- Recognition – Annual awards, service anniversaries, referral bonuses, and peer-to-peer shoutouts that spotlight your achievements.
- Wellness – Healthcare coverage, wellness programs, flu shots, and biometric screenings to support your health.
Additional Information
- Physical Requirements: None required for this position.
- Location: Remote, US
- Applicants selected may be subject to a government security investigation and must meet eligibility requirements for access to classified information.
- US citizenship may be required for some positions.
