DATABASE ANALYST II - GIS
SALARY: $5968 to $8398 monthly (26 pay periods annually)
FINAL FILING DATE: We are accepting applications until closing at 5 pm, February 18, 2022
IT IS MANDATORY THAT YOU COMPLETE THE SUPPLEMENTAL QUESTIONNAIRE. YOUR APPLICATION WILL BE REJECTED IF YOU DO NOT PROVIDE ALL NECESSARY INFORMATION.
THE POSITION
The Human Resources Department is accepting applications for the position of Database Analyst II in the Information Technology Department. The current vacancy is a regular, benefitted and full-time position; however the employment list that will be established from this recruitment may be utilized to fill future regular, temporary, and limited term vacancies in the City for the duration of the list. The term length for limited term vacancies is not guaranteed but cannot exceed 36 months. The normal work schedule is Monday through Friday, 8–5 pm; a flex schedule may be available.
The Information Technology department is looking for a full-time Database Analyst I/II – GIS to manage the City’s Enterprise GIS platforms including ArcGIS Online, ArcGIS Portal, ArcGIS Server, and enterprise geodatabases with the Information Technology’s Data Intelligence Division.
The City of Roseville promotes a no smoking atmosphere.
THE CITY
The City of Roseville is committed to a diverse workforce. We are engaged in understanding the needs and backgrounds of our colleagues and those we serve. Our organization is unified in this commitment, as we believe this produces the best results for our community.
The City of Roseville (COR) incorporates the following Core Competencies as part of the City’s culture:
- Focus on people: Develop and deliver service-oriented solutions that meet or exceed expectations.
- Build trust: Ensure honesty and integrity to gain confidence and support of others.
- Ensure accountability: Take responsibility for the outcomes of one’s own work and foster a sense of ownership in others.
- Communicate effectively: Deliver clear, concise messages and actively listen to ideas and questions.
- Collaborate inclusively: Build effective working partnerships, alliances, and teams.
- Make quality decisions: Make sound, timely decisions and recommendations.
- Be adaptable/agile: Change approach or methods to best fit the situation and effectively balance competing priorities.
DEFINITION
To perform professional level work in designing, installing, managing, updating, and securing a variety of database systems, including spatial and relational systems; to provide support to information systems personnel and user departments relative to current and anticipated database systems.
DISTINGUISHING CHARACTERISTICS
This is the journey level class within the Database Analyst 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.
This class is distinguished from the Senior Database Analyst in that the latter performs the most difficult and responsible types of duties assigned to classes within this series including assigned responsibilities for database management and exercises technical and functional supervision.
SUPERVISION RECEIVED AND EXERCISED
Receives direction from an Information Technology Program Manager. May exercise technical and functional supervision over technical and administrative support personnel.
EXAMPLES OF ESSENTIAL DUTIES - Duties may include, but are not limited to, the following:
- Design and install databases for new systems and monitor for performance; install test patches and upgrades and monitor for performance; provide database support during vendor upgrades.
- Research, plan, install, configure and test new systems; maintain and upgrade existing systems and interfaces.
- Design and implement interfaces between database systems.
- Optimize database systems by performing routine maintenance procedures, including but not limited to, reindexing and updating statistics; check for database consistency; detect and repair database corruption.
- Perform data analytics to extract data and implement business intelligence solutions; create reports and dashboards.
- Administer and create solutions for cloud based collaborative solutions including administering platforms, researching upcoming features, and assisting users; provide user training, develop and promote standardization and best practices; develop architecture and governance.
- Build, deploy and support Enterprise Data Warehouse capabilities.
- Audit database for compliance.
- Administer, configure, and maintain spatial databases using ArcSDE technology.
- Manage files for desired database structure; monitor disk storage space and backup management activities.
- Design and implement backup and recovery plans; test backup plans.
- Create and maintain user permissions, system privileges, passwords and other security methods; install, administer and monitor license management software; monitor database usage for security purposes; check logs and files for evidence of problems and system failure.
- Provide technical support in the planning of new database systems including hardware, operating systems, licensing and storage requirements for new systems.
- Perform technical duties related to the integration of data between enterprise systems.
- Enforce data quality standards and perform quality control checks on associated data.
- Create and manage disk clusters, tables, indexes, and related systems and processes.
- Monitor database performance against established standards; detect and troubleshoot problems.
- Perform backup activities (on-line, off-line, and archive logs) at scheduled times.
- Implement data recovery plan when necessary; prepare related project status reports as required. Provide advanced level support for the data, analysis and database related issues.
- Coordinate assigned functions with and provide support to other departments, other jurisdictions and agencies, and the general public; conduct user training on group or individual basis as needed; advise and train information systems personnel on database issues.
- Partner with City departments and provide database solutions to meet business needs; integrate database solutions with other City enterprise solutions.
- Research and recommend vendors.
- Evaluate operations and activities of customer support; recommend improvements and modifications; prepare various reports on operations and activities.
- Prepare and maintain systems procedures and documentation; maintain and update manuals, codebooks, templates, Intranet for departments’ use, and computer control tables; assist in the development of database policies and procedures.
- 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
Knowledge of:
- Principles and practices of Oracle and SQL Server databases, Local Area networks (LAN), storage, UNIX and NT operating systems and network terminology; computer systems and related analysis and design.
- Principles and techniques of SQL, scripting, report writing, programming, electronic data processing and application documentation.
- Principles and practices of ESRI, ArcSDE, ArcGIS Desktop, and ArcGIS Server technology and GIS theory and concepts, depending on assignment.
- Records storage and handling techniques.
- Computer operating methods, languages and procedures.
- Principles and practices of complex database design, implementation, operation, maintenance, and data manipulation.
- Principles and practices of business analysis.
- Research, analysis and management related to databases.
- Extract, transform, and load (ETL) methodologies.
- Workflow and process improvement methodologies.
- Project management methodologies.
- Computer logic and mathematics.
Ability to:
- Perform professional level work in designing and maintaining a variety of database systems.
- 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.
- Analyze, diagnose, maintain, and troubleshoot database and related network systems.
- Install and configure database specific desktop/server hardware and software.
- Provide technical expertise to City departments in support of business goals.
- Maintain and administer security systems and methodologies.
- Train or instruct users in the use of various databases.
- Create and maintain database backup and recovery procedures.
- Create and update scripts to automate database processing and maintenance.
- Prepare a variety of reports and maintain accurate records and files.
- Maintain confidentiality as necessary.
- Work weekends, evenings or standby, as required.
- Communicate clearly and concisely, both orally and in writing.
- Establish and maintain effective working relationships with those contacted in the course of work.
- Independently perform professional work in support of the City’s database systems, data management and analysis, and related network infrastructure.
- Analyze, design, program, install and maintain highly technical and complex operating programs.
- Troubleshoot, diagnose and resolve issues effectively.
- Prepare written procedures for complex database solutions.
- Write operating instructions and procedures for electronic data processing machine applications.
EXPERIENCE AND TRAINING
Experience:
- Two years of responsible experience performing duties similar to that of a Database Analyst I with the City of Roseville (performing professional work in designing, installing, managing, updating and securing a variety of database systems, including spatial and relational systems; providing support to information systems personnel and user departments relative to current and anticipated database systems).
AND
Training:
- A Bachelor’s degree from an accredited college or university. Course work in computer science, information systems, GIS or a related field is desirable.
License or Certificate:
- Possession of a valid California driver’s license by date of appointment.
SUPPLEMENTAL QUESTIONNAIRE
- Your responses to question 3, the applicant’s education, training and experience, will be scored using a pre-determined formula. Your responses to these questions must be consistent with your employment application information. This experience must also be described in the “Work Experience" section of this application. Responses to the supplemental questionnaire that are inconsistent from your “Work Experience” section in the application will not be scored. I understand and agree with the above instructions.
- Was any of the work experience listed on your application an unpaid internship, or volunteer work? If so, please list below which ones.
- How many years of experience do you have with performing duties related to GIS?
- Less than two years
- 2-3 years
- 3-4 years
- 4-5 years
- 5-6 years
- 6+ years
- Summarize your experience specifically in the GIS industry. In your response, please include any applicable GIS trainings and/or certificates with dates.
- Describe your experience managing and administering ArcGIS Online and ArcGIS Portal. In your response, please include examples of GIS web and mobile applications you have developed or deployed.
- Describe your skills and qualifications for maintaining enterprise GIS infrastructure.
- Describe what you do to provide leadership in your daily activities in your current role or position.
- What excites you about providing GIS services to a City and its citizens?
SELECTION PROCESS
All candidates meeting the minimum qualifications will have their application scored in a Formula Rate Examination. The applicant’s experience and education will be evaluated using a pre-determined formula. Scores from this evaluation will determine applicant ranking and placement on the Employment List. Supplemental questions will be utilized by the department hiring authority to make interview and selection determinations. Final appointment is contingent upon a check of past employment references, passing a City-paid fingerprint check and depending on position applied for a pre-employment medical exam and a drug and alcohol screening test.
THE CITY OF ROSEVILLE IS AN EQUAL OPPORTUNITY EMPLOYER. IF YOU REQUIRE AN ACCOMMODATION DUE TO A DISABILITY, PLEASE CONTACT THE HUMAN RESOURCES DEPARTMENT AT LEAST 5 WORKING DAYS BEFORE A SCHEDULED INTERVIEW/EXAMINATION PROCESS. MEDICAL DISABILITY VERIFICATION MAY BE REQUIRED PRIOR TO ACCOMMODATION.
