Database Administrator

City of Arlington

4d•$112,679 - $140,849

About The Position

Under general supervision, the Database Administrator develops, maintains, implements, and administers databases for the City of Arlington. The role ensures the security, integrity, and availability of databases and related software, while implementing best practices for performance and disaster recovery. By optimizing data systems and ensuring reliable access to critical information, the position supports the City’s mission to deliver smarter, more efficient services that positively impact residents.

Requirements

Knowledge of Microsoft SQL Server database administration and Always On technologies.
Knowledge of database maintenance best practices, including backups, indexing, and transaction log management.
Knowledge of API data retrieval and ETL processes.
Knowledge of Visual Studio and ESRI Geodatabase structure and maintenance.
Knowledge of database security and access control mechanisms.
Skill in writing and debugging SQL statements and stored procedures.
Analytical approach to troubleshooting and intellectual curiosity.
Ability to perform performance tuning and optimize database environments.
Ability to support clustered and high-availability database environments.
Strong service orientation, ownership, and accountability.
Ability to work independently and collaboratively across multiple divisions.
Ability to establish, maintain, and improve effective working relationships.
Ability to communicate effectively with technical and non-technical audiences.
Ability to manage multiple priorities and adjust quickly to changing priorities.
Ability to learn new information and technologies quickly.
Ability to think critically and identify trends as well as isolated events.
Ability to work independently and as part of a team, guiding team members across multiple divisions.
Ability to initiate development of methods to improve service delivery and system performance.
Ability to maintain regular and punctual attendance.
Ability to operate Microsoft Office Suite or related software.
Ability to handle difficult and stressful situations with professional composure.
Ability to work irregular hours, including evenings and weekends.
Ability to handle confidential information with discretion.
Bachelor’s degree in Computer Science, Management Information Systems, Business Administration, or a related field, or an equivalent combination of education and experience.
Minimum of five years of experience in database administration or a related position.
Successful criminal background check and CJIS fingerprint background check.
Meet and maintain qualifications for Criminal Justice Information Systems (CJIS) access.

Nice To Haves

Knowledge of data security standards such as PCI, PHI, PII, and CJIS.
Knowledge of IT Service Management frameworks and practices.
Ability to anticipate changes needed to meet strategic objectives and/or management expectations.
Experience in municipal government.

Responsibilities

Design, implement, and maintain redundant enterprise-class databases, policies, and procedures.
Write complex stored procedures, queries, and scripts to maintain the RDBMS environment.
Administer database security, perform performance tuning, and manage backup and recovery processes.
Ensure the security, integrity, and availability of assigned database systems.
Guide the selection, testing, and implementation of software patches, updates, and enhancements.
Advise on best practices for database design, deployment, and integration with other systems.
Provide technical leadership for IT projects involving database functionality and performance.
Develop and maintain processes using SSIS, MuleSoft, and other programming tools for data integration.
Monitor database performance, identify bottlenecks, and implement optimization solutions.
Create SSIS packages and provide customer support for data-related processes.
Develop reports, data catalogs, and dashboards using SQL Server, SSRS, SSIS, and Power BI.
Coordinate testing and production implementation of database tables and functions, including data dictionary management.
Lead business process redesign and documentation for new technology.
Monitor and report on information security trends and recommend corrective actions.
Lead analysis and documentation of current business processes and systems, identifying gaps and areas for improvement.
Provide 24x7 database support and on-call duties.
Mentor and transfer knowledge to less experienced team members.
Perform other additional duties aligned with the scope of essential job functions, as needed.