IT Engineer - Database Administrator

IT Engineer 3 - Database Administrator

Case Western Reserve University is committed to providing a transparent estimate of the salary range available for this position at the time of its posting. The salary range is between $76,725 and $97,057, depending on qualifications, experience, department budgets, and industry data.

Employees receive more than just a paycheck. University employees enjoy a comprehensive benefits package that includes excellent healthcare, retirement plans, tuition assistance, paid time off, and a winter recess.

Working under limited supervision as a member of the Cloud Services team, accountable for the planning, developing, and configuring of the University's Oracle and Microsoft SQL databases that support enterprise applications. These databases will reside on campus or in the cloud (Amazon Web Services, Microsoft Azure, and Google Cloud Platform). The position provides service through monitoring and troubleshooting the performance, integrity, and security of the enterprise databases.

Ensures that good security policies and practices are followed for regulated data, such as student, patient, and research data. Works with all departments within Case Western Reserve University to understand business needs in order to coordinate the installation, migration or updating of the enterprise databases, collaborate on common service requirements, and research and resolve performance problems.

• Identify database requirements by interviewing customers and by evaluating new or existing applications. Propose solutions for updating or implementing databases that support these applications. (20%)
• Recommend solutions by defining database physical structure and functional capabilities, database security, data backup, and recovery specifications. (15%)
• Propose and recommend technical specifications for applications to be upgraded or implemented. Coordinate installation requirements with project manager, system owner, and/or third‑party vendor. (15%)
• Prepare project plans and project schedules for new installations and new releases using established project processes. (10%)
• Implement database solutions based on business requirements and technical specifications. (10%)
• Maintain database performance by calculating optimum values for database parameters and installing new releases of Oracle and Microsoft SQL Server. (10%)

• Establish standards for consistent Oracle and Microsoft SQL Server database application development, security and performance, including testing guidelines and conditions. (5%)
• Support database functions by designing and coding database utilities. (5%)
• Maintain professional and technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks, benchmarking state‑of‑the‑art practices, and participating in professional societies. (5%)
• Ensure University monitoring solution monitors availability and performance of all Enterprise Database systems and alerts appropriate personnel when availability or performance does not meet the required levels of service. Maintain service key‑performance indicators (KPIs) and metrics to report to Utech leadership and campus community. (4%)
• Perform other duties as assigned. (1%)

Department:
Supervisor will review goals, accomplishments, and overall team performance at key stages. Daily contact with Cloud Services teams to tackle a variety of issues collaboratively and negotiate any shadow issues that may arise to resolve problems effectively. Daily/weekly contact with developers, engineers, managers to maintain workflow.

University:
Daily contact with project teams to tackle a variety of issues collaboratively and negotiate any shadow issues that may arise to resolve problems effectively. Regular contact with project sponsors to review project timeline, key milestones, and outstanding issues. Regular contact with stakeholders and internal constituents to facilitate and promote joint action and cooperation to achieve results.

External:
Daily/weekly contact with hosted vendors and other third‑party vendors as needed. Moderate contact with vendors, contractors, and other external representatives to investigate new and future products and services.

Students:
No contact with students.

No supervisory responsibility.

Experience: 3 to 5 years of related experience, preferably with Oracle database and Microsoft SQL database programming, server management and technical infrastructure experience.

Education: Bachelor's degree in computer science or a related field.

• Under limited supervision, develop, design, implement, maintain and report on total projects including a large range of services
• Demonstrate thorough knowledge of database theory, design principles, and development methodologies, including data modeling, data flow, and entity relationship analysis.
• Demonstrate thorough knowledge of database…