Job Overview
We are seeking a seasoned data professional to lead the design, implementation, and maintenance of efficient transactional and analytical data models.
- Optimize database backup jobs and schedules, as well as maintain production, disaster recovery, and development environments
- Troubleshoot database issues as they occur, providing timely resolutions to ensure business continuity
- Supply ad-hoc data reporting and data pulls for analytics teams, ensuring data-driven decision-making
- Perform various data loading and manipulation tasks, including routine exports for clients and partners
- Create and manage scheduled tasks and data processing scripts, streamlining operational efficiency
- Document data collection, processing, and presentation procedures, fostering transparency and accountability
- Support architecture and process flow diagrams for data systems, driving strategic alignment
- Participate in the evaluation, design, implementation, maintenance, support, and enhancement of sophisticated database systems and technologies
Required Technical Expertise
- Setup test, dev, staging, and production environments
- Design and implement disaster recovery strategies
- Establish linked servers to SQL Servers and other databases
- Design database backup and restoration strategies
- Work collaboratively with cross-functional teams to provide 24x7 support
- Monitor database backups and recover databases as needed
- Implement high-availability solutions as part of disaster recovery strategies
- Troubleshoot day-to-day issues and resolve problems efficiently
- Monitor and perform performance tuning on databases
- Document major changes to SQL Servers and apply service packs