City of Kansas City
Database Administrator (IT Senior Analyst)
City of Kansas City, Kansas City, Missouri, United States, 64101
Pay, Benefits, & Work ScheduleFull-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
ResponsibilitiesA 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 identifies bottlenecks.
Performs database tuning to ensure optimal performance.
Develops and implements backup and recovery strategies.
Performs regular backups and ensures 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 provides necessary documentation.
Automates routine database tasks to improve efficiency and reduce manual workload.
QualificationsREQUIRES
an accredited Bachelor’s degree and 3 years of technology experience; OR an equivalent combination of qualifying education and technology experience.
Preference given to those with server hardware or storage systems experience.
Other InformationURGENT!!! 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, including 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.
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.
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.
#J-18808-Ljbffr
ResponsibilitiesA 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 identifies bottlenecks.
Performs database tuning to ensure optimal performance.
Develops and implements backup and recovery strategies.
Performs regular backups and ensures 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 provides necessary documentation.
Automates routine database tasks to improve efficiency and reduce manual workload.
QualificationsREQUIRES
an accredited Bachelor’s degree and 3 years of technology experience; OR an equivalent combination of qualifying education and technology experience.
Preference given to those with server hardware or storage systems experience.
Other InformationURGENT!!! 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, including 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.
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.
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.
#J-18808-Ljbffr