SUMMARY:

• Having 9 years of experience in IT Industry on various roles with DBA with delivery roles.
• Currently working with Confidential Canada with Investment firm.
• Oracle database Administrator.
• Customer success/relation.
• Service Delivery.
• Team building.
• ITIL Management
• Good knowledge on Database Architecture
• Maintaining Tablespaces, Storage management, Undo Management
• Creating and Assigning Roles, Privileges and Profiles to Users .
• Logical Backups using Export/import (Backups - Regular and Incremental)
• Experience in oracle compliance management ( auditing ) .
• Developing various database backup & recovery strategies using Cold Backup & Hot Backup
• Configuration and working with RMAN (Recovery Manager)
• Extensive knowledge on Oracle Enterprise Manager design, configure and implementation .
• Experience in installing the OEM agents in target databases using push and pull methods .
• Experience in installing OMR for single node databases .
• Experience in installing exadata plug ins
• Performed database cloning through RMAN.
• Working on ASM mechanisms. (Automatic Storage Management)
• Database Reorganization.
• Creating indexes and rebuilding indexes for better performance
• Collecting and analyzing database performance through AWR and ADDM Reports.
• Creation of databases for new applications as per the application requirements
• Upgrading the databases as per the TSD given by Architect.
• Working on RAC instances.
• Working data guard environment.
• Working under the environment of 24X7 DBA support and on call support.
• Configuration and Working on Oracle 11g R2 streams.
• Basic Knowledge on Exadata systems.
• Impressive in adopting new oracle releases and New Oracle concepts.
• Working on Multi node and single Node cluster environment
• Working on Complex Golden gate environment
• Working on replication heterogeneous RDBMS like streams and golden gate.
• Having knowledge on AWS and Azure cloud Dabs .

WORK EXPERIENCE:

Confidential

Ontario Teachers

Responsibilities:

• Guaranteed availability for IT Department bymanagingGlobal Master Databases ofentire investment business to make sure trading and investments are happening on time.
• Point of contact of whole database systems for technical and delivery responsibilities.
• Understand and gather the technical requirements and making sure the requirements are executed on time.
• Prepare and create SOPs for the critical migration and upgrade plans for smooth executions.
• Involving and part of the database architectural strategy discussions and deriving the strategy approach for smooth operations.
• Planning the best usage of non prod environments of enterprise database across different programs.
• Propose and identify the key areas of time consuming areas and provide the SIP plans and give inputs to automation team to make sure build and regular BAU activities are completed with less time and very quick.
• Acting as single point of contact for entire offshore delivery teams for client relationships.
• Planning, designing and implantingupgrade, migration and performance enhancementprojects ofOracle, MS SQL databasesalong with respective business applications.
• Liaising with all levels of stakeholdersto understand enterprise architecture, business strategies, policies, rules and operations of the organization, and to elicit, analyze, recommend, design, develop, implement, test and manage IT Business Applications.
• Managing changes to the Applications and database using Agile methodology and within client'sITIL Change ManagementFrameworkand Performing impact analysis of changes
• Very good knowledge in implementation Exadata, MySQL and mongo DB.
• High experienced in configuration of Delphix non prod environments.
• Creation of dsource to create nonprod environments.
• Create Jetstream user configuration so that endures can do their own refreshes on time .
• Highly experienced on various databaseperformance improvementactivities such as analyzingAWR reports,Partitioningtables,purgingold data, reducing variouswait events, usingADDM report and tuning advisor.
• Experience withdatabase backup, restore, and disaster recovery procedures such as creating catalog database, Virtual Private Catalog, Hot Backup, RMAN (9i/10g, 11g) full & incremental backup, 10g Data pump (expdp, impdp).
• Experience inrecovering corrupted data filesusing “recover corruption list” command.
• Experience incloning 11g RAC database(RMAN DB Duplicate)from RMAN backups.
• Installed Golden Gate 11gR2/12csoftware in Test and production (RAC DB) environment
• Experience in Installing and Supporting Oracle database inAWS.
• Experience in installingOracle 11g Grid Infrastructure with ASM disk bothfor RAC and Standalone database.
• Extensively worked on Oracle DatabasePatchingandUpgrade(From 11.2.0.4 to 12.1.0.2)
• Good experience in upgrading10g&11gR2 database to 12cPluggable database using Oracle DBUA and/or expdp/impdp method.
• Extensive experience inASM Storage managementsuch ascreates ASM disk groupsfrom SAN disks,add/remove ASM disksto existing ASM disk group.
• RAC experience includes working experience in - planning, designing, developing, deploying, maintenance and supportingRACon RHEL and Oracle Linux.
• Configured theLoad Balancingon RAC database through service names usingSRVCTLutility and usingSCAN - Single Client Access Name (in 11g).
• Experience onPartitioningtable for better performance and ease in data archival process.
• Working with vendor consultants like Sim corp Dimension and Findur and some other trading investments.
• Working very closely on application upgrades with vendor consultants during the go-live .

Confidential

Responsibilities:

• Manage and oversee all Service Delivery reports to an agreed schedule (or on request), including management and performance reports to IT Management
• Perform incident management process reviews to ensure efficient and effective workflow and to effect improvements in response time and resolution.
• Manage and oversee Problem Management across all infra teams to drive performance excellence based on business defined priorities
• Acting as single point of contact to customer for all the delivery issues for client senior Manager.
• Acted as delivered lead for all the Infra platform teams for Data Management groups.
• Responsible for bringing the quality and efficiency on Database systems for BI operations.
• Continuous improvement on delivery quality and effeteness of monitoring of systems and provide the proactive high availability on database systems.
• Making sure the business data is flowing through all the business systems with golden gate replication and with IBM flash backup technology.
• Resolving the performance issues from the infrastructure database and system performance tuning perspective.
• Developing and measuring group service level agreements (SLAs) and key performance indicators (KPIs) and that escalation flows are in place
• Responsible for the delivery of services within the SLAs and KPIs
• Reporting team KPIs
• To build services relationships with internal users
• Be the focal point for technology incident management; ensuring appropriate root cause analysis is completed and mitigating steps are auctioned.

