Database Administrator
Cleveland, OH
Mission
To create, maintain and update existing databases, procedures, reports and other ETL processes for Truth For Life with a specific focus on security, stability, scalability and reportability, while supporting the overall ministry mission and commitment to excellence.
Accountabilities
- Write and analyze queries for performance, review database logs, maintain and monitor database infrastructure, set up new databases and design and maintain ETL workflows for a variety of disparate data sources
- Responsible for maintaining the Studio Enterprise database architecture and supporting in case of issues
- Write and optimize queries used for Studio Enterprise and reporting, and write reports as needed
- Involved in designing database for future projects, including metadata system, export of online databases and integration into future data warehouse for more self-service reporting as needs grow
- Expand both experience and leadership in the field of database administration through ongoing training
- Demonstrate a high degree of project planning proficiency in all database application projects.
Outcomes
- Maintain donor management and other ancillary databases
- Extensively grow the quantity and quality of reporting on donor and other ancillary data sources for the benefit of business decisions
- Document the current database environment, suggesting, planning and executing improvements as needed to meet RTO and RPO requirements as well as capacity planning and uptime
- Act as first-level support for user issues surrounding our donor management system and data questions/issues
- Work with web development team in designing next-generation data environment for online integration of services for the benefit of Truth For Life listeners
- Execute, update and improve existing ETL and other recurring processes with donor management system
- Assist in any needed data migrations or the onboarding of additional databases or services where data needs to be loaded
- Migration of existing process code to version control system
- Initiate and actively engage topics of ongoing learning (books, courses)
Competencies
- Integrity: Steadfast commitment to biblical principles for living and working
- Passion: Wholehearted dedication to the mission of Truth For Life
- Passion: Committed to excellent user experience across all major platforms and devices
- Efficiency: Committed to clean, lean and documented code
- Experience: 5+ years or shows strong proficiency in administering and developing for Microsoft SQL Server 2016+
- Experience: 2+ years experience working with MySQL
- Experience: 3+ years using Visual Studio or similar IDE for SSIS job or SSRS report development
- Security: A security-first mindset in development of any environment or process
- Judgment/Decision Making: Commitment to data-driven decisions with the help of research, user-testing, and experience.
- Strategic skills: Establishes a strong testing methodology for any development to ensure success of any project
- Independent: Able to manage multiple tasks and effectively meet deadlines without being closely managed
- Resourceful: Readily adopts new tools and clever approaches to overcome difficulty
- Adaptability: Easily adjusts to new conditions and welcomes challenges as opportunities
- Team player: Willingly and reliably works in cooperation with and support of others
- Innovative: Introduces new ideas and methods to meet new requirements or changing market demand
- Assertiveness: Proactively offers suggestions, opinions, and openly asks questions
- Tenacity: Highly persistent in maintaining or seeking to meet goals/objectives, determined to overcome obstacles