Anup Agrawal

480-***-**** (C) / ada895@r.postjobfree.com

Immigration Status: US Citizen

EXPERIENCE SUMMARY

20+ Years of comprehensive experience in all phases of software design, development, testing, system maintenance and database administration.

Extensive experienced in Informix Database Administration (12.x/11.x/10.x/9.x/7.x/5.x).

Extensive experienced in Oracle Database Administration (12c/11g/10g/9i).

Extensive experienced in Informix Installing, Configuring, database Migration, upgrade, Performance tuning, DR, Optimization, Capacity planning, Backup and Recovery, and Replication.

Highly experienced with MS-SQL Database Administration (2014/2012/2008R2/2008/2005).

Highly experienced in data modeling using ER-WIN.

Highly experienced in a variety of the operating systems.

Very strong in Shell scripting and AWK programming.

Experienced in application performance testing using Mercury Load Runner.

Well versed in System Analysis and Design, Client/Server architecture, relational databases and writing business logic both at front-end as well as at back-end.

Very strong in application programming (SQL, 4GL, ESQL/C, C). Experienced in complete Software Development Life Cycle (SDLC).

Have excellent communication and interpersonal skills with high level of adaptability.

Application experience includes Insurance System, Air cargo Import/export, Purchase system, and data conversion.

TECHNICAL SKILL

RDBMS

:

Informix 12.x/11.x/10.x/9.x/7.3x/7.2x/5.x,

Oracle 12c/11g/10g/9i/8i,

SQL 2014/2012/2008R2/2008/2005

DB2 UDB, Teradata, Universe

Tools

:

Veritas Netbackup, Veritas Cluster Manager, TSM, HP Open view, HPSA, Er-Win, Visio, Mercury Load Runner.

Languages

:

Informix 4GL, ESQL/C, AWK, Shell scripting.

WORK EXPERIENCE

1.Duration

:

Since Dec 2018

Client

:

Sonoma County, CA

Software

:

Informix 12.x

Role

:

Sr. Database Admin

Responsible for Sonoma County Informix databases upgrades form 10.x 12.x with minimal downtime.

Setup database replication using Informix HDR.

Provide production database support including monitoring, backup / restore, space addition.

Cloned production database to create QA and Dev server / databases.

Helping development team in implementing database configuration and schema modifications.

Helping Development and testing team in optimizing application SQL queries using database tracing.

Responsible for diagnosing issues, implementation fixes, troubleshooting, performance monitoring and tuning, upgrade and patching of database environment.

Serves Servers as an escalation point for all database related changes from database migration.

2.Duration

:

March 2017 – Feb 2019

Client

:

Safeway, CA

Software

:

Informix 12.x/11.x/10.x/9.x

Role

:

Sr. Database Admin

Responsible for Safeway’s Informix databases upgrades form 9.x 12.x with minimal downtime.

Involve in database upgrade planning and executions in 24x7 environments.

Setup database replication using Informix HDR.

Provide production database support including monitoring, backup / restore, space addition.

Streamlined / documented database upgrade process for other DBAs to follow.

Setup and configured Informix instances, occupied with multiple databases/application.

Helped development team in implementing database configuration and schema modifications.

Helped Development and testing team in optimizing application SQL queries using database tracing.

Responsible for diagnosing issues, implementation fixes, troubleshooting, performance monitoring and tuning, upgrade and patching of database environment.

Serves Servers as an escalation point for all database related changes from database migration.

Created Change Control tickets for production database changes and implemented them.

3.Duration

:

Since Jan 2010

Client

:

T-Systems North America, Scottsdale, AZ

Software

:

Informix 12.x/11.x/10.x, Oracle 11gR2/11gR1/10.x/9.x, MS-SQL 2005/2008/2008R2/2012

Role

:

Database Team Lead

Leading the database team to support multiple customer accounts with the database team in US and offshore.

Responsible for more the 100+ Informix database with replication, 50+ Oracle databases, including Oracle RAC, and MS-SQL database including SQL Clusters in a 24x7 environment.

Setup and configured Informix instances, occupied with multiple databases/application.

Migrated / upgraded several Informix database with minimum downtime.

