SUMMARY

• A self - motivated, enthusiastic self-starter, team player and pro-active Oracle Database Administrator having around 9 years of experience, who can rapidly identify problems and propose alternative solutions and formulate plans to obtain goals, quick assimilation of cutting edge technologies and concepts.
• Oracle Database Administration experience on Red Hat Enterprise Linux R5, Sun Solaris 10.x, HP-UX, AIX and Windows operating systems.
• Oracle Database Administrator Certified
• Database design, implementation and administration experience on Development, Testing, Staging, and production in RAC environments. Strong experience in migrating & upgrading RAC environment across different OS
• Performed several database upgrades from 9i to 10g, 10.2.0.1.0 to 10.2.0.4.0, 10.2.0.4.0 to 10.2.0.5.0, 10.2.0.X.0 to 11.2.0.1.0 ., and 12c and proficient in cloning DBs.
• Worked on various latest features including ASH, ADDM, AWR, data pump, flashback recovery features, Real Application Testing, Active Database duplication for building standby databases, Advanced Table compression etc.
• Experience in Golden gate 10.4.0.x & 11.2.0.x
• Experience in Data guard and Implemented and maintained physical & standby databases.
• Setup various types of backup including the Level 0, 1 (differential and cumulative) incremental backups using RMAN.
• Tuning and Troubleshooting RAC nodes, performance tuning etc. and familiar in Oracle optimizer, usage of Explain plan for SQL tuning, TKPROF,SQL TRACE, using Optimizer hints, Gathering statistics, Statspack/AWR, Oracle Resource Manager etc and also accustomed with various advisors like Memory Advisors, Undo Advisors, Segment Advisors, SQL Tuning and Access Advisors for effective tuning of database.
• Provide 24*7 Primary and secondary on call production support.
• Designed, Documented, Implemented, and maintained all disaster recovery procedures. Performed disaster recovery drills in all production and standby environments.
• Allocating system storage and planning future storage requirements for the database system
• Strong scripting skills using Unix Shell and controlling and monitoring user access to the database & Implement database security audits as per SOX compliance.
• Strong knowledge in DBA support of phases of Software Development Life Cycle (design & development, implementation) in large-scale multi-user (systems) environments

TECHNICAL SKILLS

Language: PL/SQL, T-SQL, Unix Shell and perl Scripts.

Database: Oracle 8i, 9i, 10g, 11g, and 12c releases, MS SQL Server 2000 and 2005, MS Access 2000 and 2003, Informix.

Methodologies: Six Sigma Methodologies (DMAIC, DMADV), CMMI, PCMM, IS 0 9001 2000.

Object /Data Modeling Tools: IBM Rational Rose, Visio 2000, Erwin 7.1.x.

Database Tools: Oracle Enterprise Manager (OEM) Grid control, Foglight 4.x and 5.x, TOAD for DBA Suite, RMAN, ESM v2.7.2 and v4.1, spotlight, BMC Patrol.

Advanced Database Concepts: RAC, Dataguard, Replication, Goldengate, ASM.

Version Control tools/ Testing Tools: Visual Source safe (VSS), IBM Rational ClearCase, ClearQuest, Mercury Quality Center.

Others: SQL*Plus, SQL*Loader, Crystal Reports, Minitab, SAP, Reflection-X, Putty, Hummingbird Exceed, SSH Tectia.

Operating System: Windows Server/NT/2000/XP, Sun Solaris 10.x, IBM-AIX 5.3, Red hat Enterprise Linux Release 5, HP-UX.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior Oracle DBA

Responsibilities:

• For Resolve check environment, Migrated the databases from the server Sun Solaris 10 to RHEL5. Production primary is in Alpharetta data center and standby is in Kansas city.
• Set up target environment kernel parameters, creating necessary groups, Oracle users etc.
• Capacity planning for the new environments.
• Target environment is 3 node RAC primary with 3 node RAC physical standby (Data guard). In addition Development, SIT, Training, Pipeline1 and 2 all in RAC environment.
• Migrated the databases from VERITAS Cluster file system to ASM & ASM to VCS file system.
• For DBA maintenance files, we use OCFS2 as well as NAS file system.
• Configured RMAN, patched till the latest PSU patches. Performed the failover + switchover before delivery.
• Installations performed both by manual as well as through automation process.
• For RDS environment migrated the databases to IBM AIX 5.3 9ML. each database is of size 1.4 TB. Test environments are in Secacus and Alpharetta. Production primary are in Alpharetta, Standby are in Kansas city. Added the node each to primary and standby environment to RDS application as part of scalability.
• Applying Quarterly CPU / PSU patches, bug fix patches, one off patches, merge patches etc.
• Performing Disaster Recovery exercise once a year for each application. Setting up Flashback on standby, failing over and then rolling back flashback feature.
• Setting up Golden gate replication from 10.2.0.4.0 database to 11.2.0.1.0 database. Plan to replace Streams with golden gate
• Set up OEM 11g Repository database, OEM 11g Agent and golden gate plugin Installations.
• Implementing and managing Oracle Enterprise Manager (OEM) and Grid control for performance, administration and maintenance of databases.
• Implemented Oracle OEM 11g Agent cloning tasks for hundreds of servers & databases.
• Working on BMC Remedy Client to set up alerts, black out alerts during maintenance or upgrade, working on the assigned tickets & managing ticketing alerts.
• Provided the support in upgrading the BMC Remedy ARS 7.1 to BMC Remedy ARS 7.6.03 & customize the best practices per the database requirements.
• Upgrading the database from 10.2.X to 10.2.0.4.0, upgrade from 10.2.0.4.0 to 11gR2.
• Building the standby environments with Duplicate database feature in 10g and active database duplication over network in 11gR2.
• Supporting both OLTP (concurrent users close to 1000) and data warehouse environments.
• Using Invisible Index 11g feature for performance improvement in test & prod environment.
• Using compression feature in datapump 11g for exporting and importing huge databases as part of migration.
• Performance tuning, proactive monitoring activities using Spotlight, AWR, ADDM, monitoring scripts etc.
• Configuring service names in OID.
• Setting up RMAN backup, performing restore and recovery for new builds. Regular troubleshooting activities.
• BCC is proof of concept application; we have implemented latest features like Advanced Table compression, Real application testing etc.
• Cloning TechTest1 to Techtest2 environments.
• Worked on data cleaning activities like converting Long Raw datatype to BLOB datatype for 800 GB table.
• Following Standards and policies, updating / providing suggestions.
• Troubleshooting with tools like OSWatcher, RDA etc
• Creating SRs with Oracle support (Meta link) both including regular and SSC support for troubleshooting the issues.
• Installing oracle management agent and configuring for Enterprise Manager Grid control.
• Interaction with application team for implementing the change control requests, trouble shooting day to day issues.
• 24*7 on call production support on weekly shift basis.

Environment: Oracle 11.2.0.1.0, 10.2.0.5.0, 10.2.0.4.0, 10.2.0.3.0, 10.2.0.1.0, Golden gate 10.4.0.x, 11.2.0.x Red Hat Enterprise Linux Release 5 update 4, Windows, Sun Solaris 10.x, IBM-AIX 5.3, SQL Loader, Erwin, Quest Tools like TOAD for DBA suite, spotlight and Fog Light, BMC patrol, Hummingbird Exceed, SSH tectia, ESM, DNT and Visio.

Confidential, New York City, NY

Senior Oracle DBA

Responsibilities:

• Administration, Monitoring, and managing the databases using OEM grid control and handling OLTP database and data warehouse databases for Personal Lines, Quotes and Policies environments.
• RAC Environment
• Designed/Architecture, Installed and configured RAC on three nodes with ASM and OCFS2 storage systems and managing the entire RAC environment.
• Load balancing the RAC nodes depending upon the peak batch schedules by altering the Preferred/Available features for Services.
• Creating several services depending upon the requirements to meet TAF (Transparent Application Failover) and batch jobs.
• Performance tuning the RAC environment - AWR reports, ADDM, Global Cache wait events, checking wait event views, checking various dynamic performance views - gv$views.
• Migration of Servers, database upgrades
• Migrated the databases in the server Sun Solaris and upgraded the databases from 9i to 10g.
• Steps involved:
• Upgraded the databases from 9i to 10g in source itself using patches, DBUA etc. Care has been taken in creating Sysaux tablespace as part of 10g requirement.
• Set up target environment kernel parameters, creating necessary groups, Oracle users etc.
• Installed Oracle 10g software Confidential target environment.
• Using Data Pump utility, export and import from source to target environment. For RAC environments, setting up of SSH, OCFS2, Oracle ASM, installing cluster software, RAC database software etc have been done.
• Standby database setup - prepared the existing primary database for Data Guard environment, setup standby database Confidential California Confidential maximum performance mode as part of disaster recovery setup.
• Managing Failover and switchover operations.
• Monitoring the databases with grid control.
• Depending upon the peak load, altering the protection mode for standby databases
• Setting up RMAN backup activities.
• Monitoring the growth of database to ensure smooth running of daily activities.
• Grid control setup for various databases for centralized monitoring. Installing the Management agent on all nodes for managing those nodes through grid control dbconsole.
• Leading Change Control request (CCR) meetings and implementing the CCRs.
• Performed database creation, cloning, user management activities on various databases along with Junior DBAs.
• On call production supports both primary and secondary and partitioning activities in high data warehouse environment.
• Unix Shell Scripting for automating the jobs and running the perl scripts as part of installation, patching etc.
• Used several DBMS packages for database performance monitoring and tuning activities.
• Backup restore and recovery activities using RMAN and regular hot backups.
• Setting up RMAN catalog database and registering all the databases with catalog. Configured RMAN repository (catalog) for backups, restore and recovery.
• Monitoring the backups and troubleshooting for issues using OEM and Grid Control.
• Tuning the queries along with application development team for Materialized views, improvements in dynamic SQL programming and reconciliation of data etc.
• Using SQL Tuning and Access Advisors and recommending the application development team to improve the performance of SQL queries.
• Monitoring the long running queries, listener, free space and database growth in OEM and taking appropriate action.
• Monitoring database performance / bottleneck using AWR, Statspack and Oracle Enterprise Manager Database and Grid Control.
• Loading / transforming the data using SQL Loader.
• Interaction with AutoSys group for automation related activities.

Environment: Oracle 10.2.0.4.0, 10.2.0.1.0 and 9i, Red Hat Enterprise Linux Release 4 and 5, Data Pump, Export/Import Utilities, Windows XP, Sun Solaris, SQL Loader, Erwin, Quest Tools like TOAD and Fog Light, Reflection-X and Visio.

Confidential

Oracle DBA

Responsibilities:

• Worked as an Oracle DBA in a Team of 4 striving for 100% Client satisfaction, providing vision, process improvement initiatives, providing premeditated and strategic planning for Database/vendor upgrades and meeting all user SLAs.
• Implemented 10G Active Data guard using Physical standby allowing instant updates from primary to standby. Standby database is in READ ONLY WITH APPLY status.
• Create/manage Data guard Physical Standby instanceswith automated ksh/sql scripts using flashback database and refreshing the Physical Standby Reporting Server nightly. Standby is open READ/WRITE during the day and in managed recovered mode early AM rolling forward the days changes daily.
• Managed and executed SQL tuning sets and migrating them with their related tuning profiles and commendations throughout the SDLC lifecycle.
• Provisioned and implement Oracle app server 10.1 for Forms and Reports
• Clone databases using RMAN incomplete recovery and rolling forward until a sequence or specific time.
• Strong DB performance skill sets analyzing all session wait events, node metrics, optimizer statistics, optimizer plan in-efficiencies and SGA and process PGA memory sizing
• Hinted using outlines, 9i and dba tuning profiles 10G using in some cases hash joins over nested loop joins
• Installed configured 10G instances including the new 10G RMAN features (REMOTE CLONING) and RAT (Real application testing).
• Starting implementing Oracle PSUs that combine baseline performance tested, regression tested one-off patches base lined with CPU’s (Critical Patch Updates). I am apply PSUs quarterly starting with 10.2.0.4.1
• Execute AWR/ASH reports identifying database events and hangs and create/monitor service requests with Oracle metalink.
• Provision master replication/materialized views sites, setting up public and private schema database links and refreshing daily using OEM scheduler and cronusing 9i and 10g.
• Exceptional RMAN Backup and Recovery Skills - Accomplish and setup hot, full and incremental backups via CRON. Provide regular backup and recovery using RMAN and Data Pump import/export.
• Excellent scripting skills - Above average UNIX cron scripting skills in an AIX and Solaris environment.
• Performed manual upgrades from 9i to 10G in place upgrades and import/export for smaller databases
• Provide user support for new products comprising setting up roles, privileges, users and synonyms and modifying/creating PL/SQL packages. Deploying user schema, data structures and all related objectsand modifying/creating PL/SQL packages, functions and procedures, etc.
• Monitor and baseline Oracle performance metrics via grid control always looking to improve Client application performance.
• Monitor both PGA and SGA storage structures. Implemented AMM (automatic memory) management and pga aggreagate targetbased on Solaris LPAR memory constraints.
• OEM Grid control - Monitor instance performance using AWR and ASH reports investigating event waits such as concurrency and CPU performance. Provision OMS and OEM Agents on AIX nodes.

Environment: Oracle 10g/9i, Linux, Solaris, VERITAS, OEM, EXPLAINPLAN, TKPROF, AIX, Oracle 10g, RAC,TOAD