SUMMARY

• More than 10+ years of experience as an Oracle Database Administrator with extensive experience in the areas of installations, migration/upgrades, production support and on - time delivery of project deliverables.
• Certified oracle professional with expertise in various technologies, including Oracle 8i/9i/10g/11g, Oracle 10g/11g RAC and ASM, Data Guard, Performance Tuning, Ab Initio GDE, OWB, Unix Shell Scripts, Unix (Sun Solaris, HP, AIX), Windows and Linux. Proven extensive working experience in database optimization and performance tuning.
• Experience in Oracle Database Administration which includes features like Real Application Clusters (RAC), Active Dataguard (ADG), Automatic Storage Management (ASM), Clusterware, RMAN,Grid Control, EXADATA and Oracle Golden Gate.
• Have both Production support experience and individual project experience where new enviroment is designed,built,configured,supported for an application till, it goes live.
• Extensive knowledge in database administration of Oracle 9i, 10g & 11gR2 with experience in mission critical large OLTP and OLAP systems.
• Involved in setting up and supporting Goldengate replication on databases with RAC and dataguard on oracle EXADATA Database machines
• Worked on Golden gate to setup unidirectional replication on 4 node RAC database.
• Experienced in ETL tools like Ab Initio, involved in development of ETL Jobs for Extracting/Data cleansing/Transfroming/loading the data.
• Involved in designing and implementing High availability and Disaster recovery solutions.
• Experienced in Database Migrations and Upgrades as well as migrations of the Oracle database across platforms.
• Experienced in proactive and reactive database performance tuning in all database enviroments.
• Successfully performed DBPITR (Database point in time recovery) and TSPITR (tablespace point in time recovery) on various situations.
• Performed capacity planning, application analysis and developed database solutions for server, database and space consolidation
• Independently handled crisis situations like restoring table/schema/database from backup, switch over and failover, resolving range of perfromance issues,etc.
• Experienced in Planning and implementing Database Backup Strategy using RMAN.
• Experience in DBA activities such as Upgrades, Patches, Cloning, Backups and Recovery, Performance Tuning, capacity planning, etc,.
• Experienced at using Oracle Enterprise Manager OEM(12c) to manage databases and configuring database monitoring using templates.
• Expertise in different environments like HP-UX, SUN SOLARIS, AIX, Linux and Windows.
• Demonstrated leadership, problem solving, research, inter-personal and good written and verbal skills.
• Able to work both independently and/or as part of a team, prioritize tasks and work on multiple assignments.

TECHNICAL SKILLS

Operating Systems: MSDOS, MS Windows 98/2000/ME/NT/XP/Vista, HPUX 10.x, 11.x, Sun Solaris 2.5, 2.6,5, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux 2.1, 3.x, 4.x, 5.x,6.x

Language: SQL, Unix Shell Scripting.

RDBMS: Oracle 8i/9i/10g/11gr2 SQL Server 2000/2005

Oracle Tools: SQL*PLUS, SQL*Loader, Export/Import, Data pump, ERWIN, TKPROF, AWR / STATSPACK, ADDM, ASH, RMAN, SRVCTL, CRSCTL, ASM, RAC, ADG, Listener & Service Configuration, OEM, Toad, SQL Developer

Web Related and Other Tools: HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, MS Visio

ETL tools: AB INITIO (GDE, Data Profiler,EME & Co>operating system )Oracle warehouse builder (OWB).

Packages: MS Office, BEA Weblogic server 8.1, IBM MQ series, Extra personal client. Enterprise Architect (EA).

CVS: Star team, Subverison, WinCVS.

PROFESSIONAL EXPERIENCE

Confidential

Lead Database Administrator

Responsibilities:

