PROFESSIONAL SUMMARY

• Over 11 years of extensive experience as an Oracle Database Administrator including 5 years' experience with Oracle RAC.
• Working experience in database administration, design, development, performance tuning, and high availability solutions. Exceptional and proven database management skills with extensive experience in managing Oracle implementations, upgrades, data replication, database security, PL/SQL development, disaster recovery solutions, and patch management in a large complex UNIX and Windows environment.
• Over 3 years of experience as a Developer.
• Holds many certificates and diplomas in Information Technology.
• Expertise in database design, architecture, installation, configuration, upgrades, replication, cloning, backup/recovery, performance tuning and database security.
• Extensive experience with Oracle RAC, Oracle Enterprise Manager Grid Control, Data Guard including Active DG and Flashback.
• Experience with replication solutions like Oracle Streams, Shareplex, Golden Gate and heterogeneous replication using IBM CDC/IIDR.
• Expertise in database security - SOX compliance, database audit, user profiles, security patch updates, connection manager and PCI layer 3 migration.
• Experience with Oracle SuperCluster/Exadata, architecture, capacity planning, LDOMs and zones.
• Performed PL/SQL development, Shell scripting and Performance tuning top activity, SQL tuning/profile, AWR global/diff, top events.
• Experience with ASM storage, ACFS, HACMP AIX Cluster, Unix/Linux Administration, RAID, SAN storage.
• Strong Knowledge of Oracle Designer and Erwin for data modeling.
• Performed data conversion and development across several platforms and contributed in all phases of Software Development Life cycle SDLC .
• Experience with My Oracle Support MOS /Metalink for Oracle SR, patch download.
• Exceptional skills in evaluating Oracle products and state-of-the-art technologies.
• Experience with database administration of SQL server 2005 and 2008 including stored procedures, backup and recovery, and SQL tuning.
• Experience with IBM MAXIMO service desk and on-call tools for problem/incident management and on-call support.

PROFESSIONAL EXPERIENCE

Confidential

Oracle/SQL Server DBA

• Involved as a Lead DBA for logical and physical design of Trackwise Database.
• Created ERDs for various subject areas using TOAD Data Modeller and reverse engineered the Trackwise DB for creation of schema reports.
• DBA involved in designing ETL STAR schema for Trackwise BI and Analytics. Working with performance engineering team in reviewing and tuning codes for ETL, stress testing with Neoload, supporting Webfocus reporting application on reporting database.
• Created database packages, stored procedures for Trackwise Analytics and data conversion projects.
• Installed Oracle Golden Gate with the support of team.
• Tuning hotspot application codes SQL queries, DB procedures using TKPROF traces and explain plans.
• Benchmarked application performance with performance engineering team using NeoLoad for small, medium and large size deployments.
• Documented customer facing database tuning and best practices guide for flagship product trackwise for Oracle 11g and 10g.
• Principal DBA supporting all production databases hosted in-house and customer sites in OLTP, data warehouse and reporting database environments.
• Installation of Oracle 12c release 1 on Linux 6 and documentation of new features.
• Moving databases from non-ASM to ASM for GE Healthcare.
• Applied Oracle CPU April 2013 patch on all in-house customer databases on Linux.
• Performance Tuning on databases Terabyte in size for GE Healthcare on 11gR2 RAC on Red Hat Linux using AWR, ADDM, ASH, tuning advisor and TKPROF traces.
• Copying in-houses databases from production to development environment using Transportable Tablespace and Datapump.
• Upgrade of key customer databases from 10g to 11gR2. In total 30 customer databases upgraded in less than a month.
• Troubleshooting issues in live customer databases and root cause analysis.

SQL Server DBA Responsibilities

• Installation of SQL Server 2008 R2 on Windows Server 2008R2 64 bit and Vmware
• Administration and support of all in-house application databases.
• Planning for Backup, maintenance and disaster recovery of production databases.
• On-Call support for Trackwise for pharmaceutical companies like Novartis, Medtronic, etc.
• Documented new features of SQL Server 2012 edition.

Environment: Oracle 12c, Oracle 11gR2, Grid Infrastructure, ASM, RAC, Oracle 10g, RMAN, Oracle partitioning, SQL Server 2008R2, Red Hat Linux 5/6, Windows 2008, Idera SQL Diagnostic Tool, TOAD Data Modeler, NeoLoad

Confidential

Sr Oracle Database Administrator

Responsibilities:

• Performed configuration, Installations of ORACLE 11gR2 RAC databases Including Grid Infrastructure.
• Configured application backups / RMAN, worked on Datapump, ASM and RMAN.
• Configuration, Installation and maintenance of Oracle 11gR2 RAC databases including Grid Infrastructure.
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Involved in setting up of data guard for 2-node standby.
• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery complete Incomplete .
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Skilled with AWR, ADDM, SAR to check health of database hardware.
• Installation of Oracle database 10g software with RAC using Oracle Clusterware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.

