Raju R

DBA (Cloud) | Architect | Automation

  • 406 Views

$30.00

(per hour)

Featured Services

Description

  • I am a Sr Microsoft DBA (Cloud) / Consultant / Architect with Migration, Performance Tuning, Always ON Expert.
  • I have 12+ years of experience in IT and currently working as a Senior SQL DBA, Consultant with an Architect.
  • I have performed various Microsoft sql server roles in my career, this includes, Architect role, SQL tech lead, Consultant &
  • Production support DBA.
  • During my career I worked for UK, IN & NZ for UK,NZ & US based clients, mostly working with SQL Server Technology right from version 7.0 to its latest form.
  • I worked on cluster & standalone environments, performance tuning, optimization projects with high transnational systems, migration projects, Direct Client facing roles, sql Consulting with size of more than 10TB.
  • Primary Skill: Microsoft SQL
  • Secondary Skill: Azure & AWS
  • Tools: Remedy, Quest Foglight & Spotlight, Litespeed, Red-Gate Backup, Perfmon, profiler, sqlnexus, psdiag, AdeptSQL, SQL Sentry.
  • TECHNICAL PROFICIENCY  
  • SQL Server 2012, 2014, 2008, 2008 R2, SQL server 2005 and SQL Server 7.0, SSIS, SSRS.  
  • Performance Tuning & Query Optimization,  
  • Redgate,Litespeed,sqlnexus,Adeptsql,pssdiag, SSM, Activity Monitor, profiler.  
  • ReplCompare, latencyMonitor, TransRepScripter, Quest.  
  • Clustering, Migration, Replication, logshipping, DR.  
  • Ipcenter, Remedy, Magic, Citrix, VPN, Teamviewer, VMware, AdeptSQL, Sql sentry.  
  • Database Architecture, reviewing existing system and optimize the performance.

Experience

Lead Senior SQL DBA

  • Freelance
  • December 1, 2013 - continue

· Working as a Sr SQL Server DBA ( SQL 2005, 2008, 2008 R2, 2012 and 2014 )rnrn· Performed SQL Architecture design, HADR design & Implementation, Logshipping design, SSRS, BizTalk Migration plans, performed sql consulting activities.rnrn· Implemented SQL 2012 AlwaysON (HADR), Partially Contained Database, User Defined Server Level Roles, Columnstore index & Partitions, MSDQS and more..rnrn· SQL 2014 AlwaysON (HADR), Windows Clustering ( WSFC ) , SQL Clustering ( FCI ).rnrn· Involved on SQL consulting & architectural design and implementation plans.rnrn· Mirroring, Replication, Logshipping, Consulting, planning, Architecture design, Migration, Licensing, DR, Auditing, Security, Patching, Maintenance, CU's,SP's,Hot fixes. Problem solving, trouble shooting, performance tuning, t-sql, design.SSAS,Cubes,MDW.rnrn· Building new sql 2012 & 2014 environments ( standalone and cluster sql instances, Cloud.rnrn· Windows Server 2008, 2012, OS 2012 R2. Linux based OS,BizTalk Logshipping.rnrn· Backup & Recovery, DR Implementation and Test, Production support, Oncall Support, Security, SQL best practices and standards, installation and configuration. implementing security policies.rnrn· Windows Server 2008, 2008 R2, Wndows 2012, 2012 R2 and MSA. SpotLight, SQL Nexus, SQL Best Practice analyzer, SQL Standards, planning, design,monitoring, service improvements, trainings, mentoring, sql consulting, Failover cluster manager, cluster aware patching, SAN, storage.. Oncall, 24/7 Production support, Change management, problem management, Remedy, ISM. SSRS sql 2012, 2008 R2 and 2008, SSRS Migration, SSIS. SQL Server policy based management, Resource governor, Tempdb Tuning & Configuration, SQL Server best practices and standards. RCA, Fixing issues, tuning DB systems, documentations. Logins and groups, Memory, CPU........rnrn· Enhances and maintain disaster recovery and high availability plans, procedures, training and testing.rnrn· Experience in IT strategy, including investigation of new systems Builds and planning of upgrades

Senior SQL DBA

  • IT FIRM
  • July 1, 2011 - December 1, 2013

· SQL Server DBA 2012, 7.0; 2000; 2005; 2008 Production Support [24*7*365]rnrn· Introduced advancements and performance improvement in Query Optimization and indexes for few high volume transaction systems to improve the performance.rnrn· Prepared new Established standards for SQL installations, maintenance, tuning and improving Tempdb performance.rnrn· Provided training, mentoring, and feedback to team members to enhance communication and performance. SQL Diag, SQL Nexus, Red gate, lite speed, Remedy.rnrn· Leading the Team along with provide the support to business and team in case of any major issues with database.rnrn· Supporting 400 production servers, 100 developments and testing servers.rnrn· In case of major outages join the bridge call and invite other team members and informing the business about the situation and action steps with timely updates.rnrn· Performing the RCA for the issues, testing and implementing the changes in production servers.rnrn· Panning and migrating the SQL Server from lower version to higher versions. Installing the service packs in mirror and cluster servers.rnrn· SQL server installation and configuration. Database high availability, security.

Senior System Specialist

  • Banking Firm
  • February 1, 2010 - June 1, 2011

· Backup and Restore, Configuring & Monitoring SQL Server Jobs, Installing, Configuring database servers. Implemented strategies for database highly availability and scalability.rnrn· SQL Version upgrade, Server migration -InPlace/SideBySide, Finding & Tuning SQL Server hardware Bottlenecks. Researched and executed production methodologies and documented systemrnrn· Supported over 600 servers in windows 2003 and windows 2008 environment.rnrn· Building and maintaining SQL server cluster, Troubleshooting SQL Server pro-duction/Test/Dev issues. Capacity planning and monitoring database growthrnrn· Configuring log shipping, mirroring, replication, cluster, managing log shipping, managing transaction log back-ups and implementing backup plans.rnrn· Managing SQL Server security and logins, Importing Exporting data using DTS, SSIS packages.

IT Specialist (SQL DBA)

  • IT FIRM
  • May 1, 2006 - May 1, 2008

· Responsible for migration and database tuning, upgrade, archiving the old data. Implemented high availability techniques.rnrn· Leader in major activities which include advanced performance tuning, database design, and capacity planning, migration, setting up the new environments.rnrn· Established standards for SQL installations, maintenance, tuning, and coding standards. Performed a thorough backup and recovery strategy for all major production systems.rnrn· Upgraded all SQL Server 2000 to SQL Server 2005, without any service interruptionrnrn· Effectively trained and managed a brilliant SQL DBA team.

Educational Details

MCA

  • Bharathiyar University Coimbatore
  • August 1, 2003 - August 1, 2006

2006 – MCA - Master of Computer Application Bharathiyar University Coimbatore, TamilNadu, India.

B.Sc.

  • Bharathiyar University Coimbatore
  • August 1, 2000 - August 1, 2003

2003 – Bsc (cs) - Bachelor of Computer SciencernrnBharathiyar University Coimbatore, TamilNadu, India.

Report Freelancer

Ready To Get Started

QWIRK is a brand owned by Gigart Solutions Incorporation, Delaware, USA. The company is a freelance marketplace to help firms find quality professionals when needed, to be a part of your workforce.