Iván Guillermo Aldana, Performance Tuning Developer in Yerba Buena, Tucumán, Argentina
Iván Guillermo Aldana

Performance Tuning Developer in Yerba Buena, Tucumán, Argentina

Member since April 1, 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.
Iván is now available for hire


  • Workstride
    Amazon Web Services (AWS), Python, Amazon EC2, Amazon S3 (AWS S3), AWS, Git...
  • Admotion SRL
    Git, Subversion (SVN), Jira, MongoDB, PostgreSQL, MySQL, SQL Server Profiler...
  • CIMA Telecommunications
    SQL Server Integration Services (SSIS), Microsoft SQL Server



Yerba Buena, Tucumán, Argentina



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.


  • Database Administrator (DBA) Architect

    2019 - PRESENT
    • 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.
    Technologies: Amazon Web Services (AWS), Python, Amazon EC2, Amazon S3 (AWS S3), AWS, Git, Jira, PostgreSQL, MySQL, SQL Server Profiler, Windows PowerShell, SSAS, SSRS, Always On, SQL Server Integration Services (SSIS), SQL Server 2017
  • Database Architect | Senior Development Manager

    2005 - 2019
    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.
    Technologies: Git, Subversion (SVN), Jira, MongoDB, PostgreSQL, MySQL, SQL Server Profiler, Windows PowerShell, SSAS, SSRS, SQL Server Integration Services (SSIS), DTS, Microsoft SQL Server
  • Senior SQL Server Architect (Contract)

    2015 - 2015
    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.
    Technologies: SQL Server Integration Services (SSIS), Microsoft SQL Server
  • SQL-VFP Server Programmer

    2003 - 2005
    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.
    Technologies: Visual SourceSafe, Visual FoxPro, Microsoft SQL Server
  • Senior SQL-VFP Developer

    2002 - 2005
    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.
    Technologies: C++, C, Microsoft SQL Server, Visual FoxPro
  • Senior Programmer

    2004 - 2004
    Municipalidad de Yerba Buena
    • Programmed and maintained a tax system.
    Technologies: Visual FoxPro


  • Admotion SRL 01

    ROLE: Database Administrator, Database Architect, Project Leader

    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

    This is another project with Admotion where I improved a process which initially took 12 hours. I did this by implementing a Process-Result data warehouse model with several layers and batch updates. This simplified the complexity and improved the response time to 20 minutes.


  • Languages

    Visual FoxPro, Visual FoxPro 9, C, Pascal, C++, SQL, Python
  • Tools

    Jira, DTS, Subversion (SVN), Visual SourceSafe, Excel 2010, Excel 2007, Excel 2013, SQL Server Profiler, VirtualBox, Microsoft Outlook, Visio, VPN, WinSCP, SSRS, SSAS, Git, MongoDB Shell, Microsoft Visual Studio
  • 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
  • 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, AWS, Fortinet Firewall Configuration, Database Clusters
  • Frameworks

    ASP, Windows PowerShell


  • Specialist's Degree in Project Management
    2009 - 2009
    Universidad Tecnologica Nacional - Buenos Aires, Argentina
  • Bachelor's Degree in Systems Engineering
    1996 - 2002
    Universidad Tecnologica Nacional - Tucuman, Argentina
  • Diploma in Accounting
    1992 - 1995
    Commerce School — República de Panamá - Tucuman, Argentina
  • Diploma in Accounting
    1991 - 1992
    Carlos Pellegrini Institute - Tucuman, Argentina


  • English Conversation Certification
    MAY 2006 - PRESENT
    Wise Up
  • Oracle 9i Administrator
    MAY 2005 - PRESENT
    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)

To view more profiles

Join Toptal
Share it with others