Alixander Dávila Arias
Database, WordPress, RedCap, Servers & IT support specialist
New to Contra
Alixander is ready for their next project!
Centralization and integration of data from three on-premise packaged systems used by the Faculty of Dentistry. The work included gathering access to databases and attachments, building a SQL Server data warehouse, creating a centralized file server for document storage, and unifying information from all systems into a single source of truth. I also developed database views to support a centralized Python-based results delivery system and multiple Power BI dashboards for consolidated reporting and decision-making.
1
19
Reverse-engineering, migration, and hardening of a legacy ERP platform that had to be rebuilt without original administrative access. The work included recovering Classic ASP application files, reconstructing the database structure from limited access, recreating IIS and mail configuration, securing the application against SQL injection, and building new Dev, QA, and Production environments. The final solution included backups every 30 minutes, a custom Linux load balancer, redundant Windows application servers, and a unified Linux file server to improve stability, recovery, and operational resilience.
0
12
Migration and recovery of WordPress environments from legacy servers to new infrastructure, including Linux server provisioning, Apache/PHP/MariaDB setup, virtual hosts, SSL, database and file migration, troubleshooting, and direct database adjustments when full background information was not available. This work required end-to-end platform support to restore, stabilize, and keep each site fully operational in its new environment.
0
17
Migration and modernization of multiple REDCap environments, including new Linux server provisioning, Apache/PHP/MariaDB setup, SSL, Postfix, virtual hosts, database and file migration, version-by-version REDCap upgrades, and production adjustments to keep systems stable and data safe. This work also involved server, network, and platform-level troubleshooting to ensure each environment was fully operational after migration.
0
24