Database Administrator Sql Server

Vijesh Bysani Ramnathgupta PROFESSIONAL PROFILE

SQL Server DBA

PROFILE SNAPSHOT: 15 Years of expertise in IT Industry and proven success innovating state-of-the-art solutions on time and under budget. Highly skilled and results-driven Database Architect with extensive experience in managing and optimizing SQL Server (MSSQL) and SAP Hana databases in cloud environments such as Azure and AWS. Proficient in database design, implementation, performance tuning, high availability, and disaster recovery. Adept at ensuring seamless database operations, troubleshooting complex issues, and implementing best practices for security and compliance.

With hands-on expertise in cloud platforms, I have successfully migrated, deployed, and managed enterprise-level databases in both Azure and AWS, leveraging cloud-native tools and services to enhance scalability, reliability, and performance. Experienced in automating routine DBA tasks, ensuring data integrity, and optimizing database environments for mission-critical applications. Strong understanding of backup, restoration, and recovery processes, with a focus on minimizing downtime and ensuring data availability.

Possessing a deep understanding of both on-premises and cloud architectures, I collaborate effectively with cross-functional teams to ensure the smooth operation and strategic growth of database infrastructure. Continuously staying updated with the latest industry trends, I bring innovative solutions to complex database challenges and drive successful cloud migration strategies. Education:

Bachelor of Information Science and Engineering from Sri Venkateswara college of Engineering affiliated to VTU, Belgaum, India during the period 2005 – 2009.

Achevements:

• Pat on the Back award in Societe Generale in 2017.

• Team spot awards in Mindtree in the year 2013 .

• CORONA Award for Best performance in ‘CME MAS –Database Support

& Enterprise Security’ in CGI India.

• ECS Cloud Success STEP Award in 2020.

• ECS Cloud Success STRIDE AWARD in 2021

Certifications :

AWS Certified Cloud Practitioner

AWS Certified Cloud Practitioner

Microsoft Certified: Azure Administrator Associate (AZ-103)

Microsoft Certified IT Professional: Database Administrator 2008

Cohesity Platform Foundations.

Leadership Skills 2022 - Leadership Academy Foundation Program

SAP Certified Technology Associate - SAP HANA 2.0 (SPS04) Contact No: +1-518-***-****

Email:

******.*******@*****.***

Technical Knowledge

RDBMS: MSSQL & SAP Hana Database

Administration

Scripting: PowerShell, TSQL.

Azure/AWS: Compute, Storage,

Databases, Networking, Azure IaaS,

PaaS, Cost Management.

Cloud Storage: Azure Blob Storage,

AWS S3, EFS/EBS, ANF/AFS, Storage

Access Tiering Policies.

Networking: Azure Virtual Networks,

AWS VPC, Network Security Groups,

Private and Public endpoints.

Security: Azure Active Directory, AWS

IAM, Encryption at Rest and Transit.

Azure: Azure Backup Vault, Backup

Policies, Recovery Services, Azure VM

Backup, Azure Fileshare Backup.

AWS: AWS Backup Vault, Backup

Plans, Lifecycle Management, AWS EC2

Instance Backup, RDS Backup,

Lambda.

Backup Tools: Networker/DDVE and

Cohesity Backup tool

OS: Windows, Linux.

IaC: Terraform, Auzre Devops

Soft Skills

Decision Making and Problem solving

Ability to work in a cross-cultural

environment.

Professional Summary :

1. SAP LABS (IT Architect Senior Specialist - MSSQL) Duration : August 2018 to April 2025.

Administered and maintained Azure SQL Database instances, including both single databases and elastic pools, ensuring optimal performance, scalability, and reliability.

Managed the deployment, configuration, and monitoring of SQL databases in Azure, including setup of Azure SQL Managed Instances and Virtual Machines with SQL Server.

Led and executed database migration projects from on-premise SQL Server environments to Azure SQL Database and Azure SQL Managed Instances with minimal downtime.

Managed the upgrading of databases and SQL Server instances in Azure, ensuring smooth transitions to newer versions and patch updates.

Optimized database performance using Azure SQL Database's performance features, including automatic tuning, index optimization, and query performance insights.

Identified and resolved performance bottlenecks by analyzing query execution plans, applying indexing strategies, and adjusting configuration settings.

Provision Microsoft SQL Server (MSSQL) on AWS using Terraform.

Implemented and managed Azure SQL Database's high availability features, including Geo-replication, Always On availability groups, and automatic failover groups.

Configured backup and recovery strategies, utilizing Azure Backup and Point-In-Time restore capabilities to ensure data protection and business continuity.

Enforced security policies for Azure SQL Database environments, implementing role-based access control (RBAC), dynamic data masking, and encryption (TDE, Always Encrypted).

Applied security updates and patches to SQL Server instances in Azure, ensuring compliance with industry standards such as GDPR, HIPAA, and SOC2.

Monitored and optimized cloud resource usage, including database pricing tiers, storage, and compute resources, to ensure cost- effective use of Azure resources.

Leveraged Azure Cost Management tools to track and control spending, suggesting optimizations and scaling down resources where necessary.

Automated routine DBA tasks using Azure Automation, Azure Logic Apps, and PowerShell scripts for backups, performance tuning, and scaling.

Set up real-time monitoring and alerts using Azure Monitor, Log Analytics, and Azure SQL Analytics to proactively detect and resolve issues.

Implemented disaster recovery plans using Azure Site Recovery and backup vaults to protect databases from potential failures.

Worked closely with developers to optimize database designs, stored procedures, and queries for efficient performance in Azure SQL environments.

Provided recommendations for indexing strategies, partitioning, and query optimizations to improve application performance on the cloud.

Managed firewall rules, virtual network configurations, and private endpoints to secure database access within Azure.

