SQL DBA Administrator at HCL Technologies (2022-04 – 2026-08)
Working as SQL DBA Administrator for HCL Technologies, Vijayawada.
Client: Volvo, Sweden.
Team Size: 15.
Tools: PostgreSQL, MS SQL Server 2022, 2019, 2016, 2014, 2012 and MS Windows Server 2012, SSMS, Profiler, Service Now.
The Volvo
Group is one of the world's leading manufacturers of trucks, buses, construction equipment and marine and industrial engines. The Group also provides complete solutions for financing and service.
The Volvo
Group, with its headquarters in Gothenburg, employs about 100,000 people, has production facilities in 18 countries and sells its products in more than 190 markets.
- Installing Postgres database in Linux server
- Working on query cancellation utilities like pg_cancel, pg_terminate
- Worked in PostgreSQL Data export and Import operations
- Performing data loading through pg_dump, psql, pg_restore
- Configuration of the streaming replication between production and DR site
- Managing the SQL Server on premise and Azure Database
- Migrated to Azure SQL Database from on-premises SQL Servers
- Configure Backup and restore Azure SQL Databases
- Implemented failover groups and Geo-replication on Azure SQL Database
- Configured Alerts for Azure SQL Databases and managing Azure elastic pool
- Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2016 Enterprise Edition
- Installing SQL Server patches and Service packs on standalone and HA Servers
- Installing different version of SQL Server version like SQL Server 2016, 2017, 2019 and 2022
- Working on Disk space issues and log growth and data file growth issues and finding the root cause and permanent fixes
- Designed and implemented comprehensive Backup plan and disaster recovery strategies
- Deploying the scripts in Prod environment
- Recovering the databases from backup in various disasters. Effective implementation of Point in time recovery procedures
- Working on configuring and maintaining transaction replication
- Working on DR activities using by Log shipping and Mirroring
- Good Experience on installation of cluster and adding nodes and failover and failback activities
- Configured and Monitored Database Always On for production environment
- Configured and Monitored Database Mirroring for production environment
MS SQL Server DBA at SourceHov India Pvt Ltd (2017-06 – 2022-04)
Worked as Database Administrator at SourceHov India.
Client: AmeriHealth, USA.
Team Size: 9.
Tools: MS SQL Server 2008, 2008R2, 2012, 2014, 2016 and 2017 and MS Windows Server 2008R2, SSMS, Profiler, DTA, Replication and Clustering, Bpots, Windows/IIS Admin. AmeriHealth is a United States health care provider which offers managed care plans to the large and small business, individual, medical, and senior markets, as well as providing healthcare and insurance services including claims processing, underwriting, actuarial services, and medical cost management. The company also offers life and disability insurance benefits, dental, vision and behavioral health benefits, long-term care insurance and flexible spending accounts.
- Providing leveraged DBA Support for many customers
- Installation, Configuration and maintenance of SQL Server 2008 and SQL Server 2012 on Production and lower environments
- Experienced in managing the Security for the Database. Created SQL Server logins, users, database level roles and schemas
- Configuring and Managing High availability techniques Replication and clustering
- Troubleshooting Space issues and performing Capacity Planning for Production Database servers
- Performing Database Refresh from Production to Stage environment
- Experience in upgrading the instances of Database servers from SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL Server 2012 both in place Upgrade and Side by Side Upgrade
- Resolving SQL Server performance issues using Profiler, DMVs, SQL Execution plans and Perfmon
- Testing and applying SQL patches to the Production Database servers on Windows environment
- Experience in Upgrading SQL Server 2005 Active\Passive Cluster to SQL Server 2008 Cluster
- Monitoring the overall performance of the Database servers and recommending actions to improve/optimize performance
- Managing Security for the SQL Server Database on Database Servers
- Experienced in configuring and managing Linked Servers, data transfer between SQL Server
- Experienced in managing Alerts, Operators and SQL Jobs through SQL Server Agent
- Experience in implementing Transactional Replication in a high OLTP environment
- Involved in Capacity Planning and experienced in resolving space issues for the database
- Creation of login accounts in Active directory
- Assigning appropriate permissions to the users to the particular folders
- Applying patches to the windows servers
- Worked on IIS deployments for various applications
- Performed IIS application pool restarts to ensure availability and performance
