SUMMARY

• Hard - working and enthusiastic wif extensive Oracle DBA experience including 7 years as an Oracle DBA.
• A highly result oriented Skilled Oracle DBA certified Associate wif extensive experience as Oracle DBA (12c, 11G, 10G, 9i, and 8i) on various platforms AIX, HP, SUN Solaris, SUSE Linux, RHEL, Oracle Enterprise Linux and Windows NT (Production, Development and Test environment Proficient).
• Experience included providing support to over 100 Development, Test and Production Databases including critical Production Financial Databases comprising of complex and challenging Unix, Linux, Solaris, Windows environment in Oracle versions 10g, 11g and 12c.
• Extensive technical knowledge on Database Migrations, Installation, Upgrade, Reorg, Cloning, Patching, Unix and PERL Shell Scripting, RAC, Dataguard, RMAN, Performance Tuning, Proactive Database monitoring, Performing routine Health Checks, Automating scripts and DBA Tasks, Capacity Planning, Database Backup and Recovery.
• Implemented Oracle11g RAC systems wif ASM on Linux servers.
• Specialized in Migration of Oracle databases from Oracle 8i, 9i, 10G to teh latest releases - Oracle 10G and 11G.
• Experience in planning & implementation of Backup & Recovery strategy, RMAN. Performance Tuning AWR/ stackpack for as tuning of application, shared pool, buffer cache, I/O distribution, rollback segments, redo mechanisms and SQL code.
• Refreshing test and development databases as needed wif production data using Data Pump (expdp, impdp).
• Proficient in ORACLE DBA - Installation of Oracle RAC, ASM, SANand disaster recovery - data guard setup and Streams configuration. Designing & Testing of database, administration, backup & recovery strategy implementation according to teh volatility of teh data, user management, performance monitoring/tuning and database security.
• An effective communicator wif exceptional relationship management skills wif teh ability to relate to people at any level of business and management.

TECHNICAL SKILLS

Operating System: Solaris 10, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, 7, Linux, Windows server 2003

RDBMS: Oracle 8i/9i/10g/11g/12c, SQL Server, Sybase, Teradata

Languages: Oracle SQL, PL/SQL, T-SQL, Bash/Korn Shell scripting,HTML, Perl, C Programming.

Database Tools: Oracle Golden Gate, SQL Developer, SQL Listener, Toad, App Designer, Data Mover,SQL*Loader, SQL*Plus, SQL Navigator, BRTOOLS, Grid Control,Goldengatev11.1/11.2RMAN, Export/ Import, Data pump, BCV, RM (Replication Manager) - emc2 backup toolAppworx 6, Goldengate Manager, SQL server Enterprise Manager.

Telnet Tools: PuTTy, Secure Shell, MobaXterm

Ticketing Tools: BMC Remedy, Bridge clarify, CMR (Change management request)

Others: NAGIOS, MRTG, SNMP, WinCSP, FileZilla.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Level 2 Oracle Operational DBA

Responsibilities:

• Oracle HA Stack: Install, Configure, Setup, Maintainand Support Oracle 11gR1, 11gR2, Physical and Logical Standby database for Test, Development and Production for various home-developed applications.
• Familiarizing myself wif Oracle 12c on a Single Instance and Two nodes RAC Database by performing installation, configuration and monitoring DB activities.
• Develop upgrade roadmap and perform upgrade from 11.2.0.4 to 12.1.
• Installing ASM environment and migrating database from NON-ASM to ASM storage Instance.
• Thorough understanding of architecture and operational mechanism of CRS, GNS, GPNP.
• Configured SCAN as a cluster alias for load balancing and as a client connection failover mechanism.
• Used Oracle Golden Gate for Basic and Advanced Data Replication between Oracle Database Servers and Legacy Databases
• Performed History pull to synch-up data between Oracle to Non-Oracle (Tandem, SQL Server) databases using Golden Gate
• Set up DDL/Bi-directional replication
• Built Oracle MAA Physical Standby and Logical Standby and configure Data Guard Broker for High Availability/Disaster Recovery purpose.
• Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN wif Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file table spaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL tuning Automation, Flashback Database, compression techniques etc.
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF for optimized results
• Write and automate UNIX shell, SQL scripts, and Grid Control for ease in administrative tasks and monitor databases to optimize performance, resource use, and physical implementations of databases
• Worked on Capacity Planning, Space Management, Security Management, Auditing, Shell scripting, Memory and Tuning.
• Working wif Application Development team to address any issues they encounter and provide support and resolution action plan.
• Addressing and supporting both Test and Development tickets in co-ordination wif Application Development Team.

Environment: Environment: Oracle11g/12c wif RAC, Oracle Golden Gate, Oracle Data Guard, HP-UX 11i v3, Sun Solaris 10, RHEL 6.x, TOAD.

Confidential, Hoffman Estate, IL

