We provide IT Staff Augmentation Services!

Accountable For Dba Resume

SUMMARY

  • Gained extensive exposure for several support issues related to Data warehouses worldwide at Confidential offshore unit, for some of the very well - known global clients.
  • Provided Teradata DBA Support for the World’s Largest Retail Datawarehouse Installation of Confidential

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: NCR 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

Accountable for 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 TSET info to Teradata GSC 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.

DBA Support

Confidential

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

Hire Now