CITY OF RENTON CLASS TITLE: BASIC FUNCTION: Under the direction of an assigned supervisor, handle the daily requirements for administration and maintenance activities related to the database{s} used by the City. Reviews, Evaluates, Designs, Implements and maintains City of Renton database(s) by identifying data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Provides data table structure and schema recommendations; writes code for database access in conjunction with the City’s System Analyst, and makes modifications, and constructions, including stored procedures. Provides technical advice and support to users and developers in the use of the database. Handles database server backup and recovery, including backup and recovery strategies, tools and techniques (in coorination with the Network Systems Specialist); has knowledge of commonly used concepts, practices, and procedures within a particular field. Relies on experience and judgment to plan and accomplish goals. Performs a variety of complicated tasks. A wide degree of creativiy and latitude is expected. DISTINGUISHING CHARACTERISTICS: The Database Technician in this poistion should be able to diagnose and solve system problems such as the administration and maintenance activities related to the database(s) in use within the City. The work requires knowledge of basic database architectures, server backup and recovery, recovery strategies, tools and techniques. Contact is primarily with the City’s technical staff, although some customer/vendor contact to provide technical information or advice, to resolve problems and/or to coordinate work activities. REPRESENTATIVE DUTIES: * Analyze needs of clients, formulate solutions and design systems and procedures for implementation. Recommend appropriate data base models, tools, and structures including data dictionary format, content and documentation to achieve the project goal. * Evaluate new hardware and software. Advise I.S. staff on hardware and software alternatives necessary to meet the project’s goals and objectives. Set standards for selection of software and assist I.S. staff in making a final choice. * Develop and maintain systems for communication between database servers and client or Web based query strings. * Keep current on a diversity of equipment and software for workstations, both PC and central computer based, including printers, bar coding equipment and diverse types of terminals and microprocessors. DATABASE TECHNICIAN (IS-2420)
Database Technician - Continued
Page 2
* Respond to client request for service on problematic system(s) and/or equipment relating to back-end database processes. Troubleshoot problems and develop solutions. Make minor repairs to equipment and arrange for other servicing needs. * Communicate with software vendors throughout the contract, training, implementation and support phases of software projects; provide vendor with design specifications as needed to outline new software requirements and/or changes to existing software. Perform related duties as assigned. * Denotes Essential Job Functions KNOWLEDGE AND ABILITIES KNOWLEDGE OF: • Analysis, design and development of complex computer and communications systems. • Fundamental programming logic and technical programming languages including COBOL, Object Orient programming, and UNIX shell scripts. • Principles of workflow charting and computer hardware such as cables, cabinetry and plug-in boards. • Multi-system communication networks. • Operation of complex and technical computer equipment and peripherals. • Technical aspects of field of specialty. • City organization, operations, policies and objectives. ABILITY TO: • Provide technical expertise and assistance to the Information Systems Director and user departments. • Operate, troubleshoot, adjust and repair computer equipment and peripherals. • Write clear and concise user documentation. • Evaluate systems and procedures and develop cost-saving alternatives. • Code computer programs in a variety of programming languages. • Evaluate computer hardware and software and make appropriate recommendations for purchase, repair or replacement of equipment. • Lift and move computer equipment up to 40 pounds. • Communicate effectively both orally and in writing. • Establish and maintain cooperative and effective working relationships with others. • Analyze situations accurately and adopt an effective course of action. • Work independently with little direction. • Plan and organize work. • Meet schedules and time lines. EDUCATION AND EXPERIENCE:
Database Technician - Continued
Page 3
Any combination equivalent to: Associate of Arts degree in Computer Science, Information Systems or related field and two years of experience in systems software, analysis, design, programming or network implementation. WORKING CONDITIONS: Work is performed in an office environment, but includes the ability to lift and move computer equipment weighing up to 40 pounds.
January 2001