Job Details


Position Title:Data Management Specialist I/II
Reference Number:13.169
Division:General Staffing
Contact Name:Human Resources
Contact Email:humanresources@roseville.ca.us
Contact Phone:(916) 774-5475
Contact Fax:(916) 774-5350
Position Description:SALARY RANGE: Data Management Specialist I: $4,553 - $6,406 Monthly (26 PAY PERIODS ANNUALLY)
Data Management Specialist II: $5,008 - $7,047 Monthly (26 PAY PERIODS ANNUALLY)

FINAL FILING DATE: Accepting the first 50 qualified applications or closing no later than 5:00 p.m., Thursday, June 19, 2014 or whichever occurs first.  THIS RECRUITMENT WILL CLOSE ON THURSDAY, JUNE 26, 2014.

TENTATIVE TEST DATE:
Oral Interview Exam: July 17, 2014 & July 18, 2014

SUPPLEMENTAL QUESTIONNNAIRE
IT IS MANDATORY THAT YOU COMPLETE THE SUPPLEMENTAL QUESTIONS. YOUR APPLICATION WILL BE REJECTED IF
YOU DO NOT PROVIDE ALL THE NECESSARY INFORMATION.

THE POSITION
The Human Resources Department is accepting applications for the full-time position of Data Management Specialist I/II in the Electric Department. The normal work schedule will be Monday through Friday from 8:00 a.m. – 5:00 p.m., a flex schedule is available.

DEFINITION
To perform technical and professional duties involving the analysis, design, development, programming, and maintenance of information systems related to the operations of an assigned department, including but not limited to, electric energy management, distribution, and generation processes and facilities; and to provide information technology support related to department specific operations and systems.

DISTINGUISHING CHARACTERISTICS
Data Management Specialist I
- This is the entry level class in the Data Management Specialist series. This class is distinguished from the journey level by the performance of the more routine tasks and duties assigned to positions within the series. Employees at this level are not expected to perform with the same independence of direction and judgment on matters allocated to the journey level. Since this is typically used as a training class, employees may have only limited or not directly related work experience. Employees work under general supervision while learning job tasks.

Data Management Specialist II - This is the journey level class within the Data Management Specialist series and is distinguished from the I level by the assignment of the full range of duties. Employees at this level receive only occasional instruction or assistance as new, unusual or unique situations arise and are fully aware of the operating procedures and policies within the work unit. Positions in this class are flexibly staffed and are normally filled by advancement from the I level.

SUPERVISION RECEIVED AND EXERCISED

Data Management Specialist I

• Receives general supervision from an assigned supervisor.
• May exercise technical supervision over maintenance and/or technical staff as assigned.

Data Management Specialist II

• Receives direction from an assigned supervisor.
• May exercise technical supervision over maintenance and/or technical staff as assigned.

EXAMPLES OF ESSENTIAL DUTIES - Duties may include, but are not limited to, the following:

• Implement and maintain electronic data management, collection/storage, and related systems in support of assigned department operations and processes.
• Design, develop, program, deploy, maintain and troubleshoot a variety of electronic databases related to department operations including large Relational Database Management Systems (RDBMS) such as Oracle, SQL Server, integrated development environments, Internet application server, and/or web host software.
• Develop, install and maintain Web-based applications.
• Perform daily data analysis; maintain data integrity and accuracy by running and analyzing various programs and reports; perform database backup and recovery operations; implement and test backup and recover policy.
• Monitor and maintain security of database systems by writing procedures, functions and triggers to control the flow of data, monitoring logs and reviewing system access privileges, allocating disk space for users, creating and maintaining users, user permissions, system privileges, and passwords, and performing other administrative tasks at the operating system level.
• Perform database back-up and recovery operations; implement and test back-up and recovery policies and procedures.
• Design, develop, maintain and troubleshoot server management tools, Internet application servers, and forms, reports and report development suite in support of department operations, requirements, and staff needs.
• Set-up and maintain logical storage, channels, virtual disks and partitions; create data files, tablespaces, tables and indexes as needed.
• Work with various internal users to develop programs that meet business needs; develop, test, review, and de-bug related prototypes; create documentation of final programs; develop and conduct end user training and program roll out.
• Provide system administration services; set up and install new servers and operations systems; install system upgrades and/or apply patches; hard code and/or implement programs in anticipation of upgrades.
• Design and develop forms and reports in support of department operations, requirements, and staff needs.
• Prepare periodically-required internal and external regulatory reports related to department operations.
• 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.

