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.