Database Administrator

Tasks

• Apply database patches and updates
• Deploy database change scripts
• Implement high availability backups restores clustering availability groups replication
• Install and configure SQL Server instances
• Maintain production and development databases
• Manage database indexes
• Model data for read write workloads
• Monitor database performance and integrity
• Optimize T-SQL query performance
• Perform database storage planning and partitioning
• Support developers with database design
• Troubleshoot SQL Server resource contention
• Troubleshoot database locking and deadlocks
• Write optimize and maintain stored procedures

Perks/Benefits

• N/A

Skills/Tech-stack

Always On | Always On Availability | Always On Availability Groups | Availability Groups | Backup and Restore | Clustering | DBCC | Database performance | Database performance tuning | Index Management | Jira | Performance Tuning | PostgreSQL | Query Optimization | Replication | SQL Server | Source Control | Stored Procedures | T-SQL