Database Administration Specialist 1 - PN 20064762

State of Ohio • Columbus, OH

1d • Onsite

About The Position

The Ohio Industrial Commission (OIC), Office of Information Technology, is seeking a talented Database Administration Specialist 1. The ideal candidate will design and implement processes for the efficient transfer of (ETL/ELT) between systems within and outside the agency; design and develop dashboards, summaries and visualizations using agency data and solutions such as MS Power BI; and assist with data model designs and physical data model implementations. Additionally, this position will assist with the development and maintenance of OIC’s data warehouse using cloud solutions such as Snowflake and Azure Data Factory. At the full performance level of the position, the candidate should be able to collaborate with systems administrators to set table access security, provide some data governance, write platform specific code for data migrations and visualizations (Python, SQL, Java, Dax), and monitor cloud and on-premise databases and stores utilizing logs, load test results, and performance monitoring tools. A strong knowledge of RDBMS tools such as MS SQL Server and schemaless/no-SQL solutions is required. This role demands a solid understanding of agency business processes, along with strong organizational, problem-solving, and communication skills. Under the direction of the Information Technology Supervisor, advises & consults with users on accessing various databases & to resolve data conflicts & inappropriate use of data. Resolves Tier I issues. Promotes system security & awareness by adhering to the Agency’s &/or State’s IT security policy(s) & standards. Provides performance tuning for query language statements. Reads & interprets query plans. Provides monitoring using vendor supplied & 3rd party utilities. Restores from disaster recovery plan. Monitors disaster recovery plan. Sets security & validates all updates through database connections. Assists with data model design Implements physical data models. Assists with tuning a single RBMS system on a single platform. Assists with writing platform specific code. Designs & implements processes for the efficient transfer of data (ETL/ELT). Monitors data transfer processes. Resolves data conflicts & inappropriate use of data. Provides ETL & data warehouse support. See the attached position description for more details regarding this position.

Requirements

• 36 mos. combined work experience in any combination of the following: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration 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; 18 mos. combined work experience in any combination of the following: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration 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; 12 mos. combined work experience in any combination of the following: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration 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.
• Strong knowledge of RDBMS tools such as MS SQL Server and schemaless/no-SQL solutions is required.
• Solid understanding of agency business processes
• Strong organizational, problem-solving, and communication skills.

Nice To Haves

• Experience with cloud solutions such as Snowflake and Azure Data Factory
• Experience with MS Power BI
• Experience writing platform specific code (Python, SQL, Java, Dax)
• Ability to provide own transportation &/or legally operate a state-owned vehicle

Responsibilities

• Design and implement processes for the efficient transfer of (ETL/ELT) between systems within and outside the agency
• Design and develop dashboards, summaries and visualizations using agency data and solutions such as MS Power BI
• Assist with data model designs and physical data model implementations
• Assist with the development and maintenance of OIC’s data warehouse using cloud solutions such as Snowflake and Azure Data Factory
• Collaborate with systems administrators to set table access security
• Provide some data governance
• Write platform specific code for data migrations and visualizations (Python, SQL, Java, Dax)
• Monitor cloud and on-premise databases and stores utilizing logs, load test results, and performance monitoring tools
• Advise & consult with users on accessing various databases & to resolve data conflicts & inappropriate use of data
• Resolve Tier I issues
• Promote system security & awareness by adhering to the Agency’s &/or State’s IT security policy(s) & standards
• Provide performance tuning for query language statements
• Read & interpret query plans
• Provide monitoring using vendor supplied & 3rd party utilities
• Restore from disaster recovery plan
• Monitor disaster recovery plan
• Set security & validate all updates through database connections
• Collaborate with system administrator to set table access security
• Assist with data model design
• Implement physical data models
• Assist with tuning a single RBMS system on a single platform
• Assist with writing platform specific code
• Design & implement processes for the efficient transfer of data (ETL/ELT)
• Monitor data transfer processes
• Resolve data conflicts & inappropriate use of data
• Provide ETL & data warehouse support

Benefits

• 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 )

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: Associate degree