SUBRATO NATH

# Flat no. ***, *nd Floor, Elements Layout, Kaikondrahalli Sarjapur Main Road, Carmelram Post, Bangalore (Karnataka) 560035, India. Call : 91-998*******, (080-********. Email : nbc7p3@r.postjobfree.com

Oracle GoldenGate Architect– Associate Architect (Cambridge Technologies)

• A Logical data replication specialist with Oracle PL/SQL and Data Base Administrator skills. Having 11 years of IT experience with different database technologies, among which 6 years with Oracle. I have been involved in the full life cycle of the application design process.

• Worked as a Project Manager for a production support environment. A team of 21 oracle DBAs for data management services account.

• Worked as GoldenGate architect for Vodafone New Zealand and Telecom Hutchison Australia separation project..

• Have strong knowledge in Relational Databases like Oracle, FoxPro, MySql & Access

• Database development experience using tables, triggers, views, functions in PL/SQL.

• Extremely creative with excellent Communication and People management skills acquired from experience.

Hardware and Software Environment:

Operating System :Red Hat Linux 4,5.5, HP-UX B.11.11, Sun OS, DOS-6.22, Windows 3.11,

:Windows (95, 98, 2000, XP5.1), Novell NetWare

Products/Tools :VMWare 8, TOAD 7.6.1/8.5, Power Designer, Win CVS, HP-OpenView, SecureCRT

Languages :SQL and PL\SQL, C, C++, Korn Shell scripts, JavaScript, HTML, ASP (3.0)

Databases :Oracle (8, 8i, 9i & 10g), FoxPro (2.5, 2.6), MySql, MS Access

Versioning Tools :Win CVS

Replication Tools :SharePlex, GoldenGate

Project / Professional Experience Highlights:

Cambridge Technologies, Bangalore:

Associate Architect

Nov 2011 to till date

Description : An environment with 6 pairs of source and target production databases on oracle 11g deployed in AWS cloud. A unidirectional GoldenGate data replication is in place between the source and the target databases. Target databases are planned for failover.

Responsibilities:

Study every new objects that are added during code releases.

Redesigned existing setup to avoid future out of sync situations.

Deployed shell scripts for monitoring different GG processes with defined threshold.

Scripted semi-automated failover mechanism.

Creating required architectural diagram and implementation / technical documents and present it to the client for approval.

IBM India Pvt Ltd, Bangalore:

Technical Services Manager

October 2010 to Nov 2011

Description : Handling 15 oracle DBAs spanning account 3 diffirent accounts. All of them are highly visible production support environment with very aggressive SLA / SLO attentment ratio.

Responsibilities:

Maintain Service Level commitments for each quarter above 99.8% for the total of all accounts supported

Establish operations maturity such that there are no escalations for unavoidable reasons - related to skill, process, technology issues

Identify process gaps with maximum issues and find ways to improve the compliance and performance

Ensure reporting of all change failures, SLA breaches and escalations/complaints is done in next morning

Define clear trainings to be undertaken for all in the Direct reporting structure.

Participate and contribute to the projects that look at scalability /predictability of processes/procedures in ITIL Service Support

Manage the life cycle of the process artifacts (process, procedures, work instructions) providing continuous improvement resulting from RCA assessments and in support of the quality initiatives.

Improve the climate, culture, and satisfaction of the employees in the teams managed for achieving a greater sense of belonging.

Actively work to close any skills gaps by progressing through account training plans and product training plans that may be applicable

MphasiS and HP Company, Bangalore:

Oracle DBA as Project Manager

July 2006 – Oct 2010

1) Project Name : Vodafone NZ - AU Separation

Duration : Nov 2009 till date

Technology : Oracle 9i, GoldenGate 10.4

Role : GoldenGate Architect

Description: Merger of Vodafone Australia and Telecom Hutchison Australia, Vodafone New Zealand has commissioned a number of initiatives to separate their operations from those of the merged Vodafone Hutchison Australia (VHA). This initiated the Siebel and Websphere Business Integration (WBI) database to lift and shift from Australia to New Zealand.

Responsibilities:

Part of Database Migration team who involved in the entire migration solution design placed at the client location at New Zealand.

As the replication tool, Oracle GoldenGate is widely used. Replication strategy and implementation was part of my responsibilities.

Involving Oracle / GoldenGate technical team to assess our solution strategies for further improvement and identifying the areas of challenges.

