Senior Database Administrator

Must apply at www.cuyahogacounty.gov/human-resources. Click find a career

Department: Information Technology

Anticipated Work Schedule: M_F

Reports To: Administrator IT Applications

Full Time or Part Time: FT

Regular or Temporary: R

Bargaining Unit: N/A

Classified or Unclassified: Classified

FLSA: Exempt

Summary

The purpose of this class is to monitor, design, implement, and coordinate database operations and assigned application systems to ensure data integrity, security, performance, and consistency.

This is a technical, advanced journey level classification, working under direction from the unit manager. This class receives direction from management in the form of broad objectives and receives only occasional instruction or assistance as new or unusual situations arise. Employees are expected to become/remain up-to-date regarding methods, protocols, procedures, and applicable regulations. The employee is expected to independently exercise judgment in performing work and ensure that assigned activities are planned and completed in a timely and efficient manner. This class is distinguished from the Database Administrator in that the senior level has more extensive database, computer networking, computer architecture, operating system, and programming knowledge and experience and assists and instructs the lower-level class.

Essential Job Functions

The following duties are normal for this classification. These are not to be construed as exclusive or all-inclusive. Other duties may be required and assigned.

• Monitors and troubleshoots database systems to ensure optimal performance, system availability, data integrity and consistency, and security of data; creates and maintains database strategies and solutions (i.e., backups, restores, database consistency checks, index reorganizations/rebuilds); automates database maintenance and monitoring tasks; configures and maintains database replication; troubleshoots and resolves application and maintenance problems involving databases, server operating systems, networks, applications, websites, and programming code; implements applications upgrades, database patching, and database migrations; executes disaster recovery preparation by backing up and restoring databases; installs and configures operating system and database related software including but not limited to reporting, performance monitoring, and data migration and integration servers and applications; provides application support work and enhancements; extracts, transforms, loads, and queries data from various sources; documents technical information including database configuration information (i.e., IP addresses, database statistics, maintenance plan schedules, etc.).
• Designs, develops, implements, and analyzes new and existing physical and logical database designs to ensure optimal performance and high availability and utilize minimal server resources; participates in database development projects including determining user needs, database requirements, and network, operating system, and storage constraints; conducts program code and database design reviews to ensure optimal performance, code migrations, flexible and logical design, and adherence to best practices and programming/data standards; develops and/or modifies web and desktop applications including user interface, interface with existing systems, business rules, etc.; designs, validates, and/or implements end-to-end solutions involving databases; assesses growth rate and conducts capacity planning; designs and develops/modifies data warehousing solutions.

• Collaborates with IT and Business leadership to develop database strategies that meet availability, quality, and security requirements and integrate third party applications; collaborates with system and network administrators on best practices for database environment configuration, application and system upgrades, and capacity planning; researches, evaluates, and provides recommendations on other database systems not administered directly; mentors developers on best practices for software development, programming standards, change control and database design; advises and instructs others regarding database operations and procedures.
• Engages in professional development activities; attends professional group meetings, conferences, seminars, and trainings to learn new information on industry trends; stays abreast of new trends and innovations in the field of computer technology through independent research; applies new learned knowledge to existing database projects.

Minimum Requirements

• Bachelor’s degree in computer science, engineering, business administration or a related field and six (6) years related experience including database administration and development; software development, programming, and data modeling;

or any equivalent combination of training and experience as defined below:

Highest degree of education attained

Experience required

High school diploma/GED

10 years

Unrelated associate degree

10 years

Related associate degree

8 years

Unrelated bachelor’s degree

8 years

Related bachelor’s degree

6 years

Unrelated master’s/doctoral degree

6 years

Related master’s/doctoral degree

6 years

• Related degree fields: computer science, engineering, business administration, computer engineering, information systems and technology, management information systems, business analytics, software engineering and development, programming, data modeling, user experience design, computer and security technology, network security.
• Related work experience: database administration and development, programming, SQL knowledge, data modeling, database design, Unix systems knowledge, manipulating data within a database, writing technical specifications and documents, writing scripts for importing and exporting information, maintaining complex SQL scripts for designing, building, or testing.

Application Process

This is a competitive, classified position. The Personnel Review Commission (PRC) will check your application to make sure you meet the minimum qualifications. If you do, the PRC will invite you to take a civil service examination. The exam is specific to this position. Everyone who passes the exam goes on an eligibility list. To fill this opening, the PRC sends the hiring department and Human Resources (HR) a certified eligibility list with the top 25% candidates (or at least the ten highest scoring candidates, whichever is greater). HR helps the hiring department decide who from the certified list to follow up with for interviews and then a job offer. Most of our communication with candidates is through email. Regularly check the email address you gave us in your job profile. Watch your Spam folder, just in case. If we offer you a job, you must pass a drug screen and background check before the offer becomes final. Prior criminal convictions do not automatically disqualify you from employment; the County looks at criminal convictions on a case-by-case basis using the guidelines in Chapter 306 of the County Code.

EQUAL OPPORTUNITY EMPLOYER

Cuyahoga County is committed to fostering a diverse and inclusive workforce, which includes building an environment that respects the individual, promotes innovation and offers opportunities for all employees to develop to their full potential. A diverse workforce helps the County realize its full potential. The County benefits from the creativity and innovation that results when people with different experiences, perspectives, and cultural backgrounds work together.

The County is committed to providing equal employment opportunities for all individuals regardless of race, color, ancestry, national origin, language, religion, citizenship status, sex, age, marital status, sexual preference or orientation, gender identity/expression, military/veteran status, disability, genetic information, membership in a collective bargaining unit, status with regard to public assistance, or political affiliation.

If you need assistance applying or participating in any part of the candidate experience, contact Human Resources at 216-443-7190 and ask to speak with a talent acquisition team member.

Job Type: Full-time

Pay: $85,737.60 - $120,016.00 per year

Benefits:

• Dental insurance
• Employee assistance program
• Flexible schedule
• Flexible spending account
• Health insurance
• Life insurance
• Parental leave
• Retirement plan
• Tuition reimbursement
• Vision insurance

Schedule:

• Monday to Friday

Work Location: In person