FSSI - Financial Statement Services Inc.

Database Administrator

• 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 availability, capacity, performance, blocking, deadlocks, waits, storage utilization, and overall system health
• Perform SQL performance tuning, including query analysis, execution-plan review, indexing strategy, statistics maintenance, and stored-procedure optimization
• Design, implement, test, and maintain backup and recovery strategies
• Support high-availability and disaster-recovery technologies, including Always On Availability Groups, failover clustering, log shipping, and replication
• Manage database security, roles, permissions, service accounts, encryption, auditing, and access controls
• Apply SQL Server security updates, cumulative updates, and version upgrades through approved change-management processes
• Create, review, and maintain T-SQL scripts, stored procedures, functions, views, indexes, SQL Agent jobs, and maintenance routines
• Partner with application developers on database designs, data models, queries, stored procedures, and deployment scripts
• Support database deployments through CI/CD and DevOps processes
• Automate routine administration using PowerShell, T-SQL, SQL Server Agent, and approved scripting tools
• Maintain database documentation, configuration standards, data dictionaries, runbooks, recovery procedures, and operational documentation
• Participate in incident response, root-cause analysis, problem management, and production support
• Monitor capacity, storage growth, retention, archiving, and data lifecycle needs
• Support integrations and data movement using SSIS, APIs, ETL/ELT processes, and secure file/data transfer mechanisms
• Collaborate with infrastructure, security, development, QA, and DevOps teams
• Evaluate and support SQL Server workloads hosted on-premises and in cloud environments, including AWS
• Ensure systems and changes comply with security, audit, business-continuity, change-management, and production standards

SQL Database Administrator