• Performed Installation, configuration, maintenance and tuning of Oracle 11gr2 RAC databases.
• Successfully upgraded the Oracle Grid infrastructure and databases from 11.2.0.1 to 11.2.0.3.
• Created/managed application services on primary and standby databases and controlled the services via resource manager.
• Performed proactive and reactive database performance tuning in all oracle database environment.
• Created DataGuard Configurations including Active DataGuard managed using RMAN Duplicate as well as wiht BCV Split copy to create these Standby databases.
• Successfully upgraded the 2 node standby databases(ADG) along with Grid infrastructure from 11.2.0.1 to 11.2.0.3.
• Setup and Managed Oracle Active DataGuard environment in Oracle 11r2 and performed both planned and unplanned switchovers and failovers.
• Worked Troubleshooting and resolving the apply and transport ADG lag issues in standby databases.
• Involved in designing and implementing High availability and Disaster recovery solutions.
• Involved in installation Golden Gate server 11.2.1.0.6 and in implementation of GG initial-loads, Uni directional replication.
• Involved in setting up and supporting Goldengate replication on databases with RAC and dataguard on oracle EXADATA Database machines
• Worked on Golden gate to setup unidirectional replication on 4 node RAC database.
• Formulated Backup strategies and performed numerous Recovery operations. Methods include cold, hot, recovery manager (RMAN) and logical backups.
• Performed DBPITR (Database point in time recovery) and TSPITR (tablespace point in time recovery) on various situations.
• Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Independently delivered multiple Projects which involves tasks like design, build, configure, performance testing of database and providing support till they go live.
• Successfully built, configured and delivered multiple projects independently.
• Worked on query tuning on application SQLs that breached the SLA during the load testing in QP environment.
• Lead the Production support team and mentored the team members.
• 24x7 remote support and on call Database support for Database developers & end users.
• Performed all aspects of database administration including installs, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
• Performed capacity planning, application analysis and developed database solutions for server, database and space consolidation
• Worked on setting up Monitoring of database and OS parameters using 12c Grid control.
• Performed SQL tuning and resolved performance issues in several environments.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Mentored other team members on RAC Cluster Builds and Clusterware Administration to bring them to speed on managing these Production Clusters.

Confidential

Sr. DBA

Responsibilities:

• Worked for Open Systems DBA team which services Oracle, Oracle Apps, SQL Server databases
• Reporting to Client on a daily basis on the issues/challenges.
• Creating and maintaining all databases required for development, testing, staging and production usage.
• Installed, Administered and Troubleshooting issues related to Oracle Real Application Cluster Databases ( RAC ) for Oracle 9i and 10gR2.
• Installed, Administered and Upgraded the Oracle Clusterware (CRS).
• Implemented Node Addition/Deletion and Instance Addition/Deletion procedures for the RAC Database.
• Migrated oracle 10g database from non-ASM to ASM .
• Performed conversion of Single Instance to Cluster databases using rconfig / Grid Control.
• Tuned the RAC database for performance issues using AWR / Statspack reports.
• Performing RMAN backup and Restore in different instances.
• Performing the capacity planning required to create and maintain the databases
• Performing ongoing tuning of the database instances.
• Planning and implementing backup and recovery of the Oracle, Oracle Apps, SQL Server and Sybase databases.
• Gathering schema Stats, rebuilding index, reorganizing table has done for improvement of running application queries .
• Perfromed switchover and failover of databases using DGMGRL and Rebuilt the physical standby database after fail over.
• Rolling out quarterly patches on RAC 10g, standby databases and single instance databases.
• Controlling migrations of programs, database changes, data changes and menu changes through the development life cycle
• Implementing and enforcing security for all of the databases
• Performing database reorganizations as required to assist performance and ensure maximum uptime of the database
• Putting standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• Supporting issues as per SLA.
• Documentation of Implementation and Support activities
• Preparing Known Error Database ( KEDB ) for the team members’ which consists of all the issues faced with the resolution steps
• Evaluating releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate.
• Coordination with the Application developers, System administrators and Backup support team, to ensure the operations are smooth
• Administering all database objects, including tables, clusters, indexes, views, sequences, packages and procedures
• Troubleshooting with problems regarding the databases, applications and development tools
• Automated jobs using UNIX shell script to perform backup, partition maintenance and schedule in control-m.

Confidential

ORACLE DBA

Environment: Management System (EMS) is designed to serve the major programs of BT and serves as a common framework whereby creation of builds, developmental plans, software assets, hardware assets and their configuration

Responsibilities:

