VIJAYASARADHI SAMAVEDAM

Work History

Database Analyst/Technical Specialist

UPS Supply Chain Solutions

04.2019 - Current

Configured Azure SQL managed instance to migrate on prem databases to Azure
Performed migration assessment of on prem sql server before moving to Azure Instances
Created and utilized shared access signature to copy and restore database backups from on prem to Azure blob store onto SQL Managed instances
Used SQL migration tool to assess and analyze database compatibility issues
Configure Sliding window partitioning on VLDB databases to improve performance
Setup Geographically dispersed Read scale availability groups on SQL Server 2017
Upgrading Databases from SQL Server 2016 to SQL Server 2017 using Zero Downtime by using Database Mirroring
Set up Distributed Availability group between different datacenters on SQL Server 2016/2017/2019
Performing Weekly and Monthly releases according to sprint and Kanban schedules
Gathering Business requirements from Application stake holders and converting them to actionable projects
Database support on Migration projects for legacy systems from DB2/Mainframe to SQL Server 2019
Support Mission critical applications in both Ground transport and Airline Operations
Perform Server and Query level tuning as required by application requirements
Participate in Quarterly On call production support
Created and tested MSSQL instances on containerized solutions on Docker, Openshift and Kubernetes
Provide proactive performance tuning and capacity planning for UPS peak holiday season
Participate in all aspects of new application onboarding including Physical Data modeling, capacity planning, performance testing, Store procedure analysis and monitoring
Implement UPS standard Database security model for new databases for access requirements and implement security best practices
Perform Quarterly SQL patching on supported applications after regression testing in lower environments
Utilize Extended events to trace and tune store procedures
Built databases and table structures for web applications.
Managed database security, development and access of input systems.
Implemented security measures to protect vital business data.
Followed standard practices for migrating changes to test and production environments.
Wrote and maintained technical and functional specifications to document database intentions and requirements.

SQL Server DBA

Ciox Health

10.2018 - 04.2019

Setting up log shipping in standby mode for reporting purposes
Configuring Idera SQL diagnostic Manager with alert rules and templates for SQL monitoring
Planning for storage migrations of Availability groups between different data stores
Migrating Databases from SQL 2008/2008R2 to SQL 2014/2016
Configuring 3 node Availability group cluster with automatic failover on SQL 2017
Configuring Backups according to RTO and RPO requirements of the business
Performing Database refreshes from Production to Pre-production
Perform Dynamic Data Masking on Production data during refreshes adhering to HIPPA compliance
Working on setting up Development and QA and Production in AWS – RDS
Configure AlwaysOn High Availability between different Availability Zones on Amazon EC2
Configuring IAM and S3 buckets for Production VPC SQL Servers in line of Security requirements and RTO/RPO
Participate in On-Call rotations and day to day support issues
Applying Patches to SQL instances during maintenance periods
Participate in monthly deployments, perform workload tests in lower environments
Participate in Weekly sprints and standup meetings adhering to Agile Methodologies for project deliverables
Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
Developed custom database objects, stored procedures and delivered application support.
Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.

SQL Server DBA

IHG - InterContinental Hotels Group

07.2016 - 04.2018

Installed and configured SQL Server 2012/2014/2016 across datacenters as per internal company requirements
Working on consolidating the Environment to reduce Licensing and Operating costs to the company
Configured Always On Availability groups on SQL Server 2014/2016
Working on Migrating databases from SQL Server 2008/2008R2/2012 to 2014 and, Working on standardizing failover capabilities between datacenters using Cross Subnet Availability groups
Creating Backup strategies for Operations team
Working with Offshore resources to test and implement Veeam backups as per RTO and RPO
Setting up SSRS and SSIS infrastructure for reporting and ETL purposes
Working with application teams as required for the same
Testing and implementing patches every 2 months on the environment
Coordinating with offshore team for the same
Planning and documenting failover validations on AlwaysOn Availability groups for Disaster Recovery
Working to onboard Idera SQLdm monitoring system for the SQL infrastructure
Performing audits to obtain Database usage activity for consolidation process
Creating SSRS reports on Daily and Weekly basis for the management to provide an overview of current Enterprise summary
Creating and Populating Runbooks for Operations as and when required
Migrated SQL Clusters across data stores from EMC to Nutanix
Configuring Robo copy jobs to move backups from Local server to Fileshare clusters and Azure based storage management system (storsimple)
Working on POC project to have AAG cluster between 2 availability zones
Perform SQL Patching for GDR and monthly updates as they come out to be in line with best security practices

SQL Analyst

Global Logic

08.2010 - 10.2013

Installation and configuration of MS SQL Server 2008/2008R2
Setting up baselines for performance metrics
Extensively used perfmon to gauge and generate data points
Created ER diagrams
Involved in conceptual and physical modeling of data using Erwin tool
Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL)
Part of team for analyzing and implementing physical design for database
Creating Full, Differential backups per business requirements
Working with operations team for Patching, on call and DR activities
Configuring Failover cluster instances (Active – Passive) and (Active – Active)
Moving SQL Servers from Physical to Virtual environments with vSphere vMotion for consolidation
Responsible for transferring of database and database objects from Development to Production Server using DTS
Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures
Participate in patching SQL Server updates/servicepacks as per company requirements and standards
Awards and Recognitions, Most Valuable Professional

Summary

Overview

Work History

Database Analyst/Technical Specialist

SQL Server DBA

SQL Server DBA

SQL Analyst

Education

Master of Science - Computer Science, Commerce

Bachelors - Computer Science

Skills

Websites

Certification

Awards

Work Availability

Timeline

Similar Profiles

Akshata Prashant ChaudahriAkshata Prashant Chaudahri

Joe MontaganoJoe Montagano

Wilyenson BaezWilyenson Baez

Jasper IshigamiJasper Ishigami

Paul ComriePaul Comrie