SQL Server Operations DBA

Tasks

• Analyze SQL query execution plans
• Analyze and generate table and index statistics
• Configure AlwaysOn availability groups and failover clustering
• Configure and use data storage management
• Create and maintain database indexes
• Create and optimize SQL Server Agent jobs
• Develop and debug stored procedures
• Develop and optimize SSIS ETL packages
• Implement database design using T-SQL
• Install and configure Microsoft SQL Server instances
• Maintain SQL Server maintenance plans
• Manage SQL Server security
• Manage data export import and mass data loads
• Monitor SQL Server maintenance jobs
• Optimize complex SQL queries
• Perform database backup and recovery
• Perform database migrations and server upgrades
• Plan and manage disaster recovery
• Resolve data lock issues
• Troubleshoot application performance issues
• Troubleshoot failed jobs

Perks/Benefits

• N/A

Skills/Tech-stack

Agent Jobs | AlwaysOn Availability | AlwaysOn availability groups | Availability Groups | C Sharp | Database Backup | Database Design | Database Modeling | Database migrations | Database performance | Database performance tuning | Database recovery | Database security | Disaster Recovery | ETL | Execution Plans | Failover Clustering | Functions | Git | ITIL | Indexing | Integration Services | Maintenance Plans | Microsoft SQL | Microsoft SQL Server | MongoDB | Performance Tuning | Powershell | Query Optimization | SCOM | SQL Server | SQL Server Agent | SQL Server Agent Jobs | SQL Server Integration Services | SQL Server Maintenance Plans | SQL Server Security | SQL Server integration | SQL Server maintenance | SSIS | Server Integration Services | Server Security | Server upgrades | Source Control | Stored Procedures | Subversion | T-SQL | Triggers