Database Administration Specialist 2 ( 20024734)

Ohio Department of Administrative Services•Columbus, OH

About The Position

Works under administrative direction and requires thorough knowledge of database administration Conducts performance tuning and configuration and tunes DBMS systems running on a single platform Performs load testing and scalability Issues Tier II resolution Designs and maintains various versions of data models Participates in Change Review Board Creates ERD (entity relation diagram) Conducts data normalization Performs data migrations and business process monitoring Writes platform specific code for data migration Monitors load balance Tunes cluster parameters for high performance Reporting business intelligence (warehousing Monitors and tunes data warehousing process Supports business intelligence activity Monitors and tunes business intelligence activity and performance Designs disaster recovery plan Restores malicious deletions Archives backup and restores Implements disaster recovery plan Research product enhancements and capabilities Stays current with emerging technologies Thoroughly investigates tests, evaluates, and defines a business case for any candidates new technologies relating to meeting customer requirements Stays current with new versions and patches Conducts proof of concept and develops standards Implement documentation of installation procedures and monitoring procedures and security policies Works closely with clients and business analysts Software development staff to define and resolve information flow and content issues Develop database strategies to support business needs.

Requirements

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.
completion of associate core program in computer science or information systems; 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.
completion of undergraduate core program in computer science or information systems; 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.
equivalent of minimum class qualifications for employment noted above.
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.
Job Skills: Database Administration

Responsibilities

Conduct performance tuning and configuration
Tune DBMS systems running on a single platform
Perform load testing and scalability
Issue Tier II resolution
Design and maintain various versions of data models
Participate in Change Review Board
Create ERD (entity relation diagram)
Conduct data normalization
Perform data migrations and business process monitoring
Write platform specific code for data migration
Monitor load balance
Tune cluster parameters for high performance
Monitor and tune data warehousing process
Support business intelligence activity
Monitor and tune business intelligence activity and performance
Design disaster recovery plan
Restore malicious deletions
Archive backup and restores
Implement disaster recovery plan
Research product enhancements and capabilities
Stay current with emerging technologies
Investigate, test, and evaluate new technologies
Stay current with new versions and patches
Conduct proof of concept and develop standards
Implement documentation of installation procedures and monitoring procedures and security policies
Work closely with clients and business analysts
Develop database strategies to support business needs