Durga M Email & Phone Number

● 5 years of Experience in installing, configuring, upgrading Microsoft SQL Server 2008/2012/2014, experience as SQL Server Developer, SSIS, SSRS and SQL DBA.● Experience with complete SDLC life cycle, which includes requirement gathering, analysis, design,development, maintenance and implementation.● Experience in using SQL for developing stored procedures, triggers, tables, user defined functions, relational database models and SQL joins.● Hands on Experience in Table Design creating Clustered Indexes, Non-Clustered Indexes, complex joins and SQL Scripts for Views and Materialized Views.● Expertise in writing T-SQL Queries, sub-queries, Stored Procedures, Triggers, User-defined Functions, Views and Cursors.● Experience with CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation.● Knowledge on Oracle 11g and PL/SQL.● Created SSRS reports like tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc.● Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring. ● Has very good ETL experience using SSIS for Data Extractions, Transformations and Loads.● Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.● Experience in monitoring, troubleshooting and resolving SQL Server problems such as database integrity issues, performance issues, Concurrency problems (blocks, locks, and deadlocks), replication issues, log shipping issues, connectivity issues, SQL Server service startup problems, SQL agent job execution problems and security issues.● Managed highly available database and application infrastructure according to Business requirements using SQL clustering, load-balancing, Replication, Disaster recovery.● Good knowledge on HA Always On Availability groups.● Ability to handle multiple tasks, Initiative and Adaptable, Self-motivated, organized team player.