OBJECTIVE:

• Over 7 years of experience in following major areas of Oracle Database Administration:

PROFESSIONAL EXPERIENCE

• Building RAC
• Configure ASM
• Worked on Performance tuning
• Strong Linux Admin skills
• ASH, AWR, ADDM
• Build Data Guard
• Configure Statspack
• Build Active Data Guard
• Worked on Exadata
• Worked on SQL Profiling
• Worked on GoldenGate
• Managed SQL Server
• Worked on Oracle Security
• Used SQL Developer
• Written Shell scripting
• Worked on DB Upgrades
• Managed OEM
• Managed DB using 12c Cloud Control
• AIX, HPUX
• SQL Baseline
• Managed DB using TOAD
• Performed DB Cloning
• Backup and restore using RMAN
• Upgrade Grid Infrastructure
• Refreshes using Data Pump

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Supporting Oracle Customers running various versions of Oracle RDBMS.• Build multi node 11g and 12c RAC
• Set up Active Data Guard• Worked on various performances related issues.
• Very familiar with RAID configuration.
• Worked with Storage team for ASM and other file system needs.
• Set up uni - directional Golden Gate for replication.• Setup the materialize views for replication.
• Worked For the support of Oracle Exadata Systems• Managed SQL Server Databases.• Provided assistance to Memory Corruption and Dictionary Corruption Errors
• Setup the replication using Oracle GoldenGate.• Provided assistance to Implement Huge pages /Large Pages in Unix platform
• Assistance to High memory utilization issues in Unix and Windows Platforms
• Provided assistance to Slowness of Data Pump, expand SQL Loader utilities
• Providing all round DBA support to resolve Application and DB outages on production, development, test and staging Customer environments across the Globe.
• Involved in resolving issues after Installations, Upgrades, Cloning, patching (both DB and Applications), CPU patches, and one-off patches.
• Development Life Cycle (ISDLC), that have high availability and scalability consistent with Customer needs, Mentors and develops Associates• Applied On-off, CPU, PSU and CRS Bundle patches.
• Performing design testing, implementation, maintenance and administration in a multiple platform SAP environment.
• Provides and supports the implementation of business solutions• Upgrade databases from 10g to 11g R2 to 12c to 18C to 19C.
• Worked on OEM 12c and 13c• Installed 12c, 18c and 19c database• Worked on Multitenant databases.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Setting up and testing the backup and recovery strategies.
• Database Tuning by generating explain plans for long running queries, creating indexes on columns to improve performance.Build physical Standby database
• Completed tasks for snapshot standby.• Resolved gaps at standby database.
• Remove unnecessary histograms in highly volatile schemas.• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Database dot release upgrades using GUI and via command prompt• Tested Recovery scenarios.
• Performed Security administration tasks, setup users accounts, passwords, roles
• Monitored data files, logical data storage and data growth activities
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze, DB backup logs etc
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
• Perform capacity planning required to create and maintain database environments.• Supported 24/7 on-call pager support for mission critical financial databases.

Confidential

Oracle Database Administrator

Responsibilities:

• Responsible for administration and supporting oracle 11g, 10g and 9i databases.
• Coordinated system support and performance• Actively participated in gathering Business Requirements and System Specification from system users.
• Responsible for Analyzing requirements, designing, maintaining and updating data models
• Analyze the current data management procedures in practice and suggest ways for automating the process or improving the existing system.
• Installation of Oracle on Linux and Windows.Performed installations of Oracle 10g and 11g and SQL Server databases.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
• Analyzed and suggest improvements to SQL queries and statements written by others.
• Developed stored procedures to pull the data from the distributed systems.
• Maintaining daily batch cycle and providing 24/7 support.
• Developed various form-level and DML triggers to perform validation checks• Worked Extensively in Menu Modules in forms Builder
• Developed Templates for new forms and generate scripts for database objects using oracle designer 10g
• Developed and implemented complex data models and logical database designs.
• Involved in unit testing and integrated testing. Involved in preparing the User Test plans.
• Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.
• Defined database requirements and designed data model. Installation of Solaris, Linux and Windows on the servers.
• Monitored of tablespace related issues like increasing the storage parameter values, resizing the data files, adding new data files etc.