SUMMARY

• 10.5 years of rich IT experience as Database Administrator and Teradata Architect and proven skills in TERADATA Database Administration / Teradata Performance specialist.
• Experienced to work as Lead DBA/ Tech Lead/ Team Lead/ Sr. Performance specialist / Sr. Teradata DBA.
• Visited onsite for client place in various parts of Europe and Asia Pacific.
• Worked on Teradata and Oracle as database administrator / Solution Architect.
• Creating & Managing Databases/Users, Roles/Profiles.
• Implement the best practice on Space management.
• Implement the best practice on Role for data protection.
• Implement best practice on Profile for security administration.
• Experience in Multi value compression (MVC), Collect stats.
• Worked with Teradata Engineering team for Teradata upgradation.
• Worked on Teradata tools like TASM, PDCR, BTEQ, ARCMAIN, TPT, Fastload, Multiload, PMCP, Viewpoint, and TSET, DBQL, Access logging, Resusage .
• Worked on TWS scheduling tool, creation of composer script.
• Worked on Mainframe TWS and endevour.
• Worked on Teradata DBS Control utility like Recovery Manager, DBS control, Locking logger, Lock display, Showlocks, Query session, Vproc Manager, Ferret, CTL, Cnsterm etc.
• Worked on Incident management, Problem management, Change management on SM7 and Managenow, Service now.
• Monitoring & administering the Teradata Databases using tools such as Teradata Manager, PMON and Teradata administrator, Viewpoint.
• Good DBA skills in Teradata DBMS production DBA support.
• SQL query performance tuning, System level performance analysis.
• Skilled on performing backups using Teradata arcmain, Netbackup, TARA GUI.
• Experience in reducing the skew and defining distribution keys (PI), primary partitions (PPI), multi level partitions (MPPI).
• Experience in creating Join Indexes (JI) and other variety of indexes like UPI, USI, NUSI for tuning the queries for optimal performance.
• Experience in reviewing query bands, analyzing the spool, I/O, CPU usage using PDCR data, and explain plan investigation.
• Implemented the MVC (Multi Value Compression) for space saving and reducing the I/O.
• Implemented BLC (Block Level Compression) for tables which are not frequently used for space saving.
• Experience to implement PDM for Teradata objects.
• Experience in Oracle to Teradata migration activity.
• Tuning the Database and Application using Statspack and AWR Utility in Oracle.
• Design Proper Indexing Strategy in Oracle.
• Export/Import and Cloning of Database for Development Team in Oracle.
• Good exposure to Teradata 14.10, Teradata 14, Teradata 13.10, Teradata 13, Teradata 12, Teradata V2R5, Oracle 9i and Oracle 10g RDBMS.

TECHNICAL SKILLS

Operating Systems: Linux, UNIX, Windows xp, Mainframe

DBMS: Teradata 14.10, Teradata 14, Teradata 13.10, Teradata 13, Teradata 12, Teradata V2R5, Oracle 10g, Oracle 9i

Teradata Tools/Utilities: Teradata SQL Assistant, Teradata Administrator, TDWM, TASM, TSET, Teradata Manager, Viewpoint, Bteq, TPT, Fast load, Multiload, Arcmain, DBS control, PDCR, PMCP, PMON.

Scheduling tool: TWS Scheduler, Mainframe TWS Scheduler, and Mainframe Endevour for version control.

Incident/Problem Management tool: SM7, Manage Now, Service Now.

PROFESSIONAL EXPERIENCE

Confidential

Lead Teradata DBA

Tool: Teradata 14.10, Viewpoint 15.0

Responsibility:

• Analyze and setup Teradata Active Systems Management (TASM) tool.
• Implement performance reporting using PDCR toolkit.
• Monitor, recommend and maintain/ adjust the TASM settings based on the production workload.
• Monitor, recommend and Adjust workload sessions and concurrency settings
• Review and Analyze Viewpoint setup, database alerts and Canary queries set - up in environment.
• Setup and respond to Viewpoint alerts for system and query performance.
• Generate monthly space usage trend reports by database.
• Generate monthly system performance trend reports.
• Analyze monthly performance reports for trends and provide recommendations.
• Identify poor performing queries via Viewpoint alerts and based on DBQL (database query logging).
• Run explain plans of poor performing queries and provide recommendations.
• Run compression on approved tables
• Analyze skewed tables and provide recommendations for improvement
• Setup system disk and CPU capacity baseline
• Collect information from Client regarding new projects and demand
• Create Capacity Plan based on trends and Client demands
• Develop and implement Teradata database authorization model in collaboration
• Define and implement password policy
• Define and implement policy for dormant users
• Administer power user logins and passwords periodically based on client security guidelines
• Administer privileged database access based on client security guidelines
• Apply system and database security policies as directed by client security team

Confidential

Tool: Teradata 14, Teradata Migration Accelerator, Oracle 10g, Viewpoint 15

Responsibility:

• Implemented PDM for Teradata objects.
• Involved in the Oracle To Teradata migration activities.
• Identify poor performing queries via Viewpoint alerts and based on DBQL (database query logging).
• Run explain plans of poor performing queries and provide recommendations.
• Setup and maintain statistics collection process
• Identify performance issues and make recommendations for resolution
• Analyze tables for candidate columns for compression and determine space savings
• Run compression on approved tables
• Analyze skewed tables and provide recommendations for improvement
• Setup system disk and CPU capacity baseline
• Collect information from client regarding new projects and demands.
• Create capacity plan based on trends and client demands
• Experience to migrate the definition from Oracle to Teradata using TMA tool
• Create migrated objects in bulk in Teradata.

Confidential

Sr. Teradata DBA, Performance Specialist

Tool: Teradata 14.10, Viewpoint 15.0

Responsibility:

• Analyze and setup Teradata Active Systems Management (TASM) tool.
• Implement performance reporting using PDCR toolkit.
• Monitor, recommend and maintain/ adjust the TASM settings based on the production workload.
• Monitor, recommend and Adjust workload sessions and concurrency settings
• Review and Analyse Viewpoint setup, database alerts and Canary queries set-up in environment.
• Setup and respond to Viewpoint alerts for system and query performance.
• Generate monthly space usage trend reports by database.
• Generate monthly system performance trend reports.
• Analyse monthly performance reports for trends and provide recommendations.
• Identify poor performing queries via Viewpoint alerts and based on DBQL (database query logging).
• Run explain plans of poor performing queries and provide recommendations.
• Setup and maintain statistics collection process
• Identify performance issues and make recommendations for resolution
• Analyse tables for candidate columns for compression and determine space savings
• Run compression on approved tables
• Analyse skewed tables and provide recommendations for improvement
• Setup system disk and CPU capacity baseline
• Collect information from Client regarding new projects and demand
• Create Capacity Plan based on trends and Client demands
• Develop and implement Teradata database authorization model in collaboration
• Define and implement password policy
• Define and implement policy for dormant users
• Administer power user login and password periodically based on client security guidelines
• Administer privileged database access based on client security guidelines
• Apply system and database security policies as directed by client security team
• Review and report on DB access Violations
• Participate in client security and compliance audits by completing client pro-vided questionnaires or providing evidence of compliance to policies
• Maintain Database Query Log (DBQL) and Access Log data for auditing based on Client's requirements
• Identify Teradata database security risks
• Define controls and processes to mitigate identified risks
• Gather evidence around controls and maintain the processes
• Ensure defined controls are working and managing the identified risks
• Database security logs review/ audit and compliance
• Maintain Database Query Logging (DBQL) data for security audits

Confidential

Sr. Database Administrator / Performace Specialist

Tool: Teradata 14.10, Viewpoint 15.0

Responsibilities:

• Setup the Database hierarchy, create database and user, troubleshoot database
• Implemented the Teradata best practice to purge the DBC data DBC housekeeping.
• Implemented the Teradata Viewpoint setup and design the roles for proper access rights.
• Implemented the roles and profile accordingly to the different types of user.
• Performance tuning of query.
• Troubleshoot the databases and end user problems.

Confidential

Sr. Database administrator / Performace Specialist

Tool: Teradata 14.10, Viewpoint 15.0

Responsibilities:

• Experience to recommend DBA remediation activity and implementation.
• Identified the objects where stats are not collected or stale states, implemented Teradata stats collection tool.
• Identified the duplicate access right and cleaned them to avoid the overhead on access right table
• Identified the top skewed objects and suggested them the proper primary index column to avoid the unnecessary I/O.
• Implemented the DBC housekeeping process for backup and purge the data from DBC to DBC History database.
• Implemented the compression tool for data compression which helps to save the space.
• Set up the database from scratch with proper hierarchy.
• Experience to change the DBS console parameter as and when required.
• Experience to use the DBS console utilities like Show locks, Query Session, Lock display, Abort Session, Recovery manager etc.
• Set up the roles and profiles for the different kind of users based upon users access and resource usage.
• Enable the query logging process for the SQL and Objects information.
• Experience to install the PDCR tool by using DIP script.
• Enable the Access logging for the users.
• Creation of Databases and Users with better user management.
• Applied best practices for Databases and User.
• Setup the viewpoint server for the new Teradata 14 system
• Troubleshoot the database problems.

Confidential

IT Infrastructure Lead

Tool: Teradata 14.10, Viewpoint 15.0

Responsibilities:

• Experience to work on to implement housekeeping jobs for infrastructure management like DBQL purge, Spaceupdown process and analysis, troubleshooting of job, Creation of TWS schedule and Jobs, Creation of Netvault backup and tape copy job, BAR migration from mainframe to Netvault etc.
• Development of Spaceupdown process to optimize and avoid the recurring incidents.
• Development of DBQL purging process
• Experience on Incident, problem management and change record in SM7.
• Experience on Online Performance monitoring.
• Experience on BAR Migration, to migrate the backup job from Mainframe to Netvault.
• Worked on Mainframe TWS and endevour.
• Created the Netvault backup jobs and tape copy job.
• Development of MI reporting and scheduling.
• Exposure on TDWM, Teradata Manager, Teradata Administrator, Viewpoint, BTEQ and ARCMAIN, TWS scheduling tool.
• Exposure to design Admin portal to perform all the administration activity in a predefined process way.
• Creation of Databases and Users with better user management.
• Creation and Maintenance of Users, Databases, roles and profiles manually and through Database Administrator tool
• Applied best practices for Space management.
• Creation of tables, views, macros and Procedures,
• Used Teradata Manager to monitor and analyze performance and sessions Performance Monitoring.
• Managed Backup Operations by creating the backups and tape copy job through Netvault.

Confidential

Sr. Teradata Database Administrator

Tools: Teradata 12, PMON, Teradata Manager

Responsibilities:

• Creation of Databases and Users with better user management.
• Creation and Maintenance of Users, Databases, roles and profiles manually and through Database Administrator tool
• Applied best practices for Roles and Access rights Management.
• Applied best practice for Profiles for better password management.
• Applied best practice for Space management.
• Defined the password policy based on the User’s group and implement at profile level.
• Apply best practices for Space Management.
• Creation of tables, views, macros and Procedures,
• Worked with Teradata Engineering team for Teradata upgradation.
• Generate monthly resource utilization report to aid in long-term capacity planning.
• Enable the query logging (DBQL) and Purging of DBQL tables.
• Used Teradata Manager to monitor and analyze performance and sessions Performance Monitoring.
• Managed Backup Operations by taking periodic backups and restore of databases through Arcmain.
• Online Performance monitoring to monitor the database activities like locking, blocking etc.
• Using PMCP (Performance Monitoring and Capacity Planning), we are generate a report for Client specific requirement like CPU, IO, Space management.
• Using DBQL generating a report for highly resource consumed query.
• Setting up the Alert’s in Teradata Manager Application.
• Document Teradata DBA specific Operation Manual.
• Configure and install Teradata manager server on PROD and DEV environment.

Confidential

Tool: Teradata 12, Teradata Manager, PMON

Responsibilities:

• Creating and Updating Operations Manual (Run Book) for Teradata Server as per client requirement.
• Perm/Spool Space Management and Access rights maintenance.
• Monitoring resource, CPU usage and users activity using DBQL data.
• Implementing Collect statistics process on important tables.
• Implementing several Alert policies on Teradata Manager Server in order to proactive database monitoring.
• Monitoring of databases using Confidential ’s custom made tool (similar to PMON).
• Monitoring and resolving session blocking.
• Offshore DBA support to application teams in creating database objects, tuning queries and handling loading jobs.

Confidential

Oracle Database Administrator

Tools: Oracle 9i, Oracle 10g, OEM

Responsibilities:

• Worked as Oracle Production DBA in a large environment.
• Administration & Maintenance of Database server and Application Server.
• Tuning the Database and Application using Statspack and AWR Utility.
• Tune SQL Query of Critical Report.
• Design Proper Indexing Strategy.
• Deploying Application and Database Patch.
• Administration of all Database Objects, Space management, roles and profiles.
• Multiplexing Control File and Redo log Files.
• Export/Import and Cloning of Database for Development Team.
• Troubleshooting of Database.

Confidential

Database Administrator

Tool: Oracle 9i, Oracle 10g, SAP R3

Responsibilities:

• Working on SAP Implementation Team as a team coordinator for data migration.
• Tuning of Database using Statspack Utility.
• Design Proper Indexing Strategy.
• Deploying Application and Database Patch.
• Administration of all Database Objects like Tablespace, Table, Index.
• Export/Import and Cloning of Database for Development Team.
• Troubleshooting of database.