Associate Senior Database Administrator

Job Description

Summary

DescriptionSummary of This Role

Plans computerized databases, including base definition, structure, documentation, long-range requirements, operational guidelines and protection. Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries. Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of the system.

What Part Will You Play

- Assists more experienced Database Administrators (DBAs) with the testing of database software, utilities and patches, such as Oracle Real Application Clusters (RAC), Oracle Enterprise Manager (OEM), Data Guard, within a test environment. Assists in the migration of tested/approved database software, utilities, and patches to production. Begins to demonstrate a database administration acumen.
- Assists with the completion of authentication and authorization requests by creating/purging/maintaining user accounts, adding/deleting/modifying table and data permissions. Performs and/or setup scheduled database audit procedures to track the who/when changes are made or new items are created within the database environment.
- Assists in the scheduling of database back-up tasks. Observes and supports more experienced DBAs during a disaster recovery and/or recovery exercises to continue familiarization and knowledge of database recovery tasks. Develops a working knowledge of Oracle Recovery Manager, Data Guard and Golden Gate.
- Assists more experienced DBAs with storage and capacity planning by executing established reports, gathering additional data and occasionally performing basic routine maintenance such as data compression or defragmentation.
- Participates in database tuning, optimizing, and monitoring tasks by assisting more experienced DBAs with the execution of routine tasks such as monitoring query performance and rebuilding inconsistent and/or corrupt indexes. Develops a working knowledge of Automatic workload Repository (AWR) reports, Auto service Request (ASR) and OEM.
- Assists more experienced DBAs during application failures to further develop knowledge and application of troubleshooting techniques.
- Gathers data/reporting and assist with the production and maintenance of operational database documentation, such as Oracle Standard Operating Procedures documents, Disaster Recovery Plans, Recovery Presentation, Naming Standards, Performance and Tuning.

What Are We Looking For in This Role

Minimum Qualifications

- Bachelor&aposs Degree
- Relevant Experience or Degree in: No degree specified
- Typically Minimum 2 Years Relevant Exp
- With the Installation, Customization, Testing and Maintenance of database systems within a production environment.

Preferred Qualifications

- Bachelor&aposs Degree
- IT related field

What Are Our Desired Skills and Capabilities

- Skills / Knowledge - Developing professional expertise, applies company policies and procedures to resolve a variety of issues.
- Job Complexity - Works on problems of moderate scope where analysis of situations or data requires a review of a variety of factors. Exercises judgment within defined procedures and practices to determine appropriate action. Builds productive internal/external working relationships.
- Supervision - Normally receives general instructions on routine work, detailed instructions on new projects or assignments.
- DBMS Knowledge - Extensive Knowledge of multiple database disciplines and technologies
- DBMS Utilities - Extensive Knowledge of multiple utilities utilized to manage, monitor and maintain database systems
- DBMS Recovery - Extensive Knowledge of recovery technologies for local and geographically disperse systems

---