IT Database Administrator

Salary: $102,065.60 - $124,113.60 Annually

Location : Des Moines, IA

Job Type: Regular Full-Time

Job Number: 4193-10-2024

Department: Information Technology

Division: IT152000 - IT Enterprise Application Development

Opening Date: 10/31/2024

Closing Date: 11/25/2024 4:00 PM Central

FLSA: Exempt

Bargaining Unit: MEA

Occupational Group: Civil Service

Location of Vacancy: Information Technology Department

Recruitment: Entrance

Selection Method: Applicants meeting the minimum requirements will be referred to the hiring department for consideration. Applicants deemed most qualified based on qualifications may be contacted for an interview. Qualified applicants who need a reasonable accommodation must inform this office at (515) 283-4213 or TTY at Iowa Relay at 711 or 1-800-735-2942 prior to closing date.

Distinguishing Features of the Class

Under general direction, performs database operational support to ensure city-wide databases are available and running smoothly 24/7 providing a seamless flow of information throughout the organization while considering backend data structure and frontend accessibility. Provides support and training to end users including business unit operations personnel, staff in IT Operations: Applications, Help Desk, Infrastructure, and Business Analysts. Performs other related duties as assigned.

Acceptable Experience and Training

• Graduation from an accredited college or university with a Bachelor's Degree in Information Systems, Computer Science, Database Administration or related field, or a Bachelor's Degree in Business/Public Administration with major coursework in information systems, computer science, or database administration; and
• Considerable experience in database administration, application database development, database architecture, or a related field; or
• Any combination of experience, education and training which provides the knowledge, skills and abilities necessary to perform the work.
• MCSE/MCSA certification preferred.

NOTE: Certifications and Educational Transcripts need to be submitted to the City of Des Moines Human Resources Department; electronically to , by fax to 515-237-1680, or by mail to 1551 E MLK Jr Pkwy, Des Moines, IA 50317 by the application deadline date.
Required Special Qualifications

• A candidate will be required to successfully pass a post-offer background investigation, drug screen and physical examination.
• Must possess a valid Iowa Driver's License or evidence of equivalent mobility.

Examples of Essential Work (Illustrative Only)

• Implements design of databases to ensure the storage, security, selection and retrieval of information is performed logically, orderly and efficiently;
• Install and maintain database software and servers for the organization;
• Ensure quality performance of databases and their servers;
• Develop processes for optimizing and ensuring database security;
• Set and maintain database standards;
• Manage, maintain, and secure database access;
• Performance tuning of database systems;
• Install, upgrade, and manage database applications for both third party and internally built software;
• Diagnose and troubleshoot database errors;
• Recommend and implement emerging database technologies;
• Create and manage database reports, visualizations, and dashboards;
• Create automation for repeating database tasks;
• Be available for on-call support as needed;
• Other duties as assigned.

01

I acknowledge that my responses to the following supplemental questions must be clear and thorough to obtain credit. Responses such as "see attached resume", "see application", etc. are not acceptable.

• I acknowledge

02

Have you completed college coursework or have a degree in Information Systems, Computer Science, Database Administration or related field, or a Bachelor's Degree in Business/Public Administration with major coursework in information systems, computer science, or database administration? If Yes, submittal of college transcripts showing degree conferred is required by application deadline.Please submit to the City of Des Moines Human Resources Department; electronically to humanresources@dmgov.org, by fax to 515-237-1680, or by mail to 1551 E MLK Jr Pkwy, Des Moines, IA 50317 by the application deadline date.

• Yes, I understand college transcripts are required by the application deadline and have attached my transcripts to my application.
• Yes, I understand college transcripts are required by the application deadline and I have requested my transcripts.
• I have not taken college course work and do not have college transcripts to provide.

03

Do you possess any related certifications? If yes, please explain.Submittal of certification records is required by application deadline. Please submit to the City of Des Moines Human Resources Department; electronically to humanresources@dmgov.org, by fax to 515-237-1680, or by mail to 1551 E MLK Jr Pkwy, Des Moines, IA 50319 by the application deadline date.

04

Tell us how many years of experience you have in designing and administering databases for a large environment. Also, explain your role in designing and administering these databases, and give an example of how you improved an organization's database function. If you have no experience, indicate "none".

05

Tell us how many years of experience you have in application database development for a large environment. Also, tell us about one of your application database development projects. What was the scale of the project? What was your role? What was the business reason for the project? If you have no experience, indicate "none".

06

Tell us how many years of experience you have with database architecture in a large environment. Also, tell us about one of your database architecture projects. What was the scale of the project? What was your role? What was the business reason for the project? If you have no experience, indicate "none".

07

Describe your experience with:A) SQLB) SQL Server ToolsInclude how many years, and the scope of your experience. If you have no experience, indicate "none".

08

Describe your experience withA) PowerShellB) UnixShell ScriptingInclude how many years, and the scope of your experience. If you have no experience, indicate "none".

09

Tell us how many years of experience you have managing projects such as upgrades, software rollouts, or other large scale implementations and where you obtained this experience. If you have no experience, indicate "none".

Required Question

Location: South Des Moines, IA, US

Posted Date: 11/22/2024