Sql Server Information Technology

Ravi Babu Vellanki

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

Contact No +1-703-***-****

Objective

To be part of a progressive organization that allows me to leverage my knowledge and skills in Information Technology, while pursuing challenging opportunities that foster both personal and professional growth.

Profile Summery

As an experienced MSSQL Server Developer with strong DBA expertise, I offer a unique combination of technical skills and industry knowledge, particularly in the banking and healthcare sectors. My proficiency in Microsoft Azure, ETL processes, and Azure development allows me to design and implement efficient data solutions that drive business outcomes.

I have a proven track record of delivering high-quality database solutions that optimize performance and enhance data accessibility. My understanding of industry-specific business processes enables me to tailor solutions that meet stakeholders' unique needs. Additionally, I possess excellent communication and interpersonal skills, facilitating effective collaboration with cross-functional teams.

My enthusiasm for technology and commitment to continuous learning ensure that I remain at the forefront of industry trends, contributing to innovative and effective solutions. I have thorough knowledge of Microsoft SQL Server 2016, 2017, and 2019 on Windows operating systems, and I bring four years of experience with Microsoft Azure, including Synapse Analytics, Dedicated SQL Pools, Azure SQL Database, Data Lake Gen1, and Data Factory.

Database Administrator: -

Experienced in handling administrative tasks, database monitoring, diagnosing, and resolving database issues efficiently.

Collaborated with customers to understand problem statements and use cases, translating them into tangible technical requirements.

Excellent experience in Upgrading SQL Server lower versions to higher versions

Managed a large 38TB single database, developing and implementing an effective maintenance plan

Expertise in T-SQL, including writing stored procedures, triggers, and functions.

Proficient in designing cloud and hybrid solutions on Microsoft Azure, covering network infrastructure, storage, business continuity, monitoring, and security.

Experienced in RDBMS database design, performance tuning, optimization, and backup and recovery across SQL Azure, SQL Server 2008/2012/2014/2016, and 2019.

Skilled in SSIS, SSRS, and SSAS technologies.

Expertise in high availability (HA) and disaster recovery (DR) solutions, including Always On, mirroring, and log shipping.

Experienced in Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) for sensitive data within SQL Server.

Configured log shipping in SQL Server 2008 R2, 2012, and 2014.

Configured transactional, snapshot, and merge replication.

Developed, tested, and deployed database standards, processes, and procedures across various environments.

Documented SQL Server issues and implemented necessary solutions.

Expertise in Reporting Services with a basic understanding of Analysis Services.

Conducted database consistency checks using DBCC and DMVs.

Excellent knowledge of logical table partitioning from SQL Server 2005 onwards.

Strong understanding of VMware and virtual server configuration for SQL Servers.

Data Engineer: -

Identify right Azure SQL Server deployment option, purchasing model and service tier according to requirements and will be able to deploy it in cloud

Deploy Azure Synapse Analytics (formerly known as Azure SQL Data warehouse) in Azure Cloud environment

Analyze on-premises data warehouse and migrate data to Azure Data Warehouse.

Well experienced in Azure famous MPP (Massive Parallel Processing) architecture

Designing data models and database schemas for data warehousing and data analytics purposes

Experienced in different migration methods and best practices

Configure Polybasic to access external files into SQL Server.

Implementing disaster recovery and backup strategies to ensure data availability and business continuity

Provision Azure Database in Virtual Machine (IaaS)

Deploy Elastic Pool Database and able to add/remove more databases from the pool

Deploy the Managed Instance Database, configure it and connect with your SQL Server Management studio

Server-less SQL pools to develop table structures to replicate data from an Oracle data source

Experienced in managed and unmanaged services.

Well experience in Resource group maintenance.

Experience in designing and implementing applications using PaaS Services in a hybrid Azure environment

Well experience in IaaS (Infrastructure), PaaS (Platform) and SaaS (Software as a Service)

Experience in Storge & Data Distribution (Hash, Round-robin, Replicate)

Experience in Partitioning and Distribution key using Colum store, Heap, Cluster B-tree index

Analyzing data distribution before migration to Azure

Configure High availability in managed instance

Professional Experience

Discover Financial Services, SLC March 2014 – Till Date

Recovery DM (Debt Manager) supports the daily activities of business users within the DFS Banking Recovery Management System. Users leverage the DM tool to manage charge-off accounts, assign them to appropriate third-party vendors for collections, and recall accounts once they are recovered. The system also enables the removal of accounts from DM9 and the generation of comprehensive reports. DM9 enhances collection efforts, improves agent productivity, and ensures compliance.

