Oracle Database Administrator

Oracle Database Administrator

West Advanced Technologies (WATI)

Annapolis, MD • On-site

$50.25 - $68.25/hr

Full-time

Posted 24 days ago


Job description

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



Frequently asked questions

Q: What skills or qualities help someone succeed as a Oracle Database Administrator?

A: To succeed as an Oracle Database Administrator, key technical skills include proficiency in Oracle database management systems, such as database design, implementation, and performance tuning, as well as expertise in SQL, PL/SQL, and Oracle tools like SQL Developer and Enterprise Manager. Additionally, strong analytical and problem-solving skills, along with the ability to communicate complex technical information to non-technical stakeholders, are essential soft skills for success in this role. By combining these technical and soft skills, Oracle Database Administrators can effectively manage and optimize database performance, ensuring high availability and reliability, and driving business growth and success.

Q: What is the career path for a Oracle Database Administrator?

A: A typical career path for an Oracle Database Administrator (DBA) involves progression from entry-level roles such as Junior DBA or Database Support Specialist, to mid-level positions like Senior DBA or Database Architect, and ultimately to senior leadership roles like Database Manager or Enterprise Architect. Key opportunities for skill development and growth include mastering Oracle database technologies, learning cloud computing and DevOps practices, and developing expertise in data security, performance tuning, and high availability. Long-term career prospects for DBAs may include transitioning into related fields such as data science, business intelligence, or IT management, or pursuing specialized roles like Oracle Cloud Infrastructure (OCI) or Oracle Exadata expert.



West Advanced Technologies (WATI) job posting for a Oracle Database Administrator in Annapolis, MD with a salary of $50 to $68 Hourly with a map of Annapolis location.