Senior Database Specialist
NTT DATA Global Delivery Services
Total years of experience :13 years, 4 Months
Oracle 19c, 12c, 11g, SQL servers (2008, 2012, 2019)
•Responsible for monitoring the 19c, 18c, 12c, 11g Databases like RAC, Data guard Health Monitor, OEM alert, and resolving the performance tuning issues..
•Performance Exadata Patching Quarter rack X7 -Machine and X-6 in Rolling fashion & Upgrades to databases 19c.
•Up gradations databases from 12c to 19c database OS like Salaries and Linux systems .
•Monitoring the Golden Gate Oracle to Oracle Lags, Abended process, and if needed configuration ends.
•Experience in PSU patching Rolling/Non-Rolling fashion for RAC environment.
•Performance of Data Guard using Data guard Broker(DGMGRL) Switchover and Switch back to the depending up Client requirement.
•Troubleshooting for Database issue fetch the AWR Reports & analyzing issue .
•Troubleshooting for Long running jobs in database level, Check the plans if improve the SQL Query executions create sql-patch and SQL Profile .
•Trouble shooting for the performance issues like long running jobs, database issues.
•Monitoring the Golden Gate veridata jobs, if any job out-of-sync or Failed need to troubleshooting.
•Monitoring the Long-running sessions, Blocking sessions, Locks, Invalid objects in troubleshooting in PROD/Model.
•Experience in Bank operations EOD and BOD process.
•Monitoring the Banking EOD Process on Prod/Model Environment using the Control -M tool.
•Performance issues like Long-running sessions, DB health monitors.
•Regular monitoring OEM alerts &troubleshooting for based on ORA-errors.
•Working in Performance Tuning at various levels including instance tuning, Query tuning, using tools like TOAD, OEM and EXPLAIN PLAN for optimized results.Performed database object sizing, rebuilding indexes, fragmenting data blocks of table spaces, partitioned large tables and space allocation.
•Maintained the Prod/Non Prod, DEV, UAT relevant databases .
•Managing the single Node RAC AND 2-Node RAC, 4-Node on Oracle databases.
•Prepared the documentation Standard operation Procedures (SOP).
•Experience in Installation, Configuration on Oracle Exadata Database Machine Quarter Rack X5-2 and X6-2.
•Experience in Non Rolling PSU patch installation(RDBMS, GRID Home, CELL Nodes) on Quatar Rack Exadata.
•Troubleshooting the issues, depends up on Severity raised on Incidents, tickets on Exadata System Databases.
•Have a good experience in Golden Gate replication technology.
•Experience in installation Golden Gate, configuration, maintenance Uni-Directional Oracle Golden Gate Databases.
•Experience on Oracle 12c RAC Installation & configuration and Installation of 12c Standalone databases .
•Expert proficiency in installation, upgradation, maintenance and administration of multiple Oracle Enterprise Editions 10g, 11g & 12c databases in OEL(Oracle Enterprise Linux) and Red Hat Enterprise Linux.
•Experience in configuring ASM Disks &ASM database creation.ASM Disk group addition and deletion on Grid &ASMCMD Command line.
•Performance of Data Guard using Data guard Broker(DGMGRL) Switchover and Switch back to the depending up Client requirement.
•Monitoring the scheduled backup every days
•Experienced in testing Disaster Recovery implementations in enterprise level.
•Proficient in installation, configuration Data Guard using RMAN utilities switchover &switch back and Failover(FSFO).
•Proficient in using Oracle utilities i.e. Export/import, Data Pump, ASMCMD, TOAD, SQL Developer.
•Knowledge Experience Delphix, vertex tools.
•Good knowledge Splunk and Control-M, Jenkins, Datical, BI tools and Release Jenkins’.
•Experience of ITIL management like Daily, Incidents, Changes, Requests, Problem Management Tickets and attending the CAB Meeting with Customers..
•Knowledge Experience AWS Cloud Compute EC2, Storage S3, Database & Monitoring tools Splunk, Jenkins
Worked as a Wipro Ltd (Payroll of Team Lease Digital )as a Senior Consultant DBA Kochi, Kerala (2 year 3 months).
End Client : South Indian Bank-Datacenter (Kochi )
Domain : Finance Bank
Skills :Oracle 10g, 11g, 12c, Golden Gate, Exadata x-5
Experience in installation, configuration and maintenance of Uni-Directional Oracle Golden Gate Databases.
Configure the Oracle Golden Gate V12.1.2.1.0 for Oracle on Linux x86-64 in a Environment..
Daily health check of Table and Schema Level Databases Golden Gate.
Configured oracle-to-oracle unidirectional replication.
Resolved replication issues in Confidential
Tuned GG to handle large volumes of data for high transaction tables.
Maintain the larger databases 10TB and 6 TB and 1 TB sizes of Databases .
Consolidated tables and enabled GG replication by application segregation.
Database Security product implementation & migration (Oracle TDE (Column & Tablespace), Oracle Wallets, Database Vault, Database Firewall.
Configured the schema level replication with and without pump process.
Configured the column level replication setup using defend parameter file.
Performed Instantiations using exp/imp and expdp/impdp at table level.
Installing & configuring Oracle clusterware& Database Software
Troubleshooting using cluvfy& handling common issues that arise during integration
Resolving bugs, network issues, configuration files issues, OCR issue, deinstallation &cleanup of cluster ware
Worked with on RAC resolutions on split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss
Provided Heterogeneous environment support
Troubleshoot performance issues for the RAC instances
Applying the patches for Red-Hat Linux and Windows Servers Databases.
Performance of Data Guard using Data guard Broker(DGMGRL) Switchover and Switch back (OR)Manually the depending up Client requirement.
Expert on Testing of Prod-Standby databases for Failover &Fail Back Activities Quarterly.
Quarterly Disaster Recovery purposes all Production databases moving to the DR Setup.
Restore the Data all backup servers for Quarterly.
Upgraded the databases from 11.2.0.3 to 11.2.0.4 and 12.1.2.0.3 Upgraded single instance Databases to RAC databases
Managing the single Node RAC and 2-Node RAC, 3-Node RAC on Oracle 11g databases .
Apply the PSU, CPU Patches on Releases versions of Oracle .
Monitoring the Backups and Scheduling backups on Symantec Net Backup Server.
Experience on Bank operations EOD and BOD process.
Worked at Bitech International LLC as a Database Administrator Dubai, UAE(2 Years 1month )
Client :Etisalat
Location :Dubai
Expert proficiency in installation, up gradation, maintenance and administration of multiple Oracle Enterprise Editions 10g, 11g & 12c databases in OEL(Oracle Enterprise Linux) and Red Hat Enterprise Linux.
Configuration and management of databases on Physical Data guard set up.
Monitoring the Database in Oracle Enterprise Manager 12c & OEM 13c.
Installation and Configuration the Data guard set up Primary and Standby databases.
Performance of Oracle Database Appliances, ODA V1 and ODA X3-2, ODA X5-2.
Using Data Guard Broker configure the 2 or More Standby Databases environment.
Performing the Logs and sequence number in Primary and Standby Databases.
Perform the Switchover and switch back activity depending up on client requirement.
Expert on implementation knowledge on Stand-by databases for fail-over and recovery.
Increase the Oracle Database availability with Fast start Failover(FSFO).
Quarterly ODA Patch upgradation to OS level &Firmware&Grid In fracture(Gi)&Database level V1, X-3, X-5-2.
Expert on ODA patch upgradation of 12.1.2.4.0 to 12.1.2.5.0 and 12.1.2.6.0
Quarterly Disaster Recovery purposes all Production databases moving to the DR Setup.
Upgraded the databases from 10.2.0.5 to 11.2.0.2 and 11.2.0.3. 11.2.0.4, 11.2.0.15Upgraded single instance Databases to RAC databases.
Managed the 2-Node and Single Node RAC oracle database .
Responsible for taking knowledge sessions to other team members.
Take the Back up of all Databases using Datapump EXPDP and IMPDP (EXPORT, IMPORT) and RMAN Tools.
Daily Check the all databases Replication primary to secondary.
Creating and dropping of users, granting and revoking privileges as per Business requirement.
Responsible for patching Grid Homes, RDBMS Homes, Compute nodes, Cell nodes, Virtual Machines &InfiniBand switches.
Worked at L&T infotech(C2H-Dhrv Consultancy Services ) Senior Database Administrator Bangalore, India. ( 4 years 2 months ).
End Client: YES BANK (Banking & Financial)
Location: Bangalore
Responsible for Installation, administration, and upgrade of Oracle RAC Grid Infrastructure & standalone 10g &11g production and development databases. Providing 24x7 on call support for production database issues.
Upgraded the databases from 9.2.0.8 to 10.2.0.5 & 10.2.0.5 to 11.2.0.2 and 11.2.0.3. Upgraded single instance Databases to RAC databases.
Involved in database migration from single instance to 6nodesRAC Database.
Creation and Configuring Services using SRVCTL for application specific.
Created and Managing Standby Databases for Disaster recovery.
Good working and implementation knowledge on Stand-by databases for fail-over and recovery.
Managing tnsnames file with IFILE’s for easy administration.
Developed and implemented new backup policies with scheduled shell scripts..
Loaded data into staging tables using SQLLDR, automated data loading using shell scripts(Linux Shell).
Restore the backup data using Recovery manager.
Responsible for Quarterly PSU patch testing and implementing DEV, QA, UAT and PROD environments.
Working in Performance Tuning at various levels including instance tuning, Query tuning, using tools likeTOAD, OEM and EXPLAIN PLAN for optimized results. Performed database object sizing, rebuilding indexes, fragmenting data blocks of table spaces, partitioned large tablesand space allocation.
Responsible for monitoring the alert logs and resolving if any issues. For unresolved issues follow-up with Oracle
courses: ORACLE CERTIFICATIONS •Oracle Certified Professional 12c(OCP) •Oracle Certified Professional 11g(OCP)