SUMMARY

• Detailed - oriented Microsoft Certified Team Lead SQL Server/Azure SQL Database Administrator with over 13 year of experience managing SQL Server, Azure SQL, Database Security, Database Architect and Cloud(Azure) administrator role for production environments. Maintained server and systems to ensure smooth business operations.
• A Passionate contributor to team success with track record of empowering teams. Versatile with Database and Azure cloud technologies, always motivated to learn, grow and stay current.
• Have achieved commendable success in delivering high quality IT services and implementing continuous service improvement measures for multiple clients. Adept at problem solving negotiating and delivering projects.
• Provide Service reliability from designing, implementing & operating highly Scalable-resilient Cloud based Services which are cost efficient and fault tolerant ensuring modern engineering principles, Azure capacity & performance are leveraged in the process.
• Design and implement robust database administration solutions including resource management, security, backup and recovery, performance monitoring and tuning, data management and capacity planning, planning and implementing failover between database instances.
• Experienced Azure Database Administrator to implements and manages the operational aspect of cloud-native and hybrid data platform solutions built on Microsoft Azure services and Azure SQL VM.
• Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems;
• Good Understanding & Knowledge onCloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS).
• Good Experience in Database Design & Architecture; Good experience in Backup and Recovery scenarios.
• Good Expertise and experience on Multiple Data Center migration and yearly DR Drill for Critical application databases.
• Migrated SQL Databases from On-Prem to AZURE, Configure Geo-Replication for high availability, Manage database on Elastic pool and SQL Managed Instance.
• Extensive experience to use multiple Azure migration tool like “Azure Migrate”, Azure Data migration Services(DMS)” and “Azure Data Migration assistant(DMA)”.
• Setup and Manage Always-ON High availability for HA/DR; High Availability and Disaster recovery. Setup and manage Log shipping to automate and synchronize backup and restore to a secondary servers for Disaster recovery as an additional security for mission critical databases in our environment.
• Setup and Configure Azure Backup for SQL Server databases with Recovery Service vault. Configure and setup SQL Server on Azure VM and setup HA/DR for Azure VM.
• Review and Remediate SQL Server and Azure SQL Database Vulnerabilities and part of database best Security Practice.
• Expertise in Identifying the I/O and memory, bottleneck, blocking and deadlock caused by complex queries using SQL Server activity monitor/profiler, and handling them by implementing better query execution plans with PLAN GUIDE and QUERY Store.
• Automated processes to reduce workflow by creating maintenance plan that runs daily to reorganize, rebuild and update statistics, backup and clean up task.
• Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance.
• Good Expertise in managing Database team(Onsite-Offshore).
• Good Experience on Database Auditing and SOX compliance process.

PROFESSIONAL EXPERIENCE

Confidential, Carmel, IN

Team Lead (SQL Server/Azure SQL/Azure Administrator)

Responsibilities:

• As Senior Lead Operation DBA, my responsibility is to make sure, I Plan, design and implement disaster recovery strategies for database environment to make sure we have 24/7 availability and higher uptime.
• Responsible for maintaining database systems that are accurate, highly secure, and constantly available.
• Managing Database team for Onsite and offshore also part of CAB member team to review and approve database change request.
• Responsible for Installing, Configuring and Maintaining SQL Server 2014/2016/2019 on Active/Active or Active/passive Cluster with the latest Service Packs, Hot Fixes. Performed In-Place and side by side migration of each version of SQL server.
• Providing efficient strategies for consolidating the databases/Servers/instances and decommissioning servers to free up data centers and SQL licensing cost etc..
• Responsible for Database Auditing and working with SOX compliance team to provide data based on need.
• Worked on Cloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS).
• Setup and configure Azure VM, Azure SQL DB, Storage account, VNET, Load balancer and other Azure resources.
• Responsible for Moving On-Prem SQL server databases to Azure SQL VM, Azure SQL and Managed Instance.
• Responsible for setup and configuring Azure Backup on Azure SQL VM for SQL database backup.
• Setup and configure Azure Storage account for Azure Blob and Azure files and secure the data by using keys or shared access signatures.
• Setup and configure Azure automation job for indexing and Update statistics on Azure SQL database and also for exporting Azure SQL DB bacpac file to azure with Azure automation.
• Good experience inDatabase design & architecture and Backup & Recoveryscenarios.
• Good experience in implementing High Availability & Disaster Recovery solutions usingAlways ON, Clustering, Replication, Mirroring and Log Shipping.
• Worked on performance and query tunning for Microsoft Dynamics AX 2012 ERP and Dynamics 365, Performed Data refresh and worked on Dynamics Perf to troubleshoot, analysis and optimize query performance.

Confidential

SQL Database Administration

Responsibilities:

• Ensure routine database activity: Task included Backup and Restore, Login issue, DB Access issue Service pack upgrade, Disk space analysis, database space analysis.
• Performing Maintenance Window activity on SQL server after business hours(Like Rebooting server to refresh system and memory resources, SQL Cluster Fail back on preferred node, Restarting SQL services and SQL agent, Rebooting Cluster Node, Applying Latest service Pack on Cluster and standalone SQL servers.
• Have Implemented Replication Setup(Mostly Transactional Replication) on SQL Server 2008 and 2000. Worked on Adding/Deleting Articles on Existing replication Setup as per requirements. Also troubleshoot replication related issues and re-initialize subscription when subscription(s) have been marked inactive.
• Implemented log shipping on SQL server 2008 via SSMS and also by using IDERA SQL safe Management tools.
• Performing database migration from SQL Server and also moved databases and jobs for one data center to another.
• Implementing Transparent Data Encryption(TDE) for Database Security and also Maintains backup for s and Keys.
• Working on Client DB request: Adding users under proper groups and giving appropriate access to user, backup and restore database in all environment, create Database Shell setup for newly created programs as per specification, create linked server, creating jobs, schedule, alerts, operators.
• Worked on Updating the SQL configuration for optimum performance and memory usage. Updated the Ad Hoc Workload Configuration for 2008 SQL Server configurations.
• Worked on Backup/Restore, Disaster recovery and Disk space issue by using Few Third Party products like IDERA SQL Safe, AVAMAR Backup/Restore, IDERA Space analyzer.
• Resolving issues pertaining to database administration: Issues faced by users in accessing the database are resolved by performance tuning or due to blocking etc..
• Maintaining databases in good health: Migration of NCI(Non clustered indexes) from primary file group to Index file group on different drive to improve performance . Checking Blocking reports and resolving if any job caused blocking. Performing reindexing and update statistics on DBs as per requirement.

Confidential

SQL Database Administration

Responsibilities:

• Performing routine database activity: Task included checking all schedule jobs on all the servers and troubleshooting failed jobs, disk space analysis, database space analysis, checking SQL error log for errors.
• Migration of MS-Access Database to SQL Server2008 Database
• Performing database migration from SQL Server .
• Implementing Transparent Data Encryption for Database Security.
• Resolving issues pertaining to database administration: Issues faced by users in accessing the database are resolved by performance tuning.
• Maintaining databases in good health: Performing reindexing and update statistics on DBs as per requirement.
• Working on Client DB request: Creating login, user, giving appropriate access to user, backup, restore, DTS package, create DB as per specification, create linked server, creating jobs, schedule, alerts, operators.
• Handle incidents related to SQL Server and resolve the issues- Incident Management
• Disk space management --- Incident Management
• Implement planned changes to SQL Servers as per client business requirement-- Change Management
• Implement performance tuning process as per Application required.
• Participate in Request For Change(RFC) meeting --- Change Management
• Participate in conference calls with Application team and client for various reasons
• Maintain good relationship with the client.