What are the responsibilities and job description for the Technology Engineer/Administrator (DIT) - Database Administration Support - Infrastructure Division position at City of Richmond, Virginia?
Are you Richmond R.E.A.D.Y ?
R espect. E quity. A ccountability. D iversity… YOU !!!
About
This is an EXCITING time to Join the City of Richmond! We are 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 are thrilled about the below employee benefit enhancements:
The City of Richmond Department of Information Technology is seeking to fill the need for a Technology Engineer/Administrator. Incumbents perform work as a technology engineers or systems administrators and are considered designated subject matter experts. Incumbents perform skilled assessments, troubleshooting, and administration of user issues, and solve complex database issues. Additionally perform project configuration and design recommendations and documentation as required.
Duties include but are not limited to
The incumbent in this position is required to serve on-call 24 hours/7 days a week to provide leadership for the support and resolution of problems for critical systems and applications within the assigned City of Richmond portfolio.
Knowledge
Qualifications, Special Certifications and Licenses
The City of Richmond provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
The City of Richmond is committed to the full inclusion of all qualified individuals. As part of this commitment, the City of Richmond will ensure that persons with disabilities are provided with reasonable accommodations. If you require reasonable accommodations under the Americans with Disabilities Act (ADA) to participate in the job application and/or the interview process, please contact Jessica McKenzie, Human Resources Manager by email at Jessica.McKenzie@RVA.GOV .
This policy applies to all terms and conditions of employment, including recruitment, hiring, placement, promotion, termination, layoff, transfer, leaves of absence, compensation and training.
The City of Richmond Values Veterans. We are an official V3 Certified Company.
The City of Richmond is a proud partner with the US Army Partnership for Your Success PaYS Program.
R espect. E quity. A ccountability. D iversity… YOU !!!
About
This is an EXCITING time to Join the City of Richmond! We are 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 are thrilled about the below employee benefit enhancements:
- Virginia Retirement System (VRS)
- Language Incentive
- Referral Bonus
- T uition Assistance Program
The City of Richmond Department of Information Technology is seeking to fill the need for a Technology Engineer/Administrator. Incumbents perform work as a technology engineers or systems administrators and are considered designated subject matter experts. Incumbents perform skilled assessments, troubleshooting, and administration of user issues, and solve complex database issues. Additionally perform project configuration and design recommendations and documentation as required.
Duties include but are not limited to
- Configuration and troubleshooting
- Performance reviews and recommendations
- Backups and recovery of databases
- Researching and resolving issues in performance
- Documentation and updating of project documentation as well as trouble tickets
- Providing afterhours support in coordination with an on-call rotation
- Contributing and participating in project review, design, and configuration
- Developing and analyzing reporting documentation with regards to performance, backups, and security
- Providing technical support for daily issues or outages
- Process development for new strategies with regards to database in a production environment
- Providing updates, notifications, and documentation for outages during active sessions
- ITIL change management documentation for all production changes
- Providing timely service and resolutions to services requests and incidents in accordance with SLA’s
- Ensuring production uptime and performance
- Research, documentation, and presenting environmental changes for future areas of improvement and optimization to ensure efficient solutions
- Research and identification of trends and develop areas of improvements as it relates to performance in a production environment
The incumbent in this position is required to serve on-call 24 hours/7 days a week to provide leadership for the support and resolution of problems for critical systems and applications within the assigned City of Richmond portfolio.
Knowledge
Qualifications, Special Certifications and Licenses
- Considerable working background in Microsoft SQL database administration. Architecture and troubleshooting in a working environment.
- Database administration and backup/recovery management. Working knowledge of backing up and restoring of production databases.
- Knowledge of SQL database performance tuning. Monitoring and optimization of database performance.
- Desired working knowledge of database security and management.
- Desired working knowledge of troubleshooting database issues in a production environment.
- Working knowledge of database administration tools. SQL Workbench, SQL Studio, Datadog database monitoring, etc.
- Desired working knowledge of Oracle database administration.
- Desired working knowledge of UNIX (any version would be helpful)
- Knowledge of ITIL Change Management
- Administration and management of production databases.
- Basic to advanced troubleshooting skills.
- Backup/recovery/monitoring of databases.
- Communication within a team environment with peers as well as customer facing.
- Security assessment and review of database administration and access.
- Design, configuration, deploying, troubleshooting, administration, and maintaining systems.
- Ensuring project and workload documentation and process are accurate, on time, and stored properly.
- Demonstrated abilities in analyzing; thinking critically
- Paying attention to detail
- Solving problems
- Organizing
- Planning
- Managing time effectively
- Prioritizing
- Contributing to and supporting multiple projects simultaneously.
- 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 of the classification
- SQL Database Administration (essential)
- SQL Configuration and Management (desired but not essential)
- Oracle DBA (desired but not essential)
- UNIX Administration (desired not essential)
- 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, project documentation, process and procedures, knowledge base articles for usage and best practices.
The City of Richmond provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
The City of Richmond is committed to the full inclusion of all qualified individuals. As part of this commitment, the City of Richmond will ensure that persons with disabilities are provided with reasonable accommodations. If you require reasonable accommodations under the Americans with Disabilities Act (ADA) to participate in the job application and/or the interview process, please contact Jessica McKenzie, Human Resources Manager by email at Jessica.McKenzie@RVA.GOV .
This policy applies to all terms and conditions of employment, including recruitment, hiring, placement, promotion, termination, layoff, transfer, leaves of absence, compensation and training.
The City of Richmond Values Veterans. We are an official V3 Certified Company.
The City of Richmond is a proud partner with the US Army Partnership for Your Success PaYS Program.
