Database Administration Specialist 2 -
Database Administration Specialist 2 -
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Position Qualifications
The ideal candidate at minimum must have the following:
Alternative 1:
- 60 mos. combined work experience in any combination of the following: conducting performance tuning and configuration creating data models and providing technical Tier II database support including 12 mos. work experience in the primary technology specified by the agency in the position description & job posting.
Alternative 2:
- Completion of associate core program in computer science or information systemsAND
- 42 mos. combined work experience in any combination of the following: conducting performance tuning and configuration creating data models and providing technical Tier II database support including 12 mos. work experience in the primary technology specified by the agency in the position description & job posting.
Alternative 3:
- Completion of undergraduate core program in computer science or information systemsAND
- 36 mos. combined work experience in any combination of the following: conducting performance tuning and configuration creating data models and providing technical Tier II database support including 12 mos. work experience in the primary technology specified by the agency in the position description & job posting.
Alternative 4:
- Equivalent of minimum class qualifications for employment noted above.
Note: The official position description on file with the designated agency is to reflect the required primary technology directly relating to the duties of the position. Only those applicants possessing the experience in the required primary technology listed in the position description & job posting are to be considered for any vacancies posted. The job posting must list the required technology commensurate with the position in question.
Primary Technology: SQL Server
Technical Skills: Information Technology Database Administration
Professional Skills: Critical Thinking Customer Focus Decision Making Written Communication
Required Educational Transcripts
Official transcripts are required for all postsecondary education coursework or degrees listed on the application. Applicantsmustsubmit an official transcript before receiving a formal employment offer. Failure to provide transcripts within five (5) business days of the request will result in disqualification from further consideration. Transcripts printed from the institutions website will not be accepted. OhioMHAS reserves the right to evaluate the academic validity of the degreegranting institution.
Ohio is a Disability Inclusion State and strives to be a model employer of individuals with disabilities. The State of Ohio is committed to providing access and inclusion and reasonable accommodation in its services activities programs and employment opportunities in accordance with the Americans with Disabilities Act (ADA) and other applicable laws.
Application Procedures
To be considered for this position you must apply online through this posting website (). We no longer accept paper applications. When completing your online Ohio Civil Service Application be sure to clearly describe how you meet the minimum qualifications outlined on this job posting. We will not give credit for your qualifications experience education and training in the job selection process if there is no evidence provided on your application. In addition see resume is not a substitution for completing supplemental questions. Answers to the supplemental questions must be fully supported by the work experience/education sections of your application. You may check the status of your application by signing into your profile on this website (). We will communicate with you through the email you provided in your profile and job application. Be sure to check your email regularly.
Background Check Notice
The final candidate selected for this position will be required to undergo a criminal background check. Criminal convictions do not necessarily preclude an applicant from consideration for a position. An individual assessment of an applicants prior criminal convictions will be made before excluding an applicant from consideration.
If you require a reasonable accommodation for the application process assessment &/or interview please contact Andrew Seifert EEO/ADA Administrator at or.
What youll do at OhioMHAS:
OhioMHAS Information Services is the technology arm of the third largest cabinet level agency in the state of Ohio. We develop and support technology for several critical business solutions used by the agency as well as by county and local behavioral health care providers across the state. We are seeking a highly skilled and motivated Database Administration Specialist 2 primary technology SQL Server to join our IT team. This position is responsible for advancedlevel database management including performance tuning data modeling business intelligence support disaster recovery and technical mentorship.
The ideal candidate will possess deep knowledge of database systems and be capable of collaborating across teams to support scalable secure and efficient data environments.
Key Responsibilities:
- Database Performance & Configuration: Tune DBMS systems running on a single platform for optimal performance. Perform load testing and ensure scalability of database systems. Provide Tier II database support for issue resolution. Design and maintain data models and create entity relationship diagrams (ERDs). Conduct data normalization and write platformspecific code for data migrations. Monitor load balance and tune cluster parameters to maintain high availability and performance. Participate in the Change Review Board to assess and implement changes. Troubleshoot and resolve database performance and configuration issues.
- Business Intelligence & Data Warehousing: Monitor and tune data warehousing processes and business intelligence performance. Support business intelligence activities and data analytics processes. Design and implement disaster recovery plans including restoration of malicious deletions and system recovery. Manage data archiving backup and restore processes.
- Technology Research & Standards Development: Stay current with emerging technologies and research enhancements that align with business needs. Conduct proofs of concept and develop business cases for adopting new database technologies. Develop document and implement standards and best practices for installation monitoring security configuration and migration.
- Business Analysis & Client Collaboration: Collaborate with clients business analysts system programmers and application developers to resolve data flow and content issues. Translate business requirements into effective platformspecific database solutions. Develop database strategies to support evolving business goals. Participate in project planning using best practices in database design and administration. Provide informal mentorship to peers and junior staff through documentation conversation or technical guidance.
This is anhourly position covered by the OCSEA/AFSCME bargaining unit (union)with a pay range of35 on theOCSEAPay Range Schedule.Normal working hours are 1stshift (8:00am to 5:00pm).This position is located within ourOffice of Information Technologyheadquartered at theJames Rhodes State Office Tower 30 East Broad Street 33rd floor Columbus Ohio 43215.
Unless required by any applicable union contract and/or requirements of the Ohio Revised Code the selected candidate will begin atStep 1 of the pay range schedule listed above with an opportunity for pay increase after six months of satisfactory performance and then a yearly raise thereafter.
At the State of Ohio we take care of the team that cares for Ohioans. We provide a variety of quality competitive benefits to eligible fulltime and parttime employees*. For a list of all the State of Ohio Benefits visit ourTotal Rewards website! Our benefits package includes:
- Medical Coverage
- Free Dental Vision and Basic Life Insurance premiums after completion of eligibility period
- Paid time off including vacation personal sick leave and 11 paid holidays per year
- Childbirth Adoption and Foster Care leave
- Education and Development Opportunities (Employee Development Funds Public Service Loan Forgiveness and more)
- Public Retirement Systems (such as OPERS STRS SERS and HPRS)&Optional Deferred Compensation (Ohio Deferred Compensation)
*Benefits eligibility is dependent on a number of factors. The Agency Contact listed above will be able to provide specific benefits information for this position.
Database Administration Specialist 2
Central Office
Who we are:
At the Ohio Department of Mental Health and Addiction Services (OhioMHAS) we strive to exemplifyThe Heart of Hopefor individuals and families affected by mental health and substance use disorders.
We proudly employ over 2800 dedicated employees across our six inpatient behavioral health hospitals Ohio Pharmacy Services Ohios prison systems and the central office located in the James A. Rhodes State Office Tower in Columbus OH.
OhioMHAS Values:
- ServiceOriented (Person Centered Solution Oriented Customer Service Focused)
- Collaborative (Approachable Reasonable Transparent)
- Value Driven
- Innovative (Yes Before No)
- Strong Sense of Urgency
Our team of highly qualified professionals advances a critical system of behavioral healthcare in Ohio that helps people be well get well and stay well. Join our collaborative serviceoriented environment where you will be respected and valued.
The State of Ohio is a drugfree workplace which prohibits the use of marijuana (recreational marijuana/nonmedical cannabis). Please note this position may be subject to additional restrictions pursuant to the State of Ohio DrugFree Workplace Policy (HR39) and as outlined in the posting.
Required Experience:
Unclear Seniority
Employment Type
Full-Time
