We provide IT Staff Augmentation Services!

Sr Consultant, Performance Resume

4.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • Over 15 years of IT experience as Database Administrator on various databases(Primarily DB2, SQL Server) with Financial and Health Care Industry, ERP Systems
  • Experience with Confidential LN/M3/CSF databases administration
  • Experience with PeopleSoft Financials/Portal/EPM/ABM/FDW/PJP (OLTP, Data Warehouse) systems in EEE multi TB environment.
  • Experience in designing, creating and Upgrading SAP db2 databases
  • Experience with Installing, Settingup of DB2/Oracle databases
  • Experience with Health Care Applications OLTP systems
  • Basic Scripting Experience with HP LoadRunner11.0
  • Monitoring & Troubleshooting of AWS cloud EC2 instances(MT), and Single Tenant servers
  • Deployment of LN/M3 application fix pack updates on Multitenant Applications.
  • Performance monitoring and Analysis of Multitenant Applications on AWS cloud
  • Performance monitoring using LogicMonitor/Monocle
  • MT application logs Analysis using Sumo Logic
  • Instance and database creation and configuration in non - partitioned (EE) and partitioned (EEE/ESE) database server including multiple logical (MLP) and multiple physical partition (MPP) configurations.
  • Installation, configuration, and upgrade experience on single processor, symmetrical multi-processing (SMP), massively parallel processor (MPP), with enterprise storage area networks (SAN).
  • Experienced in installation of DB2 LUW 11.1/10.5/10.1/9. xx/8.xx
  • Experienced in SQL Server 2014/2016 DBA
  • Experienced in Setting up DB2 BLU 10.5
  • Exposure and Experienced in Setting up DB2 pure Scale 10.5
  • Experienced in Implementing WLM (Workload Manager)
  • Basic Scripting Experience with HP LoadRunner11.0
  • Creating and Converting Existing Databases to Automatic Storage Databases
  • Designing, Creation and Upgrade of SAP databases
  • Performance Tuning of DataStage, Business Object queries
  • Implemented MDC and Range Partitioned Together on one table and implemented Separately.
  • Setting up of AIX and Linux Environments (Single and Multiple LPAR’s)
  • Database migrations from AIX to RedHat Linux (EE, EEE and from EE to EEE)
  • Database, instance monitoring using snapshots, event monitoring (DBM, DB, Application, Lock, FCM, Dynamic SQL) and Problem determination.
  • Good Expertise with DB2MTRK, DB2TOP, DB2PD and review information for problem determination.
  • Tier0 (SSD-Thin Pooling), Tier1 (Fiber Channel), Tier2 (SATA), Tier3 (Clarion) Disk designing for Table space Containers (Data, Log, Archive Log, Backup and Archive) without contention.
  • Database migrations for Tier1 EMC disks to SSD EMC disks.
  • Setting up of Tablespace Containers to support Parallel Processing without contention for OLTP Databases and for Data Warehouse(DSS Databases)
  • Requirements gathering, reviewed with Users, Architects and Developers for Capacity Planning
  • Participated in Logical Design of DB2 Custom Designed Databases for both Transactional (OLTP) and Decision Support Systems (DSS VLDB) (Helped in Defining Partitioning Key).
  • Experienced in UDB V10.5, V10.1, UDB V9.7, V9.5, V9.1, V8.2 on LUW Operating Systems.
  • Production Support of Oracle 11g, SQL Server and Sybase databases
  • Proficient in Database Migrations and Recovery of databases.
  • Worked with SYSADMINS to setup of Database cluster Servers and DR servers.
  • Actively participated in DATA CENTER Migrations(Requirements Gathering, Planning, Setting up of New Data Center and Implementing, Migrating database and application Servers).
  • Actively participated in DR tests and Real DR Activates, including DR planning, setup, testing etc.
  • Application and Batch Process Tuning Efforts Achieved 40+% of Runtime Gains.
  • Good understanding and working Experience of Statistical Views
  • Setting up of Optim Performance Monitoring(OPM) for Database monitoring.
  • Setting up of Optim6.1 for Database Archiving
  • Installation, Setup of DB2 High Performance Unload.
  • Writing Shell Scripts for Database maintenance Activities including but not limited to REORG, RUNSTATS, Pruning of Logs
  • Database recovery experience with backup, restore, roll-forward, and log archival
  • High availability (HA) experience with VERITAS Clutter Services (VCS) and HADR.
  • SQL Tuning Efforts and DBM, DB CFG Parameters and database performance Tuning.
  • Stored procedure, user defined function, and user defined table function experience with DB2 SQL/PL and Java.
  • 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 Computer Associates ERwin.
  • Supporting PeopleSoft Installation/Migrations/Upgrades.
  • Worked with People Soft Financials/Portal/EPM/ABM UDB DB2 running on AIX/Linux(RedHat) OS.
  • Scheduled the conference calls with the Off-Shore teams and coordinated the smooth transition and take over.
  • 24/7 On-Call Support.
  • Highly experienced in resolving deadlock and time out issues, which are common with most of the 3-tier vendor product applications which contain lot of Referential Integrity and DB triggers.
  • Experienced in designing multiple LPAR’s or physical nodes to establish UDB DB2 multi-partitioned database servers, experienced in DB2 Clusters and partitions (Physical Nodes & Logical Partitions)
  • Setting up of all filesystems (JFS and Large File enabled JFS), home directory of DB2 instance (NFS exported), across multiple physical nodes with appropriate naming conventions defined by the Production UNIX Sysadmins.
  • Using SMITTY, performed most of the UNIX administrator tasks using root authority
  • AIX/Linux(RedHat) OS Server space management
  • Helped SAN Admin in getting a good physical design of the database laid out on a multi partitioned environment with sizing of LUN’s, allocation of EMC Storage(SSD, Fiber Channel)
  • Worked with PeopleSoft/FCR/Hyperion/PJP Admin to Configure Applications with DB2 UDB 8.1, 9.1, 9.5, 9.7, 10.1 and 10.5 and setting up of Application Security, SQL Server 2012
  • Migration of PeopleTools suite (PS 7.1 to 7.5.1 and from 7.5.1 to 8.1)
  • Migration of SAP DB2 V9.7 databases to V10.1 fp3a
  • Installation LN 10.1 on DB2 10.5
  • Worked on Oracle11g, SQL Server 2000, Sybase ASE 15.0
  • Installed and Configured Optim6.1 Application for Data Archive and Data Masking of Production Data.
  • Supporting FCR (Financial Control Report), PJP (Platform Journal Processing) application Migrations and Configuration Setup.
  • Worked with Application Admins to migrate application codes to perform DB2 database administration tasks.
  • Complete Design (Physical and Logical) of PJP Application, ITM/RRM process Tables, Views, Referential Integrity, Database Triggers Setup.
  • Complete Design (Physical) of GH Application database

