Database Administrator II

First Financial Bank; Cincinnati (OH); On-site; USD 74,000 - 100,000; Full time

Job summary

First Financial Bank is seeking a Database Administrator II in Cincinnati to support and enhance SQL Server, Azure data platforms, and related data environments. You will work with teams across the organization to deliver reliable, secure, and scalable data solutions, including ETL, reporting, and production support.

The role emphasizes performance tuning, automation, and cloud modernization efforts while maintaining compliance and security standards.

Qualifications

• 3+ years in database administration or related field, with at least 2 years in Microsoft SQL Server.
• Advanced proficiency with T-SQL, database object development, query optimization, and indexing.
• Experience administering SQL Server environments, including security, backup/restore, and maintenance.
• Ability to translate business requirements into database, reporting, and data integration solutions.
• Familiarity with SOX, security, change management, and data governance practices.

Responsibilities

• Administer and support Microsoft SQL Server including configuration, maintenance, patching, monitoring, capacity management, and troubleshooting.
• Develop, test, and maintain SQL queries and database objects (tables, views, procedures, functions, indexes, triggers).
• Monitor and tune performance by reviewing execution plans and resolving blocking or deadlocks.
• Develop, deploy, monitor, and troubleshoot SSIS, SSRS, ETL processes, and data integration solutions.
• Provide production and on-call support; document security, operations, and recovery procedures.

Skills

T-SQL

SQL Server

Performance tuning

Data modeling

Problem solving

Communication

Documentation

SOX/compliance awareness

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Server

SSIS

SSRS

PowerShell

SQL Server Agent

Azure Data Factory

Azure SQL

Power BI

Job description

We do the right things, right now. We do them in a way that is relevant to our clients. Become a part of our history as it continues to be written!

The Database Administrator II supports and enhances the organization’s database, reporting, and data integration environments. This role combines database administration with hands-on development, including SQL, ETL, reporting, performance tuning, automation, and production support. The position works with database administrators, solution architects, developers, infrastructure teams, and business partners to deliver reliable, secure, and scalable solutions across Microsoft SQL Server, Azure, and related data platforms.

Essential Functions/Responsibilities

• Administer and support Microsoft SQL Server including configuration, maintenance, patching, monitoring, capacity management, and troubleshooting.
• Develop, test, and maintain SQL queries and database objects, including tables, views, stored procedures, functions, indexes, triggers, and scheduled jobs.
• Monitor and tune database performance by reviewing execution plans and resolving blocking, deadlocks, failed jobs, inefficient queries, storage issues, and connectivity problems.
• Develop, deploy, monitor, and troubleshoot SSIS packages, SSRS reports, ETL processes, and related data integration solutions.
• Support operational databases, reporting platforms, data warehouses, dimensional models, and data workflows by translating business and technical requirements into working solutions.
• Perform backups, restores, point-in-time recovery, backup validation, and routine recovery testing.
• Administer database users, roles, permissions, and access controls; maintain documentation and audit evidence supporting security, SOX, and other compliance requirements.
• Automate database monitoring, maintenance, deployment, and support activities using T-SQL, PowerShell, SQL Server Agent, or comparable tools.
• Participate in database design, code reviews, testing, release management, production deployments, legacy migrations, and cloud modernization initiatives.
• Provide production and on-call support, collaborate across technical and business teams, and maintain technical, operational, and recovery documentation.
• Follow established database, security, change management, and operational standards while identifying opportunities to improve reliability, scalability, performance, and efficiency.
• Partner with lines of business and technical teams to gather and clarify requirements, evaluate solution options, and design, develop, test, and implement database, reporting, and data integration solutions.

Minimum Knowledge, Skills, and Abilities Needed to Perform Essential Functions of the Job

• Three or more years of experience in database administration, database development, data integration, or a related area, including at least two years of recent Microsoft SQL Server experience.
• Advanced proficiency with T-SQL, database object development, query optimization, transactions, indexing, and relational database design.
• Experience administering SQL Server environments, including monitoring, security, backup, restore, recovery, maintenance, and troubleshooting.
• Ability to troubleshoot performance, availability, data, job, storage, and connectivity issues.
• Experience with database security, user access, source control, release management, change management, and software development lifecycle practices.
• Understanding of normalization, referential integrity, dimensional modeling, and logical and physical data design.
• Ability to translate business and technical requirements into database, reporting, and integration solutions.
• Strong analytical, documentation, communication, prioritization, and collaboration skills.
• Associate’s or bachelor’s degree in Computer Science, Information Technology, Software Engineering, Data Management, or a related field, or equivalent professional experience.

Preferred Knowledge and Skills

• Experience with Azure SQL, Azure SQL Managed Instance, Microsoft Fabric, Snowflake, Power BI, Azure Data Factory, or other cloud data platforms.
• Working knowledge of SQL Server high-availability and disaster-recovery technologies, including Windows Server Failover Clustering, Always On Availability Groups, log shipping, replication, or comparable solutions.
• Experience with hybrid environments, cloud migrations, data warehousing, dimensional modeling, or database modernization.
• Experience in financial services or another regulated industry, including familiarity with SOX, audit, data privacy, and security requirements.

Level of Complexity and Scope

Performs routine and moderately complex database administration and development work across multiple applications and environments.

Independently manages defined assignments and escalates architecture, security, recovery, or enterprise-impacting issues.

Degree of Independence and Decision-Making

Works under moderate supervision while applying established guidelines receiving minimal guidance.

Required Supervisory Responsibilities

No direct supervisory responsibilities.

Physical Requirements

• Prolonged periods of deskwork.
• Frequent use of computer, keyboard, phone and office equipment.
• Occasionally lifting and carrying light objects, typically up to 10-15 pounds.
• Occasionally reaching for items on shelves or in drawers.
• Clear and effective communication in person and over the phone.
• Ability to move within an office environment.

Compliance Statement

The associate is responsible for meeting all compliance requirements imposed on First Financial Bank by State and Federal law and regulation, as well as all related First Financial Bank policies and procedures. This includes all Bank Secrecy Act, Anti-Money Laundering, OFAC and Suspicious Activity reporting requirements, as well as all other lending and deposit compliance requirements.

Development and Training

Pay Range: $74,000/year to $100,000/year

Benefits

We have relevant, thoughtful benefits and programs that support every aspect of our associates' holistic wellbeing. Please review our Benefits Guide.

• Incentive Eligibility All roles are incentive eligible with the exception of Co-Op, Intern, or Student positions.
• It is our policy to not discriminate against any individual in violation of federal, state, and local laws as it relates to age, race, color, religion, national origin, sex, marital status, pregnancy, gender identity, disability, sexual orientation, genetic information, veteran/military service, or any other characteristic protected by law.
• We are an E-Verify Employer.

At first financial bank, our mission is clear: to be the best bank to do business with, the best place to work, and the best financial partner for our shareholders and the communities we serve.

We believe that how we work is just as important as what we achieve. That’s why we’re guided by core values that shape everything we do: Doing the right thing Teamwork Mutual respect Wellbeing Excellence

Our success starts with our people. We know that when our associates are talented, engaged, and supported, they create outstanding results. If you're looking to be part of a team that values integrity, inclusion, and collaboration—and where your growth matters—you’ll find your future here.