Bronx, New York, United States
Administered and maintained multiple SQL Server and PostgreSQL instances across on-prem and cloud environments, performing user/role management, security configuration, backup validation, basic restoration testing, and routine health checks to ensure database reliability.
Monitored database performance and availability, performing tuning activities such as analyzing slow-running queries, reviewing execution plans, and recommending indexing or configuration adjustments to optimize system efficiency.
Built and orchestrated an automated ETL pipeline using Meltano, dbt, and DuckDB and deployed as a Linux container, enabling reliable data processing and scalable reporting workflows.
Executed ad-hoc data extractions, bulk uploads, schema updates, and controlled database changes to support business operations while adhering to governance and change-management procedures.
Collaborated with application, infrastructure, and analytics teams to troubleshoot database-related issues, support deployments, and ensure high availability and data integrity.