Reviewed and modified existing Informix-4gl program for performance.

Responsible for design, engineering, technical implementation, troubleshooting, performance monitoring and tuning, upgrade and patching of database environment to keep up with supported version.

Serve as lead DBA on multiple projects in different database technologies (Informix / Oracle / SQL). Responsibilities include database design, creation and full-time support through the application lifecycle.

Helped Sales and technical solution team in database project efforts and timeline.

Lead the database migration effort from customer data centre to T-Systems data centre.

Responsible for creating/presenting Informix, Oracle, and SQL database reports to management on a regular basis.

Responsible for database charging mode and providing the report to account team.

Responsible for creating database standards, monitoring standards and helped team to implement them for Informix, Oracle, and SQL databases.

Lead the effort on server consolidation project as a Lead DBA and helped in optimizing and reducing database server counts.

Created Change Control tickets for production database changes and implemented them.

Software evaluation, testing, installation, migration and upgrade.

4.Duration

:

Nov 2002 – Dec 2009

Client

:

DHL Worldwide Express, Scottsdale, AZ

Software

:

Informix 11.x/10.x/9.x/7.x, Oracle 8.x/9.x/10.x/11.x, MS-SQL

Role

:

Lead / Sr. Database Administrator

Managed more the 100+ Informix Production servers, as Lead DBA. Also supported development and testing environment, including pager duty.

Setup and configured Informix instances, occupied with multiple databases/application.

Design and implemented the physical database layout for large and complex application for better performance and I/O.

Design and implemented data purge strategy using table fragmentation to reduce the locking contention and to reduce the database/systems load.

Setup and maintained database HDR and ER replication for business critical and global systems.

Written HPL jobs for loading the large amount of data.

Migrated business critical applications from 7.x to 9.x with 100% success and very little down time.

Performance monitoring and tuning, from O/S, database to application level in production environment.

Participated in application performance testing and flagged/tuned poor queries and tuned Informix onconfig parameters.

Setup full, incremental and logical log database Backups using Onbar and Veritas Netbackup.

Setup Informix database automated failover using Veritas Clustering.

Setup the database monitoring using HP Openview DBSPI, shell scripts in cron and database alarms program. Also setup two email aliases to notify or page on-call DBA depending upon critically of the alarm.

Co-ordinated with System Admin on SAN to understand it and make the best use in Database environment.

Dealt with Assert Failures, Inconsistency issues and worked with IBM till the time problem is resolved.

Kept the company critical system up and running during company merger phase.

Managed more the 70+ Oracle Production databases (10+ RAC databases) in a 24x7 environment with DBA team, also supported development and testing environment.

Installed and configured oracle 11gR1 and 10gR2 RAC database instances. Configured database monitoring in OEM, Setup database backups using RMAN in VERITAS netbackup,

Managed Universe database for very critical application and provided 24 x 7 production support.

Provided backup DBA role for MS-SQL environment.

Created Change Control tickets for production database changes and implemented them.

Software evaluation, testing, installation, migration and upgrade.

5.Duration

:

Jul 2005 - Dec 2005 (Part Time)

Client

:

Safeway Inc Scottsdale, AZ

Software

:

Informix 9.x/7.x, DB2 7.x/8.x, MS-SQL

Role

:

Sr. Database Administrator

Supported Production servers in a 24 x 7 environment with DBA team, including pager duty, also supported development and testing environment.

Worked on several projects with development and product support team to stabilize the database and application environments. Flagged, tuned poor queries and tuned Informix onconfig parameters for better performance.

Did the performance monitoring and tuning for the Informix databases in production environment.

Written HPL jobs to Reorg the very large tables to reduce number of extents.

Wrote several scripts for monitoring the database environments, also written and Implemented Update statistics script.

Created Change Control tickets for production database changes and implemented them.

Helped companies existing database support team in the Database odd hour implementations.

6.Duration

:

Jan 2001 – Oct 2002

Client

:

DHL Worldwide Express, San Francisco

Software

:

Informix 9.x/7.x, Er-win 3.5.2

Role

:

Database Administrator

Managed Informix Production databases in a 24 x 7 environment with DBA team, using IDS 9.x/7.x also supported development and testing environment.

