DIXON RODRIGUES
Gothenburg
Summary
High-performing Database Architect with 18+ years of professional experience with extensive experience in managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Saved thousands of dollars through performance tuning, there by avoided additional hardware procurement. Involved in various phases of data warehousing projects including Development, Implementation, Acceptance Testing for end-to-end IT solution offerings. Over these years, worked in various domains such as Retail, Transportation, Life Science, Insurance, Healthcare and Telecommunication.Collaborative and dedicated to improving and optimizing database performance. Smart and committed to staying up-to-date with new technologies and advancements. Team oriented with strong work ethic.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Teradata and Snowflake Database Administrator
Volvo Cars
12.2019 - Current
- Database administration such as creating database objects, creating users and granting access to them
- Fine tuning of long running, highly skewed, heavy spool consuming and high CPU consuming queries
- Saved Thousands of dollars by spending additional cost over new hardware procurement just by tuning existing applications
- Saved 162 hours of ETL execution runtime per month along with reduction in extensive utilization of system resources.
- Designing and Implementation of Teradata Workload Management
- Setting up system alerts for easy monitoring
- Building security model and also supporting adhoc requests raised by development, testing and support teams
- As part of snowflake administration, Involved in Account, warehouse, roles and user creation
- Implement Snowflake best practices for management, monitoring, and optimization of warehouses
- Recommending Snowflake best practices & considerations for managing load operations and performance
- Enforcing column-level data security using secure views and employing dynamic data masking features for data governance
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
Teradata Database Administrator
MGM Resorts International
04.2016 - 11.2019
- Creating database objects, creating users and granting access to them.
- Fine tuning of backup jobs based on system configuration and restoring data between environments.
- Capacity planning of system. Designing and Implementation of Teradata Workload Management.
- Verifying System / Database health check by generating weekly and monthly system reports. Building daily, weekly statistics jobs and scheduling them.
- Query and system performance tuning. Setting up system alerts for easy monitoring.
- Saved nearly 15 hours of execution time per week by tuning 20+ ETL job queries
Teradata Database Administrator
United Healthcare Global
07.2015 - 12.2015
- Creating database objects for tickets that application development team, Testing team and Support team had raised to their various needs.
- Involved in tuning queries which are long running
- Rigidly monitoring system for 100% availability.
Teradata Datbase Administrator
Amgen
10.2013 - 05.2015
- Setting up Structure, Database, User, role, profiles, Space as per Teradata Best Practices.
- Configuring Workload management its setup and creating different types of rules for batch and reporting users to meet their job within SLA.
- Produced high-standard database solutions to meet stability, reliability and performance metrics
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers
- Automation of backup and restore scripts and notification of jobs after completion of Backups and restore. Automation of system level utilities like showspace, showlocks, and packdisk.
- Working closely with customer and resolving day to day issues and Provide suggestion and recommendation as per Teradata best practices.
- Setting up Viewpoint Alerts for better system Monitoring.
- Working with Teradata Customer supports executive for any Production/Development database issue and interact with client accordingly
Teradata Database Administrator
Walmart
02.2012 - 10.2013
- Work with DA to translate logical data models into physical database designs and implementation.
- Space management and security
- Usage of Teradata Viewpoint for releasing Locks, killing blocking Users.
- Identifying potential bottlenecks with queries in aspects of query re-writing, skewed redistributions, join order, optimizer statistics etc.
- Migration of data between servers using WM proprietary tool called Teracopy. Perform Impact analysis/Compression analysis on tables.
- Guiding developers about Wal-Mart process over Teradata system and Load process.
- Support application development teams for database needs and guidance. Assist with Change Management related to DB Issues.
- Provide technical leadership to less experience IT staff members to develop their understanding of physical data resources.
Software Tester
T-Systems
10.2011 - 01.2012
- Carried out tests to identify, report bugs and glitches.
- Coordinated work with various teams to solve problems and improve efficiency for software testing and automation.
- Assessed software bugs and compiled findings along with suggested resolutions for development team members.
- Schema validation for new and modified data elements. ETL process and data validation between Source and tables in EDW.
Teradata Developer
Travellers, Wellpoint, IHG
11.2009 - 10.2011
- Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
- Developing and optimizing sqls to push data from stage tables to final target Fact Table
- Preparation of test cases and logging test cases
- Designed and implemented scalable applications for data extraction and analysis using Informatica 8.2 to load data from Mainframe file system into target Teradata stage tables
Teradata Performance Tuning
GE Healthcare, Orbitz, EBay
07.2005 - 11.2009
- Gathered, defined and refined requirements, led project design and oversaw implementation.
- Collaborated with system architects, design analysts and others to understand business and industry requirements.
- Developing and optimizing sqls to push data from stage tables to final target Fact Table
- Preparation of test cases and logging test cases
- Designed internal process improvements to automate repetitive tasks, shortening data delivery times
Education
Master of Science - Computer Science
Mysore University
Mysore, India 2001
Skills
- SQL Performance Tuning to core
- Database Optimization
- Teradata Database Administration
- Snowflake Database Administration
- Fundamentals of Azure platform and Administration
- Business Intelligence Project Management
- UNIX Shell Scripting
Certification
- Teradata Certified Master V2R5- 2007.
- Snowflake SnoPro Certified - 2021
- Azure Fundamentals-AZ900- 2021
- Oracle Certified Professional - 2007
- Netezza Silver Certified - 2008
Timeline
Teradata and Snowflake Database Administrator
Volvo Cars
12.2019 - Current
Teradata Database Administrator
MGM Resorts International
04.2016 - 11.2019
Teradata Database Administrator
United Healthcare Global
07.2015 - 12.2015
Teradata Datbase Administrator
Amgen
10.2013 - 05.2015
Teradata Database Administrator
Walmart
02.2012 - 10.2013
Software Tester
T-Systems
10.2011 - 01.2012
Teradata Developer
Travellers, Wellpoint, IHG
11.2009 - 10.2011
Teradata Performance Tuning
GE Healthcare, Orbitz, EBay
07.2005 - 11.2009
Master of Science - Computer Science
Mysore University
Similar Profiles
Robert VerheyRobert Verhey
Sales Director at Volvo Cars Tampa/Volvo Cars Wesley ChapelSales Director at Volvo Cars Tampa/Volvo Cars Wesley Chapel
Juan C. RodriguezJuan C. Rodriguez
Automotive Technician at Volvo Cars (DEEL Volvo, Bomnin Volvo)Automotive Technician at Volvo Cars (DEEL Volvo, Bomnin Volvo)
APRIL LYN DIXONAPRIL LYN DIXON
Team Leader at Volvo Cars USATeam Leader at Volvo Cars USA