Job Description

FIRSTRUST BANK
RECOGNIZES 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.

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.

JOB DUTIES AND RESPONSIBILITIES:

• 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

OTHER JOB DUTIES AND RESPONSIBILITIES:
• 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

POTENITAL ON-THE-JOB-RISKS:
• None identified.

EDUCATION, TRAINING AND EXPERIENCE:
• 5-10 years of hands on experience administering Microsoft SQL Server (2012 or newer)
• Strong experience supporting high volume, highly transactional OLTP environments
• Deep understanding of:
◦ Database architecture and relational design principles
◦ Indexing strategies and execution plans

WORK SCHEDULE:
• Hybrid Schedule

Firstrust Bank provides equal employment opportunity without regard to race, color, creed, sex (including pregnancy), age, gender, (including gender nonconformity and status as a transgender or transsexual individual), physical or mental disability, religion, national origin, genetics, marital status, veteran’s status, ancestry, citizenship, sexual orientation, or other characteristics protected by applicable law. This policy applies to all areas of employment, including, without limitation, recruitment, hiring, training and development, promotion, transfer, termination, compensation, benefits, and all other conditions and privileges of employment in accordance with applicable federal, state and local laws.

Firstrust Bank is an Equal Opportunity Employer.

If you have a disability and need an accommodation to complete the application process, please email Firstrust Bank Human Resources Department HResources@firstrust.com. Include your full name, best way to reach you, and the accommodation needed to assist with the application process.

Firstrust provides reasonable accommodations so that disabled individuals may participate in the application and selection process. Please state your reasonable accommodation request for assistance in your message.

Only reasonable accommodation requests related to applying for a specific position within Firstrust will be reviewed at the email address and phone number supplied.

Please advise Firstrust of any accommodation you require to express an interest in a specific opening by emailing or calling: reasonableaccomdations@firstrust.com or 215-728-8265.