Apply on Employer Site

First Federal Bank · 7 hours ago

Database Administrator

United States

Full-time

Remote

Senior Level

5+ years exp

First Federal Bank is committed to community and customer service, offering a remote work opportunity for a Database Administrator. The role involves administering and optimizing databases, implementing high availability and disaster recovery solutions, and collaborating with various teams to ensure efficient database solutions.

BankingFinancial Services

Responsibilities

Administer, configure, patch, and optimize MS SQL Server (2016-2022) and IBM DB2 (11.x-12.x)

Implement and maintain high availability (HA) and disaster recovery (DR) solutions

Monitor performance and proactively resolve database issues and bottlenecks

Develop, test, and maintain database backup and recovery strategies

Design and maintain advanced PowerShell scripts to automate monitoring, maintenance, and routine DBA tasks

Write, review, and optimize complex SQL queries, stored procedures, trigger, and functions

Contribute to roadmap and support adoption of cloud-based technologies such as Azure SQL DB and Managed Instance

Provide input and support for future data warehouse administration and integration on platforms such as Fabric or Snowflake

Enforce database security standards, encryption, and best practices

Perform regular audits and ensure compliance with industry regulations

Assist with periodic, internal and external audit activities

Partner with Vendors, Analysts, and Application Support team to design, and/or implement efficient database solutions

Contribute to data governance, data quality monitoring, documentation, and best practices

Share knowledge across Data Analytics and Application Support teams

Ability to work non-business and on-call hours as needed

Log all project work, change management tasks, and support interactions in the ticketing system and provide assurance that resolutions are completed timely to meet current SLAs

Provides the best service to our customers with innovative and creative solutions

Qualification

MS SQL ServerIBM DB2PowerShellCloud technologiesData warehouse designETLData replicationCommunication skillsProblem-solvingTeam collaboration

Required

Minimum 5 to 7 years of related professional experience in a role primarily focused on database administration and/or Associates, Bachelors or Technical Institute certificate/degree in Computer Science, Information Systems or related field

Ability to work independently and take initiative; demonstrated ability to identify and troubleshoot complex problems and see them through to resolution

Must have an established understanding of database technologies, high availability, disaster recovery, replication, virtualization technologies, storage technologies, server operating systems, reporting application systems and related best practices

Must have solid technical skills and experience with a variety software packages and hardware involved in enterprise database and analytics delivery operations

Must have an aptitude for troubleshooting, analyzing, and diagnosing problems

Strong oral and written communication skills and decision-making ability

An ability to deal with a wide variety of customers and provide empathy while listening to and understanding inquiries about issues, then explain corrective procedures to technical and non-technical end-users

Ability to handle changing priorities and make valuable contributions to team objectives

Ability to seek continuous improvement and efficiency across all areas of responsibility

Eagerness to learn and become a subject matter expert in databases, ETL and analytics platforms

Have a thorough understanding of RTO/RPO and BCP

Ability to work non-business hours and on-call hours as needed

Must interact professionally with other employees, customers and suppliers

Extended hours sitting and performing computer tasks may be required

Ability to complete complex projects with minimum to no supervision

PowerShell and process automation

Experience using dbatools PowerShell modules

Knowledge of data warehouse design and implementation best practices, specifically the Kimball methodology

Experience with Cognos and/or SSRS