Oracle Database Administrator jobs in Pennsylvania

About the Role

Donegal Insurance Group has an opening for an Oracle Database Administrator. As a member of our Information Services team, this position will help support expanding Oracle environments and ensure  database availability and performance consistent with required SLAs. The candidate will be responsible for the day-to-day Oracle Database administration across all Oracle environments.

Knowledge and experience with Oracle databases on Linux/Unix platforms, strong experience with Oracle advanced features such as Multitenant, RAC, ASM, Data Guard, RMAN (backup/data recovery), Oracle Advanced Compression, and Oracle Advanced Security Transparent Data Encryption (TDE).

This position requires working with all IS teams to ensure database availability and performance consistent with required SLAs.

Responsibilities and Duties

• Database Installation and Configuration:
  • Install and configure Oracle databases on Exadata Cloud at Customer infrastructure.
  • Ensure proper setup and configuration of database parameters to optimize performance and resource utilization
• Monitoring and Performance Tuning:
  • Monitor database performance and proactively identify and resolve performance issues.
  • Conduct performance tuning activities such as SQL optimization, index management, and database parameter tuning.
  • Implement and maintain monitoring solutions to ensure the availability and performance of databases.
• Backup and Recovery:
  • Implement backup and recovery strategies to ensure data integrity and availability.
  • Perform regular backups and validate the integrity of backup data.
  • Develop and maintain disaster recovery plans using Data Guard and conduct regular testing.
• Security and Compliance:
  • Implement and enforce security policies and access controls to safeguard sensitive data.
  • Ensure compliance with relevant regulatory requirements and industry standards.
  • Perform regular security audits and vulnerability assessments.
• Patch Management and Upgrades:
  • Plan and execute database patching and upgrades in accordance with best practices and vendor recommendations.
  • Coordinate with stakeholders to minimize downtime and ensure seamless transition during upgrades.
• Capacity Planning and Resource Management:
  • Monitor resource utilization and plan for capacity upgrades as needed.
  • Optimize resource allocation to ensure efficient utilization of Exadata infrastructure.
• Automation and Scripting:
  • Develop and maintain automation scripts to streamline routine tasks and processes.
  • Implement automation solutions for monitoring, alerting, and maintenance activities.
• Documentation and Knowledge Sharing:
  • Maintain comprehensive documentation of database configurations, procedures, and troubleshooting guides.
  • Share knowledge and best practices with team members and stakeholders.

Qualifications and Skills

• 6-8 years hands-on experience with Oracle databases on Linux/Unix Platform.
• Strong experience with Oracle advanced features such as Multitenant, RAC, ASM, Data Guard, RMAN (backup/data recovery), Oracle Advanced Compression, and Oracle Advanced Security Transparent Data Encryption (TDE).
• Strong experience in production support, resolution of complex operational issues, and performance issues in OLTP and Data Warehouse environments
• Experience in capacity planning and resource usage analysis
• Strong experience with Oracle Cloud Control (OEM): monitoring, alerting, job scheduling, etc.
• Strong Experience in Proof-of-Concept projects, testing and certification of new features
• 2-3 years of experience in Unix/Linux Basic Administration.
• Basic knowledge of automation scripting (UNIX, PowerShell).
• 2-3 years of experience with PL/SQL.
• Proficiency in managing Oracle databases on Exadata infrastructure
• Knowledge of Oracle and SQL ancillary tools such as TOAD, SSMS and SQL Developer.
• Ability to work on-call to provide 24-7 support for Production systems.
• Oracle 12c -19c Database Internals and Administration

To apply, please submit your resume and online application

Competitive Benefits Package

Donegal Insurance Group offers a comprehensive benefits package for all full-time, permanent positions including:

• Medical, Dental, and Vision Coverage: Available to you and your dependents. Coverage begins the first of the month after start date.
• 401(k) with the first 3% matched at 100%: the next 6% is matched at 50%
• Paid Time Off: Paid vacation, sick days, paid holidays, & bereavement days
• Career Development: Including college partnership discounts and industry designation(s) reimbursements

Additional benefits include company-paid basic life insurance; short & long-term disability insurance; employee stock purchase plan; and employee assistance program (EAP). Learn more about our full benefit offerings by visiting our Benefits page.

Who We Are

Donegal Insurance Group provides commercial and personal insurance products through a network of independent agents in 23 states and across several regions of the U.S. In Texas, Colorado, Utah, New Mexico and Arizona, business is conducted under the Mountain States Insurance Group name; and in Michigan, business is conducted under the Michigan Insurance name.

Headquartered in Lancaster County, Pennsylvania, along with four (4) regional offices located in: Athens, GA, Grand Rapids, MI, Albuquerque, NM, and Glen Allen, VA, our steady growth and successes have allowed us to establish a culture of which we're proud. Check out our Glassdoor profile where our rating speaks for itself:

By joining the Donegal family, you would be joining a team of dedicated, hard-working employees, all with a common goal of providing peace of mind to our policyholders and being There when it matters most.™.

Work Arrangement

Donegal Insurance Group has a variety of positions that are either onsite, hybrid, or remote. With each department and position being different, the work arrangement for a specific position will be reviewed with candidates during a initial phone screening. For a fully remote position, the ideal candidate must live within our Donegal footprint (Current approved states for remote work are: AL, AZ, CT, DE, FL, GA, IA, IL, IN, MA, MD, MI, MN, MO, NC, ND, NE, NH, NJ, NM, NY, OH, PA, SC, SD, TN, TX, UT, VA, WI, and, WV. Please note, this list is subject to change without notice.)

E-Verify

Donegal Insurance Group participates in E-Verify in the following states: Alabama, Arizona, Florida, Georgia, Louisiana, Mississippi, Nebraska, North Carolina, South Carolina, Tennessee, and Utah. If you reside in one of the listed states, please review the "Notice of E-Verify Participation" and the "Right to Work Poster" on the links below:

• Notice of E-Verify Participation Poster (English and Spanish)
• Right to Work Poster (English and Spanish)