What are the responsibilities and job description for the Sr Database Admin - Financial Crimes position at MidFirst Bank - Default?
The Sr. Database Admin will be responsible for the definition, creation, and maintenance of database architecture and ETL processes to support the Bank’s Financial Crimes department. Analyzes, tests, and implements physical database design. Ensures data recovery, maintenance, data integrity, and space requirements for the physical database are met. Above all, 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.
This position will become familiar with Anti Money Laundering (AML)/Fraud systems; and become a subject matter expert in regards to their data usage, workflow, and documentation in order to facilitate supporting their functionality and daily operation. This will include sharing on-call responsibilities to support nightly application data processing tasks.
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
- Support, maintain, and troubleshoot issues impacting data required by AML/Fraud systems;
- 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.);
- Maintain stable production and development environments; keep systems at current release and maintenance patch levels; install supporting products; resolve security vulnerabilities;
- 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 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 preferred
- 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
- Excellent knowledge of MIS applications
- 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
- Strong understanding of, or the ability to quickly gain such, of applicable laws, regulations, and guidance in the subject area as well as the desire to keep up with changes in a complex environment
**This position is on-site at our corporate campus in north Oklahoma City, therefore, you must to reside in this area in order to be considered for this opening.**
