Summary
Overview
Work History
Education
Skills
Timeline
Generic

Jeremy Rivera

Edna,TX

Summary

Experienced database administrator with over two decades of expertise in database development and production environments. Demonstrated proficiency in implementing robust security protocols, performing comprehensive database maintenance, and establishing critical backup and recovery strategies to ensure data integrity and protection.

Overview

21
21
years of professional experience

Work History

Database Administrator

CPS Energy
10.2019 - 10.2024
  • Streamlined backup and recovery processes, enhancing overall system stability and availability.
  • Ensured database security with implementation of role-based access control and regular vulnerability assessments.
  • Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
  • Modified databases to meet needs and goals determined during planning process.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Conducted regular audits of data quality, identifying inconsistencies and implementing corrective actions as necessary.
  • Diagnosed and resolved complex databases performance challenges while providing technical support to cross-functional development teams.

Database Engineer

Frost Bank
09.2007 - 05.2019
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Reduced operational costs with strategic consolidation of database servers, maximizing resource utilization.
  • Identified opportunities for cost savings through effective capacity planning and resource allocation decisions in large-scale database environments.
  • Collaborated with cross-functional teams to develop scalable, high-performance database solutions.
  • Implemented automated testing frameworks for database systems, ensuring reliability and stability across updates.
  • Conducted regular audits to identify areas of improvement in database management practices, leading to increased efficiency.
  • Reduced system downtime, proactively monitoring databases and addressing potential issues before they escalated.
  • Boosted team productivity by introducing collaborative tools for database development and maintenance tasks.

SQL Server Database Administrator

Texas Department of Transpotation
06.2003 - 09.2007
  • Maintained complex SQL queries, views, and stored procedures in multi-database environment with little supervision.
  • Documented analysis results and provided performance improvement feedback.
  • Developed custom database objects, stored procedures, and delivered application support.
  • Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
  • Supported projects enabling delivery efficiencies and technical resolution.
  • Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.

Education

Bachelor's Business Admin. - Computer Information Systems

Texas A&M University
Kingsville, TX
05.1998

Skills

  • Database management
  • Backup and recovery
  • Database monitoring
  • Database troubleshooting
  • SQL proficiency
  • Presentations
  • Data security
  • Attention to detail
  • Team collaboration
  • Forklift operation
  • Flexible schedule
  • Relationship building
  • Phone etiquette

Timeline

Database Administrator

CPS Energy
10.2019 - 10.2024

Database Engineer

Frost Bank
09.2007 - 05.2019

SQL Server Database Administrator

Texas Department of Transpotation
06.2003 - 09.2007

Bachelor's Business Admin. - Computer Information Systems

Texas A&M University
Jeremy Rivera