DBA

Kids for the Future; Indianapolis (IN); On-site; USD 90,000 - 140,000; Full time

Job summary

RCR Technology is seeking a Database Administrator to manage day-to-day Oracle DB operations, maintain schemas, and enforce security standards across multiple applications.

You will plan and execute migrations, patching, and backups while tuning performance and resolving complex issues. Strong SQL, PL/SQL, and scripting skills are required for a reliable, scalable data layer.

Qualifications

• 5-7 years of DBA experience with complex migrations (prefer Exadata or On-Prem-to-Cloud).
• Experience configuring Data Guard and automated switchovers/failovers via Data Guard Broker.
• Experience with GoldenGate installation and replication.
• Quarterly Exadata patching across DB, GI, storage, and firmware.
• Experience with Oracle DB versions 11g, 12c, 19c; strong logical/physical design skills.
• Strong SQL and database issue resolution skills (deadlocks, waits, contention).
• Experience with RMAN backups and performance tuning; AWR/ ADDM reports.
• Shell scripting for backups, schema refreshes and maintenance jobs.
• Experience with OEM monitoring/alerting and Data-Pump utilities.
• Bachelor's degree or equivalent experience.

Responsibilities

• Manage day-to-day database operations and enforce security standards.
• Maintain schema objects and ensure performance across multiple apps.
• Plan and execute migrations, patches, and upgrades with minimal downtime.
• Administer users, perform schema refreshes, and monitor database health.
• Collaborate with development and testing teams across releases and projects.

Skills

Oracle DBA

Exadata

Data Guard

GoldenGate

RMAN backups

Performance tuning

SQL

Shell scripting

PL/SQL

Monitoring with OEM

Education

Bachelor's degree or equivalent experience

Tools

OEM

Data Pump

RMAN

Job description

• Location 9365 Counselors Row,Suite 116,Indianapolis, IN, 46240,United States
• Employee Type FT Non-Exempt
• Required Degree 4 Year Degree

Description

RCR Technology is seeking a DBA to m anage day-to-day database operations, maintain schema objects, database and security standards Maintenance and Monitoring of all Databases, supporting different application teams, releases and projects, identifying and tuning performance bottlenecks, user administration and maintenance, Schema refreshes, etc.

Requirements

• 5-7 Years of experience as a DBA Proven track record of executing at least one complex database migration, preferably involving Exadata platforms or On-Premises-to-Cloud movements.
• Experience in configuring advanced Data Guard. Configure and test automated database Switchovers and Failovers using Data Guard Broker to ensure minimal-downtime cutovers.
• Experience in Golden gate installation, Configuring Exacts, Replicates etc. Design and maintain enterprise backup architectures utilizing RMAN, optimizing parameters like channel parallelism, SECTION SIZE, and Block Change Tracking (BCT).
• Proven experience planning and executing quarterly full-stack Exadata patching, including the database layer, Grid Infrastructure (GI), storage cell software, InfiniBand/RoCE switches, and server firmware.
• Experience in Oracle Database versions (11g,12c,19c) Strong skills in both logical and physical database design/modeling.
• Strong skills in identifying and fixing database issues, related to deadlocks, application locks and waits, contentions, etc.
• Strong skills in SQL
• Performance tuning of inefficient queries.
• Experience in Database Performance Tuning using AWR/ADDM reports.
• Strong skills in maintaining multiple databases and support development, testing and performance teams.
• Strong skills in writing Stored Procedures, Packages, Triggers, Views, etc. PL/SQL skills.
• Experience in writing shell/batch scripts for processes like backups, schema refreshes, Wait and lock alerts, Maintenance jobs, etc.
• Experience with OEM monitoring and alerting Experience in Oracle Data-Pump utility Capacity planning, User management
• Bachelor's degree or equivalent experience

Preferred Skills:

• Oracle certifications are a plus Data Masking, Exadata, Golden Gate experience.
• Ability to adapt quickly to an existing, complex environment.
• Ability to quickly learn new concepts is necessary.
• Candidate should be self-motivated, independent, detail oriented, responsible team-player and exhibit exceptional relationship management skills.
• Strong communication skills, both written and oral.
• Passionate about building high-quality systems with software implementation best practices while leading and mentoring a team of developers.
• Ability to understand methodologies and tools used for delivery and display a passion to follow and devise processes for improving quality.
• Ability to multi-task & support multiple priorities / multiple deliverables.
• Ability to understand requirements and turn them to useful client deliverables using a team.
• Strong Analytical and Problem-Solving Skills.
• Experience with JEE/WEB applications are a plus