Associate Senior Database Administrator

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.

Roles and Responsibilities :

• 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

Preferred Qualifications

What Are Our Desired Skills and Capabilities

Skills Required

Database Administrator, Oem, Rac, Dbms, Database Systems, Testing