IT - Database Administrator

Advanced Onion - Monterey, CA

Full-time - Mid Level

Monterey, CA

Professional, Scientific, and Technical Services

About the position

The Applications Support Oracle Developer/DBA plays a critical role in ensuring the smooth operation and maintenance of application-level databases across the DMDC environment. This position involves a variety of tasks aimed at supporting the Lead DBA in managing and optimizing database performance. The primary responsibilities include verifying that database objects such as triggers, indexes, and stored procedures are deployed correctly, as well as providing estimates for table space sizing and partitioning recommendations to facilitate migrations to new technologies, including cloud infrastructures. Collaboration with the systems team is essential for proactive monitoring of RDBMS space utilization, ensuring that database performance is maintained at optimal levels. In addition to deployment and monitoring tasks, the DBA will coordinate with System DBAs to maintain and support approved enterprise database objects. This role also requires providing database support across designated regions through a structured on-call personnel hierarchy. The DBA will be responsible for reviewing RDBMS log files to troubleshoot and remediate database issues, ensuring that updates to databases are quality-checked and yield the desired results. Furthermore, the DBA will assist project teams by providing feedback and support for database restore and recovery operations, as well as performing database conversions and migrations in response to application changes. The position also entails maintaining consistency across test, development, and pre-production databases, supporting data extracts from production databases while adhering to DMDC privacy policies, and collaborating with Tech Services teams to establish and control database security measures. The DBA will report any unauthorized DDL activities to the appropriate government information assurance officers and make necessary changes to database replication based on evolving requirements. This role requires a strong understanding of Oracle internals and the ability to create and maintain UNIX shell scripts for DBA tasks, ensuring that all database operations are efficient and secure.

Responsibilities

• Assure and verify objects deploy correctly to the application-level databases across the DMDC environment.
• Provide table space sizing estimates for all database objects and partitioning recommendations.
• Collaborate with systems team to proactively monitor RDBMS space utilization.
• Design, implement, monitor and tune SQL, DDL, and DML statements stored in the database.
• Coordinate with System DBAs to maintain and support approved enterprise database objects.
• Provide database support for all designated regions through a primary/secondary on-call personnel hierarchy.
• Support review of RDBMS log files proactively for database problems to troubleshoot and remediate issues.
• Provide quality check on updates to databases and assure scripts updates to databases have the desired result.
• Provide necessary feedback to project teams.
• Provide Database Restore and Recovery support in collaboration with the System DBAs.
• Perform database conversions and migrations in support of application changes.
• Support, maintain, and keep the test, development, and pre-production databases consistent across environments.
• Support data extracts from production databases in response to DMDC Data Requests.
• Ensure all DMDC privacy policies are enforced when extracting PII.
• Assist in verifying the accuracy and completeness of the data in DMDC databases.
• Collaborate with Tech Services teams to establish/control database security/annual password changes.
• Report any unauthorized DDL activities to the appropriate government information assurance officers.
• Make changes to database replication based on new requirements.
• Configure, maintain and monitor replication for errors and data consistency.
• Verify replicated database synchronization and resolve any inconsistencies.
• Support and maintain Oracle wallet repository in all regions.
• Support and maintain monthly data archival.
• Create/maintain UNIX shell scripting for DBA tasks.
• Update data sources/batch files on servers/maintain credentials for databases.

Requirements

• Minimum 5+ years' experience working with Oracle databases within Linux and Unix environments.
• Expert level of SQL and PL/SQL skills, including query optimization, troubleshooting, and performance tuning.
• Experience in design, development, testing, implementation, and support of database objects such as data models, triggers, packages, procedures, functions, and data loads.
• Experience with UNIX and Linux Servers, including the ability to read, develop, and test UNIX shell scripts.
• Experience in data migration projects, thoroughly testing the migration of data from one data structure to another.
• Experienced in Oracle data pump, export/import process, and table space point-in-time recovery.
• Good analytical, written, and communication skills.
• Self-motivated and able to work well in a team environment.

Nice-to-haves

• Good understanding of Oracle internals and objects.
• Able to provide 24/7 support 365 days of the year.
• Knowledge in creating automated testing scripts.
• Respond to system failures and work with developers, customers, and vendors to resolve issues related to database servers and related hardware.
• Regular and proactive performance monitoring of various database structures, activities, and users.