Manager Data

Thirupathi

DB*DBA

CELL650-***-****•E-MAIL: **********.*****@*****.***

Professional Summary

DB2 UDB DBA with over 7years of IT experience with last 7years of DB2DBA experience along with Strong Hands-on Experience in PL/SQL Development.

Experience in Data Analysis and developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.

Evaluating Data Sources and strong understanding of Data warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.

Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like Erwin, ER Studio.

Vast experience in supporting various business-critical trading applications.

Expert with designing and supporting DB2 DPF databases.

Strong experience with very large scale (80+ TB) various distributed databases.

Extensively worked on DB2 SQL replication.

Extensively experience with designing and supporting DB2 UDB DPF databases.

Extensively involved in refreshing production databases to stage for application testing.

Extensively worked in capacity monitoring, short term and long term capacity planning.

Tuned Complex SQL Queries to improve the overall performance of the database.

Implemented required security controls to meet audit requirements.

Tuned DB & DBM configuration parameters and DB2 registry variables.

Skilled in planning, implementing and tuning physical database design.

Expertise in distributed database performance tuning.

Expertise with V9.7, V9.5 and V 9.1.

Expertise in data migration/backup/restore strategies.

Strong working experience with EMC SRDF DR Failover and split.

Strong working knowledge of DB2 internal architecture and processing.

Vast experience with VERITAS HA clustering.

Expertise in Legato Tape/VTL/Disk backup’s.

Expertise in designing MQT’s and MDC’s.

Hands on experience with LBAC for integration.

Expertise in Logical and physical database design.

Skilled in STAR & Snow flake multi-dimensional models.

Strong experience in SQL performance tuning.

Strong working experience with db2gov, Query Patroller& DB2 Information Integrator.

Good working experience with third party tools such as BMC Patrol, HPOV, iwatch etc.

Expertise in database Backup and Recovery for partitioned environments.

Expertise in database problem determination and monitoring using various utilities like db2top and db2pd.

Strong understanding of LDAP.

Proficient in generating shell scripts for various kinds of administration tasks (Reorg, Runstats and Backups etc).

Broad working knowledge of ETL Ascential Data stage and Informatica.

Strong working experience with SOX/compliance environments.

Backup, Recovery and Cloning of databases using RMANalso profound in using the new oracle 11g features in these utilities.

Excellent experience inperformance tuning using STATSPACK, AWR, ADDM, EXPLAIN PLAN, SQL TRACE, and TKPROF.

Hands on Experience in upgradation ( 9i, 10g to 11g) and Migration of Database by applying patches (CPU, PSU, Interim Patches) using OPatch utility and PatchSet using Universal Installer.

Proficient in using Flashback Technology, Log Miner, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM).

Good Exposure in translating business requirements into creation of database objects: tables, indexes, constraints, packages, Triggers, stored procedures and functions using Oracle tools.

Expertise in Data Modeling, Logical and Physical Database design using ERWIN.

Good experience in resolving the issues related to installation, upgrades and patches.

Excellent Troubleshooting skills in OS level and Database level

Proficient in SQL, PL/SQL, Shell Scripting.

Excellent experience in providing 24x7 on-call support.

Good Experience in Relational Database design and architecture for OLTP and OLAP

Experience in working with OLTP, Data warehousing environments and VLDB’s.

Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB).

Experience in Data Compression, table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM

Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB).

Excellent interpersonal skills, team player, aggressive, hardworking and result oriented.

Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectation.

Technical Skills

Operating Systems

HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, 5.3

Red Hat Linux RHEL 3.x, 4.x, 5.x, 6.x Unix and Solaris, IBM AIX 5.X, 6.X.

RDBMS

DB2DBA, Oracle 10g/11g, Oracle RAC 10g/11g, MS Access, SQL Server

Languages

SQL, PL/SQL, UNIX Shell Scripting, Java Script, C, C++, JAVA

Tools

DB2 Client, IBM Utilities, DB2 Connect, Power Designer, DB2 Data studio, SQL*Plus, TOAD, Oracle Workflow Builder 2.6 Testing Tools, FTP Tool, ERWIN Tool,

Database Modeling

Erwin 4.0

Tuning tool

IBM Data Studio, SQL Toad, Optim Performance Manager(OPM), TKPROF, Explain plan, AWR, ADDM

Storage technologies:

NAS, SAN, QFS, Replication manager (RM), Tape Library

Utilities (Oracle):

SQL*LOADER, IMPORT & EXPORT, Data pump, STATSPACK, EXPLAIN PLAN, TKPROF, RMAN, OEM, Data guard, ASM, Golden Gate, CRS

Education

Bachelor of Technology, Jawaharlal Nehru Technological University - Hyderabad, India

Professional Experience

US Dept. of Labor, Washington DC Jul 2015 to PresentDB2 UDB DBA

Responsibilities:

Created and maintained Instances and databases for various FX/Equities trading applications.

Designed, created and supported 24+ TB Accounts and Balance (APB) data warehouse.

Extensively worked on db2 data compression and range partitioning in V9.

Extensively worked on integration of Barclay systems with Lehman’s.

Worked and analyzed the requirements for Barclay’s security and implemented LBAC.

Extensively worked in capacity monitoring, short term and long term capacity planning.

Tuned Complex SQL Queries to improve the overall performance of the database.

Extensively involved in refreshing production databases to stage for application testing.

Implemented required security controls to meet audit requirements.

Extensively worked with MDC’s, MQT’s and Replicated MQT’s.

Tuned DB & DBM configuration parameters and DB2 registry variables.

Extensively worked on Q-rep, SQL-rep and SYBASE repserver to replicate complicated database systems across the world.

Worked with db2gov for database management and QP for load handling.

Developed database monitoring and tuning strategies.

