Database Administrator/Developer

Clark College is currently accepting applications for a full-time, 12-month, exempt Database Administrator/Developer position in the Information Technology (IT) department. This position is responsible to develop and maintain a secure and efficient SQL Server environment and manage the data processes including ETL and data warehouse, serving the data requirements of the college community. This position will also collaborate with IT staff (Application Development and Infrastructure) and other college partners to provide data support to the college. 

 

At Clark, we value equity, diversity, and inclusion. We have not always gotten it right, but are committed to growing, learning, and supporting our employees. Our Office of Diversity, Equity, and Inclusion (ODEI) supports individuals with their academic, personal, and professional development, as well as provides training and educational resources for all members of the college community around diversity, inclusion, power, privilege, inequity, social equity, and social justice. The college offers further professional development for our employees through opportunities such as Employee Resource Groups, Social Justice Leadership Institute, Cross Institution Faculty of Color Mentorship program, Administrators of Color Leadership Program, and Faculty and Staff of Color Conference.

 

Clark College values diversity and is an Equal Opportunity Employer and Educator. Protected group members are strongly encouraged to apply.  Clark College provides equal opportunity in education and employment and does not discriminate on the basis of race, color, national origin, age, disability, genetic information, sex, sexual orientation, marital status, creed, religion, honorably discharged veteran or military status, citizenship, immigration status or use of a trained guide dog or service animal. Prohibited sex discrimination includes sexual harassment (unwelcome sexual conduct of various types). The college considers equal opportunity, affirmative action, and non-discrimination to be fundamental to the mission, vision and values of the college. All faculty and staff hired at Clark College are encouraged to embrace, continually support and enhance social equity on our campus and in our community. The college provides reasonable accommodations for qualified students, employees, and applicants with disabilities in accordance with the Americans with Disabilities Act and Federal Rehabilitation Act. The following person has been designated to handle inquiries regarding non-discrimination policies, Title II and Title IX, and Affirmative Action: Darcy Rourk, Interim Vice President of Human Resources, 360-992-2119, drourk@clark.edu, 1933 Fort Vancouver Way, Baird 012, Vancouver, Washington 98663. Clark College is a smoke-free/drug free environment.  This recruitment announcement does not reflect the entire job description and can be changed and or modified without notice.

• Design, develop, test, implement and maintain databases in MS SQL Server database environments. 
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. 
• Ensure systems meet industry best practices and business, security, privacy, and retention requirements. 
• Design and deploy complex ETL solutions and provide maintenance, troubleshooting, support, and performance improvements for various data sources, including Oracle databases. 
• Design, create and maintain middle tier / application server / application development interface (API) for accessing data, reconfigurations of existing data, and datasets. 
• Design, develop and maintain on-premises and cloud-based data structures such as data marts, data warehouses, data lakes, and data pipelines. 
• Create various complex SQL Queries, Stored Procedures, Views, Cursors and User Defined Functions to implement the business logic. 
• Collaborate with Application Development and other college partners to provide database setup, configuration, optimization, and modification support to college staff. 
• Write Business Intelligence reports. 
• Optimize and tune queries for performance. 
• Refine and automate regular processes. 
• Ensure all database programs meet the college’s security and performance requirements. 
• Remain current on data architecture, analytics, and data science developments. 
• Develop technical documentation and training manuals. 
• Perform other duties as assigned.

Minimum Qualifications:

• Bachelor’s degree in Data Science, Computer Science, Science, Technology, Engineering & Math (STEM), or relevant analytical field. 
• Five (5) years’ experience with DBA, SQL development and ETL implementation. 
• Advanced knowledge of database security, backup and recovery, replication, and performance monitoring standards. 
• Extensive experience with Microsoft SQL Server and coding techniques to write views, stored procedures, and functions. 
• Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies, ODS, ETL/ELT process, and data modeling. 
• Experience in working with Microsoft SQL Server BI stack including SSAS, SSIS, and SSRS with SQL Server Data Tool (SSDT). 
• Experience developing, architecting, and deploying data warehouses with Microsoft SQL Server. 
• Experience developing ETL processes with Microsoft SQL Server Integration Services packages. 
• Experience with Performance Tuning and Optimization. 
• Demonstrated ability to understand, discuss and document complex data models. 
• Effective oral, written communication skills and strong analytical problem-solving capabilities. 
• Effective communication skills to facilitate gathering and understanding requirements from business groups. 
• Motivated to learn new skills and technologies. 
• Ability to work well with people of all ages from academically, culturally, and socioeconomically diverse backgrounds.

 Preferred Qualifications:

• Experience with Oracle. 
• Experience implementing ETL processes using Python.
• Experience with data visualization development, preferably using Tableau.

Salary Statement: $81,365/annually

Benefits include vacation/ sick leave; medical, dental, life and long-term disability insurance; retirement; and tuition waiver.

 

APPLICATION PROCESS

Required Online Application Materials:

• Clark College Online Application 
• Cover letter describing background and experience related to qualifications and responsibilities of the position
• Current résumé 
• Unofficial copy of all transcripts/certifications uploaded with online application or delivered to the Human Resources office in person or by fax (360-992-2873).

 

To contact Clark College Human Resources, please call (360) 992-2105.

 

Application Deadline:  

Required application materials must be completed and submitted online by 3 p.m., May 17, 2021.

 

Condition of employment:

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. Completion of academic degrees will also be verified through receipt of official transcripts.

 

DISABILITY ACCOMMODATIONS

Upon request, accommodations are available to persons with disabilities for the application process. Contact Human Resources at (360)992-2105 or by video phone at (360)991-0901.

 

SECURITY

The security of all the members of the campus community is of vital concern to Clark College. Information regarding crime prevention advice, the authority of the Security/Safety Department, policies concerning reporting of any crimes which may occur on or near college property, and crime statistics for the most recent 3-year period may be requested from the Clark College Security/Safety Department, (360) 992-2133 or security.requests@clark.edu. The most recent Annual Security Report, written in compliance with the Clery Act, can be reviewed here: http://www.clark.edu/campus-life/student-support/security/report.php. 

 

ELIGIBILITY VERIFICATION

If you are hired, you will need proof of identity, and documentation of U.S. citizenship or legal authorization to work.

 

CORRECTIONS OR EXTENDED NOTICES
 Corrected or extended notices will be posted online and in the Human Resources Office.

 

Clark College Human Resources

May 3, 2021

21-00023