Database Administrator

DEPARTMENT

Information Technology

SALARY

$112,679.00 - $140,848.50

JOB SUMMARY

Under general supervision, the Database Administrator develops, maintains, implements, and administers databases for the City of Arlington. This 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, this role supports the City's mission to deliver smarter, more efficient services that positively impact on the lives of our residents.

ESSENTIAL JOB FUNCTIONS

• 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 backups and recovery processes.
• Ensure security, integrity, and availability of assigned database systems.
• Guide 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.
• Leads business process redesign and documentation for new technology.
• Monitor and report on information security trends, recommending corrective actions.
• Lead analysis and documentation of current business processes and systems, identifying gaps and areas for improvement.

OTHER JOB FUNCTIONS

• Provide 24x7 database support and on-call duties.
• Mentor and transfer knowledge to less experienced team members.
• On a nontypical basis, may perform other additional duties not listed in this description that are in alignment with the scope of essential job functions.

MINIMUM QUALIFICATIONS

Knowledge, Skills and Abilities Required

• 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.
• Skilled in writing and debugging SQL statements and stored procedures.
• Skilled in analytical approach to troubleshooting, success requires intellectual curiosity.
• Ability to perform performance tuning and optimize database environments.
• Ability to support clustered and high-availability database environments.
• Ability to provide strong service with a high sense of ownership and accountability.
• Ability to work independently and collaboratively across multiple divisions.
• Ability to establish, maintain, improve, and deepen, strong, effective working relationships.
• Ability to communicate effectively on technical, interpersonal, and professional levels to technical and non-technical audiences.
• Ability to manage multiple priorities and assess and adjust quickly to changing priorities.
• Ability to learn new information and technologies quickly and organically.
• 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 within multiple divisions.
• Ability to initiate development of new 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.

Qualifying Education and Experience

• Bachelor's degree in Computer Science, Management Information Systems, Business Administration, or related field.
• Minimum of five (5) years of experience in database administration or a related position.
• Or an equivalent combination of education and experience.

PREFERRED QUALIFICATIONS

Knowledge, Skills, and Abilities Preferred

• 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.

Preferred Education and Experience

• Experience in municipal government.

Employment Screenings Required

• Criminal Background Check
• CJIS Fingerprint Background Check
• Meet and maintain qualifications for Criminal Justice Information Systems (CJIS) access.

City of Arlington is an Equal Opportunity Employer.