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

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship