S SRAVANTHI

SV University, Tirupathi

MCA · Computer Applications

N/A – Present

Geojit Financial Services

Database Administrator

September 1, 2022 – December 31, 2025

Cochin, Kerala, India

Splenta Systems

Database Developer and Administrator

November 1, 2018 – August 31, 2022

Bengaluru, Karnataka, India

Mutual Fund Brokerage Reconciliation

January 1, 2021 – December 31, 2025

Managed and supported 200+ SQL Server instances (2022/2019/2017/2016/2014/2012) across Production, QA, and Development environments. Performed SQL Server administration, including installation, patching, upgrades, migrations, security, backup/recovery, and performance tuning. Implemented and managed High Availability solutions such as Always On Availability Groups, Clustering, Mirroring, and Replication. Monitored database health using DBCC, DMVs, SQL Profiler, and Idera; resolved performance bottlenecks through query and index tuning. Managed SQL Server Agent jobs, SSIS packages, ETL processes, and troubleshooting production issues. Administered user access, permissions, database refreshes, and disaster recovery activities. Configured and maintained backup strategies, ensuring data availability and recovery objectives. Reviewed, optimized, and deployed database scripts while supporting application and development teams. Monitored CPU, memory, disk utilization, and implemented proactive alerting and capacity planning. Provided 24x7 production support, incident resolution, root cause analysis, and client communication.

Mutual Fund Investment

November 1, 2018 – January 31, 2021

Worked on SQL Queries using Joins, Sub Queries & Correlated sub queries to retrieve data from the database. Requirement gathering from the Business Team. Working with Triggers, Synonyms, views, Joins, Cross/ Outer Apply, and Table Valued Parameters (Table Type Object). Writing Complex Queries, inline queries, Stored Procedures and Functions, CTE’s. Planning a strategy to migrate data from one database to another. Working with SCD Techniques and data quality. Developed SSIS packages to get the data from Oracle server, xml, Excel (xls, xlsx, xlsm), Cloud, text, CSV and different types of files to SQLSERVER. Developed SSIS Packages to read the data from web service, writing into Flat Files and upload them into Remote server using WinSCP. Worked on different types of SSIS data loads like weekly and monthly Packages. Automate the SSIS Packages using SQL Server Agent and Windows Task scheduler. Creating Linked Servers. Coordinating the Developing activities with the development team And QA team. Working with event handlers, Logging and different types of configurations in SSIS packages. Proficiency and Expertise in SQL Server Backup/Recovery, Disaster recovery and planning. Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached. Participating in deployment of different patches, builds and applications latest versions using build deployment tool Octopus. Administrator tasks like managing users, roles and permissions. Creating Database Maintenance Planner for the performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics, Re-build and Re-organize indexing. Implemented different types of Replication models like Snapshot and Transactional Replication. Implemented Always-On High Availability feature in SQL 2012 servers. Used DMV’s, Performance dashboard and tracking Performance Counters. Performed database consistency checks. Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers. Taking care of RCA (root cause analysis) for various issues. Knowledge on administrating Mirroring, Log shipping, Replication and other high availability methodologies. Use of ServiceNow ticketing system, process, and procedures. Creating and managing the tickets in the ServiceNow tool.