DR Maintenance, DBA Resume

SUMMARY

Database management - Creating Roles, Profiles, Users, Databases, objects, managing access rights
Performance Tuning, review and deployment of production code
Build and Manage DR process and support Data Movement jobs
Design and Manage Archive Purge Process for applications
Capacity Planning, Space monitoring and maintenance
Archive/Backup and Restore using NetVault/ArcMain
Generation of Performance Reports from DBQL (PDCR Reports)
Process optimization for better application and system performance.
Worked on Disaster Recovery and ensuring Teradata Objects are restored in time and online to the Users.
Worked on Sybase to Teradata migration and DB2 to Teradata migration.
Worked on Datacenter Movement and Teradata Database Upgrades
Query, DM job and System Monitoring using Teradata View Point.
Developing Macros, Procedures, TPT, Mload, Fastload, Fexp, Bteq and Tpump Scripts
Adhoc User Requirement reporting
Design and Development of job flows and scripts for various phases -SIT, UAT, SAT, testing and productionization
Scheduling and Monitoring Jobs via TWS, JSC, EE, Crontab, Autosys Tools
Version controlling via SCCS, CVS SVM
Client calls coordination and requirement gathering
Communicate/Guide team to complete the assignment
Support Activities, Investigate and Mitigate Jobs abends and resolve Data discrepancy and Providing workarounds
Recourse Management, Billing and Project Budgeting
Knowledge on Hadoop platforms,
Knowledge of Data Domain Teradata DSA
Knowledge of TASM
Worked in Airlines, Telecom and Banking & Risk Domain,
Worked on CLDM, FSLDM .

TECHNICAL SKILLS

Operating systems: IBM MVS/TSO, Windows (95/98, NT/2000), Linux

RDBMS: Teradata, Sybase, Oracle

Programming Languages: SQL, PL/SQL, JCL,Shell Scripting

ETL Tools: Informatica, ODI

Tools & Utilities: TTU (TPT,BTEQ, Fast Load, Multi Load, Fast Export, TPUMP), Teradata SQL Assistant, Teradata Studio, Teradata Administrator,DM, PMON, TQS, Viewpoint, Net vaultScheduler Autosys, CVS, EE, TQS, TWS, Crontab, SCCS, JSC

Versioning tools: SVN, CVS

ITSM: Remedy, Nexus,ServiceNow

PROFESSIONAL EXPERIENCE

Confidential

DR Maintenance, DBA

Responsibilities:

DR Maintenance- Build and Manage DR process on AML applications and support Data Movement jobs.
User and Access Management
Performance monitoring, tuning, code review and deployment.
Capacity management and space approvals, allocation
Monitoring and managing CPU/Space utilization and ongoing system and application performance
Worked on Teradata 15.10 Upgrade Support.
Worked on Disaster Recovery and ensuring Teradata Objects are restored in time and online to the Users.
Design and Manage Archive Purge Process for Base View Application.
Supporting system maintenance and upgrades.

Confidential

Team Lead

Responsibilities:

DBO Migration project Lead- Sybase to Teradata migration with metadata Driven Framework MDF.TD Object creations, maintenance and access rights .
Capability Assessment Project -Recommend better opportunities plan and solution to pain points in IDN/GDAC. Worked on information gathering on overall IDN Process (EE, Skew Procedures, Defect Areas, Criticalities).
IDN Support Lead - Maintenance, Support, System performance management and Level 3 defect fixing.
Performance Management -Query Tuning and System Performance monitoring. Database objects creation and Space Management.

Confidential

Teradata DBA, Operations and Development Lead.

Responsibilities:

Teradata DBA - Tuning, System Performance management, Designing, Creating and Maintenance of Data marts, Teradata Objects, Space and Access Management. DR Maintenance.
Datacenter Movement and Database Upgrade from V2R6.2 to TD12.
BI-DW Operational Management and Enhancement

Confidential

Application Support, Maintenance and Enhancement, Adhoc Reporting

Responsibilities:

Application Support Maintenance and Enhancement on Quantas CDW (Corporate Data Warehouse).
WORLDNET -Decision Support System (DSS) Adhoc Reporting o Qantas and its Alliances business for analyzing the business performance.
FMS (Financial Management System) Migration from DB2 to Teradata
AML (Anti Money Laundering). Migration from DB2 to Teradata.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship