Baji Shaik

Backend Engineer

Pune Division, Maharashtra, India15 yrs 3 mos experience

Highly Stable

Key Highlights

Expert in SQL Server Management and Database Administration.
Proven track record in performance optimization and troubleshooting.
Strong experience in high availability and disaster recovery solutions.

Stackforce AI infers this person is a Database Administrator with expertise in SQL Server management and high availability solutions.

Contact

Skills

Core Skills

Database AdministrationSql Server Management

Other Skills

Installation of New SQL Server ServersConfiguring Log ShippingTroubleshootingApplying patchesMigrating databasesRestoring databasesCreating and Monitoring SQL Server agent jobsPerformance optimizationIncident ManagementChange ManagementDatabase Consistency ChecksDatabase MirroringClusteringTransaction replicationBackup planning strategy

Experience

15 yrs 3 mos

Total Experience

3 yrs 10 mos

Average Tenure

3 yrs 7 mos

Current Experience

Cogneesol

2 roles

SQL Database Administrator

Oct 2022 – Present · 3 yrs 7 mos

Database Administrator

Oct 2022 – Present · 3 yrs 7 mos

· 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... Whenever 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.

Installation of New SQL Server ServersConfiguring Log ShippingTroubleshootingApplying patchesMigrating databasesRestoring databases+10

Johnson & johnson

Database Administrator

Jun 2019 – Sep 2022 · 3 yrs 3 mos

· 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.

Backup planning strategyAdministering ReplicationLog shippingPerformance tuningMonitoring SQL Server PerformanceAdministering Large Databases+6

Winco foods, usa

Database Administrator

Dec 2018 – May 2019 · 5 mos

· 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.

Installation & Configuration of SQL ServerMaintaining serversMonitoring Backup & Recovery strategyTroubleshooting transaction logsHigh AvailabilityMonitoring SQL Server alerts+3