SUMMARY:

• 7+ years of experience in IT industry, harnessed in wide range of Confidential technologies. Was endorsed as a vital professional in SQL Database Administration and ASP.NET Confidential development technologies.
• Experienced in full software development life cycle (SDLC) including analysis, design, and development.
• Adept in building applications for windows platforms.
• Installed and maintained SQL Server failover clustering (active/active and active/passive) for SQL Server 2005/2008/2008 R2/2012/2014 versions.
• Experience in working with AWS Cloud.
• Experience on Database Mirroring and Log shipping with Network Authentication.
• Experience on SQL Server Transactional Replication.
• Experience in implementing and Monitoring different types High Availability and Disaster Recovery scenarios like Always on, Replication, log shipping and Configure Database Mirroring in Cluster Environment on Production, QA and Dev environments.
• Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in supporting Very Large Database (VLDB) more than 8TB and troubleshooting problems.
• Experience in designing data warehouse and building interfaces for SAP Business Objects.
• Expertise in Database Backup and Recovery procedures by using Native, TDP/TSM and LiteSpeed to/from Disk /Legato server (Tape).
• Expert in Azure SQL Administration on Cloud Computing.
• Very good experience on working with SCOM Monitoring.
• Experience on Installing, upgradation of SQL Server 2000, 2005 & 2008.
• Involved in designing the backup strategy.
• Restoring database from production to dev servers as per requests.
• Creating SQL Logins, Assigning Roles for the requested users.
• Monitoring space on server, handling issues with Log files, Shrinking Log and Data files.
• Troubleshoot SQL Server service outages as they occur, including after - hours and weekends
• Conduct SQL Server lunch-and-learn sessions for application developers
• Configure SQL Server monitoring utilities to minimize false alarms
• As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies
• Install and configure new SQL Servers
• Deploy database change scripts provided by third party vendors
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
• Document the company’s database environment
• On-call troubleshooting for SQL Server service outages
• Setting up Transactional Replication for Production server to Reporting Server.
• Configure and maintain High Availability using Log Shipping.
• Experience on Database Mirroring.
• Involved in generating Workload file to analyze SQL server performance using SQL Server Profiler.
• Involved in Index operations (Rebuild & Reorganize) and database maintenance
• Extensive Experience in providing Production support for Database and Applications.
• Experience in Tuning SQL Queries & improving the performance of the Database and Applications.
• Extensive experience with Monitor, tune and analyze database performance and allocate server resources to achieve optimum database performance.
• Excellent communication, presentation and interpersonal skills
• Strong troubleshooting and organizational skills.

TECHNICAL SKILLS:

Confidential Development Platforms: Visual Studio .NET 2010/2012 and .NET Framework 3.0/4.0/4.5, Windows Mobile SDK, Web Services - SOAP, REST, WSDL, JSON

Development Languages: C#, VB.NET, C++, VB.NET

WEB TECHNOLOGIES: ASP.NET, MVC, ASMX Web Services, WCF Services, HTML, JavaScript, CSS, XML, JQuery

Operating Systems: Confidential Windows Server 2003/2008, Confidential Windows XP/7/8

Database Systems: SQL Server 2005/2008, Oracle 9i/10g version Control: Team Foundation Server, Tortoise SVN

Modelling Tools: UML 2.0Performance Tools: FxCop, Code Metrics

PROFESSIONAL EXPERIENCE:

Confidential, Dearborn, MI

SQL Server DBA

Responsibilities:

