Database Developer - II

PURPOSE OF THE POSITION: Under general supervision, the Database Developer 2 is responsible for designing, developing, and optimizing advanced database solutions. The role supports the Data Architect by implementing scalable database architectures, managing complex data integrations, and delivering high-quality reporting and analytics tools. This position includes leadership responsibilities within the database team and focuses on driving technical excellence and modernization., 1. Designs and develops database architectures in alignment with organizational goals and in collaboration with the Data Architect.

2. Implements advanced ETL processes and SSIS packages, supporting complex data integration and transformation workflows.

3. Creates and maintains SQL Server Reporting Services (SSRS) reports and Power BI dashboards for actionable insights.

4. Optimizes database performance, including advanced indexing strategies, query tuning, and resource management.

5. Analyzes business and technical requirements, recommending innovative database solutions.

6. Ensures data accuracy and integrity by implementing advanced validation and business rule processes.

7. Troubleshoots and resolves complex issues within databases, data warehouses, and reporting systems.

8. Supports modernization efforts, including migrations to hybrid or cloud-compatible architectures.

9. Collaborates across teams, providing technical expertise and ensuring database alignment with application requirements.

10. Documents solutions and processes, creating technical specifications and diagrams for reference.

11. Leads code reviews, ensuring high-quality and maintainable database solutions.

12. Provides advanced technical support for escalated issues, mentoring junior team members as needed.

13. Researches emerging database technologies and provides insights to support modernization and innovation initiatives.

14. Implements security measures and compliance protocols, ensuring data protection and regulatory alignment.

15. Mentors junior developers by providing technical guidance, support, and fostering their professional growth.

16. Contributes to cross-functional projects, applying advanced database expertise to achieve organizational objectives.

17. Performs other related work as assigned. This is not necessarily an all-inclusive list of job-related responsibilities, duties, skills, efforts, requirements or working conditions. While this is intended to be an accurate reflection of the current job, the Agency reserves the right to revise the job or to require that other or different tasks be performed as assigned.

CORE COMPETENCIES: Accountability, Collaboration, Critical Thinking, Design Thinking, Detail Orientation, Drive for Results, Organizational Skills, and Technical Expertise., PHYSICAL REQUIREMENTS: The individual assigned to this position must be able to complete all physical requirements of the job, with or without a reasonable accommodation, which include, but are not limited to the following:

• Ability to remain in a stationary position for extended periods while completing technical tasks.
• Occasional movement within the office to interact with team members or access equipment.
• Manual dexterity to operate technology tools, including keyboards and software interfaces.
• Ability to lift and transport computing equipment weighing up to 50 pounds when required.
• Effective communication skills for collaboration and documentation., * Bachelor's degree in Information Systems, Computer Science, or a related field, or equivalent education and experience.
• 4-6 years of hands-on experience in designing, developing, and managing enterprise databases and reporting solutions.

Technical Skills & Expertise:

• Advanced proficiency in SQL Server, T-SQL, SSRS, and SSIS for database and reporting development.
• Expertise in Power BI and other data visualization tools for analytics.
• Strong knowledge of database performance tuning, query optimization, and indexing strategies.
• Experience with hybrid or cloud-compatible database environments.
• Proficiency in scripting languages (Python, PowerShell, or C#) for database automation.
• Familiarity with regulatory standards and security frameworks for data protection.

Preferred Qualifications:

• Certifications in database technologies (e.g., Microsoft SQL Server, Azure).
• Experience with cloud migration projects or modern database architectures.
• Strong collaboration and leadership skills for mentoring and guiding teams.

Work Location: Hybrid remote in Brecksville, OH 44141