OBJECTIVE

• Position where Database Designing and DBA skills and experience in database designing, administration and Management will add value in today’s challenging business and Information Technology.

SUMMARY

• 8+ years of experience in IT and Teradata administration, designing database solutions with Architecture.
• 5+ Years of exclusive Production support and deploy of Teradata Patches, fixtures and DBQL settings.
• Experienced in archiving, restoring and recovering data on Teradata using ARC utility and TARA GUI.
• Excellent knowledge in moving database objects between Teradata systems and Teradata Database.
• Very well trained and experienced in scheduling backups and recovery of the entire EDW databases across various geographical locations for the business continuity and response time.
• Track record in Archiving and Recovering Down Amps
• Highly experienced in designing and testing Node fail over tests
• Highly knowledgeable in designing table DDL mechanisms for Automatic Data Protection
• Skilled in using Utility commands (TPA resets) for stopping and restarting Teradata Database.
• Efficient in housekeeping and maintaining database through regular cleanup of old logs, deleting old data, collecting statistics and tuning queries for efficient database running.
• Highly skilled in using tools for Managing Teradata Resources to minimize the occurrence of impeded performance, maximize throughput and manage of consumption of resources.
• Experienced in troubleshooting and analyzing problems like job hangs, slowdowns, inconsistent rows, revalidating headers for tables with RI constraints, PPIs and configuration
• Worked with Teradata field engineers in handling Teradata crash dumps.
• Handling efficient way of data and DDL backups and environment refreshes.
• Experienced in reading DBQL, PMON to identify monster queries and Hot Amps.
• Excellent planner for releases and Outage notifications.
• High expertise in cross database coding/design skills( Oracle, Teradata and SQLServer)
• Excellent track record in tuning ETL and SQL Jobs within the batch window
• Expert knowledge in DBS control and settings.
• Good coding and tuning skills using Teradata load utilities like Fastload and Teradata Parallel Transporter.
• Expert in UNIX scripts for Database extraction and filtering.
• Experienced using crontab utilities and shell scripting for scheduling weekly and nightly loads.
• Good hands on experience in coding and developing Autosys scripts.
• Designed the Utility testing environment for concurrent Loads in the Database (Teradata) box.
• Developed and deployed solutions that support integration of data in all environments - transactional as well as operational and analytical.
• Provided a solid basis for expediting transactions, streamlining operations, making optimal decisions, building large data warehouses, data marts.
• Implemented, Architected and Designed ETL story boards based on Hybrid model(Star and Snowflake)
• Experienced with supply chain management systems development, implementation and analysis.
• Excellent knowledge in Entity Relationship modeling and Physical database designing.
• Wrote SQL scripts for backend databases, custom stored procedures, macros. Enhanced and Customized load and back up scripts to the newly developed and in design projects.

TECHNICAL SKILLS

Operating Systems: Windows 95/98, Windows 2000, XP, UNIX, MS-DOS.

Programming Languages: C, C++, Universe Basic, PERL, TCL, UNIX shell scripts.

Tools: ERWIN Data Modeling, Rational Tools, Golden Gate

Databases: Teradata 13.10/13.0.1// V12/6.2, Oracle 10g/9i, Universe DB, MS Access, SQL Server.

PROFESSIONAL EXPERIENCE

Confidential, Hoffman Estates, IL

Teradata DBA

Responsibilities:

• Responsible and involved in Setting up the Teradata database, users, Roles and Profiles.
• Applied data protection including Transient Journal, Fallback. Resolved deadlocks and DBQL maintenance creating an archive DBQL SYSTEM MGMT database.
• Defined Permanent space limits both at the database and user level for different business scenarios.
• Configured DBS control settings and MaxLoad AWT, MaxLoadTasks, DBQLFlushRate and system fields and other Performance fields like MaxParseTreeSegs.
• Took crash dumps and TSETs for the Teradata technology to analyze for certain crashes.
• Highly experienced in working with Teradata support team for Opening and tracking incidents for Teradata issues or any upgrades.
• Designed Security model based on the business model and enforced the security through roles.
• Worked with Teradata System Engineers and Support team to fix Node level issue.
• Installed patches to BAR server and Viewpoint.
• Developed statistics macros and automated to run based on the frequency.
• Used Dataflux tool for data profiling, data patterns and analyzing data for designing right Primary Indexes.
• Defined account IDs, priority scheduler performance groups, and system date and time substitution variables in user and profile definitions.
• Configured the TDWM and customized for the Sears’s business model.
• Experienced in Loading, archiving and restoring data Duties also involved are storage optimization, performance tuning, monitoring, UNIX shell scripting, and physical and logical database design.
• Controlled and tracked access to Teradata Database by granting and revoking privileges.
• Implemented Teradata protection features Table design and index selection Table implementations, maintenance, and backup, Problem support, Workload monitoring and control, Policies, procedures and guidelines that govern the Teradata environment
• Involved in SQL code review, Developer and user support and training, Capacity planning, System software testing and benchmarking and Support and coordination during hardware upgrades
• Designed DDLs and efficient PIs along with Identity Keys for efficient data distribution
• Assisted Developers with coding and effective Join issues
• Responsible for Backups every night after Major loads.
• Allocated spaces to the users, controlled Spool spaces and assigning of table spaces
• Planned the releases, monitored performance and reported to Teradata for further technical issues.
• Explained Users by showing Viewpoint about their inefficient queries
• Involved with Teradata to deploy patches, install, fix and figured out the settings.
• Applied DBQL settings to the business and application standards.

