Summary

• Having 8 years of professional IT experience as a Software Engineer in the field of Oracle database environment.
• Having good Experience in Development Support Environments.
• Hands on Experience on UNIX and Linux, Created scripts for automating the day to day activities and Created scripts for capacity planning.
• Customer handling and Coordination and Status reporting.
• Develop, document and enforce database standards and procedures.
• Standby/Failover Administration
• Instance tuning using Oracle AWR Reports, OEM and Oracle 10g tuning advisers
• Created/Migrated database environments using the Quality Center tool for validation projects
• Created Capacity plans and prepared database design documents as per the user's requirements.
• Installed Oracle CPU patch sets and upgraded oracle databases to higher versions.
• Implemented database security tools, design and testing.
• Worked on Load testing's and provided the recommendations to improve the performance.
• Worked with developers on DDL and DML changes on the database.
• Having strong knowledge on the partition tables and indexes.
• Worked on table partitions and provided recommendations
• Supported 5 Terabytes size large databases.
• Experience with OEM/EM12c Oracle tool to monitor the databases and configure the alert monitoring templates, used EM12c for performance tuning.
• Reviewed business requests for data and data usage, researched data sources from the listener logs to resolve the Listener storm issues.
• Experienced in Backup, Recovery, and Duplicate database using RMAN.
• Developed RMAN scripts for database Backup including hot and cold backup options for both RAC and stand alone databases.
• Configuration of Oracle OEM Oracle Enterprise Manager .
• Proficiency in Tuning the SGA, Buffer Cache, Redo Mechanisms, Monitoring and detecting Locks, undo / rollback segments.
• Managing Oracle Net Configuration, monitoring Alert Log Files, Listener Log, Redo Log status, and trace files for the database.
• Experience in writing shell scripts for loading of data.
• Monitoring of the queries with high response time and high disk reads per execution and tuning the same using Explain Plan, TKPROF, Auto trace.
• Used Repository manager to create Repository, User groups, Users and managed users by setting up their privileges and profiles.
• As a production DBA, resolved several types of production issues during the off hours and over the weekends by 24x7.
• Worked both as a development and Production Support DBA and having experience in full life cycle of database administration.
• Excellent communication skills and the ability to work independently or in a team.

WORK EXPERIENCE

Role: Oracle DBA

Confidential

Responsibilities:

• Responsible for Feasibility study and preparing Technical specification
• Implemented Oracle Patches CPU PSU on the Compliance databases Device a plan to patch them.
• Involved in Production Support for Critical Application Databases when needed.
• Responsible for all database weekly cold and daily archive logs.
• Worked on Oracle Total recall, enabled, disable, associated flashback on the tables that is required history enabled on tables.
• Created automation scripts for applying database application release patches
• Worked on Read only tablespace plugin to other databases
• Fixed alerts from EM12c monitoring templates.
• Worked on table level partitions
• Responsible for client side enhancements like pointing to new oracle home, testing entire application functionality on 11g client version
• Scheduling jobs through oracle JOB SCHEDULAR, Crontab UNIX .
• Created routines for Daily, Weekly Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
• Implemented Transparent Data Encryption TDE for compliance related databases.
• Responsible for implementing code enhancements as per 11g standards
• Planning, reviewing and executing the maintenance and enhancement tasks.
• Supporting the Hardware/Database upgrades.
• Customer handling and Coordination and Status reporting.
• Application Monitoring, analyzing issues and trouble-shooting the failures.
• Analyzing and tuning SQL, PL/SQL statements using Oracle provided utilities.
• Provide analysis for market data related queries and data inconsistencies.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Performing Backup/Restore of all the Oracle databases using RMAN.
• Performed migration of the oracle databases whose database sizes vary from 300 to 500GB from Oracle 10.2.0.4/11.1.0.7/11.2.0.1 to Oracle 11.2.0.3 using Exp/Imp and Expdp/Impdp.
• Implementing Physical and Logical Standby setups Data guard Configurations.
• Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC.
• Knowledge of Exadata Storage Servers and monitored X3/X2 Quarter/Half/Full RACK Machines.
• Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 20TB and automated the process through crontab.
• Ran Scripts for Health Check on Exadata Storage Servers.
• Implemented Oracle Patches CPU PSU on the Compliance databases Device a plan to patch them.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Involved in Production Support for Critical Application Databases when needed.
• Installing agent 12c on the server. Adding High Available Database with CRS, Scheduling Backups through OEM12c.
• Scheduling jobs through oracle JOB SCHEDULAR, Crontab UNIX .
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues helping to transform business requirements into environment specific databases.

Environment: ORACLE 10g/11g, Oracle 10g/11g RAC, ASM, Oracle Solaris 10, Linux 5.x,6.x , Toad, SQL, PL/SQL, Toad, Data-Pump, OEM, RMAN, XML, Shell Scripting.

Role: Sr. Oracle DBA

Confidential

Responsibilities:

