Microsoft SQL Database Administrator

About the role

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, Connecticut, 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

• 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 DevOps processes and participate in release planning, validation, rollback, and post-deployment monitoring
• Automate routine database administration activities using PowerShell, T-SQL, SQL Server Agent, and other approved scripting and orchestration tools
• Maintain database documentation, configuration standards, data dictionaries, runbooks, recovery procedures, and operational support documentation
• Participate in incident response, root-cause analysis, problem management, and production support for database-related issues
• Monitor and manage capacity, storage growth, retention requirements, archiving, and data lifecycle needs
• Support integrations and data movement using technologies such as SQL Server Integration Services (SSIS), APIs, ETL/ELT