PROFILE

Highly accomplished, deeply driven, Results-oriented IT Professional with 14+ years of experience having 10+ years of experience in Oracle 9i/10g/11g and DB2 UDB (EE and EEE) database administration supporting OLTP and DSS(over 12 Terra bytes) databases. Have extensive experience in setting up high available architecture using Oracle RAC(9i, 10g and 11g), HADR and HACMP, architecting Data warehouse databases of multi terra bytes using Oracle and DB2 UDB DPF. Have in depth knowledge on Financial and Retail industry functions and process flows. Proven record of accomplishment in providing strategic direction and delivering high quality solutions
.
Expertise and Strengths include:

• Data placement analysis
• Logical & Physical Database Designing / Architecture, Designing DSS, OLAP & OLTP Systems
• Exceptional analytical and problem solving skills
• Design, Architect and implement high available and highly scalable database solutions.
• Package Software Support, Production support of large business critical Oracle and UDB databases.
• Good knowledge of SOX and PCI compliance, experience with Security and Auditing
• Prepare business requirements reports, feasibility studies.
• Ability to manage and execute multiple projects in high pressure, dynamic environment with critical time lines.
• Strong leadership qualities with ability to define individual and shared goals for teams.
• Maintain best practices, implementing new technologies to ensure customer service satisfaction.
• Proactive preparation, in-house technical training’s, Proposal presentations and Database
• functionality walkthroughs to the Application development team.
• Proactively manage diverse functions adding value as a Solutions Architect.
• Knowledge and experience in Six SIGMA, ISO 9001, CMM.

Professional Certifications achieved:

• IBM CERTIFIED PROFESSIONAL DB2 UDB Database Administration
• ORACLE 8i,10g CERTIFIED PROFESSIONAL ORACLE Database Administration
• CSQA Certified Software Quality Analyst

TECHNICAL SKILLS
DATABASE DB2 UDB 9.7/9.5/8.x/7.x, Oracle 11gR2, 10g, 9i, 8, 7, RAC (11gR2,10g, 9i),
SQL Server 2005/2008, MySql 5.1, Sybase12,5
DATABASE TECH. RAC, ASM, Data Guard, RMAN, Grid Control, Enterprise Manager, Streams, Advanced Replication, DB2 HADR, DB2 SQL and Q Replication
O/S HP-UX 10, Solaris 8,9,10, AIX 4.3, 5L, 6.0, RHEL4, 5, SuSE 8, Windows NT.
TOOLS Grid Control, OEM, Informatica PowerMart /PowerCenter 7.x, CVS, SVN, Wiki, Jira, Eclipse, Dynatrace.
DESIGNING Erwin 3.5.2, 4.0, ERStudio 5.1.1, Designer 6i
LANGUAGES SQL, PL/SQL, HTML, Java, C, C++, Pro*C, JAVA, J2EE
utilities DataPump, Import, Export, Load, SQL*Loader, db2pd, db2top, db2hpu
NETWORK TECH. SQL*Net, NET8, ODBC, JDBC.
BACKUP TECH. RMAN SQL-BackTrack, EMC SRDF/BCV, Tivoli ADSM, Veritas NetBackup

PROFESSIONAL EXPERIENCE

Confidential,Chicago, IL Mar 2011 to Till Date
Database Administrator/Infrastructure Engineer (Oracle 10g/11g, DB2 UDB(EE and EEE) 8.2/9.5/9.7, MySQL 5.1, SQL Server 2005/2008 on AIX, Linux, Windows NT) in Online Business Unit(OBU) group supporting databases and infrastructure for highly transactional sears.com, kmart.com and mygofer.com (IBM Websphere eCommerce) databases and OBU data warehouse databases.

• Responsible for availability and performance of online(sears.com, kmart.com and mygofer.com) database.
• Lead the effort for infrastructure upgrade for holiday readiness.
• Designed and implemented new ETL process for data propagation from staging environment to online environment.
• Implemented HADR solution for db2 udb databases.
• Lead the effort for database upgrades from db2 udb 8.2 to v9.7 and v9.5 to 9.7
• Manage project timelines, completion status, on-call schedules and resource allocation for the DBA Group
• Did POC on Natezza and Vertica to improve catalog indexing build process.
• Analyze and understand business requirements to insure optimal database architecture and infrastructure are put in place for assurance of high availability and recoverability of database operations.
• Perform capacity planning related activities on database storage and performance.
• Provide support for databases in OBU.

Confidential,MI, USA Jan 2007 to Feb 2011
Lead Database Administrator (Oracle 8i/9i/10g/11g, DB2 UDB(EE and EEE) 7/8.2/9.5/9.7, SQL Server 2005/2008 and Sybase 12.5 on AIX, Linux, Windows NT) in Database Administration group supporting databases for various applications include Store Catalog Search, Online Inventory control, Business Intelligence, Warehouse Management system(WMS), Store perform, Retek, Websphere portal, peoplesoft, Lawson, and Websphere eCommerce(borders.com) and Order Management System(OMS).

• Responsible and Single point of contact for over 15 Applications, Spread across 100 databases of size 50GB – 4000GB (4.0 Terra Bytes).
• Implemented strategic direction to create consistency within the Infrastructure group
• Designated team representative for infrastructure customers and other team managers
• Manage project timelines, completion status, on-call schedules and resource allocation for the DBA Group
• Analyze and understand business requirements to insure optimal database architecture and infrastructure are put in place for assurance of high availability and recoverability of database operations.
• Perform capacity planning related activities on database storage and performance.
• Identified and led the consolidation of db2 udb and oracle databases resulted in savings of $200,000 per year in license cost.
• Designed and implemented 2 node oracle10g RAC environments for WMS and OMS application databases.
• Did POC for 11gR2 RAC on RHEL5 to migrate from 10g RAC on AIX.
• Installed and configured Oracle 10.2.0.4 Grid Control.
• Installed and configured ASM 10.2.0.4 and 10.2.0.1.
• Performed RAC Component Failure testing and Disaster Recovery testing.
• Integrated Oracle and DB2 UDB backups with EMC Data Domain appliance.
• Migrated enterprise Data warehouse DB from Oracle 9i to 10g(10.2.0.4).
• Designed and implemented new data warehouse db in Oracle 10g for online business unit.
• Migrated DB2 UDB databases from V8 FP14 to V9.5 and 9.5 to 9.7.
• Implementation of high availability and disaster recovery of databases using UDB HADR, DB2 SQL Replication, HACMP, Oracle RAC.
• Designed and Implemented 2 node HACMP solution for Borders.com databases.
• Analyzing, solving and creating solutions for very complex performance tuning situations.
• Database server Installation, Database Creation, Maintenance, Backup, Recovery & Performance Tuning
• Develop and implement enterprise-wide database development/management strategies and solutions
• Review logical models and create physical model to assure both data integrity and application performance
• Work with application and system administration and venders to coordinate activities, resolve development and maintenance issues, and perform application tuning.
• Design, development and implementation of security policies and integrity controls including SOX/PCI audit requirements.
• Lead teams in coordination projects such as databases upgrades and consolidation.
• Verifiable record for achievement of Exceeding Expectations, as a Senior Database Administrator.

Confidential,USA Aug 2005 to Dec 2006
Senior Database Administrator (IBM DB2-UDB(EE and EEE), Oracle on AIX) in Database Management Support Services group for Investment and Capital Markets (ICM) Applications and Corporate Data Warehouse(CDW).

• Responsible and Single point of contact for over 10 Applications, Spread across 60 databases of size 50GB – 12000GB (12 Terra Byte).
• Managing multiple Production and Development Oracle and UDB(EE and EEE) Applications environments of different releases.
• Database server Installation, Database Creation, Maintenance, Backup, Recovery & Performance Tuning
• UDB database migrations from FP6c to FP11 and from 32 bit Instance to 64 bit instance.
• Manage CDW database which was over 12TBin size and was spread across 10 physical servers and 18 logical partitions.
• Migration of Oracle databases from 9.2.0.7 to 10g(10.1.0.4)
• Installed and configured ASM 10.2.04
• Performance tuning using Oracle OUTLINES
• Implementation of high availability and disaster recovery of databases through UDB HADR, Oracle Data Guard and Replication
• Developing shell scripts for database monitoring and maintenance.
• Research and resolve database issues.
• Design and implement required processes to ensure ongoing audit/SOX compliance for databases.
• Performing certifications for new RDBMS features and new versions
• Develop and implement enterprise-wide database development/management strategies and solutions
• Verifiable record for achievement of Exceeding Expectations, as a Database Administrator.

Confidential,MD, USA Mar 2005 to July 2005

Lead Database Administrator (IBM DB2-UDB(EE and EEE), Oracle on Aix) for Information management services – Duetsche Bank supporting E-Commerce and Business Intelligence applications.

• Responsible and Single point of contact for over 10 Applications, Spread across 40 databases of size 50GB – 3000GB (3.0 Terra Byte).
• Logical & Physical Database Designing
• Analyze and understand business requirements to insure optimal database architecture and infrastructure are put in place for assurance of high availability and recoverability of database operations.
• Database server Installation, Database Creation, Maintenance, Backup, Recovery & Performance Tuning
• Implementation of high availability and disaster recovery of databases using EMC SRDF.
• Automation of backup and restoring process for UDB and Oracle databases using shell scripts.
• Perform capacity monitoring, short term and long term capacity planning working with development resources, system administrators and system architects.
• Develop and implement enterprise-wide database development/management strategies and solutions

Confidential,AZ, USA Aug 2001 to Feb 2005
Lead Database Administrator (IBM DB2-UDB(EE and EEE), Oracle on Sun, AIX and Windows NT) for Information Management Services - American Express technologies (IMS – AMEX).
Three and Half years of progressive responsibility & Full life-cycle experience on OLAP and OLTP systems.

