Oracle DBA II

Meridian Cooperative is looking for an experienced Database Administrator II (DBA II) with 6-8 years of hands-on expertise in Oracle databases and cloud database platforms. The ideal candidate will be proficient in PL/SQL, performance tuning, backup/recovery, and automation, with exposure to AWS and OCI database services. Responsibilities

• Install, configure, patch, and upgrade Oracle databases across on-premises and cloud environments.
• Design, develop, and maintain PL/SQL procedures, functions, triggers, and packages.
• Write intermediate-level shell scripts with loops, conditionals, error handling, and logging to automate tasks.
• Design, implement, and validate backup/recovery strategies using RMAN; perform test recoveries and point-in-time recovery.
• Monitor and analyze performance using AWR, ASH, ADDM, and SQL Tuning Advisor; recommend indexing strategies.
• Experience with provisioning and managing databases on AWS RDS, EC2-hosted Oracle, and OCI DB Systems/Autonomous Databases.
• Implement security controls including roles, privileges, auditing policies, encryption (TDE), and user lifecycle management.
• Participate in data modeling and schema design reviews; recommend partitioning, indexing, and structure improvements.
• Perform routine Linux administration: file systems, permissions, process monitoring, and log rotation.
• Collaborate with developers, architects, and infrastructure teams to troubleshoot issues and deliver solutions.

Do you have a valid AWS Certified Cloud Practitioner - Foundational certification?, Do you have experience in System tuning?, * Advanced PL/SQL Development: Strong skills in writing and tuning procedures, functions, triggers, and packages.

• Intermediate Shell Scripting: Proficient with conditionals, loops, parameterization, and logging.
• Backup & Recovery Expertise: Solid hands-on experience with RMAN, Data Pump, cloning, and TSPITR scenarios.
• Performance Tuning Fundamentals: Knowledge of explain plans, indexing, AWR/ASH reports, and SQL optimization.
• Cloud Database Services: Hands-on experience with AWS RDS, EC2-hosted Oracle, and OCI Autonomous DB.
• Database Security Knowledge: Understanding of RBAC, auditing, TDE/SSL, and compliance frameworks.
• Data Modeling & Design: Knowledge of normalization, partitioning, schema optimization, and indexing strategies.
• Linux/Unix Administration: Skilled in using ps, top, vmstat, iostat, file system management, and cron jobs.
• Collaboration & Communication: Ability to work independently and coordinate with cross-functional teams.

Preferred Certifications Oracle Certified Professional (OCP) - Database Administration

Pulled from the full job description

• Health insurance
• Vision insurance
• Dental insurance
• Flexible spending account
• Life insurance, * Outstanding Medical/Dental/Vision that starts on the first day of employment.
• Education/Training Reimbursement
• Flexible Spending Account
• Health/Wellness Reimbursement (fitness tracking device one-time up to $300)
• Excellent Life Insurance & Disability
• Vacation: 22 days of accrued time off (no waiting period). 9 holidays which include the day after Thanksgiving & Christmas Eve. Up to 240 hours of vacation time can rollover to the following year.
• Volunteer Time: 8 hours per year
• Retirement: Robust 401K employees are 100% vested in the Company-funded employer basic contributions from the date they enter the plan. The Company will match 100% of each dollar you contribute on the first five percent (5%) of eligible compensation that you contribute to your account. Employer basic contribution eligibility occurs on the first day of the month following the employee’s completion of one year of continuous service (contribution of 4-11% of base salary based on years of service).

We were formed in 1976 by a group of Electric Membership Cooperatives with a vision for a single enterprise solution provider to serve data processing, IT, and operational needs to cooperatives, public utility districts, and municipal utilities. Through carefully curated acquisitions and partnerships, Meridian Co-op has unified multiple leading-edge companies under its umbrella in order to truly execute that vision. Today, the Meridian Suite serves over 500 utilities across the country with industry leading enterprise software solutions.