Database Administrator- Journey Hiring for Database Administrator- Journey Job at Cheney, WA Full Time

About Eastern Washington University:
Eastern Washington University, a regional, comprehensive public university with an enrollment of over 10,000 students, is one of six state-funded four-year institutions of higher education in Washington, each governed by its own board of trustees. EWUs 300-acre main campus is located in Cheney, a community of 12,000 residents 16 miles southwest of Washingtons second largest city, Spokane. Eastern also offers programs in downtown Spokane at the innovative, energy-efficient Catalyst building and at Riverpoint, a campus shared with Washington State University. In addition, EWU programs can be found at select locations throughout the state, aligned with the needs of the community. Eastern contributes to the vitality of the region and the state through its wide array of bachelors and masters degrees in over 100 fields of study, as well as applied doctorates in physical therapy and educational leadership, offering accessible pathways to career success and personal development to students of all socioeconomic and cultural backgrounds.

Tribal Land Acknowledgement
Eastern Washington University resides within the traditional homelands of the Spokane People and other tribes who are connected through their shared history of this region. This land holds their cultural DNA and it is their Ancestors who are here and bring forth the knowledge of this place-the knowledge that comes from the land.

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 Enterprise Application 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.

• This is a remote or hybrid remote position.

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, generous paid vacation and sick leave, 12 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 OR equivalent IT work-related experience may be substituted for degree.
• Two years of Oracle database administration experience that includes database maintenance, database design and query language programming.
• Two years of other database administration experience (Microsoft SQL Server, MySQL/MariaDB, PostgreSQL, or equivalent) that includes database maintenance, database design and query language programming.
• Experience implementing, managing and administering complex, enterprise systems.
• 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

• Demonstrated interest, ability and/or experience promoting cultural competency, universal accessibility, and/or diversity.

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 databaseprojectserver 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:

• The combination of all job responsibilities/duties equals 100%.

Installation, maintenance, and development. Install, upgrade, and provide development and design support for database systems and select applications.

Tasks:

• 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.

Tasks:

• 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.

Tasks:

• 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.

Tasks:

• 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.

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.

Upon hire – You must complete required DEI, Hazing, and Harassment and Title IX training. The training will be available online, in person or via Zoom. In person and Zoom training opportunities will be posted on InsideEWU and listed on Human Resources webpage.
Salary Information: The salary range for this position is $80,064 (minimum) up to $105,060. Where the hired candidate will begin within this range is dependent on education, experience and skills.

Posting Date: 12/15/2022
Open Until Further Notice: Yes
Closing Date:

Screening to Begin: 01/03/2023

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/9853

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.

jeid-b5bb0acaa15da9439904f190e74c6828