SUMMARY:

• Over 17 years of IT experience encompassing a wide range of skill set and roles across various industry verticals. I have got around 15 years of experiences specific to Administration and Architecture. As a lead have been handling various teams with a maximum size of 15 with Unix/Linux/Solaris/Windows platform. Solid hands - on experiences and outstanding troubleshooting skills to Setup / Configure / Monitor / Maintain Oracle 10g/11g/12c RAC / ASM / Data Guard/Golden Gate environments.
• Oracle Certified Associate, DBA track - OCA
• SAP Certified Technology Associate System Administration or DBA for HANA
• Received Service Recognition Achievement Reward for 10 years Completion Confidential Confidential . Provided Solutioning for various Fortune 100 clients of Confidential during this tenure.
• Around 15+ years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, Performance tuning, backup and recovery, cloning, space management, database security, Auditing.
• Worked as a team member to provide 24x7 on-call production database support.
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g,11g and 12c in UNIX/LINUX, Confidential -AIX,HP-UX and Windows environment. Particularly installation of 12C, 11g RAC on ASM.
• Responsible for HANA installation, upgrades and patching
• Around 17 years of experience in Oracle Database 11g, 10g,9i, 8.x,7.x, 6.x along with DB2 in both transactional and ware house systems.
• More than 10years of experiences and solid hands-on experiences in Installation / Configuration / Performance Tuning / Troubleshooting Oracle GoldenGate in Oracle to Oracle homogeneous environments and heterogeneous environments (including Oracle to Oracle and MS SQL Server to Oracle).
• 10+ years’ experience in huge size Oracle data warehouse (more than 30TB) solutions and ETL architecture, development, maintenance, production support, data modeling, reporting fields. Extensive knowledge and experiences on various ETL, reporting, and database development tools such as Informatica, Erwin and Power Design.
• Proficient in Oracle database backup & recovery strategies plan and implementation such as user-managed backup, RMAN backup with/without catalog, cold and hot backup, full / incremental backup.
• More than 10 years experiences in PL/SQL, Procedure, Functions, Triggers, Packages development in applications such as Financial, Confidential fields.
• Highly skilled in SQL and PL/SQL Tuning, TKProf, Explain Plan. Expertise in monitoring and performance tuning of Oracle database through tuning application, memory and disk by using Statspack/AWR/ADDM/SQL Advisor.
• Also having an additional skill in J2EE technology like EJB, Servlets, JSP, Struts, JDBC, LDAP and XML.

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

Sr Oracle DBA

Responsibilities:

• Currently working as Sr Oracle DBA and responsible for End to End Oracle Solutions. Responsible for Sizing, Installation, Upgrade, day to day Administration of Oracle DB.
• Installed, deployed and supported Oracle Grid/RAC 11g Release 2 on Linux 5 and AIX 6.1 with ASM.
• Planed, Configured, Set up and Supported high availability and high scalability Oracle 10g RAC/11g RAC on Red Hat Linux and AIX 5.3 with ASM.
• Involved in administration of over 50 Oracle 11g/10g R2 instances.
• Upgraded 11gR2 grid infrastructure as out of place patch.
• Applied patches on Oracle 11g/10g Clusterware and RAC databases.
• Extensive experience with rolling patches on 11g/10g grid/RAC.
• Applied numerous PSU, CPU, Patch set and one off patches to RAC, ASM and databases.
• Configured OEM Grid Control 11g to manage the entire database in single centralized location.
• Configured and troubleshoot ASM Cluster File System (ACFS) for 11gR2 Grid/RAC cluster.
• Configured, tested and supported Oracle data guard RAC standby for RAC primary and standalone standby for RAC primary.
• Creating table spaces, tables, and users for custom applications in SQL Server.
• Designed reliable, space and time efficient RMAN backup strategy.
• Coded various RMAN report scripts to report backup stats like time taken, compression ratio, backup set sizing, backup level, job status etc.
• Implemented data compression to reduce storage and improve performance for certain queries.
• Creating and maintaining Physical and Logical Data Guard (Standby Database) for Disaster Recovery.
• Setup, configure, developed database automatic monitoring of alert log, database status, space usage, connectivity, SGA etc.
• Expertise in the Cloning (Refresh) databases from production to dev, testing. Coded scripts for automatically nightly refresh/clone of databases.
• Expertise in Monitoring and Performance Tuning of the Databases through Tuning Applications, Tuning Memory and Planning Disk Usage.
• Expertise in configuration and implementation of Backup and Disaster Recovery, UNIX Shell Scripts, Perl scripts, RMAN and Export/Import utilities, Datapump.
• Experience in Capacity Planning, Space Management and Storage Allocation.
• Controlling and Maintaining System Security through Profiles, Roles, Privileges and Auditing.
• Migrated databases from HP-UX to LINUX.
• Providing the Go-live and Post - golive Support for the database performance related issues and Ensure that all the work is documented for future reference.
• Determine time estimates and schedule for own work and resolve issues in timely manner.
• Working with Server Admin to resolve the server level issues.
• Performed DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequences etc.), space management (tablespace, rollback segment), and monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
• Implemented Oracle advanced security across various database levels

