AC Transit is actively recruiting for the position of Database Administrator in the Information Services Department. Under general supervision, maintains and modifies a database; analyzes system performance; designs and writes queries and programs; designs, documents and implements all system and server processes including security, access, test routines, and back up; modifies existing programs to user requirements; troubleshoots and resolves malfunctions; writes systems documentation; and may provide work direction to journey and lower level programmers. This is an excellent opportunity to work in IT at one of the largest bus agencies in California. In addition to working with some of the best in the business, AC Transit also has an outstanding benefits package that includes pension, medical, dental and vision coverage, flexible spending and a 457 savings plan.

• Designs, documents and implements security, back up and recovery of assigned database(s) and indexes, runs performance queries, and schedules systems maintenance. 
• Administers systems security, and assigns appropriate access privileges to end-users.
• Writes and/or modifies software programs using database languages.
• Writes and tests scripts used to build, restore, dump, and/or maintain databases.
• Uses system commands and protocols to maintain network systems and/or databases.
• Designs and implements testing routines to identify and resolve (de-bug) conflicts and potential operating malfunctions.
• Analyzes database architecture and monitors disk-usage to maintain integrity of database(s) and/or servers, and reconfigures or relocates data for optimal performance.
• Design application programs to minimize run time and response times.
• Documents procedures, and provides user information and training materials.
• Troubleshoots and resolves malfunctions with databases, servers, operating platform/database interfaces, and networked systems.
• Confers with end-users to identify user needs, and with vendors regarding programming and/or systems upgrades.
• Estimates time and resources needed for projects, develops project schedules, and may help end users prepare service request forms. 
• Performs related duties as required.

Education/Training: Equivalent to an Associate's degree in Computer Science, Mathematics, or a related field, OR certification of completion of a recognized program in Computer Science.
 
Experience: Two (2) years experience in a data processing related field in a client-server environment, one (1) year of which must include performing a variety of tasks in support of administering a database. Additional education may be substituted for up to one year of the general experience on a year for year basis.

Desirable Experience: 

• Experience with very large transactional systems, production support, disaster recovery, Big Data, Microsoft Azure data platform, Power Platform, Power BI and SharePoint Online.
• 7 years of progressively responsible experience in database technology or Business Intelligence including development. Experience with location technology, GIS  and public transit are plus.
• Bachelor degree in computer science or a closely related field. Microsoft Azure Data Platform certification or proficiency in Python scripting is preferred.  

License Requirement: Must possess, or obtain and maintain a valid California Class C Driver License and meet the District's safe driving standards.

Physical Requirements: Must maintain the physical condition necessary to: (1) perform tasks in an office setting operating a personal computer, keyboards, and other peripheral equipment; (2) possess physical mobility in order to travel within the District for meetings and presentations; and (3) grasp, lift, and transport marketing materials and equipment weighing up to fifty (50) lbs.  

THIS POSITION IS A UNION POSITION, REPRESENTED BY AFSCME

Equal Opportunity Employer