Summary:

• Database Administrator with 7 years of experience in Installation, upgrade/migration, Management, Administration, Backup and Recovery, Maintaining and Tuning of Oracle databases.
• Proficient in Oracle 12c, 11g R1, 11g R2, Oracle 10g R2, 10.1.0.x, Oracle 9.2.0.x, Oracle 8.1.7.x
• Experience in supporting Oracle databases 8i/9i/10g/11g in variety of different environments including UNIX, Sun Solaris, IBM AIX, Microsoft Windows 2000/NT Servers and Linux.
• Experience in Real Application Clusters RAC setup, configuration and cluster interconnection with Automatic Storage Management ASM , configured user log on load balancing and failover on RAC database for high availability.
• Installed and Administered Oracle 11g ASM 10g RAC software with ASM OCFS2 File systems.
• Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
• Administered Oracle ASM disk groups mirroring, compatibility with Oracle ASM Configuration Assistant ASMCA .
• Extensive expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance Tuning, Backups, Recovery, RMAN backups, Optimization, Networking, Troubleshooting.
• Experience in Oracle Enterprise Manager OEM Grid Control, TOAD, RMAN and Golden Gate.
• Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild and a bend.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Performed data replication, transformation and delivery of database transactions using Golden gate replication tool. Supported a large number of Development Databases.
• Experience in installing Oracle patches, Migration of database across different platforms.
• Cloning/Data Refresh from production environment to setup test and development environments.
• Proficient in all DBA responsibilities such as Instance tuning, user management, space management, monitoring.
• Implemented Data guard in the production environment.
• Excellent experience in various migration techniques like export/import, Data pump, backup restore, cloning, and data guard.
• Experience in Disaster Recovery set-up using Data Guard for critical environments and Disaster Recovery exercises annually.
• Implementing FSFO Fast start failover on databases and configuring disaster recovery site using Data guard. Also proficient with new 11g features such as Active Data guard and Snapshot standby database
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.
• Design and implementation of Backup and Recovery strategies both cold and hot backups and performing periodical backup, restoration and recovery using RMAN full and incremental .
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Delivered SQL and Database performance tuning services via V /GV views, Explain Plan, TKPROF, AWR Stats pack reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager OEM , Grid control, analyzed SQL trace dumps for 9i/10g/11g.
• Configured database 10g, 11g for ORACLE FLASHBACK TECHNOLOGY
• Transferring compressed files on FTP servers, on UNIX platform
• Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
• Experience in SQL Tuning, Optimization, rule based optimization, cost based optimization and Hints.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, and SQL TRACE.
• Experience on building and rolling out new 12c databases for test/dev/qa environments
• Experience in upgrading of oracle databases from 11g to 12c
• Proven ability of providing production support for 24X7 on multiple databases.
• Ability to work on own initiative and as a part of team. Excellent verbal and written communication skills.
• Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.

Software Skills:

EXPERIENCE:

Confidential

Oracle DBA Developer

Responsibilities:

• Worked on upgrading of oracle databases from 11g to 12c.
• Worked on building and rolling out new 12c databases for test/dev/qa environments.
• Implemented oracle 12c active standby database for test database environment.
• Installed, Configured Oracle 12c Goldengate on Oracle 12c Database.
• Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.
• Performed the code reviews for all the db code coming into the database and fine tuned it before hand.
• Utilized RMAN recover table functionality and created proof of concepts for our pre-prod environment.
• Support databases in Exadata environment.
• Involved in hardware migration of databases from Linux to Exadata servers.
• Involved in 24x7 support for 8TB, 4 Node production RAC database with on-call pager
• Installation and creation of 11g and 10g databases for Testing, Development and Production.
• Installed Golden Gate 12c on IBM-AIX Platform.
• Implemented 12c/11g Data guard with one physical database
• Extensively worked with DML Triggers.
• PL/SQL, Performance Tuning, Application Tuning and Monitoring.
• Installed, upgraded Golden gate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Used Oracle 11g/12c AWR ADDM to monitor database activities and performance tuning.
• Backup of Database Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.
• SQL query tuning using tools like Explain Plan, SQL Trace, TKPROF and Statspack
• OEM / GRID OGC installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable tablespaces and RMAN.
• Extensively used Oracle Application Server 10g, in deploying and integrating enterprise's applications.
• Planned and performed the database migration from SQL Server to Oracle using Golden Gate.
• Build and implement test, quality assurance, and production databases and environments.
• Coordinated strategies to move data between databases using expdp/impdp.
• Composed maintained and monitored compliance to standards and practices.
• Assisted IT Analysts on technical database issues and features.
• Resolved data integration issues.
• Ensured data is being maintained effectively by monitoring data maintenance.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• ASM implementation maintenance. Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Created standby database using data guard on testing server.
• Dataguard and Provided Oracle database administrative support.
• Maintenance and monitoring of table spaces, data file, control files etc.
• Implement and maintain database security create and maintain users and roles, assign privileges
• Implemented scripts, which monitor database health check at regular interval, upon error, send email to the concerned person.
• Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
• Worked with projects/operations/professional services team and co-ordinate multiple tasks at hand with expertise and solid plan.
• Worked under high stress situations many times and handled the situation very effectively.
• Define Backup Strategies and Implementation.
• Loading bulk data from flat files using sql loader and external tables

