Sr. SQL Server Application/Operations DBA MSSQL SERVER Resume

SUMMARY

I am an experienced Senior Database Engineer/ Administrator/Developer/Architect with a demonstrated history of working in both the financial and healthcare industries.
In these roles, I specialize in high - volume transactional databases including Microsoft SQL Server, Oracle, and Sybase. On the side, I am currently exploring NoSQL technologies (MongoDB, Cassandra) in some personal projects.
Very well versed in SDLC (Software Development Life Cycle), Agile Safe and scrum, and Project Management

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server Application/Operations DBA MSSQL SERVER

Responsibilities:

Install and configure MS SQL Server 2012/2014/2016/2017 on Windows 2012/2016 serversDevelop maintenance plans and backup and restore strategies
Maintain and develop multi terabytes databases
Database architecture and design aided by Agile methodology (SAFe certified)
Develop stored procedures, triggers, functions, views for all pharma functions including customer effectiveness
Continuous performance monitoring analyzing query plans and perfmon
Implement and setup disaster recovery systems in MS SQL Server using ALWAYSON AVAILABILITY GROUPS and SQL Server Clusters (including multi subnet clusters)
Design, develop and maintain ETL solutions using SSIS, reporting services using SSRS and Analysis services using SSAS
Convert Oracle databases from Oracle to MYSQL on AZURE/Google Cloud Platform
Regular performance tuning of Database server and windows servers to alert unusual activities
Setup SQL Server Performance on all servers to alert unusual activities
Implement Master Data Services in SQL Server as a part of consolidating critical data
Proactive resource planning to avoid any down time
Provide active solution support to all applications both home-grown and third party
Actively support change management process

Confidential

Senior Lead MS SQL Server Database Administrator/Developer/Architect

Responsibilities:

Quality Planning (QPC), a member of the Verisk Analytics Family of Companies, supplies tools and services that help automobile insurers identify rating errors, recover lost premiums, and minimize future losses.
Install and Upgrade MS SQL Server 2005 on various Development/QA/Production platforms and convert to MS SQL Server 2005/2012 .
Design and code Database Objects including Tables, Stored Procedures, Views, Triggers, UDFs etc..
Develop SSIS packages and Reporting systems for Revenue stream and On call 7x24 support .

Confidential

Senior Lead MS SQL Server Database Administrator/Operations Systems Engineer

Responsibilities:

Architect the System sizing and resource and capacity planning in view of the 300% Volume growth
Install MS SQL Server 2008, TFS (Team Foundation Server) as a replacement for VSS on all the new Windows 2008 servers, Upgrade old MS SQL Server 2000 to scalable MS SQL Server 2005 SSRS, SSIS(Sales Tracking and Fee Reimbursement), SSAS, Maintain Data Replication and Log shipping