Environment: HPUX10, LinuxRedHat, Windows2000/2003Oracle8i (8.1.6/8.1.7 ), Oracle9i/10gR1, RAC, ASM, RMAN, SAN Replication, Oracle Enterprise Manager, Network Management, Oracle Partitioning, Standby, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2000, Toad, SAP Business Objects 4.0/4.1, SAP Data Services 4.1, SAP BW 7.3, HANA 1.0 SP8

Confidential, New Jersey

Sr Oracle DBA

Responsibilities:

• 24x7 Production database and applications support.
• Administering ORACLE Databases 9i, 10g, 11g and also Oracle10g RAC/11g RAC.
• Installed, Configure and maintained 2 Node 10g RAC with ASM development databases.
• Configured and Upgraded to Oracle 11gR2 from 10g and from 11.2.0.2 to 11.2.0.3
• Successfully implemented oracle 11gR2 Physical Standby database using Oracle Data Guard in High availability configuration.
• Experience on Configuring ASM (Automatic Storage Management) which includes creating disks, disk groups for the RAC environment
• Monitoring productions servers through Oracle Enterprise Manager OEM to manage databases and diagnosing database problems.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN,QUEST Shareplex,VERITAS Net Backup.
• Involved in implementing Dashboard-based Monitoring solution by developing shell scripts and SQL scripts and also worked on Perl scripts.
• Experience in code migration, database change management and data management through the various stages of the development life cycle
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for RAC Databases.
• Performed tuning the queries using OEM and also set up base lines from OEM.
• Worked on Streams Database where Schema level Replication is done.
• Used OEM extensively and set up Rules for alert notification and schedule RMAN backups with failure notification.
• Installing, configuring and maintaining ORACLE APPLICATION EXPRESS, ORACLE GATEWAY and APACHE WEB SERVER.
• Wrote shell scripts for purging trace files, alert log and network log files in Sun Solaris boxes which is used as standard script across all the databases.
• Writing PL/SQL triggers, procedures, and functions.
• Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems; monitored database usage, and reported on database performance and system availability.
• Extensive experience in performance tuning of database, memory & I/O using tools such as AWR, ADDMand analyzing queries using EXPLAIN PLAN, SQL-TRACE and TKPROF
• Proficient in SQL, PL/SQL, stored procedures, packages, triggers, forms and report.
• Designed logical and physical Data Models using ERWIN forward-engineered into DDL and executed n large scale to create database also specialized in data architecture methods and database normalization.
• Installed the Oracle software using silent feature and also created databases.
• Maintenance and monitoring of table spaces, data file, control files etc.
• Extensively worked on setting up auditing in many databases we supported.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication. Used Oracle Advanced.
• Managed CRONTAB file, rescheduling the failed jobs( due to errors), changing timings for the scripts to run if the job fails and adding new jobs (scripts).
• Replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Monitored lock Escalation, Dead Locks, resources utilization by sessions, capturing long running SQL queries.
• Performed DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequences etc.), space management (tablespace, rollback segment), and monitoring (alert log, memory, disk I/O, CPU, database network connectivity).

Environment: Red hat Linux 4.X, Confidential -AIX 5.2, Windows2000 Server, Oracle 10gRAC/9i, Oracle Streams, Toad, Sql-navigator 2000 & 2005, PL/SQL 8.0, SQL*Loader, Oracle Warehouse Builder, ODBC, ASM, PL/SQL, OLTP, OEM, Erwin 4.1.2, VERITAS Net backup, HANA 1.0 SP7, SAP Business Objects 4.0/4.1, SAP Data Services 4.0, SAP BW 7.3