Confidential

Responsibilities:

• Maintaining databases in 24x7 Production environments.
• Working on vast and complex environment such as RAC with standby along with Golden gate data flows.
• Attending daily Problem and incident calls whenever representation required.
• Assisting to the clients and application team when require in Critical incidents
• Assisting with Golden gate lag and associated issues
• Working on Data guard broker and Huge standby databases
• Working on Huge page settings as per Confidential standard.
• Working on Applying patch and upgrades of RAC databases
• Working on daily infra calls support with service delivery management team.
• Working on presenting the Weekly decks to customer managers and Directors.
• Working on presenting and executing SIP plans for the Confidential client.
• Identifying the Service Improvement plans (SIP) areas where team can deliver best practices and gaps to achieve team working deliverables and customer expectations.
• Identifying and executing automation activities where team spending more man hours to deliver the things such as automation of aid$ purging events keeping in scheduler jobs etc. . . .
• Working with application team and identifying the root cause of severity of issues
• Working with Oracle support on major incidents to prevent future and repeated outages and crashes.
• Working on Replicate, Pump,Extract goldengate process issues
• Configuring new tables in existing golden gate environments.
• Validating and reviewing changes and schedules, arranging the shift people as per the approved and reviewed complexity of the changes.
• Preparing RCAs for major incidents and customer asks on critical applications
• Involving the Shift huddles and taking over on going outages and calls and maintain the same momentum without any issues.
• Handling severity calls when escalation comes.
• Working with architects on the application side and enterprise side to get the root cause and understand the problem very clearly.
• Preparing M&P (Methods and Procedures) for L1 team for repeated events and issues.
• Involving in the outage calls whenever other team members require and support.
• Involved in the execution of best practices and giving suggestion on process improvement plans to give the best deliverables.
• Attending the weekly calls with Oracle customer support managers to get best practices on repeated events and issues specific to Confidential .
• Automating the build process and decommissions process for Confidential client.
• Giving best directions to L1 team to handle outages before escalating ticket to L2.
• Working on Standby lag and associated issues
• Working on Node reboots whenever planned changes
• Working on Partition Drop /create changes as part of Monthly activity.

Confidential

Senior Operations Professional (Oracle DBA)

Responsibilities:

• Maintaining databases in 24x7 Production environments.
• Attending daily Problem and incident calls whenever representation required.
• Assisting to the clients and application team when require in Critical incidents
• Reviewing the High priority changes for approval including technical reviews.
• Attending the CAB (Change Authority Board) meetings for Production change reviews.
• Joining the bridge calls with management whenever major incidents are lying.
• Weekly meeting with SMEs (Subject Matter experts) to review the health check reports.
• Writing, Reviewing and Giving inputs to RCA (Root Cause Analysis) whenever there is a requirement.
• Discussing and implementing the new methods with Subject Matter experts to provide better service to the customer in critical scenarios.
• Attending the weekly meetings and checkpoints calls and status calls for individual RFS activity(Request for Service) With application architects and Infrastructure Architects to design TSD.
• Writing an SOP (Standard Operating Procedures) for the repeating and critical activities.
• Taking initiatives whenever the situation demands for extending and continual service.
• Attending any escalation calls during non-business hours.
• Providing the Best solution strategy whenever required required for the client on Oracle database point of view
• Working with ORACLE Support for critical production service delivery decision making.
• Monthly meetings with Higher management including SDM ( service delivery managers ), CSM ( Client support mangers ), DPE ( Delivery Project Executives ) to improve Service lines in process gaps among

Confidential

Responsibilities:

• Installing New Releases Oracle database software and client software as per requirement on UNIX boxes (AIX, Linux).
• Creating databases using DBCA and manual for new applications as per specifications given by Application team.
• Monitoring alert boxes and taking appropriate action on table space management.
• Working on user management and connectivity issues when persists
• Upgrading the database from lower version to new releases based on the obsolesce versionIncluding 9.2.0.8 to 11 R2 and 10G to 11G.
• Working on Capacity management plans and DPP ( Defect Prevention Policy )For table space and OS mount points.
• Applying Quarterly CPU patches as per the release versions
• Exchanging the Billing table partitions to Normal table to revoke the approx. GB space at theTable space level
• Monitoring Oracle backup schedule and completion of backup activity.
• Participating in reboot activities of servers and planned activates.
• Administrating Multi node RAC environment
• Decommission of older version of databases with proper approvals.
• Performance tuning for optimized results using tools like AWR and ADDM reports
• Monitoring the disk performance including the disk space and the paging space.
• Making both primary and standby database whenever any gap detection noticed.
• Log shipping whenever any small amount of gap noticed when when ever in standby environment
• Configuring the best backup strategy for applications.
• Online Re-Organization of Oracle Tables.
• Checking Tables/ Indexes which needs more extents and to allocate space/ reorganize/ rebuild.
• Performing database refresh, Schema refresh and total Database refresh.
• Performing RMAN Cloning in 9i, 10g, and 11g versions based on the application requirement.
• Taking appropriate action whenever CPU utilization is high for oracle process in on critical production servers
• Creation and managing the user accounts, privileges and profiles under security compliance.
• Working on GSD 331 security compliance on Quarterly basis.
• Working on service Activation and Deactivation Process for the Oracle service line
• Working on Central inventory documents on monthly wise based on new databases coming to the service and decommission of databases.