ID: 7150852 (Ref.No. R-3995)
Posted: May 27, 2023
Application Deadline: Open Until Filled
Job Posting Closing Times: Job postings are removed from advertising at 12:00 A.M. on the closing date e.g., at midnight on the day before the closing date.
Austin Community College is a public two-year institution that serves a diverse population of approximately 41,000 credit students each Fall and Spring semester. We embrace our identity as a community college, as reflected in our mission statement. We promote student success and community development by providing affordable access, through traditional and distance learning modes, to higher education and workforce training, including appropriate applied baccalaureate degrees, in our service area.
As a community college committed to our mission, we seek to recruit and retain a workforce that:
Reflects the diversity of our community
Values intellectual curiosity and innovative teaching
Is attracted by the college's mission to promote equitable access to educational opportunities
Cares about student success and collaborates on strategies to facilitate success for under-represented populations
Welcomes difference and models respectful interaction with others
Engages with the community both within and outside of ACC
Commitment to Equity and Inclusion
ACC is committed to the ongoing systemic changes needed to ensure the increased recruitment, inclusion, retention, and completion of historically underserved and underrepresented populations. Through continual strategic community engagement and professional development of administrators, faculty, staff, and students, the college demonstrates its dedication to fostering a culture and climate for equitable outcomes.
ACC is proud to serve a diverse student body as an open-access and low-cost institution. Dedicated faculty members are excellent professors who help students achieve their educational goals and are sensitive to our students' diverse cultures and socio-economic backgrounds. In 2017 our faculty adopted a Statement of ACC Faculty Values. This Statement affirms that ACC's faculty members value collaboration, service, agency, scholarship, inclusion, and teaching, all of which attest to our commitment to equity, diversity, and inclusion at the heart of our mission.
Job Posting Title:Administrator, Database
Job Description Summary:To administer, develop, implement, and maintain the collegewide databases in a diverse multi-vendor client server environment.
Reports to: Manager, ERP Services
General Statement of Job
Under the supervision of the ERP Services Manager, the Database Administrator oversees the creation, administration, and maintenance of critical database systems, jobs, and processes that support ACC’s vision. The Database Administrator will work within an IT as a Business (ITaaB) model wherein the maintenance of core database business processes, service/operating-level agreements and success metrics will be a primary responsibility.
The Database Administrator will be responsible for the overall administration of ACC’s database-driven systems in conjunction with our solutions delivery teams and users external to IT, as directed and specified by the ERP Services Manager. The Database Administrator will also be responsible for the administration, monitoring, troubleshooting, and enhancement of supported database systems and associated processes.
The Administrator will need to be detail-oriented, organized, and analytical, helping the college to enhance its operations through the implementation of secure, stable database systems.
Description of Duties and Tasks
Essential duties and responsibilities include the following. Other duties may be assigned.
Coordinates with application developers regarding database development, migration, revision and update, procedure development, troubleshooting, system configuration, and account setup.
Installs, deploys, and upgrades database systems, maintains documentation, and performs routine database maintenance activities.
Configures, monitors, and analyzes the performance and health of databases; resolves database performance, capacity, and distributed data issues.
Provides assistance to end users and programmers regarding database-related problems and issues.
Initiates processes and documentation of college-wide data warehousing system; develops procedures to ensure security and integrity of data.
Coordinates with IT project managers, programmers, web developers, and operational staff to define and ensure standards for database performance, availability, and security are being met.
Develops and monitors the process for synchronization between different database management systems.
Manages end-user accounts and accessibility; provides technical expertise to end-users who create complex queries and virtual fields.
Coordinates, schedules, and tests upgrades to the college-wide database system.
Researches and evaluates software, system upgrades and enhancements, and provides technical recommendations.
Keeps current with the latest technology; regularly attends technical training in order to maintain technical expertise.
Performs database administration and maintenance including database backups, performance monitoring and tuning, application T-SQL queries turning and update indexes, and databases upgrading as well as system patching.
SQL programming concepts including T-SQL and SSIS.
Administration of various versions of SQL Server (2012, 2016, 2019) and MySQL.
Experience with Unidata is preferred but not required.
Database systems and development theories.
Database integrity and security standards.
Effectively using interpersonal and communications skills including tact and diplomacy.
Effectively using organizational and planning skills with attention to detail and follow-through.
Installing, deploying, and upgrading database systems.
Monitoring and analyzing the performance of database systems using a variety of tools, including Spotlight and products from Redgate.
Providing technical assistance to end users regarding database issues and problems.
Providing technical assistance with ETL functions, including ERP-specific extracts and third-party (iPaaS) jobs.
Creating and documenting database tables, views, data elements, and shared data rules.
Performing database maintenance activities such as database backups, copying databases, creating accounts and enforcing database security.
Maintaining confidentiality of work-related information and materials.
Establishing and maintaining effective working relationships.
Maintaining an established work schedule and providing assistance outside of usual work hours, including nights, weekends, holidays, winter, and college holidays as required.
Required Work Experience
2+ years experience managing enterprise database systems, including those powered by Microsoft SQL Server
2+ years experience working with high-availability (clustered) SQL environments.
Experience completing at least 2 full SQL version upgrades.
Must have experience preparing technical specifications, detailed design documents, and ITIL-guided RFCs.
Bachelor’s degree in Information Technology or related field
ITIL Foundation Certification or higher
Must have a valid driver's license
- Work is primarily performed in a standard office or remote/hybrid environment.
$82,756 - $103,445
Number of Openings:1
Job Posting Close Date:June 9, 2023
As required by the US Department of Education, employees are required to report violations under Title IX and, under the Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act (Clery Act), select individuals are required to report crimes. If this position is identified as a Campus Security Authority (Clery Act), you will be notified, trained, and provided resources for reporting.
The above description is an overview of the job. It is not intended to be an all-inclusive list of duties and responsibilities of the job, nor is it an all-inclusive list of the skills and abilities required to do the job. Duties and responsibilities may change with business needs. ACC reserves the right to add, change, amend, or delete portions of this job description at any time, with or without notice. Employees may be required to perform other duties as requested, directed, or assigned. In addition, reasonable accommodations may be made by ACC at its discretion to enable individuals with disabilities to perform essential functions of the job.