Experience

Uber Technologies, llc

• United States
• Design Services
• 1 - 100 Employee

• SQL Database Administrator

  • Mar 2018 - Present

  ● Upgrading SQL server 2017 to SQL Server 2019 and 2022. ● Experience in implementing windows cluster across multiple availability zones and Implemented SQL Server 2019 Always On availability group in AWS. ● Experience in setting up database transactional replication for reporting servers, Using Backup and restore methods. ● Experts in Database refresh from prod to lower environment as per the business requirements. Automated quarterly/monthly database refresh. ● Managed and Involved in SQL performance Tuning, identifying locking and Third-party tools to enhance and boost performance of SQL Dbs. ● Managed SQL server Logins, Database users & roles and involved in Daily User Maintenance. ● Created Database Maintenance jobs to perform full & transaction log Backups and scheduled them with the SQL Server agent job scheduler. ● Monitor database growth activities & Troubleshoot Transaction Log Issue. ● Created and configured mirroring for Disaster Recovery. ● Providing weekly status information on all projects to Project Manager. ● Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements. ● Designed and developed ETL process using SSIS to load data from various sources like MS Access and SQL Server 2017, Oracle database. ● Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS) ● Experience in migrating SQL Server 2017 and 2019 to SQL Server 2022 with AlwaysOn Availability ● Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases ● Worked on BCP for data uploading module and created SSIS packages for data transfer & transform across locations and multiple data sources as per requirement. ● Created new tables, stored procedures and triggers using T-SQL. ● Refactored and Fine-tuned the queries and Stored procedures in T-SQL. ● Installed and configured MS SQL Servers in Virtual Environments using VMWARE. Show less



Merck

• Kenilworth, New Jersey, United States

• Sql Server Database Administrator

  • Jul 2014 - Nov 2018

  ● Installed and Configured various editions and versions of SQL Server in standalone, and clustered nodes. ● Installed, and Configured SQL Server Fail-Over Cluster for SQL Server 2008, 2008 R2 & 2012. ● Applied service packs, hotfixes and cumulative updates. ● Upgraded SQL Server 2012 R2 Database into SQL Server 2014 and 2017. ● Created and maintained logins, Users, Roles and managed security of the database. ● Implemented Disaster recovery plan by performing routine backups and restore ● Taking Full, Differential and Transactional log backups and setting automated jobs. ● Migrated data using Import/Export, bulk, backup-restore, DTS, SSIS, Detach/Attach ● Performed data Extracting, Transforming and Loading (ETL) from different data sources. ● Rebuilding /reorganize indexes to reduce fragmentation and enhance SQL server performance ● Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, Notifications and configured database Mail. ● Hands on experience monitoring and performance tuning using Tuning Advisor, SQL server Profiler, Activity monitor, Windows performance monitor, DBCC, DMVs, Stored procedures ● Working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications. ● Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, Failover Clustering and Always On availability group. ● Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports ● Worked in a team with integrated Developers, CAB (Change Approval Board) and Disaster Recovery Planning team. ● Experience in contacting Microsoft and other vendors for product and technical support. ● Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet the deadline before SLA is due. ● Experience in Agile projects with a solid foundation in Software Development Lifecycle (SDLC). Show less