Served as application and project database administrator to support for multiple Enterprise Data Warehouse Teradata environments. Cooperate in all stages of software development life cycle (SDLC), including development, system integration testing, user acceptance testing, pre-production, and production implementation releases. Provided assistance to agile projects and DevOps teams throughout the System Development Life Cycle (SDLC) process. Coordinate with Reference Architecture and development teams on a daily basis to integrate new and updated project features. Project DBA to support multiple DevOps teams in meeting critical production implementation deadlines.• Supported business applications as the Project Application DBA including on-prem and Vantage while supporting Snowflake cloud environments (responsible user/database/table and security setup and access).• SQL Analysis and Performance Tuning experience to optimize query efficiency.• Maintained documentation for Application DBA team processes to remain up-to-date with production enhancements.• Experience with stored procedures and capacity planning to streamline and automate processes. • Collaborated with Security teams to preemptively identify and then to mitigate any security threats.

Provided application and operational DBA support for numerous Teradata platforms, including three production and one development Teradata system. Implemented performance tuning strategies as well as developed roles and security layer for database views. Implemented backup and recovery procedures with multi-value compression using TARA.

Leveraged expertise in managing physical database implementation, Teradata 13 upgrading, database roles and permissions, performance monitoring, SQL Query Tuning, Multi-Value compression, and capacity planning. Reviewed and approved data model modifications for future application development and production implementations.

Responsibilities included application project DBA support activities. Provided database performance and workload monitoring analysis and making performance recommendations.

(Customer sites: Bank of America, Bank of New York, Capital One, Navy Federal Credit Union)Overall Responsibilities:• Responsible for overall logical/physical data model ( Teradata Financial Solutions Logical Data Model – FSLDM) for data warehouse subject areas on client data warehouse environments.• Physical implementation of model (3nf), systems development, installation, and support of the ETL, software (upgrades), Archive/Recovery components for the data warehouse project.• Interfaced with Internal Business and Technology management teams while providing valuable input in formalizing Request for Information Proposals. • Senior level Application Systems & Development Life cycle expertise in the following areas: Planning, Analysis, Design, Construction, Testing, Implementation, and Maintenance of software applications in multiple environments including mainframe and client/server. • Technical responsibilities included database physical implementation, performance tuning, capacity planning, archive & recovery strategy, and performance monitoring. • Senior data warehouse consultant to provide technical support in a multitude of areas in new customer Teradata data warehouses. • Teamed with customer data warehouse staff in the following phases of the Enterprise Data Warehouse solutions methodology.