• Rich experience in two DBMS Platforms – IBM DB2 UDB and Oracle.
• Responsible and Single point of contact for over 15 Applications, Spread across 65 databases of size 50GB – 1500GB(1.5 Terra Byte).
• Pioneered Re-engineering Initiatives and Key contributor towards the 4. 1 Million IMS - AMEX 2003 Goal, through Cost Reduction and Cost Avoidance savings. Tasks included Automation of periodic Purge, Load and Monitoring, Decommissioning of obsolete Databases, Performance tuning resulting in CPU cycle saves, Permanent fix and root cause analysis for production Issues.
• Subject Module Expert for Migration projects : Analyzed & Deployed database migration projects from UDB7.1 to UDB8.1 and Oracle8i to Oracle9i . Mastered the intricacies of migration issues.
• Hand Picked to draft the Database Disaster Recovery plan: Wrote and implemented a procedures manual for databases.
• Pro-actively designed and implemented a Database Contact Tool (DCT): The result was a 80% decrease in the time taken to reach out to the owners of the Databases, Instances Servers.
• Efficiently, forecast current and nearly available technologies for adaptation to current business processes, which resulted in adaptation of QWEST, BMC PATROL tools.
• Proven ability to serve as a liaison among business and technical staffs and end users.
• Verifiable record for achievement of Exceeding Expectations, as a Database Architect and Administrator. Successfully managed client expectations as a Lead DBA and recognized as a strong, positive leader and a sharp strategic thinker.
• Re-Design and Strategic Planning capabilities resulted in efficient implementation and minimum to zero maintenance down time. Set processes for documentation in place, to avoid ‘Re-Invent’ the wheel situations for future projects.
• Thrive on opportunities to drive people, processes and technology. Constantly involved in In-House training’s and knowledge sharing sessions to fellow colleagues.
• Active role at the Marketing Intelligence front with focus on preparing proposals for DBA outsourcing projects and presenting the same to prospective clients across USA.

Confidential, Jan ‘00 – Jul ‘01

DBA (Oracle 8i and UDB 7.2 on Sun Solaris)
Project: Analysis, design, development, install and maintenance of Trading and Settlement system for Bangalore Stock Exchange. Trading system will provide common interface to trade on multiple stock Exchanges and monitoring of exposures. Settlement system download all trades from trading system, calculate obligations at broker and sub-broker level, maintain settlement calendar for various kind of securities and make settlement at exchange level.

Size of the DB: 500 GB, Users- 600

Responsibilities:

• Complete cycle, including Analysis, Design, development, testing, training and production.
• Installation, Upgrade and Configuration of ORACLE and UDB.
• Extensive Performance Tuning, Memory Tuning.
• Applying Patches both Server side and Client side.
• Developed user interface on UNIX environment.

Confidential, (Birmingham, UK), oct ‘98 – dec ‘99

Worked with Kalamazoo as contractor.
Developer, DBA and onsite coordinator(Oracle 7.1.3, Pro*C on Sun solaris)
Project: Kalamazoo has software called ELITE for automobile dealers to carry out dealership business. ELITE software front end was developed in Forms 3.0, database was built in oracle 7 and reports were in SQL reports. Project is to migrate front end from Forms 3.0 and Forms 4.5 and Reports from SQL reports to Pro *C.
Responsibilities:

• Installation and Configuration of Oracle (7.3.2.3)
• Building Reports in Pro *C.
• Tuning the queries using TKPROF and Explain.
• Unit testing, Module testing and Integration Testing.
• Unix make files for compiling Pro *C programs.
• Writing common libraries in Pro *C

Confidential, (Bangalore, India) nov ‘97 – sep ‘98

Developer (Oracle 7.3.4 on Sun Solaris , Forms 4.5)
Project: Kalamazoo has software called ELITE for automobile dealers to carry out dealership business. ELITE software front end was developed in Forms 3.0, database was built in oracle 7 and reports were in SQL reports. Project is to migrate front end from Forms 3.0 and Forms 4.5 and Reports from SQL reports to Pro *C.
Responsibilities:

• Installation and Configuration of Oracle (7.3.4.)
• Building Reports in Pro *C.
• Migrate the front end.
• Unit testing, Module testing and Integration Testing.
• Unix Shell scripting in csh, ksh for compiling Pro *C programs.
• Writing common libraries in Pro *C

Confidential, (pune, india), July ‘95 – Oct ‘97

Developer and DBA (Oracle 7.3.4, developer 2000)
Project: Analysis, design, development, testing, implementation and maintenance of production planning and control system for Sterlite Industries Pvt Ltd. Automating all processes involved in various departments.
Responsibilities:

• Installation and Configuration of Oracle (7.3.2.3)
• Building Reports in Pro *C.
• Tuning the queries using TKPROF and Explain.
• Developing front end on Forms 4.5 and Unit , Module and Integration Testing.
• Developing and maintenance of source code control scripts in UNIX.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).
• Database triggers are used to enforce the integrity constraint
• Unix Shell scripting in csh, ksh for compiling Pro *C programs.

EDUCATION

BE : Bachelor of Engineering with specialization in Electronics and Communication Engineering.