Make incremental work genuinely incremental.
A SQL Database Administrator assignment focused on resilient ingestion, recovery, and reporting delivery.
- Redesigned incremental SSIS extraction using a previously undocumented source timestamp, reducing processing volume and runtime while preserving data completeness through reconciliation.
- Extended packages, schemas, stored procedures, and SQL Server Agent schedules for new PostgreSQL, FTP, CRM, and frequently updated sources.
- Diagnosed schema, datatype, network, and source-data failures and executed controlled, upsert-based recovery without duplicate records.
- Migrated a complete paginated-report suite from SSRS to Power BI, including schedules and user-level access configuration.
administrationMay 2024 - present