Resume

Sign in

Senior Business Solution Architect

Location:
Montreal, QC, Canada
Posted:
May 21, 2020

Contact this candidate

Resume:

Objective:

Canadian PR holder looking for Senior/Lead Teradata DBA/Performance DBA opportunity, where I can use my technical skills and experience to provide administration and support for the smooth operation of Teradata server in the organization.

10+ years’ experience in IT industry, involving a wide range of experience in Database administration (Teradata 14 Certified Professional), Analysis, Design, Implementation, development, testing, and implementation of Enterprise Data Warehouse. Extensive experience in implementation, upgrades and supporting database solutions in Teradata Data warehouse environments and SQL Server Database. Leading a team of performance analysts along with shared resources, getting them allocated to different clients and monitoring their maximum utilization.

Excellent Communication, Interpersonal, problem solving skills and Implementation skills. An effective communicator with exceptional relationship management skills, proactive attitude, good communication & presentation skills ensuring stakeholders and higher management are up to date about the updated project status. Goal oriented, creative and resourceful, with proven effectiveness in coordination and team leading capabilities along with ability to work independently.

Field of Specialization:

Teradata : Strong knowledge of Teradata database concepts and physical database design plus database

administration support for very large databases in a Teradata environment, Design, creation,

maintenance, and support of database objects based on architectural guidelines and standards,

Combined experience with ETL utilities, application support, performance tuning, user & security

administration, optimization of BTEQ/SQLs.

SQL : Configuring DR techniques like Log shipping, Replication, Mirroring and Clustering in production

environment analyze long running slow queries and tune the same to optimize application and

system performance, Rebuilding/Reorganizing indexes at regular intervals for better DB

performance proactively check SQL server performance by using Perfmon counters, Profiler,

SQL Script and other third-party tools, Implementing latest Services packs and its hot fixes,

Upgrading/Migration and consolidation of SQL Server.

Tools and Utilities : Teradata 16/15.10, MS SQL-Server 2005/2008, Putty, SSRS, SQLA, DSA, TARA, Viewpoint.

Operating Systems : Windows Server, Red Hat Enterprise Linux (RHEL), Suse Linux, HP-UX.

Databases : Teradata 16 and lower versions, SQL Server.

Education:

Master of Computer Applications – Mumbai University, 2008.

Bachelor of Science (Computer Science) – Mumbai University, 2005.

Certifications:

Teradata 14 Certified Professional.

Teradata 12 Certified Enterprise Architect.

Oracle 9i Certified Professional.

ITIL® Foundation Certificate in IT Service Management.

Additional Trainings:

Trained on Hadoop Administration at Teradata India.

Accolades:

Employee of the Quarter, Solution and Innovation Champion, Q3 2017: For achieving highest Customer Satisfaction from Pfizer.

Certificate of Excellence: For automating multiple client processes on demand, under given timelines, at Infosys BPO Ltd for client P&G.

Professional Experience:

CLEARGOALS, Montreal 04/19 – till date

Senior Business Solution Architect

Bell Canada

Consulting on physical database implementations, PPI, skew analysis, join methods, and data access paths.

SQL query re-writing.

Creating runbooks and technical documentation for the team. Ensuring higher management is aware of all latest project updates.

Developing modules to extract, process & transfer the customer data using Teradata utilities.

Teradata, Mumbai 05/12 – 03/19

Technical Lead (Performance DBA)

Pfizer, Bank of America, Optus Australia Pharmaceutical, Investment Banking, Telecom

Managing Teradata Workload Management - designing and creating workload groups, priorities, throttles, etc.

Leading a team of 4 resources, guiding them with the directions, leadership on performance project.

Understanding the specification and analyzed data according to client requirement. Extensively worked in data Extraction, Transformation and loading from source to target system using BTEQ, FastLoad, and MultiLoad.

Identifying performance issues on system and providing applicable solutions using optimal use of statistics, recommending indexes, query rewrite or by using workload management.

Performance tuning, including collecting statistics, analyzing explains & determining which tables need statistics.

Supporting multiple Teradata systems including independent marts, development/UAT, disaster recovery, and the enterprise warehouse production environments.

Created Fast Load, Fast Export, Multi Load, TPUMP, and BTEQ to load data from Oracle database and Flat files to primary data warehouse.

Consulting with different stakeholders, project teams and client management to facilitate proper communications to avoid any confusions.

Pfizer Automation

Automated scripts to find mount disk space and generate alerts when threshold limits are met, via shell scripting.

Automated Processes such as executing weekly procedures and validate the results via shell scripts.

Alert setups, Notifications and scheduling shell scripts using CRON jobs.

William Sonoma Inc, American Express Retailer, Financial Services

Automated Stats collection process using BTEQ script.

Polaris Software Labs, Mumbai

RBI Central Bank 10/11 – 05/12

Day to day DBA activities like managing the databases, users, roles, profiles & access in both Live & DEV including 24 * 7 DBA Support.

Releasing hut locks, preventing blocking during Teradata backup jobs.

Using Subqueries and joins to fetch reports.

Writing Teradata sql queries to join or any modifications in the table.

Rosy Blue India, Mumbai

Rosy Blue India Diamond Manufacturing 01/11 – 10/11

Restoring the database as and when required.

Creating Replications.

Installation of MS SQL Server 2005 in cluster environment.

Implemented latest Services packs and its hot fixes

Infosys BPO Ltd, Pune, India 07/09 – 12/10

Procter and Gamble (P&G) Ltd Consumer Goods

Installing and configuring SQL Server 2005/2008 Database on Windows.

Day-to-day monitoring of database. Checking daily back-ups.

Proactively check SQL server performance by using Perfmon counters, Profiler, SQL Script and other third party tools.



Contact this candidate