The Ohio Industrial Commission’s Office of Information Technology is seeking Database Administration Specialist 1s to support agency databases, data transfers, analytics, and data warehousing. The role designs and implements efficient ETL/ELT data-transfer processes; develops dashboards, summaries, and visualizations using agency data and tools such as MS Power BI; and assists with data-model design and physical data-model implementation. The position also assists with development and maintenance of the agency data warehouse using cloud solutions such as Snowflake and Azure Data Factory. At the full performance level, the specialist collaborates with systems administrators on table-access security, contributes to data governance, writes platform-specific code for data migrations and visualizations using tools and languages such as Python, SQL, Java, and DAX, and monitors cloud and on-premises databases and data stores using logs, load-test results, and performance-monitoring tools. The role requires knowledge of relational database management systems such as MS SQL Server and schemaless/NoSQL solutions, understanding of agency business processes, and organizational, problem-solving, and communication skills. Under the direction of the Information Technology Supervisor, the specialist advises and consults with users on database access, resolves data conflicts and inappropriate data use, resolves Tier I issues, and promotes system security by following agency and state IT security policies and standards. This is an on-site position in Columbus, Ohio. Travel may be required, and the employee must be able to provide their own transportation and/or legally operate a state-owned vehicle.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Job Type
Full-time
Career Level
Entry Level
Education Level
No Education Listed