Oracle DBA II

Job Details Location: Atlanta, GA 30346 – Position Type: Full Time 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. What You’ll Bring 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 AWS Certified Cloud Practitioner Oracle Cloud Database Service Professional What We Offer 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). #J-18808-Ljbffr