We provide IT Staff Augmentation Services!

Teradata Database Architect Resume

SUMMARY:

  • Technically - oriented professional excelling in devising and implementing database strategies to propel information systems, products and services.
  • Over 4.9 years of experience in managing design, development, and delivery of innovative technology solutions.
  • Sound exposure of planning and administering multi-tier, highly-robust and scalable databases
  • Accompanied with expertise in project execution working closely ensuring transparent communication with customers to effectively gather requirements and mapping them into functional designs

SKILLS SNAPSHOT:

  • Database Administration
  • IT Operations
  • Operational Management
  • Technical Documentation
  • Process Management

TECHNICAL SNAPSHOT:

Databases: Oracle 9i/10g/11g, Teradata 14.10/15.10

Tools: RMAN, Data Guard, Fail Safe, Putty, PL/SQL developer, Global Gateway, BTEQ, TPT, Migration, Export/Import, SQL*Loader, ODBC Gateways

Operating Systems: Sun Solaris/Windows

ETL & BI tools: Informatica, QMF-for Workstation

Languages: SQL, Shell scripting

ORGANISATIONAL EXPERIENCE:

Confidential

Teradata Database Architect

Environment: Database: Teradata, Hadoop

Platform: Unix/Linux

Tools: Putty, Teradata SQL Asst, BTEQ, Fastload, mload, Viewpoint, Tivoli, Informatica

Responsibilities:

  • Teradata Database Capacity Planning and Management.
  • Logical and Physical Data Modelling.
  • PDCR database setup for Teradata Database.
  • Snapshot Creation, Instance Creation and Instance Decommission.
  • Viewpoint set up for new Teradata Systems and TASM rule set. User and access management on Viewpoint Servers.
  • SOX Auditing and compliance for Teradata System.
  • Supporting release management Team for deployment of Objects in SIT, UAT and OAT environment
  • Working on Defects raised by Testing Team for fixes in Teradata objects.
  • User and Access management on Teradata System(access, roles and profiles).
  • Working in project of Migration from Hadoop to Teradata Database.
  • Creating BTEQ, FASTLOAD, MULTILOAD scripts as per the requirement of Development Team.
  • Defining structure of staging tables with Proper Data type and precision on Teradata Side for efficient loading of Data from Hadoop to Teradata.
  • Reviewing and modifying the structure of Dimensions and Fact tables for better performance in Teradata.
  • Preparing technical documents like CR requests, OAT and Production implementation plans and getting it approved from Customer.
  • Supporting ETL team to resolve batch failure Issues and provide immediate solution to them.
  • Monitoring Teradata system performance through Viewpoint and proactively monitoring all the sessions run by our team, in order to avoid any blocking /system degradation.
  • Query optimization by reviewing explain plans. Performance Tuning for user and batch queries. Provide recommendation to user queries and batch queries, for enhancing their query performance.
  • Contributed in resolving Teradata connectivity issues, spool, temporary, permanent space, checking the skewness on tables. MVC Analysis for Space saving.
  • Reviewing Queries run by Reporting Team and Creating Single Table/Multitable Join Indexes to improve performance.

Confidential

Teradata DBA/ Senior Oracle DBA

Environment: Database: Teradata, Oracle, Hadoop

Platform: Unix/Linux, Windows 00 / 03 / 08

Tools: Putty, Teradata SQL Asst, SQL Loader PL/SQL Developer, DBCA, RMAN, DATAGAURD, expdp-impdp, ASM

