We provide IT Staff Augmentation Services!

Senior Database Administrator - Teradata Dba Resume

Tampa, FL

SUMMARY:

  • A seasoned IT professional with over 16+ years of commendable success in Teradata Production DBA Support, Teradata Application DBA Support, Application Development and Implementation & Project Management.
  • Well versed with Teradata Database Administration, Performance Tuning and Workload Management and various Teradata Load Utilities; Data warehousing concepts, Backup Tools such as NETVAULT, ARCMAIN and in programming using PB, C, C++, Dev. 2000 with Access, Oracle and Teradata.
  • A keen strategist, planner and implementer with expertise in devising strategies aimed at enhancing overall organizational growth, sustained profitability of operations and improved business performance.
  • Possess credibility & personal integrity that leaves lasting impression with corporate decision makers, motivates employees and generates loyalty.
  • In - depth expertise in all aspects of the SDLC including requirement analysis, design, development, testing, troubleshooting and debugging.
  • Strong collaboration, team building, interpersonal, communication skills with proficiency at grasping new technical concepts quickly & utilizing the same in a productive manner.

KEY RESULT AREAS

  • Project Management * Database Administration *Application Programming Relationship Management * Maintenance * Team Management SDLC * Software Analysis * Client Relationship Management
  • Interacting with customer & team for requirement gathering, risk assessment, finalization of technical specifications.
  • Developing plans & schedules, resource allocations as per budgets, manpower deployment and team meetings for individual projects.
  • Interacting with team members to ensure smooth progress of project work.
  • Interfacing with clients for business gathering, conducting system analysis and finalizing technical / functional specifications and high level 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, development, testing, troubleshooting and debugging of the software.
  • Create, maintain, and support Database architectural environment.
  • Devise strategy for Backups, recovery & fine-tuning.
  • Workload Management, Capacity Planning, user maintenance, database security imposition; performance analysis of application and database.
  • Meet deadlines without compromising quality norms and adhering to SLA. Delivery Management & Post Implementation support.
  • Understand & co-ordinate client’s needs / enhancements, customization, software-related issues, provide solutions in adherence to delivery schedules.
  • Achieve customer satisfaction by ensuring service quality norms and building the brand image by exceeding the customer expectations.

TECHNICAL SKILLS:

Database: Teradata

Other Databases: Oracle

Tools: & Utilities Teradata Viewpoint, TASM, Teradata Administrator, SQL Assistant, Fast Load, Mload, PDCR, Arcmain, TSET, Visual Explain, Console, Ferret, LocksDisplay, DBS Control, BTEQ

Languages: SQL, PL/SQL

Backup Tools: Netvault, HP Openview, Legato

ETL Tool: Informatica

Operating System: UNIX (MP-RAS, Linux, Solaris, HP-UX), Windows

Hardware: Confidential WorldMark 5250/5350/5450/5400/5500/6700 Servers, Teradata Appliance

Front-End Tools: PB, Developer2000/6.

Data Modeling Tools: S-Designer, Erwin, Designer2000

Technology: Datawarehousing

Business: Telecom, Retail

Additional Trainings: Received Training in SQL-H of Big Data Hadoop and Aster.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Senior Database Administrator - Teradata DBA

Responsibilities:

  • Migration of various application databases from Oracle to Teradata.
  • Develop 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 various 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 saving by implementation of MVC and Block Compression restores.
  • Creation of Backup and Restore/Copy Strategies.
  • Creation of new Functional ID’s for Application/Batch after reviewing/optimizing Sql’s.
  • Creation/Granting/Revoking of Roles, Privileges to Normal and Secured Databases.
  • Be the main contact for issue resolutions and be an efficient Teradata DBA.
  • Create, maintain, and support Teradata architectural environment.
  • Setting up of alerts, canary queries, etc.
  • Creation of Macros; Space Management; Database Up-gradation and Migration Activities.
  • Upgradation and usage of PDCR.
  • Resolve any Teradata related issues raised by business users and application teams.
  • Support the application development teams for database needs and guidance
  • Support of production processes through tickets
  • Sending of Confidential info to Teradata Confidential support via incidents for their in-house problem re-creation.
  • Respond to change requests to create, change, or delete database objects (tables, views, indexes, DDL, DML, etc.) per client specifications.
  • Received Training in SQL-H of Big Data Hadoop and Aster.

Confidential, Bentonville, Arkansas

Senior Manager - Teradata DBA

Responsibilities:

  • Be the main contact for issue resolutions and be an efficient Lead DBA.
  • Create, maintain, and support Teradata architectural environment.
  • Migration of various application databases across servers for load balancing.
  • Query Tuning which resulted in significant CPU savings which goes as quarterly reports to upper management equated as Dollar Savings.
  • Creation of new DBC ID’s for Application/Batch after reviewing/optimizing Sql’s
  • Grant/Revoke of Additional Roles, Privileges to Normal and Secured Databases.
  • Monitoring and maintenance through Teradata Viewpoint.
  • Using Teradata Manager to set alerts, canary queries, etc.
  • Creation of Macros; Space Management; Database Up-gradation and Migration Activities.
  • Resolve any Teradata related issues raised by business users and application teams.
  • Support the application development 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, views, indexes, DDL, DML, etc.) per client specifications.
  • On-call support
  • Provide Level 2 & 3 support

Confidential

Project Manager - Teradata Lead DBA

Responsibilities:

  • Key Stakeholder Management
  • Provide visibility to support managers and concerned stakeholders
  • Suggest and Implement Service Improvement Plans from time to time
  • Project review report from time to time
  • Be main contact for issue resolutions and be an efficient Lead DBA
  • Create, maintain, and support Teradata architectural environment
  • Administration of production objects in change control environment
  • Development of pro-active processes for monitoring capacity and performance
  • Frequent MVC analysis for space saving.
  • 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 effectively utilized.
  • Database security administration.
  • Database Backup, Archival & Restore using Netvault.
  • Coordinating with Teradata Confidential for upgrades, patch installation, etc.
  • Weekly meetings with the Client and the dedicated Confidential personnel.
  • Running utilities like checktable, scandisk, etc
  • On-call support
  • Provide Level 2 & 3 support

Hire Now