PROFESSIONAL SUMMARY:

• Ten (10)years of experience as an Oracle Database Administrator, Exadata DMAand AWS.Having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery
• Space management, database security, cloning, migration, shell scripting and documentation.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g and 12cwith experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Excellent experience in installation, setup and configuration of Oracle 10g, 11g,and12cin HP - UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
• Having hands on experience in management and database administration of Oracle applications on ExadataQuarter RACK and Half RACK platforms.
• Expertise in upgrading teh databases from Oracle 9i to Oracle 10g, Oracle 10g to Oracle 11g and Oracle 11g to Oracle 12c.
• AWS Cloud expertise in administration, migration and enterprise configuration
• Architect AWS instances to migrate on premise application to cloud.
• Design architecture diagram for different application.
• Working Experience with Oracle Data Guard
• Working Experience with RAC and ASM
• Created Read Replica Database for Production Database.
• Experience in Database Migration from Linux to RDS Database
• Experience with Database Migration from Non Cloud Servers to Cloud Servers
• Working experience with Database Upgrades
• MigratedOn Premises Oracle Database to AWS RDS Database
• Experience with High Availability features (RAC andDataGuard).
• Excellent knowledge in logical backups,Hot/Cold Backup and Recoveryand Cloning of databases usingRMAN
• Experience in complete recovery, incomplete recovery, recovering data files, tablespaces, control files, block corruption.
• Good exposure to oracle technologies likeAWR, ASMand data pump Export and Import.
• Working Experience on ORACLE EXADATA for teh extreme performance of teh database.
• Prepared Standard Operating Procedure Documents

TECHNICAL SKILLS:

Databases: RDBMS, Oracle 12c, 11g, 10g, and 9i

Oracle Products: Gloden gate, Oracle Exadata DMA, Data Guard Broker, OEM, RMAN,ASM and RAC

Programming Languages: SQL, PL/SQL, JAVA, C, C++

Operating systems: OEL, RHEL, AIX, Solaris, Windows XP, 2003, 2008, 2010 and 2012.

Other Tools: RDBMS, SQL Developer,pgAdmin and IBM PowerHA

PROFESSIONAL EXPERIENCE:

Confidential, CO

Lead / Sr. Oracle DBA

Responsibilities:

• Responsible for providing 24X7 production support for critical Payments, Financial, and connectivity applications’ Oracle 11g and 12c databases on Solaris and RHEL.
• Worked on Database Migrations from On Premises to AWS RDS Database and Exadata.
• Worked on Quarter Rack and Half Rack Exadata on X5 and X6 machines.
• Worked on Database Migrations from one datacenter to another datacenter on Quarter Rack on Exadata
• Piloted teh Planning and Migration of Oracle databases from In-premises Datacenters to AWS Cloud including homogeneous and heterogeneous migrations
• Experience in Database Migration from on Primacies to AWS RDS Database using Export and Import
• Experience with Amazon Web Services (AWS) RDS object storage, monitoring and notification services (SNS and Cloudwatch).
• Worked on AWS RDS to Oracle Migrations
• Experienced in Design, implementation and generating documentation of Oracle 11g Data Guard
• Involved in Installation and configuration of Oracle 10g &11g RAC using Cluster ware and ASM.

Confidential, WA

Lead / Sr. Oracle DBA

Responsibilities:

• 24x7 Production Database administration and applications support
• Supporting multiple databases for Production, Development, Test and Staging purposes
• Applying upgrade patch, maintenance (opatchetc) Patches on all teh Exadata databases.
• Refreshing Dev and test instances with data from Production on a regular basis.
• Installation of Oracle 11g/10g RAC and Standby Database for High Availability and Disaster Recovery purpose.
• Provided performance tuning of Oracle Databases on Exadata.
• RMAN point in time recovery and Instance recovery done.
• Worked on teh migration of SQL Server databases to Oracle databases.
• Upgrade and Migration of Database from 9i to 10g, 10g to 11g and 11g to 12c applying patches whenever required.
• Monitoring and optimizing teh performance of teh Database
• Capacity planning: Allocate system storage and plan future storage requirements.
• Creating OEM alerts that provides notifications.
• Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.

Confidential, CO

Lead / Sr. Oracle DBA

Responsibilities:

• Worked on 2 Node RAC for Production Database.
• Applied Quarterly patches for Oracle Database
• Worked on Half RACKOracle Exadata DMA
• Database Monitored throughOEM 12c Cloud control.
• Applied Patches for every quarter
• Working experience in Oracle Data Guard
• Createdand Configured Oracle GlodenGate
• Experience with Change Management for all teh database changes.
• Worked on Migration from RHEL Server to Exadata Oracle Database
• Worked on Export and Import for Schema Refresh
• Worked onOracle ExadataDMA server for infrastructure and in other similar projects

Confidential, NJ

Lead / Sr. Oracle DBA

Responsibilities:

• Installed Oracle database and Oracle Grid Infrastructure software on IBM PowerHA /HACMP clusters
• Worked on Exports and Imports for Refresh task.
• Worked onDocumentation and Build Plan for Database Upgrades and Patches
• Good working experience with OEM 12c cloud control.
• Applied Patches for every quarter
• Working experience in Oracle Data Guard
• ImplementedOracle GlodenGate from Production to Test environment
• Created custom KEYS on IAM for AWS
• Created Oracle Database on AWS RDS Service, created Tablespaces and Users
• Worked on Database migration from On-Primises to AWS RDS Oracle Database
• Worked onOracle Exadata server for infrastructure and in other similar projects
• Used srvctl command to start and stop RAC Database

Confidential

Sr. Oracle DBA

Responsibilities:

• Applied Patches for every quarter.
• Database Monitored through Oracle Enterprise Manager (OEM)
• Experience in supporting Oracle Corporation implementation.
• Conducted Meetings for all level of Escalations
• Prepared Build Plan for Database Migrations Activity
• Experience in handling large database up to 14TB in size with 4 nodes cluster on various flavors of UNIX.
• Resolved Replicate/extract/pump issues and upgraded classic EXTRACT to Integrated capture to overcome teh compression table’s issue.
• Experience in troubleshooting RAC node eviction problems by reviewing cluster logs and system log messages
• Experience in Managing Applications on oracle 11g / 10g RAC databases using ASM file system with server control utility (SRVCTL) and CRSCTL for high availability RAC.
• REFRESH/CLONING of Databases and applications for development, testing and Prod boxes on demand from Application teams using EXPORT/IMPORT, DATAPUMP at table level, schema level and database level for Refreshes.
• Hands on experience with 11g new features such as ADRCI, Duplicate from Active database, ASMCMD, Memory parameters, Incidents etc

Confidential

Sr. Oracle DBA

Responsibilities:

• As a Oracle DBA, Installation, configuration, maintenance and tuning of Oracle 11g and 10g.
• Worked as a part of team in Data Center Migration project for 6 months.
• Daily database administration tasks including backup and recovery through RMAN
• Performed data transfer using Export and Import
• Created Build Plan for Quarterly Patches and Database Upgrades
• Created NEVER expiry profiles for all system USERS
• Worked on Database Health Check for every Quarter
• Created Database Links from DEV Database to TEST Database
• Applied patches for every quarter inOracle database.
• Worked on Exports and Imports for Schema Refresh task
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.
• Involved in Installation and configuration of Oracle 10g &11gRAC using Cluster ware and ASM.
• 24x7 remote support and on call Database support for Database developers & end-users.
• Experienced in implementing Oracle Database advanced security practices.
• Implemented Oracle Dataguard for PROD Environments.
• Successfully configured and installed Oracle Gloden Gate for replication.
• Helped in developing applications based on Oracle Exadata platforms.
• Maintained teh Heart beat tables to check teh lag between teh sites.
• Installation and configuration of OEM 12c on RHEL.
• Worked with application team to resolve conflict handlers and teh replication issues.
• Experienced in Design, implementation and generating documentation of Oracle 11g Data Guard
• Implemented Data guard, creating both Logical and Physical Standby databases in 10g &11gRAC environment for teh Production databases.

Confidential

Oracle DBA

Responsibilities:

• Created NEVER EXPIRY Profile for Application users.
• 24x7 Production database administration, support and monitoring to ensure a proactive problemrecognition and resolution of database issues.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Made performance improvements to teh database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for teh same.
• Created Users, Privileges, Roles in Oracle Database.
• Used RMAN (Recovery Manager) utility to take backups.
• Applying security patches both Server side and Client side and Performed testing.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.

Confidential

Oracle DBA

Responsibilities:

• Created Users, Roles, Profiles and provided privileges in Oracle Database.
• Created Standard Procedure Documents
• Modified scripts as per technical specifications.
• Created Tablespaces and Adding Datafiles in Oracle Database.
• Database Monitored through BMC Patrol
• Analyzed teh table structures using Analyze command.
• Involvement in all phases of teh project life cycle.
• Designed Database tables as per technical specifications.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Implemented automated backup strategy using teh UNIXshell script CRON UTILITY.

Environment: Oracle 9i,10g and 11gEXP, IMP, IBM-AIX, Windows XP/NT, PL/SQL, SQL, Supported Applications likeSIEBEL, OBIEE, Hyperion, WindChill,PeopleSoft, ODA, JD Edwards and ServiceNow.