Teradata & Data Warehouse Architect & DBA Leader
Resume:
Resume
Name: Varun Vats
Contact No: 929-***-****
Email ID: ***********@*****.***
Charlotte, NC
A Tech-savvy, results-driven, team-spirited, and performance-driven Information Technology professional having expertise in major Database/Data Warehouse, Analytical platforms like TERADATA, SNOWFLAKE, ORACLE. Background includes nearly Twenty years of experience in End to End (Online Transaction Processing)OLTP/(Online Analytical Processing)OLAP Database Applications handling as an Architect, Application, Performance, Operations, Systems & Migration DBA cloud & on-prem. Years of experience in Teradata TPT ETL,ELT development.15 plus years’ experience in leading teams technically in an ITIL, Agile, DevOps framework. Understands client business and broad IT exposure & experience in various business industries like Telecommunication, Retail, Finance & Banking, Media, IT. CORE COMPETENCIES
Database Security Data Architecture Data Management Data Integration Data Analysis DatabaseOptimization Best Practices Implementation Installation and Configuration Database Resources Management Continue Process Improvement Database Capacity Management Risk Assessment Backups Analysis Business Requirements Evaluation Data Modeling Database Support Capacity Framework Design ApplicationWorkloadManagement Database Integrity and Security Database Architect DataWarehouse Architect PROFESSIONAL EXPERIENCE SUMMARY
Randstad Digital, LLC
Duration: from June-2023 – Current
Current Designation: Teradata Database Administrator Client- Bank of America
Job Roles: -
DatabaseMigration across Teradata to Teradata systems.
BCM configuration and setup.
Tunings Database queries on Enterprise Datawarehouse for optimum performance.
DatabaseMonthly heat maps review on reliability and optimization.
BYOM- Bring your own model ML/AL engine installation and configuration.
Modify and maintain database resources, throughput and workload management and providing solutions based on performance hit areas.
Application workload management for the proper database workload settings using Teradata Active SystemManagement (TASM).
Architectural Contribution to the design reviews and create design documents.
Query Grid Installation, Configuration and Management.
Contribution to process improvement and Standard Operating Procedures (SOP) for efficiency Improvements.
Teradata Database Performance Improvement expertise.
PerformedDatabase Migrations.
Query Grid Installation, Configuration, extended clustering and Management between Teradata to Teradata and Teradata to Hadoop for testing requirements by applications team.
Raising issues/bugs with Teradata GSO identified during POC.
DataMover TPT to T2T conversion and build performance improvement reporting.
Build & Migrate DSA Full DB & Full Table Jobs to Incremental copy jobs for improved run times & performances, leveraging system to utilize bandwidth for other critical applications.
IVSm and Model Ops installation.
Perform Disaster Recovery, periodic performance enhancements for the Backup & Restore (BAR) solution.
Invest time in Proof of Concepts (POC) to build optimized solutions which helps in system resource savings and helping business application functionalities. Nordstrom Inc
Duration: from June-01-2021 – May-01-2023
Current Designation: Engineer 2
Job Roles: -
Responsible to plan and implement Solutions for Enterprise data Warehouse Applications for Teradata Database in the DevOps Model.
DatabaseMigration across Teradata to Teradata.
Application code review/ SQL-DDL considering Teradata database best practices for performance & optimization before production deployment using gitlab.
Monthly Database optimizationwith database compression techniques.
Tunings Database queries on Enterprise Datawarehouse for optimum performance.
Implementation of password complexity & Quarterly OS password rotation.
DatabaseMonthly heat maps review on reliability and optimization.
Modify and maintain database resources, throughput and workload management and providing solutions based on performance hit areas.
Application workload management for the proper database workload settings using Teradata Active SystemManagement (TASM).
Contribute to design reviews and create design documents.
Query Grid Installation, Configuration and Management.
Contribution to process improvement and Standard Operating Procedures (SOP) for efficiency Improvements.
Teradata Database Performance Improvement expertise.
Teradata code development and automated deployment using Gitlab, CI-CD
Business/Application Continuity Planning, Solutions, support, and design.
Building Tableau dashboards using Teradata as a source.
ETL infrastructure setup for Teradata using Terraform(Infrastructure as code).
PerformedDatabase Migrations.
Developed Semantic Layer MetadataManagement framework using Python.
AWS cloud infrastructure/services management and account review for performance & cost optimization.
TERADATA OPERATIONS
Duration: fromAugust-19-2013 – May-28-2021
Current Designation: PS Consultant (Sr. Lead Database Consultant) Clients - T-Mobile, Procter & Gamble, New York & Co., Major League Baseball(MLB) Job Roles: -
Responsible to plan and implement Solutions for Enterprise data Warehouse Applications for Teradata Database in the DevOps Model.
Migration POC to Snowflake and Snowflake Administration.
DatabaseMigration across cross platforms. Teradata to Teradata and Netezza to Teradata.
Application code review/ SQL-DDL considering Teradata database best practices for performance & optimization before production deployment.
Involved in plan, Assess, and develop Database capacitymanagement and forecasting.
Design and Develop Database Indexes and stats or optimumDB performance.
Vast experience in Teradata Database tools Datamover, DSA, Query Grid, TPT.
Data security with VOLTAGE implementation, SPLUNK and management.
Monthly Database optimizationwith database compression techniques.
Tunings Database queries on Enterprise Datawarehouse for optimum performance.
Demand measure, process measure, quality, Security & Integrity measure of database on business requirements and SLA definitions for Database Batch Jobs/loads.
Analyze database backup strategy and Infrastructure review after monthly backups analysis.
DatabaseMonthly heat maps review on reliability and optimization.
Modify and maintain database resources, throughput and workload management and providing solutions based on performance hit areas.
Application workload management for the proper database workload settings using Teradata Active SystemManagement (TASM).
Leading team on Technologies ELT, Teradata Database, MDM, CIM.
Efficient delivery on Incidents reductions, Problem ticket handling keeping ITIL framework inline.
Capacity Framework design and forecasting for End to End Database PlatformArchitecture.
Client escalations and requirements handling in best possible & efficient way.
Query Grid Installation, Configuration and Management.
Contribution to process improvement and Standard Operating Procedures (SOP) for efficiency Improvements.
Teradata Database Performance& Tuning Improvement expertise.
Application database support on cloud & on prem.
Teradata developer using TPT Load,Export,Stream ETL,ELT development.
Automateddeployment using Gitlab, CI-CD
Business/Application Continuity Planning, Solutions, support, and design.
SOX controller for Teradata systems.
IBM INDIA PVT.LTD.
Duration: fromMay-04-2009 to August-14-2013
Designation: Technical Team lead & Database Administrator. Client: Vodafone Ireland(2 Plus years onsite client experience) Job Roles:
Responsible for planning and designing of high availability solutions for database and its applications.
Involved in design and development of Oracle Database backup, recovery, and reliability tasks.
Responsible for planning and maintenance of oracle database security producers and Integrity.
Designing, development and maintenance of store procedures PL/SQL based on business requirements.
Involved in telecom Application Handling as a Team Lead and Database management Administration.
Responsible for client-oriented Solutions feasibility and Implementation in overall scope of Application. Involved in develop, maintain and design DataModeling of new application requirements.
Presentation to clients on various business requirements and solutions being an environment gatekeeper.
E2e Application environment defects handling, presentation of defects trend & identifying prone areas.
Involved in technical, feasibility & supportability review of new business requirements from database perspective during project phase and submission of reviews to Technical Design Authority-TDA.
Responsible for oracle database performance and tuning activities on database from the application perspective.
Involved in oracle RAC and single instance database administration on UNIX platforms.
Responsible tomonitor and optimize oracle database systemperformance.
Health check and performing housekeeping tasks for Oracle database.
Oracle Database refresh and cloning on Single Instances and RAC.
Involved in designing & performing standard operating procedures.
Responsible to work on Database capacity optimization in linewith new jobs and requirements.
Writing Shell scripts for creating new Jobs for oracle database in UNIX for projects.
Responsible for TIBCO middle-ware Administration, integration with Oracle. MAGNA INFOTECH PVT. LTD.
Duration: October-06-2008 to April-30-2009
Designation: Senior Oracle Database Administrator
Client: Fidelity Investments, Gurgaon, India
Job Roles:
Responsible in managing Oracle 9i and 10g Database on Production, Test Development.
Involved in planning, configuring and monitoring database stats collection job/activities.
Responsible for developing duplicate database creation, cloning for testing purpose.
Oracle Database creation and management systemon Windows, AIX and Solaris platforms.
Maintaining and optimization of database storage structures, database objects.
Routine Health checks and performing housekeeping task for Oracle server.
Schema/User creation and export/import to Test environments.
Preventivemaintenance of backups and enforcing database integrity & security.
Responsible to perform datamodeling, reliability, and query optimization.
Involved in performance monitoring and diagnose of oracle database (AWR AND ADDM).
Responsible for database upgrades fromold version to new versions (8i to 10g, 9i rel2 to 10g).
Oracle Data Guard implementation and Management for high availability solutions.
Responsible in taking RMAN backups, scheduling, and recovery of databases.
Involved in Oracle Data Pump Exports and imports at schema, table, table space levels.
Oracle Real Application Cluster 10G Monitoring and installation of nodes.
Tune Oracle Database Performance by creating appropriate indexes and query tuning.
Download and install oracle patches for routine patch deployment activities BMC SOFTWARE INDIA PVT. LTD
Duration: July-30-2007 to October-03-2008
Designation: Technical Support Analyst
Clients: Major EMEA
Job Roles:
Assisting Clients in troubleshooting issues related to database Backup, Restore and recovery using SQL-BACKTRACK.
Troubleshooting technical issues related to Oracle and SQL Database using BMC PATROL.
Responsible in solving Technical Queries/issues raised by Clients (US, EMEA) for products SQL- BACKTRACK and BMC PATROL using Database like Oracle and SQL server.
Support on technical troubleshooting and managing patrol Reporting having backend oracle 9i and 10g database.
TEKNOMEX SOLUTIONS
Duration: July-01-2004 to July-15-2007
Designation: Senior Technical Associate
Job Roles:
Involved in planning designing maintaining and operation of database as per requirement.
Oracle 9i Database creation on windows for Test and Development Environment for projects release.
Creation of clone of database to restore on Non-Prod environments.
Monitoring alert log file for database errors, support and troubleshooting on production database
Evaluate and creation of Database windows Server Hardwaremanagement.
Database Tablespace management and schema creation in line with database integrity& security guidelines.
Export and import utilities of Oracle database for refresh of Schema and Tables.
Configuration Oracle Database RMAN for Backup of test environment.
Document writing according to the guidelines, policies and standard operating procedures.
Involved in database Backup Scheduling using RMAN utility and time to time review.
Responsible to review the database indexes periodically for index rebuilding activity.
Review of unwanted and obsolete database objects for optimization purpose.
Involved in managing database storage structures with optimization.
Responsible to perform Database stats collection whenever needed.
Responsible in develop and design of IP addressing, Routing Protocols Inter network, access list
& WAN List.
TCP/IP, configuration Routing Protocols, Router, switchwith VLANs system image.
Trouble shooting Routing protocols, TCP/IP, LAN & WLAN, Router, Switch. Education:
o Bachelor of Engineering (Electronics & Telecommunication)-June 2004 – 1stDivision with Distinction
Profession Certifications:
o Snowflake SnowPro Core - Certified
o Teradata Vantage Certified Administrator (16.10) - Certified o Microsoft Certified: Azure Fundamentals - Certified o Teradata Certified Technical Specialist (14.0) - Certified o Horton works Hadoop Certified Administrator - Certified o ITIL v3 Foundation Certified - Certified
o Oracle-9i Certified Professional DBA - Certified o Support Certified Professional, Service Strategies - Certified TECHNICAL & Tool PROFICIENCIES
Teradata SQL, SQL Assistant, Microsoft Office (Excel, PowerPoint), Microsoft Azure, IBM Clear Case, GitLab,CI/CD, MongoDB, Jenkins, Python, Teradata QueryGrid, Datamover, DSA, Query Grid, TPT, DBeaver, Teradata Studio, Windows, Oracle Solaris, SQL-Back Track, Tableau,Oracle RMAN, Teradata Backup Archive & Recovery(BAR), Amazon AWS Cloud, Redshift Database, Linux Unix, Autosys, BMC Patrol Reporting, BMC SQL-Backtrack, Tableau, Hadoop, JIRA,NEXUS,Remedy.
Contact this candidate