Data management – Oracle DBA with extensive familiarity with data management principles including
Manage large Oracle database environment
Configure and maintain database servers and processes
Monitor system's health and performance
Perform database backup – Recovery process
Restore lower environment databases with Production backup
Ensure high levels of performance, availability, sustainability and security
Assist developers with query tuning and schema refinement
Provide 24x7 support for critical production systems
Manage database alerts and respond to alerts
Perform code deployment as per company defined change management process
Synch code across all environments of databases
Management, configuration and troubleshooting of OUD
Support to Database specific OS configuration
Familiarity to Unix environment to support Oracle database running in Unix environment
Basic Unix command and parameters knowledge
Development Support –
Detailed knowledge of PL/SQL, packages and knowledge of Oracleprogramming objects
Develop and analyze Oracle Code objects such as Stored Proc, View, Function , Trigger etc and identify defects and recommend for performance tuning
Experience in performance tuning by suggesting index, stats, trace collection etc
High Availability Solution Support –
Extensive Knowledge of Real Application Cluster, Oracle Cluster, Oracle ASM instance. Knowledge should include installation, management and troubleshooting
Knowledge of Replication Data Guard, it should include installation, configuration, management and troubleshooting
Data Replication
Installation, management, troubleshooting of Oracle Golden Gate 19c
Environment Monitoring:
To proactively monitor the database systems to ensure secure services with minimum downtime
Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management
Setup alerts and set threshold to get right alerts
Monitor environment an setup alerts through OEM
Problem-solving skills – Oracle DBAs should be skilled creative and technical problem-solvers, able to isolate and resolve database issues in real time to maintain access and data integrity
Communication skills
Respond to issues in timely manner, clearly elaborate problem and propose solution
Communicate with application teams, listen and respond to their queries and concerns