Key Responsibilities
• Platform administration: Maintain production and nonproduction Clarity and Caboodle environments, including configuration, upgrades, patching, and coordinated environment refreshes.
• ETL operations: Schedule, monitor, and troubleshoot Clarity extracts and Caboodle ETL processes. Investigate failed or delayed jobs, manage dependencies, and communicate data-availability impacts to reporting teams.
• Database performance: Monitor database growth and workload performance. Maintain appropriate indexes and statistics, investigate resource bottlenecks, and coordinate tuning with database and infrastructure teams.
• Data protection and access: Maintain database access controls and service accounts, validate backups and restores, and participate in disaster recovery testing.
• Release and data validation: Assess the operational impact of Epic updates and schema changes. Coordinate testing with reporting developers and validate successful data loads following maintenance or upgrades.
• Operational improvement: Maintain ETL runbooks, configuration documentation, and recovery procedures. Automate routine checks, track recurring failures, and implement improvements to data-delivery reliability.