SUMMARY:

• Over 12+ years in IT and 6+ years of strong experience in Oracle database administration in heterogeneous system environment including LINUX/UNIX, HPUX and WINDOWS.
• Performance tuning of the database - using utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, SPM etc.
• Data Dictionary views and various database views
• Team player with excellent interpersonal, analytical and communications skills
• Monitored and managed various database components (logical & physical) like tablespaces, segments
• Worked on Shell scripting for backup, recovery and maintenance for databases
• Experienced in full life cycle of database administration in Oracle. Provided database related services to development & QA and PROD environments.
• Good experience of Installation and configuration of RAC 10g/11g (Real Application Server) on different nodes with ASM (automatic storage management).
• Skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.
• Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting etc.
• Worked on Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers; User accounts management / Security and Auditing.
• Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.
• Extensive experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
• Experience in Implementing FLASHBACK technology and its various features in Oracle 10g/11g.
• Configured physical, logical and Active Standby Databases (Data Guard for business continuity/Disaster recovery plan.
• Experience in Oracle Golden Gate data replication across heterogeneous environment
• Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
• Wrote scripts to inform the DBA team on the status, performance and space management of the database
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Worked with development and operations staff in resolving problems quickly and efficiently
• Resolve the bottlenecks in all the database environments.
• Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers.
• Extensively used Oracle Enterprise Manager (OEM) 10g/11g/12c for maintaining and monitoring databases.
• Experience in Logical backup using and full/ partial export/import and Data Pump.
• Experience in a database migration project team, serving in both an advisory and technical capacity
• Team mentoring and technical support, administrative, daily, weekly and monthly reporting
• On call technical support for 24x7 mission critical production databases. Willing to work beyond regular hours.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP

RDBMS: Oracle 10g/11g/12c

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Agents, Real Application Clusters (RAC), ASM, Golden Gate, Sql Developer, TOAD, Exp/Imp, DataPump (expdp/impdp),SRVCTL,SQL*Plus, Recovery catalog, Autosys, Crontab, HP Manager / Services, My Services, OTG etc

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM etc

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Collegeville, PA

Lead Consultant (Oracle DBA )

Environment: RHEL 5.X, 6.X; HPUX, AIX, Sun Solaris, Windows X; Oracle 10g, 11g, OEM 11g/12c, RAC, DATA GUARD etc. About 1200 servers, 8500 databases and 1350 applications)

Responsibilities:

• Automated hourly, daily, weekly system health reporting using Crontab, PL/SQL and shell scripts.
• Performed Hot Backups, Cold Backups (RMAN, EXPDP/IMPDP, EXPORT / IMPORT, OEM)
• Created recovery catalog, database complete and incomplete recovery using different utilities.
• Datagaurd / Disaster Recovery creation, management, testing, implementation etc. (Physical/logical/Active standby databases.
• Database Refresh / Replication from production to Dev/UAT/QA using various utilities.
• Design, develop and maintain UNIX shell scripts to collect and monitor database metrics.
• Performance tuning of the databases - using utilities like EXPLAIN PLAN, AWR, ADDM, Sql Tuning tools, advisors, SPM etc.
• Grid Control (10g/11g/12c) Installation, Configuring, management
• Oracle software installation / DB
• RAC (10g/11g) / ASM installation, configuration, management, troubleshooting etc.
• Writing SHELL SCRIPTS for the system and database for effective functionality and report generation
• Supported & maintained the Production/Test/Development databases on various servers
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, Constraints, materialized views etc.
• Migration / upgrade of databases from NON-ASM to ASM and vice versa across different platforms.
• Managing and creating User accounts, profiles, roles etc.
• Providing support / escalations to application DBA’s, SA’s and various DBA teams.
• Perform team mentoring and administrative duties, daily, weekly and monthly reporting

Oracle DBA/Shift Lead

Environment: RHEL 5.X, 6.X; HPUX, AIX, Windows X; Oracle 10g, 11g, OEM 11g/12c, RAC, DATA GUARD, GOLDEN GATE (OGG) etc. More than 420 servers with more than 2100 databases)

Responsibilities:

• Automated hourly, daily, weekly system health reporting using Crontab, PL/SQL and shell scripts.
• Performed Hot Backups, Cold Backups using various utilities.
• Data Guard (physical/logical) creation, testing, implementation, disaster recovery etc.
• Oracle Golden Gate data capture, routing, transforming and delivering across heterogeneous environment in real time with low impact
• Use Autosys, windows task scheduler and Crontab to schedule weekly backup and file clean jobs
• Database / schema Refreshes / Replication across various environment.
• Performance tuning of databases - SQL Tuning, Used Tuning utilities like EXPLAIN PLAN, AWR, ADDM, Sql Tuning tools and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Used Grid Control extensively. Configuring and troubleshooting of agent related issues, set up Rules for alert notification and schedule RMAN backups with Failure notification
• Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)
• Troubleshooting of windows Oracle database backup related issues
• Installation of the Oracle software using both GUI and silent feature and also database creation
• Worked on designing, installing, configuring & maintaining Oracle 10g/11 RAC / ASM
• Writing SHELL SCRIPTS for the system and database for effective functionality and report generation
• Supported & maintained the Production/Test/Development databases on various servers
• Extensive troubleshooting of Databases backup related issues
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Database Migration / upgrade from NON-ASM to ASM (different platforms) 9i, 10, 11g etc.
• Installation / configuring Oracle Enterprise Manager (OEM) 10g/11g/ 12c Grid Control.
• Managing and creating User accounts, profiles, roles etc.
• Perform quarterly home and database PSU patches
• Proving support to application DBA’s and SA’s.
• Proving support to my team. Handling of team escalation and E-Oncalls
• Perform team mentoring and administrative duties, daily, weekly and monthly reporting

Role: Oracle DBA

Environment: RHEL 5.X, 6.X; HPUX, AIX, Windows X; Oracle 10g, 11g, OEM 11g, RAC, DATA GUARD etc. More than 420 servers with more than 2100 databases)

Responsibilities:

• Oracle software installations, configuration troubleshooting etc. Database creation, management, troubleshooting etc.
• Performed logical and physical backups using various utilities.
• Dataguard (physical/logical) creation / configuration, testing, implementation, disaster recovery etc.
• Database Refreshing / Replication across various environments using various utilities.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification
• Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases
• PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)
• Worked on designing, installing & maintaining OCR, 10/11gRAC ASM
• Supported & maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Database Migration / upgrade across various platforms and versions.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.

IT Technician / Trainer

Environment: Windows 98, NT 2000/2003, XP, Win7, MS Office 2000/2003/2007, Desktops, Laptops, Printers, Scanners, Copiers, Projectors etc .

Responsibilities:

• Training of students in General Computer Concepts, Software (OS and applications) and computer Hardware
• Training of students on internet concepts and techniques, MS office applications and basic computer troubleshooting and repairs
• Configuration & Administration of the operating systems for company and clients
• Install, upgrade, repair and maintain server and PC hardware
• Install, configure Troubleshoot and Repair printers and scanners
• Install, troubleshoot, repair and set up network connections.
• Install, troubleshoot and maintain software
• Schedule maintenance and jobs using windows scheduler
• Software Upgrades and updates
• Creating and managing User accounts
• Assist in Oracle RDBMS with DB team
• Assist in school curriculum, examinations and effective course follow up