Database Administrator

About Us Centralia College is on a 30-acre campus of modern buildings set among walking paths, lawns, and native plantings just a few blocks from the heart of Centralia, Washington. The college has served students in the Lewis County region since 1925 and is the oldest continuously operating community college in Washington State. The city of Centralia is a historic railroad and river shipping hub with a vibrant downtown and railway station. As a comprehensive community college, Centralia College offers academic transfer and workforce programs, as well as adult basic education, English as a Second Language (ESL), and personal enrichment classes. The college also offers five Bachelor of Applied Science degrees. In addition to the main campus in Centralia, Centralia College East in Morton is a smaller site that serves the needs of students in east Lewis County. Centralia College is committed to the success of all students, and thus also provides educational programs at two corrections centers in southwest Washington and one juvenile facility. In total, the college serves more than 4,800 students annually. For nearly 100 years, several generations of Lewis County residents have looked to Centralia College for their education and training needs. Centralia College is committed to student success, academic excellence, and enhancing and supporting our diverse community in an inclusive and equitable learning environment. We encourage applicants with demonstrated experience collaborating with, and serving, people from a wide range of backgrounds. For more information on Centralia College and the Centralia area, call 360-736-9391 or visit www.centralia.edu. Job Description As a member of Information Technology Services (ITS), the Database Administrator (DBA) plays a crucial role in maintaining and enhancing Centralia College's database infrastructure. This position focuses on the setup, security, and support of database servers, ensuring the integrity, availability, and performance of institutional data systems. The DBA collaborates with internal stakeholders to develop and refine database schemas, supports data-driven decision-making, and enhances reporting capabilities. Additionally, this role oversees database replication, security policies, and access controls to safeguard sensitive institutional data. The DBA also assists in data analysis and query optimization, ensuring seamless integration and automation between applications and databases. By maintaining a robust database environment, this position contributes to the efficiency, security, and effectiveness of Centralia College's technology ecosystem, supporting student success and operational excellence. Duties and Responsibilities Consult forums and documentation to determine hardware needs for database services Work with the System's Administrator to plan updates and upgrades as needed Use monitoring tools to monitor utilization and suggest additional resources as usage increases Use database administration tools to design and create databases needed by applications Modify and update existing databases as required for application updates Diagnose and repair data inaccuracies Discover cause of data inaccuracies when found and report them to the owner of the application Create process to migrate data between schema changes or to repair/remove inaccurate data Perform database performance monitoring and tuning, including index design and optimization In cooperation with the rest of the team maintain and update tools used internally Bring possible tool replacements or additions to the attention of the team for discussion Test possible tool replacements for functionality and fit into the environment Discuss findings and recommendations with the team after tool trial phase Develop scripts for monitoring and automation when suitable 3rd party tools are not available Use database monitoring tools to determine when replication is needed for a database Using performance monitoring tools, forums, and documentation work with the system administrator to configure additional servers as needed Continuously monitor replication schedules and logs for changes in timing as the amount of data being replicated changes and as new replications are added Design database schema(s) to contain and index data from various sources If possible, use native database import methods to populate databases with received data Design data import and transformation tools to bring non-standardized data formats into a database Develop ETL code for application integration. Identify sensitive data within database schemas, consult with data owner(s) if uncertain Create views and stored procedures to limit results to the data needed by the application/report Establish encryption/decryption procedures to protect sensitive data from theft Review logs for unauthorized access, consult with Infrastructure to determine source and scope of attack and to establish a plan to prevent additional leaks Control access to database objects through creation and maintenance of security groups Qualifications Associate degree in Computer Science/Computer Information Systems OR equivalent work experience AND One year of database admin experience Understanding of client/server interactions and server concepts are required for server administration Experience with servers and databases outside of a classroom Preferred Qualifications MCSE Certification Bachelor's degree in Computer Science/Computer Information Systems with a programming focus MS SQL is the main datastore for campus data Knowledge of advanced application and system design and development principles. Conditions of Employment This is an twelve (12) month per year, full-time professional technical exempt position. The salary is $101,000 - $104,000 (DOQ/DOE) annually depending on the qualifications and experience of the successful candidate. The state of Washington provides a comprehensive benefits package for state employees. The position may participate in the TIAA/CREF retirement system. DEADLINE: The screening committee will begin their first review on April 8, 2024. Position is open until filled. Compensation Annual Salary: $101,000 - $104,000 (DOQ/DOE) Application Process Interested candidates may apply by submitting the following items: Online Application Cover Letter that addresses your interest in the position and ability to perform the responsibilities described in this announcement. Detailed résumé of all educational and professional experience that demonstrates how you meet the qualifications. List of at least three professional references with contact information. References are typically contacted after interviews. Eligibility to Work If you are hired, you will need proof of identity, and documentation of U.S. citizenship or legal authorization to work. Background Check 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. EEO Statement Centralia College has a strong institutional commitment to the principles of diversity in all areas. In that spirit, we strongly urge all qualified applicants, especially people of color, persons of disability, women, and disabled and Vietnam era veterans, to apply. Centralia College is an Equal Opportunity employer. It is the policy of Centralia College to assure equal employment opportunity and non-discrimination on the basis of race or ethnicity, creed, color, national origin, sex, marital status, sexual orientation, age (over 40), religion, the presence of any sensory, mental, or physical disability, or status as a disabled or Vietnam-era veteran. Centralia College does not discriminate in admission or access to, or treatment or employment in, its programs or activities. Designated Title II, VI, VII, IX, Section 504, ADA compliance officer: Vice President for Human Resources and Equity, Hanson Hall Room 101, Centralia College, 600 Centralia College Blvd, Centralia WA 98531-4099, (360)623-8943. The Human Resources Office is accessible for persons with disabilities. Those who need disability accommodation in the application/employment process, please call (360)623-8943. Jeanne Clery Statement Notice of Availability of Annual Security Report-Centralia College's Annual Crime/Security Report is available here, containing mandated information about current campus policies concerning safety and security issues, required statistics, and other related information. To obtain a paper copy of the report, please call 360-623-8947. Title IX Statement Centralia College is compliant with Title IX best practices. For more information visit, Title IX.