SUMMARY:

• More than 19 years of experience in Information Technology having experience in development, Testing, User interaction, Implementation and on - call production support and DBA activities.
• Experienced in Programming, designing database, administrating databases etc on Card processing, Risk management, Data warehousing, Care management, Banking, Sales order processing and Dispatch system applications in Oracle RDBMS using EXADATA, RAC, GoldenGate, RMAN, DataGuard, Grid control, 12c Cloud Control, Data Domain Boost, Virtual Private Database (VPD), Transparent Data Encryption (TDE), PL/SQL, Extract Transform & Loading (ETL), shell scripts on UNIX, Linux, Windows 2000 and NT environment and also supporting Reportmarts.
• Working knowledge of Big Data / NoSql systems including Cassandra (CQL), HBase / HDFS, Apache Pig.
• Extensive experience in application and performance tuning, distributed computing and handling large volume applications.
• Experienced in allocating system storage and planning future storage requirements for the Database system, Storage objects management, resource management, Auditing, Security management, Backup scheduling (online & offline), privilege and role management, Database/Table space/Rollback - growth monitoring and its optimization, Database tuning and report programs to record such activities.

TECHNICAL SKILLS:

Operating Systems: Oracle Exadata, Sun Solaris, Digital UNIX, HP UNIX, Linux, Windows NT, Windows 2000, MS- DOS

Databases: Oracle 12c, 11g, 10g, 9i, 8i, 8.x, 7.x, 6.0, MS-Access, Cassandra, HBase

Languages: C, C++, Pro*C, Shell Scripts, PL/SQL, HTML, JAVA, AWK, PERL, Python

Database Tools: SQL *Plus, Tkprof, SQLLDR, Exp/Imp, SQL *DBA, SVRMGRL, Fastunload, Rman, GoldenGate, Data Domain Boost, ERWIN, Export/Import Data pump, SRVCTL, Active DataGuard, ASMCMD, CRSCTL, DBCA, AWR, ADDM, ASH, CQL, Apache Pig, HBase

GUI Tools: Developer 6i, OEM, Cognos, Toad, Veritas, Grid control, 12c Cloud Control

PROFESSIONAL EXPERIENCE

Confidential, NH

Senior Enterprise Lead DBA

Hardware: Oracle Exadata, HP-UX Itanium, Linux x86 64

Software: Oracle 12c, 11g, 10g, Sqlplus, Pl/Sql, VPD, PERL & Shell scripts, Exp, Imp, RAC, RMAN, GoldenGate, Veritas, Toad, OEM Grid control, 12c Cloud Control, Data Domain Boost, Export/Import Data pump, Active DataGuard, AWR, ADDM, ASH

Responsibilities:

• Functioned as a lead DBA in the seamless migration of mission critical databases from HP-UX and Sun platforms to Oracle Exadata and then setup backup via RMAN and active data guard. This included creating net new 11gR2 production databases on Exadata via DBCA, setting up the database layout on ASM by pre-creating the tablespaces and then migrating the data via data pump.
• Functioned as the lead DBA architect in migrating a 100+ TB transaction history database from HP to Exadata using data pump and Golden Gate with minimum downtime.
• Involved in the 12c upgrade of various Development, QA, UAT and Production databases and documenting the issues around upgrade and resolving them.
• Involved in safeguarding data in all databases by implementing transparent data encryption (TDE) as part of data at rest strategy. Managed a team of 4 individuals in implementing TDE on various databases via minimum downtime methodologies.
• Created the standard for setting up backup via RMAN and writing backups to Data Domain appliance. This involved creating a net new database to hold the RMAN catalog thereby segregating candidate databases and their backup repository and then updating the configuration parameters in RMAN as per the candidate database specifications and then using generic scripts to take level-0 backups weekly, level-1 backups daily and archivelog backups every 2 hours.
• Created the standard for setting up active dataguard for all 11g databases. This involved creating a duplicate database without backup using the latest 11gR2 feature in RMAN and then starting the recovery in the standby database while opening it in read only mode. Then set up the data guard broker for easier switchover / failover and efficient maintenance and monitoring.
• Used Grid control and 12c Cloud Control to monitor and maintain Oracle RAC databases and ASM instances, create diskgroups and add disks to the diskgroups.
• Implemented VPD feature to hide PI sensitive data like Social Security numbers, Tax ID numbers, Credit card numbers, Customer account numbers in various databases.
• Involved in setting up replication of reporting database from one site to another using Oracle GoldenGate and supporting it.
• Used AWR, ADDM and ASH reports to monitor and troubleshoot performance issues in all databases.
• Involved in the Development, QA and Production database upgrades to 11g and Exadata.
• Downloaded and applied both CPU and Exadata bundle patches whenever required.
• Managing security and roles, functions include managing object and system privileges, granting, revoking and displaying privileges. Creating (non-) default roles and enabling/disabling roles.
• Participated in auditing of databases by providing excel output of queries from auditors.

