SUMMARY

• Over 10+ years’ experience in IT, Financial, Insurance and Healthcare which includes System Analysis, Design, Development, engineering and Administration of MS SQL Server 2016/ 2014/2012/2008 R 2 / 2008/2005/2000 , AWS, SQL Azure, private cloud in Production, UAT/QA and Development Environments.
• Experience on HA and DR solutions with clustering, Always On, Mirroring, Replication and Log shipping. Azure capabilities of elastic pools and Geo Replication.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting Database issues, deployment, upgrades, migration source control, and applications changes to systems in multiple environments.
• Expert in Migration Analysis, capacity planning, Upgrade implementation, Azure database to different server and data files migration on SAN and NAS
• Experience with SQL Server and Confidential - SQL in constructing triggers, tables, and user defined functions, views, indexes and Store procedures.
• Expertise in SQL server Performance tuning and transactions analysis, data analysis, Query Optimization and indexes tuning & Optimization
• Extensive experience in design and implementation of Business Intelligence tools (Star Schema, Snow Flake, Data-Warehousing, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.
• Expertise in performing administrative tasks: database files management, backup/restore, disaster recovery and backup strategies, security management, data integration and synchronization.
• Excellent skills in Optimization of Confidential -SQL Store-procedures, removing deadlocks, Client/Server Connectivity, Database Consistency using DBCC Utilities.
• Hands on Experience in creating, deploying SSIS packages, Extracting and transforming Data (ETL) by using DTS and Integration Services (SSIS).
• Experience in Data Modification, Updates, inserts and release code changes
• Worked and experience with MOM/SCOM and Performance analysis tools like SQL Nexus, SQL DIAG and Extended Events
• Experience in Data Safety, Data masking, Encryption (TDE), Role based Security, PII data Sensitivity, integrity requirements and PHI regulations and HIPAA mandates
• Automation of Database Maintenance tasks by creating maintenance jobs, Alerts.
• Expertise in developing ad-hoc Queries and reports using SQL server reports SSRS.
• Experience in migration of Data from Excel, Flat file, Oracle to SQL Server, SQL server production data to Data-Warehouse by using DTS and SSIS Package.
• Experience in performance tuning of Database queries using Profiler and Event Viewer graphs, performance dash board for OLAP/OLTP databases.
• Implemented and supported multi-tiered, enterprise scale Databases (12 TB)
• Experience in Storage Architecture for SQL server Best performance, configuring RAID Levels, Disk offset, Knowledge of SAN technology.
• Good understanding of service management foundations such as MOF/ITIL
• Strong troubleshooting, cross-group collaboration, problem solving skills and strong ability to prioritize multiple tasks.
• 24x7 Support for online transaction services OLTP and OLAP Systems
• Excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS

Servers & Databases: SQL Server 2016/2014/2008 R / 2000, Oracle 12i/11g, mongo DB, AWS, SQL Azure,IIS

Performance Monitoring Tools: Perf Mon, Profiler, SQL Nexus, Performance Dashboard, DMV’s, SQL DIAG, Extended events

Reporting tools: SQL Server Reporting (SSRS). Tableau

ETL & Business Intelligence: SQL Server Integration service (SSIS), Informatics, Data stage, SQL BI, Analytics

High Availability: SQL Server Clustering, Always on, AG, NLB, Mirroring, Log Shipping, Replication

Cloud Computing: SQL Azure / Windows Azure, Private Cloud, Enterprise Cloud, AWS

Operating Systems: Windows 9x/ 2000/2003/2008/2012/ NT/XP, Hyper-V UNIX, Windows Azure.

MS products & tools: SCOM/MOM, Vega, Products Studio, VSTF

Other Third Party Tools: DB artisan, Toad, Lite Speed, Tivoli, Control-M, keynote, Idera DM, Patrol, NETCOOL, Quest SQL Lite Speed/Spot Light, veritus, DBDiff, Asigra backup, VM ware P2V, Site scope, Orion, New relic, Spotlight

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Sr SQL DBA/Technical Support

Responsibilities:

• Troubleshoot and resolve database issues including performance issues, data integrity issues, logging and storage issues, and problems with executing processes.
• Supported and resolved various production/test related tickets.
• Error handling, monitoring and troubleshooting SQL server Agent jobs.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, critical server events and security Alerts.
• Automate Audit reports and Security reports and maintain RBS, compliance.
• Resolved issue related to Data errors and Applications errors and applied data fix on the SQL server database, Data validation and Bug fixes
• Worked with reports, Ad-hoc Queries as per Business Need to monitor historical events and Activity of the application and Users.
• Writes SSIS package to Upload Customer data from SFTP site to the SQL Database
• Troubleshooting of High CPU consumption SP and analyzing execution plan, Analysis of index and statistic related to that SP.
• Monitor and improve the Backup strategy based on the SLA of Point in time recoverability. Automated SQL restore & backup from production to test servers
• Used Extended Events, Profiler and SQL Native tools to Troubleshoot.

Environment: SQL SERVER 2016/ 2014/2012/2008 R2/2005, SQL Azure, Salesforce, SSIS, Confidential -SQL, Windows R /NT/XP, VM’s, SQL Azure.

Confidential

Sr. SQL server DBA

Responsibilities:

• Performed software installations, upgrades, monitored database performance, performed capacity planning and support SQL SERVER 2012 & 2014 in production, UAT and development.
• Migrate SQL server Database from Windows 2003 to Windows 2012 migration.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, critical server events and security Alerts.
• Troubleshoot and resolve database issues including performance issues, data integrity issues, logging and storage issues, and problems with executing processes.
• Supported and resolved various production/test related tickets.
• Error handling, monitoring and troubleshooting SQL server Agent jobs.
• Resolved issue related to Data types and code for upgrades as per update advisor
• Upgraded SQL server 2005 to SQL 2014 and involved in migrating server and supported in SAN migration. Azure migration from on premises.
• Build Sql server on VM and DBAAS as per the BEST practices.
• Troubleshooting of High CPU consumption SP and analyzing execution plan, Analysis of index and statistic related to that SP.
• Monitor and improve the Backup strategy based on the SLA of Point in time recoverability. Automated SQL restore & backup from production to test servers
• Used DMV’s, SP whoisactive, Profiler, and Perfmon for diagnosing the issues.

Environment: SQL SERVER 2014/2012/2008 R2/2005, SQL Azure, SSIS, Confidential -SQL, Windows R /NT/XP, VM’s, cloud.

Confidential, Seattle, WA

Sr. SQL server DBA

Responsibilities:

• Maintained databases, performed software installations, upgrades, monitored database performance, performed capacity planning and support SQL SERVER 2012 & 2008 R2 in production, UAT and development.
• Implementation of high-availability solutions for mission critical SQL Server databases, including (always on), clustering, mirroring and Transactional P2P replication.
• Troubleshoot and resolve database issues including performance issues, data integrity issues, logging and storage issues, and problems with executing processes.
• Supported and resolved various production/test related tickets.
• Upgraded SQL server 2012 with SP1 and involved in migrating server and supported in SAN migration.
• Implemented SQL server Best practices to improve the performance. Addressed the issues tempdb contention, parallelism, deadlocks using Extended Events.
• Troubleshooting of High CPU consumption SP and analyzing execution plan, Analysis of index and statistic related to that SP.
• Auditing database failed logins and maintain credentials as per the Compliance.
• Perform data changes and respond to CR’s created by Customer Team and Documented wiki pages.

Environment: SQL SERVER 2014/2012/2008 R2/2005, SSIS, Confidential -SQL, Oracle, Mongo DB, MYSQL, ORION (solar winds), CA, SVN, WINZIP (secure FTP), Windows 2008 R /NT/XP, VM’s, UNIX. AMAZON (AWS), Disney Private Cloud.

Confidential, BOTHELL, WA

SQL SERVER DBA (Production Applications Support) ABDA

Responsibilities:

• Maintained databases, performed software installations, upgrades, monitored database performance, performed capacity planning and support SQL SERVER 2012 & 2008 R2 in production, UAT and development.
• Implementation of high-availability solutions for mission critical SQL Server databases, including clustering, mirroring and Transactional P2P replication.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, critical server events and security Alerts.
• Troubleshoot and resolve database issues including performance issues, data integrity issues, logging and storage issues, and problems with executing processes.
• Supported and resolved various production/test related tickets.
• Error handling, monitoring and troubleshooting SQL server Agent jobs.
• Production support for Transactional peer to peer replication, conflict resolution, troubleshooting errors, adding node.
• Worked with data collector (MDW) to monitor historical events and troubleshoot SQL Production
• Upgraded SQL server 2012 with SP1 and involved in migrating server and supported in SAN migration.
• Implemented SQL server Best practices to improve the performance. Addressed the issues tempdb contention, parallelism, deadlocks.

Environment: SQL SERVER 2012/2008 R2/2005, SSIS, Confidential -SQL, Oracle SQL plus, connect direct (IBM), NETCOOL, PATROL, SVN, WINZIP (secure FTP), Windows 2008 R /NT/XP, VM’s

Confidential, Seattle

Database Administrator/Engineer

Responsibilities:

• Maintained databases, performed software installations, upgrades, monitored database performance, performed capacity planning and support SQL SERVER 2005 & 2008, 2008 R2 in production
• Implementation of high-availability solutions for mission critical SQL Server databases, including clustering, mirroring and Transactional replication.
• Troubleshoot performance issues, data integrity issues, logging and storage issues, Supported and resolved various production/test related tickets.
• Error handling, monitoring and troubleshooting SQL server Agent jobs.
• Implemented Log shipping and SQL reporting server for offloading Production from business and ad hoc reports.
• Upgraded SQL server 2008 R2 with SP2 and involved in migrating server and supported in SAN migration.
• Implemented SQL server Best practices to improve the performance. Addressed the issues tempdb contention, parallelism, deadlocks.

Environment: SQL SERVER 2008 R2/2008/2005, SSIS, SSRS, Confidential -SQL, Postgresql, DB visualizer. Diagnostic manager, SAN recover point, EMC VNX., Windows 2008 R /NT/XP, VM’s

Confidential, Redmond

SQL SERVER DBA

Responsibilities:

• Responsible for management, tuning, and performance monitoring of SQL Server databases. Includes consideration for optimization of server and storage utilization, consolidation of licenses, high availability and disaster tolerance. Provides tools and techniques for Operations staff to maximize effectiveness of reporting databases.
• Performs routine space and consistency checks, and manages SQL security.
• Maintained BizTalk server, SQL azure, Azure storage on UAT and PROD environment, including setting up Applications, Orchestration, Send/Receive locations
• Hands on experience in installing, deploying, configuring ASP.NET web applications on IIS 6.0/7.0
• Achieved application Stability with high-availability (HA) solutions for mission critical SQL Server databases, including clustering (active/passive), mirroring, and Log shipping and Transactional replication.
• Participated in major problem reviews, initiates requests for change and ensures compliance with operational, security policies and coordinates release management process and adherence to it.
• Engaged in responsible ownership of application, identifying potential problem, advocate for solutions and lead incident management team tier 1 in trouble shooting and resolving the Issue timely.
• Mentors and train in house and offshore for Service related issues and resolutions.
• Available for on call escalations and advanced break fix problems and problem management.

Environment: SQL SERVER 2008 R2/2008/2005, SSIS, SSRS, Confidential -SQL, .Net, SQL AZURE, Power shell, SSMS, Operations workbench, Opslight, SCOM, IIS, SCSM, Netscalers, load Balancer (NLB), Windows 2008 R /NT/XP, VM’s

Confidential, Redmond

SR SQL SERVER DBA /OPS Engineer

Responsibilities:

• Maintained databases, performed software installations, upgrades, monitored database performance, performed capacity planning and support SQL SERVER 2008 R2/2008/2005 in production and PPE Environments.
• Supported and configured high-availability solutions for mission critical SQL Server databases, including clustering (active/passive), mirroring (synchronous) and Transactional replication.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, critical server events and security Alerts.
• Managing Permissions for user/logins and assigning server/database roles 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.
• Troubleshoot and resolve database issues including connection string from application in web config.co-ordinate with web services tier to resolve.
• Performed daily operations including monitoring, storage management, backups, and index maintenance.
• Resolved Complex issues and advanced troubleshooting production OLTP Databases.
• Error handling, monitoring and troubleshooting SQL server Agent jobs.
• Created Troubleshooting guide (TSG’S) and updated with appropraite resolution steps for Tier 1 and Tier 2 Ops Engineers.
• Mentor and conduct Training for Tier1 and Tier 2 Ops Engineers.
• Experince with onboarding application on SQL Azure/window Azure
• Tier 3 Support for database issues escalated 24x7 including night and weekends

Environment: SQL SERVER 2008 R2/2008/2005, SSIS, SSRS, Confidential -SQL, SQL AZURE, Power shell, SSMS, Operations workbench, Opslight, SCOM, IIS, SCSM, Windows 2008 R /NT/XP

Confidential, Redmond

SQL SERVER DBA/ENGINEER

Responsibilities:

• Design databases, performed software installations, upgrades, monitored database performance, performed capacity planning and support SQL SERVER 2008/2005 in production and PPE Environments.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, critical server events and security Alerts.
• Troubleshoot and resolve database issues including connection string from application in web. Config co-ordinate with web services tier to resolve.
• Performed daily operations including monitoring, storage management, backups, index maintenance and advanced troubleshooting production OLTP Databases
• Troubleshoot deadlock issue in production using the system trace and Xevents.
• Performed migration of critical database from R2 with no downtime.
• Monitor Event logs, SQL error logs, application errors using SCOM, cluster sentinel and updated resolution and closed the IR’s in SCSM.
• Created Troubleshooting guide (TSG’S) and updated with appropriate resolution steps for Tier 1 and Tier 2 Ops Engineers.
• Tier 3 Support for database issues escalated 24x7 including night and weekends

Environment: SQL SERVER 2008, SQL Server 2005, SSIS, SSRS, SCOM Confidential -SQL, Power shell, MeTAL, SSMS, Query analyzer, Resource governor, data collection, and policy based management. Product studio, Visual studio team foundation, Windows 2008/2003/NT/XP, windows 2008 hyper-v

Confidential, Seattle

SQL Server DBA

Responsibilities:

• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning on SQL SERVER 2000 & 2005 servers.
• Monitored database quality assurance including database consistency check.
• Management of the corporate databases to ensure the integrity of all database components and files.
• Installed Oracle client and created Linked server for both oracle and SQL server
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Automated and enhanced daily administrative tasks, including space management and backup & recovery strategies.
• Created SQL reports, Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Troubleshooting and administration of IIS and web services for CRM application.
• Managed the granting of access to operational and developmental application system databases and user needs relating to database access and maintenance
• Provided 24X7 on call support.

Environment: SQL Server 2005, SQL Server 2000, SSIS, SSRS, Confidential -SQL, Power shell, Oracle, MySQL, SSMS, Enterprise Manager, Query analyzer, Cluster administrator, Upgrade advisor, Windows 2000/2003/NT/XP, IIS 6, Web services.

Confidential, Dayton, OH

SQL Server DBA

Responsibilities:

• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning on SQL SERVER 2000 &2005 servers.
• Monitored database quality assurance including database consistency check.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Troubleshoot and resolve database issues including performance issues, data integrity issues, logging and storage issues, and problems with executing processes.
• Supported and resolved various production/test related tickets.
• Error handling and monitoring SQL server for scheduled jobs
• Automated and enhanced daily administrative tasks, including space management and backup & recovery strategies.
• Created SQL reports, Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.

Environment: SQL Server 2005, SQL Server 2000, SSIS, SSRS, Confidential -SQL, Active X Script, VBScript, MS-Excel, XML, Windows 2000/2003/NT/XP.