Database Administrator IV
First Financial Bank · Cincinnati, OH · 1 wk ago
Information Technology$107k–$143k/yrFull-time
About the role
Database Administrators maintain and provide technical support for the database and reporting environment.
Essential Functions/Responsibilities
- Provide technical leadership for enterprise database and reporting platforms, leading strategy, solution design, and alignment with business objectives.
- Collaborate with developers, IT teams, business partners, vendors, and consultants to support enterprise initiatives and evaluate new technologies.
- Design, implement, and manage Microsoft SQL Server and Azure database environments, including installation, configuration, patching, and performance tuning.
- Develop and maintain database security, auditing, backup/recovery, and disaster recovery strategies and procedures.
- Monitor database operations, performance, ETL processes, and capacity; implement tools and processes to optimize reliability and efficiency.
- Support Solution Architects in the design and implementation of enterprise reporting and data warehouse solutions, including data models, dimensional structures, and ETL processes.
- Develop transaction processing and capacity models to support performance management initiatives.
- Support migration of legacy database systems to enterprise standards and modern platforms.
- Provide Tier 3 technical support for database and reporting environments, including participation in a 24/7 on-call rotation.
- Perform SQL code reviews and support release management processes (e.g., Azure DevOps/TFS).
- Execute testing, debugging, and performance tuning procedures; collaborate cross-functionally to resolve system defects.
- Lead and participate in Agile/Scrum activities, including stand-ups and sprint planning.
- Serve as a subject matter expert for database technologies across application development initiatives.
- Partner with leadership to manage workload, prioritize tasks, and meet deadlines and business expectations.
- Train, mentor, and develop DBA staff and other IT team members, including cross-training for backup support.
- Develop, document, and enforce database policies, standards, and operational procedures.
- Support enterprise change management processes and ensure compliance with established standards.
- Identify process improvement opportunities and implement solutions to enhance performance, scalability, and reliability.
- Maintain database access controls, activity logs, and audit documentation to support SOX compliance and internal/external audits.
- Partner with internal audit teams to provide evidence, implement database controls, and support remediation activities in accordance with SOX requirements.
- Other duties as assigned.
Minimum Knowledge, Skills, and Abilities
- 10+ years IT experience
- 7+ years of recent MS SQL Server DBA experience
- Advanced SQL Server Reporting Services (SSRS) experience
- Advanced SQL Server Integration Services (SSIS) experience
- Associate's or Bachelor's degree in Computer Science, Software Engineering, or a related field, or equivalent work experience.
Preferred Knowledge and Skills
- Experience with modern cloud data platforms such as Snowflake or Microsoft Fabric.
- Knowledge of cloud database modernization initiatives, including architecture, performance optimization, security, and operational best practices in cloud environments.
- Prior experience supporting or leading migrations from on-premises database environments to cloud-based platforms.
- Familiarity with hybrid database environments and transition strategies between traditional infrastructure and cloud-native solutions.
- Exposure to data warehousing, ETL/ELT modernization, and cloud-based data integration tools.
Level of Complexity and Scope
Expert, architect-level skills and responsibilities.
Degree of Independence and Decision-Making
- Works with minimal supervision.
- Guides and advises other team members as subject matter expert.
Required Supervisory Responsibilities
May act as Team Lead.
Physical Requirements
Operates a computer most of the day.
Pay
$107,000/year to $142,760/year.
Benefits
We have relevant, thoughtful benefits and programs that support every aspect of our associates' holistic wellbeing. Please review our Benefits Guide.