Senior Systems Engineer

Database Design: Collaborate with application developers to design and optimize SQL databases that meet application requirements, scalability, and performance needs. Database Implementation: Install, configure, and set up SQL Server instances, creating and configuring databases, tables, and stored procedures. Performance Tuning: Monitor and optimize database performance, identifying and resolving performance bottlenecks, query optimization, and index maintenance. Backup and Recovery: Develop and implement database backup and recovery strategies to ensure data availability and integrity. Security: Manage database security by configuring user roles, permissions, encryption, and auditing to protect sensitive data. Maintenance: Perform routine maintenance tasks, such as patching, upgrading, and applying service packs to keep SQL Server instances up to date. High Availability: Implement high availability and disaster recovery solutions, such as clustering, replication, and Always On availability groups. Monitoring and Alerting: Set up monitoring tools to track database health and performance, configuring alerts for proactive issue resolution. Documentation: Maintain detailed documentation of database configurations, procedures, and incidents. Query and Performance Analysis: Analyze and optimize SQL queries for efficient data retrieval and manipulation.

Experience Level

Senior Level