Job Description

 

DESCRIPTION

Starting salary for this position is: $5,319 (Monthly)

Employees starting at the entry step of this range receive salary step advancement after six months and every 12 months thereafter. If an employee starting at anything higher than the entry step of the range, will have salary step advancement after 12 months and salary step advancement every 12 months thereafter until they reach the top of the salary range. Each salary step advancement will be approximately a 5% increase in salary.

Community Colleges of Spokane (CCS) District Equity Statement 
 
CCS believes that access to high-quality education in a safe and inclusive environment is the right of all individuals and imperative for the continued advancement of a strong democracy and workforce. We also believe higher education institutions have an obligation to work toward and demonstrate progress in ensuring equity amongst their students, faculty, and staff. Equity is grounded in the principle of fairness. In higher education, equity refers to ensuring that each student receives what they need to be successful through the intentional design of the college experience.

The Information Technology division for the Community Colleges of Spokane (CCS) is seeking a Database Administrator. We seek candidates with strong technical skills and a passion for improving the lives of students, staff and faculty in a dynamic teaching and learning environment. Our strong, client-focused team puts students first, promotes equity through accessible learning and information technologies, and provides responsive service with excellence and integrity. We are excited to welcome a new team member!

 Please be aware that this recruitment closes at 4:00 p.m. PST. The application process will not be available after this time. To ensure consideration make sure your application is completed and submitted as soon as possible. Applications will only be accepted prior to 4:00 p.m. on the closing date.

 JOB SUMMARY

The Information Technology Division (IT) deploys strong technical skills and a passion for improving the lives of students, staff and faculty in a dynamic teaching, learning, and working environment. IT puts students first, promotes equity through accessible learning and information technologies, and provides responsive service with excellence and integrity.

The Information Systems and Development Services (ISDS) department within IT provides database, application development, and integration support for IT solutions at Community Colleges of Spokane (CCS). The Database Administrator position, under general direction of the department supervisor, independently performs advanced analysis, design, technical coding, and database management tasks to resolve complex application database issues.

As a member of a team, this position applies technical knowledge to perform intermediate complexity tasks such as: planning, recommending, and implementing complex database projects; facilitating application interfaces and application integration; analyzing and resolving problems; assisting others in de-bugging problems with vendor products; researching environment issues, platforms, database software and hardware requirements; and performing data analysis and data flow diagramming. The incumbent must understand the customer’s business needs and implement solutions accordingly. Most of the tasks performed by this position have districtwide or multiple-functional area impact. Tasks may require integration of new technology, and/or change how the organizations’ missions are accomplished.

CHARACTERISTIC DUTIES AND RESPONSIBILITIES

• Participate in and contribute to ISDS department and CCS IT division meetings and collaborations. *
• Document all work efforts adequately for self and colleagues/supervisor using the CCS IT division and ISDS department standard work tracking system(s) and approach (currently FreshService tickets). *
• Model and support positive and respectful communication and service to colleagues, supervisor(s), stakeholders/clients, and the public. *
• Ensure accurate and efficient operation and availability of CCS data environments and the data, dependencies, logic, and components within those environments. *
• Respond efficiently to concerns and issues as surfaced through spoken, print, or electronic communications including but not limited to voice, text/chat, email, phone, and ITSM (FreshService) system tickets. *
• Assist with planning, researching, developing, testing, implementing, enhancing, and maintaining data integrations involving components including but not limited to automated and manual SQL Agent jobs, PowerShell scripts and modules, SSIS packages, tables, views, stored procedure, functions, etc. in order to provide data to and/or get data from remote and local databases and related systems in support of CCS use of third-party and locally-developed IT solutions. *
• Work with staff at the Washington State Board for Community and Technical Colleges (SBCTC) and its member and partner colleges, CCS Institutional Research (IR) Office, and other CCS functional areas and user groups to gather information, define database requirements, and develop implementation plans pertaining to the database objects and components required; monitor performance on data solutions. *
• Assist with designing systems, which may include such tasks as: system modeling, system mapping and planning system connectivity or re-configuring existing systems; assist with building systems to meet required standards and integrate and certify software/hardware. *
• Assist with planning, consulting on, coordinating and facilitating the installation of systems, hardware, software, application interfaces, and applications; assist with resolving complex installation problems coordinating with installation vendors; assist with creating and supporting processing environments (test, demo, production) including patches and systems security. *
• Assist with designing and implementing physical databases from logical models; request disk space, develop load procedures and prepare data for loading; monitor database management system and application performance; analyze and document performance problems. *
• Perform data analysis and design a data repository (staging area) to support the data warehouse; including design and development of applications for maintaining and reviewing repository information; train and assist staff in the use of the data repository; work with technology support to define and implement database security procedures. *
• Assist with writing database documentation, including data standards, procedures and definitions for the data dictionary ('metadata'), and deployment procedures; design end user interfaces including wizards for data modeling and reporting; assist with developing best practices and training staff for data loading and extraction into and out of the data warehouse. *
• Identify and define business requirements of end users as it applies to database and application development; develop and maintain district-wide database standards, naming conventions, performance analysis, and deployment procedures. *
• Represent organization-wide computing standards and philosophy at meetings in relation to projects; report information appropriately back to colleagues, unit manager and administrator. *
• Model professional decorum and mutual respect in all personal interactions. *
• Comply with district policy, procedures and directives, state and federal regulations, orders and statutes and collective bargaining agreements. *
• Support and advance the CCS strategic plan, and perform other duties as assigned. *

