Summary

Over * years of IT experience in designing, supporting and administrating databases on multiple technologies such as SQL Server, MySQL, MariaDB, PostgreSQL and Firebird DB.

Expertise in managing databases in cloud platforms such as GCP, Ability to differentiate the database workloads Cloud SQL and Compute instances, Deploying and Architecting solutions in cloud with cost and scale in mind.

Experience in upgrading SQL Server software to new versions, applying service packs, hot fixes and unattended Installation.

Experience utilizing various high availability (HA) and disaster recovery (DR) options for MS SQL Server.

Years of working knowledge on SQL Server high availability features such AlwaysOn Availability Groups, Failover clustering, Mirroring, Log Shipping and Replication.

Expert in migrating databases to GCP and migrating SQL Databases using Distributed Availability Groups.

Strong experience in Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Experience in Leading multiple enterprise-level projects concurrently, ensuring they align with business priorities and budget.

Strong experience in Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Education:

Completed Master’s in Computer Science.

Professional Experience:

Client: WideOrbit December 2019 to Present

Responsibilities:

Worked on 24*7 high traffic e-commerce OTLP environments. Designed and managed 100’s of highly OLTP SQL Servers.

Configured AlwaysOn availability groups and SQL failover clustering for high availability, Log shipping for disaster recovery.

Expertise in troubleshooting SQL AlwaysOn Availability Group issues.

Expert in SQL Server virtualization by baselining the production workload and sizing the hardware as per need.

Implemented seamless database migration from on prem to GCP Cloud and on-premises to AWS.

Worked on database technologies such as MSSQL MySQL, MariaDB, Firebird DB

Configured MariaDB and MySQL HADR solutions in both cloud and on-premises and Managed and Supported MariaDB and MYSQL.

Migrated MariaDB to SKYSQL cloud, Worked closely with SKYSQL team on migration efforts.

Configured and Migrated Firebird DB in both cloud and on-premises. Managed and Supported Firebird DB.

Implemented and supported MySQL, MSSQL Server & PostGres on CloudSQL platform.

Knowledge on Cloud Migration, Spanner, Big Query, Cloud Data Proc and so on.

Implemented monitoring on infrastructure and databases.

Involved in design meetings and helped developers in optimizing queries for better performance.

Designed databases for scalability and availability and cost effective.

In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.

Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.

Implemented patching schedule for both OS and SQL monthly. Developed plans and road map for patching, security, audit, capacity, products, and future enhancements.

Worked closely with various vendor-provided applications both on the Cloud and on-premises.

Working on Projects, coordinating with all the teams and in time project successful completion.

Individually handling projects internal and external applications.

Lead multiple enterprise-level projects concurrently, ensuring they align with business priorities and budget.

Manage onshore and offshore database platform teams, contributing to their growth by providing feedback.

Client: BB&T, NC July 2019 to Nov 2019

Responsibilities:

Administration and maintenance of 5000+ SQL Server Instances into DEV/UAT/PRE- PROD/PROD/DR environments.

Extensively engaged in PLM (Product lifecycle Management) projects.

Updating database systems by reviewing, planning, testing and installing database security patches and service packs.

Migrating Databases ranging from 2 MB to 75 TB from SQL Server 2008R2 to SQL server 2012 /2014/ 2016/2017 on both Prim and Azure.

Implemented high availability with AlwaysOn Availability Groups and failover clustering And AlwaysOn on servers migrated to SQL 2016 and built new servers with SQL 2016.

Created performance dashboard reports to analyze the system resource utilization, Index fragmentation and missing indexes.

Implemented all Major and Minor releases (QFE’s and Hotfixes) into pre-production and production environments and rebuilt the pre-production system on par with production prior to all major releases.

Automated most of the DBA stuff using Windows and SQL integrated PowerShell.

Used PowerShell to Automate backup and restore strategies in preproduction environments and to some extent of SQL installation.

Installed monthly mandatory security patches of Operating system and SQL to make the servers non-compliant to security breach.

Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.

Working on sending business communications to users and other team on scheduled downtimes, planning the downtimes and Implementation.

Working on Projects, coordinating with all the teams and in time project successful completion.

Individually handling projects internal and external applications.

Hand on Experience with Windows server, including Active Directory, VMWare

Experience in Setting up and managing VM, Storage & SQL Servers in Azure.

Experience using project management and task management software solutions, including - Microsoft Project, Jira, and Team Foundation Server (TFS)

Client: Microsoft-WA OCT 2017 to APR 2019

Responsibilities:

Administration and maintenance of 5000+ SQL Server Instances into DEV/UAT/PRE- PROD/PROD/DR environments.

Extensively engaged in PLM (Product lifecycle Management) projects.

Updating database systems by reviewing, planning, testing and installing database security patches and service packs.

Installed and upgraded from SQL Server 2000, 2005, 2008R2 to SQL server 2012 /2014/2016 on Multiple DEV / UAT / PRE- PROD/PROD/ DR Servers.

Migrating Databases ranging from 2 MB to 75 TB from SQL Server 2000, 2005, 2008R2 to SQL server 2012 /2014 on both Prim and Azure.

