SUMMARY

• Total 26 years of IT experience.
• Over 19+ years of experience as Oracle Production DBA (12C, 11gr2 RAC) on various platforms e.g. Linux, SUN Solaris, IBM Aix, SCO UNIX,HP and Windows NT.
• Experienced in Oracle RAC, ASM, Logical and Physical Database designing/Data Modeling, Data Guard setup, Attinity and GoldenGate Replication setup, Streams, Oracle binaries and Patch Installation, upgrade, Transparent Data Encryption (TDE), RMAN Backup & Recovery, Database Duplication/Cloning, Data Archiving, Data Pump, Data Extraction from legacy systems and loading into Oracle db (ETL), High Availability (HR) & Failover Setup and Testing, Performance Tuning using AWR/ADDM and sql tuning advisors, Security Setup & Auditing and use of various DBA tools like Grid - control/OEM 12c, Toad,I3 etc.
• Experienced in Mentoring Junior DBA’s and co-ordination with off-shore DBA Team.
• Approx 6 years experience with Oracle 12C, 11gR2 RAC (including ASM) Installation, DBA support and patching.
• Approx 3 years Project Management/Project Lead experience. Managed offshore/on-site teams of 8-10 people. Acquainted with all phases of System Development Life Cycle (SDLC).
• Approx 4 years Database Architect experience. Involved in on-site Requirement Study, Analysis, Database Designing (Logical/Physical), ER-Diagrams using Erwin, Defining Oracle Standards, and Code Reviews.
• Approx 2 years experience with SQL Server 2005 Db administration, Cube Creation and with Informatica ETL (IDE and IDQ) tools.
• Currently working for Visiant Health, a Blue Cross Blue Shield of Michigan group company supporting Multiple clients.

TECHNICAL SKILLS

Hardware: Physical and Virtual Linux boxes and Windows servers., SUN 6800 and 6900 machines running SOLARIS version SunOS 5

Operating Systems: RedHat Linux 6,UNIX, SOLARIS version SunOS 5.9, Aix, LINUX, Windows 8

RDBMS: Oracle 12C Multi-Tenant, RAC 11gR2, RMAN, SqlServer 2005

DBA TOOLS: OEM12c, Grid, DBArtisan, TOAD,, Symantec i3, SQL Café, SpotLight, DB Healthcheck, RACCHECK, GoldenGate 12C, Attunity.

Babkup Toools: RMAN, Networker, Barracuda

Replication Tools: Golden Gate 12c, Attunity And Oracle Replication.

ETL TOOL: SInformatica IDE and IDQ

CASE TOOLS: Excelerator, Easy CASE, ERWIN 2.1

DEV TOOLS: SQL* FORMS (ver. 4.0, 3.2, 2.3), SQL*PLUS, SQL* REPORTWRITER,, PL/SQL, SQL*MENU, SQL*NET 2.0, Oracle Loader, Pro*C, Pro*COBOL, DATA ARCHVINGOUTERBAY

TOOLS: Programming LanguagesPL/SQL,SQL*PLUS,COBOL,C,FORTRAN,PASCAL, Pro*C, Pro*COBOL

GUI: PowerBuilder, SQL*FORMS (4.0)

OTHERS: Site Scope - Db Monitoring/alerting tool, ControlM - Job scheduling tool, PVCS - versioning tool, Remedy, Collage, HTPM, MS-PROJECT, MS Office 2003 tools (Excel, Outlook, Visio, Word), CLIPPER, ReportWriter (R & R), dBASE III plus

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Administration of Oracle 12c multi-tenant databases for multiple clients in Health Insurance Sector relating to ikaSystem’s Claims, Billing and Gateway Products, Leading Projects within DBA sphere, Coordination with Remote team, Evaluation of new Cloud Backup/Recovery tools like Barracuda, Capacity Planning, Database access control, Database Refreshes, RMAN backups and recovery and Performance Tuning.

Environment: Oracle 12C (Multi-Tenant), 11gR2, ASM, Golden Gate, Attunity,Data Guard, RMAN, Networker

Confidential

Database Sr. Advisor

Responsibilities:

