DBA

Database Administration:

Installing, configuring, and upgrading Oracle RDBMS/RAC and MongoDB software.

Application Support:

Working closely with development teams to optimize SQL queries, PL/SQL, and MongoDB aggregation pipelines.

Performance Tuning:

Monitoring alert logs, memory, disk I/O, and CPU to ensure optimal performance of both systems.

Data Protection:

Managing backup/recovery strategies, including RMAN-managed recovery and MongoDB backups.

Security & Compliance:

Managing user access, privileges, roles, and auditing.

Daily & Weekly ActivitiesMonitoring & Health Checks:

Utilizing Oracle Enterprise Manager (OEM) and MongoDB tools to check for errors, space constraints, and resource consumption.

Performance Tuning:

Tuning SQL queries, creating SQL Profiles or Baselines, and creating indexes for performance improvements.

Schema & Object Management:

Managing tablespaces, tables, synonyms, roles, and sequences.

Change Management:

Migrating schema changes across development, testing, and production environments.

Backup Verification:

Reviewing backup logs to ensure data integrity and successful completion.

Troubleshooting:

Resolving locking issues, high CPU usage, and application connectivity problems.

Database Security:

Implementing security policies, such as Oracle Transparent Data Encryption (TDE).

Key Technical Skills Oracle:

RAC (Real Application Clusters), RMAN, ASM, Data Guard, SQL, PL/SQL.

MongoDB:

Replica Sets, Sharding, Ops Manager/Cloud Manager.

Tools:

OEM, Unix Shell Scripting, Python.

Environment:

Linux/Unix. This is Senior role with multiple years of experience supporting relational and NoSQL databases.

Experience in 24x7 production environments is desired.