RAJESWAR REDDY

Email : adlo0u@r.postjobfree.com

Phone: 618-***-****

Professional Summary:

●Around 9 Years of IT experience in MS SQL Server Administration,Development and Database Design using SQL server in on-Premises and SQLAzure cloud servers (IAAS/PASS)

●Experience in Installing Managing SQL 2019/2017/2016/2014/2012/2008R2/2008/2005/2000

Servers and updating with hot fix and service packs

●Expertise in Configuring and Managing SQL server Always on availability groups .

●Hands on experience with High Availability & Disaster Recovery Solutions – Log Shipping, Mirroring (High safety and High performance), Replication (Snapshot & Transactional, Merge) and Clustering (Active-Passive and Active - Active).

●Extensively worked on Active-Active and Active-Passive two node Clustering and three node clustering (Active-Active-passive).

●Managed Microsoft Azure based PaaS and IAAS environments

●Troubleshoot Azure related issues and worked with internal teams and vendor issue resolutions

●Good knowledge on External tables,Elastic pool Models & on saving the cost on Azure models

●Implemented Side-by-Side and In - Place Migration of SQL2005 to 2008R2 and SQL Server 2008/12 databases to SQL Server 2016/2017/2019.

●Expert in Creating & Debugging Views, Functions, Stored Procedures, Triggers, Optimizing Code, and improving Efficiency.

●Good Experience and knowledge in creating and managing user permissions, logins .

●Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

●Experience in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.

●Used DBCC trace flags handling blocking and dead lock situations and handling the Isolation Levels and Concurrency Effects, detect CPU, I/O, Memory bottlenecks.

●Worked on Database Migration from SQL server to AZURE using tools like DMA (Data Migration Assist) and SSMA (SQL Server Migration Assistant). Used Team Foundation Server (TFS)

●Very Extensively used the native tools like SQL Server Profiler, Performance Monitor, Activity Monitor, index tuning wizard, Query Store,database tuning advisor to troubleshoot.

●Experience in Data/Table partitioning, online Indexing, rebuild/reorg indexes and Update statistics at regular intervals for better performance.

●Experience on Data Transfer from and to SQL Databases using u SSIS, DTS, BCP, BULK INSERT etc.

●Implemented on-prem /Azure backup for Database &Point-in-time recovery for SQL Databases.

●Good understanding on Pricing models of DTU/eDTU vs Vcore Model in Azure

●Good experience in Azure Geo-Replication, Availability Group(s) and Data Sync

●Hands on experience with administering large databases size above 6 terabytes, database design, normalization and database application development.

●Worked in OLTP & OLAP environment Prod /QA/DEV databases in SQL Server.

●Experience in configuring Data Quality Services, (DQS), Master Data Services (MDS) and IIS.

●Good knowledge of Data modeling including Physical and logical data modeling using ERWIN.

●Used power shell scripts for server maintenance and to change sql service accounts and update passwords across all sql servers and Batch scripts for regular Sql server Database maintenance

●Migrated DTS packages to SSIS packages; worked on building and deploying SSIS packages.

●Created and deployed OLAP cubes through SSAS.

●Used third party tools like Lite speed, Red gate, idera diagnostic manager, splunk dashboard, Fog light, Used pragmatic workbench, Solarwinds, cyberark .

●Experience in production support, 24 X 7 on call.

TECHNICAL Skills:

Skills:

SQL Server Tools: Profiler, Activity monitor, DTA,Import &export, Business intelligence SSIS, SRS & SSAS, Visual Studio, Data migration Assistant, Azure portal

Database: MS SQL Azure, 2019,2017,2016, 2014, 2012, 2008 R2, 2008, 2005, 2000.

Language: T-SQL, Powershell, batch scripts

Operating System: Windows Server 2016,2012 R2, 2012, 2008 R2, 2008, 2003.

Backup and

Monitoring Tools: Solarwinds, Ignite, Idera,Splunk,TSM Tivoli, Litespeed, OEM, Performace CommVault, SCOM, BMC Remedy, ServiceNow,Cyberark,Autosys

Professional Experience:

Client: Equitable April 2020 - Present

Location: Jersey city, New Jersey

Sr. SQL DBA

Responsibilities:

●Installation & Maintenance of SQL 2019/2017/2016/2014/2012/2008R2 servers,Upgraded SQL server versions to latest patches and automated Sql installations using PowerShell scripts .

●Migration of databases from On premise to Azure Cloud environment(PAAS,IAAS).

●Configured &Managed SQL server Always on availability groups and worked on always on issues.

●Handled performance issues on the SQL servers by identifying bottlenecks and rectifying it, fine-tuned store procedures to improve performance and database load performance improvements, properly configured database files and file groups to boost performance.

●Configured and Managed Active passive cluster (2 node cluster) and handled clustering issues .

