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 March 8, 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

Portfolio

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

Experience

Location

Yerba Buena, Tucumán, Argentina

Availability

Part-time

Preferred Environment

AWS 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.

Employment

  • Database Administrator (DBA) Architect

    2019 - PRESENT
    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.
    Technologies: Python, AWS RDS, AWS EC2, AWS S3, AWS, Git, Jira, PostgreSQL, MySQL, SQL 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 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

Experience

  • Admotion SRL 01 (Development)

    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 (Other amazing things)

    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.

Skills

  • Languages

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

    Jira, DTS, Subversion (SVN), Visual SourceSafe, Excel 2010, Excel 2007, Excel 2013, VirtualBox, Microsoft Office, 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), AWS EC2
  • Storage

    SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2017, SQL Server Reporting Services (SSRS), Database Transactions, SQL Profiler, OLTP, Database Modeling, SQL Server Integration Services (SSIS), Database Replication, Database Mirroring, Database Architecture, Database Administration (DBA), MySQL, PostgreSQL, MongoDB, DBeaver, Microsoft SQL Server, AWS S3, AWS RDS, SQL Server Analysis Services (SSAS), Database Clustering
  • 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, Leadership Development, Networks, Relational Database Services (RDS), Always On, AWS, Fortinet Firewall Configuration
  • Frameworks

    ASP, Windows PowerShell

Education

  • 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

Certifications

  • English Conversation Certification
    MAY 2006 - PRESENT
    Wise Up
  • Oracle 9i Administrator
    MAY 2005 - PRESENT
    Proydesa Foundation
  • Programming in SQL Server 2000
    DECEMBER 2004 - PRESENT
    Sistelco SRL
  • Cisco Networking Academy Certification
    OCTOBER 2004 - PRESENT
    Proydesa Foundation
  • SQL Server Programmer
    OCTOBER 2004 - PRESENT
    Sistelco SRL
  • Teaching English as a Second or Foreign Language/ESL Language Instructor (1st and 2nd Intensive Courses)
    OCTOBER 2003 - PRESENT
    Aticana

To view more profiles

Join Toptal
Share it with others