SUNEEL RATNAKAR

MSSQL Server DBA

📱 +91 9916931595

✉️ Suneel.ratnakar@gmail.com

📍 Bangalore, Karnataka, India

Professional Summary

To excel in the field of Information Technology as a core MS SQL Server DBA with 13 years of experience (L1, L2, and L3) along with solid knowledge of database migration on Amazon Web Services (AWS) Cloud and Oracle DBA as a L1 resource. Committed to contributing continuously towards organizational growth by providing seamless database support and leveraging every opportunity for personal and professional development.

Technical Skills

Database Expertise

SQL Server: 2022, 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005

Oracle: 19c, 12g, 11g, 10g, 9i

Operating Systems

Windows 2016, 2012, 2008 R2

Linux Servers

Ticketing Tools

Service Now, Jira, BMC Remedy, Opsview Monitoring, OEM

Third Party Tools

Data dog, Ignite monitoring tool

Languages

T-SQL, PL/SQL, Java

Platform

MS-DOS, Windows family, UNIX

Education

Bachelor of Engineering (BE) in Computer Science and Engineering

Institution: Basaveshwar Engineering College, Bagalkot

University: VTU Belgaum

Percentage: 62.19%

Duration: June 2003 – October 2006

Diploma in Computer Science (CS)

Institution: Government Polytechnic Bijapur

Board: BTE Karnataka

Duration: June 2000 – May 2003

SSLC

School: Padmashree Kaaka Kaarakhani's High School Bijapur

Board: KSEEB

Duration: June 1999 – May 2000

International Onsite Experience

🇬🇧 United Kingdom - Bath Spa

Company: Brillio Technology

Project: IFDL project for Blue Button Database

Duration: September 7, 2014 to September 21, 2014

🇫🇮 Finland - Helsinki

Company: NAPA Software

Project: Hosting Architecture for Napa Office Customers - AWS Migration to the CLOUD using SQL Server 2012 Always On High Availability Groups

Duration: May 27, 2013 to July 5, 2013

Professional Experience

🌟 Star of the Month Award

Received recognition for applying patches to critical production SQL Server environment and successfully leading in-place upgrade from SQL Server 2012 to 2016, enhancing system scalability, reliability, and overall performance.

Assistant Consultant

TCS (Tata Consultancy Services) | Bangalore, Karnataka
Project: WHG-Database Support-CBO-Offshore (Wyndham Hotels & Resorts)
Duration: February 5, 2024 – February 12, 2024
Team Size: 6 Members

Key Achievements:

Received Star of the Month Award for applying patches to critical production SQL Server environment and leading in-place upgrade from SQL Server 2012 to 2016
Worked on Wyndham Hotels & Resorts, the largest hotel franchisor in the world with 9,280 locations and 20 hotel brands

Responsibilities:

16x5 production support for PROD/DEV/TEST environment SQL Servers
Production Support for multiple database platforms: MSSQL, Oracle, Redshift, PostgreSQL, Aurora DB and MySQL, all hosted in AWS
Managed Amazon Redshift Authentication using IAM, database users, SSO, SSL, and auditing tools
Managed AWS IAM roles and policies for secure access and user access management
Monitored and optimized Redshift cluster performance for high availability and cost efficiency
Managing and monitoring AWS resources: EC2, S3, RDS, and Redshift
Performed quarterly patch updates for SQL Server 2016 and 2019
Successfully performed in-place migration from SQL Server 2012 to SQL Server 2016 in production
Applied patches on SQL Server RDS instances
Moved SQL Production Servers backups to AWS S3 bucket with 4-month retention period
Performed production deployments across Amazon Redshift environments (DWHQA, DWHDEV, DWHPRV, DVPROD)
Managed weekly delivery of application accounts expiry details, AWS recommendations, and Birst cluster updates

Consultant

ATOS SYNTEL | Bangalore, Karnataka
Project: AllState Insurance (Production Support)
Duration: February 2018 – February 7, 2024
Team Size: 11 Members

SQL Server DBA Responsibilities:

24/7 production support for PROD/DEV/TEST environment SQL Servers
Resolved incident tickets escalated from Support/App/other Teams and handled critical incidents (Sev1, Sev2, Sev3 high)
Expert installation & configuration of MS SQL Server 2017/2016/2014/2012/2008
Implemented Always On clustering with SQL Server 2012/2014 for High Availability (HADR) & Windows clustering 2012
Setup & configuration of Database Mirroring in SQL Server 2012 in Production Environment
Planned and Executed 100+ Critical SQL Server DR (Disaster Recovery) activities for Failover and Failback of Always On and Database Mirroring
DR setup aligned to Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) using log shipping and mirroring
Resolved Always On related issues: AG not in sync, DB in Suspect mode, Orphan user issues, failover/failback
Patching Validation with Application Team and Windows Team on weekly basis
Applied Service Packs and hot fixes to address security and performance issues
Handled ECC Bridge Calls for SQL Server health checks, downtimes, blocking sessions, deadlocks, long-running queries, index issues, CPU/Memory issues, patching, Always On AG matters
Maintained & secured SQL Server, handling user permissions, roles and access control
Resolved critical issues: Temp DB (without restarting SQL Server), Disk space alerts, Transaction Log space, CPU & Memory utilization
DB Integrity checks, Rebuilding & Reorganizing Indexes, Update Index Statistics
Monitored and optimized database performance using T-SQL queries, DBCC commands
In-place & side-by-side data migration from legacy systems
Created SOPs for critical Disaster Recovery activities and delivered presentations
Provided On-Call support for troubleshooting SQL Server outages

Oracle DBA Responsibilities:

Architecture of Oracle Database and monitoring Oracle Servers & health checks
Worked on Service Now tool for Change Automation and Change Assignments using WinSCP tool
Account unlocks/Password reset, User creation, Grant/Revoke permissions
Handled incidents for Table space, PGA, Disk group, FRA, Hung jobs, dangerous sessions, RMAN hung, trace file, AlertLog & shared pool memory issues
Created standard changes for file system/disk space utilization exceeds 90% threshold & archive free space issues
AWR report generation and delivery to requested users
Executed customer scripts (INSERT/DELETE/UPDATE) in production servers
Pre and post validation for Linux patching and checking sync between primary & standby database
Rebuilt indexes online using SQL query
Knowledge on Oracle Database 19c - current long-term release
Weekly cloning activity checks and confirmation mails
Weekend MongoDB deployments

Sr. Technology Leader

KPIT Technologies Ltd. | Bangalore, Karnataka
Project: Energy On
Duration: February 22, 2016 – May 23, 2017
Team Size: 9 Members

Worked on PROD/UAT/STAGING/DEV/QA Environment SQL Servers
Expert installation, upgrade and configuration of SQL Server 2012, 2008 R2, 2008, 2005 in clustered environments
Developed backup & recovery strategies for Prod environment
Setup & configuration for Always On clustering, Database Mirroring in production environment and log shipping in staging environment
Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Check using DBCC Utilities
Resolved Temp DB, CPU, Memory, fragmentation, Rebuild & Reorganizing index, Blocking & Deadlock issues
ETL of Data from Excel, Flat file, Oracle to MS SQL Server using DTS Import/Export utility, SQL Server Integration Services (SSIS)
Upgradation from SQL Server 2012 to 2014 and participated in launching Application in production environment
Monitored and maintained all SQL Server instances (Production, Staging, QA, & Development)

Sr. Engineer DBA

Brillio Technology | Bangalore, Karnataka
Project: IBM Walmart
Duration: July 2014 - April 2015
Team Size: 6 Members

Physical implementation of databases, storage structures, High-Availability and Disaster Recovery solutions
Defined DB standards and best practices for advanced monitoring, troubleshooting, performance tuning and automation
Responsible for daily scrum meetings and weekly status meetings
Automation tasks for Production Environment databases using SSIS package
SQL Server performance tuning: Index Analysis, SQL code review for stored procedures and SQL queries
Managing backups, restoring, shrinking log files, disk space issues
Handling job failures and monitoring servers
Implemented maintenance plans and utilized DTS packages
Installation and configuration for SQL Server 2000, 2005 and applying patches
Installation and configuration of Clustering SQL Server 2005
Configuration & Setup for Database Mirroring on SQL Server 2005
Production deployments
Handled weekly SQL Tech meetings to discuss and resolve critical problems

Data Administrator

Napa Software | Bangalore, Karnataka
Project: Hosting Administration of Ships Data into AWS Cloud
Duration: April 2013 - May 2014
Team Size: 2 Members