●Migrated sql databases from sql server 2008r2/2012 to 2017/2019 servers .

●Involved in troubleshooting various SQL Server version database connectivity issues from application servers.

●Worked collaboratively with Application and support teams, both on-site and offshore and Took lead of projects as per the client requirement .

●Reviewed and optimized SQL queries, stored procedures, functions, Indexes, views and triggers from other developers to achieve maximum efficiency and scalability.

●Configured and Managed Replication (Transactional &Merge) and worked on replication issues

●Proactively Managed the databases, tables, log file allocation and space utilization, identify table growth, fatal errors, failed jobs, integrity violations, performance issues and data abnormalities.

●Worked on fixing long running queries and High cpu & memory usage issues .

●Used Lite speed and Performed backups/restores of the databases .

●Worked in Managing Client's Microsoft Azure based IAAS & PAAS(Azure database model &managed instance).

●Create and configure SQL servers, databases, elastic pools in Azure Cloud PAAS.

●Took schema and data backups of databases and restore/copy databases in Azure cloud.

●Used Data migration service in Azure portal to migrate databases from on prem to azure cloud .

●Troubleshooting issues occurred with the databases in Azure cloud environment.

●Suggest Cost optimization solutions in Azure PAAS( Azure database model &managed instance).

●Migrated Databases from on Prem SQL Environments to Amazon RDS SQL Server(AWS).

●Implemented TDE (Transparent Data Encryption) on Production DB’s to secure customer data.

●Created and Used Powershell scripts for daily DBA activities and automated

●Maintained high availability DR(Log shipping, Database mirroring )

●Created linked servers & proxy accounts,Managed server& Database level security permissions.

●Used Cyberark tool for onboarding service accounts .

●Managed database environments by proactively monitoring alerts and SQL Server performance in environments and provided 24/7 on call Support on weekly basis.

Environment : MS SQL 2019/2017/2016/2014/2012/2008R2,Azure servers(IAAS,PAAS),SSIS,SSRS,SSAS, Cyberark LiteSpeed,Tivoli storage Manger,idera,Autosys tool .

Client: Corteva Agriscience April 2016– March 2020

Location: Johnston, Iowa

(Sr.SQL Server DBA)

Responsibilities:

●Installation and Maintenance of SQL 2019/2017/2016/2014/2012/2008R2 and Azure servers

and applied sql service pack and hotfixes on sql servers.

●Migrated SQL server databases from 2008R2/2012 sql servers to 2016/2017 servers

●Worked in Managing Client's Microsoft Azure based PaaS and IAAS environment

●Configured and Managed Active passive cluster

●Configured and maintained Transactional and Merge Replication and handled replication issues

●Worked on deploying databases in Sql azure and managed security on sql azure servers

●Configured SQL server 2017 Always on availability groups with one secondary replica

●Migrated SQL Server Databases from on-premise to Azure Sql server.

●Import and Export data within Azure Cloud environment.

●Used Solarwinds for the instance and database monitoring for better performance

●Worked on SSIS project deployment, configuration on sql servers and monitoring SSIS Catalog .

●Performed SQL Server service pack and Windows Service pack upgrades.

●Involved in Capacity Planning and fixing disk space issues, Log file full and backup failures.

●Created SSISDB catalog and deployed SSIS packages and fixed ETL job failures .

●Created, deployed and managed reports using SQL Server Reporting Services (SSRS).

●Created, Deployed and processed OLAP cubes and Managed Sql server Analysis server(SSAS).

●Worked on fixing SQL certificate and SPN issues on the SQL servers .

●Performed Horizontal Table Partitioning on the sql server databases .

●Created and Used power shell scripts for daily DBA activities

●Used batch scripts to install SQL servers and to configure database maintenance plans

●Worked on Server failure issues like cluster failover issues, finding out root cause for failovers by analyzing the dumps and configuration,handled server failures by bringing services online.

●Worked on very large and complex databases and in a highly transactional environment.

●Extensively used the native tools like index database tuning advisor, SQL Server Profiler, Performance Monitor, Activity Monitor, Query store and Event viewer for performance analysis

●Implementation of Hosting SQL services in azure IAAS and PAAS servers.

●Troubleshooting issues occurred with the databases in Azure cloud environment.

●Enabling Geo replication to ensure availability of the Azure databases as DR plan.

●Used service Now and TFS change request for daily incidents and Tasks.

●24*7 On Call production support.

Environment: MS SQL Server 2019/2017/2016/2014/2012/2008R2,Azure servers,SSIS,SSRS,SSAS, Windows 2012R2/2016, LiteSpeed,Tivoli storage Manger,SCOM,solarwinds,powershell .

Client: Chevron

Location: Bakersfield, CA AUG 2015 – Feb 2016

(SQL Server DBA)

Responsibilities:

●Installation and configuration/Maintenance of SQL Server 2012 /2008R2/2008/2005 in all Environments.

●Applying SQL server patches on all the SQL servers.

●Database migration from SQL server 2008r2 to SQL server 2012.

●Worked and involved on database pre-deployment and deployment DBA activities on servers.

●Updating the SQL service account passwords prior to expiry on all the servers .

●Monitoring all the SQL server alerts like disk space issues and SQL job failures and fixing the issues and Database Security Maintenance

●Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

●Configured SQL server 2012 Always on availability groups with one secondary replica on windows server 2008R2/2012.

●Worked on troubleshooting long running queries, blocking issues and temp db issues

●Configured and maintained Transactional Replication.

●Planned and worked on setting up Table Partitioning for faster database maintenance .

●Involved in Capacity Planning and adding new storage space as needed.

●Responsible for monitoring and making recommendations for performance improvement in databases like index modifications schedule jobs to re-index and update statistics in databases.

●Configured Report Server Using Report configuration manager in SQL server 2008R2

●Used IDERA & splunk monitoring tool and upgraded IDERA Diagnostics Manager .

●Documenting all the issues encountered and activities accomplished in environment.

Environment: Microsoft SQL Server 2012/2008R2/2008/2005,SSIS,SSRS,splunk, Bmc remedy tool.

Client :Estes Express Lines:

Location: Richmond, VA Aug 2013-July2015

SQL Server DBA

Responsibilities:

●Installation and configuration/Maintenance of SQL Server 2012 /2008R2 in newly configured standalone and Cluster Environments

●Configured SQL server 2012 Always on availability groups with one secondary replica on windows server 2008R2/2012.

●Worked on Always on proof of concept performed various failover test cases.

●Implemented and managed the clustering environment like Active/Passive.

●Worked on side by side migration, migrated SQL server 2008r2 databases and ETL packages to SQL server 2012 using team foundation server.

●Worked on high availability SQL Server solutions, including Log shipping, Mirroring, Replication.

●Created and Modified Tables, storprocs, Views, Indexes, User-defined Functions, and Triggers.

●Worked on (TFS), created team projects and builds to deploy databases, ETL Packages, SQL jobs.

●Worked on rebuilding SQL server due to unexpected crash by Rebuilding Master Database in Server as a part of recovery process .

●Installed and configured master data services (MDS), IIS, SQL Server Data Quality Services (DQS)

●Involved in Capacity Planning and adding new storage space as needed

●Worked on purge process as a part of database maintenance,

●Involved in recovery databases from damaged or suspect mode conditions.

●Monitored and modified Performance using execution plans and Index tuning.

●Monitored SQL server performance using profiler to find performance issues.

●Involved in Setting up Environments for all the PROD, STAGE, DEV, and QA Environments with a detailed Analysis of Resource requirements (RAM and CPU).

●Implemented CDC (Change data capture) and Database encryption (TDE)

●Worked on tools like Idera diagnostic manager, pragmatic works doc xpress.

●Worked on call 24/7 Support on weekly basis.

Environment: Microsoft SQL Server 2012/2008R2/2008/2005, Windows 2008R2/2012 Server, Scom, Idera, pragmatic works doc xpress, web server IIS 7,VMware vsphere client, powershell.

Client :PNC BANK

Location :Columbus, Ohio) Sep 2012- July 2013

SQL server DBA\Developer

Responsibilities:

●Installation and Maintenance of SQL Server 2008/2008R2/2012 of sql servers

●Implemented & managed clustering (Active/Passive) & Log Shipping on Sql servers

●Implemented and managed database mirroring

●Import data across multiple instances using BULK INSERT and BCP Utility.

●Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.

●Converting DTS packages into SQL 2005 Integration Services & Resolve issues in SSIS Packages .

●Developed automated backup and DBCC scripts for databases and transaction logs.

●Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, tables, and views, Developed complex T-SQL code for the application

●Created Indexes(Clustered and Non-Clustered Indexes) to improve data access performance.

●Worked to Identify Relationships between tables and enforce referential integrity by foreign key

●Used Team foundation server to build & deploy databases and ssis packages and ssrs reports.

●Used sql server profiler, Activity monitor and dmv’s to troubleshoot database issues

●created and deployed SSRS reports on the server as per the requirement

●Created, Deployed and processed OLAP cubes and Managed Sql server Analysis server(SSAS).

●ALL DBA Tasks .

Environment: Microsoft SQL Server 2012/2008R2/2008/2005, Windows 2003/2008R2 Server, Business Intelligence, OEM and Lite speed, IGNITE Red gate,SSIS,SSRS,

Education:

Masters in Electrical &computer Engineering(southern Illinois University of Carbondale)IL,USA

2012

Bachelors of Technology in Electronics and Communication Engineering (JNTUH),INDIA

2010

Contact this candidate