* Indicates this is an essential duty.

This position is designated a bargaining unit position.

 

COMPETENCIES & OTHER REQUIREMENTS

COMPETENCIES

• Manages Complexity: Experience making sense of complex, high-quantity, and sometimes contradictory information to effectively solve problems.
• Decision Quality: Ability to make good and timely decisions that keep the organization moving forward.
• Action Oriented: Takes on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
• Plans & Aligns: Plan and prioritize work to meet commitments aligned with organizational goals.
• Ensures Accountability: Ability to hold self and others accountable to meet commitments.
• Drives Results: Consistently achieves results, even under tough circumstances.
• Collaborates: Builds partnerships and works collaboratively with others to meet shared objectives.
• Instills Trust: Gains the confidence and trust of others through honesty, integrity, and authenticity.
• Demonstrates Self-Awareness: Uses a combination of feedback and reflection to gain productive insight into personal strengths and weaknesses.
• Self-Development: Actively seeks new ways to grow and be challenged using both formal and informal development channels.
• Nimble Learning: Actively learns through experimentation when tackling new problems, using both successes and failures as learning fodder.
• Situational Adaptability: Adapts approach and demeanor in real time to match the shifting demands of different situations.

MINIMUM QUALIFICATIONS

• Options:
  • 3 or more years’ experience with data analysis and design in a SQL Server environment including database administration and development experience creating stored procedures and SSIS packages.
  • Associate degree in a computer science-related field and 2-3 years of the above experience.
  • Bachelor’s degree in a computer science-related field and at least 1 year of the above experience.
• Experience with Microsoft server platforms and technologies as well as Visual Studio and PowerShell.
• Knowledge of and experience with ETL systems, particularly related to MS SQL Server Integrations Services (SSIS), SQL Server Analysis (SSAS) and SQL Server Management Studio (SSMS).
• Must be a detailed-oriented self-starter focused on understanding and solving identified problems.
• Consistent modeling of positive and respectful communication (spoken, written, and otherwise) and service to colleagues, supervisor(s), stakeholders/clients, and the public.
• Consistent maintenance of a high level of professionalism, working to establish a positive rapport with clients, colleagues and others.
• Strong focus on positive conflict resolution and empathy toward understanding and giving student other stakeholder perspectives and needs high priority.
• Ability to define problems, collect data, establish facts, and draw valid conclusions. 
• Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with multiple abstract and concrete variables.
• Ability to effectively deal with ambiguity and changing project requirements and to be flexible and responsive in working relationships.
• Ability to work with non-technical end users and other stakeholders and participants in database-related projects and initiatives. 
• Flexibility and adaptability to change within the IT division and the ability to have a positive overarching participatory view of change within the global CCS organization.
• Ability to effectively participate in cross-functional teams and collaborate with colleagues in other departments and other institutions/organizations – including vendor/partner representatives.
• Consistent delivery of accurate and timely work. 
• Strong multi-tasking skills and ability. 
• Strong project management skills.

DESIRED QUALIFICATIONS

