Teradata & Snowflake DBA Specialist

ESWAR KUMAR REDDY V

Teradata & Snowflake Developer

Mobile:303-***-****

Email Id: **********@*****.***

PROFESSIONAL SUMMARY:

•I have 6+ years of experience in Teradata and Snowflake Database Administration, analyzing clients' business needs, developing effective and efficient solutions, and ensuring client deliverables within committed deadlines.

•Expertise in Teradata tools & utilities like SQL Assistant, Teradata Administrator, Teradata Workload analyzer, Teradata Index Wizard, Viewpoint, BTEQ, Fastload, Mload, Backup and Recovery Tools

•Advanced expertise in Teradata DBA activities like database maintenance activities, Teradata user and database creation/maintenance, Space Management, Backups, Refreshes, and Monitoring using Viewpoint.

•Excellent interpersonal communication skills with the ability to manage multiple projects and meet deadlines.

•Worked in the domain of healthcare services.

•Having in-depth knowledge of Teradata Architecture.

•Worked on the Production system for various DBA activities, experience in Production DBA activities. Hands-on exposure to the primary technology/tools of Teradata are BTEQ, SQL Assistant, Teradata Administrator, Viewpoint, Ferret, and Database console utilities.

•Knowing how to define and implement critical Workload Management.

•Performing monthly Audit checks for CPU consumption daily/hourly, unwanted stats, missing stats,, duplicate objects, unused objects, skewed data tables, invalid views, views with no locking row for access clause, etc. Creation of user, databases, roles, profiles, and space management, Access rights.

•Monitoring database performance or resource crunch alert and taking appropriate action on priority.

•Collecting statistics and determining which needed statistics to be collected.

•Troubleshooting 1st level of troubleshooting all the viewpoint issues and setting up viewpoint alerts as per our requirements.

•Having hands-on experience to Coordinate with CSR, GSC, Client batch and production team during Adhoc/scheduled outages of the systems.

•Administered and optimized Teradata and Snowflake database environments, ensuring high performance and availability for production systems.

•Utilized Teradata tools such as SQL Assistant, Viewpoint, Teradata Administrator, and BTEQ for database monitoring, space management, backups, and troubleshooting.

•Performed monthly database audits, analyzing CPU consumption, missing stats, duplicate objects, skewed data tables, invalid views, and other performance-related issues.

•Managed user access, database creation, role and profile configurations, and space management to ensure smooth database operations.

•Expertly managed DB2 LUW installations and version upgrades on Windows, ensuring smooth transitions and minimal disruption to business operations.

•Automated and monitored database maintenance tasks, including backups, restores, RUNSTATS, and REORG, using PowerShell scripting and scheduling tools.

•Configured and maintained High Availability Disaster Recovery (HADR) setups for DB2 databases to ensure continuous availability and rapid recovery.

•Provided proactive troubleshooting and resolution for complex database issues arising from upgrades, configuration changes, and performance bottlenecks.

•Collaborated with application development teams and used change management tools like ServiceNow to support database changes and maintain compliance with IT standards.

•

•Coordinated with cross-functional teams (onsite/offsite) and vendors (CSR, GSC, Teradata) during scheduled and unscheduled system outages, ensuring minimal downtime.

•Led production DBA activities, including system health checks, backup and recovery tasks, and troubleshooting production job failures due to space and spool space issues.

•Conducted critical system audits, addressing space-related requests, and ensuring data integrity for QA testing and production environments.

•Teradata can be integrated with Hadoop using Apache Sqoop for data transfer. Sqoop allows the importing of data from Teradata into Hadoop (HDFS, Hive) and vice versa.

•Use Teradata Parallel Transporter (TPT) or Hadoop connectors to enable high-speed, parallel data transfer between Teradata and Hadoop clusters.

•Collaborated with Teradata vendor and DW support teams to resolve issues and implement patch upgrades, health checks, and disk array maintenance.

•Assisted in OS upgrades, performing critical database tasks, and addressing disk array failures and system performance issues.

•Ensured proper user ID management and deletion for auditing purposes, maintaining compliance with security standards.

•Addressing Access requests.

•Successfully led multiple database optimization projects, improving system performance and reducing resource crunches.

•Contributed to seamless OS upgrades and database patching in a production environment, ensuring minimal impact on operations.

•Improved database monitoring and alerting processes by fine-tuning Viewpoint and resource usage metrics.

•Co-ordinating with Teradata Vendor and DW Support during Planned and unplanned Teradata Outages.

•Co-ordinating with OPS and Teradata for providing site access to Teradata for Disk array failures, Health checks, Patch upgrades and other Maintenance activities.

•DBC Housekeeping. Purge history dbc data on dbc_hist or PDCRINFO databases by taking TAPE BACKUP

TECHNICAL SKILLS

•Databases: Teradata, Snowflake, SQL Server, Oracle

•Cloud Platforms: Google Cloud Platform (BigQuery, Compute Engine, IAM, Cloud Storage, Pub/Sub), AWS (Snowflake, Aurora)