• 24 X 7 Production Oracle database on call pager support and administration.
• Oracle 10g RAC and 11g RAC installation and configuration.
• Installation of Oracle clusterware with the oracle database 10g and 11g software.
• Work with RAC pre-installation tasks, like hardware requirements, software requirements, and environment configuration.
• Create required directories for the oracle database software installation and create schema, user for oracle.
• Configured ASM in an RAC environment.
• Converted Single Instance Database to RAC, Added nodes to RAC.
• Upgraded database from 9i, 10g to 11g, 8i, 9i to 10g
• Trouble shooting production problems and working effectively with other team members to identify and address problems.
• Analyzing tables and rebuilding the index twice a month to increase the performance.
• Modified spfile parameters as per the business requirements in RAC.
• Managed the control files by multiplexing to different network path.
• Continuous Performance monitoring and tuning of the databases and application s using SQL TRACE, EXPLAIN PLAN, STATSPACK, AWR and ADDM.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Analyze SQL statements, reorganize database objects, design indexes and optimizer hints to improve response of queries.
• Determine RAC specific wait events, global environments and system statistics.
• For high availability purpose configure Transparent application failover TAF on server.
• Working with audit on all databases as per the SOX compliance and analyzed and reported the audit records about the suspicious activity in the database.
• Researching, testing and coordinating Oracle patches/upgrades.

Environment: Oracle 11g RAC, 10g RAC, 9i, HP-UX, Sun Solaris, Redhat LINUX, Data guard, Clusterware,

ASM

Role: Oracle DBA

Confidential

Responsibilities

• 24 X 7 Production Oracle database on call pager support and administration.
• Oracle 10g RAC installation and Configuration.
• Performance tuning of SQL queries with the help of explain plan and Tkproof. Generating Statspack report by using statistics for the optimizer.
• Used Statspack report to tune materialized views by creating materialized view logs to enable fast refreshes on master tables.
• Performed Full/Incremental backup.
• Performed Memory tuning for structures such as the database buffer cache, shared pool, library cache and PGA.
• Documented, implemented and maintained all Disaster Recovery procedures.
• Setup and configure Standby database for high availability by using Dataguard. Used AWR for database performance and statistics.
• Provided performances tuning on a 10g RAC database.
• Created and managed Bigfile tablespaces.
• Writing shell scripts to capture server statistics into an oracle tables and change oracle environments on different server.
• Database Design/Architecture experience using both logical and physical modeling using Erwin tools.
• Administer, maintain, develop and implement policies and procedures for ensuring the security and integrity of the company database.
• Enabled the audit on all the dev/test databases as per the SOX compliance and analyzed and reported the audit records about the suspicious activity in the database.

Environment: Oracle 9i/10g RAC, IBM AIX, Linux, Sun Solaris, SQL LOADER, Grid Control.

Role: Oracle DBA

Confidential

Responsibilities:

• 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,11.2 11gR2 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.
• Implementing Physical and Logical Standby setups Data guard Configurations.
• Involved in installation, configuration and support of Oracle 11g RAC.
• Worked on using the Materialized views for large Data Replication between 2 production databases.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports.
• Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Production Support for Critical Application Databases, work closely with Application Team in identifying issues and provide
• solutions for various issues created via IBM-CMR,IMR in-terms of incidents and work orders of different severity levels like Sev1, Sev2, Sev3, Sev4 .Used IBM MangeNow.
• 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.
• Implemented backup policy using oracle RMAN. Prepared test environments for backup/recovery using RMAN. And legato TAPE backup management.
• Recovering Databases when there is any Physical or Logical Corruption.
• Created routines for Daily, Weekly Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
• Implemented Transparent Data Encryption TDE for compliance related databases.
• Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection. Also did Capacity Planning.
• Responsible for purging and archiving the production databases.
• Detected locks and resolving in-doubt transactions manually. Tuned oracle SQL statement by tracing.
• Tuned database servers by using new 10g features ADDM, AWR, Keep/pin objects, tune recovery time, ran SQL trace and generated TKPROF reports.
• Providing support to clients/developers regarding SQL queries, applications errors, database errors Prepared and managed system for Data replication. Loading flat file data into tables using SQL Loader.
• High level of tracing of Optimizer and SQL performance with events 10053, and 10046 etc, recommend any changes required.
• Scheduling jobs through oracle JOB SCHEDULAR, Control M, Crontab UNIX , Scheduled Tasks Windows and Maestro 7.0 Job Scheduling Tool .
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Used DBMS packages to schedule jobs, re-engineering, gathering statistics, mview refresh...so on.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues helping to transform business requirements into environment specific databases.
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used new oracle Metalink.
• Contacting Application Team and clients to gather the information for migration. Reviewed architecture.
• Assisted developers with the Tuning during the development and tuned the applications.
• Environment: Oracle 9i,10.2.0.4,11.1.0.6,IBM Manage NOW, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL Loader, Windows XP, LINUX, IBM AIX ,WebSphere,Solaris5.9,TOAD,SQL Developer.
• Involved in 24x7 Oracle Production Database Administration.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration.
• Resolved gaps between primary and standby databases Gap Resolution .
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98 of the time.
• Creating Tables, indexes, triggers to assist developers.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Providing Solutions to the Problems Faced by end Users or Programmers.
• Scripts for Analyzing of Tables and Rebuilding of Indexes.
• Interfacing with Oracle Corporation for technical support.

Environment: Oracle 9i,10.2.0.2,11.1.0.7,Jeera ticketing tool, OEM 10g grid, SQL Loader, Windows XP, RAC, ASM, RMAN, Toad, SQL Developer, Linux, Unix, Change Control tool