Aishwarya Nallapu
Email: *********.*********@*****.*** Cell: +1-425-***-**** LinkedIn
Professional summary:
Teradata Data Consultant and DBA with 7+ years of experience supporting enterprise Teradata platforms in banking and regulated environments. Strong expertise in Teradata Data Mover, Teradata utilities, SQL-based data analysis, performance optimization, automation, and production support. Proven ability to manage end-to-end data movement, platform governance, upgrades, and incident resolution across on-prem and hybrid cloud environments. Technical Skills:
Databases & Platforms: Teradata (Enterprise DW), MySQL, Hadoop
Teradata Utilities & Data Movement: Data Mover, BTEQ, FastLoad, MultiLoad, TPump, FastExport, TPT
Teradata Features: NOS, QueryGrid, Clearscape Analytics
SQL & Data Analysis: Advanced Teradata SQL, complex joins, analytics functions, ETL/ELT SQL
Linux / Unix: SUSE Linux SLES 10/11/12/15, CPU/memory/disk monitoring, OS-level troubleshooting
Automation & Scripting: Unix/Linux shell scripting, Python for automation, validation, and data checks
Performance Optimization: Query tuning, execution plan analysis, workload management, CPU/memory/I/O optimization
Security & Governance: Role-based access control (RBAC), user/role management, compliance support
Backup, Recovery & DR: BAR, NPARC, DTU migrations, backup/restore operations
Cloud & Hybrid: Teradata operations across on-prem, AWS, Azure; object storage & Hadoop
Scheduling & Ops: Autosys, monitoring, Sev-1/Sev-2 incident response, RCA
Collaboration: Cross-functional work with banking stakeholders, data engineers, infra, automation, and security teams Professional Experience:
Lenora Systems, Redmond, WA Sept 2023 - Present
Senior Teradata Engineer/ DBA
Install, configure, and maintain Teradata database systems, ensuring stable operation across enterprise production environments.
Support Teradata Data Mover and enterprise data movement workflows, enabling reliable data transfers within and across Teradata platforms.
Perform end-to-end data analysis saying trending, data treatment validation, and platform performance analytics to support business and operational decision-making.
Develop and optimize complex Teradata SQL for ETL pipelines, analytics, and reporting in regulated banking environments.
Build and maintain automation solutions using Unix shell scripting and Python to improve data movement reliability and reduce manual intervention.
Monitor platform performance and data quality controls, identifying risks and escalating non-compliance with clear remediation options.
Perform query tuning and workload optimization to ensure predictable performance and system stability.
Manage user access, roles, and security policies in alignment with governance and audit requirements.
Support database upgrades, patching, backup, restore, and disaster recovery readiness.
Collaborate with cross-functional teams to conceptualize solutions, build POCs, and implement scalable automation approaches.
Provide production on-call support, handling Sev-1/Sev-2 incidents and conducting root cause analysis. Teradata, Hyderabad, India Jul 2018 - Aug 2023
Teradata Data Consultant / DBA
Supported large-scale enterprise Teradata platforms for global banking and financial services customers under formal change control.
Executed high-risk Teradata upgrades, SUSE Linux SLES OS migrations, and ecosystem upgrades with minimal service disruption.
Managed Teradata Data Mover, Viewpoint, and platform utilities for controlled data movement and operational visibility.
Performed DTU, NPARC, and BAR migrations, ensuring data integrity and recovery readiness across on-prem, AWS, and Azure environments.
Monitored and troubleshot database and OS-level performance issues, including CPU, memory, I/O, and network utilization.
Applied database patches, performed post-change validation, and ensured production stability.
Conducted capacity planning and space management across Permanent, Spool, and Temporary space in multi-node systems.
Reviewed and troubleshot automation scripts and operational workflows supporting Teradata environments.
Collaborated with Global Technical Support (GTS) and Service Experience Managers to resolve critical production issues.
Provided 24 7 on-call support and maintained detailed change, audit, and operational documentation.
Mentored junior engineers on Teradata administration, data movement, and compliance standards. Key Achievements:
Delivered stable, compliant Teradata database operations by installing, configuring, upgrading, and maintaining enterprise Teradata systems across production environments.
Successfully executed high-risk Teradata upgrades, SUSE Linux OS migrations, and ecosystem changes through disciplined change control, validation, and rollback planning.
Improved system performance and operational stability by tuning complex Teradata SQL, optimizing workloads, and proactively monitoring CPU, memory, and I/O utilization.
Strengthened data protection, security, and recovery readiness through effective user/role management, space and capacity planning, and validated backup and disaster recovery procedures. Education:
Bhoj Reddy Engineering College for Women (JNTUH), Telangana, India June 2014 - April 2018 Bachelor of Technology in Information Technology