Michael Pepis
Jacksonville Beach,FL
Summary
Efficiency-driven data engineer with experience maintaining, migrating, and managing data for tier-0 applications ranging from on-premises database infrastructure to cloud-based medallion layered infrastructure. Specialized in the performance and security of critical databases as well as ELT migration processing between various heterogeneous database environments, and experience over a wide range of database platforms including PostgreSQL (Linux), DB2 for z/OS, Oracle (Linux), Microsoft SQL Server (Windows), and MongoDB.
Overview
11
11
years of professional experience
Work History
Database Administrator II
CSX
07.2015 - 04.2022
- Ensured the performance, availability, and security of a wide range of on-premises database environments including PostgreSQL, Oracle, SQL Server, DB2, and MongoDB platforms.
- Rewrote the Informatica CDC data-replication processes between DB2 and Oracle with home-grown Oracle stored procedures, saving the company $250,000 per year in licensing costs.
- Served as sole primary PostgreSQL architect and support. Designed and implemented high availability, backups and recoveries, upgrades, and change implementation for enterprise-wide PostgreSQL databases.
- Primary support for Oracle Gateway software, including DG4DRDA (Oracle-to-DB2), DP4DRDA (DB2-to-Oracle), DG4MSSQL (Oracle-to-SQL Server), and DG4ODBC (Oracle-to-ODBC) queries.
- Performed DBA responsibilities for several other database platforms including Oracle, DB2 for z/OS, SQL Server, and MongoDB.
- Administered database systems, ensuring optimal performance and security protocols.
- Monitored data integrity, resolving discrepancies to maintain accuracy across databases.
- Implemented backup and recovery procedures to safeguard critical data assets.
- Collaborated with development teams to optimize queries and improve database efficiency.
- Developed documentation for database configurations and procedures, enhancing team knowledge sharing.
- Led initiatives to upgrade database management systems, improving functionality and user experience.
Data Engineer II
CSX
04.2022 - 05.2026
- Engineered multiple layers of pipelines that move critical enterprise data from various on-premises database platforms into Microsoft cloud environment (Azure, Fabric) based on core information domain.
- Architected data pipelines that execute the flow of data between on-premises and cloud environments.
- Facilitated strategic schema redesign upon migrating data between environments with dataflow transformation processes to better fit company needs.
- Enabled medallion architecture within Microsoft Fabric including Landing, Bronze, Silver and Gold Lakehouse layers, each designated with unique archival and design.
- Worked with business partners to ensure data integrity for reporting and strategic analysis.
- Collaborated with cross-functional teams to define data requirements and architecture.
- Analyzed system performance metrics, identifying opportunities for process improvements.
- Collaborated on ETL tasks, maintaining data integrity and verifying pipeline stability.
- .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
- Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.
Education
Bachelor of Science - Information Systems
University of North Florida
Jacksonville, FL06-2015
Skills
- Database Infrastructure
- ETL/ELT Processing
- Cloud-based Medallion Architecture
- Microsoft Azure
- Microsoft Fabric
- Database Performance
- Database management
- Backup and recovery
- Database troubleshooting
- Data migration
- Query optimization
- Database design
Timeline
Data Engineer II
CSX
04.2022 - 05.2026
Database Administrator II
CSX
07.2015 - 04.2022
Bachelor of Science - Information Systems
University of North Florida