Siddartha K

Client Name: Zurich

• Provide on Call Support for Prod mission-critical (24x7) or problematic databases, and own problem resolution from end-to-end
• Strong Experience with SQL servers 2000-2022 administration, maintenance & Installation
• Demonstrate expertise in complex environments, including on-premises and cloud-based systems
• Extensive experience in Production and Pre-Prod, Test Servers
• Experience in applying the service packs and CU in both Standalone, Cluster Nodes and Always on servers
• Upgrade/Migrate SQL Server from SQL 2005 to SQL 2019
• Expertise in Configuring recovery models of databases and designing backup strategies
• Experience in Managing and maintaining MySQL databases ensuring high availability and performance
• Administer AWS database services including RDS, Aurora, and DynamoDB
• Experience in Implementing and managing the databases NoSQL, MongoDB and DynamoDB
• Expertise in implementing replication and high-availability strategies
• Restored corrupted databases and recovered them with minimal/zero data loss
• Understanding of Server Roles, Database Roles, and Permissions
• Configuring HADR like Log Shipping, Mirroring, Clustering, Always-On & Replication
• Experience in Conducted database structural maintenance, managing space and storage, and ensuring optimal physical layout
• Actively Participate in High Availability and Disaster Recovery tests, ensuring the resilience and reliability of the platform during adverse scenarios
• Diagnosing Server slow, Application slow, and Database slow performance situations
• Experience in handling blocking issues and deadlock issues
• Resolving 100% CPU troubleshooting using appropriate Perfmon Counters and DMVs considering factors like High IO, Query load, Cost Threshold & MAXDOP
• Specialist in third-party tools solar Winds, Idera, and Commvault
• Experience in Installing and configuring SSRS, SSIS, and SSAS and SSIS, SSRS packages deployment
• Expertise in Application and Production support activities
• Experience in implementing the TDE on critical applications
• Good Experience in configurations of Postgres SQL, and Oracle database systems
• Extensive experience in conducting regular system checks, troubleshooting, and proactive monitoring to identify and resolve potential issues
• Ability to accept challenges, learn, and grow in a good professional manner

Client Name: UBS (Union Bank of Switzerland)

• Establish new build environments on Windows/Linux for diverse applications while developing and deploying Azure and AWS services, emphasizing performance and cost-effectiveness
• Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking
• Ensure and maintain backup and recovery policies and procedures
• Actively monitor and administer applications, ensuring efficiency and minimizing downtimes, while applying the Patching’s
• Performing data refresh activities from production to Dev/Test on an ad-hoc basis
• Backup and restore the databases from production to test environment
• Creating and reviewing Security features for all the servers
• Handling Master, Model, MSDB, TEMPDB, and Resource database corruptions
• Experience in Configuring Log Shipping and mirroring
• Experience in SQL Profiler, Extended Events, and Performance Counters
• Expertise in Ensuring Data consistency in the database through DBCC commands
• Expertise in Configuring the Maintenance Jobs (Full Backup, Differential, Log, Rebuild, Re-Organize)
• Maintain & Monitor Alerts/Schedules to make a smooth replication process
• Expertise in Performance tuning of applications, databases, and operating systems
• Expertise in upgrading/migrating the traditional architecture databases to multi-tenant databases and regular maintenance of the multi-tenant databases
• Review/Prepare Implementation Pack, Job Procedure, and Process Flow documents as required
• Expertise in handling the day-to-day issues that arise in a very critical production environment
• A project planner with expertise in spearheading Database Projects involving planning, implementation, migration, upgrades, partitioning, compression, patching, cloning, and administration, ensuring delivery of projects within the time and cost parameters
• Experience in Monitoring database systems to detect issues and respond to incidents promptly, escalating as necessary to meet SLA requirements
• Collaborated with data engineering teams to optimize data pipelines and enhance data processing efficiency
• Focused towards ITIL Framework (Incident/Change/Problem Management)
• Successful in communicating with people at all levels and with other departments as needed to Serve the customer best
• Collaborated closely with cross-functional teams to define technical requirements for new initiatives.
• Leveraged machine learning algorithms to predict trends from massive volumes of unstructured data.
• Implemented real-time monitoring tools to detect anomalies in data streams swiftly.
• Created interactive dashboards using BI tools such as Tableau, empowering non-technical stakeholders with actionable insights.
• Managed end-to-end data pipeline construction for seamless integration of disparate data sources.
• Led team training sessions on best practices in database management and maintenance, enhancing overall staff proficiency.

Client Name: Travellers

• Good knowledge in using the Terraform for Infrastructure as Code (IaC) to automate database deployment and management
• Installation and configuration of MS SQL Server 2005, 2008, 2012, 2014, 2016, 2017, 2019
• Planned phased implementation of security patches in coordination with the application team to minimize downtime to end users
• Expertise in Monitoring the database performance using AWS Performance Insights, CloudWatch, and Datadog
• Expertise in communicating with Global teams to quickly and effectively handle issues
• Focused towards ITIL Framework (Incident/Change/Problem Management)
• Collaborated across teams to address technical challenges efficiently
• Mentored & Trained Seven Junior resources and saved a huge amount of cost to the company for hiring