Confidential

Oracle and HANA DBA

Responsibilities:

• Review of Database logical and Physical design.
• Install, upgrade and maintain Oracle software products/versions for on Linux and HP-UX.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
• Installed RAC on Oracle 10gR1and worked on ASM feature with EMC Storage of Oracle
• Had played the supervisory role to the offshore team for a brief period of time.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security
• Database Restore using RMAN, Cold Backup, Export and Flash Recovery.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Used OEM extensively and set up Rules for alert notification and schedule RMAN backups with failure notification.
• Installing, configuring and maintaining ORACLE APPLICATION EXPRESS, ORACLE GATEWAY and APACHE WEB SERVER.
• Wrote shell scripts for purging trace files, alert log and network log files in Sun Solaris boxes which is used as standard script across all the databases.
• Writing PL/SQL triggers, procedures, and functions
• Corporation and installation of patches.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Problem analysis involving interactions/dependencies between UNIX and Oracle.
• Production support for Oracle running on UNIX.
• On-Call 24x7 DBA support for production databases.
• Security User Management, Privileges, Role, Fine Grained Auditing, Risk Management, Profiling, Authentication.
• Data Migration as part of enterprise data warehouse project.
• Performed migration using transportable table space (TTS) to transport tablespaces across platforms.
• Extensive Performance Tuning, Memory (SGA) Tuning, RAC tuning, net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data Guard.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Involved in the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Data management.
• Used Erwin 4.0 for data modeling and Dimensional Data Modeling.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Worked on HANA data acquisition layer, transformation, reporting via logical views and eventually using BO tools. Managed team of 10-15 members and mentored various people Confidential SAP practice in the field of SAP BI. Developed many real time use cases to using latest HANA and BOBI/BODS products. Worked on integration of SAP HANA and Data Services 4.0/4.1 with other non-SAP products. Installation and configuration of Data Services 4.0/4.1 and Information Steward 4.1 Used the SAP BO 4.1/4.0 business Intelligence capability on top of HANA and created complex analytical reports in Explorer, Design Studio, Xcelsius. Also created the semantic layer using IDT, UDT. Responsible for BO install, upgrade patching. Has performed BO upgrade from 4.0 to 4.1 and 3.1 to 4.0. Worked on LCM, Promotion Manager, Upgrade Management Tool. Responsible for HANA installation, upgrades and patching Configurations for SAP ECC Accelerations using SAP HANA. Worked on HANA Live Solutions. HANA operations and backup and recovery. I have been part of many paper publications Confidential SAP Sapphire and Teched. Worked on HANA Live implementation Confidential LSS and for multiple clients. Planned and implanted for solutions like ECC/CRM/BW on HANA, Lumira, Predictive Analytics, HTML, XSJS, PAL and R libraries, Mobi and Explorer. Worked on various SAP HANA/BO RDS Solutions.
• Deployeed SAP HANA onto various hardware vendor platforms including VMware environments. Part of SAP BW 7.3 on HANA implementation work for various clients.

Environment: Red hat Linux 4.X, Confidential -AIX 5.2, Windows2000 Server, Oracle 10gRAC/9i, Oracle Streams, Toad, Sql-navigator 2000 & 2005, PL/SQL 8.0, SQL*Loader, Oracle Warehouse Builder, ODBC, ASM, PL/SQL, OLTP, OEM, Erwin 4.1.2, VERITAS Net backup, Data Stage 8.0, Business Objects XI R2,3.1, TOAD 9, HP UX 11

Confidential, Milwaukee

Oracle DBA

Responsibilities:

• Installing, Creating and Migrating the Oracle database on 10g Release2 and Involved in performing migration from Oracle 8i, 9i, 10g to Oracle 10g Release2 RAC database.
• Supported in Oracle 9i OLTP Data Guard 30GB 24*7 Production Environment.
• Implemented Oracle Streams for the replication of data in Development to Production.
• Utilized Oracle Streams to Capture, Propagate and apply the transfer of data, transactions and events within managed databases.
• Responsible for around 30 Oracle DBs.
• Maintained instances of around 750GB with 500 Users and around 30 Production and Development instances.
• Configuring database entries and monitoring all of the databases using Oracle Enterprise Manager (OEM).
• Troubleshooting on the databases for Application Server and Oracle database related issues.
• Used ERWIN for logical and Physical database modeling.
• Developed PL/SQL packages, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts.
• Used ERWIN for logical and Physical database modeling.
• Physical Database Capacity Planning and data-files mapping.
• Wrote PL/SQL Scripts, Packages and views to extract load and create data files using DTS
• Developed various reports using the BI tool to generate reports for the Sales department and Marketing representatives.
• Extensively used cron for scheduling of the UNIX shell script jobs.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Migrated data from Oracle to Sql server using the Sql server Migration Assistant.
• Created Heterogeneous services for accessing the database links from an Oracle database to Sqlserver database.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Daily Health Checkup of the database using statspack, AWR, ADDM.
• Install, Configure and implement Oracle Advanced Replication as the lead DBA.
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Scheduling jobs through Oracle Job Scheduler.
• Management of schemas, objects partitioning the tables & indexes.
• Created database objects like tables, indexes, synonyms, views etc. using SQL* Plus, used SQL*Loader control files to load data from external data sources into Oracle database.
• Tested the loaded data and documented the errors and reporting.
• Created the data flow diagrams using Oracle Designer as the CASE tool.
• Perl Scripting, Shell Scripting, bash scripting and PL/SQL Programming to resolve business problems of various natures.
• SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility and AUTOTRACE utility.
• Migration of data from MS SQL Server 2000 to Oracle 9i.
• Created scripts for data migration from flat files and MS Access to Oracle.
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
• Involved in sizing and planning of large VERITAS Net backup environments.
• Taking Periodic Backup of the databases and the software using RMAN.
• Recovery of Database(Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator.
• Worked with the business analysts throughout the development cycle, and provided post-implementation support, for data and report issues identified by customers.

Environment: Red hat Linux 4.X, Confidential -AIX 5.2, Windows2000 Server, Oracle 10g,RAC/9i, Oracle Streams, Toad, Sql-navigator 2000 & 2005, PL/SQL 8.0, SQL*Loader, Oracle Warehouse Builder, ODBC, ASM, PL/SQL, OLTP, OEM, Erwin 4.1.2

Confidential, Moline

Oracle DBA

Responsibilities:

• Worked as a DBA in the Database Support Team to support (daily On-Call rotation) production and non-production environments.
• Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
• Performance Tuning and Troubleshooting of custom and vendor apps running on Oracle databases using AWR/ADDM, traces/tkprof, explain plans, profiles.
• 24X7 On-call support rotation to the production database.

Environment: Oracle 10g/9i, TOAD 9, HP - S.O. HP UX 11

Confidential

Oracle DBA

Responsibilities:

• Involved in daily maintenance of all the DBs along with on-call support when needed.
• Developed Unix Shell Scripts, Perl Scripts, PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Loaded source data files with SQL*Loader and imp/exp utilities.
• Created Oracle database objects(tables, partition tables, b-tree and bitmap indexes, constraints, views and materialized views), PL/SQL Procedures/Functions/Packages, SQL and Korn shell/Perl Scripts and develop transaction processes based on created objects to support business needs and reports needs. Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
• Performance tuning and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.

Environment: Red hat Linux 4.X, Confidential -AIX 5.2, Windows2000 Server, Oracle 10gRAC/9i, Oracle Streams, Toad, Sql-navigator 2000 & 2005, PL/SQL 8.0, SQL*Loader, Oracle Warehouse Builder, ODBC, ASM, PL/SQL, OLTP, OEM, Erwin 4.1.2, VERITAS Net backup.

Confidential

Oracle DBA

Responsibilities:

• Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT.
• Worked closely with developers in Designing Schema / tuning PL*SQL/ SQL code.
• Performed Database Tuning for Oracle 8i & 9i servers including reorganization, SGA, kernel, redo log tuning, Rollback tuning.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Environment: ORACLE 9i/8i/7, SQL, PL/SQL, Toad, Pl/SQL Developer, Cronjob, Import/Export, UNIX AIX 5.1,Windows 98/NT/2000