SUMMARY

• Overall 17+ years’ experience, including 10+ years as SQL Server DBA/Architect, 4 years as SQL Server Developer/ETL
• 2 years as Azure Administrator and 2 years as an ORACLE 8i DBA in Healthcare, Logistics, Insurance, Banking and Finance domains.
• Proficient in DBA and Azure Cloud Administrator activities, such as:
• Design and implementation of Hybrid Database Solution on Azure Cloud.
• Design Disaster Recovery Solutions and High - Availability in Premise and Azure SQL.
• Management of SQL server Databases on Production, Development and UAT.
• Databases Migration and Upgradation.
• Capacity Planning.
• Manage Backup, Security, Audit and Hardening.
• Discussion with client and peers to collect and analyze data requirements.
• Database Architecture Designing.
• Manage and documentation of Compliance Standard.
• Configure Networking in AZURE Cloud.
• Manage AZURE Subscription and Resource Group.
• Performance Tuning and Query Optimization.
• Managing On-Premises and Azure VM Servers in Distributed Cluster Server environment.
• Automation with PowerShell and T-SQL script.
• Configure Virtual Machine in AZURE Cloud.
• Team Management and ON CALL Support.
• Change Management.

TECHNICAL SKILLS

SQL Server Versions: SQL Server 2017,2016, 2014, 2012, 2008R2, 2005, 2000, Oracle8i

Cloud: Azure Cloud Infrastructure, Azure Platform Service

Programming Languages: PowerShell, T-SQL, Visual Basic, PL SQL

Operating Systems: Windows Server 2016, 2012, 2008, 2003, 2000, UNIX

Ticketing and Monitoring Tools: Citrix, BMC Remedy, Lite speed, Foglight, Spotlight, SCOM, VERITAS and Visual SourceSafe

ETL Tools: SQL Server Integration Services (SSIS), Data transformation services (DTS), BCP Utility

Reporting Tools: SQL Server Reporting Services (SSRS), Replication, Mirroring, ALWAYS ON

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Enterprise Manager, SQL Server Management Studio

PROFESSIONAL EXPERIENCE

Confidential

Senior SQL Server DBA

Responsibilities:

• Install, upgrade, migrate and document all changes in SQL Servers (physical and virtual) .
• Understand and analyzed requirement for PFT application
• Planning for migration and up-gradation.
• Performance optimization and tuning.
• Monitoring alerts.

Confidential

Sr. SQL Server DBA\Azure Cloud Administrator

Responsibilities:

• Architected and implemented Public and Private Cloud infrastructure in highly distributed environment.
• Participated in a Data Engineering Team supporting application projects.
• Works collaboratively with the Application team, including architects, developers and testers, to ensure project success.
• Performed assessment, planning and implementation for migration.
• Implemented and documented servers\databases security matrix.
• Designed and documented PCI compliance standard.
• Performed hardening and audit of server\Databases.
• Assist Developers for performance optimization.
• Migrated On-Premise databases to Azure SQL Database (PASS) and Azure SQL VM (IASS).
• Configured networking, firewall rules, user permission, database auditing for Premise and Cloud Databases.
• Implemented Active GEO Replication and Always ON for business continuity and read-only workload.
• Managed Capacity Planning, Security and Process Improvements.
• Document Azure and private cloud processes for company future use.

Confidential

Senior SQL Server DBA

Responsibilities:

• Install, upgrade, migrate and document all changes in SQL Servers (physical and virtual) as an when required
• Implemented and automated Load Balancing with Always ON.
• Implemented and managed Distributed Availability Group with Always ON and documented process.
• Assist application teams for code review, performance analysis and query optimization.
• Worked closely with developer to for T-SQL programming and optimization.
• Implemented and managed HA and DR solution such as always ON, log shipping, replication and mirroring of databases.
• Maintained databases backup, restore, integrity, security and auditing.
• Setup automation with script and database mail when Always ON and DAG failures.
• Implemented Table Partition to achieve performance benefit for critical databases.
• Implemented and documented servers\databases security matrix.
• Performed hardening and audit of server\Databases.
• Managed routine DBA tasks like backup, restore, security and space management, audit, handling tickets etc.
• Utilizing best practices, work plans, checklists and defined processes.

Confidential

Senior SQL Server DBA

Responsibilities:

• Performed Server Assessment and due diligence of legacy system.
• Installed and configured SQL server 2016 in cluster environment on Production and QA servers.
• Engaged with application team for application testing on QA servers.
• Worked closely with application teams for code review, performance analysis and query optimization.
• Migrated databases from SQL server 2008R2 to SQL Server 2016 and implemented security policy.
• Implemented Always ON as HA and DR solution.

Confidential

Sr. SQL Server DBA Lead\ Azure Administrator

Responsibilities:

• Managed, installed, upgrades (In-place and side-by-side) and migration in SQL Servers.
• Initial assessment and planning for transition from On-Premise to Azure Cloud.
• Managed Services, DTU, DWU, Service Tier, Securities, Encryption, Firewall, as per business requirements.
• Migrated On-Premise databases to Azure SQL Database (PASS) and Azure SQL VM (IASS).
• Configured firewall rules, user permission, security, database audit for Azure SQL databases and Azure SQL VM.
• Replicated data to scale out read-only workload, refresh Dev-test in cloud with Active Geo Replication.
• Implemented Active GEO Replication and Always ON for business continuity and read-only workload.
• Implemented log shipping, replication, mirroring and Always ON as a HA and DR solution.
• Installed and configured SSIS, reporting services and deployed packages
• Managed Capacity Planning, Security and Process Improvements.
• Managed routine DBA tasks like backup, restore, security and space management, audit, handling tickets etc.
• Used Power Shell and T-SQL scripting to automate backup, SQL Server audit and other DBA tasks.
• Managed offshore team and presented SMR Reports to management.
• Worked closely with development team for Query optimization and Performance Tuning.

Confidential

Senior SQL Server DBA & Team Lead

Responsibilities:

• Installed service packs, upgrade, migrate SQL servers and documented all changes.
• Implemented log shipping, replication and mirroring for business continuity.
• Defined and documented server and databases security policies, user permission, auditing and process improvement.
• Performance tuning and implementation of best practices.
• Implemented and documented servers\databases security matrix and audit.
• Monitored servers, handled incident tickets, services request troubleshooting and databases recovery.
• Managed backup, restore, space management, database maintenance, development and UAT support.
• Automated capacity planning, backup and space reports and prepared checklist for DBA activities.
• Prepared SOP’s and Checklist on DBA tasks and managed offshore team activities

Confidential

Senior SQL Server DBA

Responsibilities:

• Administration of SQL Servers in Cluster and Standalone Environments.
• Implemented table partitioning, log shipping, database mirroring.
• Designed SSIS packages installed and configured Reporting services.
• Diagnosed SQL Server performance, database health and fine tuning.
• Maintained centralized inventory for databases servers and application details.