SUMMARY:

• Around 8 yearsof experience asProduction MSSQL DBAon OLTP, e - Commerce, Financial, Banking Platforms throughITIL Management Principles.
• Involved in Migration of17K+ DBsto VM Farm/Dedicated instances/SQL 2017.
• Performed Administration tasks such asPlanning, Installation, Deployment/Implementation, Configuration ofMSSQL Server 2005/2008/2012/2014/2016on 24x7 production systemsStand-Alone & Cluster environments. Installed SQL 2008/2012/2014 onHyper-V cluster& Physical Platforms.
• Upgrading/Migratingof MSSQL2005/2008/2012/2014 using suitable approach (In-Place or Side-by-Side) Techniques. Have upgradedSQL 2005 SP2 to SP4up gradations on Stand-Alone & Cluster environment
• Optimizing & developingSQL Queries, Stored Procedures and other SQL Objects
• Have extensive knowledge in OptimizingSQL Databases performance, Execution Plans & Index Optimizations.Few examples include bringing duration ofovernight processfrom11 Hrs to 2 Hrs,webpage load time from30sec to 8sec, web page requirements from14secto<5secas part of client requirements.
• Creating (Administrative), Deploying, Configuring, Installing & MaintainingSSIS & SSRS Packages. CreatedSSIS Packagesthat perform Automated data extraction from database and notify via e-Mail, backsup multiple database & restores across two different locations throughPowerShellScripts
• Created & deployedSSRS reportssuch as ticket logging reports, client stock reports on SQL 2008, 2005 platforms.
• Designed, Built & MaintainedHA techniquessuch as Always On, Mirroring, Replication, Clustering on Production environment.
• Developed Backup & Restorestrategies as per business requirement.
• Hands on experience on performance tuning such asblocking & fixingdead-locks.Worked on Code integration and tuning process to bringdeadlocks count tozero.
• User & database security management, creating users, roles, granting permissions and Managing security by creating logins, users and assigning privileges.
• Creating, Monitoring & Troubleshooting SQL Agent jobs & MaintenancePlans for automating tasks such as backups, index optimizations, integrity Checks, etc.
• Have good personal, analytical & communicative skills and worked alongside developers, managers & Clients for assisting in technology implementation & suggesting best applicable business requirements.

TECHNICAL SKILLS

Databases: MS SQL Server 2000/ 2005/ 2008/ 2012/ 2014/2016/2017

Developing Tools: Powershell, MSBI-SSIS & SSRS, T-SQL Development

Ticket Tools: ServiceNow, Vivantio, PAC2000

Backup/ Recovery Tools: LiteSpeed, Commvault, EMC Networker, NetBackup

Additional Skills: Operating Systems MS Windows Server 2003/ Server 2008 / Server 2012/Server 2016

Domains: Banking, Finance, Insurance and eCommerce

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

MSSQL Database Administrator

Responsibilities:

• Involved in End-to-End migration which includes but not limited to Estate Analysis, Hands on Database Migration and Hand-off to EDM Team.
• Involved in process walkthrough calls to brief Application team on Project scope, requirements to achieve Internal Database standards as per EDM standards and timelines.
• Configuration of user entitlements through ART and IAM Tools.
• Involved in implementation of Work Order, Change Requests and Work Requests through PAC2000 tool.
• Configuration of UDS SQL Login Roles, implementing database standards
• Worked on implementing Replication, AlwaysOn Groups on Prod and Non-Prod environments

Environment: MSSQL Server 2017, PAC2000, PowerShell, AlwaysOn, Native SQL

Confidential, Miluwakkee, WI

Senior Database Administrator

Responsibilities:

• Responsible for 24*7 production support of databases
• Patching, Upgradation of SQL Database environment.
• Designed, Configure and Maintain AlwaysOn databases
• Responsible for support DR tests and recovery support of production databases per RTO and RPO
• Carried out performance troubleshooting on servers
• Configure and maintain security and encryption of databases using TDE.
• Worked extensively on Query tuning and Performance optimization

Environment: MS SQL Server 2012, Commvault, Native SQL

Confidential

Senior Database Administrator

Responsibilities:

• Production support for leading fortune 70 companies
• Provided support during patching servers with HA configured
• Responsible for meeting and ensuring that server environments and deployments have been configured as per the customer guidelines and requirement
• Carried out performance troubleshooting on servers
• Worked extensively on DR environment to ensure servers are recovered within stipulated RTO and as per RPO

Environment: MS SQL Server 2005/ 2008/ 2012, Commvault, EMC Networker, NetBackup, Native SQL

Confidential

Database Administrator

Responsibilities:

• Installed and configured MS SQL Server, including service pack deployments
• Migrated MS SQL Server database
• Implemented disaster recovery plans
• Managed security (Creating users, logins and roles, and granting permissions)
• Involved in performance monitoring and tuning
• Ensured data consistency in the database through DBCC commands
• Added users in the database and granted permissions
• Scheduled jobs in MS SQL Server
• Configured and maintained log shipping and replication

Environment: MS SQL Server 2005/ 2008/ 2012, MS Windows Server 2003/ 2012