Srivenkateswararao Giri

+1-813-***-****

ac7mtx@r.postjobfree.com

9+ years of experience as SQL Server Database Administrator (2016, 2014, 2012, 2008,2008R2, 2005, and 2000) expertise in Installation, Configuration, Patches, Upgrades & Administration for SQL Servers in. Production, QA, Development Environments.

Strong Hands on experience in Microsoft Azure PASS & IASS environments.

Expertise in Migrating SQL Servers/ databases from On Premise Local Datacenters to Windows/Microsoft Azure (Cloud)environment.

Expertise in Configure and managing SQL Always ON environment, High Availability Always ON cluster environment and troubleshooting the availability Groups and other issues.

Expert in Disaster Recovery plans by configuring Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).

Experience in maintain and managed SQL clusters Servers 2008/2012 in Active/Passive and Acive/Active environments.

Hands on Experience in SQL server BI tools like SQL Server integration services (SSIS), SQL Server Reporting services (SSRS) and SQL Server Analysis services (SSAS).

Worked and supported High resource intensive applications like SharePoint, LiveLink, Doculink, Citix (VDI) and SAP.

Experience in SQL server database Migration/ Upgradeactivities from SQL Server 2000 to 2005, 2008 R2, SQL Server 2012 and SQL 2014. Expert in working with Third party backup tool like SQL LightSpeed, IBM Tivoli Storage Manager and Commvault for backup and recovery strategies.

Knowledge in windows Active Directory and Security and WINs and load balancing.

Worked closely with application developers and business users to assist in the planning and execution of the database and jobs upgrades across the Development, Test and Production environments

Experience in providing good Production support for 24x7 being on On-Call system Schedule over nights and weekends

Technical Skills

Operating Systems: Windows XP/2000, Server 2003, Server 2008, 2008R2 & windows 2012/2012 R2.

Databases: MS SQL Server 2014/2012/2008 R2/ 2008/2005/2000, Azure, Oracle 9i/8i.

ETL TOOLS: SSIS, SSRS, SSAS,DTS and Business Objects

Database Tools: SQL profiler, SQL Query Analyzer, Database Tuning Advisor and SSMS

Microsoft Tools PowerPoint, Word, Excel, Access, MS Project, SCOM, IDERA

Languages: T-SQL, C/C++, JAVA

Applications: Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.

Network Topologies TCP/IP, DNS, FTP.

Certification & Education:

MCTS - Microsoft SQL Server 2005 - Implementation and Maintenance

MCP – Administering Microsoft SQL Server 2012/2014 Databases

ITIL - V3 foundation certification

Master of Computer Applications (MCA) – Andhra University, India.

Professional Experience

Mosaic company, Tampa, FL Lead SQL Server DBA March 2012 – Current

The Mosaic Company (NYSE: MOS) is the world's leading integrated producer and marketer of concentrated phosphate and potash. They have SQL Database Servers spanned across Alpharetta, Wooddale locations & other servers in Regional Data Center. Major of them have been consolidated / migrated to Microsoft Azure Cloud Platform.

SQL Installation/Upgradation (2008, 2008 R2, 2012,2014& 2016) in Microsoft Azure and on-premise locations.

Configured and Managing SQL AlwaysON High availability environment, and troubleshooting the availability Groups and other issues

Migrated SQL databases from On Premise servers to Microsoft SQL Azure environment.

Successfully implemented and tested Database Mirroring in SQL server 2012 environment.

Monitoring, Configuring Database Backups using third party tools like SunGard NetBackup Backup Tool and Commvaultbackup tools.

Implementing SQL Security and SQL Hardening.

Implemented High Availability: Mirroring, Log Shipping, Replication, Clustering

Troubleshooting and resolving internal /external Project level issues at L3/L4 Level.

Managing >110 SQL Servers, ranging from 5 GB database to a 3 Terabyte.

Applying hotfixes / SQL service packs periodically to rule out any bugs / issues.

Upgrading SQL Server editions as per requirements.

