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