DBA

DBA

Duration: 12 months Location: Indianapolis, IN 46204

Required Skills:

• 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 Responsibilities: Manage 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.