Sql Database Software Development

Jyothirmaye Aravapalli

Mobile No: 336-***-****

Email : ***********.**********@*****.***

Experience Summary:

* ***** ** ********** ** in SQL Database administration, supporting databases in Banking, Life science and retail domains. Involved in installation, configuration and maintenance of MSSQL da- tabase systems in Windows environment. Experience in conducting and coordinating disaster re- covery test. Good knowledge of the IT Service Management and improves the quality of services provided to the customer by best ITIL practices.

Has good communication and interpersonal skills and is responsible for handling critical customer infrastructure.

Below are the highlights in managing the team

• Experienced in different software development methodologies like Water Fall Model, Iterative model and Agile Methodology

• Experience in MSSQL DBA skills such as Database Creation, Database Maintenance, Database Backup and Recovery, Database Tuning, Security, and Migration

• Coordinated with business users and onshore team in resolving user tickets.

• Provide recommendations to management on long term capacity plans.

• Manages database projects, monitors project schedules, progress and costs to ensure work is completed on time and within budget

• Participates in the implementation of database architecture and strategies, and in the defini- tion of standards for the database environment

• Installing, configuring and managing MSSQL server databases in Azure cloud & on-prem- ise environment

• Analyzed tickets trend, proposed and participated in many process improvements to cut down tickets and this resulted in a large cut down of IT effort, cost savings for the client.

• Developed a strong understanding of the new enhancements added to the system and pro- vided optimized solutions to incorporate new functionality into the existing production pro- cess stream.

• Coordinated team development activities, mentored new team members.

• Co-ordinating datacenter maintenance activities

Educational Qualifications

BTech - 2008

Technical Skills

Operating Systems Microsoft Windows server 2003/2008/2008R2/2012/2012R2/2016 Database SQL-server 2008, 2008R2, 2012, 2014, 2016, 2017, Azure SQL database Cloud Azure basic

Tools SQL Server Management Studio, BMC remedy, Heat ticket applica- tion, Service now, Control-M job scheduler, Task scheduler in win- dows server, Argent job scheduler, Jira, Azure devops Experience

CareMore

Oct 2019 – Till date

Role and Responsibilities:

Discover better healthcare through advanced primary care and palliative care from Carelon Health, where we focus on the health of the whole person.

Role and Responsibilities:

• Involved in entire SDLC activities of the project including, requirement gathering from the business owners of the product, performing analysis on the requirements, providing design solutions, discussing the technical and non-technical aspects on the design with concern tech teams, developing and testing the end-to-end application.

• Using Agile development on this project. Involved in Sprint planning, Sprint reviews, Daily Standups and retrospective sessions.

• Analyze the business requirements and find the data if already exists or create data to test out the feature during development and post development.

• Install and configure SQL Servers and apply service packs as needed. This supports Mi- crosoft releases to keep our system up to date and compliant.

• Setting up of backups, recovery models, DBCC commands, testing of backups to ensure we can meet the business recovery time

• Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention

• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues

• Acts as an expert technical resource to development staff in all phases of the development and implementation process

• Experience with database tools like Solarwinds DPA, PRTG, Avamar

• Participate in planning and implementation of disaster recovery plans

• Assist in the monitoring, review of the performance and quality of service provided by the infrastructure

• Experience with AlwaysON Availability groups, clustering, replication, log shipping, mirror- ing and replication techniques

• Perform all database management responsibilities in Microsoft Azure for production and non-production workloads

• Monthly and hotfix Deployment of scripts on production and non-production environments

• Maintaining JIRA which includes creating stories, tasks/sub-tasks, creating the bug tasks etc

• Using SOAP UI and Postman for testing services

• Supporting code changes during system integrated testing, user acceptance testing and post pro- duction.

• Review Code changes before pushing them into Bitbucket Matrixcare INC

April 2017 – Oct 2019

About Project:

MatrixCare is the complete solution for growing organizations that need to successfully manage risk in care delivery across the LTPAC spectrum. Trusted by more than 13,000 facility-based care settings and more than 2,500 home care, home health and hospice organizations, MatrixCare’s solutions help ACOs, skilled nursing and senior living providers, life plan communities (CCRCs), and home health organizations to connect, collaborate and prosper as we migrate to a fee-for-value healthcare sys- tem. In addition to purpose-built EHR components for any LTPAC care-setting, MatrixCare also in- cludes solutions to systematically increase clinical quality: Enterprise Analytics, robust Clinical Deci- sion Support and the industry’s first Care Coordination platform to create a true, person-centric, e- longitudinal health record and enable LTPAC providers to efficiently manage the populations under their care.