ORACLE DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition and resolution of database issues. .
• Involved in capacity planning and configured 11gr2 RAC for high Availability.
• Converted single instance database to RAC Databases.
• Configured databases for BI and worked on databases sizes from 2TB to 30TB.
• Applied patches to Oracle Databases using Opatch utility and upgraded databases manually and implementedUp-gradation of databases from 10.2.0.x to 11.2.0.x.
• Involved in migrating HP-Unix databases from 10g/11g to 11gR2 Red hat-Linux.
• Involved in configuration of parameter files for extract process in primary and replica process in standby using Golden Gate.
• Installed Golden Gate for replication of database on 11gR2 RAC environment.
• Configured parameters for teh Bi-directional replication using Golden-Gate.
• Extensively used data-pump at schema level for migrating data from Solaris to Linux.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Troubleshooting RMAN whenever backup failed and Configured retention policy, archive log deletion policy for Production databases and registered databases in catalog server.
• Involved in Management of schemas, objects partitioning teh tables & indexes.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Perform other regular DBA activities including space management and performance Tuning. Extensive Performance Tuning, Memory (SGA) Tuning.
• Taking periodic Backup of teh Database and teh software using RMAN and supporting VERITAS Net-backup Team.
• Familiar wif ORA-600 error. Involved wif dis ERROR.
• Involved in Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints

ENVIRONMENT: Oracle 10g, 11gR1/R2, HP-Unix 7i, RHEL 5.x, OEL 6.3, OEM 10g/11g, RMAN, RAC, ASM, Data guard, Virtualization Tools, AWR, ADDM, ASH, Data pumps.

Confidential

Oracle Core DBA

Responsibilities:

• Hands on experience on Installation, Upgrade & Patching of Oracle Database and its components.
• Implemented teh Upgradation of database from 10g to 11g.
• Database Cloning activities as per client request - Production to Test environment.
• Performed Refresh on Staging and DEV environments from production using conventional export/import and datapump utility.
• Monitor database health, regular backups on daily basis.
• Maintenance and monitoring of Database and Listener.
• Checking Alert log, trace files, and other database job logs.
• Worked independently wif oracle support to resolve outstanding issues or bugs under teh supervision of teh team lead.
• User creation and providing necessary Roles, Privileges and quota as per teh requirement.
• Managing table spaces, data files, redo logs files and maintaining Indexes.
• Written teh Shell Scripts in coordination wif system admin for monitoring teh alter logs, disk spaces at O/ S level, table spaces at DB level, to check teh availability of database and listeners, and automated jobs through cronjobs.
• Good knowledge on various tools like RMAN, exp/imp, expdp/impdpetc provided by oracle for database backup and recovery. Able to take all forms of physical and logical backups.
• Good knowledge of Oracle backup and recovery scenarios.
• Troubleshooted issues related to locks, session hangs, blocking sessionsetc and provide details to teh project teams.
• Good understanding on oracle dictionary related views and information available wifin those views.
• Direct interaction wif development team and client partners on daily basis to resolve teh issues.
• Working wif online (development) team to resolve online issues wifin SLA.
• Planned, designed and implemented RMAN backup strategy for Oracle 10g on Solaris 10 server

Environment: s:Oracle 10g, 11g, SQL*Plus, SQL,Red Hat Linux/Unix/IBM AIX, Putty, Remedy, Service Catlog, Terminal Service, RAC,RMAN, Oracle Enterprise Manager,Winscp,Toad, Application Designer and Data Mover.

Confidential

Database Administration

Responsibilities:

• Installation and Configuration of Oracle Database (10g) on on Solaris and Windows Platforms.
• Scheduling shell scripts or dbms jobs using Crontab or DBMS SCHEDULER (monitoring script, listener check, backup script) etc.
• Creating and managing of database users, roles, privileges, profiles and database links.
• Creating and managing tables, functions, stores, procedures and optimization.
• Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
• Involved in performance monitoring and tuning of teh database.
• Knowledge and good experience wif database backup and recovery methods using RMAN, Data Pump.
• Expertise in oracle utilities like Export/import,/expdp/impdpsql loader, RMANetc
• Daily Health check of teh Database. And monitoring teh log files, backups, database space usage and teh use of system resources.
• Perform general technical trouble shooting and give consultation to Development/Application teams.
• Installed and Configured teh Golden Gate software and created manager, extract, replicate trail files.
• Preparing HLD, LLD, User Manual and Reviewing Code
• Worked beyond regular hours based on business demands. Provided 24x7 on-call production supports

Environment: s:Oracle 10g, 11g, SQL*Plus, SQL and PL/SQL programming and development, UNIX Systems (Linux, HP - UNIX), Putty, Terminal Service, RAC, Data Guard, RMAN,VERITAS Net Backup 4.5, OEM, Sun Cluster, Citrix Servers.

Confidential

Database Administration

Responsibilities:

• Reportal administration activity (Schedule job management, provisioning and troubleshooting)
• Requirement analysis, Test requirements gathering and Designing test strategies.
• Involved in Backup activities
• Leading teh whole project and managing a team size of 3 people.
• Fine-tuned teh processes in all servers
• Functional testing of Reportal front end.
• Presenting to teh customer Weekly & Monthly data.
• Analyze and resolve teh major live incidents as per agreed SLA.
• Trained colleagues and new bees on Reportal and network related topics
• Work on teh Upgrade plans of teh application.
• Rising issues when any server or application goes down getting it resolved by continuous interaction wif Infrastructure team located in Italy

Environment: s:Unix (sed,awk), Perl, Shell Scripting, SQL, SNMP (Perl Libraries and OS Tools), PHP,RRDTool, SQLite, Nagios (Alarm Dashboard).