Management Information Technology

Biren Vora

Sr.Technical Consultant

Education:

Master Of Computer Application (MCA), IGNOU

Qualifications and Certifications:

TD – 12 Teradata Certified Administrator

ITIL V3 Foundation

Oracle 9i OCP

Training

Teradata Database 12, 14.10 & 15

Oracle 9i, 10g

ITIL

PMP

ETL Tool - Teradata Decision Expert (TDE)

Awards/Recognition:

Teradata ADC Employee of the Year Award 2010

Teradata ADC Project Long Service Award 2011

Teradata ADC Long Service Recognition 2012

Teradata Consulting Excellence Award 2012

Profile and Experience:

Biren Vora is an experienced IT professional with an experience of 13 years in Information Technology on various domains such as Retail, Telco, Banking & Finance. He is having around 12 years of experience in administering databases like Teradata, Oracle & SQL Server. He has proven abilities in leading large data warehouse DBA teams and providing efficient support and achieving customer confidence. He has good client-facing skills, outstanding project success record and communication skills. He won many accolades from the customers for extending his proactive support.

Primary Area of expertise:

Excellent hands on in configuring TASM (Teradata Active System Management) and proficient in identifying performance and resource bottlenecks and resolving them.

Expertise in tuning SQL-Queries, defining efficient PI, making index choices and identifying application tuning aspects affecting the performance of both data loading and retrieval.

Expert knowledge in defining roles and profiles to handle various security requirements and system resources

Excellent communication skills and thorough in tracking Issues, Risks and Actions and coordinating with various stakeholders in the data warehousing environment

Proficient in designing and implementing backup solutions for very large data warehouse implementations with various components such as Data Domain/Tape-Media silo/ Media-Servers/ Media-Management tool like NetBackup and top interface layer of TARA-GUI & DSA.

Defining standards for SQL code, database design and PDMs both from performance and security stand point.

Expertise in implementing and Administering Teradata Decision Expert (TDE) ETL tool.

Expertise in implementing DBA services on Teradata warehouse such as DBQL setup, PDCR implementation, Resusage setup, function based roles, profiles and account strings.

Expertise in multiple database platforms such as Oracle 8i to10g & SQL Server2005

Project experience:

Company : Teradata Operations INC

Client : Cummins INC

Duration : March 2015 to till date

Role : Onsite Coordinator, Sr. Technical Consultant

Responsible for:

Onshore lead for Teradata Managed Services DBA team

Thorough understanding of the Data warehouse environment and DBA responsibilities and documenting it to operations manual.

Real-time and historical monitoring of system performance to identify and eliminate or otherwise solve performance anomalies through Viewpoint.

Tuning OBIEE queries.

Analysing data models and recommending changes to existing models

Materializing frequently used complex views and reduces CPU usage enabling additional applications to be moved to existing system without up-gradation.

Reviewing new Business Objects modules and performing pro-active tuning before move to production.

Recommending Index option to avoid full scan of the large tables that helps in CPU and Elapsed time of the query.

Recommending vertical and horizontal partitioning option to minimize the IO consumption and help queries perform better.

Recommending usage of query banding feature of Teradata to identify the problematic areas.

Generate client requested reports like CPU Utilization, Database growth, Query history, Spool utilization etc.

Worked on ETL aspects primarily on TDE as ETL tool.

Proficient at MVC analysis/implementation.

Implemented/Designed BAR policies, volume pools, media groups based on Client’s BAR strategy.

Written shell scripts to automate all core DBA activities

Implementing and maintenance of Auto Collect statistics process using shell script and scheduled by cron/scheduling tool.

Company : Teradata India Pvt. Ltd

Client : ROGERS Communication

Duration : June 2009 to Feb 2015

Role : Lead, Production DBA team

Responsible for:

Offshore lead for Teradata Managed Services DBA team

Thorough understanding of the Data warehouse environment and DBA responsibilities and documenting it to operations manual.

Implemented workload management on the system to yield improved workload distribution and customized delegation of resources among the various workloads

Real-time and historical monitoring of system performance to identify and eliminate or otherwise solve performance anomalies through Viewpoint.

Tuning highly skewed/CPU consumed queries based on PDCR reports

Recommending Index option to avoid full scan of the large tables that helps in CPU and Elapsed time of the query.

Recommending vertical and horizontal partitioning option to minimize the IO consumption and help queries perform better.

Recommending usage of query banding feature of Teradata to identify the problematic areas.

Generate client requested reports like CPU Utilization, Database growth, Query history, Spool utilization etc.

Proficient at MVC analysis/implementation, PI revision/implementation, PPI implementation and table rebuilds as year-end activities.

Worked on ETL aspects primarily on TPT scripts writing. Worked on other Teradata Tools and Utilities including Fastload, Multiload and Fastexport.

Implemented/Designed BAR policies, volume pools, media groups based on Client’s BAR strategy.

Written shell scripts to automate all core DBA activities

Implementing and maintenance of Auto Collect statistics process using shell script and scheduled by cron/scheduling tool (Control-m).