MINIMUM QUALIFICATIONS

Data Management Specialist I

Knowledge of:

• Principles and practices of Oracle and SQL Server databases, Local Area Networks (LAN), Storage Area Networks (SAN), computer systems and related analysis.
• Principles and techniques of SQL, PL/SQL, and JAVA scripting, report writing, programming, electronic data processing and application documentation.
• Principles and practices related to the programming, maintenance, and use of computer systems and applications such as Oracle, Microsoft Word, Excel, Access, WHIMS and web development software. Local Area Networks.

Ability to:

• Learn to perform technical duties in the analysis, design, and maintenance of information systems related to the processes and operations of the assigned department.
• On a continuous basis, know and understand operations, and observe safety rules; analyze problem equipment and/or procedures; know and apply techniques and terminology; communicate and explain test results to others.
• Intermittently, sit while studying or preparing reports; bend, squat, climb, kneel and twist when performing various field site sampling duties; perform simple and power grasping, pushing, pulling, and fine manipulation; use telephone, computer or communicate through written means; and lift or carry weight of 25 pounds or less.
• Learn to apply basic principles of business processes related to the assigned department’s operations and information management.
• Communicate clearly and concisely, both orally and writing.
• Establish and maintain effective working relationships with those contacted in the course of work.

Experience and Training
Experience:

• One year of increasingly responsible experience in computer systems operations and programming related to the implementation of large Relational Database Management Systems (RDBMS) such as Oracle servers and automated data systems and information management.

AND

Training:

• Equivalent to a Bachelor’s degree from an accredited college or university with major course work in computer science, information systems or a related field.

License or Certificate

• Possession of, or ability to obtain, a valid California Driver’s License.
• Possession of an Oracle DBA certificate is desirable.

Data Management Specialist II

In addition to the qualifications for the Data Management Specialist I:

Knowledge of:

• Basic principles and practices associated with the operations of assigned department systems and facilities.
• Pertinent local, State and Federal laws, ordinances/rules, and department procedures.

Ability to:

• Independently perform technical duties in the analysis, design, and maintenance of information systems related to the processes and operations of the assigned department.
• Apply basic principles of business processes related to the assigned department’s operations and information management.

Experience and Training
Experience:

• Two years of professional experience performing duties similar to that of a Data Management Specialist I with the City of Roseville.

AND

Training:


• Equivalent to a Bachelor’s degree from an accredited college or university with major course work in computer science, information systems or a related field.

License or Certificate

• Possession of, or ability to obtain, a valid California Driver’s License.
• Possession of an Oracle DBA certificate is desirable.

SUPPLEMENTAL QUESTIONS

1. Check the applicable boxes below to indicate experience in the following:
Web development: ? 1-2 years ? 3-5 years ? >5 years
Programming Languages: ? 1-2 years ? 3-5 years ? >5 years
Structured Query Language: ? 1-2 years ? 3-5 years ? >5 years

2. What knowledge and/or experience do you have designing and managing large databases and analytical models? What is your level of proficiency with MS Office products, SQL, JAVA, cloud based application development, etc.?

3. What types of confidential customer data have you worked with? What protection methods have you utilized in working with confidential data?

4. Discuss your experience working with the selection, contracting, and managing of third party independent contractors. Please include some lessons learned and some best practices.

5. This position supports multiple non-technical business units. Describe your experience and approach to ensuring high levels of internal customer satisfaction.

SELECTION PROCESS
Applications will be screened to the most qualified candidates. Those candidates will be invited to an oral interview exam weighted at 100%. Scores earned from the oral interview will be used to establish the employment list. Candidates within the top five ranked scores will be certified to the department for final consideration. Final appointment is contingent upon a background check, passing a City-paid pre-employment medical exam, a drug and alcohol screening test, and a fingerprint check.


Job Status:Regular / Benefitted, Salary
Click Here to Apply