Environment: Teradata 13.10, Teradata Administrator, Teradata SQL Assistant, Teradata Viewpoint, BTEQ, MLOAD, TPT, ARCHMAIN, TASM, Netbackup, TARA GUI, UNIX, Shell scripts.

Confidential, Riverwoods, IL

Teradata DBA

Responsibilities:

• Involved in Setting up the Teradata database, Created databases and users, Allocated perm and spool space
• Applied data protection including Transient Journal, Fallback. Resolved deadlocks and involved in Granting and revoke security privileges.
• Defined Permanent space limits both at the database and user level.
• Created users, databases, roles, profiles and accounts.
• Established logon security, including external authentication.
• Defined account IDs, priority scheduler performance groups, and system date and time substitution variables in user and profile definitions.
• Experienced in Loading, archiving and restoring data Duties also involved are storage optimization, performance tuning, monitoring, UNIX shell scripting, and physical and logical database design.
• Controlled and tracked access to Teradata Database by granting and revoking privileges.
• Implemented Teradata protection features Table design and index selection Table implementations, maintenance, and backup, Problem support, Workload monitoring and control, Policies, procedures and guidelines that govern the Teradata environment, SQL code review, Developer and user support and training, Capacity planning, System software testing and benchmarking and Support and coordination during hardware upgrades
• Designed DDLs and efficient PIs along with Identity Keys for efficient data distribution
• Assisted Developers with coding and effective Join issues
• Responsible for Backups every night after Major loads.
• Allocated spaces to the users, controlled Spool spaces and assigning of table spaces
• Planned the releases, monitored performance and reported to Teradata for further technical issues.
• Involved with Teradata to deploy patches, install, fix and figured out the settings.
• Applied DBQL settings to the business and application standards.
• Hand coded Teradata SQL queries in Teradata CLI stage, Written Macros, Stored Procedures, triggers in Teradata. Extracted valid data to avoid overhead and Designed Test cases and Error codes and involved in testing the data stage Jobs before running in Pre-Prod, also helped ETL Developers in Understanding Data Models, identifying the various relationships among the tables in the Model. Written the best of Programming Logic to serve the BEST purpose.
• Developed Data Extractions which includes Unit and System Testing of all the Extractions. Involved in Reporting the Data and its Quality Issues to Profile team.
• Developed SQL Scripts in Teradata, Tuned Tpump jobs to avoid deadlocks.
• Ran DBQL and Explains to see the in depth frame of the query behavior
• Developed trend charts to monitor defect levels in databases in order to maintain statistical control of the business and site systems
• Developed Quality Stage macros to run in batch during specific times of the day.
• Expert in employing Total Quality Management with data modeling and RDBMS concepts in managing data quality and clean up efforts.
• Implemented triggers to monitor restricted tables and database access
• Involved in ETL Architecture from Source data flow to Target loading
• Designed high volume tables with efficient Primary Indexes and Primary Partition Indexes.
• Designed ICD system which is a common interface between teams for data communication
• Acted as the primary focal point of Contact for the IBI team for both business and technical support.
• Coded UNIX scripts for Database extraction and filtering.
• Responsible for Schema comparison and DDL validation.
• Designed ETL version of data model for the developers to understand the modeling from the developed logical and physical models.

Environment: Teradata V2R6/12, TASM, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, PMON, MLOAD, ARCHMAIN, UNIX, LINUX SUSE, Shell scripts.

Confidential, Seattle, WA

Teradata Application DBA

Responsibilities:

• Defined account IDs, priority scheduler performance groups, and system date and time substitution variables in user and profile definitions.
• Experienced in Loading, archiving and restoring data Duties also involved are storage optimization, performance tuning, monitoring, UNIX shell scripting, and physical and logical database design.
• Controlled and tracked access to Teradata Database by granting and revoking privileges.
• Implemented Teradata protection features Table design and index selection Table implementations, maintenance, and backup, Problem support, Workload monitoring and control, Policies, procedures and guidelines that govern the Teradata environment, SQL code review, Developer and user support and training, Capacity planning, System software testing and benchmarking and Support and coordination during hardware upgrades
• Designed DDLs and efficient PIs along with Identity Keys for efficient data distribution
• Assisted Developers with coding and effective Join issues
• Responsible for Backups every night after Major loads.
• Allocated spaces to the users, controlled Spool spaces and assigning of table spaces
• Planned the releases, monitored performance and reported to Teradata for further technical issues.
• Involved with Teradata to deploy patches, install, fix and figured out the settings.
• Applied DBQL settings to the business and application standards.
• Defined relationships as the identifying and non-identifying relationships ensuring integrity constraints.
• Designed and Architected ETL Preprocess system to capture delta loads.
• Responsible in Troubleshooting and releasing Mloads in different phases and restart scenarios.
• Wrote UNIX shell scripts for initialization process, scheduling and control mechanism.
• Supported the platform along with patches.
• Wrote queries which are resource hog and fine tuned for performance
• Excellent team player and complied to security
• Ran DBQL and Explains to see the in depth frame of the query behavior
• Tutored developers regarding the PIs and Optimizer behavior about different queries.
• Developed sql scripts to identify data anomalies, complex data validation and for data cleansing purpose.
• Hand coded Teradata SQL queries in Teradata CLI stage, Written Macros, Stored Procedures, triggers in Teradata. Extracted valid data to avoid overhead and Designed Test cases and Error codes and involved in testing the data stage Jobs before running in Pre-Prod, also helped ETL
• Interacted with Business Units and Analysts to cleanse the data and match the Operating Standards.
• Used rich experience of database querying in Performance tuning of ETL Jobs and embedded SQL queries in OCI, CLI, Mutliload, Tpump and SQL-Loader.
• Imported and Exported Repositories cross projects.
• Prepared functional and technical specifications for the preprocess system.
• Highly technical competent in all phases of application systems
• Designed the Utility testing environment for concurrent Loads on the Teradata box.
• Created efficient hash tables for referential Integrity and Lookup purposes for validation and referential purpose.
• Experienced in writing SQL scripts for populating new fields added to tables on a one-shot basis and solving the problem associated with slowly-changing dimension for one of the dimension tables.
• Involved in performing unit testing and integration testing the individual and extract-transform-load jobs in sequence respectively.
• Analyzed the Data Sources in identifying data anomalies patterns value ranges. Wrote SQL scripts for accomplishing the same.
• Compiled and debugging the Jobs based on the Errors.
• Wrote shell scripts for scheduling the ETL process.

Environment: Teradata V2R5/R6, TASM, TPT, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, PMON, MLOAD, ARCHMAIN, Net vault, Erwin Designer, UNIX, Shell scripts.

Confidential, Atlanta, GA

Teradata/ETL Developer

Responsibilities:

• Responsible for delivering project timeline associated with the developer deliverables.
• Designing and developing relational and dimensional models in Framework Manager.
• Used different Teradata utilities on UNIX and Mainframes (COBOL) environment.
• Responsible to gather requirements from business users and format them according to the business needs, model the requirements to match the current architecture and assign it to the team
• Educated the team on how to do the performance tuning on complex queries with efficiency of MULTI-TABLE concept, Join Index, PPI, Partitioning PPI, Secondary Index mechanism, backup and recovery, day-to-day request such as altering a table, capacity planning, general SQL tuning and skew factor.
• Expert in physical database design, logical modelling and development of pro-active processes for monitoring capacity and performance.
• Supported other ongoing projects: Software Upgrade project from Teradata V2R6.2 to V12.
• Highly proficient in writing Teradata load and export scripts like BTEQ, MLoad, FLoad and Fast Export.
• Responsible for creating Procedures and Jobs on Mainframes using JCL, to run various scripts like BTEQ, FLOAD, MLOAD and FEXPORT.
• Created COBOL copy books to check the format and data before sending the file to the clients.
• Used version control tool like Endeavor to elevate components to production environment.
• Educated the team on how to utilise the teradata visual tools like Teradata Manager, Database query language (DBQL), TDQM, Visual explain etc.,
• Implemented a process from Development life cycle to the production implementation including naming conventions, environment prefix etc and trained the team accordingly.
• Optimised high volume tables (Including collection tables) in teradata using various join index techniques, secondary indexes, join strategies and hash distribution methods.
• Implemented different kinds of purging techniques to free up space in certain teradata databases and to remove orphan records from collection tables.
• Trained off-shore team (four) and on-site team (three) on teradata architecture, usage of Bteq in UNIX environment and usage of MLoad, FLoad, Fast Export.
• Extensively used MLoad, FLoad and Fast Export Teradata tools both in ETL and UNIX scripts for high volume flat files.
• Created a Generic BTEQ script to load the data into various target tables from flat files using control table mechanism.
• Using PERL, created a script which generates MLoad script on the fly based on the table name supplied as a parameter. This has reduced the manual intervention in case of new table added in the database.
• Implemented data export from one environment to another environment using Fast Export and Fast Load. All that the scripts needs is table name, environment to export, environment to import and user credentials. This gives flexibility of importing data from production to test and to development as when the environments require fresh data.
• Faster incoming file process automated to loading into teradata staging using BTEQ, Fast Load and then loaded into MLoad by concatenating files on the basis of table name.
• The technologies used in processes are Teradata, oracle, DB2, UNIX and Mainframes.
• Extensively worked on teradata performance optimization and brought down the queries to seconds or minutes from spool out and never ending queries by using various teradata optimization strategies.