(2) Database Administration Specialist 2

9 hours ago

Columbus, United States Ohio Department of Commerce Full time
What You'll Be Doing:

Under direction of the Database Manager & Senior Level Team Members, you would be conducting performance tuning & configuration, creating data models & providing Tier II database support:
  • Providing Oracle Relational Database Management System (RDBMS) subject matter expertise in SQL Server & intermediate knowledge of Oracle.
  • Providing Production On-Call support for the RDBMS backend repositories of critical applications such as CoreSuite, External & Internal WEB Applications.
  • Administering RDBMS using DBA tools (e.g., native Microsoft & Oracle Products, Idera Data Management Software, & TOAD Products).
  • Using knowledge of Data Warehouse integration processes to support the current Snowflake Business Intelligence & Data Analytics Environment.
  • Using database administration skills to conduct performance tuning & configuration & provides technical support to application development teams, enforces security database object standards, troubleshooting database problems.
  • Participating in BWC's Change Review Board.
  • Performing data migrations & business process monitoring.
  • Resolving problems & issues (e.g. support ticket resolution, application performance problems, backup & restores.
  • Researching product enhancements & capabilities.
  • Staying current with emerging technologies.
  • Implementing documentation of installation & monitoring procedures, security policies, configuration changes, migration procedures & best practices.
For more information, please click here . The job responsibilities for both positions are identical. Applicants need to submit only one application to be considered for both roles.

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 full-time and part-time employees*. For a list of all the State of Ohio Benefits, visit our Total 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.

Qualifications

To Qualify, You Must Clearly Demonstrate:

  • 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 primar y technology (Database Support- Microsoft SQL Server RDBMS) specified by the agency in the position description & job posting.
  • Or completion of associate core program in computer science or information systems AND 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 (Database Support- Microsoft SQL Server RDBMS) specified by the agency in the position description & job posting.
  • Or completion of undergraduate core program in computer science or information systems AND 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 (Database Support- Microsoft SQL Server RDBMS) 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 (Database Support- Microsoft SQL Server RDBMS) directly relating to the duties of the position. Only those applicants possessing the experience in the required, primary technology (Database Support- Microsoft SQL Server RDBMS) 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, Information Technology

    Professional Skills: Attention to Detail, Customer Focus, Decision Making, Problem Solving, Interpreting Data

    Primary Technology: (Database Support- Microsoft SQL Server RDBMS)


Major Worker Characteristics

Knowledge of: oral & written communication tools & techniques, customer support & personal service, technical writing & documentation practices, technology design, mathematic principles relative to assigned area in IT, IT principles, methods & practices in assigned specialty area, state & Ohio Bureau of Workers' Compensation (BWC) policy, procedures & applicable laws*, vision, mission & goals of BWC*, systems performance management, IT lifecycle concepts, Database Administration Tools (e.g., Microsoft SQL Server RDBMS Tools, Idera Data Management Software, Oracle Relational Database Management System (RDBMS), Oracle Enterprise Manager (OEM), TOAD database tool), Snowflake, project management principles & methods, develop system specific specifications, back-up & recovery procedures, interrelationships of multiple IT specialties, database management principles & methodologies for data modeling, CLOUD SMART

Skill in: reading comprehension, speaking, service orientation, troubleshooting, critical thinking, using data recovery tools & techniques, complex problem solving, judgment & decision making, assuring quality, identifying & specifying business requirements, lead work, & database analysis & evaluation.

Ability to: prepare meaningful, accurate & concise reports, stay abreast of current technologies in area of IT assigned provide expert technical advice, guidance, & recommendations to management & other technical specialists on critical IT issues, & define problems, collect data, establish facts & draw valid conclusions. (*) developed after employment.

  • Senior Data Warehouse Specialist

    4 weeks ago

    Columbus, United States Ohio Department of Commerce Full time

    This is a repost. If you have previously applied for this role, please note that you will need to submit a new application to be considered. What You'll Be Doing: Under direction of the Database Warehouse Administration Manager, Conducting performance tuning & configuration. Creating data models. Performing data analysis & providing technical Tier II...

  • Administrative Support Specialist 2

    4 weeks ago

    Columbus, Ohio, United States Ohio Department of Developmental Disabilities Full time

    Position Title: Administrative Professional 2 Department: Public Safety Compensation: $21.97 per hour Work Schedule: Full-time, 8:00 am to 5:00 pm Classification: Classified Union Affiliation: OCSEA Role Overview: As an Administrative Professional 2, you will play a crucial role in supporting the operational functions of the department. Your responsibilities...

  • Administrative Professional 2

    3 weeks ago

    Columbus, United States Ohio Department of Commerce Full time

    The Administrative Professional 2 is a key role at the Commission. In this position, you will be responsible for: Answering telephones, taking messages, referring calls, greeting visitors, and receiving and processing mail. Responding to questions from the general public and other government agencies by telephone, letter, or in person, such as explaining...

  • Database Administrator

    4 days ago

    Columbus, Ohio, United States JPMorganChase Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at JPMorgan Chase. As a key member of our Employee Platforms team, you will be responsible for the configuration, maintenance, and performance tuning of both SQL and NoSQL database systems, with a primary focus on Oracle and PostgreSQL.Key...

  • Utility Specialist 2

    1 week ago

    Columbus, Ohio, United States Ohio Department of Developmental Disabilities Full time

    Job Title: Utility Specialist 2 **Job Summary:** We are seeking a highly skilled Utility Specialist 2 to join our team at the Ohio Department of Developmental Disabilities. As a key member of our organization, you will be responsible for ensuring the efficient and effective delivery of utility services to our clients. **Key Responsibilities:** * Conduct...

  • Database Management Expert

    2 weeks ago

    Columbus, Ohio, United States Ohio Department of Developmental Disabilities Full time

    Job SummaryThe Ohio Department of Developmental Disabilities is seeking a skilled Database Administration Specialist 2 to join our team. As a key member of our organization, you will be responsible for ensuring the integrity and security of our database systems.Key ResponsibilitiesDesign, implement, and maintain database systems to support business...

  • Executive Administrative Assistant 2

    4 weeks ago

    Columbus, Ohio, United States Ohio Department of Developmental Disabilities Full time

    Position Title: Administrative Professional 2 Department: Public Safety Compensation: $21.97 per hour Work Schedule: Full-time, 8:00 am to 5:00 pm Classification: Classified Union Affiliation: OCSEA Role Overview: The Administrative Professional 2 plays a crucial role in supporting the operational functions of the department. This position involves a variety...

  • Azure Database Administrator

    2 weeks ago

    Columbus, Ohio, United States Ohio Department of Developmental Disabilities Full time

    About the RoleWe are seeking a highly skilled Cloud Infrastructure Specialist to join our team at the Ohio Department of Public Safety. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining cloud-based infrastructure solutions to support our mission-critical applications.Key ResponsibilitiesCollaborate...

  • Database Administrator

    1 week ago

    Columbus, Ohio, United States JPMorganChase Full time

    Job OverviewWe are seeking a highly skilled Database Administrator to join our Employee Platforms team at JPMorgan Chase. As a key member of our team, you will be responsible for the configuration, maintenance, and performance tuning of both SQL and NoSQL database systems, with a primary focus on Oracle and PostgreSQL.This is an exciting opportunity to take...

  • Grants Administration Analyst 2

    3 weeks ago

    Columbus, Ohio, United States The Ohio State University Full time

    Position Title:Grants and Contracts Management Analyst 2Department Overview:Public Health | College AdministrationThe Ohio State University is pleased to present a flexible employment opportunity for the role of Grants and Contracts Management Analyst 2. This position is essential in supporting faculty members with the oversight of pre-award and post-award...

  • GIMS Specialist 2 Hybrid Eligible Position

    1 week ago

    Columbus, Ohio, United States Ohio Department of Developmental Disabilities Full time

    About the RoleWe are seeking a highly skilled GIMS Specialist 2 to join our team at the Ohio Department of Public Safety. As a key member of our team, you will be responsible for conducting complex analysis of multiple Ohio State Highway Patrol (OSHP) Geographic Information Systems (GIS) databases.Key ResponsibilitiesConduct complex analysis of multiple OSHP...

  • Geographic Information Systems Specialist 2

    2 weeks ago

    Columbus, Ohio, United States Ohio Department of Developmental Disabilities Full time

    About the RoleWe are seeking a highly skilled GIMS Specialist 2 Hybrid Eligible to join our team at the Ohio Department of Public Safety. As a key member of our Geographic Information Systems (GIS) team, you will play a critical role in analyzing and interpreting complex data to inform decision-making and drive business outcomes.Key ResponsibilitiesConduct...

  • IMS Database Administrator

    4 days ago

    Columbus, Ohio, United States Tekgence Inc Full time

    Job Title: IMS DB AdminLocation: Plano, TX or Columbus, OH (Onsite)Duration: Long termJob Requirements:We are seeking an experienced IBM IMS DB Administrator to join our team at Tekgence Inc. The successful candidate will be responsible for administering and maintaining the IMS database, ensuring high availability and performance.Key...

  • Inventory Management Specialist 2

    3 weeks ago

    Columbus, Ohio, United States Ohio Department of Developmental Disabilities Full time

    Position Title: Inventory Control Specialist 2 Department: Public Safety Job Overview: The Inventory Control Specialist 2 plays a crucial role in maintaining accurate inventory records and ensuring efficient stock management within the organization. This position requires a keen attention to detail and a strong focus on customer service. Key...

  • Utility Specialist 2

    2 days ago

    Columbus, Ohio, United States Ohio Department of Developmental Disabilities Full time

    Job SummaryWe are seeking a highly skilled Utility Specialist 2 to join our team at the Ohio Department of Developmental Disabilities.Key ResponsibilitiesEnsure compliance with regulatory requirements and industry standards.Conduct inspections and audits to identify areas for improvement.Investigate and enforce compliance with utility regulations.Organize...

  • DB2 Database Administrator

    3 days ago

    Columbus, Ohio, United States Worldpay Full time

    About the RoleWe are seeking a highly skilled DB2 Database Administrator to join our team in Cincinnati, Ohio. As a key member of our Database team, you will be responsible for designing, developing, and administering large-scale OLTP and analytical data structures.Key ResponsibilitiesOptimize Db2 resource utilization by tuning queries, recommending indexes,...

  • SQL Database Administrator

    4 weeks ago

    Columbus, United States Saxon Global Full time

    **Candidates must be located within a commutable distance of the central Ohio area. ***This is a contract-to-hire opportunity and will convert to a full-time position within 3-6 months. Our client is looking for a mid to senior-level SQL DBA to join their technical team, assisting the Senior DBA with all responsibilities that include but are not limited...

  • Administrative Assistant 2

    1 week ago

    Columbus, United States STRS Ohio Full time

    STRS Ohio, STRS The State Teachers Retirement System of Ohio (STRS Ohio) is seeking an Administrative Assistant 2, Investments Management. Established in 1920 and serving Ohio's educators, STRS Ohio is one of the nation's largest retirement systems, serving over 500,000 active, inactive, and retired public-school teachers, and university faculty members,...

  • SQL Database Administrator

    4 days ago

    Columbus, United States Saxon Global Full time

    **Candidates must be located within a commutable distance of the central Ohio area. ***This is a contract-to-hire opportunity and will convert to a full-time position within 3-6 months. Our client is looking for a mid to senior-level SQL DBA to join their technical team, assisting the Senior DBA with all responsibilities that include but are not limited to: ...

  • Activity Therapy Specialist 2

    1 week ago

    Columbus, Ohio, United States Ohio Department of Developmental Disabilities Full time

    Job Title: Activity Therapy Specialist 2We are seeking a highly skilled Activity Therapy Specialist 2 to join our team at the Ohio Department of Mental Health and Addiction Services. As a key member of our interdisciplinary treatment team, you will be responsible for planning, organizing, and facilitating a comprehensive program of recreational, art, or...