SUMMARY

• 7 years in progressive roles with Confidential .
• SQL DBA point of contact for 50+ applications that processes billions of dollars
• Extensively worked on Confidential SQL Peer to Peer, Snapshot and Transactional Replication
• Performed Zero downtime deployments by leveraging SQL Peer to Peer replication
• Troubleshoot performance problems, fine - tuning of databases and index Analysis
• Administering SQL Server High Availability Always On and Disaster Recovery strategies
• Strong T-SQL coding skills
• Great problem solving and analytical skills
• Well versed in SSIS development
• Strong C#/.Net debugging skills
• As a team leader, I was responsible for Analysis of specifications, Design and Development, Coding using C#, ASP.NET, Database management, Testing - unit testing and Integration testing.
• Involved in designing web forms using C# and ASP.NET.
• Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database.
• Designed SQL Server Database, developed T-SQL queries, stored procedures, and triggers using SQL Server 2005
• Creating test cases, performing User Acceptance Testing
• Responsible for overseeing the Quality procedures related to the project.
• Design, recommend and implemented high resilient solutions to achieve 99.99% availability
• Managing traffic using the Local and Global Traffic managers.
• Executed application (SQL, Web & API) failovers as part of quarterly disaster recovery exercises and mitigated any deficiencies in the failover/failback process
• Implemented automations to increase the efficiency of business processes and reduce operating costs
• Technical escalation engineer to unblock testing for agile and quarterly releases
• Implemented self-healing solutions
• Optimized application infrastructure costs and enabled effective utilization of the available resources
• Migrated on-premises infrastructure to Azure IaaS
• Leads critical Fiscal close process for Confidential
• Leads and mentors the support team that delivers high quality support to Confidential partners
• Proficient in Confidential SQL Server Development & Administration
• Deep knowledge on SQL Server version 2008/R2, 2012 and 2014
• Strong SQL BI capabilities (SSIS & SSRS)
• Master level knowledge on SQL Always On, replication and recoveries.
• Very good skills on tuning and execution plans to improve performance
• Proficient in C# coding, ASP .net Web N-Tier and MVC applications.
• Moderate skills on Azure DocumentDB and Azure Search
• Strong knowledge in Confidential Azure IaaS and PowerShell scripting
• Good expertise on SCOM, IIS, Windows NT batch jobs, Services and HTML
• Deep knowledge on DevOps, ISRM, Incident coordination, Major Incident processes, ITSM & Service NOW ticketing tools

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Sr. SQL Server developer/DBA

Responsibilities:

• Coding and reviewing the T-SQL stored procedures and views
• Developing the SSIS packages
• Creating and publishing Confidential Power BI reports
• Responsible for Analysis of specifications, Design and Development, Coding using C#, ASP.NET, Database management, Testing - unit testing and Integration testing.
• Administering SQL Server High Availability Always On and Disaster Recovery strategies
• Performed Zero downtime deployments by leveraging SQL Peer to Peer replication
• Configure and monitor Transactional, Snapshot and P2P replication
• Analyzing and resolving the customer escalations for 50+ applications that processes billions of dollars
• Onsite - Offshore Coordination
• Manage the operations team. Guide and monitor them for complete operations.
• Create and maintain the team member skill matrix.
• Resource planning, resource utilization tracking and resource optimization.
• Conducting trainings and mentoring to team members.

Confidential

SQL Server Database Administrator

Responsibilities:

• Hands on experience in installing, configuring, managing and monitoring SQL Server Servers.
• Experience in SQL server daily health check to ensure all the servers and database are up and running fine.
• Monitoring the regular backup job failures and incidents from ITSM & SNOW tools and troubleshooting them.
• Backup and Restoration: Scheduling different database backups of full, differential and log backups, and the complete responsible for restoring the databases at the critical time zone of round the clock support.
• Worked on High Availability technologies SQL Always-ON, log-shipping, failover clustering management.
• Worked on database creation, refresh, decommission, upgrade and migration from lower to higher.
• Involved in the service accounts change and verification for SQL Services based upon the requirement.
• Worked on instance or server decommissions and ensure to maintain a repository.
• Monitoring of logical disk space, log files growth.
• Monitoring SQL server incidents, change requests, and mission critical databases and providing 24x7 supports.

Confidential

Software Engineer

Responsibilities:

• Providing Production Support on Critical Applications.
• Responsible for the possible problems raised by the Support Team in Problem Management.
• Responsible for every Bug resolutions in UAT for quarter releases
• Analyzing UI, Stored Procedures, Job’s, C# code
• Analyzing the root cause for the failures
• Testing the resulting components at UAT
• Analyzing the runtime profile to debug errors
• Responsible of manual testing and smoke testing
• Responsible for overseeing the Quality procedures related to the project
• Involvement in tuning the parameters for optimum performance of the system at the customer’s work place
• Coordinated of all the aspects of the Problem Management, Change Management, Release Management, coordinating, progress and issues, managing the team and ensuring the quality of the deliverables
• Preparing and recommending technical alternatives involving technology, methodology, tools, processes and solution components
• Performance tuning of SQL Server, IIS, NLB
• Follow established group standards and methodologies and provide feedback necessary to improve those processes.
• Implement industry best practices in the projects executed with commitment to achieve success at all cost along with Process rigor
• Deployment of the Change Releases into the production environment
• To provide the required support to the customer as agreed in the service level agreement

Confidential

Associate Software Engineer

Responsibilities:

• Involved in new databases design and creation.
• Created Database Diagrams, identify database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.
• Worked on creation and improving the stored procedures and triggers performance.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions.
• Responsible for Query Performance tuning and Optimization.
• Created views, SQL joins DTS packages and SQL statements for applications.
• ETL packages are created to extract, transform and load data to data ware house using SSIS.
• Using SSIS the data is transferred to and from flat files, MS Excel and SQL Server 2005.
• Promoted rapidly through a series of highly responsible technical and lead positions based on strong technical, client relations, operations and team leadership performance.