Technology Coordinator Agency - SQL Server Relational DBA
Technology Coordinator Agency - SQL Server Relational DBA
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Are you RichmondR.E.A.D.YRespect.Equity.Accountability.DiversityYOU!!!
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
- Tuition Assistance Program
Description
- Are you Richmond R.E.A.D.Y
Respect. Equity. Accountability. Diversity You!!!
With over 4000 employees the City of Richmond is an Employer of Choice among cities throughout the nation. The City strives to hire and retain employees who bring dedication and talent to the workforce. At the City of Richmond we understand that a diverse and inclusive workforce is essential for fostering creativity enhancing problemsolving and driving success. As an Employer of Choice the City offers competitive compensation and benefits packages ongoing learning and development opportunities and a supportive and inclusive work environment. If working in this kind of organization inspires you we encourage you to apply. Welcome aboard! Are you Richmond R.E.A.D.Y!The City of Richmond Police Departmentis seeking an experienced SQL Server Relational Database Administrator (DBA)to join the Departments Information Services unit in the position ofTechnology Coordinator (Agency). The Technology Coordinator (Agency) will be responsible for the implementation configuration maintenance and performance of critical RDBMS systems to ensure the availability and consistent performance of the Departments applications. This is a handson position requiring solid technical skills as well as excellent interpersonal and communication skills.The successful candidate will be responsible for the development and sustainment of multiple mission critical relational databases ensuring their operational readiness (security health and performance) executing data loads and performing data modeling in support of various inhouse and commercial off the shelf (COTS) and must be capable of working independently and collaboratively. Duties include but are not limited to
- Installing and configuring database servers and Relational Database (RDBMS) software
- Database maintenance including monitoring backup and recovery and patching.
- Deploying database schema updates to production and Quality Assurance databases in support of system software updates.
- Providing backup and recovery services; managing file systems and disk space.
- Recommending and implementing system enhancements that will improve the performance and reliability of the system including installing upgrading/patching monitoring problem resolution and configuration management.
- Providing expertise in writing and editing queries that read manipulate and analyze data from business intelligence and relational databases
- Writing and editing automated jobs that import and export data between systems.
- Developing and documenting technical processes and procedures as needed.
- Working with other developers to make sure that all data solutions are consistent.
- Working with developers to review and approve database changes according to database design standards and principles.
- Translating business requirements into system requirements and assess where support is needed relative to existing database system design.
- Interacting meeting discussing and troubleshooting issues with the users.
- Reporting project status as required for all recurring and nonrecurring efforts.
- Working under minimal direction and independently determine and develop approach to solutions
This position is considered essential and requires some oncall hours; and availability to work overtime some weekends as necessary.Successful completion of an interview thorough background investigation which may include a polygraph exam and drug/alcohol screening is required. Please note that the Police Department background process may take up to 4560 days. An applicant disqualified from the Police background process may reapply a year after disqualification.Qualifications Special Certifications and Licenses
Considerable knowledge of general business practices; City and state security policy and system access security levels; common computer programs such as Microsoft Office Suite as well as more specialized computer programs such as Visual Studio Microsoft Group Policy etc.; electronic databases and related software applications such as SQL server IIS webserver ERP etc.; process improvement; specific and advanced technical skills in area of focus such as SQL code reviews data security data modeling and design.
Demonstrated skills analyzing and resolving system related issues; meeting with key stakeholders and management to define the scope and scale of software projects; designing software system architecture; completing data structures and design patterns; designing and implementing scalable web services applications and APIs; writing lowlevel and highlevel code; troubleshooting and bug fixing; identifying bottlenecks and improving software efficiency; writing technical documents.
Demonstrated abilitiesservicing customers; multitasking; communicating verbally and in writing; organizing; planning; analyzing and solving problems; being a team player and technologically savvy.- Experience developing backend code in C# .NET required.
- Experience with HTML and CSS required.
- Knowledge of IIS required.
- Experience with Git/DevOps version control required.
- Experience with MSSQL relational databases including stored procedures triggers and functions required.
- Understanding of database normalization complex model design constraints indices and keys.
- Experience with web services.
- Understanding of database design best practices.
- Experience using tools such as Visual Studio and SQL Management Studio.
- Completion of the core curriculum for a Baccalaureate or Associate level major in computer science or a related field and one to five years experience.
MINIMUM TRAINING AND EXPERIENCE:- Associates degree in computer science or related field
- Three years of maintenance troubleshooting and repair experience in area of assignment
- Bachelors degree in computer science preferred
- An equivalent combination of training and experience (as approved by the department) may be used to meet the minimum qualifications of the classification
LICENSING CERTIFICATIONS and/or OTHER SPECIAL REQUIREMENTS:- Some assignments may require a valid Drivers License with a satisfactory driving record and a valid Commonwealth of Virginia Drivers License within 30 days of hire.
- Incumbents assigned to telecommunications systems must have (preferred) or must obtain an FCC General Radio telephone Operator License (GROL) within one year of hire.
- Some agencies may have other specific requirements.
PREFERRED:- Minimum 5 10 years of experience designing implementing and maintaining SQL Server Relational Databases
- Advanced level knowledge of database structures and design systems design and data management
- Advanced knowledge of data modeling and understanding of different data structures and their benefits and limitations under particular use cases.
- Proven experience working handson with big data systems.
- Experience with SQL Server monitoring backup and disaster recovery.
- Substantial knowledge of different programming or scripting languages.
Equal Employment Opportunity Statement
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 .
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.
Required Experience:
IC
Employment Type
Full-Time
