Computer and systems engineer passionate about acquiring and transmitting new knowledge. I have experience and knowledge from the banking, insurance and retail sector.
My journey in data began as a SQL developer, where I acquired vast code experience. I was then able to be promoted to MSSQL Database administrator role where I deepened my skills and expertise in database design, performance, monitoring and troubleshooting. I have been able to work with different database management technologies aside from SQL Server in order to diversify my DBA skills. Also I deepened my expertise in relational and non-relational databases and datawarehousing systems as well.
All that previous experience brought me to an important switch in my journey to data architecture and data engineering. My passion is data and how it empowers and brings value to its company. I'm enthusiast in identify opportunities where data can create the most impact through digital transformation.
I believe we all as tech professionals should always keep learning and searching of new skills that challenge us.
Contact Diana regarding:
Flexible work
Starting at
USD25/hour
Timeline
work
Job
school
Education
folder
Project
flag
Award
Résumé
Jobs
verified_user
0% verified
Database Administrator
Cognits an HTEC Company
Nov 2023 - Current(2 years 8 months)
Responsible for the design and implementation of transactional database architecture from scratch. I work closely with Product Owners and other key stakeholders to ensure the solution aligns perfectly with business needs, user expectations, and both functional and non-functional requirements.
• Database design: Responsible for the database architecture of a robust solution on Amazon RDS, ensuring integrity, scalability, and high performance. This involved a thorough analysis of requirements to translate the business needs into a relational model.
• Data pipelines design: I was also part of the team that designed a data pipeline that moves files on-prem to the cloud, extracting data from them to later load it into the transactional databa
SQL Engineer
BairesDev
Aug 2021 - Sep 2022(1 year 2 months)
Working as an ETL developer, writing complex SQL statements and stored procedures and designing SSIS packages for ETL solutions for an specific client overseas. Used Git for source control and Jira for work planning.
Database Administrator
Grupo Distelsa
Aug 2021 - Oct 2023(2 years 3 months)
Oversees the daily workflow of the database department, ensuring efficient operations and high performance. Responsible for the installation, configuration, and administration of local database servers, working with Oracle 11g and 19c on Windows, as well as SQL Server 2014 to 2019 on Windows, utilizing OPManager as a monitoring tool.
Projects:
• Migration of critical systems (MSSQL and Oracle) to new virtual infrastructure.
• Migration of database infrastructure from Oracle 11g to Oracle 19c on a Windows environment.
• Implementation and administration of backup management tool (Veeam Backup).
• Define and implement policies and standards for database security, administration, and maintenance.
Additionally, I provide executive suppor
Database Administrator
BAC Credomatic
Dec 2018 - Jul 2021(2 years 8 months)
Installation, configuration and administration of local database servers; working with SQL server 2008 R2 to 2019 on Windows, a bit of MySQL and PostgreSQL on Linux. Using Avamar as a backup management tool and Nagios as a monitoring tool.
Projects:
● Upgrade legacy SQL Server instances to SQL Server 2017 and 2019 in a hybrid cloud.
● Upgrade legacy MySQL instances.
● Standardize new server installations
● Standardize monitoring tasks on servers
Professor by contract
Universidad Rafael Landívar
Sep 2013 - Apr 2023(9 years 8 months)
Support in the Faculty of Engineering.
• Teaching various courses in the Computer Science axis
• Tutorial preparation for Comprehensive Assessment
• Evaluating member of shortlists for Comprehensive Evaluation and Thesis Defense
X
MS SQL Server DBA
Xerox Commercial Solutions LLC
Dec 2011 - Jun 2018(6 years 7 months)
Installation, administration and support of clusters and database servers in physical and virtual infrastructure. SQL Server versions 2000, 2005, 2008, 2008 R2, 2012, 2014 were used. SnapManager was used as a backup management tool.
Projects:
● Planning and implementing database infrastructure migration from SQL Server 2005 to SQL Server 2008 R2.
● Planning and implementation of database infrastructure migration from SQL Server 2008 R2 to SQL Server 2014.
● Planning of database infrastructure migration from SQL Server 2008 R2 to SQL Server 2014.
● Implementation of SnapManager for backup management.
C
Web Systems Analyst Programmer
Consultoría y Soluciones Tecnólogicas SA
Feb 2011 - Dec 2011(11 months)
The SQL Server Reporting Services tool was successfully implemented as a standard for the ERP reporting module sold by the organization.
M
Database Assistant / SQL-Transact Developer
MFSI
Aug 2010 - Dec 2010(5 months)
Database maintenance and development of queries, scripts, stored procedures, triggers, etc. Internal database support for development department. Worked with SQL Server 2005, 2008 and 2008 R2,
Education
verified_user
0% verified
Diploma, Professional Project Management
Universidad Francisco Marroquín
Jan 2015 - Dec 2016(2 years)
Preparation for PMP certification.
Obtain a global vision of project management, achieving excellence in execution and correctly managing the human resources, time and risk management.
Master's degree, Gestión de Sistemas de Información
Universidad Rafael Landívar
Jan 2014 - Dec 2015(2 years)
Computer and Systems Engineering, Bachelor
Universidad Rafael Landívar
Jan 2008 - Dec 2012(5 years)
Cum Laude con promedio final de 83 puntos
Projects (professional or personal)
verified_user
0% verified
Awards
verified_user
0% verified
Cum Laude
Universidad Rafael Landívar
May 2013
Graduated with Cum Laude award for completing the bachelor with final average of 83 points.