Configuring, Managing and Troubleshooting Cluster Servers and Services.

Configuring and Troubleshooting SSIS, SSRS and SSAS related issues.

Refreshing the development databases with production data as per client request.

Migration and upgradation of Databases from SQL Server 2000, 2005 to 2008R2 / 2012 / 2014.

Automating Job Alerts using Database Mail and SQL Mail.

Implemented and documented proactive monitoring scripts for production databases.

Review performance stats and recommend changes for Database Tuning, Query Optimization, Diagnosing & fixing SQL performance issues.

Monitor server capacity and make recommendations for hardware upgrades or add-ons (E.g. processors, disk space and memory) to accommodate current and planned server usage.

Setup Maintenance Tasks such as database backups, consistency checks and Database optimizations.

Managing database and server level security, like creating and managing logins, database users and user permissions.

Communicating with clients to ensure end-user discrepancies are resolved.

Documenting Client processes, regular issues, RCAs for Audit Purpose.

Updating SQL Inventory and Creating Database Growth Report on Periodic basis.

Conducting meetings with Offshore Team on Weekly and Daily basis.

MetLife, Mumba, India Senior SQL Server DBA April 2010 – March 2012

Involved in Installation and Maintenance of SQL Server 2005 and 2008 R2 on Development, UAT and Production Environments.

Maintaining SQL Server 2008R2/2008/2005 (64 bit) on Active/ Passive Cluster with latest Service Packs, Hot Fixes.

Daily Monitoring and Health Checks for all MetLife Database Servers through SCOM Alerts.

Monitoring and making recommendations for performance improvement in hosted databases.

This involved index creation, index modification, code optimization and adding scheduled jobs to re-index and update statistics in databases.

Implemented T-SQL queries for automating SQL job alerts and troubleshot performance tuning related activities.

Maintain the integrity, availability, and recoverability of all production data systems. Planning for overall data deployment and operational health.

Setup database HA environment (Replication, Log Shipping) & supported Application DR test

Responsible and Involved in SQL Server Performance Monitoring, Server and Database optimization and Query tuning.

Analyzed database performance with SQL Profiler and perform Optimized indexes to significantly improve queries.

Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.

Conducting Database Refresh once in every week from PROD to UAT, DEV, and Test Environments.

Monitoring SQL server Error logs, Disk Space growth, Clustering Environment.

Planning and applying latest Service Packs to different versions of SQL Server.

Worked on performance and tuning, identifying locking and blocking for long running queries.

implemented and worked on Transactional replication.

Implemented the Security Best Practices for Databases using the Policy Based Management in SQL Server 2008.

Worked with Database Backup Compression, Policy-based management, Resource Governor, SQL server Audit.

Upgraded and Enhanced the SSIS packages from SQL Server 2005 to SQL Server 2008 R2/2008 and included the custom logging to tracking and troubleshooting the packages.

Configured IBM Tivoli Storage Manager for database backups and restorations

Created SQL Server logins and assigning roles and Authentication models as a part of Security.

Supported 24 X 7

Centex Corporation, Mumbai, India SQL Server DBA Dec2008 – April 2010

Installation and Configuration of SQL 2000 and 2005

Regular Database Maintenance Activities (Production / Staging / Development)

Monitor server capacity and make recommendations for hardware upgrades or add-ons (e.g. processors, disk space, memory) to accommodate current and planned server usage.

Involved in the migration of data between the production databases using Import/Export Wizard

Implemented T SQL queries for Daily database health checks.

All database operations and support including backup, recovery.

Upgrade/Patching/addition of new servers based on current and planned application usage.

Creating the jobs using Maintenance plans for full, differential and transactional log backups

Managing database and server level security, like creating and managing logins, database users and user permissions.

Monitoring the system performance and CPU usage on production servers

Maintain Windows 2000/2003 Cluster environment (Active/Active and Active/Passive) from SQL Server perspective

Provide 24x7 support

Contact this candidate