Responsibilities:

  • Oracle/Teradata Database Design and Capacity Planning.
  • Oracle Installation and Database creation, Backup and Recovery of Oracle databases using RMAN, physical and logical backups.
  • Oracle Database Cloning using Hot and cold Backups.
  • Database Link Creation.
  • Oracle User and Access Management.
  • Performing DR drill Activities.
  • Oracle Datagaurd Configuration and Management.
  • Generating and analysing explain plans and AWR reports for improving performance.
  • Scheduled logical/physical backup jobs on daily and weekly basis on Oracle Unix/Windows Server.
  • Scheduled multiple alert jobs for easily monitoring of Oracle Databases.
  • Scheduled multiple alert jobs on Viewpoint Servers for easily monitoring of Teradata System.
  • Preparing Implementation Plan and getting it approved from approvers for OAT and Production Deployment of Objects.
  • User and Access management on Teradata System(managing access, roles and profiles)
  • Teradata sessions workload management using TASM.
  • Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes). Performance Tuning for user and batch queries. Provide recommendation to user queries and batch queries, for enhancing their query performance.
  • Contributed in resolving Teradata connectivity issues, spool, temporary, permanent space, checking the skewness on tables. MVC Analysis for Space saving.

Confidential

Senior Oracle DBA

Environment: Database: Oracle 9.2.0.8, 10.2.0.1,10.2.0.4,10.2.0.5,11.2.0.3

Platform: Unix/Linux, Windows 00 / 03 / 08

Tools: Putty, DBCA, Maximo, PL/SQL Developer

Responsibilities:

  • Created instances and databases with appropriate initialization parameters and database structures including data files, rollback segments and tablespaces.
  • Performed database cloning, DR drill Activities, Backup and recovery.
  • Effectively handled SQL performance and tuned it in addition to reviewing backup and recovery strategies
  • Ensured that load, storage, archiving, back up, restore and recovery procedures are functioning correctly in both production and test databases.
  • Reviewed and monitored system and instance resources to ensure continuous database operations. Handled key parameters such as database storage, memory, CPU, network usage and I/O contention.
  • Prepared, managed and collected information for documents like Project execution Plan, SOW, WSR.
  • Prepared and approved Change Implementation plan after reviewing it from DBA side.

Confidential

Transition Lead

Environment: Database: Oracle 11.2.0.3, 10.2.0.5

Platform: Unix

Tools: Putty, DBCA, Maximo, QMF-for Workstation, Informatica

Responsibilities:

  • Assisted as Database manager for the smooth transition of Project from EMEA to India.
  • Managed L1 DBA team of 4 members and ensured proper database access given to users.
  • Performed database cloning and DR drill Activities.
  • Analyzed database systems and scheduled daily or weekly alert jobs for the better performance and high availability of database.
  • Designed KPIs(Key Performance Indicators) for different modules of the project and defined minimum threshold target limit of each KPI to ensure better delivery of the project from the new geography.
  • Established a strong monitoring and reporting system. Worked on BI tool QMF to generate Business Reports and share these with different stakeholders.
  • Scheduled reporting jobs on BI tool QMF for the easiness of customers.

Systems Engineer (Oracle DBA)

Confidential

Environment: Database: Oracle 9.2.0.8, 10.2.0.1,10.2.0.4,10.2.0.5,11.2.0.3

Platform: Unix (Sun Solaris 5.10),Windows 00, 03, 08

Tools: Putty, Toad, DBCA, PL/SQL Developer, Remedy

Responsibilities:

  • Oracle Installation on Windows and Unix/Linux environment. Creation of databases manually and using DBCA and Manage them to ensure consistent performance.
  • Verified all instances and their scheduled backups are running normally. Resolved connectivity and backup issues in case of failures.
  • Granted privileges, roles and profiles to users according to their need and maintained system security.
  • Created and managed Database link on Oracle Databases.
  • Database Cloning and Upgrade database from 9i to 11g, 10g to 11g.
  • Created and managed standby database and performed DR Drill activities.
  • Planned and implemented Backup and Recovery strategy.
  • Physical backup using Cold/Hot backups using RMAN, logical backups using Export-Import/ Data Pump.
  • Implemented auditing for DML and user logged in details.
  • Generated explain plan, AWR, ADDM Reports for Query Optimization.

Hire Now