Environment: IBM AIX 6.3,7.1, Sun Solaris 2.6/7/8, Exadata, Red Hat Linux 6.0, Oracle 10g/11g/12c, PL/SQL, SQL PLUS, VNC, ORACLE ENTERPRISE MANAGER 9.2.0 , Oracle 12c GRID, QUEST SOFTWARE 5.0 , Oracle RAC, Data guard, Toad 8.6, AD utilities, SQL server

Confidential

Oracle DBA

Responsibilities:

• Worked on Oracle RAC with SRDF Implementations for cross data center replication.
• Administered the tidal job scheduler for datacenter automation tasks.
• Worked on HP Quality Centre tool for test/dev/qa code drops and environment true-ups.
• Implemented Oracle 11g golden gate for replication project.
• Implemented Oracle 11g Active Data guard for Disaster Recovery Solution.
• Worked on Implementing Oracle OEM 11g Agent cloning tasks for hundreds of servers.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Worked on EBS and Database cloning on Exadata servers from Production to DEV and QA.
• Handled Vendor applications and interacted with vendors regularly to understand and optimize the database operations.
• Actively participated on war room bridges during major releases and escalated to dba management as needed.
• Participated in database audits and following compliance rules and regulations always.
• Participated in requirements gathering meetings with customer while building out new db environments.
• Prioritizing db related tasks on daily basis and completing most of them before the close of Business every day.
• Participated in internal db team meetings with peers and management for db work/project status update.
• Worked with offshore team and co-ordinate with them always for any database changes by means of email/phone communication.
• Always uploaded the common share point repository with all updated work related documents for sharing purpose.
• Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2 10.2.0.1, 10.2.0.2 and 10.2.0.4 11g Release 1 11.1.0.6,11.1.0.7 upgrades on all the environments in a procedural approach Dev, Test, Stage and Production also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports.
• Production Support for Critical Application Databases, work closely with
• Implemented Oracle Patches CPU, PSU on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Worked with developers and management team to ensure smooth life cycle progress from development through testing and production implementation.
• GoldenGate installation, configuration for replication.
• Helped in Performing Golden Gate replication monitoring, tuning, and capacity planning.
• Used normal import and export and also datapump import and export for exporting and importing schemas, tables etc from one database to another.
• Extensively worked with dba jobs, dba scheduler jobs, functions, procedures and packages.
• Responsible for tuning the database performance issues like query tuning and memory tuning SGA tuning and also partitioned the tables and indexes for better performance.
• Have used different tools like TOAD 10.1 , EXPLAIN PLAN, AWR, ADDM Oracle enterprise manager GRID CONTROL 10.2.0.4 to solve the performance issues.
• Kept tracking the database performance using oracle enterprise manager and checking the users sessions which consuming more CPU and taken the necessary steps to reduce the CPU usage.
• Monitored the databases and added the data files to the tablespaces or resizing the tablespaces and monitored the sessions running on the databases.
• Analyzed the tables and indexes manually whenever required. Manually refreshed the materialized views used for replication whenever the job fails to refresh them.
• Created new schemas, tables, indexes, jobs, tablespaces and granting the previleges to the user as per demand and also written pl/sql code to delete million rows by committing after every 10,000 rows.
• Monitored and checked the invalid objects like jobs, procedures etc and recompiled manually after solving the problem for objects to become invalid.
• Deployed the patches for grid agent and oms for the version 10.2.0.4 and troubleshooted the problems in uploading agent and securing agent.
• Troubleshooting application failures including performance and database connectivity problems and job failures.
• Administrated the automatic storage management ASM like adding the disk groups.

