POSITION OBJECTIVE
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, such as Amazon Web Services, Microsoft Azure, and Google Cloud Platform. This 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. This position 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.
ESSENTIAL FUNCTIONS
-
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 back-up, 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%)
NONESSENTIAL FUNCTIONS
-
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%)
CONTACTS
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.
SUPERVISORY RESPONSIBILITIES
No supervisory responsibility.
QUALIFICATIONS
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.
REQUIRED SKILLS
-
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 configuration, database performance tuning, backup methodologies, and database security.
-
Broad architectural awareness of customer applications, not only understanding database aspects (e.g., metrics, DB parameters etc.) but also with ability to triage issues in an end-to-end manner aware of how web, application and caching tiers impact database performance and availability.
-
Coding skills in the procedural language for at least one database engine is necessary (PL/SQL etc.)
-
Familiarity with Amazon Web Services, Microsoft Azure or Google Cloud Platform including RDS and/or Cloud Computing.
-
Technical project management support for technical cross-functional projects and is assigned to projects with significant scope, complexity, size, impact, budget, and/or project team size. Projects are varied in nature and have a significant impact on organization.
-
Demonstrate thorough understanding of the Software Development Life Cycle (SDLC) and utilize the ability to lead efforts in implementing life cycle practices.
-
Standard PC software packages, including word processing, spreadsheet, database, and flowcharting.
-
Demonstrate principles and practices of sound business communications with the ability to communicate complex material in ways customers can understand.
-
Ability to actively listen; responsive to verbal and non-verbal clues. (Listening Skills)
-
Ability to look at situations from multiple perspectives, break problems into component parts, and look for underlying causes and think through the consequences of different courses of action. Ability to identify various types of problems along with the creation of workable solutions. Requires the identification and analysis of problems, evaluation of alternatives, and provision of solutions (Analytical and Problem-Solving Skills).
-
Ability to respond to difficult, stressful, or sensitive interpersonal situations in ways that reduce or minimize potential conflict and maintain good working relationships among internal and external customers. The ability to recognize awkward or potentially embarrassing situations that sometimes arise. Always aware of tone and careful choice of words, while at the same time ensuring that the intended message is clear, polite, and readily understood. (Tact and Diplomacy Skill)
-
Ability to develop in-depth understanding of client needs in order to be more helpful. The ability to consider how different audiences are likely to respond and choose the best method of communicating the message to each audience. (Customer Focus Skill)
-
Consistently models high standards of honesty, integrity, trust, openness, and respect for the individual. Must have the ability to use discretion and good judgment on sensitive and important matters. (Ethic/Integrity Skills)
-
Ability to recognize the importance of certain tasks and responsibilities and the ability to prioritize to ensure that deadlines are met. (Dependability and Reliability Skill)
-
Ability to be flexible in order to meet the constant changing scope and needs of the department, division and customers being served. Ability to work in a fast-paced environment while managing multiple projects. Ability to optimize the use of time and resources to achieve the desired results; effectively plans and organizes work to minimize crises; prioritizes appropriately. (Planning and Organization Skills)
-
Ability to work with technologies for which little or no documentation or precedence exists. Commitment to self-motivated lifelong learning. (Explorative Attitude)
-
May oversee engineering, design, implementation and deployment of core technical services projects.
-
May include supervision and team leadership of core technical services projects. May direct the work of student employees
-
May be a junior technical architect with responsibilities for: Making recommendations for core infrastructure improvements.
-
Working with vendors and contractors to design, develop project initiation activities, including core technical implementation of those designs.
-
Engagement with senior colleagues (architect, senior architect) on advanced project activities with or without any direct management
-
Demonstrated history of successful support, education, and advocacy for all faculty and staff aligned with the values, mission, and messaging of the university, while adhering to the policy on conflict of commitment and interest.
-
Ability to meet consistent attendance.
-
Ability to interact with colleagues, supervisors, and customers face to face.
-
Willingness to learn and work with artificial intelligence (AI) tools and technologies.
WORKING CONDITIONS
Office and computer room environment. This position has the potential to access secure and sensitive personal information. May require working off hours to appropriately evaluate all conditions. The employee may be required to carry a cellphone during and after their normal work hours, including weekends, to address after-hours emergencies. Travel between various locations on campus may be required. The position requires typing on a computer keyboard and using a computer, mouse, and a printer.
