PROFESSIONAL SUMMARY:

• Over 8 years of experience in IT industry as Oracle Database administrator, having exclusive experience in database administration, installation, configuration and upgrades with Oracle Software 11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform.
• Hands on experience with database performance tuning, backup and recovery, cloning, space management, and database security.
• Experienced in capacity planning and estimating the growth of Oracle databases
• Good exposure in Configuring Single instance, Oracle Real Application Clusters RAC and Automatic Storage Management ASM
• Strong experience in Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.
• Experience in Backup and Recovery, Disaster Recovery options and Oracle Recovery Manager RMAN .
• Experience in configuring standby databases using Oracle Data Guard.
• Expertise in setting up and configuring golden gate
• Experienced in constructing shell scripts for monitoring golden gate replicates.
• Proficient in working with Grid Control and Oracle Enterprise Manager OEM 12c
• Strong experience and deep understanding of how an Oracle database utilizes memory, CPU, and swap space in UNIX and Linux.
• Monitored production Oracle database s , identifying emerging data-related issues, including system-level and SQL-level performance and database storage utilization, performing tuning and initiating proactive mitigating measures as appropriate.
• Experienced in data center migration of Oracle RAC 11g
• Experience as On-Call 24x7 production DBA support, application/development DBA, system administrator.
• Expertise in Installing and configuring ASM and RAC for high availability databases.
• Performed Strategic Planning, Logical and Physical Data Modeling Application Tuning.
• Experience in Performance Tuning I/O, Memory SQL Tuning etc by using tools/utilities by Automated Workload Repository AWR , Automatic Database Diagnostics Monitor ADDM , Explain Plan, Autotrace, TKPROF and Statspack.
• Experience in maintaining Oracle Data Guard Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Good knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Installed and Configured the Oracle Databases 10g/11g RDBMS, Performing Pre-installation and Post-installation Tasks
• Experience in cloning Database from Production to Test and Development and from Development to Production.
• Hands on experience in setting up and administering Oracle Streams, Oracle Dataguard also configured replication based on Oracle Streams.
• Experience in migration of oracle database to higher version and installing patches.
• Expertise in Oracle database schema management, data file and tablespace management, and object privilege management.
• Experience in writing shell scripts to check to the Status, Space Management and Performance of Database. Exporting and Importing of dumps using expdp and impdp.
• Extensively used the Grid Control for maintaining many databases together on separate servers.
• Having experience in performance tuning issues using AWR and ADDM Reports.
• Responsible for interacting with business partners to identify information needs and business requirements.
• Excellent interpersonal, strong analytical and problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.
• Identified root causes and provided corrective actions for highly complex availability, capacity, security, performance, and quality issues affecting the database.
• Good Programming Skills in SQL, PL/SQL, UNIX Shell Scripting.
• Strong knowledge of database architecture design, including data partitioning and application partitioning.

PROFESSIONALL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Role: Oracle DBA

Responsibilities:

• Setting up/Installation and configuration of 11G RAC Clusterware and instances.
• Implementation and support of 11g migrations and upgrades from Oracle 10g to Oracle 11g databases, including RAC Real Application Clusters databases on HP-UX and Linux.
• Implemented 11G Data Guard Physical and Logical standby using DG Broker, experienced with 11G Data Guard new features Active Data Guard and Snapshot Standby.
• Experience with switchover and switchback between primary and standby databases.
• Experienced in installing golden gate replication and developing monitoring scripts for extracts, replicates and pumps.
• Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.
• Upgraded 10.2.0.4 Two Node RAC ASM Database to 11g R2 four Node RAC ASM.
• Installed and configured SharePlex on all database servers. Data replication using Shareplex 6.0/7.0 Bi-directional and multi replication across all prod databases for consistence across all sites.
• Creating and managing database objects such as tables, indexes, partition tables, views, rebuilding indexes and optimizing the code to improve the performance.
• Experienced in providing L3 support for the production database issues, including performance tuning
• Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Perform user and Security Administration activities such as enrolling users, Granting Privileges to users and maintaining system security.
• Translating the logical data models to physical design and validate the SQLs Adding PK's, triggers synonyms.
• Monitoring instance performance, tablespace utilization, database objects, connectivity and database availability, verification / validation of database backups, and server space availability and maintenance.
• Monitoring Oracle Enterprise Manager OEM on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Refreshing of databases using datapump utilities expdp/impdp .Troubleshooting expdp/impdp errors in a RAC environment, configuring storage accordingly.
• Wrote Shell Scripting for managing day-to-day activities and automation of backup.
• Supported development teams for moving changes to different development, test levels and prepared documentations to move changes to the live production environment
• Experience ensuring the high availability, integrity of databases database designing.
• Managing Database Locks and blocking sessions. Defragmentation of tables and indexes for improved performance and efficient.

Environment: Oracle 10/ 11g, 11g RAC, Oracle Enterprise Manager OEM , Oracle Golden Gate, RMAN, Data Guard 11G Active Data Guard, TOAD 10.6, DBArtisan 9.0.1, HP-UX 11.31, Linux 6.5, Solaris, ASM, OEM Grid Control 11.x ,Shareplex

Confidential

Role: Oracle DBA

Responsibilities:

• Involved in Oracle Grid Control11g Installation and Configuration on AIX/Unix environment
• Accountable for upgrading Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.2 on 3 node RAC environment.
• Responsible for the configuration of Physical Standby database for maximum performance mode Oracle Data Guard.
• Expertise in designing and implementing effective migration procedures in between datacenters
• Managing replication and monitoring customer's MySQL database for pending problems
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software.
• Instrumental in the Migration of databases from 9i, 10g to 11g using export/import and data pump export/import utilities.
• Used Shareplex for data replication and clustering.
• Developed various database monitoring shell scripts.
• Performed rolling patch upgrades on RAC environment for bug fixing. Setup of Jobs using the Oracle Enterprise Manager OEM database control.
• Responsible for daily incremental backup and weekly full backup of databases using RMAN. Involved in migration of applications of the clients.
• Loading data into database tables using SQL Loader. Replicated data using Oracle Golden Gate and import/export.
• Experienced working on golden gate replication issues like extract/pump abends and resolved them affectively
• Implemented Materialized views, database links. Regular database management on 9i and 11g OEM
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Tablespace monitoring, Performance monitoring and tuning for performance improvement. Creating batch files and automating the tasks.
• Granting roles and privileges to end users. Involved in the maintenance and setup of Oracle Virtual Directory in various environments including Production.
• Managing, troubleshooting and resolving oracle database and application issues.
• Interacted and Worked with Oracle Support SR whenever we faced production issues.
• Daily checkup of the database using TKPROF, AWR, and ADDM, Monitoring alert log/system log.
• Converted very slow and complicated views to tables and implemented database triggers to update them automatically.

Environment: Oracle 9i, 10g, 11g, SQL, My SQL, PL/SQL, Oracle golden gate, Oracle Grid Control, Oracle Enterprise Manager Database Control, Oracle Spatial, TOAD, SQL Developer, SQL Loader, NT, Red Hat Enterprise Linux, ASM, JAVA, HTML, Shareplex.

Confidential

Role: Oracle DBA

Responsibilities:

• Involved in installation, setup and configuration of DATA GUARD.
• Responsible for reviewing Database logical and Physical design also involved in Installing, upgrading and maintaining Oracle10g, 9i on Sun Solaris and Windows 2003, Redhat4.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Handled Application Tuning by tuning queries, identified problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects, etc.
• Implemented Database Security, Management of role-based security. Applied Patches 9.2.0.6 and Oracle DST Patches on Oracle database.
• Accountable for writing and modifying UNIX shell scripts to manage Oracle environment.
• Performed Data Migration as a part of enterprise data warehouse project. Extensive Performance Tuning, Memory SGA Tuning, Net backup, EMC Time finder and SRDF , RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN. Established database backup/recovery strategy for different databases.
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
• Management of table space growth, monitoring data files additions, extent growth.
• Constantly monitor the performance of the Databases and viewing Alert log files Trace files. Implemented schema level, table level and bidirectional Oracle streams.
• Logical and Physical data modeling using ERwin, Dimensional/ OLAP Data Modeling, Relational/ OLTP modeling.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.

