Oracle DBA (Mphasis)

• Database Administrators are responsible for understanding, configuring, and managing database administration tools
• -Provides database support for business applications and schedules back up jobs for user databases
• -Provides access control (password resets /account creation/deletion) and checks IP compliance (violation report review, compliance updates and compliance set ups)
• -Performs data purging and data replication activities
• -Researches on connectivity issues and recurring errors in Application database
• -Responds to database alerts and takes appropriate actions
• -Provides 24x7 support
• -Performs database creations
• -Performs performance tuning and troubleshooting for database
• -Performs application database maintenance and provides technical assistance to users
• -Manages database account access and database object changes
• -Ensures that monitoring and alerts are properly in place to meet monitoring requirements
• -Performs database recovery from logs, hot & cold backups, Export/Imports and Disaster Recovery
• -Performs database creation decommissioning and database updates/migrations to a higher/lower version or cross platform migrations
• Also involved in database, schema, and object refresh activities
• -Monitors and reports existing database Instance, Database, Server activities for CPU, Memory, and Cach, logs performance, and recommends effective resource utilization/emergency recovery procedures Plans, schedules, and implements operating system software installs and patches (including 3rd party tools) using change management and release management processes
• -Implements database security and auditing features and periodic reviews
• Conducts root cause analysis for repeated incidents
• -implements and performs configuration management of database cluster and replications

Skill Requirements:

• 8+ years of Oracle DBA experience
• Experience in Oracle Golden Gate, Oracle Datagaurd and Oracle RAC is must
• Experience in Oracle 11g, 12c, 19c
• Should have a strong understanding of Oracle Database Concepts, Installation, Patching, Cloning and System Administration work.
• Should be able to perform DBA activities like instance tuning, schema management, space management, backup and recovery, disaster recovery, database refresh
• Should have good experience to performance tuning
• Setting up and monitoring database alerts through OEM / CRONTAB.
• Setting up & Monitoring Replication (Oracle GoldenGate).
• Setting up, Monitoring & troubleshooting Dataguard & RAC.
• User management
• Space management
• SQL tuning
• Backup and Recovery
• Troubleshooting end-to-end database issues in a RAC environment
• Performance tuning of the Oracle database itself - especially in RAC configurations
• Tuning of SQL performance, with emphasis on reducing disk IO and total query execution time
• Specifying and creating partitioned tables and their indexes; migrating heap-organized tables to partitioned tables online
• Configuring Oracle Enterprise Manager in a large, production environment; creating User-defined Metrics, managing and deploying monitoring templates based on database attributes, using emcli to effect mass changes efficiently
• Configuring and managing Oracle Data Guard physical standby database environments which include FarSync and multiple sites
• Disaster Recovery Management

Behavioral Skills:

• Excellent verbal, presentation, communication, and critical thinking skills.
• Strong analytical, problem solving, organizational and planning skills.

Qualification:

• Bachelor/Master degree from reputed university
• Any relevant certification would be a plus