You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Ricardo Alfredo Huaman SuarezRA

Ricardo Alfredo Huaman Suarez

DBA SQL Server | Software Architect | Data Archite

€400/day
Madrid, ES
15+ years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Ricardo Alfredo

As a professional with solid experience in SQL Server database administration and software architecture, I am convinced that my technical skills and strategic approach can contribute significantly to your organization.

Throughout my career, I have led critical projects focused on database performance optimization, efficient management of complex infrastructures, and the design of scalable solutions. My experience includes implementing high-availability environments, automating processes using advanced T-SQL scripts, and managing large volumes of data, always ensuring the integrity, security, and optimal performance of systems.

As a Software Architect, I have designed and implemented robust architectures based on microservices and DevOps principles, facilitating continuous integration and scalability of critical business applications. My ability to analyze complex requirements, propose innovative solutions, and coordinate multidisciplinary teams has allowed me to successfully lead technological initiatives aligned with the strategic objectives of the organizations in which I have worked.

I consider myself a proactive, results-oriented professional passionate about continuous improvement. Furthermore, my focus on detailed technical documentation, risk management, and adherence to information security best practices ensures the delivery of high-quality technological solutions.
  • Spanish

    Native or bilingual

Can work on-site
Madrid (up to 50km)

Experience

  • Distriplac
    Data Architect Client - Distriplac
    ARCHITECTURE AND URBAN PLANNING
    February 2025 - Today (1 year and 4 months)
    Madrid, Spain
     Migration of SSAS cubes from version 2016 to 2022.
     Source data comes from SAP and is stored in Snowflake, using Azure Data Factory for integration.
     From Snowflake, data is modeled following a dimensional schema, composed of fact and dimension tables, implemented in SQL Server.
     Table processing is performed directly in SQL Server, optimizing their performance and structure.
     Information visualization is carried out using pivot tables in Excel and interactive dashboards in Qlik Sense.
    Transac-SQL Azure Data Factory MS SQL Server Snowflake
  • Yodeyma
    DBA - BI - Project Management
    August 2023 - February 2025 (1 year and 6 months)
    Madrid, Spain
    Design and lead the Business Intelligence strategy aligned with business objectives. Plan, coordinate, and supervise BI projects, ensuring compliance with deadlines.
    • Establish data governance policies, ensuring the integrity, accuracy, security, and confidentiality of information. Development of ETLs with Data Factory
     Power BI
     SQL Azure Instance
     Transac-SQL
     Python
     Plan and track assigned projects.
     Gather business requirements for project conceptualization.
     Manage the team responsible for achieving project objectives.
     Azure / .NET / API Development and Implementation
     Swagger Yodeyma Logistics Swagger-UI
    Data Factory Transac-SQL Project Management Project Management SQL Server
  • CEPSA
    SQL Server DBA - CEPSA Client
    May 2022 - August 2023 (1 year and 3 months)
    Madrid, Spain
    SQL Server Performance Optimization:
    Administration to improve server performance, availability, and efficiency through query analysis, index tuning, and system resource optimization.

    SQL Server Migration with dbatools:
    Planning and execution of database migration processes using dbatools, ensuring data integrity, minimal service interruption, and post-migration optimization.

    PowerShell Task Automation:
    Development of PowerShell scripts to automate SQL Server administration tasks, including instance migration, backup management, performance monitoring, and security configuration.

    T-SQL (Transact-SQL) Programming:
    Design and optimization of stored procedures, functions, triggers, and complex queries in Transact-SQL, focused on improving application performance and data integrity.

    SSAS Infrastructure Migration
     Identify SSAS Mode: Multidimensional / Tabular
     Backup SSAS Database (select a location and save the ".abf" file)
     Migrate Configuration and Roles
     Review connections and data sources
     Verify that cubes/models process correctly.
     Execute MDX or DAX queries to test performance
     Ensure reports and tools (Power BI, Excel) are working.
    Transact-SQL Powershell MS SQL Server Transac-SQL SSIS

Recommendations

Be the first to recommend Ricardo Alfredo

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Computer Engineering
    UNIVERSIDAD "SAN IGNACIO DE LOYOLA"
    1999
    Ingeniería Informática
  • Technician in Computing and Informatics
    INSTITUTO SUPERIOR TECNOLOGICO "SAN IGNACIO DE LOYOLA"
    1996
    Técnico en Computación e Informática

Skill set

Categories