• Lead DBA team and participated in off-site DR exercise multiple Times.
• Participated and lead the DBA efforts for New Projects. (D2I, NPAS, TEAMS) Installed and setup the Oracle 11gr2 RAC from scratch on two node Linux cluster: fsplidb1/2. Migrated several 10g databases to 11g grid. Implemented Transparent Data Encryption (TDE) for several databases.
• Participated in the Oracle PSU patching multiple Oracle RAC grids.
• Involved in performance tuning efforts on several occasions.
• Lead the effort on GoldenGate project and installed Oracle GoldenGate 12c on RHEL 6 server.
• Completed quarterly 90 day password changes in prod and non-prod databases.
• Involved in Production Releases.
• Provided DBA support during Linux and Wintel server patching multiple times during the year.
• Performed on-call Primary (and secondary as well) DBA duties several weeks during the year on rotation basis: for multiple accounts.
• Worked with Customer on several new projects like D2I, AUR and NPAS and developed good working relationship with customer counterpart.

Environment: Oracle 11gR2 RAC, Red Hat Linux 10.x, OEM 12c, Toad, Envision, OPAS v2/v3 etc.

Confidential, Waltham, MA

Consultant DBA

Responsibilities:

• Working as Consultant/DBA at Confidential and responsible for Administering Oracle 11gR2, 10g & 9i Databases (80-90%) as well as Sql Server 2005 Databases (10-20%).
• Involved in RMAN Database Duplication, Handling Backup and Recovery issues, Performance Tuning, Large Table Analyze.
• 10g to 11gr2 upgrade, Participating in 24*7 on-call Support on rotation basis.

Environment: Oracle 11gR2/10g on Aix, Sqlserver 2005, SpotLight, OEM Grid Control, Remedy 7,PL/Sql Developer

Confidential, Hartford, CT

Specialist Database Management

Responsibilities:

• Worked as Specialist Databases/Sr. DBA for ‘The Hartford’ group. Part of a DBA team consisting of 3 DBA’s.
• Responsibilities included Administering Oracle 9i/10g and Sqlserver 2005 Financial (Claims) databases of Multi-Terabytes size, Worked closely with Development and Release teams, Co-ordination with Off-shore IBM support groups, Disaster Recovery (DR) Testing, Performance Tuning, Analyzing Space Usage, Capacity Planning, Design Reviews, Production Releases & On-call Support, On-line Table Redefinition, Index Rebuilding,
• Data Refreshes and Data Archiving. Involved in mentoring and training Jr. DBA’s

Environment: Oracle 9i/10g, Sqlserver 2005, Solaris and Windows boxes, Remedy 7, Toad, OEM Grid Control, Veritas I3/Symantec Precise.

Confidential, Wakefield, MA

Sr. Production Database Administrator/ Architect

Responsibilities:

• As a Senior and Lead production DBA participated and managed several project modules during last 10 years working with Confidential (for Confidential ) and performed the following tasks in general
• Database Upgrade from Oracle 9i to 10g with Standby db in place.
• Replication Setup (including Streams) and Resolution of Replication issues.
• Fail-over and Fall back process Setup and Testing between Primary and Secondary servers.
• Data Guard Setup and Graceful Switch-Over between Primary and Standby databases.
• Leading Database Related Modules/Tasks (Preparation of Project Plans, Organizing Meetings and Implementation)
• Hands-On Oracle 10g RAC (Including ASM) Setup Experience.
• Data Pump Usage for Data Migration between Databases and Data Archiving.
• Oracle S/W Installation and Patch Application.
• AWR/Statspack Implementation: Snapshots and Reporting, Baselining
• OEM Grid Control Usage for Administering and Maintenance of Multiple Databases.
• Responsible for the overall administration, maintenance and fine-tuning of the databases.
• Database Cloning and Creation of New 10g Databases.
• Creation of an n% database with extraction of data from production.
• Implementation of AUM: Conversion from Dictionary Managed to Locally Managed Tablespaces.
• Performance Tuning using AWR/Statspack,ADDM,Sql Tuning Advisor,Wait Statistics, Explain Plan and other Oracle Advisories.
• On-line Backups and recovery (Including RMAN Backups).
• Automation of nightly DSS (Reporting) database creation process from Standby database.
• Data Modeling and Logical/Physical Database Designing for OLTP and Data Warehouse databases.
• Creation of Data Warehouse related Summary/Aggregate tables within DSS db and Support.
• Partitioning of Tables and Indexes.
• Implementation of various releases, schema changes (an on-going process) and data conversion projects in Production db/environment.
• Data encryption in Production and QA environments using different encryption keys (3DES).
• Resolving user’s issues and application support.
• Writing of SQL, PL/SQL and Shell Scripts relating to DBA jobs .
• Involved in securing database environment w.r.t. Controlled user access and privileges, use of roles and profiles, Quarterly auditing of passwords and privileges etc and data encryption
• Involved in Capacity Planning.

Environment: SUN SOLARIS 6900’s (OS 5.9), WINDOWS NT, XP, Oracle 10g and 9i (9.2.0.6), PL/SQL, SQL.

Confidential

Database Administrator

Responsibilities:

• Installation of Oracle 8i software on HP Unix boxes (Test and QA) environments.
• Creation of New Databases
• Creation of New Schemas, Users and objects.
• Loading client provided data into test databases via Import utility
• Keeping the test and QA environments in sync with Production environment w.r.t. Overall base structure and schemas.

Environment: Oracle 8i Databases on Sun Solaris boxes, Sql, PL/SQL, Sql Loader,Export/Import Utlities

Confidential

Database Administrator

Responsibilities:

• Installation of Oracle 10g software on Window NT boxes.
• Creation of New Databases
• Creation of New Schemas, Users and objects.
• Handing over the environment to Client once initial setup is stabilized and working fine.

Environment: Oracle 10g Databases on Windows NT box

Confidential

Database Administrator

Responsibilities:

• Installation of Sql Server 2005 S/W.
• Use of Server Management Studio for Database Administration Task.
• Creation of New Schemas, users, Roles and permissions.
• Use of T-Sql for Database Objects creation
• Backup and Recovery Procedure setup.
• Three Dimensional Cube creation (Data Warehouse)
• Use for Reporting Services.

Environment: Sql server 2005 on Windows server. Confidential Technology Partners (CTP)

Confidential, MA

Production Database Administrator

Responsibilities:

• Responsible for the overall administration, maintenance and fine-tuning of the database. (Production database size 12GB).
• Installation of the Oracle software.
• Creation of the Database Instances (Production, Test and Development Instance)
• Data Migration and Refresh
• Writing of data feeds (stored procedures and packages) to fetch data from remote systems using DB Links.
• Resolving user’s issues received through HelpDesk.
• Involved in the study of new user requirements and creation of new database objects as per user needs.
• Involved in Database Designing (Logical/Physical), Data Modeling, Entity-Relationship Diagrams creation using ERWIN.

Environment: SUN SOLARIS, WINOWS NT, Oracle 7.2.3, PL/SQL, SQL, JAVA, CORBA, SELECT, ER WIN.

Confidential, Maynard, MA

Project Leader

Responsibilities:

• Worked as Project Leader for Year2000 Assessment and Conversion Projects
• Managed assessment and conversion work of many Digital internal applications simultaneously.

Environment: VAX/VMS, COBOL

Confidential, MA

Oracle Database Administrator

Responsibilities:

• Routine Database administration and maintenance Tasks
• Data replication,
• Monthly manual data refresh for non-snap tables,
• Automatic data refresh of snapshot tables for regional servers,
• Resolving user’s problem and providing them right environment
• Enhanced and Tested existing scripts to perform the Manual Data Refresh.
• Established a procedure to FTP the compressed dumps to Regional Servers to minimize traffic across the WAN.
• Support to regional DBAs.
• Created scripts to build a standard database.
• Built new database instances on two internal SUN servers.

Environment: Oracle 7.1.6, PowerBuilder, distributed database environment.

Confidential, OH

Project Leader/ Analyst

Responsibilities:

• Participated in the Designing of the Data Conversion Application for Converting data from Unisys 2200/ISAM to target - Unix/Oracle based Akron Financial System (AFS) for Confidential, OH, USA.
• As a Project Leader actively involved in the proposal development, Lead a team of 5 software engineers, Off-site review of high level design, Project monitoring, scheduling and execution of all the phases of the project.

Environment: UNISYS 2200, UNIX m/c, Oracle 7.1.6, COBOL

Confidential, OH

Oracle DBA/ Module Leader

Responsibilities:

• Defining the data conversion requirements and detailed design of the data conversion module.
• Responsible for leading a team (5-7 Resources) and execution and monitoring of the project module.
• General database administration and database activities.

Environment: Client/server environment in PowerBuilder/ Oracle (7.1) on Unisys U6000.