Summary
Overview
Work History
Education
Skills
Accomplishments
Additional Information
Cricket, Soccer, Chess, Tennis
Timeline
Generic

Srikanthan Ragothaman

Riverview,FL

Summary

Talented SQL DBA with 8 years of progressive experience in MSSQL Administration, databases and application programming. Dedicated to building customized technical solutions in alignment with operational needs and objectives. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments.

High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.

Efficient administrator eager to leverage knowledge in cloud-based database management systems. Skilled in database security, backup and recovery with good understanding of automation and containerization tools. Team-oriented with strong work ethic.


Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.


To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

Overview

22
22
years of professional experience

Work History

SQL Server DBA

MyUS.com
02.2020 - Current
  • Working as SQL DBA handling multiple servers from 2016 to 2019 and 2022 SQL Servers
  • Handling Design, Implementation, Configuration, Maintenance and Administration of all company databases spread over multiple environments including Azure
  • Built multiple SQL Servers in Cluster and Non Cluster environments from scratch after 'Ransomware' Attack
  • Handled Design (including additional security features), Configuration (Cluster setup, AAG setup) and Implementation
  • Did in place upgrades of SQL Servers from 2016 to 2019 - Coordinated and tested with application developers to ensure compatibility and took measures to ensure smooth operations after upgrades
  • Worked and working on Multiple ETL Projects using SSIS to implement Data Movement across various platforms, with reports generated as required
  • Designed, Configured, Implemented, Setup Jobs ,Monitoring and Administering and executed Data Transformation Packages
  • Did server installs and setup for Azure Managed Instance in Azure Platform
  • In charge of backups and restores of all databases in all environments
  • Maintaining up to date backup of all objects to ensure immediate recovery in case of database crash or other issues
  • Actively testing backup and restores to ensure that functioning is at optimal level
  • Maintaining multiple backups of critical databases to ensure that data is recoverable
  • Actively managing all Windows and SQL Server updates to all servers with constant coordination and research to maintain servers at optimal level
  • Using monitoring tools like Quest Spotlight and Solar Winds DPA to maintain servers at optimal levels and proactively trouble shoot issues
  • In SCRUM meetings on daily basis to discuss further improvements and research newer technologies related to SQL Server
  • Continuous monitoring of SSIS jobs to ensure that failed jobs if any are resolved in earliest possible manner
  • Worked with Unix/Linux Team to help setup and troubleshoot applications
  • Did backup/restores and quarterly maintenance on Unix based projects
  • Basic Knowledge on Linux commands
  • Handling Tableau server installs/upgrades/permissions and administration
  • Periodic maintenance of SQL Serves including Blocking analysis, Deadlock Graph analysis, SQL Profiler analysis, Index maintenance and Query Performance Tuning
  • Periodic review of permissions and login setups so that developers can do their work without any issues
  • Daily DB server and database checks to ensure issues are found at earliest and solutions applied to keep everything running smoothly
  • Managed a team of Developers and DBA’s to ensure smooth running of projects
  • Fully setup and managed cluster services and Always on
  • Handled Database and SSIS Portion of SAP Integration Project successfully
  • Worked on multiple companywide issues including setting up SQL Server after total ransomware attack in very short time to ensure normal operations were restored
  • Providing support to developers with issue checking on API and troubleshooting issues so that production operations run smoothly
  • Providing 24x7 supports to ensure that with regards to database there is 99 % availability.
  • Designed and implemented TSQL queries for reporting and complex solution development.
  • Implemented system enhancements to design and develop solutions to address problem reports.
  • Documented analysis results and provided performance improvement feedback.
  • Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
  • Developed custom database objects, stored procedures and delivered application support.
  • Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
  • Analyzed business reports for prompt communication, follow-up and ongoing support.
  • Followed standard practices for migrating changes to test and production environments.
  • Created optimal technical solutions to user needs with in-depth system analysis.
  • Produced high-standard database solutions to meet stability, reliability and performance metrics.
  • Incorporated extensive familiarity with SQL system for data management and backup and recovery accountability.
  • Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
  • Developed scripts and processes for data integration and maintenance.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Set up and controlled user access levels across databases to protect important data.
  • Modified databases to meet needs and goals determined during planning process.
  • Set up and controlled user profiles and access levels for each database segment to protect important data.
  • Tested programs and databases to identify issues and make necessary modifications.
  • Conducted tests to identify issues and make necessary modifications.
  • Created and updated database designs and data models.
  • Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
  • Built databases and table structures for web applications.
  • Authored and coded database descriptions.
  • Created and implemented database designs and data models.
  • Developed and updated databases to handle customer data.
  • Adhered to set schedules to test databases for flaws and reduce downtime.
  • Coordinated with project management on database development timelines.
  • Designed and developed analytical data structures.
  • Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
  • Implemented BI solution framework for business intelligence projects.
  • Wrote and maintained technical and functional specifications to document database intentions and requirements.
  • Implemented security measures to protect vital business data.
  • Installed and configured middleware in Linux and Windows environments.

SQL Server DBA

NVR INC
01.2013 - 01.2020
  • Worked as a SQL Server DBA handling more than 95 SQL Servers (Physical and VM)
  • Responsible for the lease replacement, end to end management of the sql servers, backup, DR process, trouble shooting, migration from 2008/2012 to 2016 and necessary permissions
  • NVR is a Home Building Company that uses SQL Server as backend for their database needs
  • Working as one of the 2 DBA's handling the whole company requirements in terms of its data needs and handle more than 200 TB of data through the 95+ servers and multiple databases
  • Key Responsibilities: Lead for the Project for Installing, Upgrading and configuring multiple instances SQL Server 2008 R2/SQL Server 2012/SQL Server 2016
  • Lead for the Migration Project for migrating SQL Servers from 2008 to 2012 and 2008/2012 to 2016
  • Migrated over 40 servers
  • Worked on some ETL projects
  • Developed and deployed multiple SSRS Projects both on the SSRS side and also the database side
  • Played a lead role with multiple SSIS/SSRS project deployments to all environments and migration of SSIS/SSRS servers from 2008 to 2016
  • Setup roles/permissions for SSIS/SSRS migration projects and involved in trouble shooting package run issues and report issues
  • Provided trend analysis to management team on a daily basis and on a need by basis Ensured that the databases are configured for high resilience and kept the resources and the databases at an optimal level of tuning with tweaks when needed
  • Played an active role in the request for hardware, software and tools needed Proved as the end point for developers in assisting with issues
  • Was responsible for the overall health of the databases and ensured that databases were available 24 x 7 sans maintenance Setup TDE and other encryptions in various environments and servers
  • Implemented various backup strategies to adhere to the SLA requirement of the company and ensured that the backups were happening and on time
  • Supporting multiple applications on Development, Test/UAT, Staging and multiple Production servers for internet and intranet applications on SQL Server 2008 to SQL Server 2012/2016 and SQL Azure
  • Installed and configured SQL Server 2016 Always On Availability Groups Installed and configured SQL Server 2008/2012/2016
  • Reporting and Integration Servers Handled Microsoft Team Foundation Server Supporting and deploying Web Applications on IIS Tuning Stored Procedures Deployed, Maintained and Migrated SSIS packages for the Data Warehouse Team
  • Planning and estimating storage capacity for database objects, backup files Designing, creating and managing the database and all database objects
  • Developed Database Maintenance Plans for Database backups and recovery, reorganizing data and for Database integrity checks Backup Strategy included full and transactional log backups that varied from database to database
  • Used SAN mount points for database files to easily move the database objects to staging or development by presenting the views
  • Used Database monitoring tools to get Server/Database performance trends, analyzed and collected data randomly and on need basis
  • Worked as a team and interacted with other DBA's to setup and follow best practices, alternate and efficient coding methods and infrastructure discussions
  • Heavily involved in change management and configuration management
  • Deployed multiple applications both in house and COTS/Vendor applications on UAT/STAGE/PRODUCTION servers
  • Received Customer Service Awards a few times
  • Responsive, eager to please and hardworking team player who is involved from start to end in any application that involved database component
  • Implemented system enhancements to design and develop solutions to address problem reports.
  • Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
  • Followed standard practices for migrating changes to test and production environments.
  • Created optimal technical solutions to user needs with in-depth system analysis.
  • Incorporated extensive familiarity with 'Rubrik' system for data management and backup and recovery accountability.
  • Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
  • Developed scripts and processes for data integration and maintenance.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Set up and controlled user access levels across databases to protect important data.
  • Modified databases to meet needs and goals determined during planning process.
  • Tested programs and databases to identify issues and make necessary modifications.
  • Conducted tests to identify issues and make necessary modifications.
  • Built databases and table structures for web applications.
  • Created and updated database designs and data models.
  • Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
  • Authored and coded database descriptions.
  • Created and implemented database designs and data models.
  • Developed and updated databases to handle customer data.
  • Adhered to set schedules to test databases for flaws and reduce downtime.
  • Coordinated with project management on database development timelines.
  • Designed and developed analytical data structures.
  • Implemented BI solution framework for business intelligence projects.
  • Implemented security measures to protect vital business data.

DBA

