SUMMARY:

• Self - motivated, enthusiastic and results-oriented team player wif excellent written, verbal, and leadership skills to develop creative solutions and resolve challenging client needs
• Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies
• Possess database administration expertise, including installation, configuration, upgrades, capacity planning, performance tuning, backup, and recovery in managing clusters of SQL servers
• Experience implementing SSIS, SSRS, and SSAS solutions, and creating complex reports using Tableau/PowerBI dashboards

TECHNICAL SKILLS:

Operating Systems: Win9x, NT4.0, 2K, 2K3, XP, Unix, Ubuntu

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

Database Tools: VERITAS Net Backup, SQL Nexus, Lite speed, SSIS, SSRS, SSASIdera SQL Diagnostic manager, SQL Sentry

Cloud: Amazon Web Services, Azure

Networking: TCP/IP, VMware, Citrix

WORK EXPERIENCE:

Database Engineering

Confidential

Responsibilities:

• Lead all database efforts to improve the existing database infrastructure
• Establish and build strong working relations and partnerships wif Business Units and Senior Management
• Provide database assistance and problem support to application developers and business users
• Automate SQL Server database migration, DBA tasks, reports and import processes using T-sql and powershell
• Provide support in Capacity planning, Forecasting, and performance tuning.

Database Lead (SME)

Confidential

Responsibilities:

• Act as Database lead and SME for Database infrastructure in AWS
• Implement and configure highly scalable SQL Server database servers adhering to industry standards of security, performance and compliance in data center or deploy to cloud using AWS/Azure
• Resolve and document root cause analysis of critical SQL Server production issues involving Database Corruption, Blocking and Deadlocks
• Design and develop the Disaster Recovery/Always On (HA) and Log shipping to ensure continuity of business
• Analyze SQL Server query execution plans and recommend code changes to assist in performance and Query tuning.

Senior SQL SERVER DBA

Confidential

Responsibilities:

• Take complete ownership of our entire database infrastructure and ensure we meet our SLA's
• Provide database development, design assistance to development and other application support teams
• Analyze SQL Server query execution plans and recommend code changes to assist in performance and Query tuning.
• Implement and configure highly scalable SQL Server database servers adhering to industry standards of security, performance and compliance in data center or deploy to cloud using AWS/Azure
• Implement and maintain data management platform to create a centralized data source and keep it synchronized using Master Data services.
• Design and develop the Disaster Recovery/Always On (HA) plan to ensure continuity of business
• Resolve and document root cause analysis of critical SQL Server production issues involving Database Corruption, Blocking and Deadlocks
• Create knowledge based articles on database migrations, upgrades and document solutions of critical prod issues in Confluence
• Establish and build strong working relations and partnerships wif Business Units and Senior Management
• Provide database assistance and problem support to application developers and business users
• Automate SQL Server database migration, DBA tasks, reports and import processes using T-sql and powershell
• Provide support in Capacity planning, Forecasting, and performance tuning.

System Analyst

Confidential

Responsibilities:

• Implemented and deployed SSIS packages and data transformation from heterogeneous sources
• Migrated SQLServer2005/2000 to SQLServer2008/SQLServer2008R2, resulting in security and performance gains for the company
• Implemented Database Compression, Indexing and Performance optimization on effected applications, resulting in 99.99% availability of the servers and integrity of critical information
• Performed root cause analysis of critical production issues and resolved database corruption and deadlocks
• Implement and maintain data management platform to create a centralized data source and keep it synchronized using Master Data services.
• Implemented capacity planning of databases and monitoring of space usages on disk
• Reduced company expenditure by $2.3M by migrating 8 Terabytes of Oracle Databases to Microsoft SQL server

Sr. Database Administrator

Confidential

Responsibilities:

• Proposed recommendations to VP-Technology and heads of business on capacity planning, database design, backup, and recovery, resulting in performance improvement and cost reduction for company
• Created and implemented SQL Server databases
• Resolved critical production issues such as database corruption and availability issues, leading to integrity of critical data
• Implemented SQL Server High Availability and Disaster Recovery solutions such as Clustering, Replication, Database Mirroring and Log Shipping
• Led a team of 24 DBAs, and managed and supported operations encompassing 900 database servers
• Recommended and implemented the use of compressed database backups using Quest Lite speed, resulting in savings of $9M

Database Administrator

Confidential

Responsibilities:

• Implemented complex reports on Business Objects and Reporting Services using T-SQL queries, stored procedures, triggers and cursors
• Extracted and transformed data from various sources wif the implementation of packages using SQL Server Integration Services tool
• Responsible for database monitoring, troubleshooting, performance tuning, and high-availability strategies wif SQL Server 2005 in a 24x7production environment
• Resolved database production issues resulting in continuous availability of database and software applications
• Reorganized Index creation, design and maintenance to improve Query Performance

Software Engineer

Confidential

Responsibilities:

• Designed and implemented Banker’s Realm Microfinance application - a retail banking product using C# and ASP.NET
• Took the lead in developing application architecture, enhancing code modules, and creating business reports and dashboards