PROFESSIONAL EXPERIENCE:

Confidential

Sr Consultant, Performance

Responsibilities:

  • Monitoring & Troubleshooting of AWS cloud servers
  • Deployment of LN/M3 application fix pack updates on Multitenant Applications.
  • Performance monitoring and Analysis of Multitenant Applications on AWS cloud
  • Installation and configuration of DB2 instances/databases and SQL Server instances/Databases.
  • Performance tuning of LN 10.4/10.6 with db2 databases and SQL Server Databases
  • We enable traces on Operating systems and on database level and collect traces and analyse the resources and provide recommendations on resources and databases for better performance of the application/databases.
  • Performance Tuning and Production support
  • Identify long running queries and tune them.
  • Monitor databases using SQL Server Activity monitor.
  • Writing and Modification of SQL Stored Procedures
  • Performance Testing/Manual Testing of LN/M3 Applications
  • Used DB2PD on table level to find Number of Insert, updates, deletes on table and Index usage for heavy hit Tables and to find out reorg processes stage/status checks
  • Performance tuning of dynamic sqls captured from snapshots using tools like db2 explain, db2advis and created different types of event monitors to monitor databases.
  • Discussed, Designed, Documented, Implemented, and lead the team in project planning, system design, development and testing, security, and documentation on the entire project.

Environment: UDB DB2 11.1/10.5, RedHat Linux, Windows 2012 R2, LN, Lawson S3/M3

Confidential

Sr UDB DB2 DBA

