Sr DBA

AKHILESH SHARMA

** ***** ** **********,** *****

***********@*****.*** 978-***-****

Summary

Over 12+ years of experience as Oracle DBA (11g, 10g, 9i, 8i and 7.x) DBA on various platforms HP, SUN Solaris, SCO UNIX and Windows NT (Prod. & Development) and Linux. Experienced in Logical and Physical Database designing/Data Modeling, Data Guard (Standby db) & Replication (Master and Streams) setup, Oracle S/w and Patch Installation, 10g upgrade, RMAN Backup & Recovery, Database Cloning, Data Archiving, Data Loading and refreshes using Data Pump, Data Extraction from legacy systems and loading into Oracle db (ETL), Failover Setup and Testing, Performance Tuning using AWR/Statspack and advisors, Security Setup & Auditing and use of various DBA tools like Grid-control/OEM, Toad,I3 etc.

Good experience with Oracle 10g RAC (including ASM) implementation and Oracle 11g new features.

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.

Reasonably good experience with SQL Server 2005 Db administration, Cube Creation and with Informatica ETL (IDE and IDQ) tools.

Currently working at ‘The Hartford’ financial Services Group at Hartford, CT as a Sr.DBA and administering financial databases of multi-terabytes size, Oracle and Sqlserver both.

TECHNICAL SKILLS

Hardware SUN 6800 and 6900 machines running SOLARIS version SunOS 5., Windows servers.

Software Operating Systems UNIX, SOLARIS version SunOS 5.9, Aix, LINUX, Windows XP

RDBMS Oracle 11g,10g and 9i (9.2.0.6), MS ACCESS, Sql Server 2005

DBA TOOLS Oracle Enterprise Manager (OEM), Grid Control, DBArtisan, TOAD, SQL Café

ETL TOOLS Informatica 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 ARCHVING OUTERBAY

TOOLS

Programming Languages PL/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

EDUCATIONAL QUALIFICATIONS

• Master of Business Administration (MBA), Indira Gandhi National Open University, New Delhi, India

• Master of Science in Physics (Nuclear Science), Kurukshetra University, India

• Bachelor of Science (Honors) in Physics, University of Delhi, Delhi, India

• Post Graduate Diploma in Computer Technology and Applications, University of Jodhpur, Jodhpur, India

RECENT TRAININGS

Oracle 11g : New Features for Database Administrators @ Oracle ATC

Oracle 10g : RAC For Administrators @Oracle ATC

The Hartford Financial Services Group, Hartford CT

Oct 09 - Todate

Role: Specialist Database Management ( Oracle and Sql Server)

Working as Sr. Specialist/DBA for ‘The Hartford’ group. Part of a DBA team consisting of 3 DBA’s. Responsibilities includes Administering Oracle 9i and Sqlserver 2005 Financial (Claims) databases of Multi-Terabytes size, Work closely with Development and Release teams and Co-ordinate with Off-shore IBM support groups. Performance Tuning,Analyzing Space Usage,Capacity Planning,Design Reviews, Production Releases & On-call Support, Rebuilding/Moving Tables and Indexes, and Data Archiving.

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

Edgewater Technology

Wakefield, MA Sep 99-Jun 09

Client: Synapse Inc (a Time Warner Group company) Sep 99-Jun 09

Role: Sr. Production Database Administrator/ Architect

Synapse Inc’s two main production databases are ‘Magazine’ and “Merchandise” respectively. Besides these, there are several other production databases for different applications. Also, there are approx. 80 development and test databases spread across multiple SUN 6900 servers.

• As a Senior and Lead production DBA participated and managed several project modules during last 10 years working with Edgewater Technology (for Synapse) 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.

Client: Resource Solutions (UK Based Company) Jan 2003-Jan 2005 (Part-Time)

Role : Database Administrator

Provided as and when required Database Administration support for this client. The time duration was spread over multiple years and it was during the time while working on main Synapse account. Some of the tasks performed for this client:

• 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,

Client: Shared Health June 2006 (Part-Time)

Role : Database Administrator

Provided initial Database Server setup support for this Client for a month or so and it was during the time while working on main Synapse account. Some of the tasks performed for this client:

• 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

Client: Edgewater Internal PS Tiger Team Project Mar 09 – June 09 (Part Time)

Role : Database Administrator

Provided DBA Support to PPS Tiger team working on Edgewater Internal Project:

• 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.,

Cambridge Technology Partners (CTP)

Cambridge, MA July 98 – July 99

Production Database Administrator

UPBEAT (Universal Process for Better Expense and Time Entry) is a Time and Expense Entry system for the employees of the company. Time Entry part of the system involved time entry through a web browser. It has the following features:

Integration with Project Accounting and HR systems. Compliance reporting for each group. Notification of time-entry delinquency.