• Worked on ORACLE DBA activities such as Database Creation, Database Maintenance, Database Backup and Recovery, Database Tuning, Application Tuning, Security, Migration.
• Performed database recovery using User-Managed, RMAN-Managed Recovery to handle efficient database recovery.
• Scheduled and upgraded the Production databases to the latest Oracle patchset with minimal downtime and migrated this database from a single instance to a RAC Cluster.
• Migrated the Production database from Oracle 9i to 10gR2 on development, test and Production environments.
• Successfully planned, executed and lead several disaster recovery tests.
• Implemented Security User Management, Privileges, Roles, Auditing, Profiling.
• Applying Oracle security patches.
• Involved in regular data monitoring, data backup/recovery processes.
• Worked in Oracle 10g, 11g Sun SOLARIS 5.8 RHEL5, HP UX 11.23
• Implemented Data Guard for Disaster recovery system using Oracle 10g
• Migrated & upgraded databases from Oracle 10g to oracle 11g.
• Installation of Oracle 10.2.0.2, 10.2.0.3 and 10.2.0.4 binaries.
• Created new 10g Database and performed regular RMAN backups for all the databases.
• Patch Analysis, Patch Installation.
• Refreshed schemas from Production environment to Dev/Test environment using exp/imp and expdp/impdp utilities.
• Refreshing database using RMAN backups & BCV split backups.
• Created tablespaces and managed tablespaces by adding/deleting/resizing data files.
• Setup database auditing, granted privileges to users through system/object roles.
• Created schema (tables, Indexes, views, sequences, synonyms, packages).
• Automation of certain monitoring and scheduled activities through Shell Scripting
• Deleting data and arch file systems on legacy server after Database Migration to new server.
• Monitor and tune database performance using STATSPACK and AWR.
• Increased performance of sql queries by creating materialized views and by enabling query rewrite.
• Worked as part of a team and provide 24x7 supports when required.
• Documented instructions for migrating & upgrading databases.
• Attended the key manager, team, change control, performance meetings and conducted weekly meetings for Infrastructure DBA Team

Confidential

Oracle DBA

Responsibilities:

• Installed and configured Oracle databases version 9.x, 10g in Redhat AS 4 and Fedora 7 Linux. - Responsible for creating and maintaining the development and test database for DMF.
• Responsible for maintain different schemas and users with appropriate privileges.
• Installing and configuring the oracle client software in all machines and establish the connectivity.
• Preparing Data model and creating relevant tables and indexes.
• Involved in environment setup activities like installation of Ab Initio server (co
• Involved in configuration and administration of Ab Initio Co
• Involved in Design and development of the ETL graphs for extraction, transformation and loading data as part of DMF.
• Involved in testing the graphs for extraction, transformation and loading data.
• Worked on design and development of ETL jobs for data cleansing using Data Profiler.
• Support and Maintainence the oracle databases and of Ab Initio servers.
• Persented a comparative study on ETL tools like OWB/Ab Initio/Informatica.
• Worked on developing ETL graphs for Change data capturing to ensure zero downtime migration.

Confidential

ORACLE DBA

Responsibilities:

• Study the current architecture of the EDW.
• Study the existing source system.
• Prepare a URS document for Oracle Migration.
• Gathering various detailed information of EDW for BI implementation.
• Preparing a test database with sample data.
• Suggesting possible solution for migration and demostrated with a POC for Data migration with Transportable tablespace.
• Coordinating with offshore team and BI team to provide them the details on database.
• Discussing with client and deriving the in scope and out of scope activities.

Confidential

ORACLE DBA

Responsibilities:

• Installation and Configuration of Oracle Software in Red Hat Enterprise Linux AS 3.
• Managing Oracle instance and Creating and maintaining the database.
• Managing security of an oracle database using Roles & Profiles.
• Monitoring Database tables and system catalogs with respect to overflows and appropriate storage structure based on the nature of queries on the tables.
• Maintaining security Policy, Like System security, Data security, user security, password security and Auditing Policy.
• Performing enduser support and trouble shooting.
• Gathering Oracle database statistics - Tablespace size, Datafiles size, Segment fragmentation, buffer cache hit ratio’s etc.
• Planning backup strategy for all instances. Maintaining Back up and recovery of database.
• Performing tuning and troubleshooting general database problem in all instances.

Confidential

Systems Engineer

Responsibilities:

• Responsible for Troubleshooting, Assembling and Installing of essential Hardware and Software.
• Responsible for Annual maintenance of computers in many companies.
• System Administration For Windows2003 Server, Windows2000, WindowsXP
• Setting up the small office network.
• Backup and Restoration of data.
• Creating user accounts, groups, assigning permissions.
• Installing and configuring Operating Systems and Hardware.
• IP Addressing, Configuring TCP/IP, DHCPScopes.
• Troubleshooting file system crash, disk space problems, and network problems
• Responsible for the Hardware Sales and Services.