Ranjit Gupta

Ranjit Gupta Email and Phone Number

Sr. Database Infrastructure Engineer @ Health Care Service Corporation
Texas, United States
Ranjit Gupta's Location
Allen, Texas, United States, United States
Ranjit Gupta's Contact Details

Ranjit Gupta work email

Ranjit Gupta personal email

n/a
About Ranjit Gupta

Highly experienced Senior SQL Database Administrator with a proven track record in database administration, and infrastructure management. Demonstrated expertise in managing complex IT environments and delivering high-quality solutions across diverse industries. Extensive knowledge of SQL Server (all versions), Azure Cloud computing, database development, ETL, Reporting, Analysis Services, and DevOps technologies. Committed to maintaining and optimizing cutting-edge database systems to support organizational goals and drive innovation.

Ranjit Gupta's Current Company Details
Health Care Service Corporation

Health Care Service Corporation

View
Sr. Database Infrastructure Engineer
Texas, United States
Ranjit Gupta Work Experience Details
  • Health Care Service Corporation
    Sr. Database Infrastructure Engineer
    Health Care Service Corporation
    Texas, United States
  • Premera Blue Cross
    Senior Sql Server Database Administrator
    Premera Blue Cross
    Allen, Tx, Us
  • Premera Blue Cross
    Senior Sql Database Administrator
    Premera Blue Cross Feb 2015 - Present
    Mountlake Terrace, Washington, Us
    Sr. SQL Database Administrator, Premera Blue Cross, Mountlake Terrace, WA (Mar 2018 – Present)Project description: Worked in development, upgrade, and migration of legacy business system applications from existing Datacenter and lead in analyzing and optimizing the performance of applications.Responsibilities:- Deliver 24x7 support for over 8,000 databases, including environments up to 27 TB.- Lead design and migration of on-premises databases to Azure SQL during cloud transition.- Collaborate with teams to resolve performance issues and optimize databases using various SQL Server technologies.- Manage migrations, disaster recovery, and security protocols, ensuring HITRUST compliance.- Execute incident and change management, leveraging Agile and Scrum methodologies.
  • T-Mobile
    Sql Server Database Administrator
    T-Mobile Aug 2014 - Jan 2015
    Bellevue, Wa, Us
    SQL Server DBA, T-Mobile, Bothell, WA (Aug 2014 – Jan 2015) - Contract Project description: The scope of the project was optimizing the existing databases and providing operational support for IT. Responsibilities:- Managed hundreds of SQL Server instances and thousands of databases across SQL 2005, 2008/2008R2, 2012, and 2014.- Troubleshot critical production issues and performed business analysis, producing effective documentation.- Monitored SQL servers using third-party tools such as Foglight and SQL Sentry.- Handled incidents and tickets, and implemented comprehensive backup policies, including full, differential, and transactional backups for Production, QA, and DEV environments.- Executed point-in-time recovery and data refreshes between production and non-production environments, and managed logins, roles, and connectivity issues.
  • Lsa Laser Llc
    Sql Server Dba
    Lsa Laser Llc Apr 2008 - Aug 2014
    SQL Server DBA, LSA Laser LLC Plymouth, MN (Feb 2012 – April 2014)Project description: The scope of the project was centered on the optimization of existing databases and ETL strategies and operation.Responsibilities:- Developed SSIS packages to transfer data from heterogeneous sources like Oracle to SQL Server, including MS Access, Excel spreadsheets, and flat files.- Utilized ETL and SSIS tools to perform data loading and implement various Data Flow Transformations, such as Copy Column, Row Count, Merge Join, Aggregator, Sort, and Lookup.- Managed and scheduled daily jobs for data transfers, backup and recovery, transaction log dumps, integrity checks, and updating statistics.- Generated daily reports to monitor database growth, failed jobs, failed backups, and failed transactional log backups.- Secured SQL Server by creating and managing user and Windows logins, assigning roles, and granting privileges based on approval.

Ranjit Gupta Skills

Microsoft Sql Server Sql Server Integration Services Sql Server Reporting Services Mongodb Replication

Ranjit Gupta Education Details

  • Metro State University
    Metro State University
    Computer Science
  • North Hennepin Community College
    North Hennepin Community College
    Computer Science

Frequently Asked Questions about Ranjit Gupta

What company does Ranjit Gupta work for?

Ranjit Gupta works for Health Care Service Corporation

What is Ranjit Gupta's role at the current company?

Ranjit Gupta's current role is Sr. Database Infrastructure Engineer.

What is Ranjit Gupta's email address?

Ranjit Gupta's email address is ra****@****era.com

What schools did Ranjit Gupta attend?

Ranjit Gupta attended Metro State University, North Hennepin Community College.

What skills is Ranjit Gupta known for?

Ranjit Gupta has skills like Microsoft Sql Server, Sql Server Integration Services, Sql Server Reporting Services, Mongodb, Replication.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.