Oracle Database Administrator
*Local within 2 hours of Harrisburg, PA only please
*This is a primarily remote position with occasional onsite requirements when needed
Description:
- We are seeking an experienced Oracle Database Administrator (DBA) to manage and maintain our mission-critical Oracle 19c environment running on Red Hat Enterprise Linux RHEL.
- The ideal candidate will have deep expertise in Oracle RAC and ASM and the ability to work independently on routine maintenance as well as specialized tasks.
Responsibilities:
- Perform routine and advanced database administration tasks for Oracle 19c RAC and ASM environments.
- Implement and maintain database backup and recovery procedures ensuring data integrity and security.
- Manage access security database integrity and physical data storage design.
- Oversee data storage management and supervise performance tuning activities.
- Author shell scripts for backup restore and monitoring tasks.
- Monitor database performance space requirements and optimize system resources.
- Identify and track issues risks and action items provide accurate and timely status updates.
- Assist in coordinating software releases and upgrades.
- Ensure compliance with quality standards and best practices.
- Work collaboratively in a team environment while being capable of independent execution of tasks.
Required Technical Skills:
- Oracle RAC and ASM administration expertise.
- Strong knowledge of Oracle 19c architecture and features Including Pluggable Databases PDBs.
- Proficiency in Linux RHEL shell scripting.
- RMAN Recovery Manager for backup and restore operations.
- Performance tuning at both database and SQL query level.
- SQL and PL/SQL scripting for automation and troubleshooting.
- Patch management and applying PSU/CPU updates.
- Familiarity with OEM AWR ADDM and ASH reports for monitoring and diagnostics.
- Security hardening and compliance encryption auditing.
- Capacity planning and forecasting for database growth.
Preferred Skills/Knowledge/Experience:
- Experience with Oracle Data Guard for disaster recovery and high availability.
- Experience with UDEV configuration for ASM devices.
- Exposure to cloud-based Oracle deployments.
- Knowledge of automation tools for database operations
Soft Skills:
- Strong analytical and problem-solving skills for diagnosing complex issues.
- Excellent documentation skills for procedures and standards.
- Effective communication skills for reporting and collaboration.
- Ability to manage time and priorities in a fast-paced environment.
Required Skills/Knowledge/Experience:
- Oracle RAC and ASM administration expertise, Required
- Strong knowledge of Oracle 19c architecture and features, including Pluggable Databases, Required
- Proficiency in Linux (RHEL) shell scripting, Required
- Recovery Manager experience for backup and restore operations, Required
- Performance tuning experience at both database and SQL query level, Required
- SQL and PL/SQL scripting experience for automation and troubleshooting, Required
- PATCH management experience and applying PSU/CPU updates, Required
- Familiarity with OEM, AWR, ADDM and ASH reports for monitoring and diagnostics, Required
- Experience with Oracle Data gaurd for disaster recovery and high availability, Desired
- Experience with UDEV configuration for ASM devices, Desired
- Exposure to cloud-based Oracle deployments, Desired
- Knowledge of automation tools for database operations, Desired
Proper email communication will only be done to and from @astyra.com email addresses. Please ensure you are communicating with approved Astyra recruiters by checking this point when receiving offers and messages from us. Please ensure you are communicating within these guidelines and proper channels for the quickest possible interview consideration!
#AC