Senior Associate

Job Title:

Senior Associate

Location:

Falls Church, VA, 22041, USA

Department:

Information Technology and Services

Skills:

ADBA with NoSQL (MongoDB) experience and Goldengate expertise, 5-10 years of experience

EXP REQ:

5 to 10 years

Educational Qualification(s):

Job Overview:

Looking for an ADBA with NoSQL (MongoDB) experience and Goldengate expertise.

Duties & Responsibilities::

Use OEM 13c/12c Grid to monitor Oracle Databases performance.
Understand Oracle Database and NoSQL (MongoDB) architecture.
Handle, configure, and administer Oracle and NoSQL (MongoDB) databases.
Perform Oracle Database maintenance tasks like gathering schema statistics, index rebuilding, and reorganizing tables.
Manage MongoDB sharding and replication.
Add and manage Oracle Goldengate processes and troubleshoot issues.
Tune Oracle Database instances and optimize SQL queries using tools like TKPROF and EXPLAIN PLAN.
Use Oracle DataPump Utility for logical backups and database migration.
Install, patch, troubleshoot, track/tune performance, and handle backup and recovery for Oracle and MongoDB.
Manage MongoDB lifecycle, including sizing, automation, monitoring, and tuning.
Use MongoDB Compass Tool.
Manage large shared MongoDB clusters.
Perform sanity tests of database performance after system/application deployment.
Work with Oracle support for complex issues like bugs and Goldengate problems.
Monitor and diagnose Oracle database performance with AWR, ADDM, and ASH reports.
Monitor CPU and memory utilization, identify top SQL sessions, and troubleshoot performance issues.
Knowledge of Oracle Data Guard (Standby) and Oracle RAC.
Manage profiles, roles, privileges, user management, tablespaces, control files, and redo logs.
Understand table partitioning methods (Hash, List, and Range Partitions).
Proficient with Unix and Linux commands and shell scripting.

Minimum Requirements:

Hands-on experience as an ADBA with NoSQL (MongoDB) experience and Goldengate expertise.