Iván Guillermo Aldana
Verified Expert in Engineering
Performance Tuning Developer
Yerba Buena, Tucumán, Argentina
Toptal member since April 16, 2019
Along with having a bachelor's degree in systems engineering from Universidad Tecnologica Nacional, Iván has more than 15 years of experience working with 24x7 databases and over a billion concurrent users. He not only has hands-on experience in database design but also is quiet good at administration and development. Ivan has an analytical vision like few others and excels at taking on new and complex challenges.
Portfolio
Experience
- Performance Tuning - 15 years
- Database Modeling - 15 years
- SQL Server Integration Services (SSIS) - 14 years
- SQL Server Reporting Services (SSRS) - 12 years
- SQL Server 2008 - 12 years
- Database Clusters - 8 years
- SQL Server 2017 - 3 years
- PostgreSQL - 2 years
Availability
Preferred Environment
Amazon EC2, Relational Database Services (RDS), MySQL, PostgreSQL, SQL
The most amazing...
...thing I've done was to improve the time performance of the OLPT layer more than 100,000 times.
Work Experience
Database Administrator (DBA) Architect
Workstride
- Served as a DBA architect and performed administrative and development tasks.
- Migrated from an on-premise environment to AWS EC2 (with always-on)/RDS with a window activity lost of a couple of seconds.
- Optimized the performance tuning.
- Automated ETL processes with SSIS.
- Planned the HA/DR.
Database Architect | Senior Development Manager
Admotion SRL
- Worked as a database administrator, architect, and project leader.
- Developed while taking in consideration high availability and security.
- Modeled complex systems with several layers and technologies.
- Implemented a model of process-result with several layers for reports with high concurrency that periodically update data warehouse and preformatted reports; this simplifies the complexity and improves the response time.
- Worked with in-memory OLTP (in-memory optimization) in a few layers of SQL Server instances, where the data is complex but do not change constantly, in order to gain performance.
- Implemented NoSQL as a parallel project of the production environment (SQL) to analyze a different option of online serving (cost and performance, housing against AWS).
- Optimized and performance tuned a 24x7 system that involved a huge amount of data in tables of billions of records. The performance was constantly monitored to determine necessary changes: regeneration or creation of new indexes, changes in structures or paradigms.
- Performed different disaster recovery scenarios, depending on the licenses and structures in each layer (failover cluster, mirroring, replications, database snapshots, backups, and restores).
- Constantly monitored databases using the PRTG Network Monitor.
Senior SQL Server Architect (Contract)
CIMA Telecommunications
- Improved a complex process that had to much use of CPU, network and memory.
- Created a precalculated model while respecting the business logic resulting in a decrease of the average CPU from 80% to 10%.
- Supported transactions leading to an improvement from 30/minute to exceed 100,000/second. This only took a logical reengineering, without the need for hard investment.
SQL-VFP Server Programmer
Credicash Card
- Migrated FoxPro DOS to a new structure of Visual FoxPro with Microsoft SQL Server.
- Designed the entire system from scratch; including data model and programming.
Senior SQL-VFP Developer
Freelance Work
- Developed new billing systems for different clients with the capabilities of stock control, print invoices, discriminate taxes, and fiscal printer (A.F.I.P.).
- Migrated and processed data from and to different origins: DBF, CSV, SQL Server, Excel, and PDF.
Senior Programmer
Municipalidad de Yerba Buena
- Programmed and maintained a tax system.
Experience
Admotion SRL 01
While working at Admotion, I faced a lot of challenges and tasks related to advertisement. Since much of the technical work done at the business was cutting-edge and NDA, it was always exciting to design new patterns and models in order to emulate or improve ib what the competition does, no matter how complex it may be.
Admotion SRL 02
Education
Specialist's Degree in Project Management
Universidad Tecnologica Nacional - Buenos Aires, Argentina
Bachelor's Degree in Systems Engineering
Universidad Tecnologica Nacional - Tucuman, Argentina
Diploma in Accounting
Commerce School — República de Panamá - Tucuman, Argentina
Diploma in Accounting
Carlos Pellegrini Institute - Tucuman, Argentina
Certifications
English Conversation Certification
Wise Up
Oracle 9i Administrator
Proydesa Foundation
Programming in SQL Server 2000
Sistelco SRL
Cisco Networking Academy Certification
Proydesa Foundation
SQL Server Programmer
Sistelco SRL
Teaching English as a Second or Foreign Language/ESL Language Instructor (1st and 2nd Intensive Courses)
Aticana
Skills
Tools
Jira, DTS, Subversion (SVN), Visual SourceSafe, Excel 2010, Excel 2007, Excel 2013, SQL Server Profiler, VirtualBox, Microsoft Outlook, Visio, VPN, WinSCP, SSAS, Git, MongoDB Shell, Microsoft Visual Studio
Languages
Visual FoxPro, Visual FoxPro 9, C, Pascal, C++, Active Server Pages (ASP), SQL, Python
Paradigms
ETL, ETL Implementation & Design
Platforms
Windows, Linux, Windows Server, Amazon Web Services (AWS), Amazon EC2
Storage
SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2017, SQL Server Reporting Services (SSRS), Database Transactions, OLTP, Database Modeling, SQL Server Integration Services (SSIS), Database Replication, Database Mirroring, Database Architecture, Database Administration (DBA), MySQL, PostgreSQL, MongoDB, DBeaver, Microsoft SQL Server, Amazon S3 (AWS S3), SQL Server Analysis Services (SSAS)
Industry Expertise
Project Management
Frameworks
Windows PowerShell
Other
Performance Tuning, Tuning Advisory, IT Project Management, Project Leadership, Excel to PDF, Process Optimization, ETL Development, Leadership, Troubleshooting, Hardware Troubleshooting, Memory Leaks, Index, Disaster Recovery Consulting, Mirroring, Query Optimization, Microsoft 365, Leadership Development, Networks, Relational Database Services (RDS), Always On, Fortinet Firewall Configuration, Database Clusters
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring