Microsoft SQL Database Administrator

Opening its doors over 45 years ago, FSSI is a leading document outsourcing company servicing Fortune 500 companies in the financial, banking, insurance and billing industries across the U.S. We are currently looking for a Microsoft SQL Database Administrator to join our FSSI East Development team.

Location:

This is a remote opportunity open to candidates residing in the following states:
Florida, Rhode Island, Massachusetts, New York, Vermont, Texas, and Alabama. Candidates who are interested in a hybrid or onsite arrangement may also work from our facilities in Lincoln, RI or Orlando, FL.

This role is responsible for the administration, availability, performance, security, integrity, and recoverability of Microsoft SQL Server database environments supporting FSSI business and production systems. Responsibilities include installing, configuring, monitoring, maintaining, troubleshooting, and optimizing SQL Server platforms; supporting application and development teams; implementing backup, recovery, high-availability, and disaster-recovery solutions; and ensuring database environments comply with FSSI security, change-management, and operational standards.

We are looking for a hands-on, experienced SQL Server Database Administrator who can step into the role and make an immediate impact. Our ideal candidate takes ownership, can assess situations independently, identify potential issues, and bring practical solutions and recommendations to the table. You’ll work closely with our IT, development, infrastructure, and business teams, so strong communication and the ability to explain technical issues and solutions are important.

You’ll receive training on FSSI-specific applications and procedures, but we’re looking for someone who already understands how to be a DBA and can apply that knowledge in a new environment.

• Administer, configure, monitor, patch, upgrade, and maintain Microsoft SQL Server database environments across development, test, and production systems.
• Install and configure SQL Server instances, databases, SQL Server Agent jobs, linked servers, maintenance plans, and related database services.
• Monitor database availability, capacity, performance, blocking, deadlocks, waits, storage utilization, and overall system health; proactively identify and resolve issues.
• Perform SQL performance tuning, including query analysis, execution-plan review, indexing strategy, statistics maintenance, and optimization of stored procedures and database objects.
• Design, implement, test, and maintain backup and recovery strategies that meet established recovery point and recovery time objectives.
• Support high-availability and disaster-recovery technologies such as SQL Server Always On Availability Groups, failover clustering, log shipping, and replication as appropriate.
• Manage database security, roles, permissions, service accounts, encryption, auditing, and access controls in accordance with least-privilege and FSSI security standards.
• Apply SQL Server security updates, cumulative updates, and version upgrades using approved change-management and testing processes.
• Create, review, and maintain T-SQL scripts, stored procedures, functions, views, indexes, SQL Agent jobs, and database maintenance routines.
• Partner with application developers to review database designs, data models, queries, stored procedures, and deployment scripts for performance, scalability, reliability, and security.
• Support database deployments through CI/CD and Dev Ops processes and participate in release planning, validation, rollback, and post-deployment monitoring.
• Automate routine database administration activities using Power Shell, T-SQL, SQL Server…