We provide IT Staff Augmentation Services!

Sr. Teradata Dba Resume

3.00 Rating

Baltimore, MD

SUMMARY

  • Over 10+years of experience in moving database objects between Teradata Systems and Teradata Database.
  • Created, maintained and supported the Teradata architecture in DEV, TST, INT, PROD
  • Proficient in managing physical database in CDEV, TST, INT and Production environments
  • Managed code promotion objects in PTC/MKS integrity change control in all environments
  • Worked on capacity planning, reported disk and CPU usage growth reports using Teradata Manager, DBQL, and ResUsage.
  • Provided system level and application level performance issues as feedback to development teams.
  • Provided query plan and stats collection information to the development teams.
  • Served as technical lead for weekly backups (DEV ~25TB, VAL ~20TB and PROD ~275 TB) including NetBackup policies and Restore.
  • Supported database restore for all environments based on application team request and resolved incident tickets
  • Effectively supported permission issues in informatica workflow and password management of Unix Service Accounts for LSDR.
  • Good technical knowledge on Hadoop Ecosystem: HDFS, Mapreduce, HBase, Pig, Hive, Sqoop, Flume.
  • Designed security model based on the business model and enforced the security through roles.
  • Participate in 24x7 on - call rotation with other Team members.
  • Led the technical tasks for scheduling backups and recovery of complete EDW databases across various geographical locations for the business continuity and response time.
  • Provided lead support for Teradata Viewpoint, TASM, and Teradata load utilities
  • Created and maintain positive and professional business relationships with both internal associates and external business users.
  • Led and performed housekeeping and maintaining database through regular cleanup of old logs, deleting old data, collecting statistics and tuning queries for efficient database running.
  • Effectively supported the client’s needs using tools for Managing Teradata Resources to minimize the occurrence of impeded performance, maximize throughput and manage of consumption of resources.
  • Managed Teradata Unity and Unified Data Architecture
  • Used the Teradata Data Moverto copy data and objects such as tables and statistics from one system to another. UsedTeradata Data Moverfor overall data management capabilities for copying indexes, global temporary tables.
  • Provided troubleshooting and analyzing problems like job hangs, slowdowns, inconsistent rows, revalidating headers for tables with RI constraints, PPIs and configuration
  • Conducted archiving, restoring and recovering data on Teradata using ARC utility and TARA GUI
  • Efficiently handled data and DDL backups and environment refreshes.
  • Created documents for database backup and recovery plans, capacity plans and security plans to meet project requirements.
  • Demonstrated good coding and tuning skills using Teradata load utilities like Fastload and Teradata Parallel Transporter.
  • Provided a solid basis for expediting transactions, streamlining operations, making optimal decisions, building large data warehouses, data marts.
  • Served as technical lead for Entity Relationship modeling and Physical database designing.
  • Skilled and proficient with Microsoft Office Products including Word, Excel, Access, and PowerPoint

TECHNICAL SKILLS

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

Tools: ERWIN Data Modeling, Rational Tools, Golden Gate, Netbackup 7.5, Net vault

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

PROFESSIONAL EXPERIENCE

Confidential - Baltimore, MD

Sr. Teradata DBA

Responsibilities:

  • Performed instrumental role in project development from inception to implementation.
  • Supported development and implementation of relational database environments. Interfaced with initial application project teams to ensure success.
  • Provided technical lead services for code versioning and deployment system and application lifecycle management.
  • Supported weekly backups (CMSDEV ~25TB, CMSDEV ~20TB and PROD ~275 TB) including NetBackup policies and restore.
  • Effectively managed creating and Scheduling the Daily, Weekly, Monthly and on-demand jobs on Dynamic Tivoli Workload Console and verification that jobs are valid.
  • Provided support for permission issues in informatica workflow and password management of Unix service accounts for LSDR.
  • Performed special requests for Development, Test, Integration and Production teams in the Unix environment
  • Attended project migration requests and coordinating with Infrastructure, informatica and data modler teams.
  • Participated in 24X7 on-call rotation.
  • Maintained and provided service for Teradata Update Versions in production environments.
  • Monitored the Teradata Viewpoint: The viewpoint monitoring portlet allows to analyzing resource usage trends on one or more Teradata Viewpoint servers.
  • Provided technical lead services in analyzing trends are graphs according to metrics such as CPU, memory usage with in time frame. Terada data view monitor also analyze system health, canary response, workload.
  • Utilized Viewpoint for blocking, long running quires for tuning, high PJI, skewed queries and identify the top CPU consuming sessions and worked with developers and user to resolve the issues.

