Data Engineer

Venkat Talluru Cell: 504-***-**** email: *******@*****.***

Technology professional with extensive experience in capacity planning, design, build and deployment of data marts, enterprise data warehouse. Played key role in data architecture, modelling, extraction, transformation, loading, data security, governance and analytics. Strong track record in standing up data processing platforms with backup, archiving and disaster recovery needs both on-premise and Cloud.

Professional Summary

Over 17 years Hands-on experience in modeling, database environment builds, database administration, production support, disaster recovery and development on AIX, LINUX, Solaris and Windows environments.

Experience in capacity planning, building, configuring Databases and installations, upgrades, performance monitoring/tuning, problem identification and resolution, backup and restores in DB2 LUW and Cassandra.

Experience in designing, implementing and administering data security.

Implemented data archiving solution based on business rules and data access patterns saving storage costs and increasing performance.

Experience in use case reviews and application on-boarding.

Developed knowledge items for database support teams and automated database maintenance activities.

Tool evaluations and proof of concept for new tools.

Experience working with application and infrastructure teams using Agile methodologies and delivering work in sprints.

Experience with enterprise data warehouse, data marts and data lakes.

Experience implementing and enforcing data management security standards, participate in data audit.

Experience in Korn Shell Scripting and python.

Implemented bi-directional active-active replication between multi datacenters to support applications 24/7 with zero downtime using Oracle golden gate.

Experience in setup and automate HADR between primary and secondary databases to ensure High Availability.

Experience in troubleshooting Database and OS performance issues.

Extensive experience in Shell scripting and automation of monitoring and maintenance jobs.

Implemented MDCs, MQTs and experience in developing SQL, PL/SQL, stored procedures and triggers

Coordination skills and Team player with excellent interpersonal, analytical, Oral and written communication skills.

Technical Skills

Databases: DB2 LUW, Mysql, Cassandra

Languages: PL/SQL, Shell Scripting, Perl Scripting, JAVA, C/C++, COBOL

Tools: Erwin, DataStage, TSM, Quest, Toad, Veridata, Control-M, IBM DSM/OPM, CDC, Oracle GoldenGate, Data Studio

Cloud: AWS and Microsoft Azure

Operating Systems: Linux, AIX, Solaris, Windows

Educational Qualifications and Professional Certifications

Master’s in engineering, University of New Orleans

Bachelor’s in Mechanical Engineering, Osmania University, India

IBM Certified Database Administrator for Db2 11.x LUW

IBM Certified Advanced Database Administrator for DB2 9 Linux, Unix and Windows

Professional Experience

Macy’s Technology, Atlanta, GA March 2013 – Till Date

Lead Database specialist

Played key role in database platform builds for Macy’s ecom and marketing. Lead DB2 LUW software upgrades, active-active replication between datacenters, AIX to Linux Migration with zero downtime, Cassandra database migration projects and performance tuning.

Capacity planning, design and build of partition and non-partition databases.

Provided support for application teams from development through production.

Physical modeling, development, implementation, day-to-day administration, monitoring backup jobs, database recovery, performance monitoring and tuning, troubleshooting and Problem resolution.

Gather requirements and perform capacity planning for database storage, work with Storage and Unix teams to carve out file systems for data, logs and backups.

Experience with MDC, MQTs, data compression, Hash and Range partitioning.

Implemented bi-directional active-active replication between multi datacenters to support applications 24/7 with zero downtime.

Created Cassandra cluster nodes and migrated DB2 LUW database to Cassandra.

Setup HADR for databases, backup and recovery of databases.

Experience in Shell scripting to collect OS and database monitoring data and automate maintenance jobs

Developed knowledge items for database support teams and automated database maintenance activities and Mentor new resources on team and provide consultation to application teams.

Cigna Health care, Chattanooga, TN Feb 2007 – March 2013

Sr. Database Engineer

Data modeling, design, implement and support databases for large claim data warehousing environment and other OLTP databases. As Sr. database engineer played key role in separating and standing up data warehouse for claims and preventive care.

Capacity planning, design and build of partition and non-partition databases.

Experience in designing and implementing large partitioned (MPP) databases and create instances, databases and database objects.

Data modeling, development, implementation, day-to-day administration, monitoring backup jobs, database recovery, performance monitoring and tuning, troubleshooting and Problem resolution.

Created optimal physical models in collaboration with metadata analysts, modelers, business analysts, ETL and reporting teams.

Improved response times for Cognos reports through the design of snap shot tables, use of MQTs, MDC, compression and elimination of data skews.

Expertise in data movement using export, import, load and db2move.

Experience in developing SQL, PL/SQL, stored procedures and triggers.

Prepare Backup and recovery strategy and document backup and restore procedures and automated daily maintenance scripts.

Expertise in setting up Federation environment on DB2 LUW for Oracle and DB2 Mainframe databases and created nicknames to access the data across the different servers.

DB2 software installation, upgrades and Fix packs.

IBM, Poughkeepsie, NY July 2005 – Feb 2007

DB2 UDB DBA

As a DB2 UDB DBA helped Conversion of data from legacy systems to DB2 UDB on AIX. Played a major role in supporting external accounts in upgrades and coordinate onsite and off-shore DBAs.

Installed, maintained and administered UDB EEE, DPF and EE databases.

Provided production support for DB2 databases for internal and external IBM accounts.

Installed and migrated the V8.2 instances, applied fix packs and did the post migration steps.

Created and maintained instances, databases, tablespaces, schemas and users on both partitioned and non-partitioned environments.

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

Set up Monitor scripts to page OS and database alerts.

Configured database for optimal performance and developed backup recovery strategies in a partitioned and non-partitioned database.

Responsible for day-to-day administration of database servers and application servers.

Developed System design specifications, Technical design specifications, unit test cases.

Design and development of conversion programs to move data from legacy systems to DB2 UDB on AIX.

Freddie mac, McLean, VA Aug 2003 – Jun 2005

DB2 UDB DBA

As a DB2 UDB DBA helped Conversion of data from legacy systems to DB2 UDB on AIX. Played a major role in supporting external accounts in upgrades and coordinate onsite and off-shore DBAs.

Created and maintaining databases, tablespaces, schemas and users.

Database sizing, tablespaces, indexes, log space design and implementation work.

Database security and audit design, test and implementation.

Set up UDB databases on development, QA and production environments.

Monitoring the data propagator scripts and verifies the log files created by Dprop scripts to ensure the data is replicated on the server by querying the tables.

Running the reorgchk, reorg and runstats utilities.

Implemented shell scripts for dynamic configuration on different servers, performance analysis and to run regular utilities like runstats, reorgchk etc.

Performed V7 to V8 migrations and applying the latest fix packs.

Responsible for maintaining the repository for all the databases (production/dev/QA).

Performed all the necessary administration on AIX and Windows database servers and applied updates and fixes on OS and databases.

Performance monitoring and tuning on a regular basis.

Running the visual explain utility on SQL statements and created explain tables.

Responsible for day-to-day administration of database servers and 24/7 support for the production environment.

Contact this candidate