Rss

Rao K

Sr DBA Architect.docx

Occupation:

Database Administrator

Location:

Highland Mills, NY

Education Level:

Master

Will Relocate:

YES

CollapseDescription

MCITP-Certified & Expert in MS SQL Server 2016/2014/2012/2008 R2/2008/2005/2000/7/6.5 * Administration, Maintenance (24x7) of SQL Servers (100+) into Production, TEST, UAT, QA, DEV, Training, Experiences in agile, hazelcast, jetkins, nexus, docker, Kafka and devops, CyberArk * Installation, Consolidation, Upgrade, Migration of SQL Server 2017/2016/2014, 2012 2008 R2 * Setup of SQL Server High Availability failover Cluster Active/Active & Active/Passive on WSFC * Setup of SQL Server High Availability using Always On, Mirroring, Log shipping and Replication * Designing and Implementation of DISASTER RECOVERY Servers, Processes, Procedures, Solutions * Setup of Maintenance jobs for BACKUP/RESTORE, re-indexing, Index defragmentation, update Statistics, integrity checks, transaction log growth monitoring and batch processes * Performance Tuning and Optimization - Memory, CPU, IO, Azure scaling up and down and AWS. * Performance Tuning - Database Engine Tuning Advisor using Trace and profiler * Installation and Maintenance of SSIS, SSRS, SSAS and database engine * Expert in SQL Server new features like Policy Based Management, Performance and Data Collector * Creation of Linked Server and setup database mail, SQL Audit, SQL Operations Studio * Cloud Platforms (AWS IaaS and platform services, Azure IaaS and PaaS services) * Deployment of SSIS project (2016/2014/2012) and Package SSIS job scheduling and Power BI * Performing Capacity Planning and pre-allocating space, warm standby, and master-slave * Use Data Collector to collect different sets of data with integration to SQL Agent and SSIS * Scaling out of report servers and configure and maintain MSSQL TDE encryption * Automation using power shell/Perl/Shell/cypher scripting, Availability Group * Involved Change management and Incident handling as per ITIL standards Maintain TFS * Administer Multiple Servers Using Central Management Servers, Resource Governor * Expr to Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO) * Expr to Test backups to ensure we can meet the business' Recovery Time Objectives (RTO) * Good working knowledge on CRM tools BMC Remedy, Salesforce, and Oracle CRMOD * Expert in using tools like SQL Profiler, Windows performance Counters and Troubleshooting with these

Right_template4_bottom

CollapseWork Experience

Right_template4_bottom

CollapseAccomplishments

Highlights:

Left_template4_bottom

CollapseKeywords

Left_template4_bottom