• SQL Server 2008/2008R 2/2012/2014/2016 Database Development and Administration.
• Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2014/2 R2/2005 on standby environments.
• Primary hands-on duties include MS Active Directory management, SQL DBA activities, Exchange management, GEMMS EMR management, Intertel telephone system management, Network Security management, application and report development and support.
• Installed latest service packs, applied hot fixes and cumulative updates.
• Migrated servers from and with In-place and Side-by-Side Processes.
• SQL Server Patching on 2005, 2008, 2008R2, 2012, 2014.
• Applied Patches and Service packs to update different versions of MS SQL Server in Clustered and standalone environments.
• Created linked servers between SQL Server 2005 and 2008, 2008R2 and 2012.
• Administering SQL Server High Availability features like Log shipping, Database Mirroring and Always On.
• Worked on Active/Passive clusters to manage cluster resources and troubleshoot errors.
• Used log shipping, Always on Availability Groups and Mirroring for synchronization of databases and worked with Transactional Replication to achieve load balancing.
• Ensure backup and recoverability of all enterprise SQL server databases using Native SQL and Symantec Netbackup.
• Daily routine Developer/DBA tasks like handling user’s permissions, monitoring Blocking, Deadlocks, Long running jobs, and space issues on Production and Semi-Production servers and handling maintenance jobs.
• Implemented the TDE (Transparent Data Encryption) in all the production servers to secure the customer credit card or payment details and also in order to follow the PCI standards.
• Created Databases on Azure SQL Server and Migrated On-Premise databases to Azure SQL .
• Setting up High availability | DR solutions over Azure.
• Configured Azure SQL Server Firewall for Performance Tuning.
• Migrated the production SQL server schema to the new AWS RDS .
• Used Cloud watch for basic and detailed monitoring of AWS resources.
• Installed, Configured, managed security for SSIS, SSAS, and SSRS (2008 R2, 2012 &2014).
• Creating SSIS packages to load data across different servers.
• Re-Designed Siemens model cubes (SSAS) by partitioning the cubes yearly and then monthly.
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Responsible for tuning complex SQL queries and Stored Procedures to increase performance.
• Involved in integration/system testing and backup/restore testing for all components.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Experience with Team Foundation Server and BI Documenter tool.
• Used TFS for source control and managing development via tasks/bugs.
• Responsible for deploying code changes, code review and code releases in all environments with respect to release deadlines.
• On Call 24X7 support, request queue, daily maintenance and application support.

Environment: SQL Server 2005/2008/2008 R 2/2012/2014/2016, Visual Studio 2008/2010,BIDS, T-SQL, SSIS, SSAS, SSRS, Azure, Red Gate SQL Compare, Lite Speed, Performance Analysis (PA), HP Quality Center, Crystal Reports, TFS, MS-Excel, XML, Windows 2012/2008R2/2008/2003/NT/XP.

Confidential

SQL Server DBA

Role & Responsibilities

• Responsible for providing 24x5 supports for production SQL Server database and maintenance.
• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
• Configure SQL Server monitoring utilities to minimize false alarms
• As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies
• Install and configure new SQL Servers
• Deploy database change scripts provided by third party vendors
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
• Document the company’s database environment
• On-call troubleshooting for SQL Server service outages
• Installation of SQL server software and related Products.
• Creating SQL Logins, Assigning Roles to the users.
• Setting up BACKUP/RESTORE and disaster recovery procedures to ensure minimal down time and data loss.
• Monitor and modify Performance using execution plans, Index tuning and rebuilding them as required.
• Automation of maintenance by creating jobs and alerts
• Checking of the database consistency using DBCC commands to minimize complexity.
• Involved in designing of High Availability using Replication and Log Shipping.
• Coordinating with onsite DBA and Brach Anchors for necessary troubleshooting to resolve the problem. To analyze the long running slow queries and tunes the same to optimize application and system performance.

Tools: SQL Server 2014/2012/2008 R2/2008/2005, T-SQL, Windows 2012/20 bit, BugZilla, Azure, DTS, SSIS, SSRS, SSAS, RedGate, Profiler, Share point, Oracle 10g, TFS, LiteSpeed.

Confidential

.NET Developer /DBA

Role & Responsibilities

• Involved in low level design.
• Development, perform unit testing and peer reviews.
• Handled the GUI part and few vital reporting part of the application.
• SQL DBA.

Tools & Technologies: Visual Studio 2008, WCF, SQL Server 2005

Confidential

.NET Developer

Role & Responsibilities

• Working with analysts in finalizing functional/technical specification document. Handled the GUI part and implemented few WCF services.

Tools & Technologies: C# 3.0, .NET 3.5, WCF, Spatial Oracle.