DBA

PRAVEEN KUMAR YALAVARTHI

IT professional, targeting assignments in Database Administration, Project Management and Design & Architecture with reputed organization, preferably in Bengaluru

Gained experience in complete database design, data mapping & conversion and data load, and creating packages for data migration & transformation

PROFILE SUMMARY

Technocrat with over 8 years of experience; expertise in Database Administration activities encompassing database planning, design, installation, configuration, disaster recovery planning, back up & recovery, configuration of stand by databases for ensuring business continuity, cloning, patch management / release

Skilled in development of logical & physical database designs, capacity planning, normalization, optimizing database design & fine tuning queries to scale up database and application performance

Drove project management including execution, design, scope, estimation, resource administration and project completion within specified parameters; resourceful in upgrade/ migration of several instances and databases

Exceptional in installation, configuration, administration, backup & recovery, performance tuning of databases, SQL code review & approval, applying database patches, upgradation, migrations, database cloning, user management and troubleshooting on windows platforms

Resourceful in implementing backups, complete recovery, monitoring procedures, ongoing support & performance tuning; controlling migration of database changes, reference data & menu changes through development life cycle

Successfully analysed information system needs, evaluated end-user requirements, designed custom solutions and troubleshot complex information systems

People-friendly, collaborative & approachable with strong interpersonal, analytical and problem solving skills

EMPLOYMENT DETAILS

Since Feb’19: LOCUZ Pvt. Ltd., Hyderabad as Sr. Database Admin

Key Result Areas:

Liaising with Client, Development & Implementation Teams to support their database requirements

Administering:

oDatabase architecture, administration, backup, restoration & recovery, database documentation and usage reports

oOracle database installation & configuration, upgradation & patching

oMission critical database migration with minimal downtime and user impact

Replicating data using materialized views, data guard/active data guard

Facilitating database backup, restoration & recovery and creating duplicate database & cloning

Developing and managing standby / primary databases

Reviewing code and managing performance tuning and query optimization/re-writings

Mapping client requirements and providing customized software solutions involving finalization of product specifications, selection of appropriate techniques for internal IT projects and coordinating with vendor for product development

Verifying change requests and defects; tracking and communicating test plans, test results and unresolved problems

Formulating backups, restores and recovery models; working on Database (DB) roll-back using backups and transaction logs to a specific point in time

Building automation scripts for Database (DB) maintenance and business processes

Supporting the development & test teams by ensuring that the relevant test databases reflected the latest changes in the product, creating SQL queries for views, data extraction and migration

Achieving nil unplanned downtime by proactively managing the production database; ensuring no SLAs are breached as a result of providing quick resolution to incidents

Providing support for critical databases; performing periodic production updates/ maintenance updates in conformance with change-management policies and procedures

Highlights:

Led the design of corporate-wide architecture for database servers as part of TracFone US$ 150 Million project in Miami & Atlanta with 4500 servers.

Managed a diverse Database Administration (DBA) team of 12 personnel with resources in multiple locations

Performed SQL tuning for the statistics Report to reduce execution time

Redesigned multiple processes to speed up data retrieval and streamline error handling, resulting in 70% reduction of processing time

Performed database tuning and performance enhancement of the system during peak loads

Developed SSIS package to migrate data during upgrade process, leading to reduction in migration time

PREVIOUS EXPERIENCE

May’17-Aug’18: Tech Mahindra Pvt. Ltd., Hyderabad as Tech Lead

Jan’14-Apr’17: HCL Technologies Pvt. Ltd., Bengaluru as System Analyst

Jul’11-Dec’13: Toyota Kirloskar Motors Pvt. Ltd., Bengaluru as System Database Administrator

CERTIFICATIONS

IBM Certified DB2 V9 Database Associate for LUW-730

IBM Certified DB2 V9 Database Associate for LUW-731

IBM Certified DB2 V9 Database Associate for LUW-736

Oracle Certified Associate

ITIL V3 Foundation Certificate in IT Service Management

TECHNICAL SKILLS

Operating Systems: IBM AIX, Sun Solaris, Linux, Unix, HPUX, z/OS, AS400, Windows Servers, Windows 7

Databases: DB2 v.10.x, v.11.x (DSM); Oracle 11g, 12c (OEM), EBS, BRM, APEX; SQL Server, Big data – Hadoop, NoSQL, Cassandra, Mongo, Netezza, connx, Informix, MySQL, Postgres

