Herc-Higher Education Recruitment Consortium

Database Administrator- Journey

About Eastern Washington University:
Eastern Washington University is a regional, comprehensive public university located in Cheney and Spokane, Washington, with programs offered throughout the state and online with an enrollment of over 12,000 students. Eastern is one of six state-funded four-year institutions of higher education in Washington reporting to its own Board of Trustees.

Easterns 300-acre main campus is located in Cheney, a community of 11,000 residents 16 miles southwest of the states second largest city, Spokane. Eastern also offers programs in downtown Spokane at the Brand new Catalyst building and on the Riverpoint Campus which is shared with Washington State University. Eastern also offers program throughout the state based on the needs of the community. Eastern offers an array of bachelors and masters degrees and one applied doctorate in physical therapy. EWU offers 135 fields of study, 9 masters degrees, 12 graduate certificates, 39 graduate programs, 1 educational specialist degree, and 1 applied doctorate to more than 10,000 enrolled students.

Job Summary:
Information Technology (IT) provides information resources and technology services to the entire campus community in support of the university's mission. IT also provides technical assistance in the design, acquisition, installation, and maintenance of campus systems, media, and telecommunications infrastructure including; desktop and laptop computer equipment; institutional databases; enterprise-wide applications; technology equipped classrooms, distance learning classrooms, telecommunications systems; centrally licensed software, online services, open-access and discipline specific computer labs, consulting, training, and user support. Information Technology provides assistance to EWU leadership in strategic planning for technology initiatives which strengthen both efficiency and effectiveness.

This position, reports to the Sr. Manager of Infrastructure Services who in turn reports to the Associate Vice President / Chief Information Officer (CIO).

A Database Administrator is responsible for the maintenance, performance, integrity, and security of database systems that include tasks related to planning, implementing, integrating and performance for both on premises and cloud systems. This position works closely with both clients and IT staff on a variety of Database systems including Oracle, MS SQL, MySQL, Aurora, RDS, PostgreSQL and other ancillary database systems.

The candidate selected for this position will be rewarded with competitive compensation and a comprehensive benefits package which includes highly subsidized health/dental plans, retirement plan with 100% university match, generous paid vacation and sick leave, 11 paid holidays (adjusted accordingly), tuition waiver benefit and more!

EWU expands opportunities for personal transformation through excellence in learning.

Required Qualifications:

• Bachelor of Science or Bachelor of Applied Science degree in a computer science discipline; Equivalent IT work-related experience may be substituted for degree (minimum of four (4) years experience).
• Two (2) years of database administration experience that includes database maintenance, database design and query language programming.
• Experience implementing, managing and administering complex, enterprise wide systems.
• Candidate must demonstrate interest, ability and/or experience promoting cultural competency, universal accessibility, and/or diversity.

Demonstrated abilities in each of the following areas:

• Working independently.
• Prioritize and work on multiple projects simultaneously in a fast-paced environment.
• Effectively communicate in both spoken and written form to diverse constituencies, both technical and non-technical.

Preferred Qualifications:

• SQL Certification such as Oracle, MS SQL, PostgreSQL or AWS Certified Database.
• Experience in using a well-structured life cycle management process for implementation of changes in application systems, including experience with project management and configuration management processes.
• Knowledge and experience working in a higher education and/or financial environment with areas dealing with information systems management and support systems.

Other Skills and Abilities:
Database Administration

• Installation, configuration, troubleshooting, support and maintenance of ancillary database systems including Production, QA and Development server environments
• Monitoring and optimization of database performance, security, resource utilization, memory configuration, sessions, archive logs, and disk space usage.
• Supervised support for mission-critical database instances, including responsibility for after hours on-call support for issue resolution
• Provide user management including enrolling users and maintaining system security
• Provide storage management including allocation of system storage and planning for future storage needs
• Perform installation and updates to products and tools, as well as systems and applications
• Provide technical input and coordination with IT staff and lateral enterprise staff and project systems
• Leverage Database knowledge by providing SQL and data understanding to developers and users
• Assist with performance measures, security policies, and operating standards for database management systems

Project Management and Community Support

• Plans, schedules and coordinates projects and tasks concurrently with supervisor
• Demonstrates the ability to estimate a project or test that is accurate and thorough
• Research University technology needs and requirements
• Creates and maintains database\project\server documentation for application support, disaster recovery and business continuity
• Provide documentation and consultation informing users of systems, services, and resources available to them
• Collaborate to develop, publish, administer and promote policies, procedures and standards for the department and institution

Job Duties:
% of Time:
Responsibility / Duty: Installation, maintenance, and development.  Install, upgrade, and provide development and design support for database systems and select applications. 

• Maintain database software and database instances to keep products current and protected from vulnerabilities.
• Apply customizations and enhancements to databases and applications as needed.
• Develop and maintain automated processes in support of database systems using tools such as Ansible, Chef, Puppet or other relevant automation tool.
• Create or retire database instances as needed.
• Provide consultation on SQL and other database technologies to developers and users.
• Troubleshoot issues as needed during all stages of installation, maintenance, and development of database systems.
• Collaborate with system administrators on system architecture, design, and cloud migrations.
• Identify and collaborate where business process analysis might lead to business process improvements and efficiencies. Suggest alternate approaches, tools, and technologies where appropriate.
• Advise and/or assist with data extraction tasks including database exports, custom views and reports.
• Use performance monitoring tools to identify resource allocation issues, resource contention issues and poorly written code.
• Independently apply recommended changes to configuration and improvements to code.
• Follow standard change control procedures for all changes to production systems and follow standard development/test/production promotion of changes including user testing
• Coordinate with business and technical units for planned outages

