GovernmentJobs.com
Database Manager
The Colorado Department of State (CDOS) is seeking diverse individuals from all backgrounds to apply for a position that makes a direct impact on enhancing the lives of Coloradans. If your goal is to build a career that makes a difference through the work you do each day, consider joining the dedicated employees of the Colorado Department of State. Whether working from your home or collaborating onsite, your professional experience will be connected and meaningful. Our office offers an RTD Eco-pass (currently free of charge) and is conveniently located near Civic Center Station, RTD light-rail lines, and the 16th Street Mall. In addition to a great location and fulfilling, impactful work, we offer: Employee wellness programs and an on-site fitness center 12 paid holidays per year plus generous personal time off and sick leave Access to a diverse array of technical, leadership and supervisory training opportunities Strong, yet flexible retirement benefits including a choice of the PERA Defined Benefit Plan or the PERA Defined Contribution Plan, plus optional 401K and 457 plans Medical and dental health plans Paid life insurance Automatic short-term (and optional long-term) disability coverage Excellent work-life balance through flex schedules, flexplace/remote work, and ad-hoc arrangements Some positions may qualify for the Public Service Loan Forgiveness Program. For more information, go to: https://studentaid.gov/manage-loans/forgiveness-cancellation Our mission is to make government easy and accessible for people to further democracy, support economic opportunity for all Coloradans, and demonstrate a standard of integrity and excellence. Our vision is to ensure all Coloradans have a voice in our future, help Coloradans and their businesses thrive, and be the best at what we do. The State of Colorado is an Equal Opportunity Employer. At the Colorado Department of State, we are dedicated to equity, diversity, and inclusion. We are committed to building work environments that are inclusive and reflect our communities and the diverse talents of all people. We highly encourage people from all backgrounds, identities, and abilities to apply. The Colorado Department of State is unique from many state agencies in that we are a smaller agency with an in-house IT division, as a result our employees maintain greater collective impact over the work product of the Department. To ensure that the Department databases are always available with a high level of data integrity, responsiveness, and that they meet the needs across all of Colorado Department of State (CDOS). As the Database Manager, you will be the leader of the highly valued database unit. You'll supervise a team of Database Administrator professionals while also working in multiple database production and development environments yourself. The ideal candidate will be a critical and creative thinker with strong leadership and problem-solving skills. To succeed in this role, it is important that you have outstanding database programming skills and experience with supervision of staff. In this role you will: supervise the DBA team. be a Database Administrator (DBA). provide tier level support using existing ticketing system for database events and data issues. be an IT expert in Data Analysis and Integrity. work across all development projects. work with IT staff and users of existing and proposed systems. design and construct new databases, with particular focus on data integrity/data and integration across all divisions. maintain existing applications with the same focus. implement data conversions as necessary for applications. perform database design using both logical and physical models. predict and react to situations to keep the database running smoothly. immediately react to critical system events and ensure speedy recovery of data and user connectivity. oversee team design, analysis, development, test, and maintenance. test and learn new development technologies for the CDOS, such as Postgres, Oracle, Mongo, and SQL Server. evaluate new database software to ascertain the best product and methodology for the CDOS. be responsible for maintaining balance between application performance, user efficiency, and data integrity in the development and production environments. maintain confidentiality of all confidential and personal identifying information, personnel information, and any other confidential or proprietary information, as well as comply with all State and Department policies regarding professional conduct and professional practices. This position requires a total of six (6) years in applicable professional experience and/or education in a field of study related to the work. To be considered for this position, your application must clearly demonstrate that you meet one of the following options outlined below: Option 1 Experience: Six (6) years of professional experience as a database administrator with a focus on production and development work. One (1) year of which must have been at the level of a work leader, staff authority, unit supervisor, or equivalent over a team of at least two staff doing the work of database administration. OR Option 2 Experience and/or Education: A combination of related education, formalized apprenticeship program, certification, and/or relevant experience as defined in Option 1 to equal six (6) years. Related education includes accredited course work in Computer Science, Information Technology, Management Information Systems, Mathematics/Statistics, Data Science/Data Analytics, Database Management, Engineering, or closely related field. Education will not substitute for the one (1) year of professional experience at the level of a work leader, staff authority, unit supervisor, or equivalent over a team of at least two staff doing the work of database administration. Preference will be given to those candidates with previous State Service related to the work assigned to the position. Ability to build strong interpersonal relationships with peers, and other senior management. Experience collaborating with senior leadership to identify, evaluate, and implement solutions. Database administration experience, including in production and development environments. Database architecture/design experience. Database experience with one or more Postgres, Informix, SQL Server, Mongo, or Oracle. Hands-on experience with database standards. Experience optimizing database performance, to include identifying and resolving performance bottlenecks. Experience in implementing high availability (HA) and disaster recovery (DR) solutions. Experience in scripting languages such as SQL, PowerShell, Python, or Bash for automating routine administrative tasks, scripting database deployments, and creating custom monitoring solutions. Experience with database security best practices and experience implementing security measures such as access controls, encryption, authentication, and auditing. Experience diagnosing and resolving database-related issues promptly. Data analysis experience. Experience with cloud database technologies. Stored procedures experience. Experience updating large databases through nightly and monthly extracts. Strong written and verbal communication skills, with the ability to clearly convey technical information to non-technical users. Demonstrated ability to work independently, manage priorities, and collaborate effectively across teams. Experience with hiring, onboarding, and training processes for new employees. Continuous Learning and Adaptability SQL Skills, Stored Procedures, and Trigger Skills Critical Thinking Skills Written and Oral Comprehension and Expression Skills Performance Tuning and Optimization Security Management Automation and Scripting Troubleshooting Skills Database Design Coordination Database Management Systems (DBMS) Knowledge Data Migration and Integration Committed to Advancing a Diverse and Inclusive Perspective Active Listening Skills Complex Problem-Solving Skills Judgment and Decision-Making Skills The Department of State does NOT offer sponsored Visa for employment purposes. Travel may be required for professional development and trainings or as requested by manager. This position will be required to successfully pass a background check. When completing your application package, ensure you have submitted your transcript (if applicable). Must be a Colorado resident at the time of application. Applications will be reviewed by a Human Resources Specialist to determine if you meet the minimum qualifications for the position. Your application should specifically address your specialized experience, work products, accomplishments, etc. as they relate to the position duties and minimum and preferred qualifications. The minimum qualifications listed in the announcement are NOT optional. Cover letters and resumes will NOT be accepted in lieu of the official State of Colorado application form. Cover letters and resumes may be attached to the application as supplemental information. If it is determined that you meet the minimum qualifications, your application may also be used as part of the comparative analysis process to identify a top group for further consideration. The comparative analysis may consist of application reviews, answers to supplemental questions, review of submitted work samples, phone screens, structured interviews, and any other method determined to be valuable in identifying the right candidate. Appeal Rights An applicant who has been removed from an employment list or removed from consideration during the selection process may request a review by the State Personnel Director. As an applicant directly affected by the results of the selection or comparative analysis process, you may file a written appeal with the State Personnel Director. Review of the completed, signed and submitted appeal will be timely on the basis of written material submitted by you,
The Colorado Department of State (CDOS) is seeking diverse individuals from all backgrounds to apply for a position that makes a direct impact on enhancing the lives of Coloradans. If your goal is to build a career that makes a difference through the work you do each day, consider joining the dedicated employees of the Colorado Department of State. Whether working from your home or collaborating onsite, your professional experience will be connected and meaningful. Our office offers an RTD Eco-pass (currently free of charge) and is conveniently located near Civic Center Station, RTD light-rail lines, and the 16th Street Mall. In addition to a great location and fulfilling, impactful work, we offer: Employee wellness programs and an on-site fitness center 12 paid holidays per year plus generous personal time off and sick leave Access to a diverse array of technical, leadership and supervisory training opportunities Strong, yet flexible retirement benefits including a choice of the PERA Defined Benefit Plan or the PERA Defined Contribution Plan, plus optional 401K and 457 plans Medical and dental health plans Paid life insurance Automatic short-term (and optional long-term) disability coverage Excellent work-life balance through flex schedules, flexplace/remote work, and ad-hoc arrangements Some positions may qualify for the Public Service Loan Forgiveness Program. For more information, go to: https://studentaid.gov/manage-loans/forgiveness-cancellation Our mission is to make government easy and accessible for people to further democracy, support economic opportunity for all Coloradans, and demonstrate a standard of integrity and excellence. Our vision is to ensure all Coloradans have a voice in our future, help Coloradans and their businesses thrive, and be the best at what we do. The State of Colorado is an Equal Opportunity Employer. At the Colorado Department of State, we are dedicated to equity, diversity, and inclusion. We are committed to building work environments that are inclusive and reflect our communities and the diverse talents of all people. We highly encourage people from all backgrounds, identities, and abilities to apply. The Colorado Department of State is unique from many state agencies in that we are a smaller agency with an in-house IT division, as a result our employees maintain greater collective impact over the work product of the Department. To ensure that the Department databases are always available with a high level of data integrity, responsiveness, and that they meet the needs across all of Colorado Department of State (CDOS). As the Database Manager, you will be the leader of the highly valued database unit. You'll supervise a team of Database Administrator professionals while also working in multiple database production and development environments yourself. The ideal candidate will be a critical and creative thinker with strong leadership and problem-solving skills. To succeed in this role, it is important that you have outstanding database programming skills and experience with supervision of staff. In this role you will: supervise the DBA team. be a Database Administrator (DBA). provide tier level support using existing ticketing system for database events and data issues. be an IT expert in Data Analysis and Integrity. work across all development projects. work with IT staff and users of existing and proposed systems. design and construct new databases, with particular focus on data integrity/data and integration across all divisions. maintain existing applications with the same focus. implement data conversions as necessary for applications. perform database design using both logical and physical models. predict and react to situations to keep the database running smoothly. immediately react to critical system events and ensure speedy recovery of data and user connectivity. oversee team design, analysis, development, test, and maintenance. test and learn new development technologies for the CDOS, such as Postgres, Oracle, Mongo, and SQL Server. evaluate new database software to ascertain the best product and methodology for the CDOS. be responsible for maintaining balance between application performance, user efficiency, and data integrity in the development and production environments. maintain confidentiality of all confidential and personal identifying information, personnel information, and any other confidential or proprietary information, as well as comply with all State and Department policies regarding professional conduct and professional practices. This position requires a total of six (6) years in applicable professional experience and/or education in a field of study related to the work. To be considered for this position, your application must clearly demonstrate that you meet one of the following options outlined below: Option 1 Experience: Six (6) years of professional experience as a database administrator with a focus on production and development work. One (1) year of which must have been at the level of a work leader, staff authority, unit supervisor, or equivalent over a team of at least two staff doing the work of database administration. OR Option 2 Experience and/or Education: A combination of related education, formalized apprenticeship program, certification, and/or relevant experience as defined in Option 1 to equal six (6) years. Related education includes accredited course work in Computer Science, Information Technology, Management Information Systems, Mathematics/Statistics, Data Science/Data Analytics, Database Management, Engineering, or closely related field. Education will not substitute for the one (1) year of professional experience at the level of a work leader, staff authority, unit supervisor, or equivalent over a team of at least two staff doing the work of database administration. Preference will be given to those candidates with previous State Service related to the work assigned to the position. Ability to build strong interpersonal relationships with peers, and other senior management. Experience collaborating with senior leadership to identify, evaluate, and implement solutions. Database administration experience, including in production and development environments. Database architecture/design experience. Database experience with one or more Postgres, Informix, SQL Server, Mongo, or Oracle. Hands-on experience with database standards. Experience optimizing database performance, to include identifying and resolving performance bottlenecks. Experience in implementing high availability (HA) and disaster recovery (DR) solutions. Experience in scripting languages such as SQL, PowerShell, Python, or Bash for automating routine administrative tasks, scripting database deployments, and creating custom monitoring solutions. Experience with database security best practices and experience implementing security measures such as access controls, encryption, authentication, and auditing. Experience diagnosing and resolving database-related issues promptly. Data analysis experience. Experience with cloud database technologies. Stored procedures experience. Experience updating large databases through nightly and monthly extracts. Strong written and verbal communication skills, with the ability to clearly convey technical information to non-technical users. Demonstrated ability to work independently, manage priorities, and collaborate effectively across teams. Experience with hiring, onboarding, and training processes for new employees. Continuous Learning and Adaptability SQL Skills, Stored Procedures, and Trigger Skills Critical Thinking Skills Written and Oral Comprehension and Expression Skills Performance Tuning and Optimization Security Management Automation and Scripting Troubleshooting Skills Database Design Coordination Database Management Systems (DBMS) Knowledge Data Migration and Integration Committed to Advancing a Diverse and Inclusive Perspective Active Listening Skills Complex Problem-Solving Skills Judgment and Decision-Making Skills The Department of State does NOT offer sponsored Visa for employment purposes. Travel may be required for professional development and trainings or as requested by manager. This position will be required to successfully pass a background check. When completing your application package, ensure you have submitted your transcript (if applicable). Must be a Colorado resident at the time of application. Applications will be reviewed by a Human Resources Specialist to determine if you meet the minimum qualifications for the position. Your application should specifically address your specialized experience, work products, accomplishments, etc. as they relate to the position duties and minimum and preferred qualifications. The minimum qualifications listed in the announcement are NOT optional. Cover letters and resumes will NOT be accepted in lieu of the official State of Colorado application form. Cover letters and resumes may be attached to the application as supplemental information. If it is determined that you meet the minimum qualifications, your application may also be used as part of the comparative analysis process to identify a top group for further consideration. The comparative analysis may consist of application reviews, answers to supplemental questions, review of submitted work samples, phone screens, structured interviews, and any other method determined to be valuable in identifying the right candidate. Appeal Rights An applicant who has been removed from an employment list or removed from consideration during the selection process may request a review by the State Personnel Director. As an applicant directly affected by the results of the selection or comparative analysis process, you may file a written appeal with the State Personnel Director. Review of the completed, signed and submitted appeal will be timely on the basis of written material submitted by you,