Verizon Data Services
02.2002 - 01.2016
  • Managed complete eDesk application Databases as SQL
  • EDesk application displays reporting metrics on webpages and ensures that metrics are available to internal and external decision makers .Was SQL Server DBA for General Business Registration Application that enabled business users to register to Verizon.com website and use self serve options
  • Worked as Production and development SQL Server DBA ensuring database availability and performed restores, implemented recovery procedures, handled performance tuning and conducted regular system backups
  • Engaged and oversaw testing and troubleshooting on all phase of project based Software Quality Assurance through Wholesale and retail dimensions
  • Key Responsibilities: Led Projects for Migration of Databases (multiple Very Large Data Bases) from one environment to another ensuring data availability is not compromised when data centers were shut down
  • Installed, Configured, and Managed SQL Server 2008R2, MS SQL Server 2008, 2005 & 2000 in development, test/Staging, and production environment ( both clustered and non-clustered) Lead Project for Disaster Recovery and coordinated third party backup software (Snap Manager and Netbackup) ensuring proper backup availability and savings of over 1M
  • Played the lead role in setting up Transactional Replication (high availability solution) ensuring data loss was virtually nonexistent Lead the LUN Storage Project to completion ensuring data was getting backed upto correct location ensuring savings of more than 600K
  • Applied all Service Packs, HOT Fixes and assisted in application of patch on Windows 2003 servers
  • Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, monitored SQL Server error logs and space usage Utilized Data Modeling Tools ( Visio and SQL Server Data Diagram) and created E-R diagrams for data modeling projects Installed, Configured and Maintained Database Mirroring using automatic fail-over option for SQL Server 2008
  • Configured Log Shipping as standby database from Production database for Reporting Purposes Configured and maintained Snapshot and Transactional Replications
  • ENVRIONMENT : MSSQL, SERVERS 2003, 2005/2008R2/2012/2016, WINDOWS 2003/2008/2012/, , LINUX,INFORMIX, UNIX, SQL REPORTING SERVICES, SHARE POINT PORTAL, SSIS
  • Tested programs and databases to identify issues and make necessary modifications.
  • Created and updated database designs and data models.
  • Built databases and table structures for web applications.
  • Developed and updated databases to handle customer data.

Education

Certificate in Project Management: Project Management -

Villanvova University
Penn, PA
05.2009

Master of Business Administration - Business Adminstration

University of Maryland University College
College Park, MD
2007

Master of Science - Information Technology

Strayer University
Arlington, VA
2004

ILOG - JRules 4.0 MQ Series Overview UNIX for developers, Java for the Web BEA - WebLogic Integration 2.1, SQL Server 2008 CERTIFICATIONS RDBMS - SQL Servers 2003 to 2016. -

Villanova University
Arlington, VA
02.2003

Skills

  • Design, Development, Implementation ,Configuration, Maintenance and Full Administration of SQL Server Databases based on Client needs
  • Have setup Multiple Clustered Instances with Always On including Azure Instance with multiple Replication, Backup and Restores, Encryption setup on multiple environments
  • Well proficient in Data Manipulation Languages with special reference to MS SQL
  • Critical thinker with analytical mindset and have very good problem solving skills
  • Experienced DBA with SQL Server 2008 to 2022 and Operating Systems from 2008 to 2022
  • Languages/Tools/Utilities - SQL, PowerShell, Activity Monitor, SQL Profiler, Perfmon, Idera, Redgate SQL Monitor, Solar Winds, Quest Spotlight, Extended Events
  • Others : SSIS/SSRS/Power BI
  • Flat file Data Systems : Progressive and Pervasive
  • Security Standards, Root cause Analysis, HADR technologies

Accomplishments

  • Created a consolidated database to improve efficiency by 40%.
  • Optimized existing procedures to improve performance by 90% for multiple codes
  • Managed more than 30 servers and 90 databases on a day to day basis
  • After a ransomware attack, setup the whole SQL Server (including cluster, AAG) from scratch to normal operations in 2 weeks
  • Migrated multiple servers and databases from 2008 to 2016 and from 2016 to 2019 and 2022.
  • Multiple improvements on Performance of the servers and databases to keep them running at the optimal level
  • Managed a team of 3 Database developers
  • Lead the Database side for the SAP Integration project
  • Played a major part in Data Center move from one Datacenter to another Datacenter

Additional Information

  • Status: , U.S Citizen and Security Clearance: Clearable

Cricket, Soccer, Chess, Tennis

Passionate about cricket and Chess.  One keeps you physically active and the other improves the mental structure.

Timeline

SQL Server DBA

MyUS.com
02.2020 - Current

SQL Server DBA

NVR INC
01.2013 - 01.2020

DBA

Verizon Data Services
02.2002 - 01.2016

Certificate in Project Management: Project Management -

Villanvova University

Master of Business Administration - Business Adminstration

University of Maryland University College

Master of Science - Information Technology

Strayer University

ILOG - JRules 4.0 MQ Series Overview UNIX for developers, Java for the Web BEA - WebLogic Integration 2.1, SQL Server 2008 CERTIFICATIONS RDBMS - SQL Servers 2003 to 2016. -

Villanova University

Similar Profiles

CREATE PROFILE
Srikanthan Ragothaman