Sr. Database Administrator

Firstrust
Horsham, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Horsham, United States of America

Tech stack

Databases
Computer Terminals
Database Design
Monitoring of Systems
Microsoft SQL Server
Online Transaction Processing
Performance Tuning
Query Optimization
Standard Sql
SQL Stored Procedures
SQL Databases
Database Optimization
Code Restructuring

Job description

This role is responsible for ensuring the performance, reliability, security, and availability of SQL Server databases that support customer-facing applications and internal systems. The ideal candidate is both technically strong and operationally focused, with the ability to collaborate closely with application developers, data engineers, and infrastructure teams in fast-paced environments.

This position plays a key role in performance tuning, troubleshooting, database design guidance, and ongoing administration across high-volume OLTP systems., * Administer and maintain SQL Server databases across development, test, and production environments

  • Monitor database health, performance, and availability; proactively identify and resolve issues
  • Lead performance tuning and optimization efforts, including:
  • Query tuning and execution plan analysis
  • Index management and optimization
  • Stored procedure review and refactoring
  • Partner with application developers to:
  • Review SQL code for efficiency and scalability
  • Assist with database design, schema changes, and data modeling decisions
  • Support high transaction OLTP systems in e commerce and financial, environments
  • Implement and manage backup, restore, and recovery strategies

  • Troubleshoot complex production issues using native and third-party monitoring tools

  • Participate in production support and on call rotations as required

  • Assist help desk and support teams with SQL- and database related issues

  • Contribute to database standards, documentation, and best practices

  • Participate in capacity planning, performance forecasting, and continuous improvement initiatives, * Assists in the development of new business for Firstrust. Is alert to expressed customer/prospect needs to suggest appropriate services. Directs customers to appropriate person to establish business relationships.

  • Other duties as assigned.

PHYSICAL AND SENSORY REQUIREMENTS:

  • Prolonged periods sitting at a desk and working on a computer.
  • Regularly required to drive a motor vehicle, occasional air travel, attending meetings at various venues, including but not limited to customers' offices and/or properties, restaurants and other meeting locations, and ascend/descend stairs and or ladders occasionally to perform inspections.
  • The employee may be required to lift files/materials up to 20 pounds to take to various locations.
  • The incumbent will be expected to operate a computer terminal.
  • Prolonged periods sitting at a desk and working on a computer

Requirements

  • 5-10 years of handson experienceadministering Microsoft SQL Server (2012 or newer)
  • Strong experience supporting highvolume, highly transactional OLTP environments
  • Deep understanding of:
  • Database architecture and relational design principles
  • Indexing strategies and execution plans

About the company

FIRSTRUST BANKRecognizes the leader in you As one of the region's foremost community banking institutions, we take pride in fostering leadership. As a Firstrust employee, your growth is our growth. For you, that means great benefits, performance-based pay, a meaningful role, and resources to help your success. For us, that means employees who offer exemplary customer service with a commitment to our values - honesty, integrity and accountability.

Apply for this position