SUMMARY

• Around 9 years of experience in Administration using MS SQL server 2005/2008/2008 R 2/2012/2014/2016/2017 and Oracle systems in Azure and AWS OLTP and OLAP environment.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Worked on setting up Jenkins for deployments over lower environments like UAT’s, Stage, Qa and Dev machines
• Implemented side by side and In place Migration (Data center) of MS SQL server 2005 to 2008R 2/2012/2014/2016 and applied Patches and Service packs to update different versions of MS SQL server.
• Developing functional process diagrams for IBM DB2, POSTGRES, ORACLE database services
• Proficient in SQL server 2008 features like Data compression, Resource Governor, Backup Compression, Mail setup, Jobs, Alerts and Database Tuning Advisor.
• Experience in implementing and setting up DR Disaster Recovery and HA High availability solutions like different Clustering (Active - Active) and Replication
• Experience in regular maintenance activities like Query Tuning, statistics update, Index rebuild, log file monitoring, temp DB monitoring, handling blocking, deadlock resolutions, and fragmentation issues.
• Explicitly used third party tools like Netapp, Lite speed and SQL sentry
• Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.
• Implemented Data center migration with cross platform implementation on AWS EC2 instance using DMS.
• Hands on experience in implementing Managed Service Accounts MSA’s on SQL services.
• Good Knowledge on using Power shell commands for Server performance.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
• Experienced with deployments, Maintenance and troubleshooting applications on Microsoft Cloud infrastructure Azure and Snowflake Cloud Data platform.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and Windows logs for hardware related errors.
• Experience in Network TCP IP, SSL and Firewall trouble shooting issues.
• Experience in documenting the Root Cause Analysis for various issues like memory and outage of database and related hardware failure.
• Knowledge on IBM DB2, Postgres SQL data warehousing concepts using Linux\Unix.
• Auditing of database for user’s transaction, login, database action and removing orphan users.
• Cleared Payer HIPPA certification for PHI related compliance.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, SnowFlake Cloud, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Data Bricks, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.
• Extensively used Repositories like Team Foundation Server (TFS) and Clear Case for Data Archival.
• Handled numerous Change Management requests on production servers.
• 24 X 7 Production Database on Call Support.
• Flexible, Enthusiastic and project oriented team player with excellent communication skills and analytical skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

Operating Systems: Azure Cloud, VM, MDOS, Windows, Tomcat, NT/ 2008/2010/2012 R2/2016/2019

Databases: MS SQL Server 2017/2016/2014/2012/2008 , Oracle R 2/2008/2005/2000 , MS Office, Access 97/2000/2003

ETL and REPORTING Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data transformation services (DTS), SMTP server services

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, perfmon counters

Third Part Tools: Jenkins, Bamboo, Boomi, Spotfire, Lite speed, Nagios, Fog lite, Red gate, Web services, SQL sentry, DbAmp.

Languages: T-SQL, SAS, XML, Python, HTML, XHTML, Power Shell, Linux & Unix.

PROFESSIONAL EXPERIENCE

Confidential

ETL DBA

Responsibilities:

• Migrating Datacenter and SQL Databases from Big Data, Sql server 2008R2 to Sql server 2014\2016 on Azure Platform using RDS.
• Experience working with SnowFlake Cloud Performance Metrics and Plan Management.
• Good Understanding & Knowledge 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)
• Analyzing long running slow queries and fine tune the same to optimize application and system performance.
• Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets.
• Migrating into Oracle and Salesforce for flexible, cost- effective, reliable, scalable, high-performance and security using DBAmp
• Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running PL\SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Fixed issues in network level of RDBMS like TCP IP, SSL and CertAuth.
• Experience in identifying root cause analysis and fixing the Tomcat, Windows/IIS Web Server/FTP Related issues.
• Experience designing and optimizing high-performance databases
• 1+ year(s) cloud (Azure & Snowflake) DBA experience.
• Ability to create dynamic views from Databricks & Snowflake
• Extensively worked on Transparent Data Encryption (TDE) and Auditing
• Performance tuning of databases by windows performance monitor and SQL Profiler.
• Worked on Data modelling using Erwin tool using Cassandra, Hadoop Big data.
• Used Index tuning wizard to redesign and created the indexes for better performance

Confidential

Azure SQL DBA

Responsibilities:

• Integrated Subversion and SQL agent jobs with Jenkins to implement the continuous integration\daily operational process.
• Migrating Databases from Oracle and SQL 2008R2 to Azure Sql server 2016\2017.
• Provide 24*7 Application availability using Auto scaling Services, including configuring, defining and testing auto scaling policies and created alarms to call scale up/down policy.
• Installed Distributed Availability groups for Better HA and DR.
• Analyzing long running slow queries and fine tune the same to optimize application and system performance.
• Deploy, monitor and manage applications in Azure cloud using Team foundation server (TFS) into Development, Test and Production web and application server environment.
• Used Azure Databricks for daily BI support and Analytics purposes.
• Worked on Data modelling concepts using Erwin tool using Oracle 11G, Postgres, DB2, Hadoop Big data.
• Migrating into Azure Managed Instances on cloud for flexible, cost- effective, reliable, scalable, high-performance and AD Group security
• Worked with the table partitioning mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Automating backups using Powershell scripts to transfer data in DR bucket.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Creating alarms in Cloud and production environments watch service for monitoring server’s performance, CPU Utilization, disk usage etc.
• Identified and resolved database PTO performance tuning and Optimization issues, database capacity issues and other distributed data issues.
• Experience in working on source controller tools like TFS, CVS, IBM Clear case, and GIT.
• Experience in installing, configuring and deploying Jenkins .
• Experience building infrastructure as code.
• Creating scripts that generate reports to proactively monitor the environment
• Migrating Payer databases to datacenters to Azure(cloud) and DataBricks, while maintaining them on daily activity basis
• Designed User Defined Routes with custom route tables for specific cases to force tunneling to the Internet via on-premise network and control use of virtual appliances in the customer’s Azure environment.
• Designed Databases for data integrity and queries execution efficiency applying knowledge of SQL Server 2017 and Azure Databricks
• Creation of cloud formation Templates of existing environments to use in building similar environments in the same or different regions for HA High Availability
• Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.
• Experience in IaaS and PaaS in a hybrid cloud environment working with private and public cloud service providers
• Created a discussion group for cloud support team in shared point and maintained all documentations in SharePoint.
• Key member of a Managed Services team that installs, configures and maintains Software, Databases and Web applications .
• Experience working with Agile/Scrum environment.

Confidential

Database Administrator

Responsibilities:

• Installed and Upgraded from Sql Server 2008 to Sql server 2014 & 2016 on various Production Servers R2 and upgraded to their respective Service Packs & cumulative upgrades.
• Implemented Sql Data Compression using Sql server 2008 for compressing data and Log Files, Back Up Level.
• Installed SQL Server 2014 HADR Failover cluster.
• Oracle PLSQL standalone and RAC clustered (11g, 12c) database environments.
• Worked on Cross Database Platform Migrations from SQL to IBM DB2 and Oracle 11g.
• Migrating Databases from Sql server 2008 to Sql server 2014\2016.
• Worked with the table partitioning mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Extensive experience with clinical (Patient, Pay) data
• Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.
• Identified and resolved database performance issues, database capacity issues and other distributed data issues.
• Experience in ETL Migrating Assistant DTS 2000 packages to SSIS packages in 2005 using Migration Wizard and Kafka.
• Analyzing long running slow queries and fine tune the same to optimize application and system performance.
• Used Power BI, IBM DB2 using Unix for data warehousing concepts
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Used Tableau for presenting front end data and represent the backend data visualization.
• Solving Tickets on Daily Basis for Cassandra OLTP Production Issues.
• Performed Backups, restores of databases using Lite Speed tool.
• Checking Payer Database Health by using DBCC Commands.
• Supporting production team & developers while being On Call DBA.

Confidential

Sr Database Admin

Responsibilities:

• Managed and administered SQL server 2005\2008\R2\2012 servers
• Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012
• Configured Windows Fail Over Clustering and SQL Clustering on Multi Subnet Cluster
• Migrating Databases from SQL Server 2008R2 to Teradata and Netezza DB systems.
• Worked on good standard Python, T-SQL queries by using different store procedures, Triggers, Indexes, Views.
• Configured Active Directory to create users and login groups to access failover clustering
• Deployment of databases, jobs from pre-production to production
• Performed installations of SQL 2005\2008\2012\2014 on clustered and standalone servers
• Worked on moving SQL databases to DR location on Azure Cloud.
• Upgradations of sql server versions and applying patches and hot fixes
• Adding nodes to already existing clustered servers as a part of data load\High availability
• Configured DR Transactional Replication and Log Shipping with SQL Server Management
• Implementation of SQL server logins, Roles and Authentication modes as a part of AD security policies
• Configured SnowFlake Databases with Database mail, linked servers.
• Extensively worked on Transparent Data Encryption (TDE) and Auditing
• Performance tuning of databases by windows performance monitor and SQL Profiler
• Used Index tuning wizard to redesign and created the indexes for better performance
• Fine-tune Stored Procedures using Execution Plan in T-SQL for better performance.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs
• Tune slow running queries using SQL Server Profiler for PTO issues
• Worked with database tuning advisor, SQL server profiler, Performance counters and activity monitor for Performance tuning
• Used DBCC and DMV commands for day-to-day troubleshooting tasks
• Import data across multiple instances using BULK INSERT and BCP Utility
• Involved in Capacity Planning, Database Normalization and De-normalization process
• Optimize the database server using DMV’s and DMF’s and performed a code review and tuning for the best performance of the application
• Disaster Recovery Planning, Testing and analyzing and continuous update of documentation.