Setup and configured Informix instances, occupied with multiple databases/application.

Design and implemented the physical database layout for large and complex application for better performance and i/o.

Setup and maintained database HDR replication for business critical system.

Written HPL jobs for loading the large amount of data.

Setup the database monitoring using shell scripts in cron and database alarms program.

Dealt with Assert Failures, Inconsistency issues and worked with IBM till the time problem is resolved.

Analyzed database changes impact on production system before implementation.

Managed database changes releases into production environment via Change Control Process.

Performance monitoring and tuning, from O/S, database to application level in production environment.

Conducted SQL query review sessions for new database queries going in production system.

Participated in application performance testing and flagged/tuned poor queries and tuned Informix onconfig parameters.

Designed and maintained data model for multiple applications using ERwin.

Designed, Developed, Debugged 4GL programs and shell scripts for quarterly data unload for shipment transit times.

Software evaluation, testing, installation, migration and upgrade.

Designed, created and maintaining DBA intranet site.

7.Duration

:

Feb 2000 – Dec 2000

Client

:

BMC Software, San Jose

Software

:

Informix Online 7.30, 7.31, 8.21 & 9.21

Brief Project Profile

The SQL-BackTrack for Informix is a complete backup and recovery management solution that can be used for all the Informix backup and recovery tasks.

Role

:

Informix DBA

Responsible for installing, configuring and maintaining the Informix 7.3x, 8.21 and 9.2x instance on HP-UX, AIX and Sun Solaris.

The main duties included Monitoring and keeping all supported environments up for SQL-BackTrack testing.

Helped the development team in understand of Informix database.

Participated in creating and executing clients backup and recovery scenarios.

Done the database recovery for customers from the backup tapes off site.

Provided 3rd level customer support for backup and recovery product.

8.Duration

:

Nov 1998 – Jan 2000

Client

:

DHL Airways, Redwood City

Software

:

Informix Online 7.24 4GL, ESQL/C

Brief Project Profile

Enhancement to the Export Control Handling Operations (ECHO) system. This is a key system for the business and supports many of DHL’s current business needs, such as compliance with US custom’s regulation, reduction in data entry, and tracking of shipment.

Role

:

Sr. System Analysts

My role was to analyze all enhancement requests to the ECHO application for implementation feasibility.

Reviewed business requirements and functional specification documents written by business.

Analyzed impact on other areas of application.

Estimated project effort. Determined team size for projects.

Wrote detail design documents and program specifications for new and modified modules.

Modified ECHO database schema in development/QA environment to meet project needs.

Conducted code review sessions for all code changes and optimising of SQL for better performance.

Managed code releases of all modules to QA and production.

Performed application performance testing using Mercury load runner.

Written several input programs, reports and complex month end transaction.

Designed and maintained data model of the ECHO application using ERwin.

Provide application production support to the end user and carried pager.

Interviewed and recommended for hiring new team members.

Trained and mentored new programmers on ECHO application.

9.CSC Ra Group, UK (Program Analyst / DBA) Nov 1995 – Sep 1998

As an analyst, perform the enhancement of Electronic Office Phase I and Phase II of insurance software package software. Involved in enhancement, development and release of the products new version. Provided the technical support to the end user. Also Responsible for Database Administration including-Configuring Instance, Performance tuning, Monitoring Extents, Estimating/ Recalculating Table Extents, applying database changes to the databases, creating the testing environment for QA team

10.Birla Consultancy, Bombay (Sr. Software Engineer) April 1995 – Oct 1995

Involved in the system study, design and in setting coding standards for programs. Wrote program specification for the masters, transactions and reports. The other role was coordination with team members and end user.

11.Sharjah Airport Authority, Sharjah, UAE (Sr. Software Engineer) May 1994 – Mar 1995

Involved in the system study, design, development, implementation and user training of cargo export/import system. Project included installation and maintenance of the Informix 5.01 server and its databases.

12.Mastek, Bombay (Software Engineer) May 1992 – April 1994

As a software engineer, my primary responsibility was to develop and implement programs written in ESQLC, Informix 4gl/sql. Participated in QA testing and ISO 9000 certification.

Contact this candidate