Senior Systems Engineer

Job description

• 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

Skills Required

Performance Tuning, Monitoring Tools, Sql Queries, Query Optimization, Database Design