Utilized Azure Data Studio, SQL Server Management Studio (SSMS), and Azure CLI for administration tasks, performance tuning, and database monitoring.

Supporting SAP HANA cloud landscape in SAP Labs.

Good working Experience on complex HANA environments like Multinode, 3-tier / Multi-tier Replication enabled systems.

Good Understanding of Hyperscalers & supporting HANA hosted in Hyperscalers for ECS.

Responsible for validating and releasing new revisions HANA for SAP customers.

Expertise in building & supporting SAP HANA databases on cloud platform.

Expertise in Upgrading & Migrating HANA databases using different downtime optimized options.

Strong troubleshooting experience and handled different HANA database issues

Driven multiple very high priority bridge calls to closure and responsible to Deescalate issues by providing necessary technical support.

Good experience troubleshooting HANA Performance, memory & CPU usage issues and analyzing HANA traces and dumps.

Worked with tools like DBA Cockpit, HANA studio, HANA hotspots, Ximo Studio for troubleshooting.

Having experience analyzing query plans using tools like Explain statement, PlanViz, SQL trace.

Good Understanding of SQL optimizer, HANA engines & enumeration options. 2. Society General Global solution center.

Organization : Society General (Senior Cloud Engineer- MSSQL) Duration : February 2016 to August 2018

Details of the project:

Société Générale is a French multinational banking and financial services company. The company is a universal bank and has divisions supporting French Networks, Global Transaction Banking, International Retail Banking, Financial services, Corporate and Investment Banking, Private Banking, Asset Management and Securities Services. Roles and responsibilities :

Implement and troubleshoot the high availability of solutions like Always ON, Clustering, Database mirroring and Logshipping in SQL Server

Automating L1 and L2 tasks - Disk check, SQL Server job failure, Security audit, SQL Server logs using Powershell.

Experience in designing, testing and implementing the enterprise Disaster recovery using Logshipping, Always ON and SQL Server Multi-Subnet Clustering.

Knowledge of T-SQL queries for High performance database application.

Creating Grafana dashboard for MSSQL using InfluxDB and Telegraf service.

Experience in upgrading and migrating from SQL Server 2008r2 to SQL Server 2014/2016 .

Performance Troubleshooting using Solarwinds DPA .

Azure IO performance evaluation and comparison with BareMetal.

XIO Data Migration using EMC Open Migrator.

Automation of Customer data migration using Powershell.

Creation of Custom monitoring for DB_Owner, database file restricted growth.

Database Hardening for MSSQL Monitoring.

Exposure in setting up new futures of SQL Server Stretch database, Dynamic data masking and Query store.

Configuring TDE on the database and SSL Certificate for SQL Server security.

Backup or Restore test using DD Boost.

3. LTIMindtree Ltd

Organization : Mindtree (Lead MSSQL DBA )

Duration : June 2013 to February 2016.

Details of the project :

Raet is a leading e-HRM software in the Netherlands and have started their business out of NL recently. They mainly offer HR solutions and various options/flexibility to their clients with ‘n’ number of applications. Working as a core SQLDBA for all their applications across DTAP environment.

Roles and responsibilities :

Successfully involved in complete end to end transition of all the production database servers from onsite to offshore. This includes right from creating inventory till offering solutions to High availability concepts and migrations.

End to end responsibilities of SQL server upgradation and migrations of various applications.

Experience with planning, designing, building and implementing disaster recovery environment

Designing, configuration and troubleshooting high availability concepts like multi node clusters and transactional Replication for various applications

Responsible for designing effective monitoring in place for all the aspects of database servers for a monitoring tool called MWatch.

Solely responsible for LUN administration

Installations and configuration of SQL server stand alone and clusters.

Monitoring/Troubleshooting performance Issues using various techniques

Performing Backup and Restoring duties.

Implementing, refining and modifying storage management configuration of mdfs, ndfs and ldfs.

Building, modifying, scheduling and troubleshooting SQL Server maintenance jobs

Perform proactive SQL Server Health Checks and taking necessary decisions as and when required

Executing T-SQL queries and Stored procedures

Troubleshooting Temp DB & DB Space Issues both at database and disk level.

Configured Database mail and linked servers in SQL server.

Conducted various meetings and conferences with different teams and customers to meet corporate milestones for database server maintenance and data migration. Security and architectural planning for database servers along with architecture teams.

Have experience in utilizing ETL tools, including SSIS and ETL Package design.

Trained 10 member of DBA team and been award as best faculty for the year 2013-2014. 4. CGI Information Systems

Organization : CGI Information System (Associative Software Engineer -DBA) Duration : June 2010 to May 2013

Details of the project :

Bell Canada is a Canadian telecommunications and media company headquartered in Montreal, Quebec. Including its subsidiaries Bell Aliant, Northwestel, Télébec, and NorthernTel, it is the incumbent local exchange carrier for telephone and DSL Internet services in most of Canada east of Manitoba and in the northern territories, and a major competitive local exchange carrier for enterprise customers in the western provinces.

Roles and responsibilities

Perform proactive SQL Server Health Checks

Involved in capacity planning, sizing and database growth projections.

Performed installation of SQL Server Service Packs and CU’s.

Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.

Reviewed DB Scripts from the development team before releasing them into the Production.

Maintaining the Process Document & Creation of the same in SQL Server

Performing Backup and Restoring duties on Production, Development, UAT Environments

Implementing, refining and modifying storage management configuration of mdfs, ndfs and ldfs.

Building, modifying, and scheduling SQL Server maintenance jobs

Monitoring/Troubleshooting Blocker Issues. Performance monitoring and tuning of I/O related issues.

Monitor Production Instances and respond to alarms as per the monitoring definitions.

Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard

Contact this candidate