Sr Database Admin

MidFirst Bank; Oklahoma City (OK); On-site; USD 80,000 - 100,000; Full time

Job summary

MidFirst Bank is looking for a Database Administrator responsible for defining, creating, and maintaining database architecture and ETL processes using T-SQL and SSIS. In this role, you will manage a Data Warehouse supporting various business applications and ensure data integrity and recovery.

The ideal candidate will have a minimum of 5 years experience in System Analysis and Database Administration, with proficiency in T-SQL programming and SSIS. Strong analytical and project management skills are essential.

Qualifications

• 5 years experience in System Analysis, Design, Development and Database Administration of MS SQL Server.
• Strong experience with SSIS for ETL development.
• Demonstrated ability in managing SQL Data Warehouses.

Responsibilities

• Define, create, and maintain database architecture and ETL processes.
• Analyze, test, and implement physical database design.
• Closely monitor database performance and resolve issues.

Skills

T-SQL programming

Database Administration

SSIS

Data Warehouse management

Problem-solving

Project management

Oral and written communication

Job description

Description

Primarily responsible for the definition, creation, and maintenance of database architecture and ETL processes using TSQL coding and SSIS. Analyzes, tests, and implements physical database design supporting various business applications. Experience in creating and managing a Data Warehouse to be used for end‑user reporting. Ensures data recovery, maintenance, data integrity, and space requirements for the physical database are met through formulation and monitoring of policies, procedures, and standards relating to database management. Above all, ensures data management processes meet business objectives and establishes and maintains a high level of user trust and confidence in the individual's knowledge of and concern for users' business needs.

Principal duties and responsibilities

• Obtain an in-depth understanding of the data requirements and business needs;
• Research and recommend optimal design criteria; publish standards and work with analysts/development staff to build and maintain an efficient and standardized environment;
• Resolve problems and answer questions related to data handling processes; contact vendor support when necessary; implement additional error handling; facilitate database changes and client problem resolution with optimum speed and efficiency;
• Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency;
• Monitor file system space, database allocation, etc.; verify efficient use of disk storage; reclaim dead space; optimize space allocation and avoid out-of-space conditions;
• Automate procedures at regular intervals; use tools to reorganize or defragment database table spaces, tables, and indexes; provide efficient database environment to maximize productivity and improve performance;
• Create and maintain technical documentation (including, but not limited to, ETL process, ERD, etc.);

Other duties and tasks as assigned.

Position Requirements

• 5 years experience in System Analysis, Design, Development and Database Administration of MS SQL Server. Strong T-SQL programming skills are a must.
• Experience in creating and maintaining a SQL Data Warehouse.
• Experience working as a DBA in MS SQL server 2016 or newer in Production and Development environments as well as experience in upgrading SQL Server. Experience with other RDBMS solutions is a plus.
• Experience with SSIS to develop ETL solutions with a strong understanding of good schema design practices;
• Experience supporting and optimizing data access for large volume reporting.
• Strong analytical and problem solving skills/background, consistently strong work ethic, independent initiative, and interpersonal skills.
• Strong project management and time management skills.
• Expert oral and written communication skills.
• Exhibits excellent teaching and training skills.
• Excellent understanding of banking data and/or bank operations business processes is a plus.

* Must reside within the market area to be considered.

* Position requires a minimum of 3 years of relevant US based experience.

#LI-DNI

Qualifications

Experience

5 - 8 years: 5 years experience in System Analysis, Design, Development and Database Administration of MS SQL Server. Strong T‑SQL programming skills are a must. (required)

Equal Opportunity Employer / Protected Veterans / Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.