Database Administrator

Welcome to the City of Charlotte

Charlotte is Americas Queen City opening her arms to a diverse and inclusive community of residents businesses and visitors alike. Here you will find a safe family-oriented city where people work together to help everyone thrive. The mission of the City of Charlotte is to deliver quality public services and promote the safety health and quality of life for all residents.

Our guiding principles include:

• Attracting and retaining a skilled and diverse workforce

• Valuing teamwork openness accountability productivity and employee development

• Providing all customers with courteous responsive accessible and seamless quality services

• Taking initiative to identify analyze and solve problems

• Collaborating with stakeholders to make informed decisions

SUMMARY

Working Environment

• This position is hybrid with the expectation of working 2 days a week at a minimum in the office at Charlotte Mecklenburg Government Center. Subject to change based organizational and business needs.

• Cross departmental collaboration

• Customer focused

• Ability to adapt to changing priorities and requirements and work effectively in a dynamic and evolving organization

• After-hours work will be required but only 1-2 times a month

Major Duties and Responsibilities:

• Administer and maintain ArcGIS Enterprise (Portal ArcGIS Server Data Store) environments.

• Manage user roles permissions and content within Portal for ArcGIS and ArcGIS Online.

• Use ArcGIS Monitor for system performance and tuning

• Troubleshoot technical issues

• Apply ArcGIS patches

• Upgrade ArcGIS Enterprise systems

• Collaborate with GIS professionals developers DBAs and IT teams to support geospatial workflows and applications.

• Automate administrative tasks using Python (ArcGIS API for Python ArcPy) and scripting tools.

• Ensure data integrity backup strategies and disaster recovery plans are in place.

• Support and manage enterprise geodatabases hosted in SQL Server including versioning schema design and performance tuning.

• Manage and audit database-level permissions including role-based access control and schema security.

• Design and support high availability (HA) and disaster recovery (DR) configurationsfor ArcGIS Enterprise.

• Develop and maintain SQL Views and support ETL workflowsto integrate spatial and non-spatial data across systems.

• Document standard operating procedures system configurations and workflows.

• Performs other related duties as assigned.

Knowledge Skills and Abilities

• 3 years of hands-on experience administering ArcGIS Enterprise.

• Strong understanding of Portal for ArcGIS ArcGIS Server and ArcGIS Data Store.

• Experience in training staff on GIS concepts workflows and solutions

• Experience with SQL Server as the enterprise geodatabase platform.

• Hands-on experience with SQL Views and ETL processesfor geospatial and tabular data.

• Demonstrated experience managing database permissions and security.

• Familiarity with Windows Server environments and IIS.

• Solid understanding of core IT concepts (networking firewalls authentication storage etc.).

• Strong troubleshooting and problem-solving skills.

• After-hours work will be required but only 1-2 times a month

• Ability to work collaboratively within a team setting

Preferred Qualifications

• Bachelors Degree (preferred) with a major emphasis in GIS Computer Science/Engineering Cartography Geography

• Knowledge of high availability (HA) and disaster recovery (DR) strategies for GIS infrastructure.

• Experience leading upgrades and migrations of GIS technology

• Project Management

• Proficiency in Python scripting for automation and administration.

• Ability to multitask in a fast-paced environment

• Knowledge of IT security best practices and Active Directory integration.

• Use ArcGIS Monitor for system notifications and performance

• Experience with ArcGIS Online Survey123 Dashboards Experience Builder.

• Experience with REST API JSON and web services.

• Esri Technical Certification in ArcGIS Desktop or Enterprise domains

• Knowledge with AWS Azure or Google Cloud is a plus

Minimum Qualifications:

High school graduate or equivalent and seven (7) years of related experience.

Or:

2-year college degree and five (5) years of related experience.

Or:

Bachelors degree and three (3) years of related experience

Or:

Masterss degree and one (1) year of related experience

CONDITIONS OF EMPLOYMENT

The Citys Background Check Policy requires background checks to be conducted on final internal or external candidate(s) applying for any position with the City of Charlotte. The type of information that will be collected as part of a background check includes but is not limited to: reference checks social security verification education verification criminal conviction record check and if applicable a credit history check sex offender registry and motor vehicle records check.

Background checks must be in compliance with all federal and state statutes such as the Fair Credit Reporting Act (FCRA). The checks must be consistent with the guidelines set forth by these laws requiring organizations to obtain a candidates written authorization before obtaining a criminal background report motor vehicle records check or credit report; and to properly store and dispose of information derived from such reports.

Final candidates must pass a pre-employment drug-screening test and physical examination. During the selection process candidates may be asked to take a skills test and/or participate in other assessments.

The City of Charlotte is an Equal Opportunity Employer and does not unlawfully discriminate on the basis of race religion color sex national origin marital status age disability sexual orientation political affiliation or on the basis of actual or perceived gender as expressed through dress appearance or behavior.

Our culture is to serve the community honorably.

HOW TO APPLY

Apply online.

Federal law requires employers to provide reasonable accommodations to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job.

You are welcome to visit the City of Charlotte Human Resources Department lobby where self-service application kiosks are available. They are located in our office at 700 East 4th Street Suite 200 Charlotte NC 28202. We are open Monday through Friday from 9:30 a.m. to 3:30 p.m. (EST) excluding official City holidays.

For questions about your application or the hiring process please email .

The City of Charlotte is committed to making our services and programs accessible to all. Upon request auxiliary aids written materials in alternate formats language access and other reasonable accommodations or modifications will be provided. To make a request please fill out the Innovation & Technology ADA request form or call 704.336.4120.

BENEFITS

The City of Charlotte provides a comprehensive benefits package to eligible employees.

Clickhereto learn more about the City of Charlottes benefits.

The City of Charlotte is a drug and alcohol-free workplace.