Oracle DBA II

MERIDIAN COOPERATIVE INC•Atlanta, GA

2d•Onsite

About The Position

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.

Requirements

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.

Nice To Haves

Oracle Certified Professional (OCP) – Database Administration
AWS Certified Cloud Practitioner
Oracle Cloud Database Service Professional

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.

Benefits

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).