Environment: Operating Systems: IBM-AIX, SunSparcSolaris64bit, and Redhat Linux., Oracle Database Server 10g/11g, Programming Language/Tools: TOAD, PL/SQL

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Primary Database administrator for several production databases.
• Worked as team member to provide 24/7 on call production database support.
• Installation, Configuration and Administration of Oracle 11g RAC and Oracle 10g RAC.
• Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC, Standby Database Active Data Guard , Replication.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Migration of all Oracle 9i/10g databases/clients to 11g.
• Migrated NON ASM databases to ASM databases.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Upgrade and Migration of Database's from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
• Installation and configuration of Golden Gate
• Implemented backup and recovery procedures Cold/Hot backups, RMAN Incremental backups Import/Export
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Written Shell scripts to Monitor activities like availability of database listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
• Good exposure to oracle technologies like AWR ,ASM ,Flashback and data pump import/export
• Installed and configured OEM Grid control and intensively used Diagnostic tuning packs along with AWR ADDM reports.
• Written Shell scripts to Monitor activates like availability of database listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Partitioning of large tables for better performance and manageability.
• Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.
• Logical Physical Database Design
• Capacity Planning and Benchmarking
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• Applying Quarterly patches and Version change patch bundles.
• Created users, roles and granted privileges according to the business requirements.
• Oracle services have been used to configure Golden Gate high availability for the RAC nodes.
• Works with management, peers and vendors to design and implement hardware/software configurations, logical models, operational management models and business continuity plans for systems under management.
• Upgraded from 10g to 11gR2 with Golden Gate as the downtime is very less , Also configured extract and replicat features.

Environment:Red Hat Linux 5.6, Oracle 10g/11g, SQL Plus, PL/SQL, SQL Loader, SQL Server 2008, Toad and SQL Developer, VNC server, NETAPP Manager, RMAN, ORACLE Streams, Golden Gate and Data Guard.

Confidential

Senior Oracle Database Administrator

• Provided 24/7 database administration and development support for MAXIMO, GIS ArcSDE , and Primavera Project management system in production, development, test/training environment running on Oracle 10g, 9i, 8i databases.
• Installed, configured, cloned and supported GIS spatial production, replication, QA/test databases.
• Developed and performed database backups and recoveries including point-in-time production database recoveries.
• Implemented Oracle 10g database export and import procedures using data pump.
• Developed and modified Crystal Reports based on Business Unit requirements.
• Performed data mapping for MAXIMO application upgrade to version 7.0
• Created SQL scripts, shell scripts, PL/SQL stored procedures, functions and triggers.
• Performed data conversion, uploaded data using SQL Loader, and created Oracle procedure for GIS Accident data processing.
• Performed restructuring of GDOS tablespaces with partitions and sub-partitions Performed partition administration including creating and maintaining partition tables and indexes, and creating local and global indexes.
• Created SOP documents for Oracle database backup, recovery and maintenance.
• Installed and configured Oracle 11g database and tested new features.
• Developed implementation plan for Oracle 10g 32-bit upgrade to 11g 64-bit .
• Installed and configured Oracle 10g RAC, Clusterware and ASM on Linux.
• Performed Oracle RAC administration, troubleshooting and backup/recovery.
• Installed and configured virtualization solutions like VMware Server/ Virtual PC.
• Implemented and configured Oracle 10g Streams and physical/logical data guard.
• Performed Oracle Streams and Data Guard administration and troubleshooting.
• Installed SQL server 2008, created databases, performed backups and recoveries including point-in-time recovery, and performance tuning using SQL profiler.

Confidential

Oracle Database Administrator

Responsibilities:

• Supported 50 databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
• Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
• Day to day performance monitoring and tuning of database. Monitoring of database objects like rollback segments, temp segments and tablespaces. Diagnose and troubleshoot Database problems and failures.
• Monitor on a regular basis, as part of database preventive maintenance, the database Growth, alert logs and archive log destination space through Toad and OEM.
• Configured Dynamic SGA in Oracle Database 10g - Automatic Shared Memory Management ASMM .
• Configured the Streams and Data guard in Oracle 10g
• Migrated from Single Instance databases to RAC databases
• Refreshed databases using Exp, import, hot, cold and rman backups from Production to non-prod Environments.
• Monitor database performance with Statspack, v -views, OEM and TOAD.
• Intended solutions and performing global enterprise database backup and recovery
• Handling large database environments Data warehouse using ETL tools and Oracle Enterprise Manager OEM on daily basis observing the performance of the production database and constantly active monitoring performance and space management issues and accordingly providing on-the-fly solutions to make database healthy and running.
• Storage and Space management including table spaces and data files. Management of table space growth, monitoring data files additions and extent growth.
• Taking care of all alerts for space issues and user requests.
• Tuned SQL queries by using Trace, Explain Plan, Tkprof and maintaining appropriate indexes.
• Working with Clients, Business analyst and Reporting team.
• Designed tools to proactively report system and database availability in highly available environments. Created SQL and PL/SQL scripts to provide periodic reporting and database monitoring for internal and remote customers.
• Developed or maintained Oracle backup and recovery scripts. Used Oracle backup utility RMAN/EBU to implement Oracle backup and performed a number of times of disaster recovery. Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Extensive experience in supporting multiple production databases running 24 x 7 mission-critical or OLTP applications demanding high availability and increased performance.
• Provide support for Oracle Enterprise Manager Grid Control and Agents.
• Checking the invalid objects recompiling the invalid objects by using utlrp.sql.

Environment: Oracle 10g/ 9i, DB2, HP-UX, Solaris, OEM, Statspack, Tkprof, AWR, ADDM, TOAD, ERWIN, RMAN, ASH.

Confidential

Oracle DBA

Responsibilities:

• Installed Oracle 10g RAC with 2 Nodes on New Data mart Database Servers RHEL- 4.0 with New SAN Storage.
• Performed Migration of the databases from normal file system to Automatic Storage Management ASM for managing huge data in SAN.
• Experience ensuring the high availability, Performance and integrity of databases.
• Configured logical/physical Data guard and managed data guard using data guard broker.
• Performed system analysis, data modeling, development, testing, and data conversion for Mutual Fund application.
• Provided database administration, application support and user training.
• Performed and managed application development for Mutual Fund plans.
• Managed a team of 2 Developers/DBAs and offered training to branch office personnel.
• Served as a point of contact for technical support.
• Installed Oracle 10g, Gridcontrol on Linux, Sun Solaris and Windows servers.
• Have worked Data modeling, building complex logical data models using sophisticated modeling techniques and tools like TOAD, Erwin and Visio.
• Defining strategies for database implementation, high performance, streams, failover and Disaster Recovery.
• Responsibilities included system analysis, data modeling, data conversion, design, testing and development of forms, reports, PL/SQL procedures, and functions.
• Performed database backups, recoveries, data conversion, and year-end-activities
• Setup backup and recovery procedures using RMAN.
• Have done database backup and recovery using Cold backup/ Hot backup/ Logical .
• Worked on import/export, Datapump and SQL- loader.
• Created and managed database objects such as tables, indexes, partition tables and views.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Manage data architects, data administrators and client enhancement requests.
• Expertise in Client server GUI software and different Operating systems.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• SQL tuning and Database tuning based on reports generated by SQL Trace, TKPROF Reports, AWR, Statspack, Explain Plans and monitor the database performance on daily basis.
• Extensively worked on Database administration activities like Installation, Configuration, Backup Recovery and Database Security.
• Expert in upgrade and configuration of MS SQL Server and databases in clustered and non-clustered environments.
• Database and log backups restoration, backup strategies, scheduling backups.
• Created Database Security by giving proper permissions to users and roles.
• On Call 24/7

Environment: Oracle 10g R2 RAC, Solaris , Red Hat Enterprise Linux 4, Data Guard ,Grid, OEM, ASM, RMAN, ASSM, AWR, OWB, sql developer, Toad, PL/SQL, Shell scripting .

Confidential

Oracle DBA

• Planning, installation, configuration, management and troubleshooting of Oracle 10g and 11g databases on Linux and Windows OS
• Performed Oracle database Upgrade and Migration from Oracle to 10g to 11g
• Created tables and views for developer and client needs
• Performed shell scripting on UNIX, AIX, Linux platforms.
• Database tuning and capacity planning to ensure acceptable level of performance
• Utilized SSH and remote desktop to administer Oracle databases from Chaveran's office to remote users
• Installing the Oracle software versions - 9i and 10g
• Writing scripts to create tables, views, indexes and synonyms per developer needs
• Creating databases and tablespaces from logical data model
• Creating users, roles and assigning users the appropriate roles as defined by application requirements
• Documented database structure, changes, problems, issues for future reference
• Help senior DBAs in tuning databases to maximize result return time
• Schedule jobs using various Oracle tools such as Oracle OEM, DBMS JOBS and SCHEDULER
• Partitioning large tables using partitioning keys
• Performing exports, cold and hot database backups
• Providing remote technical support using SSH and terminal services