Oracle Database Administrator

Annapolis, MD

12+ months

Mandatory Skills:

Bachelor's degree in an Information Technology (IT) related field.

Ten (10) years of Oracle Database Administrator experience, including Oracle RAC Databases and high availability architecture in test and production 24x7 environments.

Should have certifications from Oracle in one (1) or more than one (1) of the following subject matter areas:

o Oracle Database Administration

o Oracle Exadata

o Oracle PeopleSoft

Preferred Skills:

Expert knowledge of the following:

 Oracle Database 12c and 19c administration.

 Oracle Enterprise Manager regarding installation, configuration, tuning, patching and license management.

Experience with the following:

 RMAN backup and recovery tasks.

 Oracle database auditing of privileges, roles, critical tables, and logging.

 Shell scripting.

 High Availability and Disaster Recovery environments.

 Oracle Transparent Data Encryption and Data Masking.

 Oracle Data Guard (Active/Passive and Active/Active) and licensing.

 Backup & Recovery, Data Guard, and cloning of Oracle databases.

 PL/SQL, SQL, Database Links and scripting languages

 Oracle Audit of Oracle databases regarding privileges, roles, profiles, and access logging for security compliance.

 Configuring and maintaining WebLogic application servers.

 Oracle PeopleSoft database environments and methods to refresh dev, test, qa, uat, and training databases.

Familiarity with RHEL 7 and RHEL 8 virtual servers.

Knowledge of Oracle database partitioning.

Diagnostic and tuning skills for resolving Oracle production database issues quickly.

Ability to:

 Write shell scripts to automate daily database refresh tasks

 Communicate effectively orally and writing. Writing shall include technical communication to non-technical staff, and explanations of technical solutions to database problems.

 Establish and maintain effective working relationship with peers, end users and vendor development staff, as well as all levels of management and judicial personnel as necessary.

 Lift personal computers, printers, scanner, and other equipment associated with a standard computer workstation (with reasonable accommodation)

Responsibilities:

Mange monitors, maintain, upgrade and patch 100 Oracle databases in a fast-paced production environment.

Install, configure, patch and upgrade Oracle 12c and Oracle 19c databases.

Assist PeopleSoft application server administrators with the install, patch, configuration, monitor, and upgrade of PeopleSoft architectural components.

Monitor Oracle and PeopleSoft database batch jobs.

Diagnose and tune production databases.

Create & maintain Oracle database users, privileges, and permissions.

Maintain functional IDs and passwords.

Configure and administer Audit log and security compliance.

Implement Transparent Data Encryption on critical tables.

Backup, Recover, Refresh, and Clone database environments.

Import and export security and other components into refreshed environments.

Mask and obfuscate all private data in training environments.

Allocate and expand ASM disk for all RAC databases.

Collaborating with Application Developers and Security personnel.

Provide afterhours support 24x7 for maintenance and upgrade work

Regards

Naresh Damagalla

West Advanced Technologies, Inc

E: naresh.d@wati.com D: 279-666-5838 M: 916-694-5317

Serving government agencies for 22 Years

www.wati.com