- Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
- Configure and maintain database servers and processes, including monitoring system health and performance to ensure elevated performance levels, availability, and Security.
- Analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.
- Assist developers with complex query tuning and schema refinement.
- Performance Tuning and Optimization (PTO)
- Prevention of Deadlock and Timeouts
- Create a recovery model for disaster recovery.
- Manage ETL tools and Migration of the database from one server to another.
- Configure SQL databases on Azure cloud.
- Configuration of the database for on-premises and cloud
- Automation process for backup / restore / cleanup.
- Configure alerts for any DB related issues.
- Design indexing strategies
- Review database changes and design new database
- Maintain Database Access, Database Security and do an audit
- Configure Database Software
- Designing coding guideline for SQL programming
- MS SQL Server 2019 with Azure cloud SQL database.
- Strong Technical and Interpersonal Communication
- Work Closely with Development Teams with Regards to Database Updates and Design
- Must write SP, function, Triggers, Tables, View etc.
- Performance Tuning and Optimization for database and server level
- How to solve the performance bottleneck using Query Store
- Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
- Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
- Good knowledge of Indexes, Execution plan and missing indexes
- Improve performance using wait statistics.
- Knowledge of SQL Server Integration Service (SSIS)
- Must have knowledge of ETL.