Performs a variety of highly complex professional work in the analysis, design, implementation, maintenance, problem resolution, and technical optimization of system databases and database management software in client-server, and Internet/Intranet environments. Provides technical support for database management systems and related system software in client-server and Internet/Intranet environments. Performs other technical tasks relative to the administration of City databases.
Provides direct support for the design, customization, development, and implementation of database application software from multiple sources, both in-house and vendor-provided. Provides direct support for the integration of data from, and interfaces and data flows between and among multiple applications from multiple sources, both in-house and vendor-provided, on multiple platforms, in multiple locations.
Database Administrators 1 and 2 are flexible classifications. Advancement to Database Administrator 2 occurs by acquiring and demonstrating advanced skills and is based on section manager approval.
DISTINGUISHING CHARACTERISTICS
Database Administrator 1: This is the first level in the series and is distinguished from the second level by the breadth and depth of assigned duties and activities. Employees at this level are fully skilled in relational database design, SQL programming, SQL Server administration, optimization, database and application troubleshooting, system analysis and design, network fundamentals, GIS fundamentals and implementing multi-tier applications. This level requires experience in project management, teamwork skills and providing excellent customer service.
Data Base Administrator 2: This is the second level in the series and is distinguished from the first level by the breadth and depth of assigned tasks and activities. In addition to the skills of the Database Administrator 1, employees at this level are fully skilled in several of the following areas: implementing complex multi-tier application architecture, Windows and SQL Server security schemes, Microsoft Analysis Server, Data Warehouse design and implementation, Tuxedo Application Server administration, XML data interfaces, advanced Data Transformation Services, SQL Server Replication, SQL Server CE and interfaces, enterprise-wide data management techniques, and server-side controls and auditing. This level requires extensive experience in project management, teamwork skills and providing excellent customer service.
SUPERVISION RECEIVED AND EXERCISED
Receives general direction from a higher classification.
May involve project leadership duties.
The Database Administrator 2 provides lead direction to the Database Administrator 1.
The Database Administrator 2 may exercise direct supervision over professional, technical and/or clerical staff.
EXAMPLES OF DUTIES - Duties may include, but are not limited to, the following:
Installs, configures, administers, and tunes database management system software. Monitors system performance; implements changes as necessary.
Analyzes business service areas and develops conceptual and logical information and database models to be used for actual information system databases.
Provides implementation, architecture, and operational support of purchased database application software, including PeopleSoft Financials/HRMS, TIER Budgets, and Gaylord On-line Catalog, etc.
Develops and implements database backup and recovery plans.
Researches and analyzes complex technical problems, database-related system errors, or application software problems. Isolates problem areas. Recommends and/or develops and implements solutions.
Meets with departmental and Information Services Division staff to develop detailed data models; provides guidance and expertise in the development of database models.
Develops and implements physical database designs to ensure efficient and reliable information access.
Researches and analyzes upgrades and service packs of database management and operating system software. Recommends, installs, or participates in installation of upgrades and service packs on multiple servers. Assists development teams in preparing applications for upgrades when necessary.
Participates in and reviews work performed by professional and technical staff.
Develops and implements data replication across database servers.
Serves on a variety of interagency committees and task teams.
Manages contracts with hardware and software vendors.
Supports and respects diversity in the workplace.
Ensures implementation of and adherence to the City=s Affirmative Action and Diversity Work Plans. Coordinates the implementation of effective processes and models to produce division wide diversity initiatives. Facilitates staff development on such issues as diversity and creating a respectful working environment.
Performs related duties as assigned.
The following duties may be performed by employees in either classification, but are usually performed at the full scope by employees at the Database Administrator 2 level:
Plans, executes, and monitors database security plan.
Leads large, complex database projects involving other technical staff
Designs, develops, and maintains systemwide database policies and procedures in such areas as data security, integrity, backup, and recovery.
Researches current and future trends in computer technology generally, and database technology specifically. Provides expertise and direction on the appropriate application of new database technology.
Develops and implements data warehouses and Online Analytical Processing (OLAP) servers.
Implements and administer advanced SQL Server functionalities such as Data Transformation Services, Replication Services, SQL Server Job Scheduling.
Administers and manages distributed computing infrastructure middleware products and tools for Online Transaction Processing (OLTP), including BEA TUXEDO and PeopleSoft Internet Architecture.
Participates in design and support of regional shared databases, including geographical (GIS) data.
Participates in GIS application development and administers ESRI ArcIMS Server.
Provides lead direction to the Database Administrator 1.
If supervisory duties are assigned to the Application Systems Analyst 3: Responsible for the selection, supervision and evaluation of assigned staff; assigns work and ensures appropriate training is provided; investigates complaints; recommends and administers disciplinary actions; handles sensitive personnel matters and recommends grievance responses; exercises full supervision over employees.
QUALIFICATIONS:
Data Base Administrator 1
Knowledge of:
Principles and processes of relational data base management and development.
Principles and processes of structured system analysis, design, and programming.
Computer hardware/software, and database management system software, operating system, and network capabilities, including local area network and client-server software and techniques.
Database tools and design techniques.
Applicable database management software, file organization, utilities, data dictionary, and operating environments.
Principles and concepts of distributed application architecture.
Principles and concepts of project management techniques.
Computer network and data communication concepts.
Computer programming languages used for personal computers, web based applications, and client¬-server applications.
City government business practices and information requirements.
Principles and concepts of complex application development and implementation techniques.
Ability to:
Analyze complex administrative and data systems, identify problems, and develop logical conclusions and effective solutions.
Develop conceptual models of service systems and their information requirements.
Assist other City staff in identifying information requirements and developing conceptual models.
Develop database models using design tools such as ERwin and MS Visio.
Develop complex T-SQL objects such as stor¬ed procedures, triggers, functions etc.
Communicate clearly and concisely, both orally and in writing.
Communicate technical concepts to non-technical management and staff.
Analyze and solve complex technical problems.
Work independently and as a team member.
Represent the City's interests on regional project teams.
Establish and maintain cooperative working relationship with those contacted in the course of work,
Keep current in computing technology.
If supervision is assigned, supervise, train, mentor, assign, coach and conduct performance evaluations for staff.
Experience and Training Guidelines
Any combination of experience and training that would likely provide the required knowledge and abilities is qualifying. A typical way to obtain the knowledge and abilities would be:
Experience:
Four years of increasingly responsible experience in system and database administration in client-server environments. Experience with Microsoft SQL Server required.
Training:
Equivalent to a Bachelor's degree from an accredited college or univer¬sity in computer science or a closely related field.¬
License or Certification
None
Data Base Administrator 2:
In addition to the qualifications for Database Administrator 1:
Knowledge of:
Principles and concepts of data warehouse and OLAP design.
Principles and concepts of multi-tier application security design.
Principles and concepts of GIS data models.
Principles and concepts of enterprise-wide data models management and implementation.
Ability to:
Research and implement advanced SQL Server related technologies.
Implement and administer ESRI=s ArcIMS Server.
Advise and implement multi-tier application security within Microsoft AD framework.
Advise and implement server-side controls and auditing requirements.
Utilize and apply project management techniques.
Utilize a variety of performance monitoring tools.
Experience and Training Guidelines
Any combination of experience and training that would likely provide the required knowledge and abilities is qualifying. A typical way to obtain the knowledge and abilities would be:
Experience:
Six years of increasingly responsible experience in system and database administration in client-server environments. Experience with Microsoft SQL Server required.
Training:
Equivalent to a bachelor's degree from an accredited college or university in computer science or a closely related field.
