SUMMARY

• Around 16.4 years of experience in Database management, Administration, implementation and customization of database at the different sites
• Handling the Onsite team, looking client escalation, making the roster & managing the team
• Having the experience of Production Database administration on client
• Working Knowledge of AWS Solutions Architect,Docker & Kubernates
• Expertise in database Administration, Oracle Server Installation, Database design, Database Migration/Up gradation, Backups & Recoveries, Performance Tuning, User management, Table space management, Security management
• Installation, configuration and maintenance of different Oracle flavors 9i/10g/11g/12c on Linux, Windows NT, HP - UX, Sun Solaris
• Handling the customer escalations, Managing the Rota and applying the process guideline as per the client requirement
• Database creation (using scripts and DBCA), applying Patchsets and CPU patches
• Performance tuning of Oracle database instances for Production instances.
• Upgrade the Oracle Database from 9.2.0.x to 10.2.0.x,11.1.0.X,11.2.X.X,12.2.X.X,19.3
• Good experience in handling the Oracle Database of various types of applications.
• Cloning of database using Hot or Cold Backup’s and RMAN Backup and Patching
• Backup tasks - using OS backup (Hot and Cold). Oracle backups, generally through Export - Import utilities, RMAN, Data Pump.
• Working on RAC, RMAN, ASM, DATAGUARD,STREAMS, Golden Gate and applying patches on these technologies into the project
• Managing the team of Oracle DBAs and collaboration of AWS and Devops Team with active coordination with the end user community
• Responsible for long-term data retention and disaster recovery.
• Setup OEM 12C/13C in citi environment

TECHNICAL SKILLS

Operating System: Linux, UNIX (Solaris- 9&10), HP-Ux, AIX, Windows NT/2003

Databases: Oracle 9i/10g/11g/12c, MS SQL server2005/2008, Sybase

Oracle Utilities: RMAN, EXP/IMP, Data pump, CRON, OEM Grid Control 12C/13C,Sql Developer, Toad, Oracle Streams. Golden gate

Shell script: Unix Shell Scripting

Tools: OEM, SQL*Plus, Amazon CloudWatch, AWS CloudFormation, AWS CloudTrail, EC2, VPC, S3, ECS,IAM, Route 53 etc.

Devops Tools: Chef,Puppet.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Technical Lead

Responsibilities:

• Daily activities includes Monitoring and rectifying alerts, Database build, upgrade, tuning, Implementing change request (CR), Database refresh request from development team, schema creation that includes user creation, permissions, table space quota.
• Working in shifts 24*7 and in team environment.
• Working on RAC environment
• Cloning of database using Hot or Cold Backup’s and RMAN Backup.
• Upgrade the Oracle Database from 9.2.0.x to 10.2.0.x,11.2.0.X
• Implementation of quarterly security patch of Oracle.
• Collecting performance statistics using Statspack/AWR (Automatic workload Repository)
• Managing Tivoli Generated Incident Tickets for production database.
• Developed backup & restore strategies for Hot and Cold backups.
• Analyzing and Rectifying Production Databases backup failures.
• Creating new users and grants them required privileges and roles.
• Creation of new Tablespace and adding and resizing the Data files.
• Working on RAC, RMAN, ASM, DATAGUARD,Golden gate and applying patches on these technologies into the project
• Database Sizing, Tablespace Management and Rollback Segments Management, Security Administration.
• Implemented Oracle Golden gate for replication between Oracle database tables.

Environment: Oracle 11gR2, Linux, AIX 7.1, Shell Scripting, RMAN,Data pump, OEM 12c/13c Grid Control,Oraas

Confidential

Team Lead

Responsibilities:

• Daily activities includes Monitoring and rectifying alerts, Database build, upgrade, tuning, Implementing change request (CR), Database refresh request from development team, schema creation that includes user creation, permissions, table space quota.
• Handling the customer escalations, Managing the Rota and applying the process guideline as per the client requirement
• Database creation (using scripts and DBCA), applying Patchsets and CPU patches
• Cloning of database using Hot or Cold Backup’s and RMAN Backup.
• Upgrade the Oracle Database from 9.2.0.x to 10.2.0.x,11.2.0.X
• Collecting performance statistics using Statspack/AWR (Automatic workload Repository)

Environment: Oracle 11gR2, Linux, oracle stream, RMAN, Data pump, OEM 12c Grid Control

Confidential

Team Lead

Responsibilities:

• Responsible for provisioning the database as per bank standard for oracle, Sybase and sql server during transition, Handling the customer escalations, Managing the Rota and applying the process guideline as per the client requirement, preparing the transition docs like SMTD, SOP etc

Environment: Oracle 11gR2, Linux, oracle stream, RMAN, Data pump, OEM 12c Grid Control,sql server, Sybase

Confidential

Team Lead

Responsibilities:

• Daily activities includes Monitoring and rectifying alerts, Database build, upgrade, tuning, Implementing change request (CR), Database refresh request from development team, schema creation that includes user creation, permissions, table space quota.
• Handling the customer escalations, Managing the Rota and applying the process guideline as per the client requirement
• Database creation (using scripts and DBCA), applying Patchsets and CPU patches
• Working in shifts 24*7 and in team environment (17 DBA).
• Working on RAC environment
• Cloning of database using Hot or Cold Backup’s and RMAN Backup.
• Upgrade the Oracle Database from 9.2.0.x to 10.2.0.x,11.2.0.X
• Implementation of quarterly security patch of Oracle.
• Collecting performance statistics using Statspack/AWR (Automatic workload Repository)
• Managing Tivoli Generated Incident Tickets for production database.
• Developed backup & restore strategies for Hot and Cold backups.
• Analyzing and Rectifying Production Databases backup failures.
• Creating new users and grants them required privileges and roles.
• Creation of new Tablespace and adding and resizing the Data files.
• Working on RAC, RMAN, ASM, DATAGUARD and applying patches on these technologies into the project
• Database Sizing, Tablespace Management and Rollback Segments Management, Security Administration
• Configured Database monitoring tool Foglight a product of Quest technologies, Patrol, Symphony on bulk of databases.

OS: Sun Solaris ver 5.8/5.9, HP-UXAIX

Databases: Oracle 9i, Oracle 10g, Oracle 11g

Environment: Oracle 11gR2, Linux, Aix, Solaris oracle stream, RMAN, Data pump, OEM 12c Grid

Confidential

ORACLE DBA

Responsibilities:

• Database administration, managing table spaces, objects.
• Identifying the poorly performing reports and the corresponding Sql Statement.
• Monitoring File System and Table spaces on daily basis.
• Performing SQL statement tuning (TKPROF, Explain Plan & AUTOTRACE).
• Tuning the Shared pool, Buffer cache, Log buffer.
• Security Administration and User Management involving roles, privileges etc.
• Maintaining the Control File, Maintaining Redo Log Files, Managing rollback Segments.
• Creation of Indexes.
• Creation of oracle database users and managing them.
• Implementation of scheduled online backups in the development database and in the production database
• Taking Logical backup of full database using Export.
• Created users and roles.
• Supported development team in their day-to-day activities.
• Using crontab utility to schedule the backup operation.
• Installation of stats pack for gathering statistics

OS: Solaris, AIX

Databases: Oracle 9i

Environment: Oracle 9i/10g, Solaris, AIX, Shell Scripting, RMAN, Data pump