The California Department of Conservation (DOC) is recruiting for a database operations administrator (IT specialist II), who will serve as a subject matter expert supporting DOC’s California Geologic Energy Management (CalGEM) division.
“The incumbent will perform a full range of database tasks and data architecture planning,” the job posting says. “This position requires current knowledge and demonstrated ability to design, develop, and administer Microsoft SQL Server on-premises and hosted on Azure, Azure Cloud-based databases, and data storage.” The posting and the duty statement state: “A thorough knowledge of SQL and other scripting languages is required. Experience with managing Esri Enterprise Geodatabases as well as Esri’s suite of GIS server and desktop applications is desirable. The incumbent will work closely with other technical experts within the Enterprise Technology Services Division (ETSD) and CalGEM. The incumbent will show good communication and writing skills and will be effective in discussions and presentations with peers, clients, customers, and management.”
Essential functions of the position include database design and administration (35 percent), data architecture and planning (30 percent), programming and technical support (20 percent), research and development (10 percent) and marginal functions (5 percent).
The position has a monthly salary range of $7,893 to $10,576, and the application deadline is Aug. 29.
The California Department of Technology is recruiting for a geospatial engineer (IT specialist II) to work on the state’s Middle-Mile Broadband Initiative (MMBI).
The engineer “works at a highly skilled level involving complex technology, a subsystem of business applications or work on integration projects, and typically requires an unusual depth of understanding in a singular technology or a good understanding of multiple technologies,” the job posting says.
In a LinkedIn post about the recruitment, state Geographic Information Officer Carlos Isaac Cabrera, who’s also manager of Data and Geospatial Services for CDT, says: “We are looking for someone that loves GIS, Data and Analysis! This person will prove critical to maintaining and creating the GIS data used by our MMBI leaders.”
Desirable qualifications for the role, according to the job posting and duty statement, include:
- Knowledge of geospatial theory, analytical techniques, utilities geospatial data, design and workflows.
- Knowledge of GIS for infrastructure construction and maintenance.
- Toolkit: GitHub, MySQL, QGIS, ArcGIS Desktop (Pro), MSSQL geospatial.
- Languages/tools: JSON, JavaScript, HTML, CSS, C#, SQL, XML, C#, VB.Net, IIS, SQL reporting services.
- Frameworks: ASP.NET MVC, WordPress, Esri, JavaScript, jQuery, and various mobile and accessibility platforms and standards.
- Databases: Snowflake, PostgreSQL, Redshift, MS SQL Server, MySQL, Esri file, personal, and enterprise geodatabases.
- Server technologies: PostGIS, IIS, MS SQL Server, MySQL, ArcGIS Server, FME Server, ArcGIS Online Service Offerings, Esri Geoportal, Esri ArcGIS Hub.
- APIs: REST, SOAP, ASP.NET Web API, ArcGIS Server.
- FME Work Bench (extract transform and load), FME Server ME Server.
- Ability to effectively interact with executive-level management and technical staff including the Governor’s Office, state webmasters, vendors and end users.
The position has a monthly salary range of $7,893 to $10,576, and the application deadline is Aug. 28.
