Sql Server Dba
Resume:
Lizet Contreras
Aurora, IL *****
*********@*******.***
Professional Summary
Database Architect / Sr. SQL Server DBA
Experienced Database Architect and Senior SQL Server database administrator with over 16 years in IT, specializing in architecting and implementing complex, secure, and high-performing data solutions. Demonstrated success leading data architecture projects, migrating enterprise-scale databases to cloud environments, optimizing performance, and ensuring data integrity across highly regulated industries. Expert in Microsoft SQL Server (versions 6.5 to 2022), T-SQL, SSRS, SSIS, SSAS, Power BI, Microsoft Fabric, Azure, PySpark SQL, Spark, and data pipelines. Proficient in leveraging Copilot and ChatGPT to accelerate solution design, automate documentation, and enhance development workflows. Proven ability to design scalable architectures and lead end-to- end data modernization initiatives.
Bilingual (English/Spanish), organized, strategic, and results focused. Willing to relocate: Anywhere
Work Experience
Client
ESSC (EasterSeals-Southern California)
November 2022 to Present
· Architected and led data migration from on-premises to Microsoft Fabric.
· Designed and built a scalable cloud data platform using Microsoft Fabric, PySpark SQL, Spark, and pipelines.
· Developed ETL packages, Power BI dashboards, and implemented DevOps standards.
· Utilized Copilot and ChatGPT to automate data transformation logic and documentation.
· Achievements: Delivered robust data architecture for scalable analytics and improved data accessibility. Sr. SQL Server DBA
TDC-Hawaii
June 2019 to Present
• Architect and maintain secure, high-performance SQL Server environments
(2012-2022).
• Lead upgrades and migrations across SQL Server versions (2012 to 2022).
• Standardize database operations and implement best practices.
• Enhance security, backup, and DR strategies for mission-critical systems.
• Achievements: Migrated SQL Servers to private cloud, streamlined ETL processes, reduced downtime.
• Monitored servers using IDERA, RedGate, Solarwinds. Client
Hawaiian Electric (HECO)
November 2019 to September 2020
• Managed large-scale SQL Server environments (2008-2016).
• Created and applied database documentation, standards, and upgrade strategies.
• Achievements: Executed successful platform migration improving performance and security posture. Sr. SQL Server DBA Specialist
Senderra (via 4TH Source - AN GLOBAL)
September 2018 to June 2019
· Supported SQL Server administration (2012-2016), conducted upgrades, and implemented DRP.
· Led database standardization initiatives.
Database Architect
Edenred (via NETA Systems)
May 2017 to July 2018
· Designed OLAP solutions including cubes, ETLs, and reporting (Power BI, SSRS).
· Mentored development and DBA teams on database best practices. Sr. SQL Server DBA & Developer (Project Leader)
Actinver (via Innovasoft)
June 2015 to May 2017
· Upgraded and maintained SQL Server versions (2000-2016).
· Architected DRP, High Availability (Always On, Replication), and supported cross-platform DBs. Sr. SQL Server DBA
AON (via Praxis)
December 2014 to April 2015
• Managed SQL production systems, led DRP development and implementation, enforced database maintenance and provided performance tuning.
Sr. SQL DBA (Manager)
Royal Holiday
November 2011 to May 2014
• Directed Oracle to SQL Server migration and enforced data replication strategies.
• Applied database security policies.
• Managed the reporting team.
• Developed processes using SSIS to prepare data for end user reports. Technology Specialist (SQL Server)
DCH
July 2011 to August 2011
· Supported Dynamics AX platform, maintained SQL performance. Sr. SQL Server DBA
Consupago (via Wavezoft)
March 2011 to June 2011
· Conducted database security audits and developed best practices. Sr. Database Administrator
PagaTodo Holdings
June 2010 to March 2011
• Maintained enterprise databases and enforced data replication.
• Performance tuning.
• Applied database security.
Strategysys
DBA
September 2009 to December 2009
· Designed SSIS packages and implemented XML-based HL7 processing. DBA
MontePio (via Brendcar)
May 2009 to September 2009
· Led mass migration of over 250 databases and established maintenance routines. DBA
Actinver (via Alia)
August 2008 to May 2009
• Implemented replication and improved data security. Provided performance tunning and enforced database maintenance and created database documentation. DBA
Hewlett-Packard (via Dextra)
January 2008 to August 2008
· Normalized legacy data and upgraded systems to SQL Server 2005. Software Engineer
General Electric (via Softtek)
February 2007 to October 2007
· Developed SSIS processes and supported data warehousing initiatives. Education
M.S. in Business Analytics
UTEL-Mexico City
January 2020 to December 2022
B.S. in Computer Science
Centro Universitario Grupo Sol-Mexico City
January 2000 to December 2004
Skills
• SSIS (10+ years)
• Database Monitoring
• Database Design
• ChatGPT for automation
• DRP
• SSAS
• GitHub Copilot
• Data Modeling
• English (Advanced)
• Database encryption
• ETL Development
• documentation
• Azure
• Python
• PySpark SQL
• High Availability
• Power BI
• Log Shipping
• IDERA
• Agile Project Management (Jira, ServiceNow, Visio)
• Redgate
• SSRS
• AlwaysOn
• Cloud Migrations
• code generation
• Solarwinds
• Security and Compliance (HIPAA), Backup and Recovery
• Performance Tuning
• Spanish (Native)
• T-SQL
• JSON
• PL/SQL
• Spark
• Database security
• VMWare
• Replication
• Microsoft SQL Server 6.5-2022
• 2022
• Microsoft Fabric
• Data Pipelines
• Data Architecture
• Powershell (10+ years)
• TFS
• XML
Links
liz_50979
linkedin.com/in/lizet-contreras-9564253a
Certifications and Licenses
MCTS
MCITP
Contact this candidate