Responsibilities:

  • Setting up failover nodes for 4 LPARS(with 32 partitions) using TSA forWarehouse Databases
  • Setting up of DR Databases
  • Implemented WLM(Identifying work, designing service classes, Workloads and setting up thresholds and Remapping of Service classes)
  • Identification of HASH/Distribution Keys for tables to eliminate data skewing between nodes and by giving importance to collocated joins
  • Performance Tuning and Production support
  • SQL Query Tuning activities and implemented MDC’s, Statistical Views
  • Implemented MQT’s and Replicated MQT’s
  • Identify long running queries and tune them.
  • Implementing HADR databases with TSA(Tivoli System Automation)
  • Used DB2PD on table level to find Number of Insert, updates, deletes on table and Index usage for heavy hit Tables and to find out reorg processes stage/status checks
  • Performance tuning of dynamic sqls captured from snapshots using tools like db2 explain, db2advis and also created different types of event monitors to monitor databases.
  • Discussed, Designed, Documented, Implemented, and lead the team in project planning, system design, development and testing, security, and documentation on the entire project.

Environment: UDB DB2 V9.7/V10.1,10.5 AIX/6/7.1, BusinessObjects, db2 TSAMP, Cognos

Confidential

Sr UDB DB2 DBA

Responsibilities:

  • Migrating UDB V9.7 to 10.1 and V9.7 to V10.5
  • Setting up db2 BLU 10.5 on LAB/POC/SIT Servers
  • Converted Single Partition Databases to 8 Node SMP HASH Partitions
  • Identification of HASH/Distribution Keys for tables to eliminate data skewing between nodes and by giving importance to collocated joins
  • As part of Disaster Recovery strategies, implemented HADR on one of the OLTP Production Servers clustered across two IBM p-7 servers.
  • Tuning and Production support for NCCT/EBP databases
  • SQL Query Tuning activities and implemented MDC’s and Statistical Views
  • Everyday Monitoring of NCCT/EBP User activity and Reporting process and make sure identify long running queries and tune them.
  • Implementing HADR databases with TSA(Tivoli System Automation)
  • Setting up db2 pureScale 10.5 on LAB/POC Servers
  • Actively Implemented WLM(Work Load Manager)
  • Widely using DB2TOP tool to find out bottlenecks, ongoing executing applications, locks, snapshot of applications and queries which are running, bufferpool hit ratios etc.,
  • Expertise in using DB2PD, DB2TOP, and Widely used SYSIBMADM Views to find Index Usage, Locks, Waiting Locks, Instance, Database configuration checks, Bufferpool hit ratio, Tablespace containers checks, Application info, Active Statements, Dynamic Cache, FCM buffers usage, Reorg Process checks, Utilities checks
  • Used DB2PD on table level to find Number of Insert, updates, deletes on table and Index usage for heavy hit Tables and to find out reorg processes stage/status checks
  • Widely used db2 admin move procedure as part of online data move activities
  • Done various restore and roll-forward recovery operations from the source to the target databases as and when required.
  • Performance tuning of dynamic sqls captured from snapshots using tools like db2 explain, db2advis and also created different types of event monitors to monitor databases.
  • Client Configuration, instance set up for client connectivity
  • Discussed, Designed, Documented, Implemented, and lead the team in project planning, system design, development and testing, security, and documentation on the entire project.

Environment: DB2 BLU 10.5, DB2 pureScale 10.5, UDB DB2 V9.7/V10.1,10.5 AIX/6/7.1, Linux 5.6(RedHat), BusinessObjects, db2 TSAMP.

Confidential

UDB DB2 DBA/Oracle

