DATABASE ADMINISTRATOR

Description We are seeking a skilled, experienced Database Administrator to join our growing organization. In this position, you will design, create, test, migrate, monitor, troubleshoot, backup/recovery, security, manage and decommission various Town of Cary on premise and cloud based computer and application databases; ensuring data are available to users and kept secure from unauthorized access or accidental loss or corruption. This position will work closely in supporting IT Integration Development and Operations teams by supporting our critical database systems and architecture including but, not limited to our Public Safety, Smart and Connected Community, Water and Waste Water Resources, and AMI initiatives. An organized, detail-oriented work ethic is a must.

Work is performed under the general supervision of the Enterprise Applications Manager. Typical Tasks

• Design, create, test, migrate, monitor and troubleshoot databases for the Town of Cary overall database environment and initiatives;
• Install, configure, and administer SQL Server (including SQL Server DW/Synapse), databases and other Azure Cloud-based data solutions while adhering to best practices;
• Design logical and physical data models for relational and dimensional solutions; develop and enforce standards;
• Administer Esri enterprise geodatabases hosted in SQL Server, including configuration, performance tuning, compress, and index and statistics maintenance;
• Administer and maintain the ArcGIS Enterprise environment, including ArcGIS Server, Portal for ArcGIS, and ArcGIS Data Store, along with the database connections and related data sources behind published services;
• Work with stakeholders to develop long-term strategic goals for production databases; providing technical knowledge to the business units in identifying, evaluating, research of products and services in support of the Town’s needs and goals with scalable solutions to process current and expected future loads;
• Create custom monitoring and maintenance plans for root cause analysis and corrective action;
• Test and Install, patches and upgrades;
• Manage resources including long-term capacity planning for resources and storage; Use tools and scripting to efficiently manage and automate tasks;
• Develop, implement and maintain change control and testing processes for modifications to databases ensuring audit trails are maintained and documented;
• Work with end users to facilitate best practices for database use; create or assist in writing of user documentation, instructions, and procedures;
• Manage the ingestion and usability of our near real-time data, eliminate bottlenecks on specific databases and properly federate data throughout our IoT initiatives;
• Develop and maintain ELT/ETL processes that import and export data from various sources in a variety of formats; Identify interdependencies in system and application components;
• Setup, test and maintain backup and disaster recovery processes and procedures; including SQL Server high-availability technologies (replication, mirroring, log shipping, AGs, etc...);
• Manage and implement database security and report incidents; while adhering to CJIS requirements and NIST standards; Decommission various databases that are no longer used, following requirements for data retention;
• Perform other job-related tasks as assigned.

Minimum and Preferred Qualifications Requires any combination of education and experience equivalent to graduation from a four-year college or university with a degree in computer science or closely related field and a minimum of three years of SQL server database experience or database administration experience in a commercial environment or equivalent work experience.

Preferred qualifications include:

• Experience upgrading ArcGIS Enterprise and supporting multi-machine or highly available deployments;
• 4 years experience supporting GIS and enterprise databases in a local government environment.
• 2 years experience with Python scripting in an integration environment

Physical Requirements Work in this class is generally inside and sedentary however, frequent movement is required in the process of observing system and database operations. An employee must have such visual acuity as to be able to read and write handwritten and typewritten material and to install/repair equipment. An employee in this class must be able to talk and hear in order to be able to respond to the public, vendors and other employees.

Special Requirements

• Requires a valid driver's license with an acceptable driving record.
• Requires drug testing and background check (which may include criminal history check, SBI finger-printing, motor vehicle records check, education verification and credit history review) and satisfactory reference checks prior to employment
• Must be eligible for and able to maintain CJIS access and certification.
• Participation in emergency response activities is required.
• This is a full-time, on-site position.

Benefits

Regular Full-Time Employees

Learn more about our benefits.

Cary is pleased to provide excellent, competitive, and comprehensive benefits to serve the needs of our employees and their families.

Because Cary believes that employees are one of our most important resources, significant dollars (averaging about 40% of annual salary per employee) are spent each year on employee benefits.

All regular full-time employees of Cary are eligible, and benefits coverage for new employees and family members is effective upon an employee's hire date.

Cary ensures equal employment opportunities (EEO) are provided to all employees and applicants for employment without regard to age, sex, race, color, religion, national origin, disability, political affiliation, marital status, veteran status, or genetic information.