Database Administration Specialist 2 ( 20024734) at Ohio Department of Administrative Services

Columbus, Ohio, United States -

Full Time

Start Date

Immediate

Expiry Date

23 Jun, 26

Salary

0.0

Posted On

26 Mar, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Database Administration, Performance Tuning, Configuration, DBMS Systems, Load Testing, Scalability, Data Models, ERD Creation, Data Normalization, Data Migrations, Business Process Monitoring, Cluster Parameter Tuning, Disaster Recovery, Backup and Restore, Proof of Concept, Security Policies

Industry

Government Administration

Description

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. 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. -Or 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. Or- 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. -Or 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. Job Skills: Database Administration

Responsibilities

This role involves conducting performance tuning, configuration, and monitoring of DBMS systems, designing and maintaining data models, and participating in change review boards. Key duties include performing data migrations, designing disaster recovery plans, and researching new technologies to meet customer requirements.