| Location | Horsham, PA |
JOB SUMMARY: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 environmentsMonitor database health, performance, and availability; proactively identify and resolve issuesLead performance tuning and optimization efforts, including:
Query tuning and execution plan analysisIndex management and optimizationStored procedure review and refactoring
Partner with application developers to:
Review SQL code for efficiency and scalabilityAssist with database design, schema changes, and data modeling decisionsSupport high transaction OLTP systems in e commerce and financial, environments
Implement and manage backup, restore, and recovery strategiesTroubleshoot complex production issues using native and third-party monitoring toolsParticipate in production support and on call rotations as requiredAssist help desk and support teams with SQL- and database related issuesContribute to database standards, documentation, and best practicesParticipate 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 environmentsDeep understanding of:
Database architecture and relational design principlesIndexing strategies and execution plans
WORK SCHEDULE:
Hybrid Schedule