SUMMARY:

• Oracle Database 12c Administrator Certified Professional
• Oracle Exadata 11g Certified Implementation Specialist
• Oracle Database 11g Data Warehousing Certified Implementation Specialist
• Oracle GoldenGate 10 Certified Implementation Specialist
• Oracle Database 11g Administrator Certified Professional
• Oracle Database 10g Real Application Clusters (RAC) Administrator Certified Expert
• Oracle Database 10g Administrator Certified Professional
• Oracle Database 9i Administrator Certified Professional
• Sun Certified Solaris System Administrator
• Oracle Certified Professional 9i/10g/11g RAC DBA with 12+ year of oracle DBA experience
• Have 12+ years of experience in system analysis, design, development, implementation and production support of on - line applications with very large Oracle 7.3/8i/9i/10g/11g/12c databases
• Have extensive experience with oracle warehouse database administration and oracle EXADATA X3-8 env with 50 TB of data.
• Have Implemented table level Goldengate replication using 11.2 integrated capture between oracle databases.
• Have extensive experience with Oracle Database Creation, Configuration, Administration, patching/upgrade, Oracle Standby Creation, Maintenance, Rman Backup/Restore/refresh, Rman 11g Active database refresh, RMAN backup at standby/restore and performance tuning of large databases
• Have experience with moving/migrating large oracle databases across platform and/or storages to newer server/storage for production/development/test servers.
• Have experience with advanced oracle DBA skills like Oracle 10/11g/12c RAC, Oracle Partitioning, Oracle Data Guard, Logical/Physical Standby. RMAN/BCV backup/restores, Oracle Flash Recovery, Oracle Multi Master Replication, Materialized Views, Oracle Steams, Oracle 10g/11g ASM, Oracle 10g/11g/12c Grid, Advanced SQL Tuning, SQL plan stability for given SQL ID, Oracle database, Audit and Security Policies for very large database ( > 8 TB ) with more than 2000 concurrent worldwide users
• Have experience with Unix Performance Monitoring and Tuning on Linux/AIX,/Solaris/HP-UX
• Have Carried out Data Modeling using Erwin for Logical & Physical Database design.
• Have Experience with writing Unix shell/perl scripts to automate monitoring and admin tasks
• Have written scripts to automate daily prod clone process and on-demand Partial Mini Refresh Process for Dev and UAT env.
• Have Implemented Database Audit and Security Policies as per Oracle recommendations

TECHNICAL SKILLS:

Operating Systems: Windows 3.11, 95/98, Windows NT/2000, Open VMS, SCO-UNIX, HP-UX, Solaris, Linux, AIX 5L

Databases: Oracle 7/ 8//8i /9i/10g/11g/12c, Oracle RAC, Sybase, Informix, Access 2000

Languages: Oracle SQL, PL/SQL & Pro*C, Microsoft SQL, Unix shell scripts, perl, Java 1.4, VB Script, Java Script, HTML, PL/SQL Server PagesTools Oracle 10g Grid, OEM (Enterprise Manager), Legato NetWorker, Oracle Warehouse Builder, Discoverer, RMAN, MIG utility, 9iAS, Net-8, ODBC, Erwin, Designer 2000, SQL Backtrack SQL Loader, oracle 10g11g/12c Data Pump, oracle Export-Import, SVRMGR, Toad, and Universal Installer Control-MPROFESSIONAL EXPERIENCE:

PROFESSIONAL EXPERIENCE:

Confidential, RTP, NC

Lead SME DBA/Database Architect

Responsibilities:

• Managed and provided Primary SME DBA Database Architect support to multiple very large TB sized, very active, fast growing Prime Services Automated Trading Database with worldwide users.
• Written scripts to automate daily and on-demand Prod clone and on-demand Refresh of UAT and DEV ENV.
• Implemented Backup Strategy of taking RMAN compressed backup at Standby Database on separated physical server so that backup process and on demand prod clone process does not interfere with PROD database performance.
• Migrated large 8 TB 10g Equities Trading PROD databases to 11g from Solaris Platform to Linux Platform using datapump expot/imort and use of specifically written scripts for parallelism so that migration is completed during a weekend.
• Performed Database tuning which included use of AWR, oracle 10g/11g/12c GRID and have done tuning of: Buffer cache, shared pool, Rollback segment, redo space wait, Free list wait (use of dynamic data dictionary views such as v$system event, v$session event, v$session wait), disks sort, file I/O, row fragmentation, index fragmentation, extent size, DB block size, PCTFREE, PCTUSED
• Performed SQL tuning which involved use of super indexes, hints, proper indexes, rewriting SQL to minimize I/O, flushing a specific sql id from shared pool. SQL star join, star transformation, changing order of joins, pinging procedure/package, caching table, loading of packages at startup to reduce shared pool fragmentation, pre-running a report, use of histogram for skewed data
• Have written sql code to provide plan stability for a specific sql id without changing application code using oracle Plan Baseline.
• Performed Unix server monitoring which included regular checking of: cpu load (use of uptime, sar - u, top), paging, swapping, thrashing, processes inactive for long time, processes with high cpu time, network traffic (use of netstat for % of collision).

Environment: Oracle Databases ( 9i/10g/11g/12c RAC ), RMAN, PL/SQL, Oracle Tkprof, Oracle AWR, ASH, ADDM,10g/11g/12c Grid, Oracle ASM 10g/11g/12c, Oracle Data Pump, Oracle Physical Standby, Oracle Streams, Linux, Solaris,, Shell script, Perl Script, OEM, SQL Loader, Materialized views, RAID 5, SAN, DBArtisan, PL/SQL Developer, Control M

Confidential, RTP, NC

Primary/Lead DBA

Responsibilities:

• Managed and provided Primary DBA Prod and Dev support to multiple datbases .
• Implemented Oracle 11g 2 node RAC for “Money Movement Hub” and “Digital Platform” projects
• Written Scripts to monitor to TOP Users of CPU for a Large EXADATA X3.2 Warehouse Env
• Performed Database turing and Batch Process tuning for large warehouse projects
• RMAN refresh using oracle 11g Active database.
• Implemented table level GoldenGate 11g.2.IC replication using Integrated capture method between two oracle databases
• Rman Refresh Using oracle 11g Active database.
• Assisted Dev team with identifying bad SQL and alsonsuggested possible problem areas/solutions. Exadata X3-8 Admin Tasks:
• Applied InfiniBand switch patch by downloading/unziping/untaring/scp-ing to the dir /tmp on the switch, logging on to the switch as root, tuning, diableesm, running ./ibswitchcheck.sh pre, running command spsh and then finally executing the command load -source /tmp/filename.pkg
• Optimized parallel operation by: deleting rows in resounce io calibrate and insert a row with oracle recommended values, followed by setting parallel degree policy to 'LIMITED' and setting tables parallel degree to default for all tables and then setting parallel statement queuing to true.
• I am aware of exadata failure scenarios such as: pdu failure (Other PDU would take over, it would show up in enterprise incident manager), infiniband switch failure/ patching ( passive would take over, enterprise manger would show as switch being down ), cell software failure ( rs server would restart the server, ( in alter history it would show as core dump ), flash cache failure ( fast repair resiliveirng process would take care of this failure if write-back cache is being used, ( alter history would show this failure ) disk pull/failure ( asm re-sync for a disk pull and asm rebalance for disk failure,( it is visible in enterprise incident manager as well cell alert history), RAC database instance failure ( RAC reconfigure would occur and other instance would performs instance recovery), node failure ( as in case of motherboard failure( node eviction would occur after 30 second time out followed by client failover, RAC reconfigure and instance recovery), cell motherboard/hardware failure ( cell resync feature for all the disks is used when cell is brought up after repair, it would show up in alert history for the cell and disks would show as offline for both read and write, Enterprise manager would show cell being down).

Environment: Oracle Databases ( 9i/10g/11/12c RAC ), RMAN, PL/SQL, Oracle Tkprof, Oracle AWR, ASH, ADDM,10g/11g/12c Grid, Oracle ASM 10g/11g, Oracle Data Pump, Oracle Physical Standby, Oracle SQL Loader, Solaris, Shell script, Perl Script, OEM, SQL Loader, RAID 5, SAN, 11g Active Dataguard, Refresh using Active DatabaseGoldenGate 11.2.IC, Exadata X3-8

Confidential, Raleigh, NC

Primary DBA

Responsibilities:

• Managed and provided Primary DBA Prod and Dev support to multiple warehouse databases.
• Implemented Oracle 11g advanced compression for Large Prod Database.
• Written scripts to assist Development Team with Data Migration.
• Written Scripts to automate Partial and full Dev/QA Refresh Process.
• Written Scripts to automate purge processes for Partitioned tables.
• Written scripts to automate basic DBA monitoring tasks.
• Rman Refresh Using oracle 11g Active database.
• Written scripts to run schama compare between two envs that qa and prod.

Environment: Oracle Databases ( 9i/10g/11 RAC ), RMAN, PL/SQL, Oracle Tkprof, Oracle AWR, ASH, ADDM,10g/11g Grid, Oracle ASM 10g/11g, Oracle Data Pump, Oracle Physical Standby, Oracle SQL Loader, Solaris, Shell script, Perl Script, OEM, SQL Loader, RAID 5, SAN, 11g Active Dataguard, Refresh using Active Database

Confidential, Raleigh, NC

Primary DBA

Responsibilities:

• Managed and provided Primary DBA support to multiple very active Databases with multiple full size Q/UAT env, Standbys and Dev env with State wide users.
• Written scripts to automate Prod clone refresh process.
• Written scripts to automate Dev/Test restore process.
• Written scripts to automate basic DBA monitoring tasks.
• Written scripts for automatic data load from one oracle envy to other env.
• Assisted development process by writing triggers, indexes and procedures.

Environment: Oracle Databases ( 9i/10g/11g RAC ), RMAN, PL/SQL, Oracle Tkprof, Oracle AWR, ASH, ADDM,10g/11g/12c Grid, Oracle ASM 10g/11g, Oracle Data Pump, Oracle Physical Standby, Oracle SQL Loader, Solaris, Shell script, Perl Script, OEM, SQL Loader, RAID 5, SAN

Confidential, RTP, NC

Primary DBA

Responsibilities:

• Managed and provided Primary DBA support to TB sized, Derivative Result Prod databases ( DRD/TDRD) with 10 full size Q/UAT env and more than 10 Dev partial refresh dev env w.
• Migrated large 700 GB 9i TDRD PROD databases to 10g from Solaris Platform to Linux Platform using oracle 9i import/export Solution provided was used to migrate London and Singapore TDRD databases by other Primary DBAs
• Have tuned problematic sessions and applications by generating trace file and then analyzing text file generated by tkprof utility .

Environment: Oracle Databases ( 9i/10g/11 RAC ), RMAN, PL/SQL, Oracle Tkprof, Oracle AWR, ASH, ADDM,10g Grid, Oracle ASM 10g/11g, Oracle Data Pump, Oracle Physical Standby, Oracle Streams, Linux, Solaris,, Shell script, Perl Script, OEM, SQL Loader, Materialized views, RAID 5, SAN, DBArtisan, PL/SQL Developer, Control M

Confidential, Parsippany, NJ

Performance Tuning Specialist, Oracle DBA

Responsibilities:

• Involved in Performance tuning of very large warehousing Oracle database with 200 million rows and more than 2000 GB size
• Worked involved finding poorly performing SQL in terms of large I/O, high CPU utilization, and high memory usage and discovering the right plan and associating the right plan with poorly performing SQLS.

Environment: Oracle Databases 9i, 10g, PL/SQL, RMAN, RedHat Linux Advance Server 3.1, Solaris 9, HP-UX 11i, OEM, shell scripts, SQL Loader, RAID

Confidential, Charlotte, NC

Performance Tuning Specialist

Responsibilities:

• Managed and provided production support to more than 100 instances of database with size ranging from 10 GB to 1500 GB with more than 1200 concurrent users
• Implemented Oracle Database Audit and Security Policies as per Oracle recommendations
• Written Unix shell script to automate complicated BCV refresh process
• Configured Oracle 10g Grid for oracle database performance monitoring and availability
• Used oracle petitioning to partition some of the large tables to improve database performance
• Worked on project as Lead DBA to move/patch and upgrad Production/Development databases form older AIX servers/storages to newer AIX Servers/Storages
• Have experience with End-to-End Performance Management which requires instrumentation of codes such as dbms application info.set module/set action in the middle tier, and involves co-relating end-user-transactions with activity at middle tier, database tier, storage tier and all the network between these tiers with the help of v$session wait events or with Performance monitoring tools such as Precise/Indepth.
• Have used stored outline for plan stability of sql statements.
• Have done several performances tuning with some dramatic improvements. In one instance query execution time was reduced from 48 hour to 2 hours by using histogram on the table. In another instance detected the contention and alleviated the slow down, when running of a batch process slowed other users due to contention (for data blocks)
• Performed regular checks on database for harmful growth rate, tuning areas, I/O contention, fragmentation, performance projection and regular maintenance to avoid resource contention
• Have Performance tuned the RMAN backup process and BCV backup process for large production databases
• Have Configured Oracle Flash Recovery Area and have performed flash recovery.
• Used Oracle 10g Stream to replicate a table from production to dev databases.

Environment: Oracle Databases (7, 8, 8i and 9i/10g/11g ), RMAN/BCV backup, PL/SQL, Oracle, IBM AIX, Statspack, Tkprof, Shell script, OEM, SQL Loader, RAID 5, SAN, BCV Backups, Oracle 10g Grid, Oracle Partitioning, Oracle Patching and Upgrade, Oracle RAC, Oracle Streams, Oracle Flash Recovery, Materialized Views

Confidential, Charlotte, NC

Performance Tuning Specialist, Oracle 9i/10g RAC DBA, Production Support DBA

Responsibilities:

• Managed and provided production support to more than 50 instances of database with size ranging from 10 GB to 1.5 TB
• Have provided admin, table partitioning, data load and sql tuning production support for 1500 GB oracle wharehouse database.
• Written Unix shell scripts to automate monitoring of multiple instances of oracle 8i/9i database to ensure availability and protection of databases at optimum performance level
• Performed regular monitoring of instance availability, invalid objects, alertlog, dbsnmp process, database logical/physical backups and archiving to tape, availability of free space in tablespaces, rollback segment status, space bound objcts, missing primary key, missing index on foreign key, disabled constraints and triggers, broken or failed jobs, file/file header/block corruption, file in recovery mode, offline datafile, deadlock, runaway process, defunct process, security policy violations..
• Have implemented disaster recovery solution using synchronous replication from primary to standby database
• Worked on Real Application Clusters (RAC) database infrastructure Implementation and administration on IBM Aix 5L with 2 nodes.
• Have worked on synchronous and asynchronous replication, materialized views, multi master replication with automatic/manual conflict resolution, oracle replication manager and change management
• Have work on developing Oracle Database Audit and Security Policies as per the Oracle best practices guide lines
• Have configured Flash recovery area and performed recovery using flash recovery area

Environment: Oracle Databases (7, 8, 8i and 9i/10g/ RAC ), RMAN, PL/SQL, Oracle, IBM AIX, Statspack, Tkprof, Shell script, OEM, SQL Loader, RAID 5, SAN, Oracle Streams, Oracle ASM

Confidential, Morrisville, NC

Performance Tuning Specialist, Oracle 9i RAC DBA, Production Support ERP 11i DBA

Responsibilities:

• Involed in production support for very large 11i ERP RAC environment with multiple terabytes databases with more than 5000 users
• Provided sql tuning and database schema design production support for large oracle wharehouse database
• Performance tuned the concurrent manager Implementation
• Written tools in perl to automate 11i patch analysis which compare pre-patch image and post-patch image of critical objects and generates report for all the objects changed by the patch
• Written perl script to automate regular monitoring of temp segment and rollback segment usage for terabytes database with more then 5000 users
• Helped streamlined the DR recovery solution for very large database with raw volumns
• Written perl tools to automate purging of files
• Member of the Standard team to recommend Standards to be followed for database administration.

Environment: Oracle Databases (7, 8, 8i and 9i RAC ), RMAN, PL/SQL, Oracle 11i, RedHat Linux Advance Server 3.1, Solaris 8, HP-UX 11i, Perl, Statspack, Tkprof, Shell script, OEM, SQL Loader, RAID 5, Oracle RAC 9i

Confidential, Parsippany, NJ

Performance Tuning Specialist, Oracle DBA and Solaris Administrator

Responsibilities:

• Setup complete Oracle 9i environment on HP/Solaris Platform from scratch including configuration of storage HP MSA 1000/ Sun Storedge.
• Done Capacity Planning for very large database.
• Performance tuned very large warehousing Oracle database with 104 million rows.
• Done Application SQL tuning and Oracle database configuration tuning
• Written Performance monitoring Unix shell scripts using vmstat, mpstat, iostat, netstat
• Have Installed 10g Oracle database and migrated 9i Oracle database to 10g

Environment: Oracle Databases 9i, 10g, PL/SQL, RMAN, RedHat Linux Advance Server 3.1, Solaris 9, HP-UX 11i, OEM, shell scripts, SQL Loader, RAID

Confidential, Minneapolis, MN

Data Architect and Oracle Specialist RAC DBA

Responsibilities:

• Suggested and implemented architecture design changes to make process more efficient for content hub database for Confidential online store.
• Performed logical and physical design of content hub database using Erwin.
• Performance tuned the complex sql statements and database.
• Re-written pl/sql procedures to update the database from temp table structure
• Done Capacity planning for the large warehousing database
• Used oracle encryption package and encryption key to encrypt credit card Information in the database

Environment: Oracle Databases ( 9i RAC), PL/SQL, RMAN, Solaris 8, HP-UX 11 OCM 2.1, OEM

Confidential, Chicago, IL

Database Specialist

Responsibilities:

• Provided remote services and support.
• Installed, created and configured 9i (9.2.0.2) databases on Linux.
• Setup Data Guard on 9i Rel 2 database with two standby databases in different locations.
• Rebuilt the standby database without shutting down the production database.
• Maintained and troubleshot Data Guard in the production environment.
• Managed Data Guard using Oracle Enterprise Manager (OEM).
• Mentored and transferred knowledge to the client DBAs.

Environment: Red Hat Linux Advance Server 2.1 (7.3), Oracle 9.2.0.2, OEM

Confidential

Oracle 8i/9i DBA

Responsibilities:

• Installed and configured Oracle Server
• Performed physical and logical database design
• Performed space management by allocating system storage and planning future space requirement
• Managed database security
• Performed basic and advanced SQL and database tuning
• Provided backup and recovery strategies for databases.
• Performed backups Using RMAN, writing RMAN scripts and Unix shell scripts.

Environment: Oracle8i/9i database on Sun Solaris

Confidential, Washington, D.C

Senior Analyst Programmer and DBA

Responsibilities:

• Designed, developed, tested-debugged and implemented Underwriting, Bond, Analysis Applications.
• Used DBArtisan Tool to monitor and administer database.
• Conducted run-time maintenance and enhancement of these applications.
• Conducted data modeling using Erwin/ERX 2.0 Case

Confidential, California

Project Lead/Database Administrator

Responsibilities:

• Handled the project in the strength of Project Lead / Database Administrator.
• Met with clients/users and discussed requirements and solutions.
• Performed business-process modeling, data modeling and program flow.
• Installed and configured Oracle database on Solaris.
• Designed, developed and administered the database.
• Coded the backend packages, engines, and scheduling processes.
• Provided 24/7 technical supports on databases and tools.

Environment: Oracle Database (7, 8 & 8i), PL/SQL, Sybase, T-SQL, Pro*C and PowerBuilder, Erwin

Confidential, VA/CA

Programmer Analyst

Responsibilities:

• Worked Senior Analyst Programmer for team of twelve
• Was one of three people who finished their job way ahead of schedule and were asked to share DBA responsibilities for development database
• Involved in client/user requirement meetings and discussed solutions
• Participated in system analysis, data-modeling, and system design
• Designed and implemented the database during the project life-cycle
• Wrote backup scripts for the oracle databases.
• Had recovered Database to the point-of-crash.
• Coded the required packages / backend procedures and front-end screens
• Maintained the system and database for the client while in transition

Environment: Oracle Database (8 & 8i), Erwin, Powerbuilder, PL/SQL and Pro*C