Role and Responsibilities:

Involved in entire SDLC activities of the project including, requirement gathering from the business owners of the product, performing analysis on the requirements, providing design solutions, dis- cussing the technical and non-technical aspects on the design with concern tech teams, developing and testing the end-to-end application.

Participated in Daily stand-up’s, Sprint Planning, Retro meetings, and backlog Refinement meetings as part of Agile and SCRUM methodologies.

Install, configure, upgrade and administration of SQL Server 2008R2, 2012, 2014, 2016, 2017 standalone and perform maintenance tasks of the database.

Database storage and capacity monitoring and forecasting

Provide recommendations to management on long term capacity plans

Monitors project schedules, progress and costs to ensure work is completed on time and within budget

Participates in the implementation of database architecture and strategies, and in the definition of standards for the database environment

Experience in MS SQL DBA skills such as Database Creation, Database Maintenance, Database Backup and Recovery, Database Tuning, Security and Migration

Building knowledge base articles for the production issues which will be useful for other team mem- bers to address the production issues on time within SLA

Representing Database tower in change advisory board calls and analyzing the impact of changes that are scheduled to implement on production database, provide necessary inputs for the changes to avoid or less production impact

Installing, configuring and managing MSSQL server databases in Azure cloud environment

Coordinated team development activities, mentored new team members.

Planning, coordinating, implementing Disaster recovery tests

Co-ordinating datacenter maintenance activities

UPS, February 2015 – March 2017

About Project:

United Parcel Service, Inc. is an American multinational shipping & receiving and supply chain man- agement company founded in 1907. Originally known as the American Messenger Company special- izing in telegraphs, UPS has expanded to become a Fortune 500 company and one of the world's largest shipping couriers.

Role and Responsibilities:

• Working in Agile Environment, attended daily Scrums, backlog refinement meetings, Sprint planning every other week followed by Sprint retrospective meetings.

• Install, configure, upgrade and administration of SQL Server 2005, 2008, 2008R2 and 2012 standalone builds and perform maintenance tasks of the database.

• Monitor and troubleshoot various database issues.

• Monitoring space on the server, handling issues with Log files, Shrinking Log and data files and tuning of DB performance using SQL Profiler and Execution plans.

• Applying service packs (SP’s) on SQL Server 2005, 2008, 2008R2 and 2012 for standalone servers.

• Performed and managed database administration to ensure database availability and enable the proper database monitoring.

• Identifying and Resolving Mirroring related issues.

• Performed database deployments and involved in upgrading maintenance plan.

• Coordinated with business users and onshore team in resolving user tickets.

• Analyzed tickets trend, proposed and participated in many process improvements to cut down tickets and this resulted in a large cut down of IT effort and cost savings for the client.

• Developed a strong understanding of the new enhancements added to the system and provided optimized solutions to incorporate new functionality into the existing production process stream.

• Coordinated team development activities, mentored new team members.

• Created application guidance documents, KT documents for the team.

• Point of contact for all MS SQL activities.

• Management of L1 team and involved in other management activities like ticket audit, shift roaster, monthly reports, weekly reports and other SQL reports. Abbvie Inc, June 2013 – January 2015

About Project:

Diversified pharmaceuticals health care companies. They have 90000 employees and operate in over 130 countries. The Objective of the project is to support the Pharmaceutical Product Labeling System (PPLS) application used by Abbott laboratories. Role and Responsibilities:

Installing and configuring SQL Server.

Automating database maintenance with SQL Server Agent by creating jobs.

Creating and Monitoring the Maintenance plans – scheduling tasks to run daily and/or on week- ends tasks like rebuilding indexes, Shrink Database, and Database backups.

Monitoring SQL Server Jobs and Troubleshooting on failure.

Daily checks for server includes – Disk Space, Database backups, SQL server services running status

Monitoring ticket queue

Routing L3 tickets to primary DBAs and coordinating those tickets if needed.

Contact this candidate