OTIS-Lending (Student Loans) involves the migration of Discover Lending's legacy systems into the Debt Manager platform, providing enhanced functionality to better meet customer and business needs. A data warehouse has been developed to facilitate the migration of legacy data into the new system.

Additionally, the Server Upgrade Project encompasses the migration of database Windows and Linux servers for Debt Manager that have reached their end of life. This includes transitioning to new servers built with updated hardware.

Provided expertise in Data Warehousing ETL, data cleansing, merging data, maintenance task

Create and maintain secure database backups for all critical SQL databases

Implementation of SQL Server Upgrade from 2016 to 2019 and 2022

Tuning and Optimization of Transact – SQL, Stored Procedures

Installation and configuration of SQL 2014, 2016, 2017, 2019 an

d 2022 Standard and Enterprise

Restoring backups from production databases after removing sensitive data

Database consistency checks using DBCC and DMV’s

Configuring SQL 2016 Availability groups in multi subnets.

Appling SQL Server SP’s & security patching periodically.

Articulate and document: ETL Strategy, OLAP Strategy, Database Sizing, Security implementation, Test Strategy, and deployment strategy.

Take care of the Database design and implementation

Direct and design the information delivery and access for the data warehouse.

Classified key business drivers for the data warehouse.

Configure Replication and troubleshooting

Creating Single, Elastic, and managed instance as per requirement.

Help developers to Migrate databases on- premises to cloud

Using Auditing to track database events to analyze investigate database activities to identify potential threats

Create Dedicated SQL Pool for individual application.

Loading data with SSIS, PolyBase and data Factory

Create Pipelines in different data source for moving data efficiently.

Help Transparent data encryption data masking configuration.

Help them about managing cost and price optimization

Resource health, support, and troubleshooting

Delete unwanted resource and save cost

Take care of the Database design and implementation

Direct and design the information delivery and access for the data warehouse.

Classified key business drivers for the data warehouse.

Configure Replication and troubleshooting

Configure mirroring and troubleshooting

Configure Tags as per requirement

Configure mirroring and troubleshooting

Designation: Lead database administrator

Environment: SQL Server 2022, 2019, 2016, 2012, 2008, SSIS, SSRS.

Wipro Technologies (A, B, C, D and E)

A.Capital One Financial Corporation Oct2013 – Dec2014

Capital One Financial Corporation is a U.S.-based bank holding company specializing in credit cards, home loans, auto loans, banking and savings products. In terms of total assets and deposits, Capital One is the eighth largest bank holding company in the United States. As of 2012, the bank has 963 Capital One Bank Branches including 10 café style locations for their Capital One 360 brand and 2,000 ATMs. Capital One Financial is a member of the Fortune 500, and conducts business in Canada and the United Kingdom. The company helped pioneer the mass marketing of credit cards in the 1990s, and it is now the fourth-largest customer of the United States Postal Service.

Installation, Administration and Maintenance of SQL Server Instances

Plans and implements backup and recovery of the Oracle database

Implements and enforces security for all of the Oracle Databases

Migrating SQL Server to Oracle Database Using SQL Developer

Setup Test, Dev, Staging and Production Environments

Take care of the Database design and implementation

Create Users and assign permissions based on the level of database access the user would need

Database tuning and performance monitoring

Application tuning and performance monitoring

Plan growth and changes (capacity planning)

Work as part of a team and provide 7 24 supports when required

Do general technical trouble shooting and give consultation to development teams

Designation: Senior Database Administrator

Environment: SQL Server 2005, 2008 and Clustering

B.RWE DATACENTER-TRANSITION Feb2011 – Oct2013

RWE is one of Europe’s five leading electricity and gas companies. Through our expertise in oil, gas and lignite production; electricity generation from gas, coal, nuclear and renewable; energy trading as well as electricity and gas distribution and sales; we are active at all stages of the energy value chain. Around 70,000 employees supply over 16 million electricity customers and nearly eight million gas customers.

Pre KAP and KAP study

Plan and track the transition plan

Prepare the Project Scope

Articulate and document: ETL Strategy, OLAP Strategy, Database Sizing, Security implementation, Test Strategy and deployment strategy.

Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.

Setting up of offshore infrastructure and connectivity.

Work with developers and systems support personnel in elevating and automating successful code to production

Testing of the access of databases from Offshore

Customer relationship management and 24x7 Service Management.

Process and SLA definition and implementation

Review of technical and process documents of transition

Designation: Senior Database Administrator

Environment: SQL Server 2005, 2008 and Clustering

Client location: UK

C.CAP-CCP Reporting Operations at Microsoft Feb2011 – Oct2012