Hosting architecture customers (migration) to the cloud using SQL Server 2012 Always On (AG groups)
Installation, configuration and administration of SQL Server 2012, SQL Server 2012 Always On High Availability
SQL Server 2012 failover cluster management, adding and removing database from AG and DR
Responsible for AG related issue resolution
Performance tuning, configuring Windows clustering, Active Directory, joining machine to AD
Day-to-day Database Maintenance: Always On Clustered Database Monitoring & Windows Server Failover Clustering Status, Full & Transactional Log Backups
Total Size monitoring of databases, primary (.mdf) & log (.ldf) file size, Available Disk Space Management
Backup and recovery strategies in Production environment
Designed and implemented comprehensive Backup plan and DR strategies
Setup Database Maintenance Plans for Checking Database Integrity, Rebuilding Indexes, Update Index Statistics
Managed user and login data security (create, maintain users and roles, assign privileges)
Scheduling and Configuring SQL Server agent Jobs and Alerts, troubleshoot job failures
Configured Database Mail in SQL Server and Created Operators
Relocation of DBs using attach and detach
Issue diagnostics, troubleshooting, proactive performance improvement
Daily discussions and weekly meetings to resolve critical issues

Systems Engineer

Symphony Services | Bangalore, Karnataka
Project: Iron Mountain Project
Duration: April 2010 - May 2011
Team Size: 4 Members

Primary SQL Server DBA responsibilities: troubleshooting, performance optimization, prompt issue resolution
Day-to-day support, especially during US-shift hours
Administering SQL Server architecture and databases
Handling Job failures, clearing log space, blocking issues & monitoring servers
Creating, managing, and optimizing databases, data and log files, and logins
Creating new databases and strategically planning file locations for data, indexes, and transaction logs on disks
Fundamental SQL Server Database Administration: backups, restoration, and disk space management
Handling issues with SQL Queries & worked on DTS Package installation
Installing and maintaining SQL Server versions 2000, 2005, and 2008, including applying essential service packs
Configuring Database Mirroring in SQL Server 2005 and Clustering in SQL Server 2005
Managed production deployments and overseeing SQL tech meetings
Knowledge on High availability options: Database Mirroring, Clustering, Log shipping & Replication

Associate Systems Analyst

Unisys Global Services India | Bangalore, Karnataka
Project: Vivaldi (CIBA) Project
Duration: September 2007 - April 2009
Team Size: 10 Members

Core SQL Server DBA activities and providing 24/7 day-to-day support
Managing backups, restore, file management, and disk space
Managing job failures, log space, Temp DB, and user DB issues
Creating and maintaining maintenance plans, databases, files, and logins
DB health checks, performance tuning, and SOX testing/audit
Managing production deployments
Addressing SQL query issues and SQL Tech meetings
Handled various incidents, gaining expertise in troubleshooting
SQL Server Monitoring and timely issue resolution

Technical Certifications

1. Oracle Certified Associate [OCA]

2. Sun Certified Java Programmer (SCJP)

3. Oracle Cloud Infrastructure Foundations 2021 Associate (1Z0-1085-21)

4. Oracle Cloud Infrastructure 2021 Certified Architect Associate (1Z0-1072-21)

5. Oracle Cloud Infrastructure 2021 Certified Architect Professional (1Z0-997-21)

6. Oracle Infrastructure 2021 Certified Cloud Operations Associate (1Z0-1067-21)

7. Oracle Autonomous Database Cloud 2021 Specialist (1Z0-931-21)

8. Oracle Cloud Database Services 2021 Specialist (1Z0-1093-21)

9. Oracle Cloud Database Migration and Integration 2021 Specialist (1Z0-1094-2021)

10. Oracle Cloud Infrastructure 2023 Foundations Associate (1Z0-1085-23)

11. Oracle Cloud Data Management 2023 Foundations Associate (1Z0-1105-23)

12. Oracle Cloud Infrastructure 2023 Application Integration Professional (1Z0-1042-23)

13. Oracle Cloud Infrastructure 2025 Certified AI Foundations Associate (1Z0-1122-25)

14. Oracle Fusion Cloud Applications ERP Foundations Associate - Rel 1 (1Z0-1160-1)

15. Oracle Fusion Cloud Applications HCM Foundations Associate - Rel 1 (1Z0-1162-1)

16. Oracle Fusion Cloud Applications SCM Foundations Associate - Rel 1 (1Z0-1163-1)

17. Oracle Fusion Cloud Applications CX Foundations Associate - Rel 1 (1Z0-1161-1)

18. Oracle Cloud Infrastructure for Sunbird ED Specialty - Rel 1 (1Z0-1119-1)

19. Oracle Cloud Infrastructure 2025 Foundations Associate (1Z0-1085-25)

20. Oracle Data Platform 2025 Foundations Associate (1Z0-1195-25)

21. DP-300: Administering Microsoft Azure SQL Solutions

22. AZ-104 Microsoft Azure Administrator Associate

Pursuing Certifications

✓ AWS Certified Solutions Architect – Associate

✓