Iván Guillermo Aldana, Developer in Yerba Buena, Tucumán, Argentina
Iván is available for hire
Hire Iván

Iván Guillermo Aldana

Verified Expert  in Engineering

Performance Tuning Developer

Yerba Buena, Tucumán, Argentina

Toptal member since April 16, 2019

Bio

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

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

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

Part-time

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

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: Amazon Web Services (AWS), Python, Amazon EC2, Amazon S3 (AWS S3), Git, Jira, PostgreSQL, MySQL, SQL Server Profiler, Windows PowerShell, SSAS, SQL Server Reporting Services (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, SQL Server Reporting Services (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.
2009 - 2009

Specialist's Degree in Project Management

Universidad Tecnologica Nacional - Buenos Aires, Argentina

1996 - 2002

Bachelor's Degree in Systems Engineering

Universidad Tecnologica Nacional - Tucuman, Argentina

1992 - 1995

Diploma in Accounting

Commerce School — República de Panamá - Tucuman, Argentina

1991 - 1992

Diploma in Accounting

Carlos Pellegrini Institute - Tucuman, Argentina

MAY 2006 - PRESENT

English Conversation Certification

Wise Up

MAY 2005 - PRESENT

Oracle 9i Administrator

Proydesa Foundation

DECEMBER 2004 - PRESENT

Programming in SQL Server 2000

Sistelco SRL

OCTOBER 2004 - PRESENT

Cisco Networking Academy Certification

Proydesa Foundation

OCTOBER 2004 - PRESENT

SQL Server Programmer

Sistelco SRL

OCTOBER 2003 - PRESENT

Teaching English as a Second or Foreign Language/ESL Language Instructor (1st and 2nd Intensive Courses)

Aticana

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

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring