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