Implementing high availability with AlwaysOn Availability Groups and failover clustering And AlwaysOn on servers migrated to SQL 2016 and built new servers with SQL 2016.

Expertise in troubleshooting AlwaysOn issues.

Setup Maintenance Plans and SQL Server Agent Jobs in Upgraded Instances.

SQL Server 2014, 2012, 2008, 2005 databases and queries performance tuning.

In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.

Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.

Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.

Worked in Active / Active, Active/ Passive Cluster environment as a High availability solution.

Checking Database Health by using DBCC Commands and DMVs.

Experience using project management and task management software solutions, including - Microsoft Project, Jira, and Team Foundation Server (TFS)

Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.

Experience in Setting up and managing VM, Storage & SQL Servers in Azure.

Experience in architecting and designing technical solutions for Microsoft-centric solutions based on industry standards using any Azure IaaS, PaaS and SaaS capabilities.

Working on sending business communications to users and other team on scheduled downtimes, planning the downtimes and Implementation.

Client: T-Mobile, Bothell-WA Nov 2014– DEC 2016

Responsibilities:

Worked on 24*7 high traffic Retail OTLP environments.

Expertise on migration & upgrades from all older versions to new versions.

Configured failover clustering as one of the solutions of high availability and Log shipping for DR.

Implemented AlwaysOn on servers migrated to SQL 2014 and built new servers with SQL 2014.

Worked with customers on performance issues and built a reporting solution for server health.

As part of server consolidation, moved databases that are less utilized and analyzed their performance on shared environment.

Developed solution for monitoring resource policies and dependencies on failover cluster and wrote a script for clearing SCSI persistence reservation in case of disk failure issues during failover.

Coordinated and patched 700+ servers as part of bi-annual patching cycle.

Participated in DR exercise that involves bringing the databases online on 200+ servers with decreased RTO.

Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

Develop and maintain documentation for the control, security and integrity of the SQL servers and data.

Configured SCOM on all production servers and monitored them through a customized SCOM management pack.

Created performance dashboard reports to analyze the system resource utilization, Index fragmentation and missing indexes.

Involved in design meetings and helped developers in optimizing queries for better performance.

Built already an environment with SQL Server 2014 Always On and Virtualized SQL Server.

Working on Future Road Maps on SQL Server 2014, Virtualization, Implementation of Office 365 and Azure.

Plan future-state infrastructure (storage capacity planning, server SKU recommendations, short Stroking, Array Configuration recommendations, etc.)

Automate the processes using PowerShell and windows command shell.

Client: American Tire Distributors, Huntersville, NC May 2013 – Oct 2014

Responsibilities:

SQL Server 2005 and 2008 Performance tuning and replication for high availability on UAT and Production environment.

Configure various Windows 2003/2008 clustered and non-clustered environments to provide high availability and reliability web sites and applications.

Configured and Maintained Transactional Replication by initializing subscription with database backup on a 4TB database.

Configured Database Mirroring on a 4TB database for High Availability in case of a Disaster.

Configured Log shipping on multiple databases for Disaster Recovery and configured DB Mail automation for alerting.

Used SQL Dashboard reports for performance analysis.

Configured Active/Active and Active/Passive SQL clustered environment.

Install and Configure SSL Certificates to ensure security of the websites deployed on IIS6.0/7.0.

Responsible as the Subject Matter Expert for production environment and application(s).

Available for on call escalations and advanced break fix problems and problem management.

Facilitates and coordinates release management process and adherence to it.

Participates in major problem reviews, initiates requests for change and ensures compliance with operational and security policies

Capable of leading incident management team in trouble shooting issues and can identify potential problems in applications and advocate for solutions.

Client: Pittsburgh Glass Works, Pittsburgh, PA Jan 2012 – May 2013

Responsibilities:

Intensively worked on SQL Server 2008 and Configured in several servers which includes a fresh install and in place upgrade from 2005.

Setup redundant servers to avoid one-point failures using EMC DMX technology “Cloning” and SQL Database Mirroring for highly active servers.

Investigated data missing issues and helped Development team in finding the bugs in code.

As a service build engineer, on boarded lots of new applications and involved actively from the day of pre-baseline to till the go alive date.

Configured Resource Governor on production environments to comprise the resource between SQL server and Report Server.

On boarded all the pre-production and production servers to a single monitoring tool, System Center Operations Manager (SCOM) 2007, and used appropriate management packs to monitor the server side and SQL server configurations.

Monitored jobs on daily basis and created knowledge base articles to support level 1 & 2 service desk teams.

Installed monthly mandatory security patches of Operating system and SQL to make the servers non-compliant to security breach.

Optimized disk space by using Data Compression on Tables and Indexes, SQL lite speed backups for sql 2005 and SQL native compressed backups for SQL 2008.

Troubleshoot the performance issues using database tuning advisor, sql profiler and dynamic management views. Configured maintenance jobs to run in a non-active window to keep up the server performance.

Worked on NLB and SQL Cluster environments, efficiently used to reduce the downtime for the business users.

Provided KT to the newly hired team, and closely worked with the team in India and helped them in various aspects to solve the issues in time.

Swathi Matta

SQL Server DBA

Email:ad1t5d@r.postjobfree.com

Phone: 901-***-****

Contact this candidate