•Backup & Recovery: Veritas NetBackup, Arcmain, IBM Tapes, Data Domain

•Performance Tuning & Monitoring: Teradata Viewpoint, Query Optimization, Spool Management, DBQL Auditing

•ETL & Utilities: BTEQ, TPT, FastLoad, MultiLoad, DataStage, SQL Assistant

•Data Management: Database Creation, User/Role Management, Security & Access Control, Multi-Value Compression, Disk Space Optimization

•System Administration: TASM Configuration, Resource Management, Teradata DBA Health Checks

•Automation: Scripted Data Refresh & Copy, Task Automation (Shell, Python, BTEQ)

•Service & Incident Management: ServiceNow, SM7, Axis, DASH, Global Support Center Coordination

Project Experience –(2023-Till Date)

Project Name : EDW Project

Client : Elevance Health, USA

Technology : Teradata Developer &Snowflake Admin

Technical skillset : Teradata SQL Assistant, Wallet, STUDIO, FastLoad, TPT, MLoad, Tpump, BTEQ, JDBC, ODBC .

Project Description:

Elevance Health provider of health insurance in the United States. It is the largest for-profit managed healthcare company in the Blue Cross Blue Shield Association. The company operates as Elevance Blue Cross in California, where it has about 800,000 customers and is the largest health insurance company.

TD Responsibilities:

•Led end-to-end migration of Teradata databases to Snowflake on AWS Cloud, ensuring seamless transition and minimal downtime across DEV, QA, and PROD environments.

• Administered and supported Teradata PROD/DEV/QA systems, performing query optimization, workload management, and backup/recovery operations.

• Managed GCP administration, including IAM roles/policies, monitoring, and resource optimization to ensure compliance with cloud best practices.

• Designed and optimized BigQuery datasets, partitioning, and clustering strategies to improve query performance and cost efficiency.

• Automated DBA tasks using BTEQ, TPT, and Shell scripting, reducing downtime and manual workload.

• Led Teradata-to-GCP migration initiatives, including schema validation, workload optimization, and hybrid analytics solutions.

•Coordinated cross-functional teams of DBAs, data engineers, and BI analysts to deliver data platform modernization milestones on time.

•Automated ETL workflows with Python scripts for Teradata Snowflake migration and AWS S3 integration.

•Developed Python-based audit and monitoring scripts for space utilization, performance reporting, and error handling.

•Created Python scripts for data quality checks, schema validation, and pipeline testing.

•Integrated Teradata utilities (BTEQ, TPT) with Python for dynamic job orchestration and error logging.

•Leveraged Pandas/NumPy for data analysis and transformation on large-scale datasets.

•Automated backup/recovery validation with Python integrated into Veritas NetBackup and BAR processes.

• Developed documentation and stakeholder communication plans to ensure transparency and alignment with business goals.

•Provided 24/7 production support, monitoring query response times, space utilization, and system health to meet SLAs.

•Implemented best practices, automation frameworks, and new tools to drive operational excellence and continuous improvement.

•Implemented parallel processing in Python to accelerate bulk data validation and log parsing for production jobs.

•Built Python wrappers around Teradata TPT/BTEQ utilities to dynamically generate scripts, handle exceptions, and retry failed loads.

•Automated service requests and ticketing workflows by integrating Python scripts with ServiceNow API for job status and alerts.

•Used SQLAlchemy and pyodbc to connect Python with multiple RDBMS (Teradata, SQL Server, Oracle) for data extraction and transformation.

•Created custom monitoring dashboards by integrating Python with libraries like Matplotlib/Seaborn for job success rates, query performance, and resource utilization.

• Wrote Python test harnesses for validating ETL transformations, ensuring compliance with healthcare domain rules and HIPAA standards.

•Monitored Teradata jobs using Viewpoint, and debugged issues by creating and running JCL, BTEQ, FastLoad, MLoad, and FastExport scripts.

•Resolved high-priority tickets (P1 issues) related to ETL failures, TASM errors, and long-running queries using ServiceNow ticketing tool.

•Generated daily, weekly, and monthly reports for stakeholders and management.

•Supported Dev/Test teams by reviewing and assisting with code changes and issues, ensuring smooth application integration.

•Led the creation and management of physical database objects (tables, views, indexes, macros, procedures) and optimized scripts for better performance.

•Administered backup and restore activities using Veritas NetBackup and TARA GUI, ensuring data availability and recovery readiness.

•Coordinated with DevOps teams to streamline automation processes, reducing manual interventions and improving operational efficiency.

•Conducted weekly team meetings to discuss system health, issues, and best practices for continuous improvement in Teradata and Snowflake environments.

•Led the creation and management of physical database objects (tables, views, indexes, macros, procedures) and optimized BTEQ/FLOAD/MLOAD scripts for better performance.

•Administered backup and restore activities using Veritas NetBackup and TARA GUI, ensuring data availability and recovery readiness.

