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 Replication that is Snapshot, Transactional & Merge.
• Experience in implementing and Monitoringdifferent 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

• Visual Studio .NET 2010/2012
• .NET Framework 3.0/4.0/4.5
• Windows Mobile SDK
• Web Services - SOAP
• REST
• WSDL
• JSON
• C#
• VB.NET
• C++
• VB.NET
• ASP.NET
• MVC
• ASMX Web Services
• WCF Services
• HTML
• JavaScript
• CSS
• XML
• JQuery
• Confidential Windows Server 2003/2008
• Confidential Windows XP/7/8
• SQL Server 2005/2008
• Oracle 9i/10g
• Team Foundation Server
• Tortoise SVN
• UML 2.0
• 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, Interteltelephone system management, NetworkSecurity management, applicationand 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 toAzure 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, Reston, VA

SQL Server DBA

Responsibilities:

• Upgraded most of SQL Server 2000 to SQL Server 2008 R2
• Involved with upgrade of databases from in a Clustered environment.
• Worked on SQL Server 2005 with latest Service Packs.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Involved in Monitoring Performance of different production servers.
• Implemented Database mirroring for disaster recovery.
• Maintained various databases for Production and Testing using SQL Server 2005.
• Planning the location of data, index, and Transaction log files on the disk.
• Performance tuning, and optimization of procedures and queries.
• Worked with SQL server Profiler.
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Experience in creating and executing SQL Server Integration Services (SSIS) packages.
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Used BCP and Bulk Insert utilities and Worked with SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2008 R2/2005/2000, Windows Server 2003/2000, VMware, RedGate, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication

Confidential

SQL Server DBA

Responsibilities:

• Responsible for providing 24x5 supports for production SQL Server database and maintenance.
• 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.

Confidential

.NET Developer /DBA

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.