Senior Associate

Position

Senior Associate

Department

Information Technology And Services

Skills Required

ADBA with NoSQL - Mongo DB experience/admin skill with Goldengate expertise. Exp: 5-10 years

Experience Required

5 year - 10 year

Educational Qualification(s) Required

Bachelor of Engineering / Master of Engineering

Overview of Job

ADBA with NoSQL - Mongo DB experience/admin skill with Goldengate expertise.

Duties & Responsibilities

• Expertise in OEM 13c/12c Grid to monitor all the Oracle Databases performance.
• Good understanding of Oracle Database and NoSQL databases(MongoDB) Architecture.
• Expertise in handling, configuration and administration of databases like Oracle and NoSQL (databases like MongoDB) .
• Expertise in Oracle Database Maintenance related activities like Gather Schema Statistics, Index rebuilding,Re-org tables etc.
• Expertise in Sharding and Replication future of MongoDB.
• Expertise in Oracle Goldengate( Add Extract,DataPump and Raplicat processes) & troubleshoot Oracle Goldengate issues.
• Expertise in Oracle Database instance tuning and SQL query optimization for better application performance using various Tools like TKPROF, EXPLAIN PLAN, optimizer hints.
• Expertise in Oracle DataPump Utility for Logical backup and Database migration.
• Experience in Oracle and MongoDB installation, patching, troubleshooting, performance, tracking/tuning, backup and recovery in dynamic environments.
• Experience in managing life cycle of MongoDB including sizing, automation, monitoring and tuning.
• Experience of MongoDB compass Tool.
• Experience in managing large shared MongoDB cluster.
• Experience in sanity test of a database performance across entire application once the system /application is deployed on production environment.
• Experience to work with Oracle Co. for complex issues like oracle Bugs and Oracle GoldenGate issues.
• Monitor applications in production environments and provide real time support for analyzing and troubleshooting issues.
• Monitor and diagnose Oracle database performance through monitoring of AWR, ADDM, ASH reports.
• Familiar with monitoring of CPU and Memory Utilization, identifying top SQL sessions, long running requests in OEM and troubleshooting of various performance issues.
• Knowledge of Oracle Data Guard (Standby), Oracle RAC.
• Knowledge of Profiles, Roles, Privileges, User Management, Managing Tablespace, Control file and Redo logs.
• Knowledge of table partitions methods(Hash,List and Range Partitions)
• Knowledge of Unix and Linux commands and shell scripting.

Minimum Requirements

Hand on Experience on ADBA with NoSQL - Mongo DB experience/admin skill with Goldengate expertise

Work Location

United States- Chicago/Schaumburg (IL) / Dallas (TX) / Atlanta/Alpharetta (GA)

Working Model

Work from Office.

You should be open to working on-site at our locations or client sites. Remote work may be available — apply now and check with the recruiter.

Apply from Locations

New York NY / Los Angeles CA / Chicago IL / Houston TX / Phoenix AZ / Philadelphia PA / San Antonio TX / San Diego CA / Dallas TX / Jacksonville FL / Austin TX / Fort Worth TX / San Jose CA / Columbus OH / Charlotte NC