Expert Details
Database, DB2, Oracle, Aix, HACMP, Websphere, MQ, Windows, BI Tools
ID: 727863
United Kingdom
Expert brings to you 10 years of IT infrastructure experience of which involves as a Database Analysis/Administration/Installation, Migration & Technical Support using (Database - DB2 UDB V8.2/9.1/5,Oracle V9.2/10g, Sybase)(O/S - AIX,HACMP, windows, VMS, Solaris, Linux)(Middleware - BEA weblogic, JBoss,IBM websphere, MQ and messaging) (Migration tools as Datastage, IBM Information Server)
(BI - Abinitio, Informatica) and as system engineer & architecture for Administration and Troubleshooting of Middleware and frontend, DR and Contingency. With his diverse experience with Fortune 500 companies and others, he has acquired vast skills and knowledge from closely working with Architects, Designers, Project Managers at all times during his career.
Education
| Year | Degree | Subject | Institution |
|---|---|---|---|
| Year: 2000 | Degree: Hardware - P5series | Subject: P5series/HACMP Certified | Institution: IBM Partner |
| Year: 2000 | Degree: HDSE | Subject: Diploma in Software Engineering | Institution: Aptech |
| Year: 2001 | Degree: Diploma in Ecommerce | Subject: Ecommerce | Institution: Comet |
| Year: 2001 | Degree: DBA | Subject: DB2, Oracle | Institution: Client Trained |
| Year: 2000 | Degree: Bachelors | Subject: Computers, Commerce | Institution: University of Mumbai |
Work History
| Years | Employer | Title | Department |
|---|---|---|---|
| Years: 2007 to 2009 | Employer: Cerner | Title: Senior Analyst | Department: IT |
Responsibilities:Group: - e-bookings and Cerner Millennium for NHS• Cerner tools such as e-bookings, power chart, schapt book, scheduling etc (Millennium Tools) • Maintain front-end, middleware & backend architecture, 4terabyte of data and components. • Automated system tasks. • Automated operating system tasks. • Administer/Install/upgrade Oracle 9i to 10g, Tune oracle database at a professional level. • Administer/Install/upgrade Aix and HACMP (Power HA). • Administer/Install/Upgrade MQseries backend and Websphere frontend. • Tuning frontend and backend nodes for an average of 40000 bookings made every day by GP´S. • Manage complex middleware back-end components. • Deploy Application patches/packages. • Correct back-end domain issues. • Project Implementation/Methodology • Support & maintain application to SLA and BAU • Communicate troubleshooting issue, escalation and resolution. • Provided migration support to internal GRID DB2 UDB v8.2/9x db on standalone nodes platform Aix 5.3 and power HA. • Contribute back to the knowledge community by sharing experience about Cerner culture, process and tools best practices to other associates. |
|||
| Years | Employer | Title | Department |
| Years: 2006 to 2007 | Employer: IBM | Title: Consultant | Department: IT |
Responsibilities:• Designed RDA (Rational Data Architecture Models) Physical and Logical data models based on Architecture.• Equal Participation in db design and implementation strategies along with other groups. • Maintaining of DB Environmental Documentation for various environments Dev, Test, Pre-Prod and Prod. • Supported 24X7 DB performance tuning, Load Testing and Data loading with Data stage. • Generating Reports using datastage. • Defining of TSM and backup strategies for multiple Releases. • Provided client connectivity support and DB maintenance. • Attending meetings and conference on schedule basis and providing functional / technical support to group. |
|||
| Years | Employer | Title | Department |
| Years: 2006 to 2006 | Employer: Bank of America | Title: Sr DBA | Department: IT |
Responsibilities:• Applying (CCC) security compliance checker code policies and script to maintain Banks security compliance and database administration.• Provided Support to all environments Dev, CIT, EPE, PreProd, Prod and Prod2(contingency/HADR Machines) • Done Aix upgrade to servers from 5.2 to 5.3 for servers and client. • Installed, configured and catalogued databases for report generation, being done for Ab initio. • Designed and deployed Optimized Ab initio graphs for High Volume transformations. • Implemented the aggregation of same data across different tables in the legacy system. • Designed and deployed Optimized Ab initio graphs for High Volume transformations. • Done Installation of DB2 8.1 and updating of fix pack 7.1a to 7.1b on servers and client machines. • Done Replications and database restore online/offline for contingency servers. • Troubleshoot the data issues during the migration. • Done Database cloning and replication, given hardware support Filer move, Tivoli storage etc.. • Installed Ab initio Co-operating v2.14 system and GDEv1.15 client software and helped developers in connection with database DB2 and Oracle. • Health Monitoring with Foglightv4.2 and spotlightv4.7 installation and implemented successful automated process of diagnosing and monitoring of many servers in Banking Environment. • Provided training to peers with installation and maintenance of 3rd party applications. • Administering Netbackups and SAN storages |
|||
| Years | Employer | Title | Department |
| Years: 2005 to 2005 | Employer: Chekfree | Title: Sr DBA | Department: IT |
Responsibilities:• Logical designed and physical implemented for multiple OLTP, OLAP, DSS systems running on UDB EEE v5, v6, v7 and v8 under AIX 4.3, AIX 5L platform. Included but not limited on instances databases and all database objects creating, file systems setting up, space design and allocating, user accounts creating, system configuring, system access control setting up. All house keeping scripts created or prepared.• Configured and implemented Ab initio server and client and help ETL developers in data connection and support. • Used command line process to configure memory according to the number of concurrent users, workloads and the types of database operations (OLTP or DSS). Planned file systems/locations for data storages with consideration of data types and volumes. Implemented security on databases based on requirement of user/groups. • Planned and Implemented DB2 UDB V7.2 systems of Disaster Recovery (DR) and High availability (HA) strategy. • Participated DB2/UDB candidates technical interviews and responsible for on-the-job training of junior members of the Database Administration group. |
|||
| Years | Employer | Title | Department |
| Years: 2003 to 2004 | Employer: Arabian Odyssey | Title: Sr DBA | Department: IT |
Responsibilities:• Installation and configuration of DB2 UDB v 7.2(UDB EEE) on AIX5.1. Functioned as a DB2 Database Administrator responsible for the performance and tuning of DB2 Programs.• Actively participated in brain storm sessions with Analyst in creating the ER diagrams in Erwin. • Created event monitors to check the health of the system. • Using replication summery tables collocation tables is done • Created Database partition groups by grouping the different database partitions. • Created Snapshot monitors and event monitors to regularly check the health of the system. • Used various BMC tools for monitoring of database. • Created EXPLAIN tables and ran the Visual Explain utility on SQL statements. • Installed SQL-Server2000 and Win2000 and configured them to install KMA. • Provided support to Oracle and SQL-Server2000. • Created EXPLAIN tables and ran the Visual Explain utility on SQL statements. • Used different Data movement utilities like IMPORT, EXPORT, and LOAD utilities to load data from Oracle database to DB2 database. • Performed Reorgchk, Reorg and RUNSTATS as and when necessary to eliminate the defragmentation. • Developed Backup and Recovery Strategies. • Used Quest Tool to monitor the Buffer Pools, Table spaces and Locks to improve the performance. |
|||
| Years | Employer | Title | Department |
| Years: 2002 to 2003 | Employer: Igma Advertising | Title: Sr DBA | Department: |
Responsibilities:• Installation and configuration of DB2 UDB v 7.2(UDB EEE) on SP2 (AIX). Moved databases from older version of DB2 V5.2 to 7.2 & from Oracle to V7.2 & Call support for production environment.• Functioned as a DB2 Database Administrator responsible for the performance and tuning of DB2 Programs. • Migration of People soft tables on Oracle to Peoplesoft 8.0 on DB2 UDB v 7.2 • Database design, customisation and administration of Websphere provided tables. • DB2 database analysis and design for data handling physical and logical design normalization and conversion of data from Oracle to DB2 • Setup of Tivoli ADSM for storage, Backup and restore. • Did performance tuning of E-CRM packages and HRMS modules for monthly releases. • Used Data Joiner to join the data between Oracle and DB2 |
|||
| Years | Employer | Title | Department |
| Years: 2001 to 2002 | Employer: Modi Measurements Systems | Title: Sr DBA | Department: IT |
Responsibilities:• Installation and configuration of DB2 UDB on AIX / Windows NT.• Provided 24/7 support for a Data Warehouse for both production and development databases on Multiple Database Partitioning Environment. • Created Instances for Development, Test and Production environments. • Installed and configured databases on Oracle8i and MS SQL Server7.0/2000. • Work involved create, configure, upgrade and maintenance of the UDB database in Windows NT and AIX environments. • Setup DB2 Clients on NT and Linux. • Setup of Tivoli ADSM for storage, Backup and restore. • Connected Sun and NT nodes to server. • BMC software was used in various database administration functions • Created Logical and Physical Design of the database. • Imported Data using Load and Import Utilities. • Created Snap shots and used Performance Monitor to analyze the current activity that is going on in the database. • Ran load and unload utilities on Mainframe to extract data from MVS and load it into DB2/UDB. • Wrote ETL scripts for data loads from various sources – Oracle 8i UDB and MS-SQL Server 6.5/7.0 • Written ETL scripts for the informatica (PowerMart4.7/PowerCenter1.7) in order to populate the IMS DataMart using the flat files. |
|||
International Experience
| Years | Country / Region | Summary |
|---|---|---|
| Years: 2007 to 2009 | Country / Region: UK | Summary: Worked for Healthcare solution providing company. |
| Years: 2005 to 2007 | Country / Region: UAE | Summary: Consulting for Financial and solution providing companies such as Chekfree, Bank of America and IBM. |
| Years: 2002 to 2004 | Country / Region: UAE | Summary: Worked fulltime for Travel and Advertising company Arabian Odyssey and Igma Advertising |
| Years: 2001 to 2002 | Country / Region: INDIA | Summary: Worked for Automotive and Commissioning company Modi Measurements. |
Fields of Expertise
client/server architecture, client/server computing, client/server database access software, computer system administration, data management, data processing, data recovery, database, database design, database file management, database management, database management system, database metalanguage, database programming language, database searching, database server, database technology, DB2, DB2/QMF, DB2/SQL, document scanning, federated database, multidimensional database, object-oriented database, open database connectivity standard, Oracle, relational database, SQL database, Standard for the Exchange of Product Model Data, Structured Query Language, transaction processing, clinical database development