ABRIDGEMENT

• A seasoned IT professional with o er 16 years of commendable success in Teradata Production DBA Support, Teradata Application DBA Support, Application De elopment and Implementation Project Management.
• Currently associated with Confidential as Senior Database Administrator.
• Well ersed with Teradata Database Administration, Performance Tuning and Workload Management and arious Teradata Load Utilities Data warehousing concepts, Backup Tools such as NET AULT, ARCMAIN and in programming using PB, C, C , De . 2000 with Access, Oracle and Teradata.
• A keen strategist, planner and implementer with expertise in de ising strategies aimed at enhancing o erall organizational growth, sustained profitability of operations and impro ed business performance.
• Possess credibility personal integrity that lea es lasting impression with corporate decision makers, moti ates employees and generates loyalty.
• In-depth expertise in all aspects of the SDLC including requirement analysis, design, de elopment, testing, troubleshooting and debugging.
• Strong collaboration, team building, interpersonal, communication skills with proficiency at grasping new technical concepts quickly utilizing the same in a producti e manner.

CAREER MILESTONES

• Gained extensi e exposure for se eral support issues related to Data warehouses worldwide was trained in Teradata and Linux OS, at NCR San Diego office at NCR Teradata offshore unit, for some of the ery well-known global clients like SBC, Dell, Bank of America, etc.
• Pro ided Teradata DBA Support for the World's Largest Retail Datawarehouse Installation of Walmart Stores, Inc., Benton ille, Arkansas.
• Recognized as Teradata DBA with about 10 years of experience in Teradata DBA support acti ities while working as a Senior Database Administrator for erizon and Senior Manager-DBA for the prestigious WALMART World's largest retail database project of DBA support.
• Played a pi otal role Project Manager Teradata DBA in TESCO 2nd Largest retail in UK and Le el 3 support personnel along with Front-Line acti ities at NCR and Teradata Corporation.
• Teradata Certified professional and has experience on Teradata RDBMS extensi ely used Teradata Client Utilities along with Teradata iewpoint and Workload management by using TASM.

KEY RESULT AREAS

• Project Management Database Administration Application Programming
• Relationship Management Maintenance Team Management
• SDLC Software Analysis Client Relationship Management

Project Management

• Interacting with customer team for requirement gathering, risk assessment, finalization of technical specifications.
• De eloping plans schedules, resource allocations as per budgets, manpower deployment and team meetings for indi idual projects.
• Interacting with team members to ensure smooth progress of project work.

Confidential

• Interfacing with clients for business gathering, conducting system analysis and finalizing technical / functional specifications and high le el design documents for the project.
• Participating in design and coding of Software Applications mapping requirements participating in the finalization of product specifications and selection of appropriate techniques.
• Conducting system study and coordinating with team members for system design integration, application maintenance, etc. contributing to the design, de elopment, testing, troubleshooting and debugging of the software.

Database Administration

• Create, maintain, and support Database architectural en ironment.
• De ise strategy for Backups, reco ery fine-tuning.
• Workload Management, Capacity Planning, user maintenance, database security imposition performance analysis of application and database.

Relationship Management

• Meet deadlines without compromising quality norms and adhering to SLA. Deli ery Management Post Implementation support.
• Understand co-ordinate client's needs / enhancements, customization, software-related issues, pro ide solutions in adherence to deli ery schedules.
• Achie e customer satisfaction by ensuring ser ice quality norms and building the brand image by exceeding the customer expectations.

NOTEWORTHY ACCOMPLISHMENTS

• Lead a team of o er 40 members.
• Dexterously handling Teradata DBA acti ities for Confidential
• Recognized for pro iding Teradata DBA Support for Walmart, as well as the isibility to the Management for all the DBA Towers Consisting of 40 Members in the areas of Resource Position for all DBA Towers, Onsite and Offshore situation / key issues / challenges, Billing Details for the week, Kudos / E aluation of Kudos, alue Addition, Admin / IT issues, Weekly Report in the specified format, Nomination of DBA's from arious towers for Rewards Recognition, Handling of operational issues, Dri ing the Go ernance Team for ITIL/20k Certification, etc.
• Recei ed alues Awards at Tesco.
• Attained the Excellence Award for Exceptional Performance and aluable Contribution at Collabera, Bangalore.
• Awards / Appreciation Letters recei ed:
• Cash Reward under Special Skill Bonus from Collabera for handling complexities in ol ed with highest degree of accountability.
• Cash Reward under Key Associates Retention Scheme from Satyam for customer delight in meeting stakeholder obligation and achie ing high performance le els.

SCHOLASTICS

• B.Sc. from S.U., Rourkela in 1994.
• PGDIM from CMC, Kolkata in 1997.
• CIC from IGNOU, Kolkata IN 1998.

TECHNICAL SKILLS

• Database: Teradata
• Other Databases: Oracle
• Tools Utilities: Teradata iewpoint, TASM, Teradata Administrator, SQL Assistant, Fast Load, Mload, PDCR, Arcmain, TSET, isual Explain, Console, Ferret, LocksDisplay, DBS Control, BTEQ
• Languages: SQL, PL/SQL
• Backup Tools: Net ault, HP Open iew, Legato
• ETL Tool: Informatica
• Operating System: UNIX MP-RAS, Linux, Solaris, HP-UX , Windows
• Hardware: NCR WorldMark 5250/5350/5450/5400/5500/6700 Ser ers, Teradata Appliance
• Front-End Tools: PB, De eloper2000/6.
• Data Modeling Tools: S-Designer, Erwin, Designer2000
• Technology: Datawarehousing
• Business: Telecom, Retail
• Additional Trainings: Recei ed Training in SQL-H of Big Data Hadoop and Aster.

Organization Confidential

Title: erizon DBA Support

• Client: Confidential
• Location: Confidential

Role: Senior Database Administrator Teradata DBA

• Period: Since Jul'12
• Team Size: 8 members

En ironment: Working on following Databases and Client tools:

• Databases: Teradata 14.10, Oracle 11g
• Tools: Teradata Tools Utilities, Teradata iewpoint, PDCR,
• TASM, MLOAD, FastLoad, TOAD, TOAD Data Modeller.
• Backup: Net ault
• ETL: Informatica
• Data Sync: IBM CDC Tool
• O/s: Unix, Solaris, Windows
• Hardware: NCR WorldMark 6700 Ser ers, Teradata Appliance,
• Teradata Aster Big Analytics Appliances.
• Description: erizon is a global leader in Communications, IT solutions, Information and Entertainment Ser ices. It has 2 Production Systems and 2 De elopment Systems. erizon has migrated their Datawarehousing applications from arious databases like Oracle and DB2 to Teradata to ha e a single ersion of truth. As a Teradata DBA Numerous application databases were migrated from Oracle and simultaneously had to be fine tuned and supported.
• Role: Accountable for DBA acti ities in erizon Data warehouse En ironment:
• Migration of arious application databases from Oracle to Teradata.
• De elop ETL Extract, Transform, Load processes and tools needed to migrate this data
• Creation of data extraction scripts for Oracle.
• Creation of Teradata Mload and FastLoad and Bteq scripts for Data Migration
• Creation of Informatica Interfaces and mapping for Data Transfers.
• Resolution of arious data load errors.
• Recommendation of PI changes to reduce skewing factor of tables.
• Recommendation of additional Stats, Indexes for better query performance.
• Implementation Profiles.
• Disk space sa ing by implementation of M C and Block Compression restores.
• Creation of Backup and Restore/Copy Strategies.
• Creation of new Functional ID's for Application/Batch after re iewing/optimizing Sql's.
• Creation/Granting/Re oking of Roles, Pri ileges to Normal and Secured Databases.
• Be the main contact for issue resolutions and be an efficient Teradata DBA.
• Create, maintain, and support Teradata architectural en ironment.
• Setting up of alerts, canary queries, etc.
• Creation of Macros Space Management Database Up-gradation and Migration Acti ities.
• Upgradation and usage of PDCR.
• Resol e any Teradata related issues raised by business users and application teams.
• Support the application de elopment teams for database needs and guidance
• Support of production processes through tickets
• Sending of TSET info to Teradata GSC support ia incidents for their in-house problem re-creation.
• Respond to change requests to create, change, or delete database objects tables, iews, indexes, DDL, DML, etc. per client specifications.
• Recei ed Training in SQL-H of Big Data Hadoop and Aster.
• Highlights: Continuous Migration of Datawarehouse Application related databases from Oracle to Teradata within Fixed Time Frame. Pro ided performance tuning and process impro ement recommendations from time to time. Significant Space sa ings by using M C in production en ironment and block compression in non-production en ironment.

Title: Confidential

• Client: Confidential
• Location: Confidential

Role: Senior Manager Teradata DBA

• Period:
• Team Size: 11 members

En ironment: Working on following Database and Client tools:

• Database: Teradata
• Tools: Teradata Tools Utilities, Teradata iewpoint, TASM
• O/s: Linux, MP-RAS, Windows
• Hardware: NCR WorldMark Ser ers
• Description: Walmart has the world's largest retail database whose size has crossed Petabyte. It has 8 Production Systems and 2 De elopment Systems.
• Role: Accountable for DBA acti ities in Wal-Mart Data warehouse En ironment:
• Be the main contact for issue resolutions and be an efficient Lead DBA.
• Create, maintain, and support Teradata architectural en ironment.
• Migration of arious application databases across ser ers for load balancing.
• Query Tuning which resulted in significant CPU sa ings which goes as quarterly reports to upper management equated as Dollar Sa ings.
• Creation of new DBC ID's for Application/Batch after re iewing/optimizing Sql's
• Grant/Re oke of Additional Roles, Pri ileges to Normal and Secured Databases.
• Monitoring and maintenance through Teradata iewpoint.
• Using Teradata Manager to set alerts, canary queries, etc.
• Creation of Macros Space Management Database Up-gradation and Migration Acti ities.
• Resol e any Teradata related issues raised by business users and application teams.
• Support the application de elopment teams for database needs and guidance
• Support of production processes through Remedy tickets
• Respond to change requests to create, change, or delete database objects tables, iews, indexes, DDL, DML, etc. per client specifications.
• On-call support
• Pro ide Le el 2 3 support
• Highlights: Performed Query Tuning resulting in significant CPU cycles and spool space sa ings. Pro ided TASM recommendations from time to time for efficient workload management. Identified and rectified incorrect database permissions pro ided to a large number of users. Planned, prepared and executed Change Controls. Successfully upgraded to 13 and also migrated arious applications related to arious countries across different Teradata Systems.

Organization Confidential

Title: Confidential

• Client: Confidential
• Location: Confidential

Role: Project Manager - Teradata Lead DBA

• Period:
• Team Size: 4 members

En ironment: Working on following Database and Client tools:

• Database: Teradata
• Tools: Teradata Tools Utilities, Teradata Manager, TASM
• O/s: Linux, MP-RAS, Windows
• Hardware: NCR WorldMark 5250/5350/5450/5400/5500 Ser ers.
• Description: Tesco has 4 Production Systems and 1 De elopment box and has implemented Net ault Backup with SL8500 Tape Library. Master box comprises 12 5500 nodes at SDC Master DW for source data loading, analytic and ad hoc queries , Cheshunt box comprises of 28 5400 nodes at CDC Cheshunt Box is used for Group countries application , Reporting box comprises of 12 nodes in which 6 5250 and 6 5350 nodes Reporting applications use aggregate data deri ed from a master. New Master Box comprises of 16 nodes which separates the fixed report queries DW Reporting from the ariable ad-hoc queries DW Master has pro ed to be the best way to guarantee on-line performance for report users . De elopment Box consists of 12 Nodes.
• Role: Played a ital role as Project Manager - Teradata Lead DBA in Tesco:
• Key Stakeholder Management
• Pro ide isibility to support managers and concerned stakeholders
• Suggest and Implement Ser ice Impro ement Plans from time to time
• Project re iew report from time to time
• Be main contact for issue resolutions and be an efficient Lead DBA
• Create, maintain, and support Teradata architectural en ironment
• Administration of production objects in change control en ironment
• De elopment of pro-acti e processes for monitoring capacity and performance
• Frequent M C analysis for space sa ing.
• Using Teradata Manager to set alerts, canary queries, etc.
• Support of production processes such as P1,P2,P3 tickets
• Space administration. Ensuring that the disk space is effecti ely utilized.
• Database security administration.
• Database Backup, Archi al Restore using Net ault.
• Coordinating with Teradata GSC for upgrades, patch installation, etc.
• Weekly meetings with the Client and the dedicated GSC personnel.
• Running utilities like checktable, scandisk, etc
• On-call support
• Pro ide Le el 2 3 support
• Highlights: Implementation of TASM and DBA Best Practices. Implemented many useful Teradata alerts, M C, Capacity Planning Reports, Automatic Stats Collection Procedure, etc. Planned and executed successfully Migration and Up-gradation Acti ities. Implemented Incremental, Clustered and Partitioned Backup strategy apart from normal Database backup by using Net ault. Successfully migrated from L700 to SL8500 Tape Library. Successfully Upgraded and Migrated to Teradata Higher ersions.

Organization Confidential

Title: Confidential

• Client: Confidential
• Location: Confidential

Role: Teradata Specialist Support DBA

• Period: Apr'04 Apr'08
• Team Size: 24 members

En ironment: Worked on the following tools and languages:

• Languages: SQL, PL-SQL, C/C
• Database: Teradata 2R5/6/12
• Tools: Teradata Manager, TASM, NCR-PUT, Teradata Administrator, Teradata Manager,
• Fast Load, FastExport, BT
• O/s: MP-RAS, SUSE LINUX, Sun Solaris, Windows
• Description: Being a Teradata Certified Professional, I was in ol ed in working with DBA Support, Database Internals. Carried out the fine tuning of the Database and SQL to enhance the performance of Teradata for global customers. Good hands on experience on TASM implementation and Teradata Manager. Apart from this I pro ided acti e front-line support acti ities. Recei ed on-site training in Teradata Linux o/s from No ell in San Diego, California, USA.