Baji Shaik
Vijayawada
Summary
Adept at database administration, I leveraged my expertise in MS SQL Server (2005-2019) and robust problem-solving skills at Cogneesol Private Limited, enhancing system efficiency and reliability. My proactive approach to database optimization and commitment to continuous learning have significantly contributed to operational excellence, underscoring my ability to meet and exceed employer expectations.
Overview
6
6
years of professional experience
Work History
DBA L2 ( Assistant Manager)
Cogneesol Private limited
Pune
10.2022 - Current
- Developing and maintaining databases, ensuring data security.
- Tuning performance, backing up data, and providing training and support to users.
- Creating and maintaining database standards and policies.
- Supporting database design, creation, and testing activities.
- Designing database backup, archiving, and storage strategy.
- Installing upgrades and patches to various apps.
- Administering database objects to achieve optimum utilization.
- Defining and implementing event triggers that will alert on potential database performance or integrity issues.
Database Administrator
IKEA
08.2020 - 09.2022
- Company Overview: IKEA is a multinational group of companies that designs and sells ready-to-assemble furniture appliances and home accessories
- As of January 2008, it is the world's largest furniture retailer
- Founded in Sweden in 1943 by then-17-year-old Ingvar Kamprad, who was listed as one of the world's richest people in 2013, the company's name is an acronym that consists of the initials of Ingvar Kamprad, Elaterid, and Agunnaryd
- Installation of New SQL Server Servers of SQL 2012/2014/2016/2017 and 2019
- Configuring Log Shipping, Mirroring Always on Groups and troubleshooting
- Applying patches to standalone and in cluster environments
- Migrating databases from test servers to the new environments
- Restoring the db's from prod to test environment
- Creating and Monitoring SQL Server agent jobs, Maintenance plans, and troubleshooting as required
- Migrating SSIS packages & SSRS reports from one server to another server
- Performing optimization tasks on the database such as re-organizing and rebuilding the indexes, Shrinking, etc.
- When ever required to increase the performance
- Executing the scripts in Production environments
- Performing day-to-day operations based on Incident Management, Problem Management, and Change Management
- Performing Database Consistency Checks on Databases and Tables
- Configured, Deployed & Administering of Log shipping, Database Mirroring, Clustering for critical databases
- Configuring Transaction replication and troubleshooting issues
- Configuring and performing failover and failback tests in cluster environment
- Having Knowledge in Oracle Database
Database Administrator
Johnson & Johnson
Hyderabad
06.2019 - 07.2020
- Implemented efficient backup planning strategy to maintain the data to be highly available via Management plans and Jobs
- Administering Replication, Log shipping, Mirroring
- Configuring the SQL servers in SCOM monitoring
- Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
- Assigning appropriate permissions to the users as required following the principle of least privilege
- Creating and Monitoring SQL Server agent jobs and troubleshooting as required
- Monitoring SQL Server Performance using profiler to find performance locks and blockings
- Administering Large Databases from capacity planning to database design and maintenance
- Setting up Linked Servers
- Configuring and implementing the third party backup tool like NetBackup for SQL Server to automate the backup process
- Deploying the scripts in production environment
- Deploying the SSIS packages in MSDB or File system
- Migrating the reports from lower to higher versions
- Migrating the db's and upgradation of DB's
Data Base Administrator
WINCO FOODS
12.2018 - 05.2019
- Company Overview: WinCo Foods, Inc
- Is a privately held, majority employee-owned American supermarket chain based in Boise, Idaho with retail stores in Arizona, California, Idaho, Nevada, Oregon, Texas, Utah, and Washington
- It previously operated stores as Ware mart Food Centers and Cub Foods (under a franchise agreement) until 1999
- As of November 2015, it has 104 retail stores and five distribution centers with over 15,000 employees
- Inco Foods is based in Boise, Idaho
- It was founded in 1967 and most of the company ownership is held by current and former employees through an employee stock ownership plan
- Installation & Configuration of SQL Server 2005/2008/2008/R2 on Local System and Remote System
- Maintaining of over 200+ servers
- Continuously monitoring and updating the Backup & Recovery strategy and also monitoring scheduled jobs of backup and restore procedure for database
- Performing the DB checklist and Critical server checklist
- Configuring the backups for all the db's and working for failure backups
- Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support
- Identifying/resolving fragmentation resulting in improved performance
- Troubleshooting transaction logs and Tempdb when full
- Hands on experience in High Availability such as Log-Shipping, Database Mirroring, Replication and Clustering
- Monitoring SQL Server alerts at regular intervals
- Monitoring SQL Server agent jobs/maintenance plans
- Provided 24
- 7 Production support for the database and application issues
- Co-coordinating with Development, Test and Support teams for server wide issues
- Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks
- WinCo Foods, Inc
- Is a privately held, majority employee-owned American supermarket chain based in Boise, Idaho with retail stores in Arizona, California, Idaho, Nevada, Oregon, Texas, Utah, and Washington
- It previously operated stores as Ware mart Food Centers and Cub Foods (under a franchise agreement) until 1999
- As of November 2015, it has 104 retail stores and five distribution centers with over 15,000 employees
- Inco Foods is based in Boise, Idaho
- It was founded in 1967 and most of the company ownership is held by current and former employees through an employee stock ownership plan
Education
Master of Business Administration -
Andhra University
01.2010
Skills
- Windows Family (XP/2000/2003/2008)
- MS SQL Server 2005
- MS SQL Server 2008
- MS SQL Server 2008 R2
- MS SQL Server 2012
- MS SQL Server 2014
- MS SQL Server 2016
- MS SQL Server 2017
- MS SQL Server 2019
- Enterprise Manager
- Query Analyzer
- SSMS
- SQL Profiler
- HPSM
- Service Now
- SCOM
- EMC Networker
- Writing queries
- Database analysis
- Running backups
- Data conversion and migration
- Microsoft SQL
- Database backup
- Database monitoring
- Patch management
- Backup and recovery
Languages
- English
- Telugu
- Hindi
Personal Information
- Date of Birth: 06/06/87
- Marital Status: Married
Languages
Hindi
First Language
English
Advanced (C1)
C1
Urdu
Intermediate (B1)
B1
Timeline
DBA L2 ( Assistant Manager)
Cogneesol Private limited
10.2022 - Current
Database Administrator
IKEA
08.2020 - 09.2022
Database Administrator
Johnson & Johnson
06.2019 - 07.2020
Data Base Administrator
WINCO FOODS
12.2018 - 05.2019
Master of Business Administration -
Andhra University
Similar Profiles
Shrinivas KolturShrinivas Koltur
Assistant Manager at CogneesolAssistant Manager at Cogneesol
Shrinivas KolturShrinivas Koltur
Assistant Manager at CogneesolAssistant Manager at Cogneesol
Parkash Deep SinghParkash Deep Singh
Head of Marketing at CogneesolHead of Marketing at Cogneesol