Environment Oracle 10g and 9i, Sun Solaris, RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL Loader, TOAD, Erwin, STATSPACK

Confidential

Role: Oracle DBA

Responsibilities:

• Tuned ETL process of data warehouse databases to reduce load time. Worked with application developers on SQL tuning.
• Tuned performance of RAC and non RAC databases. Found bottlenecking queries that impede application performance and fine-tuned them.
• Periodically clone multi-terabyte databases to QA and UAT.
• Troubleshooting application SQLs and database performance tuning, table partitioning, table space reorg
• Design and developed alerting mechanism for several databases using Shell scripting, net cool monitoring and Grid control.
• Database performance monitoring and troubleshooting using OEM, ADDM AWR reports
• Resolved several production issues in mission critical databases and restore service within Emdeon's SLA.
• Scheduled and executed several planned maintenance operations like Patching, upgrading, redesigning, denormalizing , and partitioning.
• Restored databases using RMAN to fix corruption and storage issues.
• Support Data guard based DR sites and Replication Golden Gate and Advanced Replication based DR sites.
• Schedule on-call rotation shifts, allocate tasks to DBAs and monitor progress. Report progress of Projects and support activities to client management.

Environment Oracle 10g and 9i, Sun Solaris, RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL Loader, TOAD, Erwin, STATSPACK

Confidential

Role: Oracle DBA

Responsibilities:

• Database support Development, QA and Production for various applications on Oracle and SQL Server.
• Communicate with user groups for database requirements.
• Database and application SQLs performance tuning.
• Develop ETL process in MS-SSIS to extract data from OLTP Oracle to DW/BI SQL Server .
• Data warehouse data modeling and architecture using ERWIN DM Tool.
• Star schema design for various data marts such as financial dashboard, Sales, Procurements.
• Communicate with sysadmin group, managerial, administrative and technical staff to determine technical needs data flows and systems definitions.
• Responsible for database code migration and maintenance during all lifecycle phases of the projects assigned
• Tune SQL, PL/SQL statements found in the reporting utilities and queries
• Migrating/refreshing data from production to QA for testing.
• SQL Server 2008 R2 database administration, backup and recovery strategies.
• Implemented SQL Server Transactional Replication process for Disaster Recovery.
• Database architect and design for OLTP and Data Warehouse.

Environment: Oracle 10g, Linux Red Hat, Unix shell, TOAD, T-SQL,SQL Server 2008 R2, MS-SSIS/SSRS2008R2 , OEM Grid, Web logic 10.3.3, Korn shell

Confidential

Role: Oracle DBA

Responsibilities:

• Developed PL/SQL packages to capture end of day transactions. Implemented UTL HTTP oracle built in package to acquire data from external websites.
• Responsible for Data Modeling, Development and Support of Enterprise Database, Data Warehouse and standardizing of practice to support new sets of Application and Business intelligence solutions.
• Latest features of Merge/Multiple Table Insert/Loading and logging error in a single statement/Grouping sets, Cube, Rollup have been used to improve the performance and reduce IO.
• Involved in Data loads and Conversion of data from Legacy system to Oracle Applications and Oracle Data warehouse with the use of SQL Loader and bulk load process using PL/SQL procedures.
• Created various Database triggers using PL/SQL. Extensively used Explicit Cursors in stored procedures.
• Importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Restructured indexing to improve OLTP performance and helped developers with PL/SQL procedures.
• Developed several intricate procedures and functions to accommodate data manipulation.
• Created Tables, Views, Synonyms, Sequences and Indexes. Developed PL/SQL scripts for exception handling.

Environment RHEL, Windows, Oracle 8i, 9i, SQL, PL/SQL, UNIX Shell scripting