Requires TS/SCI w/ poly.
Required: Oracle, Linux, SQL, scripting,
*1 week of on-call support every 3-5 weeks required after ramp-up
Desired: Oracle RAC, Oracle Data Guard, RMAN backups, Oracle Enterprise Monitoring (OEM), Oracle ZFS storage appliance
- Experience with Jira and Confluence
- Experience with Relational database design tools such as Power Designer
- Perform Database Administration (DBA) activities on a daily basis such as monitoring storage, database performance, and RMAN back up verification
- Ensure standby DataGuard databases are functioning properly with minimal lag time
- Develop strategies to migrate data between environments
- Identify and resolve database performance issues
- Support the database design, development, implementation, information storage and retrieval, data flow and analysis activities
- Support the analysis and evaluation of system improvements, optimization, development and/or maintenance efforts.
- Translate a set of requirements and data into a usable database schemas
- Create and update data models using PowerDesigner
- Assist in developing database structures that fit into the overall architecture of the system under development.
- Develop a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls.
- Direct the development of complex systems using queries, tables, Open -Database Connectivity and database storage and retrieval.