Actively involved in hardware expansion activities. Acted as vital link between Rogers & Teradata CS and ensured smooth completion of each activity well within timelines.

Company : Teradata India Pvt. Ltd

Client : ROGERS Communication

Duration : December2008 to May 2009

Role : Onsite coordinator, Teradata DBA

Responsible for:

Support to Migration team to migrate Database environment from Netezza to Teradata

Setting up of Teradata development, UAT & SIT environment for Test & System Integration.

Migration of Database Objects from Netezza to Teradata

Coordinating with the development teams for scheduled migration releases.

Setting up of Teradata Production Environment using Teradata Best practices.

Implemented DBA services on Rogers production environment such as DBQL setup, PDCR implementation, Resusage setup, function based roles, profiles and account strings.

Transition of DBA support

Thorough understanding of the Data warehouse environment and DBA responsibilities and documenting it to operations manual.

Company : Teradata India Pvt. Ltd

Client : BestBuy Inc.

Role : Teradata DBA

Responsible for:

Creating users and granting access/privileges based on requirement without impacting the Security policies.

Continuous monitoring of the batch jobs/SQL’s triggered by Business End Users and Power Users.

Creating Roles and Profiles according to the user groups.

Writing COLLECT STATS scripts based on the existing as well as adhoc queries and ETL loading scripts.

Regular maintenance activities like Defrag and PackDisk.

Coordinating with Backup Administration Team for taking regular full backup based on the requirement.

Catering to Adhoc requests (e.g. Creation of Database Objects, Granting privileges to a user/role, Resetting the password /Releasing the password lock for a user etc.)

Housekeeping activities (Purging of DB objects according to the company policies).

Enabling DBQL for the business users and using it to analyze the badly performing queries.

Run weekly and monthly resource usage reports, analyze them and provide recommendations when required.

Company : BAeHAL Software Ltd

Client : HAL

Duration : September 2006 to October 2007

Role : Lead, Oracle DBA

Responsible for:

Installing Oracle 10g on IBM-AIX environment.

Performance details database performance checks using STATSPACK, Utlbstat & Utlestat and other scripts and optimizing performance if necessary.

Reorganized databases to avoid disk rotation for maximum performance.

Created various RAW Partitions for the database and symbolic links to access these Raw Partitions from the Oracle Database.

Implemented Partitioning on huge tables to improve the performance and reduce the maintenance.

Used Query Rewrite on some tables to improve the performance of reports.

Analyzing daily jobs and suggesting enhanced feature to improve the performance.

Executed the Scheduled deployment activities on production.

Done Database reorganization regularly to remove row migrations and fragmentation using export and import utilities.

Setting up Backup and Recovery procedures using RMAN.

Responsible for Logical, Cold and Hot backup of the database regularly.

Controlling and monitoring of users access to the database including granting and revoking of privileges and roles and tablespace quotas.

Creation and Management of tablespaces, tables, indexes, views, integrity constraints, synonyms.

Monitoring database activity and efficiency of object usage.

Data refresh between production and test environment.

Interacting with Oracle Support Services for customized patches for environment.

Company : Zenith Infotech Ltd.

Client : Central Bank Of India

Duration : September 2003 to August 2006

Role : Oracle DBA

Responsible for:

Providing Database solutions, Maintenance of Oracle 9i Database server on Linux and Windows Platforms.

Define database architecture and strategy to support the business objectives of the Client.

Monitoring of Tablespace, Space Management, and Index Management.

Designed and Implemented database strategies like Archive Log Mode and Non-Archival Log Mode, Backup/Restore, Standby Server etc.

Cold & Hot Backup, Import & Export and also create script for scheduled backup on different OS Platforms.

Monitoring of Tablespace, Index Management and Tuning Of Server.

Data Migration from Legacy System or Manual to Oracle Database.

Creation and management of rollback segments &Table spaces.

Creation of users, granting roles and privileges to users, designing & maintaining security using Oracle Enterprise Manager.

Configuring Recovery Manager.

Developing Stored Procedures, Functions, Packages, and database Triggers.

Coordinating with a team of developers for implementing the system and changes required from time to time.

Company : Zenith Infotech Ltd.

Client : Allahabad Bank

Duration : October 2005 to August 2006

Role : SQL Server DBA

Responsible for:

Performing the Scheduled deployment activities on production.

Creating plans and implementing plans for backups and maintenance jobs.

Monitoring replication and data push activities.

Migration the databases as requested by the users for testing.

Maintaining the disk spaces.

Creating logins and granting permissions to users for database access.

Monitoring the alerts.

Tuning queries for developers.

Career History:

Name of the Company

Duration

Position

Teradata US

March 2015 to till date

Sr Technical Consultant

Teradata India

October 2007 to February 2015

Associate Lead Technical Consultant

BAeHAL Software Ltd

September 2006 to October 2007

Sr Oracle DBA

Zenith Infotech Ltd

September 2003 to August 2006

Oracle DBA

PC Infotech

January 2002 to September 2003

Oracle Developer/Instructor

Contact this candidate