Senior Database Administrator

Description

Who We Are

Orlando, The City Beautiful

For most of Orlando's history we've been the place everyone wants to visit. Today, we're also the place where everyone wants to live and do business. List after list has Orlando as one of the fastest growing cities in America. We're transitioning from our role as the young upstart to a more mature, global city.

This didn't happen by accident. Together as a community, we developed a shared vision for our city focused on creating partnerships and we've transformed Orlando from a place that was packed with potential into a city on the rise.

Our vision ensures we are an inclusive, compassionate community that is generating jobs, becoming the most sustainable city in the nation, keeping our community safe, making it easier to get around, and increasing the quality of life. Together, we can continue realizing all our city's potential.

Come be part of our community with the City of Orlando.

Nature of Work:

Performs the duties of the Database Administrator, including highly technical and administrative work in the installation, development, and maintenance of the City's MS SQL Database environment. Ongoing database monitoring and performance tuning of mission critical 24/7 instances is a primary responsibility. Provides consulting services to the Applications Development staff to correctly develop application database design models. Responsible for developing and enforcing Citywide data and database design standards, operational procedures, and software interfaces. Incumbent exercises considerable judgment in the resolution of technical problems and in all administrative and professional situations. Work is performed under limited supervision and is evaluated while in progress and upon completion through direct observation, discussion, review of established procedures, and achievement of desired results.

Examples of Duties

• DB backup/restore operations
• DB integrity checks
• Index maintenance
• Performance tuning
• Data ETL (Extract, Transform & Load)
• DB migrations
• Data mapping
• Write queries, scripts and stored procedures
• Create/maintain documentation
• Create and adhere to standard operating procedures (SOPs)
• AlwaysOn configuration and maintenance
• SSIS, SSAS, SSRS familiarity
• Apply security best practices
• Manage DB access
• Install, upgrade and manage database applications
• Task automation
• Troubleshoot database and application issues
• Incident reporting
• Disaster recovery
• Capacity planning
• Basic networks and server knowledge
• Cloud awareness

Minimum Requirements
Bachelor degree in Computer Science, Management Information Systems, or related field required with four or more years related experience at least two of which must have been in database team leadership and project coordination and include the following: training and mentoring assistant/backup database personnel; coordinating activities developer teams in using database software; arrange, supervise and perform vendor software and tools upgrades. Specific experience with MS SQL and database modeling concepts is required. Training and/or experience with AWS and Azure cloud experience preferred but not required.

Supplemental Information
City of Orlando Benefits

If this posting indicates a degree is required, the following experience will apply in lieu of any degree as follows:

• Two (2) years of direct experience for an associate degree;
• Four (4) years of direct experience for a bachelor's degree;
• Six (6) years of direct experience for a master's degree; or
• Nine (9) years of direct experience for a doctoral degree

Closing Date/Time: 9/29/2023 5:00 PM Eastern