Senior Database Administrator/Engineer

Roderick David

Atlanta, GA 678-***-**** *********@*****.***

Summary:

Results-driven Senior Database Engineer with fifteen years of extensive experience managing and optimizing enterprise-level Data Warehouse (EDW) applications, including Teradata and Snowflake. Proven track record in performance tuning, security administration, capacity planning, and implementing robust data management solutions. Expert in leading cross-functional teams, mentoring junior DBAs, and promoting innovative solutions to improve database efficiency, performance, and security.

Areas of Expertise:

Database Administration & Security Controls: Implementing security measures and access controls to safeguard data.

SQL Performance Tuning & Optimization: Analyzing and optimizing complex queries to improve performance.

Capacity Planning & Statistics Management: Forecasting storage needs and resource allocation for scalability.

Process Automation & ETL Solutions: Designing automated processes to streamline data integration and ETL pipelines.

UNIX/Linux & Windows Environments: Expertise in command-line operations and system management.

Cross-Functional Collaboration: Partnering with DevOps, Business Analysts, and Security Teams to meet project goals.

Cloud Technologies: Experience with Snowflake and AWS (S3, EC2) for cloud-based data platforms.

Technical Proficiencies:

RDBMS: Teradata Database Tools & Utilities 17.20 (SQL Assistant, Stored Procedures, FastLoad, MultiLoad, FastExport, BTEQ, TPT, DBQL, TASM/ TDWM, VIEWPOINT)

Cloud Services: Snowflake DB, AWS (S3 cloud storage)

MS Office Suite: Excel (pivot tables), Word, Powerpoint, Outlook.

Data Modeling Software: ER/Studio, Power Designer 16.7

ETL/Reporting Tools: Ab Initio, Informatica PowerCenter,Tableau, Terraform (IaC)

Infrastructure Tools: BAR (DSA), Veritas NetBackup

Operating Systems: Windows Server, UNIX System V, HP-UX

Languages: C, Sybase SQL Server 10.0, Tuxedo, TERADATA RDBMS & SQL

Automation & Scripting: Linux/UNIX Shell Scripting

Networking & Security: Network Data Mover, WSFTP (PuTTY)

Change Management: ServiceNow, Jira

Backup & Recovery: Veritas NetBackup, BAR (DSA)

Accomplishments:

Relationship Management: Cultivated and maintained long-term relationships with key business partners to proactively anticipate data demands and optimize the usage of existing data warehouse resources, leading to a 20% reduction in resource allocation costs.

Data Architecture Standards: Maintained robust data architecture standards, enhancing system design efficiency and improving data retrieval times by 30%.

Team Development: Proactively upskilled client DBA team members on best practices in Teradata configurations across Development, Test, Integration, and Production environments, resulting in improved team efficiency and skill sets.

ETL Enhancements: Designed and implemented new ETL solutions for Data Warehouse environments, improving data processing speeds and increasing capacity planning accuracy by 25%.

Database Optimization: Examined and optimized query execution plans, achieving significant performance enhancements that reduced average query run time by over 35%.

Compression Techniques: Designed and Executed multi-value compression (MVC) routines across databases, successfully reclaiming 15–25% of storage capacity and resulting in substantial cost savings regarding database maintenance and performance.

Performance Metrics: As Lead Database Administrator Consultant, established new performance metrics, leading the team to adopt the best practices for SDLC methodologies and improving overall project delivery timelines.

Professional Experience:

Elevance Health (Carelon Digital Platforms), Atlanta, GA

Senior Database Administrator /Engineer

April 2014 – October 2023

Performed as Lead Project DBA for multiple business applications residing on the Enterprise Data Warehouse Teradata (17.20) RDBMS environments, ensuring the seamless execution of all phases of the SDLC, including development, integration testing, user acceptance testing (UAT), and production deployments.

Supported business applications as both Application DBA and Project DBA, including on-prem and Snowflake cloud environments, directly managing user, database, table setups, and access security protocols.

Conducted in-depth Dynamic SQL performance analysis and tuning sessions, resulting in a marked increase in overall system efficiency and user satisfaction.

Collaborated with IT security teams to preemptively identify potential security threats, implementing effective countermeasures that ensured HIPAA compliance while protecting patient health information (PHI) with healthcare regulations.

Developed and maintained automated ETL pipelines in Python to support data integration between Teradata and Snowflake, leveraging AWS S3 and EC2 services.

Worked on migration efforts for Teradata on-premise to Snowflake on AWS, involving all phases of the SDLC.

Strong communication and productive partnership with analysts, devops, and business leaders.

Provided critical Tier II on-call production support for fast problem resolution and maintaining system availability.

T-Mobile, Atlanta, GA

Senior Database Engineer (Consulting Engagement)

October 2010 – January 2014

Provided comprehensive DBA support for multiple Teradata environments, including three production instances and one development instance, enabling optimal performance and reliability.

Streamlined Dynamic SQL indexing and partitioning strategies, boosting query performance and reducing downtime.

Supported and maintained Reference Data Management (RDM) process to improve data governance quality management.

Led performance tuning initiatives for critical databases and developed security protocols for database views, resulting in increased security and improved access management.

Instituted robust backup and recovery procedures utilizing multi-value compression to enhance data recovery processes and operational resilience.

Centers for Medicare and Medicaid Services (CMS), Remote USA

Senior Database Administrator/Engineer (Consulting Engagement)

July 2007 – August 2010

Managed physical database implementations and upgrades for Teradata 13, focusing on roles, permissions, and performance monitoring metrics which led to a smoother application development lifecycle.

Reviewed data model modifications for compliance with industry standards, facilitating better application development and streamlined production implementations.

Responsible for the design and implementation of ETL strategies for multiple file formats including .csv files to the Teradata database platform.

Education:

B.A. in Marketing/Business Administration

Wilmington College of Ohio

Professional Development: On-going Snowflake/AWS on-demand and certification courses.

Contact this candidate