Confidential, MA

DMA Data warehouse DBA

Hardware: Windows 2000, HP-UX 9000, Linux x86 64

Software: Oracle 10g, 9i, Sqlplus, Pl/Sql, PERL & Shell scripts, Exp, Imp, RAC, RMAN, Veritas, Cognos, Toad, Grid control, Export/Import Data pump, DataGuard

Responsibilities:

• Supporting the production databases (more than 4 Tera bytes) in DMA which hold the Claims and Eligibility data and maintaining them by partitioning.
• Currently involved in the setting up of new datawarehouse databases with Oracle RAC on Linux servers and used RMAN to take incremental backup of the databases.
• Used RMAN and DataGuard to set up physical standby for a production database and automate redo log transport and apply process.
• Used 10g Grid control to monitor and maintain Oracle RAC databases and ASM instances, create diskgroups and add disks to the diskgroups.
• Involved in the Development, QA and Production database upgrades to 10g.
• Downloaded and applied patches whenever required.
• Set the 10g parameter Sga Target to a non-zero value to take advantage of the automatic memory management.
• Involved in writing a script to transport tablespaces from 2 databases into a single database and scheduled it to run daily.
• Involved in writing a package/trigger combo that creates session context variables which improve query performance particularly involving partitioned tables by doing partition elimination.
• Involved in writing a procedure/trigger combo that would send an email to the Tech team whenever a batch process suspends on space.
• Managing security and roles, functions include managing object and system privileges, granting, revoking and displaying privileges. Creating (non-) default roles and enabling/disabling roles.
• Using Oracle 9i's latest features like Index rebuilds, Table moves for reorganizing tables and indices. Also using statspack packages and reports for gathering database statistics everyday.
• Setting size of System Global Area (SGA and Shared Pool constituents like Cache, Checkpoints) and estimating storage parameter sizes of application objects like indices, tables and clusters.
• Perform disk space management, database tuning and query optimization using sqltrace, explain plan, effective hints and adjusting the system parameters.
• Performing production refresh of claims,eligibility and other data into QA and development databases through Exp/Imp. Used Rman and Veritas to create a policy for online backup of production database.
• Managing the tablespaces in all the DMA databases and resizing their datafiles whenever necessary.
• Created alternate keys for all the claim and eligibility tables having low cardinality as bitmap indices thereby improving query performance and using less space.
• Used materialized views for some of the complex aggregate queries thereby drastically reducing query response times.

Confidential, PA

Care Data Management

Hardware: HP-UX 9000

Software: Oracle 9i, 8i, 8x, PL/SQL, PERL & Shell scripts, Exp, Imp, SQLLDR, Developer 6i

Responsibilities:

• Creation of Application objects like tables, indices, triggers in Development and migration of the objects to System test database and then end-migration to production. Also worked in installing Oracle Developer 6i for various applications within Care management system.
• Managing security and roles, functions include managing object and system privileges, granting, revoking and displaying privileges. Creating (non-) default roles and enabling/disabling roles.
• Table, index and table space re-organization, Preparing scripts for creating control files and then loading data into the client's loader accounts using the control files and perform validation checks on the data.
• Setting size of System Global Area (SGA and Shared Pool constituents like Cache, Checkpoints) and estimating storage parameter sizes of application objects like indices, tables and clusters.
• Perform disk space management, database tuning and query optimization using SQL-Trace, Utlbstat/Utlestat, Explain Plan and Tkprof.
• Generating MIS Reports of database like Oracle Free Space Statistics, Library Cache Statistics, Dictionary Cache Statistics, Tablespace and Segments Growth information and Datafile information.

Confidential, MA

Enterprise Data Warehouse & Capacity Planning

Database Administration (EDW DBA)

Hardware: HP-UX 9000

Software: Oracle 8i/8x, PL/SQL, Shell scripts, ERWIN, Exp, Imp, SQLLDR, Svrmgrl, Fastunload, SQR Reportmart, ETL

Responsibilities:

• Creation of Application objects like tables, indices, sequences, procedures, triggers, synonyms and views in Development and migration of the objects to System test database and then end-migration to production and effective partitioning of specific tables and indices.
• Downloaded and applied patches whenever required.
• Maintenance of SQR Reportmart database, which is responsible for the generation of Daily sales analysis, Global sales analysis and other reports for the different Gillette products in various markets.
• Managing security and roles, functions include managing object and system privileges, granting, revoking and displaying privileges. Creating (non-) default roles and enabling/disabling roles.
• Table, index and table space re-organization, Wrote programs for loading data using SQL*Loader and used Fastunload to export tables much faster than Export Utility.
• Actively involved in auditing the system, Backup scheduling & diagnosing lock-related deterioration.
• Setting size of System Global Area (SGA and Shared Pool constituents like Cache, Checkpoints) and estimating storage parameter sizes of application objects like indices, tables and clusters.
• Optimizing INIT.ORA parameters like DB Block Size, Block Buffers, Log Buffer Sort Area, Shared Pool Size, Rollback segments and used Oracle's Advanced Queuing techniques using Dbms Aqadm package.
• Perform physical and logical design, disk space management, database tuning and query optimization using SQL-Trace, Utlbstat/Utlestat, Explain Plan and Tkprof.
• Generating MIS Reports of database like Oracle Free Space Statistics, Library Cache Statistics, Dictionary Cache Statistics, Tablespace and Segments Growth information and Datafile information.

Confidential

Database Administration

Hardware: UNIX (Sun Solaris 5.5.1), DEC Alpha, Windows NT 4.0

Software: Oracle 7.x, Oracle 8.0, Oracle 8i, Pro *C, PL/SQL, Forms 3.0, Shell scripts, Oracle Designer 2000

Tools: SQL*DBA, SVRMGR

Responsibilities:

• Oracle installation, creating databases, determining requirements and establish procedures for backup/recovery, running Import/Export utilities.
• Creating tables, indices, sequences, clusters, profiles, constraints, triggers, procedures etc.
• Perform database tuning and query optimization using sqltrace, utlbstat/utlestat, explain plan and tkprof.
• Pinning procedures & triggers thereby enhancing their performance.
• Creating, designing & testing applications in Oracle 8i as part of product testing activity and compilation of SQL *Forms Programs using Runform30x compilation scripts.
• Perform object refresh from production databases. Designing an ideal test database for programmers. Created test database for Y2k testing, providing on-line support and resolve various Oracle errors.
• Creating objects required for the application team after carefully estimating the sizes.

Confidential

National Banking, Dial a Draft and Hire Purchase and Leasing System

Hardware: Sun Solaris 5.5.1

Software: Oracle 7.3, Pro *C, PL/SQL, Forms 3.0

Responsibilities:

• The customer can have account in any of the Confidential branches in the country. He can issue the checks at any Confidential branch in the country.
• The checks will be treated as local check and will be cleared by national clearing. The coding part involves Uploading, validating & updating the accounts at the remote location. Dial a Draft is the attractive part of Confidential business. Considering the time span of execution the entire module was developed in PL/SQL and Pro *C. First the users have to enter the account number or credit card number.
• After that it will ask the tpin and the details are displayed.
• After validations the draft is booked and the instrument is couriered to the customer. Coding involves displaying the details and booking the instruments, generation of reports, implementation, maintenance and documentation.
• HALS will separate all processes associated with leasing and hire purchase based as credit evaluation, contract sanction, customers repayment processing, penalty applications for delayed payments, premature contract termination and automatic contract maturity.
• It is a Batch Processing System, no on-line updates performed; all user inputs are collected in advice files and applied by batch processes at end of the day. Coding involves creating flat file and booking the instruments by uploading flat file.

Confidential

Sales Order Processing & Dispatch System

Hardware: HP-UX 9000

Software: Oracle 7.3, PL/SQL, Forms 3.0, Report writer 1.1

• Starting up and shutting down of the System.
• Taking Incremental and Complete Backups.
• Storage space Management.
• Loading of data using SQL *Loader.