Created Backup and Recovery strategies to reduce the backup time.

Designed and implement backup and disaster recovery strategies.

Extensively worked on SRDF DR testing.

Tuned Complex SQL Queries to improve the overall performance of the database.

Implemented required security controls to meet audit requirements.

Tuned DB & DBM configuration parameters and DB2 registry variables.

Developed database monitoring and tuning strategies.

Created Backup and Recovery strategies to reduce the backup time.

Designed and implement backup and disaster recovery strategies.

Analyzed the existing DB2 UDB application programs and tuned SQL queries using Explain and db2advis.

Standardized and documented the naming conventions for file systems, instances for any new DB2 UDB projects.

Intensively involved in taking snapshots for locks, databases, applications and tuning database configuration parameters.

Generated UNIX scripts for Backup & Recovery of the databases.

Developed Stored Procedures, functions and database triggers.

Mentored new comers with the current database architecture and setup.

Provided 24/7 on-call support for production database.

Environment:DB2 UDB 8.2, 9.1 and 8.2, AIX 5.3, Solaris, SYBASE 12.5/15.x 10, LINUX, Q-rep,SQL-rep, Control-M, Command Center, Control Center, Query Patroller, DB2GOV, HPU

Bank ofAmerica, Charlotte, NCApr 2013 to Jun 2015

DB2 UDB DBA

Responsibilities:

Designed logical and physical databases and database objects for DB2 UDB on Development, Test and Production environments.

Involved in HADR set up. Developed SOPs for database backup and recovery strategy and Disaster recovery strategy.

Wrote several scripts to monitor and resolve any issues related to the input files for the 24/7 loads

Performed database system performance tuning by using Snapshot, Event Monitor, and

OS commands (vmstat, and iostat) and updating DB and DBM configuration parameters.

Used db2look, and import/export utilities to move structure and data between databases.

Performed SQL statement performance tuning by using Explain Plain, db2exfmt, and db2expln tools, and running the reorgchk, reorg, runstats and db2rbind commands

Implemented High Availability Disaster Recovery (HADR) on PROD and QA DB system.

Strong understanding of database shared memory parameters and tuning memory parameters in Db and dbmcfg.

Coordinating with the core development team for coding static PL/SQL stored procedures. Also coordinated with application team for SQL Optimization, SQL Analysis and Streamlining. Has experience working and analyzing with SQL Visual Explains output.

Maintained Shell Scripts for Monitoring Databases.

User creation and providing necessary Roles, Privileges and quota as per the requirements

Wrote shell scripts in Unix (AIX/Solaris/HP) with a good understanding of UNIX servers and architecture

Created snapshot monitors and event monitors to regularly check the health of the system

Overseeing the daily data feeds and load process and weekly full load of the data, worked with data export, import and load utilities.

Actively involved in figuring out the qualifying problems for IBM PMR, following up with the vendors and the teams involved.

Analyzing buffer pool usage, catalog stats, objects design and providing suggestion to improve the performance as the part of daily activities.

Identifying the root cause for performance bottlenecks and providing the solution in the effective way.

Generated various performance reports like SQL base comparison report etc using OPM tool.

Creation of Maintenance plan, Scheduled Jobs for backups.

Perform AUDIT on the Databases to give users bare minimum privileges on the Database and Database objects.

Involved in writing of SQL queries for posting and retrieving of data from database.

Involved in reducing HWM and free the space and add it to the File System.

Participation in large-scale Data Warehouse development projects and also knowledge in DB2 DPF.

Supported project releases in production and lower environments.

Environment:DB2 EEE Version 9.7/10.1, AIX 6, IBM Utilities, Erwin7.3, Shell Scripting, toad, DB2 data studio, TSM, OPM(Optim Performance Manager).

JP MorganChase, NJJan 2010 to Mar 2013

DB2 UDB DBA

Responsibilities:

24x7 support for Production databases and applications.

Performed online and offline backups for both incremental and delta type on different applications. Performed database recovery using restore and redirected restore from both command center and control center. Also performed crash, version and rollforward recovery.

Perform DB2 installation, configuration and install fixpacks to keep DB2 at most recent level on AIX, LINUX, Solaris servers including in HADR environment.

Set up HADR for the production and performance test environments. Also wrote shell scripts to monitor the HADR synchronizations and connections.

Used Global temporary tables, MQTs to optimize several queries

Monitored several performance tests conducted by the testing team and used self-developed scripts to arrive at the bad performing SQLs.

Creation of Database Objects Tables, Table spaces, Indexes and Storage group

Extensively involved in performance tuning, recommending SQL queries for better performance.

Developed automated scripts using Unix Shell and Perl for performing run stats, reorg, rebind, backup, load, export and other related to database activities

Capacity planning - space management, ongoing maintenance of production and development environments.

Monitor CPU, memory and Disk IO for Database servers.

Efficient in working with IBM by providing them the details to resolve our database problems.

Performance tuning activities to manage database configuration, buffer pool configuration and registry variable configuration.

Automated the backups, Reorgs, Runstats, Space monitoring, monitoring the size of the table spaces, etc.

Established communication from desktop PC's through a server to a DB2 data warehouse using DB2 Connect ODBC and MS Access software.

Produced and analyzed DB2 performance reports PL/SQL Programming.

Cloning of databases from production to development and test.

Performance monitoring and tuning using Explain Plan, STATSPACK, SQL_TRACE, TKPROF, Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM).

SQL, PL/SQL Programming. Developed PL/SQL functions, procedures, packages and triggers.

Performed Database security and Auditing.

Environment: z/OS, DB2 EEE Version 9.5/9.7, AIX 5.x, IBM web sphere 5.1, DB2 connect, TSM.

Contact this candidate