As a DBA performed the following tasks:

• 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.

Digital Equipment (India) LTD

Client: Digital Equipment Corporation Maynard, MA June 97 - July 98

Role: Project Leader

Worked as Project Leader for Year2000 Assessment and Conversion Projects for NSIS Y2K Internal Group, at Digital. Managed assessment and conversion work of many Digital internal applications simultaneously.

Environment: VAX/VMS, COBOL

Tata Unisys Limited (later known as Tata Infotech Ltd) Aug 95-Jun 97

Client :Depratment of Trasportation

Cambridge, MA Jan.’97 - June’ 97

Role: Oracle Database Administrator

Worked as DBA in Transportation Information Management System (TIMS) Project for Department of Transportation, at Unisys Corporation, Cambridge, MA, USA.

TIMS system has its master database at Cambridge and 12 regional slave databases across the USA. System involves data replication using snapshots and on-line backups. All the regional servers are connected to master server through LAN/WAN using SQL*NET (1.0) and TCP/IP.

As DBA performed the following tasks:

• 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.

Client: City of Akron,OH Aug. 96 - Dec. 96

Role: Project Leader/ Analyst

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 City of Akron, 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

Client: City of Toledo, OH Aug. 95 - July 96

Role: Oracle DBA/ Module Leader

Municipal Income Tax Information System (MITIS) for City of Toledo, OH, USA

was originally implemented on Unisys 2200/401 mainframe in COBOL and ISAM. TUL re-engineered the original MITIS application to a client/server environment in PowerBuilder/ Oracle (7.1) on Unisys U6000 machine/PCs. Data Conversion programs to convert the existing data from ISAM files to Oracle tables were also developed.

As a DBA and Module leader performed the following tasks:

• Data Conversion Requirement Study at Client Site City of Toledo, OH.

• 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.

DCM DataSystems Mar 93- Apr 95

Client: Shree Cement Ltd.,Beawar,India

New Delhi, India Nov. 94 – Apr. 95

Role: DB Architect and DBA

The main features of the Sales and Marketing system are Order booking for cement & clinker, generation of dispatch instructions, loading and dispatch detail maintenance, invoicing, excise gate pass printing, stock reconciliation for stock at various depots, sales analysis and printing of Sales trend report.

As a Db Architect and DBA was responsible for Requirement Study, Logical and Physical Database designing, Database Administration and Maintenance.

Environment: Oracle 7.X, Forms 4.0 in Client server environment on UNIX based machine.

Client: Coromandal Fertilizers Ltd.,

Visakhapatnam,India

Jan 94 - Oct 94

Role: Db Architect and DBA

Material Management System was an on-line system and covered the Stores management and purchase system. Main features of the system includes automatic generation of the purchase requisitions, on-line purchase order printing, reminders and tender printing, FSN and ABC analysis, on-line stock updation, gate-pass generation and stock ledger printing.

As a Db Architect cum DBA was responsible for User Requirement Study, Logical Database Designing, Physical Database Designing, Defining the Overall Architecture of the System, Integration with Other Databases/Applications. Subsequently actively involved in Over seeing development of data entry forms and reports, and data conversion module.

Environment: Oracle 6.0 with Forms 3.0, sql*menu and pro*c on CDC (UNIX) machine.

JK Technosoft, New Delhi, India Apr 91-Mar 93

Client: Bell Northern Research Ltd., (BNR), Ottawa, CANADA March 92 – July 92

Role: Quality Analyst/Team Member

Worked at BNR, CANADA as part of the Product verification team. As a team member, was involved in Verification/testing of different versions of the software like Ranger 10 (wireless system). DR4 (Brazil), DR5, Sweden etc. Automation of test cases and Bug fixing in automated test cases.

Client: JK Cement Works, ChittaurGarh, India Apr 91-Mar 92

Role: Analyst/Developer

Involved in Designing and Development of the Maintenance Management System (MMS) for JK Cement Works, ChittaurGarh, India, at JK Technosoft, India.

The system prepares the yearly and weekly maintenance schedule for all the routine jobs for each equipment. The jobs missed in the privious week’s schedule are automatically re-scheduled. Apart from the scheduled jobs, the system also takes care of un-scheduled and shutdown jobs. Costing of the jobs is another important feature of the system. The technical details of the equipments are maintained in the database which can be queried by any of the maintenance personnel. Relation between an equipment and its spare parts is also maintained to assist in maintenance planning.

As a team member, responsibility included Requirement study, Analysis and designing, Development of the Screens and Reports using Forms 2.x and Proc*C, Testing and Implementation at the Client Site and User training. Environment: Oracle ver. 5.1 with forms 2.x. in UNIX environment

Contact this candidate