Experience

Persistent Technology, Inc.

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Database Administrator

  • Nov 2020 - Present

  • Installed, configured and administered Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure Virtual Machines. • Managed the Azure SQL environments and Migrated 50+ Databases to Azure. • Architected and implemented Always on Availability Groups as high availability and disaster recovery solution. • Developed and utilized a PowerShell script for unattended SQL Server installation and configuration as well as configuration of Windows Failover Cluster (WSFC) for Always on Availability Groups (AG) in multi-subnet cluster environment across data centers. The script was used to install and configure 30+ AG clusters having three replica servers each. The script reduced the time and resources it would take to install and configure SQL Server, WSFC, AG, and migrate logins, jobs, and other server related objects by 80% or more. • Administered Enterprise and Standard edition of SQL 2019,2016 and 2014,2012 instances in Always On, Failover Cluster as well as stand-alone Environments. • Performed Troubleshooting and performance tuning existing queries, stored procedures, functions and views. • Performed Capacity planning and optimization on DB storage and CPU requirements. • Expertise in creating different datasets, pipelines to copy data from On-premise to Azure, from Blob Storage to Azure PaaS. • Worked with Azure SQL Database Import and Export Service. • Configured and managed SQL Server maintenance plans using Ola-Hallengren maintenance scripts for backups, integrity checks and index optimization with update statistics. • Created SQL jobs to monitor log-backup delays, free disk space, and Always on Availability Group synchronization issues. • Resolved log file growth and disk space issues. • Modified the Ola-Hallengren maintenance script for log backup by creating multiple log backups that use bucketing systems to run in parallel so that log backups do not take longer than recurrence time. Show less



State Farm

• United States
• Insurance
• 700 & Above Employee

• SQL SERVER DBA

  • Sep 2018 - Oct 2019

  • Maintained the Integrity, Security, and Availability of MS SQL Server and PostgreSQL databases. • Ensured that all databases are backed up in a way that meets the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO). • Administered MS SQL Server 2016/2014/2012, PostgreSQL Databases level Security and utilized Auditing and Transparent Data Encryption (TDE). • Configured and Supported High Availability (HA) and Disaster Recovery (DR) strategies including Clustering and AlwaysOn Availability Groups. • Created and Monitored automated daily, weekly, and monthly SQL Server agent jobs/Maintenance plans such as but not limited to Database Backups and Restore, Database Integrity Checks, Index Rebuild/Reorganize, Update Statistics and Maintenance Clean up Tasks. • Monitored, Tuned, Troubleshoot and Resolved issues including but not limited to SQL Server performance, database integrity, locks and deadlocks, connectivity, security using windows and SQL performance monitoring tools (i.e. Extended Events, SQL Profiler, Performance Monitor, Activity Monitor, Store Procedures, DBCC, DTA and DMVs). • Designed, implemented and maintained database schema, entity relationship diagrams, data modeling. • Developed parameterized and non-parameterized stored procedures, functions, triggers, views, and other T-SQL codes. • Created Databases, Tables and Table partitioning on large Tables. • Configured Database mail, Operators, Created Alerts and Notifications. • Performed patching on SQL Server 2014/2012, Windows server 2012, Windows server 2008R2 and Linux servers. • Installed, configured, and managed SQL server instances, SSRS and SSIS Data Integration in development, test, and production environments. • Deployed periodic reports based on the analysis of the data using SQL Server Reporting Services. • Developed complex SSIS packages to Extract, Transform and Load (ETL) data from different data sources and Deployed SSIS packages in staging and production servers. Show less



The Walt Disney Company

• United States
• Entertainment Providers
• 700 & Above Employee

• Manual QA analyst

  • May 2017 - Aug 2018

  •Responsible for gathering Business Requirements, Functional Requirements and Design Documents. •Performed Functional, Negative, Positive, Integration, Regression, End to End and User Acceptance Test •Extensively involved in writing and designing templates for the Test Plans and Test cases. Identified and isolated software defects and reported them via JIRA. •Worked with the Developers and the Test Lead to verify the Test Cases. •Designed and Analyzed Test case design document basing on the Functional Requirement Specifications to implement through testing process. •Analyzed and Developed Test Plan, Test Cases, Test Scripts, Expected Test Results and Test Procedure from functional requirement •Supported End-to-end testing for downstream systems. •Loaded the Test Data into the HPQC to prepare for the execution of Test Cases •Involved in Task Creation, Task Estimation, Task Distribution, Task Prioritization and Communication between Onsite and Offshore Team Members. Tools include JIRA for project management and defect tracking, HP ALM for test case creation and execution, and Confluence for sharing all requirement docs and guidelines, and Swagger tool to maintain all JSON test data scripts. •Reviewing and Analyzing Functional Requirement documents, Maintain Test Cases and Defects in ALM. •Interact with end users and investigate issues related to the QA. •Used Quality Center to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting. •Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution using Quality Center •Prepared and presented weekly and monthly QA Defect and Status Reports to the different Stake holders of the project using Quality Center. •Reported debugging using Informatic and tracked defects using HP ALM Quality Center •Maintained bug lists for critical issues using Quality Center. Show less