Full-Time Database Administrator/Developer
Job Description
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, dr****@cl***.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.
Job Duties and Responsibilities:
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).
Please apply online at www.clark.edu/jobs
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.
How to Apply
Please apply online at www.clark.edu/jobs438 total views, 0 today