Professional Summary

• 6+ years of experience working on Administration of Teradata, Performance monitoring/tuning, Teradata RDBMS internals, and Data Warehousing model and concepts.
• Currently working with Amgen Inc. as a Primary Teradata DBA.
• Experience at different client locations across various geographical area. While working with Teradata Corporation, visited various client locations and worked with other DBAs to solve the raised issues/incidents. Through Teradata Corporation worked with Walmart, SBC, Verizon, DELL and other big clients as support personnel to support for upgrades, analyze system performance and stability issues. Worked with Barclays in the role of Teradata DBA in UK.
• Proficient in tools like Teradata Administration, Performance Monitoring/Tuning using tools such as Teradata Manager, Viewpoint, TASM, TD Administrator, TDWM, PMON, DBQL and other TD tools.
• Error handling and trouble shooting of Teradata load/unload utilities like FastLoad, MultiLoad, FastExport, Tpump, Arc/Restore. Working closely with DEV team and assisting them in data modeling.
• Proficient in Teradata AMP and client based administration utilities such as Ferret, Check Table, Console interface (cnssupv), Config, Reconfig, DIP, PMON etc.
• Administration of the production boxes over a period of time to identify the bottlenecks and workload balancing of the system. Proficient in writing SHELL scripts, Stored Procedures, Macros in order to automate and simplify the day to day activities.
• Acquaintance with data modeling/logical modeling and Replication tool Golden Gate.
• Systems Programming for Teradata PDE Subsystem server code in C.
• Enhancement and Maintenance of Teradata database. Used Microsoft Visual Studio .Net, GDB and WinDBG for debugging.

TECHNICAL SKILLS

Platforms: Windows NT/2000/XP/2003, Linux-REDHAT 2.6.7 & SUSE ES9, MPRAS - System V.
Languages: Shell scripting, JCL, C, Assembly.
Tools: Rational Rose, Rational ClearCase, gdb, WinDbg, Mainframe Environment(MVS), Tivoli (TWS), NetVault 7.45 withTDAT plugin version: 11.1, NetBackUP, TARA, GoldenGate
Database: Teradata V2R5, V2R6, V2R12.
Teradata Server Utilities:
Teradata Manager, Priority Scheduler, Database Query Language (DBQL), Teradata Query Manager (TDQM), Database Window (DBW), DBS Control, VprocManager, FERRET, CheckTable, TableRebuild, Recovery Manager, TDWM, PMON,TASM.
Teradata Client Utilities:
BTEQ, Queryman (SQL Assistant), Multiload, Fastload, FastExport, Tpump and Archive/Restore.

Certifications

Teradata Certified Master V2R5

EDUCATION

Bachelors in Information Technology
Personal Accomplishments

• Involved in developing major feature (Virtual Storage Arch) awaiting to release.
• Acclaimed recognition and awards for Teradata porting on Linux.

AWARDS

• Staggered Performance Reward for outstanding performance with Barclays Client.
• NCR-Teradata High Performance award 2005, presented by NCR Corp.,
• Knight on the Town Award for outstanding performance in porting Teradata on Linux, presented by NCR Corp.,
• Pat on the back award by Satyam for outstanding performance in the projects.

• Teradata Administration at Teradata Corporation, USA
• Clearcase at Teradata Corporation, USA
• Teradata DBA activities, Tools and Utilities at Barclays, UK
• RDBMS Concepts at Satyam Learning Center, Hyderabad
• Leadership Skills at Satyam Learning Center, Hyderabad

Confidential
Client: Confidential, USA Oct 2009 --- Present
Teradata Database Administrator

Confidential, is a leading human therapeutics company in the biotechnology industry. For more than 25 years, the company has tapped the power of scientific discovery and innovation to advance the practice of medicine. Amgen pioneered the development of novel products based on advances in recombinant DNA and molecular biology and launched the biotechnology industry's first blockbuster medicines. Today, as a Fortune 500 company Amgen is serving millions of patients.

Confidential, has Terabytes of EDW data maintained by Teradata database and the source as SAP systems. It has PROD servers located in US and EUROPE and the data integrity is maintained with GoldenGate replication software. Different applications are maintained in EDW data and hundreds of users access the Data warehouse simultaneously.

Responsibilities:

• Manage the Teradata Servers across the globe, monitor the performance of databases and make tuning changes, researched and evaluated alternative solutions related query performance and recommend the most cost effective design solutions.
• Responsible for Patch upgrades, performance monitoring, responding to Alerts, tuning, creating appropriate Indexes, and creating Incidents with Teradata and assistance/follow up with the CSR.
• Performed system level and application level tuning and supported the application development teams for database needs and guidance using tools and utilities like explain, visual explain, PMON, DBC views.
• Developed Shell Scripts, Stored Procedures and Macros in order to automate to run based on the frequency.
• Involved in taking care of day-to-day needs for the Development team with in the specified SLA and also taking care of the ad-hoc requests.
• Successfully handled the needs such as creating Databases/Users/Tables/Views/Roles/Profiles etc., Access grants, Load support/assistance such as resolving the deadlock issues, creating the JI and SI, STATS collection, avoiding bad joins etc.
• Assist Development Team Leads in the design and implementation of large, complex database solutions.
• Reviewing the DDL/DML before it goes into TEST/PROD. Discuss/Review with the DEV team from the initial stages of the design, data model and understanding the business needs in order to choose the Indexes and other Architect things that need to be taken care.
• Responsible for the migration activities under the qualified environments.
• Set up and implement backup/recovery and security strategies, setting up the policies/schedules using NetBackup console and TARA.
• Responsible for syncing the PROD boxes present in US and Europe and maintaining the data integrity.
• Involved in installing/testing/documenting the Golden Gate for replication for Teradata systems across the globe.
• Involved in creating replication groups, adding extracts, pumps and sorts for Golden Gate replication.
• Involved in building the environment for testing the replication activities and end to end testing, Stress testing, Load testing the Golden Gate replication software.

Confidential
Client: Confidential, August 2007 --- Oct 2009
Teradata Database Administrator

Confidential, is one of the largest banks in UK. It has its operations distributed across several locations. Data from various source systems is fed into the EDW (Enterprise Data Warehouse). Bank has a dedicated infrastructure wing for catering the needs of this EDW known as DWS (Data Warehousing Services). Data Warehousing Services manages the platform infrastructure hosting data from the Group\'s operational systems providing the capability for users or operational systems to query and extract this information as required. DWS manages the whole end to end change and service lifecycle including build, schedule and infrastructure support, service desk, risk and compliance and service and finance management.

Barclays has 60+ Terabyte system with 32 nodes on production, 24 Nodes on Pre-Prod, 8
Nodes on Test , 8 Nodes on Development and 2 Nodes for Misc / Special projects, there are
around 300 source systems which loads data daily / weekly from various OS and database
flavours,2000+ user access the warehouse regularly, TASM is used for Workload management and Netvault for BAR Solution

Responsibilities:

• Barclays implements ticketing system (Service center) for all Order/Changes/Incidents which are assigned/picked up by the DBA's to resolve. Involved in resolving all kinds of tickets that are assigned, with in their respective SLA periods.
• Involved in DBA activities such as
• Creating Users, Databases and other objects,
• Creating/maintaining Roles and Profiles and assigning them to users,
• Space management,
• Access management.
• Have good hands on experience in BAR activities like Scheduling and monitoring of data backup. Proficient in archive and restore on both the environments of Mainframe (MVC) and NetVault.
• Scheduling and Trouble shooting the load schedules in TWS. Monitoring and restarting the data load schedules as needed on live system.
• Administering Teradata database (5 different MPP Systems) using Teradata Manager, Teradata Administrator and other Teradata internal tools.
• Performance tuning of Teradata SQL, ETL jobs. This demands good knowledge in understanding the parameters like Teradata Explain, Stats Collection, Multi value Compression, Skewing etc
• Involved in Performance monitoring the different TD servers using tools like PMON, Dashboard, TD Alert and other Barclay's specific internal monitoring/alerting tools.
• Reacting to alert system, if needed.
• Data movement across different Teradata servers to support development team.
• Involved in reviewing the Implementation plans of the new projects that needs to go LIVE. This includes educating the users with the best practices and Teradata recommendations where in need arrives.
• Also involved in implementing new projects (applications) on pre-production machine and advise the users in case of discrepancies, so that they can be avoided while implementing on production box. This implementation needs bunch of tasks to be executed such as creation of new data databases, Views databases, Users, tables, view and other objects as per requirement of the project. This is termed as OAT (Operational Acceptance Testing).
• Implemented the new projects/amendments to the existing projects on production machine once it gets clean sheet from the pre-production machine environment. It also includes DML execution, temporary Cycle data sets creation, creating the schedules, modifying the existing ones from TWS.
• Investigating the occurred discrepancies, through DBQL and communicating to the end users.

