We are seeking an experienced Oracle DBA with strong hands on expertise in administering and supporting Oracle 19c databases in production environments. The ideal candidate will be responsible for database administration, performance tuning, security, and operational support while ensuring high availability and data integrity across environments.
Job Title: Oracle DBA
Location: Mechanicsburg, PA 17050
Position: 1
Work Arrangement: Onsite
Responsibilities:
Administer and support Oracle Database 19c in enterprise production environments.
Perform database installation, configuration, and ongoing maintenance activities.
Coordinate database patching and perform routine database health checks.
Implement and maintain table partitioning strategies to improve performance and manageability.
Enable and manage table compression to optimize storage and enhance database performance.
Support data masking activities for non production database refreshes to meet compliance requirements.
Conduct end to end performance tuning including analysis of wait events, AWR and ASH reports, SQL optimization, statistics management, and parameter tuning.
Develop and maintain PL SQL stored procedures and related database objects as required.
Manage database backup and recovery processes including restoration validation and refresh activities across multiple environments.
Provide operational support and troubleshooting to ensure database stability and availability.
Required Skills:
Oracle Database Administration (Oracle 19c)
PL SQL and Stored Procedures
Database Backup and Recovery
Database Refresh and Restoration
Performance Tuning and Optimization
Database Partitioning and Compression
Never miss an opportunity! Create an alert based on the job you applied for.