Sr Database Admin - Financial Crimes
: Job Details :

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 environmentSupport, 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 plusExperience with SSIS to develop ETL solutions with a strong understanding of good schema design practices preferredExperience supporting and optimizing data access for large volume reportingStrong analytical and problem solving skills/background, consistently strong work ethic, independent initiative, and interpersonal skills.Strong project management and time management skillsExcellent knowledge of MIS applicationsExpert oral and written communication skillsExhibits excellent teaching and training skillsExcellent understanding of banking data and/or bank operations business processes is a plusStrong 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.**Equal Opportunity Employer/Protected Veterans/Individuals with DisabilitiesThe contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)