•Worked closely with development and test teams, providing assistance in code changes and issues, and contributing to system enhancements.

•Coordinated with DevOps teams to streamline automation processes, reducing manual interventions and improving operational efficiency.

•Played a key role in Teradata upgrades, system maintenance, performance optimization, and backup and restore (BAR) activities, ensuring smooth system transitions.

•Conducted performance tuning of high CPU-impact queries, provided recommendations for structural changes, and suggested best practices to improve overall system performance.

•Monitored Teradata space usage, transferred space to critical production databases, and ensured proper management of database resources.

•Performance tuning recommendations were provided to multiple operational counterparts which have helped save Billions of AMP CPU, I/O and Hundreds of Hours, disk space and in turn improve the overall system performance.

•Checking Blocks, CPU and Space Alert on Teradata Viewpoints.

•Checking Alert locks on BAR jobs – Arcmin utility.

•Managing CR, PM and IM through Service management process tools like SM7/Axis/DASH.

•Review and Approve DBA Tasks based on Standards of DBA Checklist.

•Provide requested information on Teradata to solution architect on Teradata system based on Request.

•Monitoring Teradata Space and Transfer space to Critical production databases.

•Implementing DBA Task as requested from dev/support through CM process.

•Monitoring Data movement from DBC to DBC_HIST (PDCR).

•Weekly Team Meeting. Discussion on Teradata, BAR related issue and steps to overcome it.

•Analyze majorly high CPU impacted queries and suggest users on the best practice to be followed.

Project Experience 2019 to 2023)

Project Name : EDW Project

Client : Anthem, USA

Technology : Teradata Developer &Snowflake Admin

Technical skillset: Teradata SQL Assistant, Wallet, STUDIO, Fast Load, TPT, MLoad, Tpump, BTEQ, JDBC, ODBC .

Project Description:

Our client is the one of the largest health insurance providers in USA and other states. It is the largest for-profit managed health care company in the blue cross blue shield association where our client serving 40 million members.

TD Responsibilities:

•Worked extensively on Teradata production systems, handling critical DBA activities, including performance monitoring, backup management, and query tuning using primary Teradata tools like BTEQ, SQL Assistant, Teradata Administrator, Viewpoint, Ferret, and Database console utilities.

•Managed user accounts, ensuring appropriate security measures were in place, and granted/revoked object rights and system rights on databases, users, and roles.

•Oversaw daily and weekly backups, implementing a backup process using ARC utility and ensuring reliable data recovery processes.

•Collaborated with BI Production Support teams to resolve database issues and provided proactive troubleshooting for long-running queries, space management, and performance optimization.

•Implemented TASM settings based on system load, and analyzed system performance through Viewpoint to ensure optimal database functionality.

•Conducted database audits and reviewed SQL code/ETL processes before deployment, providing approvals for production releases.

•Implemented compression techniques on tables to optimize disk space usage and recommended structural changes to resolve skewed table issues.

•Managed and performed backups using IBM tapes and Data Domain to ensure data availability and disaster recovery.

•Coordinated with GSC, client batch, and production teams during scheduled and unscheduled outages, minimizing downtime.

•Performed root cause analysis and worked with the team to fix daily ETL and report job failures, ensuring minimal business disruption.

•Proactively identified and tuned high-resource-consuming ETLs to optimize performance and resource utilization.

•Led the team in managing incidents, maintaining alert setups, and providing weekly status reports on system health and performance.

•Worked with SDLC migration activities, ensuring smooth deployment and proper migration of database objects across environments.

•Successfully optimized performance and resolved database space issues by fine-tuning queries and recommending compression techniques, resulting in improved system performance and reduced disk usage.

•Reduced downtime and optimized system performance by effectively managing backups and proactively resolving ETL job failures.

•Played a key role in maintaining high availability and performance for critical production environments through effective performance monitoring and troubleshooting.

•Working with GSC, client batch and production team during adhoc/scheduled outages of system.

•Collecting statistics and determining which needed statistics to be collected.

•Performed system health checks, space management, and query performance tuning for high-volume Teradata environments.

• Supported business-critical ETL pipelines using Teradata utilities (TPT, FastLoad, MultiLoad).

• Implemented backup and recovery strategies (BAR, TARA, NetBackup), ensuring data integrity and availability.

• Partnered with application teams to troubleshoot and resolve production issues, minimizing downtime.

• Collaborated on data warehouse modernization projects, integrating Teradata with Snowflake on AWS for cloud adoption.

•and taking appropriate action on priority.

•Used to take backups on IBM tapes and Data domain.

•SQL Code/ETL review before deploying into any environment and Providing approvals

•Working on SDLC migration activities

•Providing application DBA support to all critical application

•Performance monitoring, investigating of long running queries.

Educational Qualifications:

B.TECH (Computer Science): GODAVARI INSTITUTEOF ENGINEERING ANDTECHNOLOGY.

Contact this candidate