Sr Database Admin

MidFirst Bank•Oklahoma City, OK

13d

About The Position

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.

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 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
Must reside within the market area to be considered.
Position requires a minimum of 3 years of relevant US based experience.

Nice To Haves

Experience with other RDBMS solutions is a plus.
Exhibits excellent teaching and training skills
Excellent understanding of banking data and/or bank operations business processes is a plus

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.