Activities:

• Provided proof of concept of GoldenGate replication, keeping SIEBEL and WBI migration in mind.

• As the replication tool, Oracle GoldenGate is widely used. Replication strategy and implementation was part of my responsibilities.

• Interacted with the different stake holder like Vodafone NZ, Vodafone Australia & IBM, explaining our migration approach.

• GoldenGate implementation and configuration done for test and production environment

2) Project Name : Sprint Nextel

Duration : July 2006 - Nov 2009

Technology : Oracle 9i/10g

Role : DBA, Project Manager

Description: Handling a team of 26 experienced Oracle DBAs. Team is responsible for 24/7 Monitoring, Support and Maintenance of 120 production Databases belongs to Sprint-Nextel, one of the major telecom giant in US. Database sizes are ranging from 5TB to 200TB.

Responsibilities:

Reviewing application codes like procedure, functions, packages that will be deployed in production environment in the upcoming releases.

Each and every SQL queries are extracted from the stored procedures and performance are checked in production.

Daily query performance issues facing from different batch jobs are looked into.

Monitoring performance of Standby database recovery and GoldenGate replications on daily basis.

Checking for Logical and RMAN hot backup completion mails, need to investigate the ones which have failed.

Developing a Goldengate reporting environment with Shell Scripts and PL/SQL stored procedure, the report tool used is Jasper.

DBA Activities:

• Oracle software Install, upgrades, patch and maintain Oracle software, viz – 9i, 10g, ASM

• Implementing security using Roles, Privileges, Grants, and Views.

• Strong Experience in Backup and Recovery.

• Manage Tablespaces, Rollback Segments, Redo Logs and other database objects.

• Used Import, Export, DBVerify, SQL*Loader, RMAN.

• Tuning Database buffer Cache, Shared Pool, and Redo log Buffer etc

• Strong knowledge in database cloning, standby database and DR setup.

• SQL Tuning using SQL TRACE, TKPROF and EXPLAIN PLAN, STATPACK Analysis.

• Logical (Export & Import), Physical (Cold & Hot) backup according to the Backup Strategy.

• Experience in Installation, configuration & Monitoring Oracle 10g and ASM instance

Infonox Software Private, Pune, (www.infonox.com) Santa Clara, USA:

Software Executive

Oct 2004 – July 2006

1) Project Name : SupportNox / MonitorNox

Duration : Oct 2004 – July 2006

Technology : Oracle 8i / 9i

Role : DBA, Developer

Description: Developing software for companies involved in financial services through Self Service Kiosk or Assisted kiosk to their customers in supermarkets, retail outlets, Casinos etc. Some of the prime services are Cash withdrawal, Cash Deposit, Cashing Cheque (Salary or personal), Money Transfer, Bill Payment via Cash, Cheque, Credit or Debit Card. A monitoring tool called MonitorNox, which give a realtime status of all the Kiosk in the chain, provided as an after sales service.

Responsibilities:

Creation of procedures, functions, packages & Triggers using PL/SQL are some of the major

responsibilities.

Basic performances are reviewed, depending on OLTP or DSS (ReportNox).

Creation of Database Release Scripts and subsequently doing releases on QA, Staging & Production Environment.

Daily Monitoring of Production Database replication process. We have developed our own trigger based replicator.

Periodic performance monitoring of costly Procedures & queries on production and resolving them.

Responsible for QA & Development backup strategy. Daily Full Export, weekly RMAN, monthly Cold Backup.

Shanti Mukand Hospital (Delhi):

EDP Manager

Jul 2002 – Oct 2004

1) Project Name : Hospital Information System

Duration : Jul 2002 – Oct 2004

Technology : Oracle 8i / Foxpro2.6

Role : DBA, Developer

Description: Patient Registration- (IPD-In Patient, OPD Out door Patient, Ante-Natal Checkup), Schedule of Charges (Own Schedule & Panel Companies Schedule)

Doctor's Share - (Calculation of Consulting charge & Procedure charge), Patient History- (Doctors can be the previous Investigation list & results), Billing - (Raising of bills for both Company patient & private patient), Receipt - (Recording of advances as well as receipts from companies as well as from patients), Purchase & Inventory Management Utilities.

Responsibilities:

Responsible for Implementation of Hospital Information system on VB & Oracle with Vendor.

Interacting with hospital staff & Management for freezing down requirement.