Responsibilities:

  • Migrating UDB V9.5 to V9.7, V9.7 to 10.1
  • As part of Disaster Recovery strategies, implemented HADR on one of the OLTP Production Servers clustered across two IBM p-5 servers.
  • Implementing HADR databases with TSA(Tivoli System Automation)
  • Widely using DB2TOP tool to find out bottlenecks, ongoing executing applications, locks, snapshot of applications and queries which are running, bufferpool hit ratios etc.,
  • Online data movement for tables by using db2 admin move procedure
  • Supporting SAP, SAS, GuidedHealth, Business Object, DataStage Applications/Tools
  • Responsible for design, creation and to upgrade SAP databases from 9.7 to 10.1 and used DBA COCKPIT to find out db backup issues and Changing DBM/DB cfg parameters
  • Expertise in using DB2PD, DB2TOP, and Widely used SYSIBMADM Views to find Index Usage, Locks, Waiting Locks, Instance, Database configuration checks, Bufferpool hit ratio, Tablespace containers checks, Application info, Active Statements, Dynamic Cache, FCM buffers usage, Reorg Process checks, Utilities checks
  • Used DB2PD on table level to find Number of Insert, updates, deletes on table and Index usage for heavy hit Tables and to find out reorg processes stage/status checks
  • Widely used db2 admin move procedure as part of online data move activities
  • Responsible for Physical database model maintenance on OLTP and Warehouse Databases
  • Tuning GuidedHealth Batch Process, Reporting process, Table and Tablespace Design changes, Container modifications and Achived 45% of runtime Savings.
  • Table design changes by Implementing MDC and Range Partitions achived 60% performance Gains over the Batch Process
  • Implemented Range Partition Tables over Claim Tables
  • Done various restore and roll-forward recovery operations from the source to the target databases as and when required.
  • Responsible to Identify issues with newly implemented Information MDM process db2 as database
  • Performance tuning of dynamic sqls captured from snapshots using tools like db2 explain, db2advis and also created different types of event monitors to monitor databases.
  • Everyday Monitoring of GuidedHealth Batch and Reporting process and make sure identity long running queries and tune to meet Batch SLA’s .
  • Implemented Statistical View solutions for GH Queries and Rebates queries and achieved 70% of runtime savings.
  • Client Configuration, instance set up for client connectivity for BOBJ Application as part of setting up DR System for BOBJ Production system.
  • Designing, Implementing, Converting and Supporting BPW, PS, PBP(Pharmacy Benefit Plan) Processes and change of Process to run in Parallel Mode.
  • Implemented Adaptive Row Compression (on tables whose row count more than a Million) and achieved 75% of DISK SPACE savings.
  • Worked on Oralce 11g maintenance activities.
  • Oracle11g installation, database creation, setup activates, Production Support
  • Did periodic checks of the various database environments in terms of the growth of the data and maintained the threshold limit of 80% across all DMS table spaces.
  • Responsible for Implementation of OPTIM 6.1 tool in various servers.
  • Discussed, Designed, Documented, Implemented, and lead the team in project planning, system design, development and testing, security, and documentation on the entire project.
  • On-call support for Data warehouse and OLTP databases
  • Basic Scripting Experience with HP LoadRunne

Environment: UDB DB2 V9.7/V10.1, AIX5.3/6/7.1, Oracle11g, Linux 5.6(RedHat), BusinessObjects, Web-Sphere, OPM 4.01/5.1/6, SAP, DataStage, Informatica MDM, Corticon Rule Engine, LoadRunner11.0

Confidential

UDB DB2 DBA

