Database Administrator (IT Senior Analyst)

Full-time position available with the General Services Department, Information Technology Division located at 1111 Locust Street
Salary Range: $5,173-$7,759/month
Normal Work Days/Hours: Monday-Friday, 8:00 a.m.-5:00 p.m. *Telework schedule available after 6-month probationary period completed
Application Deadline Date: November 11, 2024


Responsibilities

A Server Database Administrator (DBA) is responsible for the overall management, maintenance, and security of an organization's databases. It also plays a crucial role in ensuring the reliability, performance, and security of an organization's data infrastructure.

• Installs and configures database servers and related software.
• Sets up database infrastructure based on business requirements.
• Designs and implements database schemas, tables, indexes, and views.
• Optimizes database structures for performance and scalability.
• Monitors database performance and identify bottlenecks.
• Performs database tuning to ensure optimal performance.
• Develops and implements backup and recovery strategies.
• Performs regular backups and ensure data recovery procedures are in place.
• Implements and enforces database security policies.
• Manages user access and permissions to databases.
• Performs routine maintenance tasks such as patching and updates.
• Cleans up and archives old data as necessary.
• Ensures data integrity and quality through regular checks and validations.
• Implements data cleansing procedures to maintain data accuracy.
• Plans for future database growth and capacity needs.
• Recommends hardware and software upgrades as necessary.
• Troubleshoots database issues and provides technical support to users.
• Resolves database-related incidents and problems promptly.
• Maintains comprehensive documentation of database configurations, procedures, and changes.
• Generates reports on database performance, usage, and other metrics.
• Works closely with developers, system administrators, and other stakeholders.
• Communicates database-related issues and updates to the relevant teams.
• Develops and tests disaster recovery plans to ensure business continuity.
• Conducts regular disaster recovery drills to ensure preparedness.
• Ensures databases comply with relevant regulations and standards.
• Assists with audits and provide necessary documentation.
• Automates routine database tasks to improve efficiency and reduce manual workload.

Qualifications

REQUIRES an accredited Bachelor's degree and 3 years of technology experience; OR a n equivalent combination of qualifying education and technology experience. Preference given to those with server hardware or storage systems experience.


Other Information

URGENT!!! CRITICAL RECRUITMENT INFORMATION

Applications and/or resumes are evaluated on the information received by the application deadline. Please ensure that your application or resume clearly demonstrates how you meet the minimum qualifications for the position for which you are applying, this includes providing all relevant educational dates and a detailed description of relevant work experience, including months/years of employment. Applications and/or resumes may not be considered if information is incomplete.

In order for a resume to be used in lieu of an application the resume must have been submitted online via the City's Applicant Tracking System.

Positions requiring a high school diploma/GED certificate must be obtained from a school/program accredited by the Department of Education and recognized by the U.S. Secretary of Education.

The minimum education requirement for positions that allow for experience equivalency for an accredited degree is a high school diploma. Unless otherwise specified, an accredited degree must be obtained from a college or university listed with the U.S. Department of Education and recognized by the U.S. Secretary of Education.
For positions with a salary grade of EX6 or higher that require an accredited degree, qualifying professional experience must be obtained AFTER the accredited degree is obtained.
Successful completion of a pre-employment criminal history/background check is required for all positions. Some positions require a post offer drug screen and/or physical.

If appointed, non-residents must obtain residency inside Kansas City, Missouri's city limits within nine months.

The City of KCMO is an equal opportunity employer that values diversity and inclusion in the workplace. The City is committed to providing a workplace environment for its employees and citizens free from discrimination based on race, color, sex (including pregnancy), national origin, religion, age, disability, marital status, genetic information, sexual orientation, or gender identity. For more information, please see our EEO Policy

The City of KCMO is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process, please call 816-513-1908 or send an e-mail to accommodations@kcmo.org .

If claiming military veterans' preference points, you must attach a copy of your DD-214 or a DD-256 (for reservists). To claim veterans' points you must have served 180 days of regular active duty service and be discharged or released under honorable conditions during peacetimes or 90 days of active duty service, one (1) day during "wartime" and a last discharge or release under honorable conditions. (DOD) 38 U.S. Code • 4211).

• 

• City of Kansas City

Show more