Languages: SQL, JavaScript, Shell Scripting, Perl Scripting, AWK, SED, VB Script

Other Domains &

Web Technologies: IBM TWS, IBM WAS, IBM TSM, IBM ITM, IBM MQ, IBM Data Mirror, IBM Optim, IBM Data Stage, IBM STORAGE(5,8k), CA Autosys, Informatica V 8.1/7.1, Data Science, Robotics, Machine learning, Automation

ACADEMIC DETAILS

MCA from Bangalore University with 75% in 2010

BSC ( computers ) from Nagarjuna University with 65% in 2007

(Please refer annexure for projects)

ANNEXURE

Projects Managed

Project 1:

Title: TracOne

Company: LOCUZ Pvt. Ltd., Hyderabad

Client: TracFone Wireless, Inc., USA

Period: Since Feb’19

Platform: Aix, Solaris, Linux and Windows

RDBMS: DB2 UDB V10.x and V11.x on LUW

Role: Sr. Database Admin

Key Result Areas:

Monitoring the table spaces, tables and its utilization by querying the system tables

Managing database backup & recovery and performing Quiesce, Reorg, runstats and db2look

Working with various data movement utilities like load, export, import and db2move for timely movement of data

Leading Table Space management, adding containers to table space and taking the table space backups

Tuning memory parameters like SSHMAX and SSHMIN for proper use of the RAM

Creating primary objects like (tables, indexes, views & triggers) and granting/revoking permissions on database objects

Scheduling Cron jobs as per requirements and for the backups of the database

Implementing triggers for providing permanent solution for the performance issues in the database and creating views to reduce the burden & designing MQTs

Rendering production support for fixing bugs based on the raised tickets as daily activity

Creating wrappers & nickname to access the data from remote databases

Resolving queries as per the client requirements and assisting Developers in database and application tuning for optimal performance

Loading and refreshing non-production database for application testing

Performing data migration from one subsystem to another

Conducting day-to-day calculation of Index Read Efficiency and supporting to increase index reads in all type of queries

Project 2:

Title: Advisory Asset & Goal based Wealth Management

Organization: Tech Mahindra Pvt. Ltd., Hyderabad

Client: Morgan Stanley –NYC-USA

Period: May’17-Aug’18

Platform: Linux and Windows

RDBMS: DB2 UDB V10.x and V11.x on LUW

Role: Tech Lead

Key Result Areas:

Installed and upgraded fix packs DB2 server software and related products

Designed, implemented and administered DB2 UDB for development, test and production environments

Troubleshot day-to-day problems encountered on production, development and test database environment.

Migrated Development (DEV), Test (UAT) and production (PROD) databases from DB2 10.1 FP 5 to DB2 10.5 FP 3

Developed and implemented standards to create databases and various database objects

Took online & offline backups and wrote Shell scripts and scheduled them

Requested space for file system and raw-devices to Linux group

Managed job scheduling daily based for Backup, Reorgs and runstats scripts

Catalogued multiple instances and configured connectivity to databases from remote clients

Managed database loading, migrating and maintaining data with Load, Export, Import, db2look, Replication

Involved in application support, design, user administration, security, performance tuning, optimization and backup/recovery

Dropped and added users, logins, aliases & groups to databases and granted/revoked permissions on Database objects

Supported Developers in database and application tuning for optimal performance

Provided queries as per the client requirements and coordinated with client to understand their requirements

Project 3:

Title: DBI (Direct Brands Inc.)

Company: HCL Technologies, Bangalore

Client: DBI -USA

Period: Jan’14-Apr’17

Platform: AIX, Sun Solaris and Windows

RDBMS: DB2 UDB V8.x, V9.5 and v9.7on LUW

Role: DB2 Database Administrator

Key Result Areas:

Led implementation, administration and troubleshooting of DB2 V9.7/9.5/9.1/8.2 LUW databases

Migrated DB2 LUW Data Servers, DB2 Connect Servers, and DB2 Data Server Clients from V8.2/8.1 to V9.7/9.5/9.1

Managed logical design and physical design of DB2 LUW databases

Performed performance tuning of DB2 LUW databases

Built high availability DB2 clusters using HADR, HACMP and VCS

Maintained db2 databases using runstats, reorgchk, reorg and rebind

Tuned slow running queries using DB2 Explain and DB2ADVIS tools

Used Shell scripting to automate various database administration tasks like backups, restores, runstats, reorgs, reorgchk and rebind

Configured communication between DB2 data servers and DB2 clients

Created partitions for better performance and assigned instance level authorities, database level authorities, object privileges to users and groups as required

Opened PMR with IBM to resolve critical issues by providing necessary information using DB2Support utility

Performed:

oRedirect Restore of the databases involved in db2 version upgrade

oOffline backups, online backups of db2 servers when required during db2 migrations, Operating system migrations and Storage migrations

Directed administration, monitoring and tuning of DB2 databases

Monitored db2 database servers using Snapshots & Event monitors

Implemented HADR for the newly migrated databases on V9.5 for high availability and business continuity

Conducted failover testing/ Switch over testing of new clusters

Maintained db2 databases using runstats, reorgchk, reorg, rebind

Managed performance tuning of slow running queries using db2 explain and db2advis tools

Assigned instance level authorities, database level authorities, object privileges to users/groups as required by the system

Tuned dbm & db cfg parameters to obtain optimum performance for the applications

Configured communication between DB2 Data Servers and its clients

Created SMS, DMS and automatic storage path tablespaces

Increased size of filesystems, DMS tablespace container sizes and added paths to automatic storage as per system requirement

Troubleshooting db2 database server issues by analysing db2diag.log, db2pd, errpt, lsps, df, ps, topas, vmstat, iostat, netstat

Project 4:

Title: EFC & EBS and G-Topas Systems

Organization: Toyota Kirloskar Motors Pvt. Ltd, Bangalore

Client: Toyota Motor Corporation (Japan)

Period: Jul’11-Dec’13

Platform: AIX, Sun Solaris and Windows

RDBMS: DB2 UDB V8.x, V9.5 and v9.7 on LUW

Role: DB2 Database Administrator

Key Result Areas:

Created instances & databases and involved in SA&D process of new servers

Verified errors in db2diag.Log and took online /offline backup of database, table space to disk & TSM

Managed backups & archived Logs for various types of recovery techniques

Led restoration of the database and built high availability DB2 clusters using HADR, HACMP and VCS

Takeover HADR in required situations and managed table space & file systems space issues

Extended table space and created partitions for better performance

Monitored backups, file system space and the batch jobs

Granted/revoked various authorizations to different users/groups

Configured database backups to Disk & TSM and automated Backup, reorgs, runstats and maintenance tasks

Recovered the database during database crash and whenever in required situations

Used db2 data move utilities like export, import and load

Installed latest fix packs on the servers and involved in DB2 Version Migration

Addressed locking & logging issues and worked with db2 tools such as db2pd, db2look, db2move & db2support as & when required

Project 5:

Title: ECRB and INFRA Systems

Organization: Toyota Kirloskar Motors Pvt. Ltd., Bangalore

Client: Toyota Motor Corporation (Japan)

Period: Jul’11-Dec’13

Platform: AIX, Sun Solaris and Windows

RDBMS: DB2 UDB V8.x, V9.1 and v9.5on LUW

Role: DB2 Database Administrator

Key Result Areas:

Performed database health checking as per the security standards

Verified errors in db2diag.Log using db2diag tool and took online /offline backup of database

Restored database and created buffer pools, table spaces, tables using Command/Control Center

Built high availability DB2 clusters using HADR, HACMP and VCS

Managed table space and file systems space issues and extended table space

Granted/revoked various authorizations to different users/groups

Created partitions for better performance and performed reorgs, runstats and maintenance tasks

Recovered the database during database crash and whenever in required situations

Supervised databases by using snapshots, event monitors

Used db2 data move utilities like export, import and load

Installed latest fix packs on the servers and monitored databases by using snapshots & event monitors

Maintained 24*7 production environment

E-Mail: *******.***.***@*****.*** Phone: +91-636*******

Photo

Areas of Expertise

Database Administration

Project Management

Design & Architecture

Technical Support

Disaster Recovery

Troubleshooting & Tracking Logs

Performance Tuning

Optimization/Enhancement

Requirement Gathering

Stakeholder Management

Client Relationship Mgt.

Date of Birth: 6th June 1986 Languages Known: English, Hindi, Telugu, Kannada and Tamil

Passport Number: S2650353

Address: Thanisandra, Bangalore - 560045

Contact this candidate