Maintain and support database in several RDBMS, such as Microsoft SQL server, MySQL, and MS Access; ensure database monitoring, performance, integrity, and security; normalization and optimization, manage database backup/recovery procedures and replication to ensure high availability of critical data; and analysis of long-range hardware, software, and storage requirements for future database projects. Maintain a working knowledge of current best practices and emerging trends in database management. Assist in the technical design, development, migration, maintenance, documentation, and security of end user, enterprise RDBMS databases and related data for large and complex projects. Work closely with all stakeholders to determine requirements and manage the full project lifecycle using common industry methodologies/best practices. Depending on skillset and project needs, may assist web developers with designing complex queries, forms, and code to facilitate use of data by public and stakeholders outside the bureau through the bureau’s website and web services. Experience with web application development and the creation of web infrastructure/ middleware to serve geospatial database online is desired. Cross-train and work closely with other IT staff to engineer, develop, maintain and support a robust IT infrastructure. This can include but not limited to virtualization, data storage, automation, monitoring, clustering/high availability, back up/ recovery, hardware, authentication/ directory, network and security services. Other duties as assigned.
Associate’s degree or completion of 60+ college credit; area of study: Database technologies, IT, Computer Science or related field. May substitute degree with professional experience and/or industry certifications. Experience and proficiency with Microsoft Access required. Experience with database design and normalization techniques required. Knowledge of Enterprise RDBMS systems like MySQL, MS-SQL, PostgreSQL, and Oracle required. Knowledge of SQL or T-SQL required. Must be capable of close collaboration and have excellent interpersonal and organizational skills required. Ability to assimilate and apply new knowledge quickly in a fast paced changing environment required. Ability to handle multiple projects, tasks, and schedule time required. Excellent customer service and communication skills required. Knowledge of one or more programming languages desired. Knowledge of web development/ web application programming desired. Knowledge of General IT system administration desired. Knowledge of Active Directory desired. Knowledge of, or interest in the geological sciences desired.