Sr Database Admin

Company: MidFirst Bank
Location: Oklahoma City
Posted on: June 23, 2022

Job Description:

Has primary responsibility for the definition, creation, and maintenance of the enterprise data model as well as the support of existing database object development and new database object development, to include TSQL coding for views and stored procedures and the use of SSIS for data ETL. Analyzes, tests, and implements physical database design supporting various business applications (including base definition, structure, documentation, long-range requirements, and operational guidelines). Ensures data recovery, maintenance, data integrity, and space requirements for physical database are met through formulations and monitoring of policies, procedures, and standards relating to database management. Provides a high degree of coordination between user, technical, application, and corporate entities to ensure effective data management as a corporate enterprise. Above all, ensures solutions meet business objectives and establishes and maintains a high level of user trust and confidence in IT's knowledge of and concern for users' business needs. Has a willingness to work with customers of varying levels of technical expertise in a high-pressure, complex environment.

• Candidate needs to be familiar with TSQL and SSIS (or similar ETL tool)
• Candidate will spend time working directly with the Data Governance team to assist in the documentation of data lineage and creation of an enterprise-wide data dictionary, as well as generate scripts/processes to automate the finding and upkeep of this information. Prior experience with creating/maintain a data dictionary or other lineage documentation would be beneficial but not required.Bachelors degree in Computer Science, Engineering, or related discipline; equivalent experience acceptable. At least four years of in-depth experience in the design, administration, programming, and support of RDBMSs/MDDBMSs (e.g., Microsoft SQL Server, Oracle) in one or more computing environments (e.g., Windows, Unix) Four to Six years of experience as a DBA in one or more environments is highly desirable (preferably with RDBMSs) or strong, demonstrated DBA skills earned in equivalent experience. Thorough understanding of the relational database model and solid theoretical knowledge of relational database techniques. Experience in designing, modeling, developing, and supporting large RDBMSs. Extensive experience in logical and physical database design, hands-on data modeling techniques, and development methodology; physical schema design of table spaces, rollback segments, and data files. Experience in using TSQL and SSIS for data integration and ETL. Excellent oral and written communications skills.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)

Keywords: MidFirst Bank, Oklahoma City , Sr Database Admin, IT / Software / Systems , Oklahoma City, Oklahoma