Job Description

Help for Job Description. Opens a new window.

Monitor SQL Server database instances, system logs, and SQL Server Agent jobs to identify errors, performance issues, or security concerns. Validate completion of full, differential, and transaction log backups and perform routine backup and recovery testing. Perform regular database maintenance, including index rebuilds/reorganizations, statistics updates, integrity checks, and fragmentation review. Analyze and optimize SQL queries, stored procedures, triggers, and database objects to improve performance and reliability. Manage database storage, monitor file growth, and forecast capacity needs. Support high availability and disaster recovery configurations, including clustering, log shipping, replication, and AlwaysOn environments. Design, develop, and maintain SQL Server databases, data models, and schema changes based on application requirements. Develop and support ETL processes using SSIS or related tools for data integration and migration. Monitor and support cloud based database environments, including Azure SQL and related Azure services. Utilize automation/orchestration tools to streamline database and application workflows and resolve automation errors. Collaborate with cross functional teams to support application development, data integration, and operational requirements. Prepare and maintain technical documentation for database configurations, maintenance procedures, and operational workflows.

Must be willing to relocate to unanticipated client locations in the

U.S. 100

% telecommuting from home allowed from anywhere in the United States when not at client site.