Outcome: Database systems and applications are provisioned and maintained in a timely manner; database support provided to development teams and other staff.
Essential Function Indicator: Yes


% of Time:
Responsibility / Duty: Security and Data Integrity. Utilize database security technologies that include the use of roles, fine grained access, auditing, and encryption that protect data from unauthorized or malicious access. Ensure that data is protected in accordance with the defined recovery point objective (RPO) from loss due to hardware failure, software failure, user error or malicious activity. 

• Maintain authentication services for database systems.
• Working in conjunction with data owners, design, implement, maintain and utilize a framework for authorizing access to data for named users using database technologies like roles and fine-grained access. Access is authorized by data owners and in accordance with the IT security policy.
• Implement auditing of data access as needed by data owners and/or regulations.
• Follow best practice steps to harden database systems against malicious access that include appropriate firewall restrictions.
• Utilize appropriate encryption to secure data against attacks.
• Collaborate on disaster recovery plans and recovery testing.
• Backup data in accordance with the specified retention period and RPO (Recovery Point Objective). RPO is the maximum targeted period in which data might be lost due to a major incident.
• Recover data as needed following a major incident or user error.
• Provide Tier 2 troubleshooting support for applications within DBA services purview including coding and database connectivity issues.
• Identify, research and resolve data integrity problems.

Outcome: Data is protected against unauthorized or malicious access including the review of audited access controls, policies, procedures, and users. Systems are available so that authorized users can complete their assigned functions and tasks. During a data loss event, data is recovered in accordance with the defined RPO and the affected application is returned to service.
Essential Function Indicator: Yes


% of Time:
Responsibility / Duty: Cloud Design and Engineering.  Assist with the design and configuration of cloud database and application environments with considerations for storage, memory, clustering, database connectivity, security, staging servers, interoperability of applications, continuous integration and server management software. 

• Collaborate with vendors, sysadmins, information security, and other IT staff to provide cloud database and application environments.
• Request and coordinate creation and retirement of cloud servers, applications, and services.
• Utilize middleware, continuous integration services, and configuration management solutions to improve processes, deploy installation scripts, and maintain and improve database and application deployments.
• Anticipate and plan for usage growth.

Outcome: Adapt to evolving technologies and system usage; ensure that services meet specifications and perform under anticipated loads.
Essential Function Indicator: Yes


% of Time:
Responsibility / Duty: Administration. Perform administrative tasks in support of other database related job duties. 

• Develop and maintain detailed documentation for all job duties to provide repeatability and business continuity.
• Plan, schedule, and coordinate projects and tasks. Sets and maintains project schedules, coordinates, and implements installation projects for systems.
• Provides technical coordination with all IT staff, vendors, business units, and project.
• Ensure licensing requirements for databases are met.
• Maintains code in repositories and continuous integration servers.

Outcome: Systems, tasks, and responsibilities are documented. Compliance to licensing agreements is maintained. Projects are adequately managed.
Essential Function Indicator: Yes



Conditions of Employment:
This position, during the course of university employment will be involved in the receipt of, or accountability for, university funds or other items of value, as well as the unsupervised access with the developmentally disabled, vulnerable adults or children under the age of 16. The offer of employment is contingent upon successful completion and passing of a background check prior to beginning employment.

COVID-19/MMR Requirement: All new employees must comply with EWU Immunization Policy 602-02 and provide proof of immunity or vaccination to MMR and proof they are fully vaccinated against COVID-19 before beginning work at EWU. Waivers for the immunization requirements are available for medical or sincerely held religious beliefs.

• COVID-19 Vaccination and Exemption Information link: https://inside.ewu.edu/hr/

This position is covered by the Washington Federation of State Employees Collective Bargaining Agreement.

Travel: Occasional travel relating to training/conference attendance
Salary Information: The salary range for this position is $77,544 (minimum) up to $101,736. Where the hired candidate will begin within this range is dependent on education, experience and skills.

Posting Date: 09/15/2021
Open Until Further Notice: No
Closing Date: 10/6/2021
Screening to Begin: 10/07/2021

Special Instructions to Applicants:
Submit your application materials through our online applications portal provided below. If you are unable to submit through the applicant portal, please contact Human Resources Services at (509) 359-2381.

To apply, visit https://jobs.hr.ewu.edu/postings/7320

EWU does not discriminate in its programs and activities on the basis of race, color, creed, religion, national origin, citizenship or immigration status, sex, pregnancy, sexual orientation, gender identity/expression, genetic information, age, marital status, families with children, protected veteran or military status, HIV or hepatitis C, status as a mother breastfeeding her child, or the presence of any sensory, mental, or physical disability or the use of a trained guide dog or service animal by a person with a disability, as provided for and to the extent required by state and federal laws.





Copyright 2021 Jobelephant.com Inc. All rights reserved.

Posted by the FREE value-added recruitment advertising agency

jeid-5089ba695ccab847a737c560b21d5595