Database creation, backup strategy, stored Procedure creation using PL/SQL are some of the key responsibilities

Ask Me Information Services Pvt. Ltd (Calcutta):

Systems Manager

Feb 1999 – May 2002

1) Project Name : Ask Me Answering Machine

Duration : Feb 1999 – Mar 2000

Technology : Developed with FoxPro 2.6 (Multi User Environment) on Novell Netware.

Role : System Analyst / Developer

Description: A powerful searching software containing various kinds of search like Company wise, Product wise, Brand wise, Juxtapose (company, product, brand ) search, Entering inquires from the caller for a particular company, product & services. Generating reports of these inquires and sending them to the corresponding companies..

2) Project Name : Ask Me Sales Tracking System

Duration : July 2000 – Nov 2000

Technology : Developed with FoxPro 2.6 (Multi User Environment) on Novell Netware.

Role : System Analyst / Developer

Description: Software generated daily appointment fixing from tele-marketing. Determination of daily and monthly target depending on their performance, Calculation incentive, Daily Sales collection, & various MIS reports.

3) Project Name : Ask Me Payroll

Duration : Jan 2001 – June 2001

Technology : Developed with FoxPro 2.6 (Multi User Environment) on Novell Netware.

Role : System Analyst / Developer

Description: Normal payroll system with Loan & advance tracking, PF calculation, Tracking different kinds of leave entitlement and availability and carrying forward to the next year. Tax Calculation for the employees with different saving scheme.

4) Project Name : www.calcuttainfo.com

Duration : Oct 2001– Feb 2002

Technology : ASP, Java Applet, Java Script, MS Access.

Role : System Analyst / Developer

Description:

Module present in the site :-

Search - Search option for company, Product, Brand. Emergency & various service search, page wise. Handling Company Search for eighteen more Indian cities.

Placement - searching of jobs through Broad category followed by Job title and Job detail. Adding resume in a table which are posted by the candidate with the cut & paste option on the site along with mailing one copy of the resume to our mail box.

ILAM Systems (P) Ltd (Calcutta)

Sr. Programmer

Jan 1998 – Feb1999

1) Project Name : Sanchyani

Duration : Jan 1998 – Sep 1999

Technology : Developed with FoxPro 2.6 (Multi User Environment) on Novell Netware.

Role : Programmer

Description: Developed different module of a NBFC software which keep track of installment deposition of different policy including insurance certificate, Calculating commission (spot, overriding) for every individual agent in the entire chain.

2) Project Name : Provident fund allocation system

Duration : Oct 1999 – Feb1999

Technology : Developed with FoxPro 2.6 (Multi User Environment) on Novell Netware.

Role : Programmer

Description: Tracking and calculation P.F. of more than 1500 employees located in 103 branches, also handled advance taken from PF account. Taking out reports of different PF form for the deposition.

Personal Details

Education

Graduation : Ashutosh College in the year 1994 with Botany, Zoology & Chemistry (Calcutta University)

Higher Secondary: Ashutosh College in the year 1992 with Physics, Chemistry, Biology (Calcutta University)

Secondary : Julien Day School in the year 1989 (Calcutta University)

Diploma : One Year Diploma in Systems Management (DISM) from APTECH

Certification

1. Oracle Certified Professional - OCP (Release 6/6i) - Paper includes 1st (Introduction to Oracle), 2nd (SQL, PL/SQL program units) 3rd(Forms Build I), 4th (Forms Build II), 5th (Reports)

2. Oracle PL/SQL Brain bench Certification. http://www.brainbench.com. Transcript ID Number is 3010114.

3. Specialized course on Oracle 8/8i & Developer 2000 Release 6 from Oracle Corp. Authorized training Centre viz. SQL Star International Ltd.

4. TOEFL - Test of English as Foreign Language (score- 520)

5. GoldenGate Implementation methodologies from Golden Gate – 1 Week, 8 hours a Day

6. Level 0 Certification on Telecommunication - Mphasis an EDS company

Professional Training

UNIX Basics & Shell Scripting – 2 Weeks, 8 hours a Day

Oracle 10g new features – 2 Weeks, 8 hours a Day

Delivering Superior Services for Project Leads – 16 hours.

Travel Details

Countries Visited : Thailand, New Zealand

Passport No : G6170539

Date of Issue : 20/11/2007

Date of Expiry : 19/11/2017

Place of Issue : BANGALORE

Subrato Nath

Contact this candidate