Oracle DBA/SQL DBA, Lead Consultant, Lead Consultant -Oracle DBA

* Extensive experience in Oracle Database Installation (9i,10g,11gR2,12C,19C) , configuration
and administration on Linux, Sun OS , IBM AIX, & Windows Platform
* Experience in upgradation and migration of Oracle 10gR2 RAC, 11gR1 RAC to 11gR2 RAC.
* Maintenance and Support of Oracle Databases on Linux/AIX with 12c/19c RAC.
* Created DataGuard for the Disaster Recovery of the critical databases and monitoring the Log
shipping by writing shell/sql scripts.
* Actively Performed DR Drill by switchover and switchback activity successfully.
* Creating, Maintaining and monitoring the DB-LINKS created to integrate the different
environments.
* Cloning and Patching of Oracle Database
* Applied Oracle Database patches using OPATCH.
* Troubleshooting the Oracle bottleneck and resolving the performance issues related to
different application issues.
* Performing the Oracle database activities of creation of USERS, granting privilege, creating
roles.
* Maintaining the security of the database by properly adding or removing the roles/grants on
the objects.
* Designed database architecture and perform the Capacity planning on the databases as per the
application requirements.
* Troubleshooting END users issue related to Oracle Database
* Performing Administrative task using Oracle SQL like adding of datafiles, growth monitoring.
* Writing shell scripts to automate monitoring and performing daily database health checks.
* Planning and Managing Database backups
* Monitoring END Users Requests so that performance of the system is maintained
* Experienced In ITIL Framework And In Defining And Developing Processes And Process
Improvements For IT Service Management.
* Clone and Refresh Oracle Database.
* Successfully set up a two-node cluster and RAC database on Linux, IBM AIX and Exadata Server.
* Adding nodes to the existing cluster.
* Configuring and managing OCR and voting disk.
* Incident management, change management, problem management using ITSM tool.
* Backup and recovery strategy using RMAN.
* Creating RMAN scripts.
* Duplicating database using RMAN.
* Refresh database to a previous incarnation using RMAN.
* Hands on experience in Cross platform migration
* Optimizing database performance.
* Worked on 24/7 high availability environments.
* Knowledge of Oracle and UNIX Security and networking.
* Clone database using online/offline backup.

SQL DBA Activities:

* Creating and Administering the SQL Server Databases, managing the growth parameters and
database options.
* Resolving the Disk space issues and finding the root cause and permanent fixes.
* Experience in Database Consistency Checks using DBCC commands and checking server status using
DMV's.
* Experience in automation of SQL Server activities including jobs, maintenance plans.
* Migration of database between the servers and providing technical support for the business
users.
* Developed Backup strategies (Full, Differential, Transition log)for Database Recovery, backing
up database, backing up data files, log files, verifying the integrity of backup files.
* Verifying and resolving the SQL Server Blocking issues and Finding the root cause
* Maintaining High database availability for supporting non-stop Business Operations.
* Experience in applying the service packs and cumulative updates for servers.
* Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update
statistics and monthly maintenance plans such as clean up history etc. to run the databases
efficiently.
* Performing the Failover and Failback operations in the cluster environment and adding the new
Disks and troubleshooting activities.
* Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long
running queries and deadlocks.
* Hands on experience on monitoring tools like SCOM, SPOTLIGHT,ServiceNow.
* Good knowledge on SSIS and SSRS.
* Maintaining the SQL Server Stand-Alone and Failover cluster Instances.