Database Administrator III
Job Title Code
Salary Range (Full-Time)
$6,250.00 mo. - $7,187.50 mo. (dependent on experience and other considerations)
The Database Administrator III position will work with the Senior Database Administration Manager and other members of the DSC SQL Team to provide Administrative Support for the Microsoft Windows OS multiple SQL Server Infrastructure Production and Development/Test environments at the District Service Center, LeCroy Center and in the Microsoft Azure Cloud. The Primary Production SQL Servers consist of multiple High-Availability SQL AlwaysOn environments with SQL Nodes on premise at the DSC as well as at the DCCCD LeCroy Center and/or in the Microsoft Azure Cloud. There are also some stand-alone SQL environments that also require Administrative support from the DSC SQL Team.
This DBA III position will have responsibilities for installing, configuring, ensuring a secure SQL environment and performance monitoring with various available software tools for these multiple SQL environments. This position must have a strong knowledge of how to configure the network environment including some mixed-subnet SQL Server environments. A solid understanding of configuring Microsoft Windows Active Directory Accounts & Groups with occasional Local SQL Logins access permissions for SQL Server and Windows Drive Shares.
This position will also work with other Workgroup Teams, outside Vendors as well as at times the individual Colleges to assist them as needed with their separate SQL environments or their SQL databases being hosted on a designated SQL Server AlwaysOn environment established by the SQL Team.
This person will at times write SSIS packages, Transact-SQL (T-SQL) code, PowerShell Scripts or other type scripts required to support currently implemented or new applications as needed to support the various DBA or end-user SQL initiatives.
An advanced level IT database position responsible for providing technical support for DCCCD’s database environment, which includes the development and organization of databases, performance reporting, business intelligence tools, assessment and implementation of new technologies.
Required Knowledge, Skills & Abilities
Advance knowledge of database structure, database modeling/design, theory, monitoring, maintenance, capacity planning, security, and administration of complex databases. The ability to establish, document and enforce procedures and policies related to database management and systems. Knowledge of applicable data privacy practices and laws. In-depth experience with the development lifecycle and software development methodologies. The ability to diagnose and resolve computer related problems quickly and effectively. Strong experience of project management procedures with proven ability to multitask with tight timelines, budget constraints and high client expectations. Must be able to work in fast-paced, constantly changing environment. Ability to form collaborative partnerships grounded in trust and integrity with customers, peers, stakeholders, and leadership in a diverse environment. Interpersonal, creative skills that allow effective, proactive working relationships in a team-oriented environment. Familiarity with principles and practices of Change Management, Configuration Management and Systems Development Lifecycle. The ability to use logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems. The ability to analyze and determine data relationships and attributes, data flow and storage requirements and data output and reporting capabilities. The ability to work in a fast-paced environment, organize, prioritize and manage multiple workloads and projects with minimal supervision. Effective business communication with experience in communicating to technical and business constituencies orally and in writing regarding business specifications and requirements. Able to communicate with all levels of management, internal and external customers and the ability to present ideas in a user-friendly language. Must be able to provide excellent customer service.
Normal physical job functions performed within a standard office environment. Reasonable accommodations may be made to individuals with physical challenges to perform the essential duties and responsibilities.
Minimum Knowledge and Experience
Bachelor’s degree plus four (4) years of work related experience in a complex multi-platform environment. Must have current and valid driver’s license required for off-site travel. On-call, work hours may extend beyond the regular, eight hours, Monday-Friday, workday, including weekends and holidays to provide immediate support due to system failures on a 24/7 basis. Official transcripts are required. *** Will be subject to a criminal background check. Some positions may be subject to a fingerprint check. ***
Essential Duties and Responsibilities
Responsible for the technical design, development, testing and implementation of database applications utilizing complex development procedures and techniques that support the requirements defined by users and analysts. Maintains integrity of development and production environments to ensure availability, validity and authorized access of data stored within selected centralized district database systems. Translates and documents customer requirements, recommend system solutions and formulate detailed specifications from which enterprise applications are developed. Assists in the development of processes for exchanging information between multi-platform database systems. Provides technical expertise for database related problems. Keeps up-to-date on best practices and technological changes by participating in professional development activities. Works collaboratively with diverse team members and business partners within the DCCCD community network in defining, designing, developing and implementing technology solutions to improve business functions including the ability to collect, store process and retrieve data. Prepare reports, logs, and specification documents as required. Controls migrations of programs, database changes, reference data changes and critical patch updates through the development cycle. Provides leadership in the design, coordination and implementation of a disaster recovery strategy for centralized database systems. Responsible for suggesting, reviewing and justifying new technical tools and techniques and managing their implementation. Validates that the database platforms supporting technologies are operating according to district standards according to design specifications. Coach, train, and mentor other employees on proper access and use of database systems. Continually ensures completeness and compatibility of the technical infrastructure and data warehouse implementation to support system performance. Develop system documentation for all developed applications databases, processes, and jobs including flowcharts and data models. Performs other duties as assigned.