• Gender: Male
• Age: 29
• Designation: SQL Developer
• Highest Education Level: Graduate - Degree
• Notice Period: 30  Days
• Preferred Location: Pune
• Work Experience: 5.7 Year(s)

Education

B.Com in Computers

Skill Sets

Skills / IT Skills
• Operating Systems: Windows Family (XP/2000/2003/2008/2010) (2 years)
• Languages: T-SQL (2 years)
• RDBMS: MS SQL Server 2019-2005, SQL AZURE. (2 years)
• Ssis
• SQL Server Tools: Enterprise Manager, Query Analyzer, SSMS, SSIS, Profiler, SSRS (2 years)
• Sql

Work Experience

SQL DB Developer
From August - 2019 to till date.
Company profile- global leader in next-generation digital services and consulting.

Job profile-
• Installation & Configuration of SQL Server 2005/2008/2008/R2/2012/2016 on Local System and Remote
System.
• Applying the service packs in regular intervals.
• Deploying the scripts in production environments.
• Coordinating the Developing activities with the development team And QA team.
• Writing and working on complex stored procedures, triggers, functions, and views.
• Performance Tuning.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming, and loading data into the data
warehouse.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access,
Flat files).
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server 2008
tools like SQL Server Management Studio.
• Used Table variables inside functions and stored procedures.
• Participate in discussions involving the application creation and understand the requirements and
provide the back-end functionality for the applications
• Performed data import and data transformation activities.
• Create functions to provide custom functionality as per the requirements.
• Created Indexes on Tables in order to improve the performance.
• Resolving fragmentation resulting in improved performance.
• Upgrading databases & SQL servers from Lower to Higher versions.
• Monitoring SQL Server alerts at regular intervals
• Monitoring SQL Server agent jobs/maintenance plans
• Provided 7 x 24 Production support for the database and application issues.
• Performing the failover and failback activities on the cluster.
• Having experience on Azure Cloud VMs, Storage and Network and Azure SQL (IaaS and PaaS)

I.T. Professional with 2.6 years of experience in MICROSOFT SQL SERVER Development with a talent
for analyzing problems, developing and simplifying procedures, and finding innovative solutions. 
Ability to work independently or within a Team. Good Inter-Personal skills, team player. 
Development, Support, and Maintenance of business applications using SQL Server
2019/2017/2016/2014/2012/2008R2 
Maintaining SQL Servers with different versions and environments (DEV, QA, Pre prod and
Production) 
Proficient in monitoring & troubleshooting databases, alerts, backups, and performance issues. 
Installation and configuration of SQL Server 2008R2 /2012/ 2014/2016/2016/2017/2019 Standalone
and Cluster servers (Active-Passive and Active-Active), Client tools as per Client requirements 
Handling migration of databases from On-premises to Azure SQL cloud 
Having working experience in T-SQL, SSRS, SSIS. 
Expertise in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management
Studio functionality using T-SQL Scripts and Batches. 
Experience in writing complex SQL queries involving multiple tables inner and outer joins. 
Experience in optimizing the queries by creating various clustered, non-clustered indexes. 
Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions, and
other T- SQL statements for various applications. 
Experience in Performance Tuning, Query optimization, Index Tuning. 
Experience in creating ETL process using SSIS package. 
Experience in creating various types of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports, and Charts using SQL Server Reporting Services (SSRS) 
Experience in creating SSRS subscriptions and scheduling those subscriptions to deliver the reports to a windows file share or through email. 
Experience on Temp-tables, Subqueries, CTE (Common table expression), and Recursive CTE. 
Used XML data types in stored procedures for passing multiple values through parameters. 
Strong knowledge Of Dynamic SQL (Execute SQL), TCL (Transaction Control Language), and Error handling. 
Good Knowledge of Performance Tuning and creating indexes In-order to improve Query Performance. 
Strong Knowledge of loading data from different source systems (Flat file source, Excel source) into
SQL server Through SQL Import Export Wizard. 
Knowledge of SCD1, SCD2 techniques, and Normalization concepts. 
Extensive experience in Installing all versions of SQL Server (SQL server 2008/2012/2016/2019).