Confidential
Client: Confidential, USA April2005 --- July 2007
Teradata Programmer and Sustainer

Teradata PDE provides the underlying framework to support the Teradata RDBMS, which is a massively parallel database used for decision support and online transaction processing. To provide the high system reliability, availability, and serviceability that a massively parallel database requires, additional infrastructure is needed that Unix, Linux and Windows operating systems do not provide. To create this infrastructure and the parallel environment that the Teradata RDBMS requires, additional extensions and tools are added to the operating system kernel and libraries. These tools, libraries, and kernel drivers together become Teradata parallel database extensions (PDE).

Responsibilities:

• Involved in enhancement and maintenance of Teradata database and customer support for Teradata RDBMS by solving and fixing bugs in the RDBMS server code related to Teradata PDE
• Analyze the functionality of the Teradata Database Server and diagnose the customer problems and provide solution for the discrepancies in the server code. Apart from the technical know-how of the product, it needs proficiency in C and C++ languages.
• Worked on the problems involving design, logic, detail design changes, performance issues and other customer issues.
• Provided support to customers during major software upgrades, problem diagnosis and troubleshooting
• Debugged problems with PDE tools, utilities, and subsystems using the kernel debugger, puma, GDB, lcrash and WinDbg.
• Was actively involved in analyzing and fixing the problems at customer sites and internal sites of NCR
• Developed the scripts to automate the installation process and testing process using Shell programming and Expect.
• Designed and developed test cases (test stubs) for functionality testing (Black box testing) and unit testing, depending on the software requirements. Also performed acceptance testing, component testing and regression testing.
• Tested and reviewed code changes in enhancements of the Kernel.
• Documentation of changes and new features to the subsystems and utilities.

Administration tasks performed:

Administration of the production boxes over a period of time to identify the bottlenecks and workload balancing of the system. The major activities includes identifying AMP worker tasks depletion, running canaries, looking for delayed system response times, parallel efficiency (skewed CPU/IO), identifying high consuming queries or users, run away queries etc. Many administration and prioritization tools such as Teradata Manager, TASM, PMON, RSS, Puma and Priority Scheduler are used in this process.

Major activities performed during onsite assignment:

• Worked as frontline (24X7) support for the customers of Teradata globally and actively resolved the customer issues that involved both PDE and RDBMS. This requires knowledge in Troubleshooting, Installation/Upgrade/Downgrade of Teradata, SQL query related and administration issues.
• Responsible for support of benchmarking team for the benchmarks done on the General Customer Available (GCA) Teradata releases.
• Developed scripts using Expect, to help in administration and performance monitoring.

Confidential
Client: Confidential, USA March 2004 --- April2005
Teradata Kernel Programmer

To provide the high system reliability, availability, and serviceability that a massively parallel database requires, additional infrastructure is needed that Linux operating system do not provide. As per customer requirement was for porting the PDE code to Linux Operating system which includes the kernel as well as tools.

Responsibilities:

• Prior Analysis of the code changes that are required to incorporate PDE on Linux. Also includes identifying the GPL source code part that needs to be released to customer
• Involved in porting the PDE code changes on Linux which includes both the kernel and tools. As a team member actively interacted with different Kernel subsystem developers to understand and fix problems.
• Study of the design documents of every feature of the database to fix problems in that feature.
• Coding in C language as per NCR's standard.
• Technical discussions with the NCR developers through e-mails especially when there is a design change involved in the DR (discrepancy report) fix.
• Testing of Teradata development releases on Linux (32-bit & 64-bit). Had performed basic sanity, regression, stress and crashdump testing.
• Performed Teradata tools testing which demands sound knowledge in their complete usage and also it's internal architecture.
• Using various Teradata client utilities / tools as part of DR fixing.
• I had received advanced training in Teradata System Internals to apply the knowledge and expertise, gained over the years by other team members to trouble shoot complex problems when occurred on Customer sites. I have worked on problems involving Teradata design changes, performance issues and customer issues.