Company:
MarshDescription:
- Installation & Configuration: Installing, configuring, and upgrading SQL Server instances and related software, applying patches, and setting up system and user databases.
- Performance Monitoring & Tuning: Proactively monitoring database performance metrics (CPU, memory, I/O), identifying and resolving performance bottlenecks, and optimizing slow-running queries and indexing strategies.
- Backup & Recovery: Designing, implementing, and regularly testing robust backup and disaster recovery (DR) plans to prevent data loss and meet recovery time objectives (RTO) and recovery point objectives (RPO).
- High Availability (HA) & Disaster Recovery: Implementing and managing HA/DR solutions like Always On Availability Groups, failover clustering, mirroring, or log shipping to ensure business continuity and minimize downtime.
- Security & Access Management: Implementing role-based security, creating and managing user logins and permissions, setting up encryption, and performing regular security audits to protect sensitive data.
- Maintenance & Automation: Developing and implementing routine maintenance plans (integrity checks, index maintenance, statistics updates) and using scripting languages like T-SQL or PowerShell to automate repetitive tasks.
- Collaboration & Support: Working closely with developers on database design, schema changes, and code reviews, and providing 24/7 on-call support for critical production incidents.
- Capacity Planning: Monitoring database growth trends and planning for future storage and performance needs to ensure scalability.