Sajay Mehta

adl5j9@r.postjobfree.com

440-***-****

SUMMARY:

I am a Senior UDB DB2 DBA with over 10+ years of experience in Database Administration on Unix, and Linux.

Database utility experience including reorg, runstats, rebind, export, import, load, auto-load, backup, restore and roll forward utilities.

Scripting experience korn shell to identify problems and monitor.

Database recovery experience with backup, restore, roll-forward, and log archival, and the DB2 advanced database recovery tool (db2dart).

High availability (HA) experience with HACMP and HADR.

Database monitoring and tuning experience using DB2’s Performance Monitor, Snapshot Monitor, Event Monitor, Explain, Visual Explain, and Index Advisor performance tools.

System, instance, and database security and auditing experience using table definitions, triggers, data replication, and the DB2 Audit Facility.

Problem identification, management, and resolution experience with DB2 diagnostics, trace facilities, and database analysis reporting tool (DART).

Database benchmarking experience using Quest Software Benchmark Factory and Mercury Interactive Load Runner benchmarking tools.

Database analysis and design experience using Power Designer Data Architect, Embarcadero ER/Studio, and Computer Associates Erwin.

Worked extensively with BCBS on SAP environments

Installation of PeopleSoft software on db2 instance, a 64-bit instance using PSOFT id

Worked with PeopleSoft HRMS 5/Payroll 8.9/ HR Help desk 8.8 on UDB DB2 running on AIX OS

Worked with PeopleSoft CRM 8.9 for communications on an AIX, UDB DB2 environment

Lead and mentored the junior UDB DB2 DBA’s as part of the transition of the Data teams DBA responsibilities(both Development and Production environments) in supporting countries.

TECHNICAL SKILLS:

UDB DB2 V9.7/9.5/V8.2/V7.1/V6.1, SQLServer, Oracle V7.1

IBM AIX 4.x & 5.x, Solaris 8, 9 & 10; Windows Server 2000, 2003; HP-UX 11i v2; Redhat Linux 8 and 9.

HACMP, Veritas Volume Manager (VxVM) and File System (VxFS) 3.5, 4.0, 4.1

Veritas Cluster (VCS) fundamental 3.5, 4.0., Peoplesoft HRMS/Payroll/CRM, TWS (Tivoli Work Load Scheduler), MS Office (2000/XP/2003), MS Windows (Vista, XP, 2000).

PROFESSIONAL EXPERIENCE:

COMMUNITY LOAN OF AMERICA, GA JAN 17 – DB2 UDB DBA

24x 7 Production support on-call support to determine and provide root cause analysis for any issues.

Performance Tuning – database manager, database configuration parameter tuning for optimal functionality.

Perform regular database health checks, gather database statistics and continually improve performance by tuning databases.

Monitored database load test for new built servers, summary report for total execution time, individual execution time for all statements ran, most expensive SQL’s ran during the test, report on deadlocks and timeouts detected during the test, CPU etc.

PeopleSoft Database Migration CRM, FIN, HCM PRT from ZOS to DB2 V9.7 /V10.5, V11.1

Custom shell scripting, to proactively solve issues/ monitor, and also automate task

DB2 installs, instance creation, db2 fix pack upgrades, instance upgrades, client upgrades, and client configuration from Windows/AIX Servers

DB2 shell rebuild /Export/Load, database object level comparison, Metrics tracking cutover planning

Configured Federation, setup custom maintenance jobs

Analyze application SQL for performance improvement opportunities

Perform database maintenance activities such as Backup, Reorg, Runstats, Rebinds

Reengineering Database for performance gains ZOS tablespace reduction / database configurations / SQL review/ indexing / Server Hardware analysis

Optimized storage utilization by database compression

Assisted Unix Team created file systems/instance id, groups, DB2 installation

Implemented Networker configuration as backup recovery strategy

Setup PeopleSoft tables for App designer

PepsiCo Plano, TX MAR 13 –DEC 16 DB2 UDB DBA

Provide 24X7 on-call support to troubleshoot issues with the Production databases and lead offshore team

Perform database maintenance activities such as backup, reorg, runstats, rebinds

Install and configure DB2 UDB new releases, database upgrades

Scripting, design/analysis, installation, monitoring, maintaining, troubleshooting, and tuning UDB databases

Maximize database performance by setting installation and storage parameters, allocate system resources and improve performance

Analyze application SQL for performance improvement opportunities and work with DB2 support on problems and questions.

Maintaining the production and Development database servers

Proactively monitor performance, diagnose problems and tune queries and database.

Assisting with the creation and modification of primary database storage structures tablespaces and other database objects

Responsible for performing DB2 UDB Version & fix pack upgrades.

Implement data security while making data available to those authorized to have access

Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server.

Perform capacity planning and analysis and implement required changes on multiple database server

Engaged with DEV/QA team for performance tuning taking Snapshots and gathering other information related to the database and the system during stress tests or performance tuning

Implement and test HADR performance for production environments, documented plans and procedures in terms of backups, restores and disaster recovery.

Travelport, Atlanta, GA APR 11 – FEB 13 DB2 UDB DBA

Provided 24x7 support to HomeDepot.com core Production environments, and Lower Life Cycles

Addressed daily Service Tickets, Monitoring alerts, and documented all work

Worked on new database and server builds which entailed configuring dbm, db cfg’s, database grants, supported Replication, cronjobs for database monitoring maintenance jobs, and DBI

Supported performance team Load Testing for holiday preparation, and performed database review with an overall evaluations on Key Performance Indicators, also what could be changed to improve performance.

Discussion with development teams on stored procedure not performing at the expected SLA

Created indexes where needed which solved the issue

Performed database version upgrades on DB2V8.1 to DB2V9.7

Designed and implemented an addition in efforts to better forecast Capacity Planning, and also maintenance job tracking on REORGS, RUNSTATS, REBINDS, and BACKUP for Application integration of Dashboard to be viewed historically

Worked with Application Team with problem SQL that caused Lock Timeouts, and offered review of changes to be implemented.

Worked with the TSM team on backup and archive log issues on slow delayed performance or failed TSM.

Setup TSA, HADR and setup Standby database to allow internal users to read from the database.

Monitored Replication and configured environment when performing database Redirected Restores

Supported HADR and HACMP environments and involved in testing with the AIX team

American Express, Phoenix, AZ DEC 07 – APR 11 UDB DB2 DBA

Development, implementation, and maintenance of the data mart made out of three Siebel servers each residing on RS/6000 servers with IBM AIX as the operating System, located in North America, Europe and Asia-Pacific regions, UNIX Shell Scripting and UDB DB2 V 7.2 EE special features.

DB2 UDB EE 7.x Database administration and support.

Experience in database restores and disaster recovery.

Created database objects: Tables, Table spaces, Indexes, views, aliases.

Logical and Physical Database design.

Altered tables and added check constraints and referential integrity.

As a member of DBA team, created and maintained databases, table-spaces, tables, views, and indexes.

Interact with business team and development teams for incorporating new functionality.

Participated in enterprise-wide application and database production releases.

Designed and implemented backup architecture viz., backup requirements, backup standards and retention's.

Developed shell scripts to handle DBA tasks and alerting systems.

Documented plans and procedures in terms of backups, restores and disaster recovery.

Checking the consistency of the databases using different db2 commands.

Data maintenance activities like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT and EXPORT.

Tuning application queries, Databases and Systems for best performance.

Performed performance tuning and capacity planning using the parameters of dbm configuration file & db configuration file and various db snapshots.

Contact this candidate