CAP and CCF Operations is a data warehouse environment project where we support huge databases with terabytes of data. It’s a critical warehouse data environment as it helps business to analyses their call center business workflow and various analytical element studies. Based on the reports we publish in the environment they do their daily activities and action items. This project has huge visibility across Microsoft comprising of director level people. It’s very important to have all the SLA met.

We have almost 100% SLA met metrics on daily basis so far with no operational failures. The environment is a complete integration on SSIS, SSRS, SSAS and SQL SERVER 2008 databases.

Handled SLA activities comprising of huge data warehouse data.

Determined executive level support for the project of data warehouse.

Classified key business drivers for the data warehouse.

Maintained about 200 servers for all the environments including Production, PPE, UAT, Test etc.

Implemented SSIS and SSRS technologies based on the business requirement.

Modified database design to improve the performance of the Query outputs using Logical table partioning, Indexed views, Indexes etc.

ETL jobs

Appling regular service packs and cumulative updates on servers

Designed and implemented data warehouse architecture for the corporate circulation data warehouse that became the standard for divisional data warehouses. Subsequent data marts, extracts and reports were sourced from an architecture of conformed facts and dimensions

Upgrading servers and security patch application.

Direct and design the information delivery and access for the data warehouse.

Password change activities in SSRS, SSAS and SQL Server.

Applying and managing Quarterly releases.

Planning and suggesting the environment improvement activities

Designation : Database Administrator

Environment: SQL Server 2005, 2008, SSIS, SSRS and Windows Cluster

Reporting: Jon Brown

Client location: USA

Client: Microsoft

D.Fosters Group AUG 2009 – FEB 2011

Fosters has three regional businesses - Australia, Asia & Pacific (AAP), Americas, Europe, Middle East and Africa (EMEA) - with their goal to offer a portfolio of the best beer, wine, spirits, ready-to-drink, cider, and non-alcohol brands to suit every drinking occasion.

As Foster's continues to build their business, their focus is on delivering strong, consistent returns on all financial measures. Foster's wants to develop the capability for sustainable growth through continuous improvement and innovation. Foster's have a team of more than 10,000 people in locations around the world. Foster's have operations in the United Kingdom, Europe, the United States, Australia, New Zealand and Asia, and their products are sold in more than 150 countries worldwide. As the leading alcohol company in Australia and the Asia Pacific, Foster's is the proud owner of the region's favorite brands and the world's most famous Australian beer; Foster's Lager.

Performed key role in handling Production database server during peak times

Responsible for all database related issue in production servers

Database Maintenance activities like Backup Monitoring, Database Health Check, Daily jobs monitoring and Re-indexing etc.

Installed, Administering and maintaining High availability solutions like

a) Log shipping

b) Mirroring

c) Failover Cluster

d) Replication

Project related activities like executing DTS Packages, SSIS Packages, scripting SPs, installing SQL Server 2000/2005/2008

Weekly/Monthly maintenance tasks like Patching, installing Service Packs

Database related issues like T-log full, Disk full, DB Suspect state, recovering corrupt databases, point in time recovery etc

OS Related tasks like Rebooting Servers, analyzing Server performance, scheduling Windows Scheduled tasks, troubleshooting production issues using Performance counters, Event Viewer etc

DB Performance monitoring using tools like Idera, Profiler, Perf Counters,

Implemented Service Improvement Plans like Preparing Monitoring Scripts, Disk space alerts script etc

Reporting: Project Manager

Designation: Database Administrator

Environment: SQL Server 2005, 2008 2008 R2 and Clustering

E.Microsoft Dec 2007-AUG 2009

Providing end to end solutions to Database production support

Member of MBSIT Platform support (24/7 project).

Very good experience on SQL Jobs (Creating, Executing and troubleshooting on 2000, 2005)

Installed MS SQL Server on Cluster environment and Configured windows clustering.

Created Replication between two deferent environments

Performing Disk Space Management.

Creating and Managing Indexes and Partitioned Indexes

Performing Database Mirroring configuring Witness Server

Created DTS Packages for Transfer (Jobs, Logins MS-SQL Server2000 to MS-SQL Server2005)

Executing DTS, SSIS and VBScripts on SQL servers.

Given proposal for servers and hardware RAID configuration solutions for Enterprise Solutions.

Implementation of database maintenance plans, database security management, and clustering.

Configuring Log shipping

Coordinate with Application Team through migration review meetings and post-migration QA and support.

Server and storage resources capacity planning and allocation.

Resolving Tickets based on priority.

Designation: Database Administrator

Environment: SQL Server 2000 and 2005

Contact this candidate