Sql Server Azure Cloud

Professional Summary

Outstanding years of successfully leading and managing key IT functions across the broad spectrum of plan, build, deploy, and operate related disciplines in the areas of infrastructure and platform operations.

Extensive experience in installation, configuration, migration, upgrades, update, consolidation, troubleshooting, and performance tuning.

Extensive experience in Migration of SQL databases from on-promise to Azure Cloud in both IaaS and PaaS Environment.

Extensive experience in High Availability solutions using Mirroring, Log Shipping, Clustering (Active/Passive), Replication, AlwaysOn Availability, and implementing Disaster Recovery plan (BCP).

Experience with deploying and managing Cloud Database Services like Azure SQL and Azure Cosmos DB.

Strong experience in monitoring, detecting, and troubleshooting SQL Server issues and other resource contentions

Extensive knowledge in Backup-Recovery that meets the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).

Strong knowledge in database management systems, SQL query optimization, and performance tuning to ensure efficient and reliable database operations.

Adherence to industry best practices and compliance standards in database administration and data governance.

Effective in communicating across all levels of an organization and motivating team to perform beyond expectation.

Diverse technical knowledge in databases, systems engineering, security, industry standards, procedures development, hardware support, capacity management, and operational metrics.

Expertise in enhancing and deploying the SSIS Packages from development server to production server.

Proficient in knowledge transfer to the newly higher and giving continuous training to the Jr. DBAs

Technical Skills

RMDBS: MS SQL Server 2000, through 2019.

SQL Server Tools: Data Factory, SSMS, SQL DM, SQL Safe, IBM Tivoli, Redgate, Spotlight, Fog-light, Site-Scom, HP Polyserve,

Lite-Speed, Symantec Backup, DD-Boost Backup solution, SolarWinds, Double Take (Migration), etc.