Responsibilities:

  • Migrating UDB V8.2 to UDB V9.1 ESE and From V9.1 to V9.7 (MPP and SMP).
  • Setting up of EEE environment using 4 p-5, p-6, p-7(IBM Servers) LPAR’s with 17(logical nodes) having 10TB data warehouse.
  • Setting up of EEE PeopleSoft environment using RedHat Linux LPAR with 4 Logical nodes having 2TB(Allocation) PeopleSoft Transactional database.
  • Designing PeopleSoft and Data Warehouse databases DISKs without Contention (Tier0, Tier1, Tier2, Tier3).
  • AWS servers monitoring.
  • Performance tracing of AWS servers
  • As part of Disaster Recovery strategies, implemented HADR on one of the OLTP Production Servers clustered across two IBM p-5 servers.
  • Table spaces and File system designing for EMC SSD DISKS(Think Pooling).
  • Creation of VCS (Veritas Cluster Services) Servers for Production databases.
  • Setting up of DR servers and SRDF file systems setup with EMC disks.
  • Supporting People Soft Financial Applications, Portal, EPM, ABM Migrations.
  • Expertise in using DB2PD, DB2TOP, DB2MTRK to find Locks, Waiting Locks, Instance, Database configuration checks, Bufferpool hit ratio, Tablespace containers checks, Application info, Active Statements, Dynamic Cache, FCM buffers usage, Reorg Process checks, Utilities checks
  • Used DB2PD on table level to find Number of Insert, updates, deletes on table and Index usage for heavy hit Tables and to find out reorg processes stage/status checks
  • Logical and Physical Designing of New Modules for Data Warehouse databases (CoRep, MI modules/functionalities).
  • User requirements gathering and reviewing with users, architects and developers for incoming data feeds to Unix systems(from Mainframe for the sources like TDA, DDA, Credit Card etc) for Capacity Planning for PeopleSoft GL(OLTP) and FDS(DSS) databases, and Determined extending the database partitions, adding CPUs, Memory, DISK and Increasing the number of FCM buffers.
  • DataCenter Migrations from Amhurst to Buffalo, From Buffalo to Volo and from Volo to Vernon Hills Actively handled real time DR Tests and actual DR situation.
  • Tuning People Soft Batch Process, Tablespace Design changes, Container modifications and Achived 45% of runtime Savings.
  • ITM/RRM/SQR processes Tunings effort and achieved 60% of runtime Improvements.
  • Session databases design, implementation and supporting
  • Done various restore and roll-forward recovery operations from the source to the target databases as and when required.
  • Implemented MQT’s for everyday repeatable queries and MDC’s for monthly RSF/JSF Journal Tables balances verification jobs.
  • Designed and Implemented Range Partitions (Monthly, Daily), and, as part of automating process, written scripts to Roll-in, Roll-out partitions.
  • Performance tuning of dynamic sqls captured from snapshots using tools like db2 explain, db2advis and also created different types of event monitors to monitor databases.
  • Everyday Monitoring of People Soft and FTP Batch process and make sure identity long running queries and tune to meet Batch SLA’s .
  • Extensive use of DB2 HPU to unload data from production then using DB2 Load Utility to load data onto Test Databases. This is to support and prepare test Bed for test Processes in BST/UAT databases.
  • Implemented Clustered Index Solution for Heavy Hit Tables (to remove ITM/PS LEDGER/PS JRNL LN tables PS batch tables from weekly reorg list).
  • Implemented Statistical View solutions for People Soft PS Queries and SQR queries and achieved 70% of runtime savings.
  • Client Configuration, instance set up for client connectivity for Cognos Application as part of setting up DR System for Cognos Production system.
  • Monitoring databases Memory and CPU utilization on Server, giving suggestion to tune and Prioritize Workload and finding out heavy resource consuming SQL and scheduling change suggestions and implementation to reduce contention with User queries and Batch Process queries (ITM/RRM, FIRE and Downstream processes)
  • Implemented DB2 Governor to force long running SQR/PS Queries and User queries which run more than 30mins or select more than 72000 rows.
  • Designing, Implementing, Converting and Supporting ABM, GFDM/CIBM EPM Processes and change of Process to run in Parallel Mode to use multiple PeopleSoft Temp Tables.
  • Implemented Row Compression (on tables whose row count more than a Million) and achieved 62% of DISK SPACE savings.
  • Did periodic checks of the various database environments in terms of the growth of the data and maintained the threshold limit of 80% across all DMS table spaces.
  • Installation and Configuring Database Achieving Tool OPTIM 6.4.0/6.4.1.
  • Responsible for Implementation of OPTIM tool in various servers.
  • Discussed, Designed, Documented, Implemented, and lead the team in project planning, system design, development and testing, security, and documentation on the entire project.
  • On-call support for Data warehouse and PeopleSoft databases

Environment: UDB DB2 ESE/V8.2,V9.1 DPF(EEE), AIX5.3, Linux 5.6(RedHat), VCS, Cognos, Web-Sphere Commerce Suite, Peoplesoft, FCR, PJP, Hyperion, OPTIM 6.4.0/6.4.1/ OPM 4.01/5.1

Confidential

Database Administrator

Responsibilities:

  • Active Member in designing and setting up of Production, Staging and Development Databases.
  • Stored procedure, user defined function, and user defined table function experience with SQL/PL and Java.
  • 24 * 7 on-call rotation carrying pager all the time
  • Data Movement from Production to Non-Production and Staging, and Performance databases to support Test cycles.
  • Restore of Databases to support Test cycles
  • Instrumental in implementing frequent DDL changes and going thru the complete life cycle(development, UAT and Production) of the project in adding columns into existing tables, creating new tables, taking care of all the dependant objects in the process.
  • Worked on Hospital Specific Code Migrations, Hospital Specific Enhancements Table changes and Specific Report queries Tuning.
  • CSR’s and DCR workflow process and segregation and identification of Enhancements and Defects based on customer requirements
  • Supported and Involved on SQL Server Migrations .
  • Complete Physical Design of different functionalities and Rules for Pathways Contract Management Application.(Ex: Hourly Billing, Daily Billing, In Patient, Out Patient, Billing by Person, Billing by Child etc.,)
  • Performed various tests on the database from simple to complex queries and captured performance measures in order to assess Hospital specific queries performance.

Environment: SQL Server 2000, Windows 2002 Server, Sybase ASE 15.0, Crystal Reports

We'd love your feedback!