Sql Server Database Administrator

RAKESH BABU

***.******@*****.*** +1-919-***-**** https://www.linkedin.com/in/rakeshcrb/

Summary:

Database Administrator with 5 years of experience in managing database systems, optimizing performance and data security across various platforms. Expertise in handling critical database operations, troubleshooting and implementing high-availability solutions.

Technical expertise:

Database Management: Oracle, SQL Server, MySQL, PostgreSQL

Backup & Recovery: RMAN, Data Pump, Log Shipping, Replication

High Availability & Disaster Recovery: Oracle Data Guard, SQL Server Always On, Oracle RAC

Performance Tuning: SQL Optimization, Indexing, Partitioning, OEM, AWR, and TKPROF

Automation & Scripting: Unix Shell Scripting, PowerShell

Security & Compliance: User Access Management, Database Auditing, Encryption

Tools & Utilities: OEM, Grid Control, GoldenGate, SSIS, SSRS, SSAS

Professional Experience:

Macy’s – Atlanta, GA

DBA Feb 2024 – Present

Description: Managed and optimized Macy's SQL Server and PostgreSQL databases, ensuring high availability, security and performance.

Responsibilities:

Managed SQL Server(2016/2019/2022) environments across development, testing, and production stages, ensuring smooth transitions.

Configured database servers tools like SQL Server Management Studio (SSMS), PowerShell scripts, and automated monitoring tools like SolarWinds and Splunk.

Migrated Oracle database objects (schemas, tables, indexes, triggers, stored procedures, and functions) to PostgreSQL compatible formats.

Migrated application data from SQL Server to MongoDB for flexible schema requirements and scalability.

Managed cross-platform database replication and synchronization to ensure consistency between Oracle and PostgreSQL during migration phases.

Applied performance tuning and optimization techniques using tools like SQL Profiler, Query Store, and Extended Events to ensure high system efficiency.

Designed and implemented MongoDB Replica Sets and Cassandra Clusters for high availability and fault tolerance.

Independently analyzed and resolved database issues in real time, using troubleshooting tools such as SQL Server Error Logs and dynamic management views (DMVs).

Automated routine database tasks with PowerShell scripts and SQL Server Agent jobs, ensuring consistency and reducing manual errors.

Assisted developers in optimizing complex queries and refining schemas using tools like dbForge and Azure Data Studio.

Implemented High Availability and Disaster Recovery solutions, including Always On Availability Groups (AOG) and Azure SQL Managed Instances, to guarantee business continuity.

Ensured data integrity by managing backups and recovery processes using native SQL Server tools, Redgate and Azure Backup solutions.

Administered cloud-based solutions like Azure SQL Database, PaaS, and SQL Managed Instances for scalability and efficiency.

Installed, configured and optimized PostgreSQL databases, using tools like pgAdmin and pg_dump for maintenance, tuning, and backup strategies.

Used advanced monitoring tools such as Dynatrace, Nagios, and performance dashboards to proactively identify and resolve potential issues.

Shared expertise through documentation, cross-training, and mentoring team members on best practices and new database technologies.

Environment: SQL Server (2016/2019/2022), PostgreSQL, Azure SQL Database, MongoDB, PaaS, PowerShell, SQL Server Management Studio (SSMS), dbForge, Azure Data Studio, SolarWinds, Splunk, Dynatrace, Nagios, Redgate, Windows Server, Linux (RHEL, Ubuntu), pgAdmin, pg_dump.

Wipro – Chennai, India

Administrator June 2018 – April 2022

Description: Manage Oracle database administration assignments for TD Bank. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning, and conduct regular system backups. Ensuring technical and functional designs meet business requirements on daily basis.

Responsibilities:

Maintaining RAC database (Two Node Cluster with ASM storage).

Installing, configuring, and maintaining Oracle 11g, 12c and 19c databases

Applying latest Database and GRID/PSUs, JDK patches as per requirements on Oracle RAC cluster - Database Instances in 11g,12c and 19c environments

Backup strategies using Hot Backup, Cold Backup & Logical Backup with Block Chain Tracking enabled.

RMAN and OEM Configuration, Backup and Recoveries as per requirement, Full, Incremental and Differential Backups

Expdp & Impdp utilities for datapump: Full export-import, parallel execution, attaching jobs, remapping schemas tablespaces.

Oracle Enterprise Manager (OEM) & TOAD Applications for: Administration, SQL query/job and DB Monitoring, datafile creations; ASM, AWR, ASH, ADDM reports; database system backups and their daily reports

Database and schema/objects refresh (in place) from lower version to higher & vice versa as per feasibility.

Writing and using bash automated scripts where/whenever required. Managing tablespaces & data files, creating and managing of DB Links. Maintaining CRONTAB jobs.

Managing Users, Roles, Functions and Profiles. Participated in Disaster Recovery activities periodically using observer server and DataGuard, also log monitoring.

Finding long running queries and advising users to re-write their queries and tune them. Finding object locks and releasing them to increase their job performance in the databases.

Analyzing tables and creating and rebuilding indexes wherever is applicable.

Working in a 24x7x365 environment with shifts feasibility

Joining and handling techlines calls & chat with direct application customers and various teams in 24/7/365 shifts whenever required. Guiding the team/individuals on requirements for the work completion, scheduling & handling KT and reverse KTs

Tools for work handling: JIRA, BMC Remedy (creating and managing INC, CRQ, WO, PBI), SmartIT, ORACLE Support SRs,server internal tools, Confluence documentations etc.

Proposed database changes to ease monitoring and administrative effort.

Provided resources and skill sets to support DBA functions for Applications. Also have led the team as a backup.

Environment: Oracle 11g, 12c, 19c, RAC, ASM, UNIX, Linux, Shell Scripting, RMAN, OEM, DataGuard, Expdp/Impdp, TOAD, JIRA, BMC Remedy, SmartIT, Confluence

Educational Qualification:

Master’s from Southern New Hampshire University (April 2022 – December 2023)

Contact this candidate