Seeking a team where my passion and self-motivation can be leveraged to work on multiple concurrent projects and my professionalism can diffuse high pressure situations. Having excellent customer service skills and the ability to work effectively with clients and team members.
I start my day with a learning mindset and believe in continuous learning, always seek new opportunities and challenges to grow myself and others. I enjoy working in a diverse environment and love making best use of technology.
Below is my professional summary.
1. Installation and configuration of SQL Server in accordance to business needs and requirements.
2. Designing, implementing and documenting high availability and disaster recovery solutions using different methodologies i.e. backup/ restore, Log Shipping, Replication, AlwaysOn and Failover Clustering.
3. Designing, implementing and documenting consolidation strategies.
4. Critical Alerts Configuration to ensure continuous business operations and to mitigate / minimize downtime.
5. Testing for new applications or modifications. Testing in pre-production environment before live implementation to test software updates, bug fixes, SQL cumulative updates, service packs, upgrades and OS releases. Responsible for remedial maintenance with updates to other teams as necessary.
6. Manage and perform database maintenance (Index / Statistics) using different automated script to ensure optimal database performance.
7. Designing, implementing and documenting backup and restore strategies to meet the business RPOs and RTOs.
8. Documenting backup and restore scripts and making it available to the team and ensuring backup is valid and restorable.
9. Troubleshoot different database issues to support mission critical applications.
10. Expert T.SQL Development i.e. Stored Procedures, Views, Functions and Triggers.
11. Tuning Queries for different reports and applications.
• Maintenance and Administration of SQL Server databases and Multidimensional Cubes (Process, Backup, Restore) and enhancement to existing data warehouse.
• SQL Server installation, configuration, maintenance, upgrade and patch management.
• Designing, documenting, cleaning and implementation of data mart using SSIS, SSAS both Multi-Dimensional and Tabular.
• Application development using C#, VB.net and ASP.net.
• T-SQL development and helping the development team in troubleshooting different database issues and in writing optimal and advance queries (adhoc and stored procedures).
• Exploring and analyzing new SQL features and educating the team on how to use it.
• Troubleshooting different SQL server issues to support business critical applications and ensure best database performance.
• Documenting, Designing and implementation of Database backup and restore strategies.
• Report Development using SSRS / Crystal Reports and Power BI.
• .Net development using C#, VB.net and ASP.net
• Integration with different applications using Rest APIs, web services.
• Troubleshooting, designing, installation, upgrade and maintenance of SQL Server.
• Maintaining SQL Server database to ensure optimal performance.
• Web and windows-based application development using C#, VB.net and Asp.net.
• Report development using SSRS.
• Data migration (from production to staging server) using SQL Server Import / Export, SSIS and Replication.
• T-SQL Development.
1. Software Development using VB.net, C# and Asp.net
2. T-SQL Development, writing optimal and optimized stored procedures.
3. Gathering Requirements.
4. Web Services development.