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