Environment: Oracle 11g/10g, SQL, PL/SQL, Erwin, TOAD 10.1 , Exadata, Recovery Manager RMAN , Tivoli, Oracle Enterprise Manager OEM , SQL Loader, TKPROF, Data Guard, Shell Scripts, Golden Gate, AWR, ADDM, HTML, DHTML, Windows 2008, RHEL 4.0, AIX-5.3.

Confidential

Oracle DBA

Responsibilities:

• Installation and Maintenance of Oracle Databases.
• Upgrade of Database from 9i to 10g.
• Involved in configuration of Golden Gate for replication of database.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Cleaning up unwanted log files and Checking the Disk Space for potential problems.
• Performed number of schema refreshes from production to test and dev using expdp/impdp
• Migrating HP-UX to Linux with Oracle database.
• Applying CPU patches to Oracle Applications.
• Performed cloning/Refresh of Production Instance to Test, Development environments.
• Performance tuning Tune SQL statements, I/O, Memory, latches etc. Worked extensively on SQL Profiler, Explain Plan and Stats Pack for tuning top wait events, high cost SQL's.
• Monitoring the environments from OEM.
• Backup and Recovery using RMAN.
• Applied Oracle Security Patches for 9i and 10g databases.
• Rebuilding of Indexes.
• Providing Production support 24/7 and troubleshooting user issues.
• Weekly meetings with users to discuss about the issues related to various application modules overall performance of the system.
• Interaction with Oracle support to work on Tars.
• Taking different types of logical, physical backups at database level.
• Identifying and troubleshooting long running queries, locked sesions to improve overall performance.
• Generated Automatic Workload Repository AWR report to collect processes and maintained performance statistics for problem detection self tuning purposes.
• Generated Automatic Database Diagnostic Monitor ADDM in order to analyze data in the Automatic Workload Repository AWR in order to identify potential performance bottlenecks.
• Bouncing of Database services.
• Documented various process procedures.
• Support the UNIX and Linux Administration tasks.
• Established and wrote the Database Administrators Procedures document for the IT department.
• Interaction with various stakeholders for timely delivery of different tasks.

Environment: Oracle 9i/10g, Linux, HP-UX, Putty, OEM.

Confidential

Oracle DBA

Responsibilities:

• Provided 24x7 Support of Critical Databases and worked on enhancing the Database Monitoring process.
• Troubleshooting issues during upgrade, applying patches to fix issues.
• Upgrade of database from 8i to 9i.
• Responsible for refreshing/cloning test instances with Production Instance periodically,
• Applying patches for fixing issues and adding functionality.
• Administration of databases- Physical and logical structures.
• Applied and provided feedback regarding in-house technical standards and processes.
• Creating and Managing users, Granting and Revoking privileges for the users in order to ensure the Database security.
• Creating and Maintenance of different types of Tablespaces.
• Automated jobs to run backups, disk cleanup for logs and archive logs, gather statistics.
• Identify and troubleshoot long running queries, locked sessions to improve overall performance.
• Established and wrote the Database Administrators Procedures document for the IT department.
• This document outlines all standards for the DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards, policies, practices and procedures.
• Provided production database support, including creating and maintaining databases, backup and recovery, security, upgrades.
• Supported development projects on database activities Oracle, DB2, and MySQL .
• Managed and supported users by creating roles and privileges for database access and data manipulation.
• Reported the database storage capacities to Project Management.
• Organized the capacity planning of the production database.

Environment: Oracle 9i/8i, Solaris, Linux, HP-UX.

Confidential

Jr. Oracle DBA

Responsibilities:

• Providing Production support and troubleshooting user issues.
• Performing daily database operations, maintenance and support.
• Administration of databases- Physical and logical structures.
• Export/Import data to/from PROD and Non Production systems as required.
• Expertise in database backup and recovery management Hot/Cold, Exp/Imp .
• Identifying and resolving resource contention issues and monitoring database performance.
• Troubleshooting based on Alert logs.
• Maintaining of Space requirements on the Tablespaces by adding/re-sizing data files based upon the space available on the file systems and existing volumes.
• Creating and Managing Users, Granting, Revoking privileges for the users in order to ensure the Database security.
• Responsible for refreshing/cloning test instances with Production Instance periodically.
• Creation of Database Links and Materialized Views between different databases.
• Coordinate with Oracle Support to resolve database performance issues.

Environment: Oracle 9i/8i, Solaris, Linux.