Senior database administrator | Warren, PA

Detailed Information

  • Location: Warren, PA

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 backssing 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 Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The 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)For more details: jobs-search. org/architecture-construction_warren-c445897/senior-database-administrator-warren_i1971851297

View Jobs by Category >>

Related Jobs