Nicolas has been working with data as a SQL DBA Engineer for 15+ years, both as an employee and a freelancer for platforms in the US and Canada. Diligent, creative, and flexible, he works well in teams and solo.
Worked with SQL Server and Oracle for a leading collection and recovery platform and centralized the management and administration of arrears throughout its lifecycle.
Designed and implemented fault-tolerant SQL Server solutions using high-availability patterns for scalability and stability.
Worked closely with project teams to develop data models that support business processes.
Worked with Access 97, MySQL 5, and SQL Server 2008R2, performing installation, administration, maintenance, and optimization on Windows Server 2008.
Performed reception, formatting, and administration of raw data for several projects mainly dedicated to presidential electoral roll lists, national passport control system, Argentinian peso (ARS) production, and control process.
Used T-SQL scripting for maintenance routine development.
Handled installation and migration on SQL Server 2008 and 2012 to SQL Server 2016 on Windows Server and SQL Server 2008/2012/2016 maintenance and tuning on AWS. Managed documentation production for process standardization on SQL Server and SQL Server-related product installations.
Handled SQL and MySQL server Installation, administration, maintenance, and optimization on Windows Server and Intersystems Caché v5.0 (nonrelational DB engine) installation and administration on Windows Server. Monitoring and alerting done through Windows PerfMon and SQL Email Operators.
Managed SQL and MySQL server Installation, administration, maintenance, and optimization on Windows Server and Unix, T-SQL scripting for maintenance routine development, and worked with PostgreSQL and MariaDB lab environment assembly and benchmark testing.