Environment: Teradata 14.10, Teradata Administrator, Teradata SQL Assistant, Teradata Viewpoint, BTEQ, MLOAD, TPT, ARCHMAIN, TASM, TDWC, PTC/MKS Integrity, Netbackup 7.5, TARA GUI.

Confidential, Baltimore, MD

Sr. Teradata DBA

Responsibilities:

  • Implemented infrastructure changes in accordance with the Change Management processes
  • Experience in performance tuning, capacity planning, analyzing the CPU and IO requirements and the data warehousing space management.
  • Effectively supported the client’s user security model by creating profiles, roles and assign appropriate access rights to them.
  • Provided lead technical services for weekly Development, Validation and Production backups including NetBackup policies and restore.
  • Created and scheduled several ETL jobs on Dynamic Tivoli Workload Console (DTWC).
  • Provided support for permission issues and password management of Unix Service Accounts for IDR.
  • Member of 7 by 24 rotating on call team
  • Executed capacity and security plans to meet the project requirements.
  • Performed special requests such as copying files from development to Test, Val and production, re-naming the files, executing the scripts and creating UNIX directories and file folders for the developers.
  • Lead maintenance and installation of Teradata Updated Versions in all environments.

Environment: Teradata 14.10, Teradata Administrator, Teradata SQL Assistant, Teradata Viewpoint, BTEQ, MLOAD, TPT, ARCHMAIN, TASM, TDWC, PTC/MKS Integrity Netbackup 7.5, TARA GUI.

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.
  • 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 production issues.
  • Provided technical lead services on Teradata Unity and Unified Data Architecture
  • Created and served the team using Teradata Data Moverto copy data and objects such as tables and statistics from one system to another. UsedTeradata Data Moverfor overall data management capabilities for copying indexes, global temporary tables.
  • Designed Security model based on the business model and enforced the security through roles.
  • Worked with Architecting team on implementing new Netbackup 7.5 and Data Domain environments, improving current infrastructure, working on DR solutions and de-duplication technology.
  • Performed capacity planning and procedures for the DR / BAR system.
  • Monitored and implemented backup and restores procedures using TARA GUI Netbackup Extension.
  • Created Arcmain scripts for one of backup and restore of small tables.
  • Configured new backup policies adding new clients and removing decommissioned ones from policy.
  • Developed statistics macros and automated to run based on the frequency.
  • Defined account IDs, priority scheduler performance groups, and system date and time substitution variables in user and profile definitions.
  • Created Teradata Data Labs (TDL) and assigning them to requesting business users.
  • Experienced in loading, archiving and restoring data and also involved storage optimization, performance tuning, monitoring.
  • Experienced in create routing rules using Unity director tool using admin command line utility.
  • Created several routing rules using create balanced option in viewpoint portlet. Created read/write preferred routing rules using admin command line utility and unity director portlet.
  • 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 software upgrades.
  • Designed DDLs and efficient PIs along with Identity keys for efficient data distribution and Assisted developers with coding and effective join issues.
  • Provided lead technical support for moving the analytical proofing data into a production intelligent sandbox environment where Data Lab provides production protection for the Database Administrator while allowing self-service provisioning and governance capabilities desired by the analytical community.
  • 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.

Environment: Teradata 14.0, Teradata 13.10, Teradata Unity, Teradata SQL Assistant, Teradata Viewpoint, BTEQ, MLOAD, TPT, ARCHMAIN, TASM, Netbackup 7.5, TARA GUI.

Confidential, Atlanta, GA

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.
  • Provided technical services in Teradata Backup, Archive and Recovery (BAR) using Arcmain and other Teradata utilities.
  • 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.
  • 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
  • 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.
  • 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.
  • Employed 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.
  • Provided effective support for Schema comparison and DDL validation.

Environment: Teradata V2R6/12, TASM, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, PMON, MLOAD, ARCMAIN.

Confidential

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.
  • 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, Assisted developers with coding and effective join issues
  • Provided technical support in Capacity planning, System software testing and benchmarking and Support and coordination during hardware upgrades. 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.
  • Wrote queries which are resource hog and fine-tuned for performance.
  • 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.

Environment: Teradata V2R5/R6, TASM, TPT, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, PMON, MLOAD, ARCMAIN, Net vault.

We'd love your feedback!