This Recruitment is open to City of Roseville Employees Only
Close Date: Dec 7, 2012
Salary: $6,298.00 - $8,440.00 Monthly
PROMOTIONAL EXAMINATION: 12.018
DATE OPENED: 11/27/2012
SENIOR DATABASE ANALYST
SALARY RANGE: $6,298 to $8,440 Monthly (26 PAY PERIODS ANNUALLY)
FINAL FILING DATE: Qualified and Regular City Employees should submit an application no later than 5:00 p.m., Friday, December 7, 2012. Temporary City employees are not eligible to apply.
TENTATIVE TEST DATES: Oral Interview Exam: TBD
SUPPLEMENTAL QUESTIONNAIRE: IT IS MANDATORY THAT YOU COMPLETE THE SUPPLEMENTAL APPLICATION. YOUR APPLICATION WILL BE REJECTED IF YOU DO NOT PROVIDE ALL NECESSARY INFORMATION.
The Human Resources Department is accepting applications for Senior Database Analyst in the Information Technology Department. The normal work schedule will be from Monday through Friday from 8:00 a.m. to 5:00 pm. A flex schedule may be available.
To plan, organize and coordinate implementation of multiple database systems on a City-wide basis; to perform highly complex database design and administration duties; and to provide technical and functional supervision over professional staff.
The Senior Database Analyst is the advanced journey level in the Database Analyst class series. Positions at this level are distinguished from other classes within the series by the level of responsibility assumed, complexity of duties assigned, independence of action taken, by the amount of time spent performing the duties, and by the nature of the public contact made. Employees perform the most difficult and responsible types of duties assigned to classes within this series and provide technical and functional supervision over professional and technical personnel.
SUPERVISION RECEIVED AND EXERCISED
• Receives general direction from an Information Technology Division Manager.
• Exercises technical and functional supervision over assigned professional and technical personnel.
EXAMPLES OF ESSENTIAL DUTIES - Duties may include, but are not limited to, the following:
• Plan, prioritize, and review the work of personnel assigned to database management functions.
• Develop schedules and methods to accomplish assignments ensuring work is completed in a timely and efficient manner.
• Participate in evaluating the activities of staff, recommending improvements and modifications.
• Provide and coordinate staff training; work with employees to correct deficiencies.
• Perform the most difficult and complex work related to database management and administration including backup and recovery planning and implementation, overseeing disk capacity of server and database infrastructure, and monitoring performance of assigned databases and servers.
• Design and implement database infrastructure.
• Lead system design, business process design, and business solution activities and provide technical advice to staff and other departments.
• Oversee efforts to integrate databases with enterprise systems to best meet the needs of the City.
• Participate in strategic planning efforts with respect to improve information technology service delivery.
• Install, configure, and setup a variety of databases; respond to inquiries, updates, and integration of data requests.
• Determine and enforce technical and security standards related to various databases; develop processes and best practices in order to maintain the integrity of data.
• Participate in the development of Requests for Proposal; assist with the selection and oversight of consultants and vendors.
• Participate in budget preparation and administration for assigned projects.
• Build and maintain positive working relationships with co-workers, other City employees and the public using principles of good customer service.
• Perform related duties as assigned.
• Principles and practices of complex database design, implementation, operation, and maintenance for a variety of uses and applications.
• Project management methodologies.
• Relational database management systems.
• Local area networks, operating systems and network terminology.
• Principles and practices of technical and functional supervision and training.
• Plan, organize and coordinate implementation of City database operations related to area of assignment.
• On a continuous basis, know and understand all aspects of the job. Intermittently analyze work papers, reports and special projects; identify and interpret technical and numerical information; observe and problem solve operational and technical policy and procedures.
• On a continuous basis, sit at desk for long periods of time. Intermittently twist to reach equipment surrounding desk; perform simple grasping and fine manipulation; use telephone, and write or use a keyboard to communicate through written means; and lift or carry weight of 30 pounds or less.
• Integrate and update a variety of databases.
• Document and implement systems following the software life cycles; make recommendations for upgrades and/or replacements.
• Analyze, design, integrate, program, and manage highly technical and complex computer programs as related to database operations.
• Interpret and explain pertinent information technology and City policies and procedures.
• Effectively manage the more complex projects.
• Effectively lead cross-functional teams.
• Prepare a variety of reports and maintain accurate records and files.
• Communicate clearly and concisely, both orally and in writing.
• Maintain confidentiality as necessary.
• Work weekends, evenings or standby, as required.
• Establish and maintain effective working relationships with those contacted in the course of work.
Experience and Training
Three years of responsible experience performing duties similar to that of a Database Analyst II with the City of Roseville.
Equivalent to a Bachelor’s degree from an accredited college or university in computer science, information systems, or a related field.
The selection process will be determined by the number of qualified applicants and may include a written, oral, or practical examination.
1. Please describe your experience as a technical lead, your responsibilities, and challenges.
2. Please describe your knowledge and experience working with database technology?
3. What do you think is the biggest technology challenge the City of Roseville faces today? What strategy do you recommend
4. Describe a difficult interaction you’ve had with a customer. How did you handle it?
5. What motivates you? How do you motivate others to continually improve?