Summary

• Implemented Backups Full, Incremental and Cumulative and recovery, Incomplete recovery and disaster recovery using Standby DB or Data Guard
• Setup physical, logical standby DBs for AIX and Linux DBs using RMAN data guard
• Written numerous Unix shell scripts to perform weekly level-1, monthly level-0, twice daily archival log backup and delete catalog/nocatalog/standby
• Cloned production DBs to setup Test/Dev DBs. Periodically refresh UAT DBs every six months from production OLTP/OLAP/Data Warehouse DBs using RMAN duplicate, Standby cold copy methods.
• Restored OLAP 3TB , OLTP 0.5 TB DBs from Tape backup to point-in-time recovery for auditing

• Maintain nearly 50 total AIX, Linux, Windows DBs. These are Production, UAT, Test, Dev OLTP, OLAP, Data Warehouse, Apps DBs and their associated physical standby DBs. Newly created about 20 DBs among these with dbca, Customized shell script methods
• Installation of Oracle software 9i/10g/11g in AIX/Linux/Windows environments. Install OEM Server, client
• Apply required patches Patching , Critical Patch Update CPU , Patch Set Update PSU , One-off patches using OPatch and run installer
• Upgraded oracle DB versions e.g. 11.2.0.2 to 11.2.0.3.10 . Swap standby, primary DBs when required
• Responsible for 24X7 data synchronization between the 2 OLTP and 2 Archival DBs via Oracle Streams
• Extensive experience in managing Schemas, Profiles, Tables, Indexes, Roles, DB links, Constraints, Views, Synonyms, Sequences, Global Temporary tables, packages and stored procedures
• Extensive experience in using NAS Network Attached Storage for various DB Backup, Recovery, migration operations
• Used 11g physical standby DBs for temporary read/write testing with restore point, flashback method

• Migrated all Production, UAT, Test, Dev OLTP, OLAP, Data Warehouse, Apps-Server total about 40 DBs from IBM AIX 5.3 to RedHat Linux 2.6
• Migrated associated physical standby DBs total about 10 of above production DBs from IBM AIX 5.3 to RedHat Linux 2.6

• Upgraded Production, UAT, Test, Dev OLTP, OLAP, Data Warehouse, Apps Server total about 50 DBs from Oracle 9i to 11g in AIX 5.3
• Migrated all associated production physical standby DBs from Oracle 9i to 11g

• Converted data for - CAP - Consumer Assistance Program from existing cap2000 Oracle 9i MS Access to cap.net Oracle 11g using SQL Loader, External tables, DataPump and Imp/Exp methods
• Written custom PL/SQL packages to convert old system schema data to new system schema , mapping 100s of old Vs new tables and converted data
• Migrated data from MCI old smog program from Tape backup to current NGET application huge tables with size upto 250GB
• Used TDE Transparent Data Encryption to encrypt data. Implemented tablespace encryption using Oracle wallets
• Used Oracle DB Vault Realms, Multi-Factor Authorization and Command Rules to provide security controls around access to DB and applications
• Used Oracle's Transportable Table Space TTS to move tablespaces during AIX to Linux DB migrations

• Wrote huge PL/SQL package purging scripts to do nightly purging to contain OLTP DB data within 7 months while purging maintaining all the integrity constraints among 100s of tables. Tuned the purging scripts to complete within 1.5 hours within the daily maintenance time frame and scheduled to run daily
• Converted purging scripts to generic scripts and used the same scripts to purge required archival DB tables
• Written numerous Unix shell scripts to purge alert logs, dump, listener logs, trace file scheduled it to run daily

• Written numerous pl/sql packages and korn/bash shell scripts to ETL Extract, Transform and Load the data from Archival DB into Data Warehouse 3TB size DB joining numerous tables ranging from 150 to 400 million rows. These are ETL which runs Daily, Monthly and Quarterly for respective duration reports
• Written numerous complex views joining 10s of tables selecting from Data Warehouse tables which feeds the Hyperion reports
• Written numerous Unix shell scripts which wait for dependency on nightly data load trigger the ETL, email the success/failure of individual ETL loads

• Written, maintenance of numerous Unix shell scripts parameterized to monitor target DBs run 24X7
• E.g. scripts : To check the DB, listener is up and running, to check the tablespace sizes, file system sizes, archival log destination is within the threshold limits. Monitor standby DBs are in sync 24X7 with primary
• Written scripts to email/text errors to on-call DBA those errors recorded in the alert logs or any alerts from the above monitoring scripts.
• Wrote complete Streams Monitoring scripts. To name a few a monitor the capture/apply queue sizes/latency is within threshold limits for peak, non peak hours b Suspend/restart all streams replication c Suspend/restart specific table's replication d Text alert the on-call DBA if the streams capture/propagation/Apply objects is abnormal, or the queue size, latency exceeds threshold
• Wrote generic parameterized scripts to Install Oracle Streams which can be adopted in UAT, Prod, ST environments or any other new environment

• Done Optimizing Oracle DB for performance tuning in OLTP, OLAP, Data warehouse systems using oracle utilities such as ADDM, AWR, ASH, Statspack, CBO, Tkprof, Explain Plan, Sql Trace, SQL Advisor, Utlbstat and Utlestat, OEM Advisor Central ADDM Advisor, Segment Advisor, Undo Management Advisor, Memory Advisor, MTTR Advisor, SQL Access Advisor, SQL Tuning Advisor
• Tuned DBs for on-growing growth and upgraded applications. E.g. sga, shared pool, steams pool, buffer cache sizes. Troubleshoot/fix DB server related CPU, memory, I/O, disk space, resource contention issues
• Tuned numerous SQL queries to make a significant difference in the query run time. Tables of sizes up to 250GB with rows 500 million plus were handled
• Partitioned numerous tables to increase performance of application as appropriate
• Tuned Oracle Streams when DBs were upgraded from 9i to 10g and 11g and DBs were migrated from AIX to Linux

• Designed, written and implemented complete Streams replication scripts to replicate data in a 4 way data path environment 2 OLTP bidirectional 2 Archival DBs
• Methods used including one-capture to many apply, queue forwarding, suspend/start streams for entire schema /single table and apply DML handlers
• Log the streams queue size/latency every n minutes based on peak/non-peak thresholds, generate streams measurement logs Excel report and email it daily
• Written complete pl/sql package sets Recon to replicate data in a 4 way direction. Recon is run once daily or on demand to back the streams replication. Recon is also used when streams is offline
• Introduced propagation servers to increase the performance of Streams

• Have used ODM Oracle Data Mining . Audited data using Oracle data audit methods DB auditing, value-based auditing, fine-grained auditing, Logminer and flashback utility
• Audit corrupted data and compare it with an available restore. Fix the data from good source
• Compare source Vs target schemas between different DBs sync the target schema with the difference

• Worked in the design and develoment of CAP Consumer Assitance Program. This includes requirement analysis, logical design, schema refinement, physical design and secutiry design using ERWin,Visio.
• Worked in the design and develoment of NGET Next Generation Emissions Testing. This includes requirement analysis, logical design, schema refinement, physical design and secutiry design
• Reverse engineering of schema design from existing production/UAT schema make required additions generate PDF schema documents
• Forward engineer and generate DDL from ERWin for generating the target schema

• Taking on-call every alternate week and attend, fix production DB, data replication, table synchronization, ETL table data issues
• Coordinate with IT-Ops team and perform DB related tasks on various week end and off hour maintenance activities E.g. NAS upgrade . Support periodic production schema releases
• Mentor Staff DBAs on issues they are unable to resolve

• Setup ODBC connectivity to mysql DB using Oracle OCI utility
• Load/query data from mysql DB into Oracle DBs for daily data loading
• Setup streams replication from Oracle source DB capture to SQL Server DB apply

• I have an expert level of experience in PL/SQL programming and in using various oracle dbms, utl packages, various analytic, group functions.
• Written most of the ETL packages which load data into warehouse schema. Numerous huge pl/sql ETL packages with several thousdand lines of code were written, tuned and scheduled to run on a daily basis
• Involved in the design, development and coding application development of NGET PL/SQL interfaces which validates, manipulates XML data received from analyzers and process the data into numerous target tables
• Involved in writing code to nighlty data load processing vehicle,station,technician , receiving the flat file data from DMV, parse it, load it into inbound tables using sql loader and then process them into target tables, monitor the received data replicated via streams/Recon to other OLTA and 2 other OLAP, Ad-Hoc DBs, alert with emails/pager on encountered errors
• Written code to generate numerous HTML reports using only PL/SQL, send emails from pl/sql using utl smtp with excel, pdf attachments. Used utl file extensively to generate Oracle Streams apply handlers
• Written numerous PL/SQL packages to schudule, monitor Recon processes and alert on-call DBA with emails/pager during error
• Created an Oracle job of jobs which self generate list of nightly jobs every night which includes kick-start, start/end checks of list of nightly jobs. Wrote numerous Dynamic PL/SQL scripts to generate code in runtime

• Used data pump, imp/exp, sql loader on various occasions. To name a few, get a subset of data from prod DB and setup development DB, Clone existing schema data and setup new schema with identical data
• Used transportable tablespaces during the migration of AIX to Linux 11g DBs

• Distribute DB related issue tickets to staff DBAs. Verification of resolved issues after completion
• Trained staff DBAs in the existing applications, DB maintenance, monitoring scripts, data replication and nightly data load maintenance

• Solid understanding of Oracle internal architecture which includes but not limited to a Memory structures SGA DB buffer cache, Log Buffer, Large Pool, Java Pool, Streams Pool, Shared Pool , PGA b Process structures SMON, PMON, DBWn, LGWR, CKPT, MMON, MMAN, ARCn, RECO, DIAG and c Storage structures d Listener, TNSNames, SQL net, OCM - Oracle Connection Manager and e V and DBA Views
• Have in-depth knowledge of the complete application in various areas not just from DB side, but also at development, ETL, front end App servers, Hyperion reports, network areas and how they work
• Innovative and Creative on tasks. My managers left feedback in my LinkedIn profile that I am an Asset of the Organization

SKILLS HIGHLIGHT

• OS AIX 5.1, 5.2, 5.3, 6.1, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x Oracle Enterprise Linux 5.5, 6.x,
• HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10 and Windows NT/2000/2003/XP
• RDDBMS Oracle 11g, 10g, 9i, 8i. Exposure to 12c
• Languages SQL, PL/SQL, MYSQL, C, C , VB, JavaScript, Unix Shell, Ksh, bash and Perl
• Scripting, COBOL, PASCAL
• Application Tools DBCA, DBUA, Oracle Data Guard, OEM GC , RMAN, ASM, SQL Developer 4.0,
• TOAD 9.0, SQL Loader, SQL Plus, Imp/Exp, expdp/impdp datapump, Veritas/Arkea
• Tape Backup. NAS, SQL Trace, Explain plan, TKProf, Statspack, AWR, ADDM, Oracle
• Streams 9i,10g and 11g
• Data model Tools Visio 2007/2010/2013, Erwin 7.x/8.x/9.x, TOAD 9.0
• Web Tools HTML, XML, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metalink
• Business Intel. tools OWB 9i, Hyperion
• Application Servers Oracle 9iAS Release 1 2 , WAS 3.0
• Version Ctl. Systems Tortoise CVS, SVN, VSS
• Issue trackers Citrix, GForge, Collabnet