We provide IT Staff Augmentation Services!

Senior Sql Server Dba And Azure Consultant Resume

SUMMARY

  • A Microsoft Certified Senior SQL Server DBA with 14+ years of IT Experience with AZURE Data Architect in Production Support Database Administration in Windows Environments and also Application support experience using Microsoft SQL Server 2000, 2005, 2008/2008 R2, 2012, 2014, 2016,2017 and 2019 MySQL, Cassandra and COSMOSDb.
  • Quick learner Technical lead and good team player, strong interpersonal and Communication skills combined with self motivation, initiative and ability to think outside the box.
  • Having Experience in Azure Data Architect - Data Lake, Data Factory, Data Bricks, SaaS, IaaS capabilities, and experienced in designing and building MS SQL databases with in Azure.
  • Worked on SQL Server Upgrades from 2005/2008-R2 to SQL Server to SQL Server 2016 2017 and 2019. Both Side-by-Side and in-place upgrades.
  • Participate in internal and customer meetings assisting with the ongoing evolution of technology offerings in SQL Server TDE, Data Compression and Table Paritionining
  • Specialist in resolving issues relating to SQL Server Install/Upgrade failures.
  • Installed/upgraded 800+ SQL Instances of 2005/2008/2008 R 2/2012/2014/2016 Clustered Servers of Dev/QA/UAT/Production Environments till date.
  • Installed and Maintained Multi-Node SQL clusters. Max being 7-Node Windows Cluster with 20 SQL Clustered Instances on it.
  • Define cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure.
  • Migrated multiple SQL Servers (2008R2 to 2017) and databases to MS Azure cloud.
  • Migrated Multiple SQL Servers and databases from Vmware, Phsyical (On-Premises) and SQL Database servers to Azure Cloud incuding failover cluster.
  • Handled and maintained the largest database of 25 TB in size.
  • Enabled and configured more than 100+ Always-On feature in both same subnet and multi subnet on SQL 2012, SQL 2014, and 2016.
  • Migrated SQL 2008R2, 2012 Databases to My SQL and Maria Db.
  • Having experience automating SQL Server daily tasks using PowerShell, Automated SQL Server patching, Disk Monitoring and Inventory collection.
  • Worked closely with customers to help them in setting their migration plans.
  • Experience in implementing different types of Replication modes like Snapshot, Transactional, and Transactional with Subscriber Updates, and merge.
  • Worked extensively and implemented Transparent Data Encryption (TDE) on databases as per Customer requirements.
  • Worked extensively on Performance Tuning and Query Optimization of TSQL queries/procedures.
  • Worked extensively on SSIS Package designs for Import/Export from various data source like flat file and Excel to MS SQL Server and vice versa.
  • Worked extensively on SSRS reports designed and deployed the reports into the Reporting Server and automation the e-mails to the Customer.
  • Backup, Design of SSAS Cube and restoration of the Cubes, assigning permissions on the cubes.
  • Installation and configuration of SSIS, SSRS, and SSAS Servers.
  • Having knowledge and experience in DDL, DML, Physical and Logical Data Modeling working along with development team.
  • Created a SQL Server Environment Dashboard using Power BI tool.

TECHNICAL SKILLS

Database: Microsoft SQL Server 6.5, 7.0, 2000, 2005, 2008, R2, 2012, 2014, 2016, 2017. My SQL 5.5, 5.6 and 8.0. NoSQL - Cosmos Db and Cassandra

Operating Systems: Windows Server 2019,2016,2012,2008\R2 and RHEL, Ubuntu

Language: T-SQL, Power Shell and Bash

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS), SSIS, SSRS, SSAS, SSRS, Power pivot, Power shell, Power BI and SQL Nexus

Tools: Used For ITIL: BMC Remedy 6.0/6.5, Manage Now, AHD (Advanced Help Desk), SDM, Maximo and HP Service Center.

Third Party Tools: TDP, VEEAM, Lite Speed, IDERA, Symantec Net-backup, and SQL-Nexus

Cloud Technology: Microsoft Azure IaaS, PaaS

PROFESSIONAL EXPERIENCE

Confidential

Senior SQL Server DBA and Azure Consultant

Environment: SQL Server 2000/ 2005/2008/2008 R 2/2012/2014/2016 MySQL, Cassandra and CosmosDb.

Responsibilities:

  • Manage database administration team and technical expertise for more than 2,500 SQL Server instances ranging in size up to 25 terabytes, including all types of complex data replication.
  • Supervise 9 offshore DBA’s as the primary managed services contact, providing training and technical support, as well as publishing and enforcing standard operating procedures.
  • Develop strategic recommendations to business leadership partners, presenting information to deliver world-class database solutions.
  • Architect large SQL Server database projects, compiling business requirements and providing additional engineering and end-user support.
  • Having experience automating SQL Server daily tasks using PowerShell, Automated SQL Server patching, Disk Monitoring and Inventory collection.
  • Design standards related to database administration, performance evaluation and technologies used for maintenance and data replication.
  • Served as project lead for the development of company's retail pharmacy systems mainframe interface, engineering a SQL Server database infrastructure that serves as central repository for 900 retail pharmacies.
  • Automated SQL install and configuring parameters on 2014,2016 and 2017 using powershell.
  • Engineered and implemented a central database server infrastructure that included a 7-node SQL Server cluster serving as a load-balanced replication re-publisher for pushing data to the pharmacies and transactional replication distributors for trickle-feeding data from the stores.
  • Initiated multiple SQL Server upgrades, first from 2000 to 2005, then to SQL Server 2008R2, including engineering and orchestrating hardware and other infrastructure upgrades.
  • Expert-level skill and knowledge and experience in Data Warehouse concepts, including data mining, data marts, on-line analytical processing (OLAP).
  • Implemented the TDE (Transparent Data Encryption) in all the Production servers to secure the payment details and also in order to follow the PCI standards.
  • Migrated SQL 2008R2, 2012 Databases to My SQL 5.6 to reduce Lincensing Cost.
  • Supporting My SQL 5.5, 5.6 and 8.0 involes all database administration activites.
  • Having hands-on experience in migrating SQL Server and databases to AZURE cloud.
  • Migrated Multiple SQL Servers and databases from Vmware, Phsyical (On-Premises) and SQL Database servers to Azure Cloud incuding failover cluster.
  • Worked on SQL API in CosmosDb and created collections, including multi master.
  • Worked on Casandra No-SQL database including Admin activites.

Confidential

Technical Consultant

Environment: SQL Server 2000/ 2005/2008/2008 R2

Responsibilities:

  • Working on 1500 SQL server instances analyzing, implementing and testing for critical banking domain.
  • Verifying architect, management and development reports and documents.
  • Working in Service Activation, Deactivation of SQL Servers.
  • Reviewing Solution Architecture Document and providing technical inputs.
  • Ensuring the availability and recoverability of the applications is not impacted in transition.
  • Involves all kinds of activities such as planning, installing, configuring and performing DR for SQL Servers.

Confidential

SQL Server DBA

Environment: SQL Server 2000/ 2005/2008/2008 R2

Responsibilities:

  • Building SQL Servers in new data center.
  • Accountable for architect, management and development in a reporting environment.
  • Analyzing, implementing and testing responsibilities.
  • Ensuring the availability and recoverability of the applications is not impacted in transition.
  • Involves all kinds of activities such as planning, installing, configuring and performing DR for SQL Servers.

Hire Now