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 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: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: 
