• Own production performance across PostgreSQL and Microsoft SQL Server. • Diagnose and resolve execution plan, indexing, locking, blocking, and query performance issues. • Design and operate high availability, replication, failover, and disaster recovery strategies. • Lead zero-downtime schema changes and production database migrations. • Execute large-scale data migrations and backfills using safe, verifiable processes. • Maintain secure database access, encryption, auditing, and governance practices. • Build monitoring, alerting, and capacity planning processes. • Support reporting, analytics, and warehouse performance. • Continuously improve database reliability, safety, and operational excellence.

• Monitor the availability, performance, capacity and overall health of customer SQL Server environments. • Review and respond to alerts generated through database monitoring and service-management platforms. • Assess and triage database tickets according to impact, urgency and technical complexity. • Investigate availability, performance, connectivity, configuration and capacity issues. • Identify root causes and develop clear, technically appropriate resolution plans. • Resolve incidents within agreed service levels and maintain ownership through to completion. • Identify recurring alerts and incidents and recommend preventative or permanent solutions. • Install, configure, maintain, patch and upgrade SQL Server environments as required. • Investigate slow queries, blocking, deadlocks, resource contention and other performance challenges. • Review database configurations, indexing and performance settings and recommend improvements. • Manage database users, roles, permissions and access controls. • Support database migrations, environment changes and SQL Server version upgrades. • Configure and support High Availability and Disaster Recovery solutions. • Support database mirroring, replication and data synchronisation. • Monitor and validate backup, restoration and recovery processes. • Communicate findings, risks, recommended actions and progress updates directly to customers. • Work closely with customers, application teams, infrastructure teams and internal delivery resources. • Escalate highly complex or critical issues when additional expertise or resources are required. • Maintain accurate records of incidents, investigations, configurations, changes and resolutions. • Develop and maintain technical documentation, operating procedures and knowledge-base articles. • Identify opportunities to improve operational processes, database reliability and customer outcomes.

Role Description - Analizar la estructura actual de bases de datos legadas y proponer estrategias de migración a nuevas arquitecturas en SQL Server. - Diseñar e implementar procesos de extracción, transformación y carga (ETL) para la consolidación de información histórica. - Realizar ingeniería inversa para documentar esquemas, dependencias y relaciones entre objetos. - Monitorear la ejecución y desempeño de las migraciones, proponiendo mejoras continuas en los procesos de carga y transformación. Qualifications - Experiencia mínima de 3 años administrando y desarrollando bases de datos en SQL Server (2012 a 2019). - Experiencia en migración de datos, ingeniería inversa y reingeniería de estructuras de base de datos. - Conocimiento avanzado en modelado de datos relacionales y optimización de consultas (query tuning). - Experiencia en estrategias de respaldo, restauración y mantenimiento de bases de datos. Requirements - Deseable: Experiencia en la creación de reportes y dashboards en Power BI para el análisis de datos migrados o de rendimiento de bases de datos.

• Manages the performance, security, and maintenance of databases within Saint Francis Health System (SFHS). • Ensures data integrity, perform system backups, optimizes performance, and supports users while ensuring compliance with relevant regulations. • Designs and implements database structures based on organizational requirements. • Conducts systems analysis to understand and address database needs in alignment with business processes. • Collaborates with stakeholders to gather and analyze business requirements for database solutions. • Analyzes and revises existing system logic difficulties for moderately complex workflows and systems. • Monitors and optimizes database performance, including tuning queries and database configurations. • Implements and manages security measures to protect sensitive data, including access controls and encryption. • Develops and maintains backup procedures and disaster recovery plans to ensure data availability and integrity. • Ensures data accuracy, consistency, and reliability within the database. • Maintains and updates SQL code to correct errors and enhance functionality. • Ensures compliance with relevant regulations and standards and assists with audits. • Partners with business process experts to learn and understand database problems, making recommendations for enhancements and solutions. • Plans for future database capacity and storage needs, assessing current usage and forecasting growth. • Troubleshoots and resolves database related issues to minimize downtime and data loss.