Azure Migration: Azure migrate, Data Migration, Assistant (DMA), Azure Database Migration Services (DMS, SQL Server

Migration Assistant (SSMA), & Database Experimentation Assistant (DEA).

Programing Lang: T-SQL, PL/SQL, PowerShell, Java, C, C++, C#, Pascal, Visual Basic, COBOL, etc.

Domain/AD: Active directory, DNS

Clearance: C6 – Public trust

Experience

Scientific Games 11/2019 - Present

Sr. Database Administrator

Provide 24x7 Production support for Databases in Production on Clustered and standalone Servers to achieve Optimum Performance.

Install and configure SQL Server from legacy to the latest version of SQL Server

Migrate databases from On-promise to Azure Cloud in both IaaS and PaaS Environment.

Configure and manage SQL Server Reporting Services (SSRS) including availability, access management, and optimize SSRS reports to meet critical business needs.

Collaborate with developers and system administrators to optimize database performance and resolve any issues.

Manage and maintain databases in Hybrid environments between On-premise and Azure cloud environment.

Responsible for database tuning, availability, integrity, consistency, and performance of critical databases

Schedule jobs to automate database related activities including backup, index maintenance, disk space usage, backup verification, and database health check.

Implement and maintain databases security (Create, maintain, and grant role and privileges to users.)

Migrate, upgrade, and patch SQL Server from legacy SQL Server to the latest version of SQL Server

Provide guidance to development teams in data and schema design to ensure proper implementation and utilization of the data structures.

Perform database troubleshooting and performance tuning whenever an issue arises.

Configure HA solutions using Mirroring, Log Shipping, Clustering, Replication, AlwaysOn Availability, and implementing Disaster Recovery plan (BCP).

Participate in all aspects of the database lifecycle management and in the implementation of application deployment and configuration changes in supported database environments.

Proactively monitor production database servers for issues and act on alerts to ensure the stability of the database environment.

Work closely with internal and external security/auditing to ensure all appropriate controls are in place; this includes SOX and internal change control requirements.

Design database structures and implement database object changes in collaboration with the application project teams. Able to review and process requests quickly.

Enforce and document database security, policies, procedures, and standard of practice (SOP).

AXIS Capital Insurance 06/2018 – 10/2019

Sr. Database Administrator

Lead in the completion of medium to large scale implementations and managing projects from business requirements analysis to solutions delivery and support.

Responsible for data availability, integrity, consistency, and performance of critical databases

Migrate databases from legacy environments to the newer versions of SQL Server.

Migrate databases from On-promise to Azure Cloud in both IaaS and PaaS Environment.

Migrate, Install, configure, upgrade, patch, and support SQL Server in Azure and on-premises.

Perform capacity planning, performance tuning, monitoring, performance troubleshooting, & query optimization

Automate and standardize SQL Server environment to operationalize repetitive tasks.

Establish and build strong working relations and partnerships with Business Units and Senior Management

Interface with developers, network, virtualization, storage, and systems operations teams to resolve problems with applications and database systems.

Automate database related activities on-premises and Azure cloud - including backup, index maintenance, disk space usage, backup verification, and database health check.

Provide database assistance and problem support to application developers, business analysts, and business users.

Manage Databases that spread across multiple regions, datacenters, and servers in Production, staging, Development, & testing environments.

Manage Security and creating SQL Server Logins, Database Users, Roles, and assigning permissions as needed in compliance with the best practices.

Provided 24x7 Production support for Databases in Production on Clustered and standalone Servers to achieve Optimum Performance.

Implement and maintain security rules; maintain Audit security policies; maintain state of Audit readiness; and cleanup database logins.

DELL 09/2014 – 06/2018

Sr. SQL Server Database Administrator Advisor

Client: US Dept. of Education

Adhere to SQL Server databases recommended best practice, instance Hardening, and Database security.

Perform 24x7 production support and on call rotation in supporting databases to achieve maximum performance and uptime.

Ensure all databases are backed up in a way that meets the business’s Recovery Point Objective (RPO) and Recovery Time Objectives (RTO).

Perform all Database related activities such as Database Backup, Restore, Troubleshooting, Performance Tuning, activity monitoring, maintain and create SQL server maintenance plans, etc.

Implement and maintain security rules; maintain Audit security policies; maintain state of Audit readiness; and cleanup database logins.

Successfully configured Active/Active/Passive cluster and installed multiple SQL Server instances for the cluster.

Lead in implementing TDE for databases encryption and TLS encryption for data in transit.

Installed and configured a SQL 2012 clustered environment with Always availability groups.

Install and configure SQL Server with minimum access privileges for service accounts and logins to improve security and attain high ratings in auditing.

Responsibilities include recovery, import/export, replication of data, and scheduling of tasks.

Duties included disk configuration, tuning, documenting architecture, and reviewing developers’ codes as they move through development, test, Stage, and production environments.

Implement Trigger to maintain data integrity and consistency.

Plan and coordinate database migration between systems and environments.

Administering cluster failover and load balance technologies as per client requirement.

Involved in periodic Disaster Recovery exercise in preparation for actual disaster.

Maintain, configure, and monitor database availability solutions. I.e., Mirroring, Log Shipping, Clusters, Availability Group, and Replication.

Analyze long running slow queries and tune the same to optimize application and system performance.

Recognition

Silver Award for Outstanding performance

Bronze Award for Outstanding Performance

TATA Consultancy Services 11/2011 – 09/2014

Client: Dow Chemical

Sr. SQL Server Database Administrator (DBA)

Provided 24x7 support for SQL Server databases to achieve maximum performance and uptime in production environment and systems with high availability requirements.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Established and maintained policies, database security, standard operating procedures, and associated documentation for user interaction with the database environment.

Managed SSIS/DTS packages, stored procedures, jobs, and alerts

Troubleshooting and resolving database integrity issues, blocking issues, availability issues, connectivity issues, security issues, etc.

Continuous upgrade of SQL Server from old version to new i.e., SQL 2005 to SQL server 2008/2008r2/2012

Configured database availability solutions like Failover Cluster, Mirroring, Log Shipping, Replication, and AlwaysOn.

Using SQL Server native tools, online resource, DMVs, third party tools, and various resources to diagnose performance issues and server reliability.

Designing and writing SQL Server reports (SSRS)

Migrated Database Instances, user databases, logins, users, maintenance plan, Jobs, packages, and database objects between multiple servers in Production, Test, and Development platforms.

Performed Disaster Recovery procedure, performance tuning, Backup/Recovery options, and database Security.

Worked with Application team, Server-OS team, Storage team, Network teams, and Security team to discern, fine-tune, and debug SQL Server and Windows related issues.

Pacific Systems Inc. 04/2005 – 11/2011

SQL Server / Oracle Database Administrator (DBA)

Implemented backups to network drive to replace obsolete tape backups. The backup duration was shortened from as long as 16 hours down to less than 2 hours, enabling companies to keep more backups online.

Provided 24x7 support for SQL Server databases to achieve maximum performance and uptime in the production environment.

Modified and tuned-running SQL queries to cut execution time, ease database load, and improve scalability.

Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS

Aided developers in writing efficient codes and making efficient use of the resources leading to better performance and optimization.

Supported the data loads into the database and ensured that the application and any enhancements interact efficiently with the database.

Developed and tested storage strategies and disaster-recovery plan for large manufacturing company's operational database, delivering solutions that guaranteed recovery performance and high availability.

Recommended database clustering to client for failover in disaster recovery and to enhance database high availability and data protection.

Education

Georgia State University, Atlanta, GA

B.Sc. Computer Science

Certifications

Azure Database Administrator Associate (DP-300)

SQL Server MS Certified IT Professional (MCITP)

SQL Server MS Certified Technology Specialist (MCTS)

Oracle Certified Associate (OCA)

Recognitions

Bronze Award for Outstanding Performance in 2015

Outstanding achievements in Computer Science

Outstanding achievements in Mathematics

Recipient of top performance award and perfect attendance

Reference

It will be provided on request.

Contact this candidate