DBA

Deloitte Dynamic Talent Solutions•Indianapolis, IN

10h•Onsite

About The Position

This role involves managing day-to-day database operations, maintaining schema objects, and ensuring database and security standards. The DBA will be responsible for the maintenance and monitoring of all databases, supporting various application teams, releases, and projects. Key tasks include identifying and tuning performance bottlenecks, user administration and maintenance, and schema refreshes. The position requires strong skills in database design, performance tuning, and scripting, with a focus on Oracle Database versions and Exadata platforms.

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

Nice To Haves

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