PROFESSIONAL SUMMARY:

• 15+ years of Microsoft SQL Server Database Architect / Development and Administration experience in SQL Server Azure, 2016/2014/2012/2008 R 2/2008/2005/2000/ SQL7.
• Microsoft Certified (MCTS) with extensive experience in SQL Server Database Development. Administration, Analysis, Integration and Reporting service (SSIS,SSAS, SSRS), Power BI. Azure DataFactory, Azure datalakes, Cosmos. U - SQL,Kusto
• Working for Microsoft client since last 10 years in different capacity
• Expertise in Data warehousing setup and creating various kind of reporting and dashboards.
• Expertise in SQL query optimization and performance tuning
• Expertise in SQL Azure Migration from on-premise Data centers.
• Analyzing capacity planning for moving databases from on-premises to SQL Azure or Azure VM
• Strong knowledge in high availability setup like Windows Clustering, SQL clustering, Availability Group, Log shipping, Mirroring, replication.
• Expertise in designing and creating process/operation automation
• Experience in capacity planning, disaster recovery, troubleshooting, backup advanced data recovery, fixing data corruption and restore procedures
• Expertise in Test Plan preparation, Test case generation, Test Plan review, Test case automation, Testing strategies
• Strong expertise in DevOps implementation
• Expertise in System Engineering, Ticketing, SLA and Security compliance activities
• Expertise in C#, MVC, Web API, Entity Framework
• Expertise on various MS tools which includes GIT, ICM, TFS, VSTS, Kusto, Cosmos
• Deft in handling project management activities, which include planning, design, scope management, estimation, resource administration and completion of project within specified parameters.
• Effective communicator with people management, relationship management, analytical and coordination skills.
• Achieving implementation of project plans within pre-set budgets.
• Monitoring project progress as per scheduled deadlines for various tasks and taking necessary steps to ensure completion within time, cost and effort parameters.
• Leading & managing project teams throughout the project lifecycle and providing them support & guidance on technical and project-related issues.
• Managing code deployment, change management and quality assurance(CMMI, Six Sigma)
• Expertise in handling Onsite/offshore model team in 24 X 7 support
• Mentoring/guiding Team Members
• Providing value adds to customers through implementing multiple tools to eliminate manual works
• 12 Years of onsite experience

PROFESSIONAL EXPERIENCE:

Confidential, Redmond

SQLServer/ Azure Architect

Technologies Used: SQL 2012/2014/2016, ICM, Windows 2012, SQL Azure, SQL RunBook, Avocado, Data Factory, PowerBI, C#, MVC, Web API, Powershell, TFS, VSTS, Cosmos, Kusto, GIT, Traffic manager, ASP.Net, Python, Cosmo, Kusto

Responsibilities:

• Installation, configuration of SQL Server 2008R2/ 2012/2014/2016 Enterprise Edition in Production & other lower environments. Applied latest service packs and windows patches.
• Maintaining SQL Server 2008/2012/2014 databases.
• Migrating Databases to SQL Azure using multiple methods.
• Designing Strategy/solution for Data migration to Azure
• Expertise in SQL Azure Migration from on-premise Data centers.
• Performing query optimization and performance tuning
• Solving day to day problems, Trouble shooting jobs
• Creating and maintaining more than 1000 Windows and SQL clusters and Setting up & maintaining Availability group, AGL, Log Shipping, Replication.
• Responsible for Critical server support 3K servers out of which 2K servers are production servers, remaining Prod like, test and development servers.
• Setting up clone servers
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages
• Creating reports using SSRS and PowerBI
• Creating cubes using SSAS and Tabular SSAS.
• Creating Logins and Roles with appropriate permissions.
• Working with developers for resolving their issues.
• Install and Performing monitoring activities through Powershell
• Handling team of 26 people and taking care of planning, design, scope management, estimation, resource administration, onboarding, coaching, mentoring and completion of project within specified parameters.
• Migration/ upgradation from /2014 SQL Server
• Creating and migrating SSRS reports
• To monitor alerts 24 X 7 and provide resolution for all kind of DBA activity

Confidential

SQL DBA/Developer

Technologies Used: SQL 2005, Oracle, Data warehousing, Crystal reports, Asp.Net

Responsibilities:

• Maintaining SQL Servers and Databases
• Migrating data from Different System to SQL Server 2005/Oracle
• Developing SSIS packages
• Support Web applications
• Performance monitoring
• Space Management
• Creating database maintenance plan
• Creation of Packages & report testing using SSRS & SSIS
• Apply Builds and releases
• Apply hotfixes & monthly security patching
• Shrinking the Logs/data files of databases
• Work with Dev, Test, PMs for project related issues and releases.

Confidential

SQL DBA/Developer

Technologies Used: SQL 2000/2005, Visual Basic6.0, Crystal Reports 9, COM/DCOM FrontStep Toolset, UML.

Responsibilities:

• Migrating database from
• Writing code to fix the bugs in ERP code.
• Wring new feature by creating new form and changing in procedures and triggers
• Creating new triggers/procedure to fix the bug/new features
• Performance tuning and query optimization
• Index creation and tuning
• Checking query plan and proving feedback to create indexes
• Load testing
• Space Management
• Scheduling of Jobs
• Creating database maintenance plan
• Apply Builds and releases
• Monitoring & Maintaining SQL Alerts and Jobs.
• Shrinking the Logs/data files of databases

Confidential

Programmer, Developer

Technologies Used: SQL Server 2000, Crystal Reports8.5, Rational Suite, ERWin

Responsibilities:

• Data Modelling with Erwin
• Form design for reporting in VB 6.0
• Crystal reports design
• Estimation
• Writing procedures for reports
• Creating reports
• Testing the reports
• Helping developers for write procedures and triggers.