• Database experience in a development environment.
• Microsoft Certifications: MCDBA, MCSD, MCAD.
• Working knowledge of Internet/Web technology (browsers, firewalls, and security). Experience working in C# and the .NET environment.

 

CONDITIONS/TERMS OF EMPLOYMENT

TOTAL COMPENSATION WITH BENEFITS:  $82,920 - $107,734.
 
Total compensation is an estimate based upon adding the following amounts together:

• Base compensation of $63,828 - $85,848, plus 
• Current employer-paid health and related benefit contribution rates, plus
  • Click here for a full list of benefits.
• Median retirement fund contributions. 

The actual total will vary depending upon each employee's enrollment choices.

Person hired must be able to provide acceptable documentation of U.S. Citizenship or lawful authorization to work in the United States. This is an absolute condition of employment. An offer of employment will not carry with it any responsibility or obligation on the part of the district to sponsor an H1-B visa. In addition, the Community Colleges of Spokane maintains a drug-free work environment and prohibits all smoking in the college buildings and state-owned vehicles. Must be able to successfully work in and promote a multicultural work and education environment.  

Prior to a new hire, a background check including criminal record history will be conducted. Information from the background check will not necessarily preclude employment but will be considered in determining the applicant’s suitability and competence to perform in the position. Once an applicant is chosen for a position, they are required to complete and submit a declaration regarding sexual misconduct and investigation per state law.

PHYSICAL REQUIREMENTS

• Work is performed in an office environment with frequent interruptions and background noise.
• Work is and sedentary
• Work directly with clients.
• Frequent oral and auditory communication with others.

CONDITIONS OF EMPLOYMENT

• Full-time schedule (12-month, 40-hours a week).
• 6-month probationary period. 
• This position is overtime eligible.
• May require local or regional travel. 
• Criminal background check is required.

 

 

REQUIRED APPLICATION MATERIALS

To qualify for consideration, applicants must meet required competencies and submit a complete application packet, which includes the following:

• CCS online application. *
• Cover letter addressing your qualifications relevant to the responsibilities of this position. *
• Resume. *
• References – the names, addresses, and phone numbers of three professional references. *
• College transcript(s) if applicable - unofficial/copies of transcripts are acceptable for initial application, official copies must be submitted upon acceptance of job offer.

NOTE:  All of the above are required to ensure your consideration for this position.  The item(s) marked with an asterisk are required attachments to your application prior to submission. 
 
If you require an accommodation during the application or interview process, please contact HR at CCS.recruiter@ccs.spokane.edu
 
Community Colleges of Spokane does not discriminate in its programs, activities and employment on the basis of race, creed, color, religion, national or ethnic origin, age, sex, marital status, pregnancy, pregnancy related conditions, parental status or families with children, status as a mother breastfeeding her child, AIDS/HIV or hepatitis C, honorably discharged veteran status, sexual orientation, gender identity or expression, disability, use of trained guide dog or service animal by a person with disability, genetic information or any other legally protected category.
 
Direct all inquiries or grievances regarding access and Title IX or ADA to:
 
Amy McCoy | Chief Compliance Officer
Title IX and ADA Coordinator
Community Colleges of Spokane
2917 W. Whistalks Way, MS 3027
Spokane, WA. 99224-5288
ccs.titleix@ccs.spokane.edu
509-279-6012
 
Direct all inquiries regarding equal opportunity compliance and/or grievances to:
 
Greg Stevens | Chief Strategy and Administration Officer
Community Colleges of Spokane
P.O. Box 6000, MS1004
Spokane, WA. 99217-6000
509-434-5040
 
Native Land Acknowledgement

We are honored to acknowledge that the Community Colleges of Spokane, and our main campuses for Spokane Falls and Spokane Community College, are located on the traditional and sacred homelands of the Spokane Tribe. We also provide services in a region that includes the traditional and sacred homelands of the Coeur d’Alene Tribe, Confederated Tribes of the Colville Reservation, Kalispel Tribe and Nez Perce Tribe.
 
We pay our respect to tribal elders both past and present as well as to all Indigenous people today. This land holds their cultural DNA, and we are honored and grateful to be here on their traditional lands. We give thanks to the legacy of the original people and their descendants and pledge to honor their stewardship and values.

 

*Please mention you saw this ad on AcademicJobs.*

Apply Now