senior database administrator - Columbus, United States - Penn Foster Inc

Description

The Senior Database Administrator (Sr. DBA) will be part of the Enterprise Data Services team, and is responsible for the Database Engineering and Capacity Management function with a strong focus on database Governance and Security.

The Senior DBA is part of the Database Administration team and is responsible for all functions associated with the physical implementation, operation, and maintenance of database environments.

The successful incumbent will plan, coordinate, administer and maintain databases. Responsible for planning, documentation, operation, security and contingency (business continuity); ensuring database recovery. Formulating and monitoring policies, procedures, and standards related to database management. Analyses, tests, evaluates and implements physical database performance and capacity and tunes the system for efficient performance and integrity. Provides technical guidance and assistance in the development and implementation of database systems.

Provides a high degree of coordination between colleagues, technical staff and application developers to ensure efficient and effective data management that meets both business and regulatory objectives.

Essential Functions
Manage databases (MS SQL Server 2019) in Production/QA/Development environments including installation, configuration, upgrades, schema changes, patches, performance optimization, etc.
Responsible for ensuring design, build and operation for highly available, normalize, performance, secure database platforms, including structure and content
Successfully implement database design, data access, table maintenance, replication and other database issues
Define guidelines and audit systems to ensure security guidelines are maintained; identify and correct complex bugs and problems
Ensure optimal configuration and performance of database(s) and environment; develop and monitor database(s) security in collaboration with the IT Security Team
Develop and monitor appropriate security procedures to safeguard system from physical harm and viruses that may damage data. Provide back-up and recovery procedures as needed for all production and test databases; participate on Q3BCP testing
Perform database security through data encryption solutions to maintain compliance with industry, regulatory and business security standards
Ensure integrity and recovery of databases by designing solutions for and resolving open data environment audit findings; this includes understanding and managing compliance reporting and audits; ensuring solutions, production and fixes are aligned to SOX, FDIC and other regulatory requirements
Develop database architectural strategies at the modeling, design, and implementation stages to address business requirements and system capabilities working with internal constituents and other IT resources internally
Develop, produce, and publish key metrics in collaboration with Chief Data Officer, provide insight and needed system adjustments
Monitor security bulletins to obtain information of potential threats, ensuring database security, integrity, stability and systems availability
Configure, deploy and administer SQL and SQL server tools, including the creation and support Azure database fundamentals, including Azure Data Lake, and data flow; this will include ensuring the Data Lake is compliant with SOX
Work and act a liaison with (3rd Party) on database planning and upgrading the infrastructure; simplify effort and maintenance costs and ensure optimization
Support project teams as needed as new initiatives are planned and rolled-out in the Bank
Develop and maintain documentation of enterprise database topologies, data flows and database configurations
Analyze long-term database performance trends and proactively identify ongoing cost optimization, performance enhancement, and growth strategies
Assist in budget preparation, cost analysis, and long-range planning including proactively assessing needs and providing recommendations
Provide Tier 3 support of databases and support of data build / operations teams

Additional Essential Functions
Ensure compliance with Northwest's policies and procedures, and Federal/State regulations
Navigate Microsoft Office Software, computer applications, and software specific to the department in order to maximize technology tools and gain efficiency
Work as part of a team
Work with on-site equipment

Additional Responsibilities
Complete special projects as assigned
Assist with other IT related special projects as determined by business need

Safety and Health for those without supervisory duties
Abide by the rules of the safety and loss prevention program
Perform work tasks in a safe manner
Report any and all injuries to supervisor
Know what to do in case of an emergency


QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education
Bachelor's Degree Engineering, Programming, Data Sciences or Similar
Must have a DBA Certification from an accredited organization

General Employee Knowledge, Skills, and Abilities
Ability to establish effective working relationships among team members and participate in solving problems and making decisions
Ability to present and express ideas and information clearly and concisely in a manner appropriate to the audience, whether oral or written
Ability to actively listen to what others are saying to achieve understanding, sharing information with others and facilitating the open exchange of ideas and information
Ability to establish courses of action for self to accomplish specific goals, develop and use tracking systems for monitoring own work progress, and effectively use resources such as time and information
Ability to make right decisions based on perceptive and analytical processes, practicing good judgment in gray areas

Additional Knowledge, Skills and Abilities
Must be able to establish Data environment configurations, controls, policies and guidelines which are aligned to best practice framework
Must have a DBA certification and performed the primary functions as a DBA
Has the ability to communicate effectively verbally and in writing with IT team members
Demonstrates leadership at a team or project level

Licenses and Certifications
MCDBA, ADO, DB2 12, MCADF (Any one of) Upon Hire
Database Administration Certification

Qualifications
Skills
Behaviors
:

Motivations
:

Education
Experience
Licenses & Certifications

#J-18808-Ljbffr