Technology Engineer/Administrator (DIT) - Database Administration Support - Infrastructure Division

The City of Richmond is committed to nurturing talent, fostering growth opportunities, and building strong connections within our workforce. As we continue to make strides to becoming the employer of choice, we offer the following employee benefit enhancements: Virginia Retirement System (VRS), Language Incentive, Referral Bonus, and Tuition Assistance Program.

About the role

The City of Richmond Department of Information Technology is seeking a Technology Engineer/Administrator. Incumbents perform work as technology engineers or systems administrators and are considered designated subject matter experts. This position serves as an Essential employee, required to work during public emergencies, critical or hazardous conditions, or inclement weather.

Responsibilities

• Configuration and troubleshooting of databases
• Performance reviews and recommendations
• Backups and recovery of databases
• Researching and resolving performance issues
• Documentation and updating of project documentation and trouble tickets
• Providing after-hours support in coordination with an on-call rotation
• Contributing to project review, design, and configuration
• Developing and analyzing reporting documentation for performance, backups, and security
• Providing technical support for daily issues or outages
• Process development for new database strategies in a production environment
• Providing updates, notifications, and documentation for outages during active sessions
• ITIL change management documentation for all production changes
• Ensuring timely service and resolution of service requests and incidents in accordance with SLAs
• Ensuring production uptime and performance
• Researching, documenting, and presenting environmental changes for future improvements and optimization
• Identifying trends and developing areas of improvement related to performance in a production environment
• Serving on-call 24/7 to provide leadership for support and resolution of problems for critical systems and applications

Requirements

• Considerable working background in Microsoft SQL database administration, architecture, and troubleshooting
• Database administration and backup/recovery management
• Working knowledge of backing up and restoring production databases
• Knowledge of SQL database performance tuning, monitoring, and optimization
• Desired working knowledge of database security and management
• Working knowledge of database administration tools (e.g., SQL Workbench, SQL Studio, Datadog database monitoring)
• Desired working knowledge of Oracle database administration
• Desired working knowledge of UNIX (any version)
• Knowledge of ITIL Change Management

Skills

• Administration and management of production databases
• Basic to advanced troubleshooting skills
• Backup, recovery, and monitoring of databases
• Communication within a team environment and customer-facing interactions
• Security assessment and review of database administration and access
• Design, configuration, deployment, troubleshooting, administration, and maintenance of systems
• Ensuring project and workload documentation and processes are accurate, on time, and stored properly

Abilities

• Analyzing and thinking critically
• Paying attention to detail
• Solving problems
• Organizing and planning
• Managing time effectively and prioritizing tasks
• Contributing to and supporting multiple projects simultaneously

Qualifications

• Bachelor's degree in computer science or related field
• Two years of journey-level professional systems and network engineering experience
• An equivalent combination of training and experience (as approved by the department) may be used to meet the minimum qualifications

Licensing, Certifications, and Other Special Requirements

• SQL Database Administration (essential)
• SQL Configuration and Management (desired)
• Oracle DBA (desired)
• UNIX Administration (desired)

Preferred Training and Experience

• Working knowledge of Windows SQL 2019 and above
• Desired working knowledge of Oracle 11G, 12C, 18C, and 19C
• Desired working knowledge of UNIX operating systems, particularly as it relates to storage configuration
• Technical writing skills, including project documentation, processes, procedures, and knowledge base articles for usage and best practices

Pay

The maximum hiring compensation for this position is $109,566 per year.