We provide IT Staff Augmentation Services!

Senior Technical Consultant Resume

3.00/5 (Submit Your Rating)

Richardson, TX

Hire Now

SUMMARY

  • Teradata Database Management & Administration.
  • Design, Setup & Manage Teradata Active System Management ( TASM ) rules.
  • Performance Management, Analysis & Optimization.
  • Query Tuning activities in mixed temperature environment.
  • Backup, Recovery & Archive solutions design & implementation.
  • Point in time recovery using Journaling.
  • Compression Analysis & implementation for block level, algorithmic & multi - value compression.
  • Migration & Upgrade of Teradata database across different versions.
  • System Monitoring & Alerting setup using Viewpoint.
  • Assisting clients with development and management of standards-based enterprise strategic technical Data Warehouse based on and aligned with the client’s business objectives.
  • Leading & Mentoring team.

TECHNICAL SKILLS

Teradata: Teradata Database V2R6, 12, 13.10, 14.10

Oracle: Oracle 9i, 10g

Unix: Simple Shell Scripting

Other: C++, VC++, Visual Basic, Java, PL/SQL

PROFESSIONAL EXPERIENCE

Senior Technical Consultant

Confidential, Richardson, TX

Responsibilities:

  • Lead Teradata Consultant for Data Warehouse at Client location assignment.
  • Teradata Database Management & Administration.
  • TASM - Addition & Management of workloads, filters & throttles.
  • Query tuning activities for performance optimization.
  • Performance reporting and analysis using PDCR & DBQL.
  • Backup, Recovery & Archive activities and backup optimization.
  • Multi Value & Block level compression analysis and implementation.
  • Database upgrade activities from 12.0 to 13.10.
  • Co-ordination for Hardware upgrade.
  • Database design & setup in the development phase.
  • Leading the Teradata DW team at client location.

Confidential, Menomonee Falls, WI

Responsibilities

  • Lead Teradata Consultant for Data Warehouse at Client location assignment.
  • Database design and setup for new Data Warehouse implementation.
  • TASM rules design & implementation.
  • Backup, Archive & Recovery setup & structuring of backup jobs using NetBackup.
  • Query Tuning activities for performance optimization to meet client SLAs.
  • Performance Reporting & analysis using PDCR.
  • Multi-value compression for space optimization.
  • Single Teradata point of contact for Terdata’s Managed Services.

Confidential, Rochester, NY

Responsibilities

  • Lead Teradata Consultant for DW from Offshore location in Mumbai, India.
  • Database Administration & Management.
  • Backup, Archive & Restore operations using NetVault.
  • Full DWH restoration on Disaster Recovery site.
  • Query tuning activities for performance optimization.
  • Performance Reporting using PDCR & DBQL.
  • Compression analysis & Multi value compression for space optimization.

Confidential

Database Operations

Roles & Responsibilities

  • Leading team of 5 DBAs in client support environment for Oracle / SQL Server database support for multiple datacenter locations.
  • Resource management and assignment for different client accounts.
  • Setup & optimization for Oracle databases for various clients.
  • Setup & management for Oracle RAC for clients.
  • Design & implementation of various replication strategies for clients in Production & Disaster recovery sites.
  • Mentoring team for Oracle Database Administration activities.

Confidential

Systems Executive

Roles & Responsibilities

  • Oracle Database Administration & Management.
  • Security management for Oracle database.
  • Integration of Oracle with LDAP for single sign-on authorization.
  • Oracle RAC setup & management in test environment.

Confidential

Database Administrator

Responsibilities

  • Installation & Administration of Oracle Databases.
  • User accounts, roles & profile management.
  • Object management & creation
  • Tablespace management for various databases.
  • Backup & Recovery solutions for Oracle database.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship