Home

Ajay Garre - Sr. SQL DBA

[email protected]

Location: Troutville, Virginia, USA

Relocation:

Visa:

Ajay Lead. MS SQL SERVER DBA Professional Summary: Database Administrator with 17+ years of experience providing day-to-day operational and administrative support for Microsoft SQL Server environments (2016 2022). Strong background in database monitoring, backup and recovery, performance tuning, incident resolution, and documentation. Experienced in supporting SSRS and SSIS, assisting with migrations and upgrades, and working within established SOPs and escalation procedures in 24x7 production environments. Experience in MS SQL Server 2000/2005/2008/2012/2014/2016/2017/2019/2022 Installation, Configuration, Managing, Monitoring and Troubleshooting. Experience on SQL Server 2005/2008/2012/2014/2016/2017/2019/2022 tools like SQL Server Management Studio (SSMS), SQL Server Profiler, SQL Server Agent, Execution Plan, Performance monitor, DBCC commands and troubleshooting and SQL Server Surface Area Configuration, Database Engine Tuning Advisor. Designed and implemented end-to-end ETL solutions on GCP using tools like Dataflow, Apache Beam, and Cloud Composer, facilitating seamless data movement across diverse sources and destinations Expertise in data migration from MS SQL Server 2014 to 2017/19, 2008 to 2012/14, 2005 to 2008 including Replication in Standalone & Clustered environments. Managed RDBMS service from AWS that s compatible with MySQL and PostgreSQL. Managed day-to-day User activities like creating logins, database users, roles, assigning proper permissions, manually running the jobs etc. as per business requirements. Extensive experience in providing High Availability using Failover Clustering, Database Mirroring and Log Shipping capabilities of MS SQL Server to provide robust database solutions. Experience supporting SQLite, Oracle, and PostgreSQL database platforms Comprehensive, enterprise-grade RDBMS known for its scalability and advanced features. Intensive experience in monitoring/tuning SQL Server and Database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor. Experience in Upgrading, applying Service Packs and Migrating SQL Server 2005 databases to SQL Server 2008 and SQL server 2008 to SQL server 2014/17/19/22. Proficient with database backup and recovery procedures, using tools Tivoli Data Protection (TDP), Snap Manager and Snap Protect. Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional. Involved in design and development of DTS and SSIS packages to load and process the data from Oracle, Excel, Access and flat file feeds to SQL Server and vice versa. Experience with Reporting Services (SSRS) and Analysis Services (SSAS). Experience in installing, Configuring and maintaining SQL Server Active/Active & Active/Passive Clusters. Automating the Database Maintenance tasks by creating Jobs and Alerts using the Database Mail and SQL Server Agent. Knowledge in Third party tools like SCOM, Quest Foglight, Quest Spotlight, Quest Performance Analyzer. Experience in working with 24/7 production Environment with thorough understanding of Standard Operation Procedures (SOP) and Service Level Agreements (SLA). Self-motivated, creative team player with effective communication and analytical skills. Technical Skills: Operating Systems: Windows 2019/16/12/08 R2, Windows NT/95/98 Databases: MS SQL Server 2022/19/17/16/14/12/08/05/2000, MS Access, Azure Database Tools: Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Database Tuning Advisor, Business Intelligence Studio, DTS, SSIS, Export & Import Languages: T-SQL, SQL, HTML, XML Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook Professional Experience: Altria, Richmond, VA May 11 Till Date Senior MS SQL Server DBA (Operational Support) Altria Client Services is the parent company of Philip Morris USA, John Middleton, Inc.., and other. SalesEdge is the multimillion application of Altria Client Services for PMUSA Client. Responsibilities: Involved in the installation, configuration & maintenance of SQL Server 5-node & 4-node Active Clusters. Advanced open-source RDBMS known for its robustness and support for advanced data types. SQL Server 2012/14/16/17/19/22 installation & configuration on Windows 2008/12/16/19. Migrated databases from SQL 2005/08 R2 to SQL 2012/14/16/17/19/22. Responsible for creating & maintaining users, indexes, roles, credentials, linked server connections, sql agent jobs and proxy accounts. Experienced in managing Alerts, Operators and Jobs using SQL Server Agent and Tidal Enterprise Scheduler (TES) Implemented robust data security measures within GCP environments, ensuring compliance with industry standards and regulations, including the establishment of access controls and encryption protocols. Responsible for databases' backup & restore using Tivoli Data Protection (TDP), SnapManager & SnapProtect. Monitored database performance, capacity, and availability using SQL Profiler, PerfMon, Foglight, and SCOM to proactively identify issues. Performed capacity planning and space forecasting for multi-terabyte databases. Created and maintained operational documentation, SOPs, and support runbooks. Participated in knowledge transfer sessions and mentored team members during operational transitions. Experience in performing administrative tasks & troubleshooting disk space, performance, availability issues using Powershell. Followed established standard operating procedures (SOPs), change management processes, and escalation paths while supporting production environments. Implemented and Maintained Clustering, Log Shipping, Replication and Always On. Monitoring SQL server performance using monitoring tools like SCOM, Quest Foglight, Quest Performance Analyzer & SQL Profiler. Developed pipelines using the AWS Glue and Cloud Dataflow on GCP Migrated databases from On-prem SQL servers to SQL Azure VM/MI. Experience in configuring Azure VMs as per Client requirement and standards. Primarily responsible for the business-critical Sales databases (10+ TB). Responsible for creation of maintenance plans for Data integrity, index maintenance, update stats, on-demand backups. Monitor SQL Server/database status including CPU utilization, memory, space, blocking and dead-lock issues. Gathering data requirements and designing, fine-tuning of databases as per Client requirement. Implemented database security including authentication, authorization, role-based access control, and auditing. Supported SQL Server instances hosted on virtualized environments (VMware/Hyper-V) Worked with the audit team to setup/monitor SQL Audit for critical PROD databases. Provide database assistance and problem support to application developers, business analysts and business users. Provided 24x7 support to business-critical Sales Servers/databases. Upgraded SQL with latest service packs and security fix for both Clustered and Standalone servers. Actively participated in DR testing. Environment: MS SQL 2008 R2/2012/2014/2016/17/19/22, T-SQL, SSIS, Windows Server 2008R2/12/16, Foglight, SCOM, SnapProtect, Maximo, ServiceNow, SolarWinds. Union Public Pacific Rail Sept 10 Apr 11 Omaha, NE Sr SQL Server DBA Union Pacific Railroad is an operating subsidiary of Union Pacific Corporation. It is the largest railroad in North America, operating in western two-thirds of the United States. Union Pacific Railroad is using Ultra Low Sulfur diesel with the oxicat resulted in reduced particulate emissions by approximately 50 percent, unburned hydrocarbons by 38 percent and carbon monoxide by 82 percent, which was supported by United States Environmental Protection Agency. Responsibilities: Installed SQL Server 2005/2008 on Development, Test & Stage Boxes. Migrated databases from SQL Server 2000/2005 onto SQL server 2008. Involved in creating Logins, Tables, Views, Functions, Clustered & Non-Clustered Indexes and Stored Procedures. Estimation and Monitoring space requirements for databases and log files. Implemented Database Mirroring between Primary Server and a Standby Server. Used SQL Server Profiles to monitor and trace the slow running queries and optimize query execution with the use of Index Tuning Wizard and Rebuild Indexes if necessary. Backups, Job maintenance, tuning and performance issues, troubleshooting, security issues, service pack patches and other security patches installation. Configured and maintained Transactional and Snapshot replication. Created documentation to install SQL Server, apply service pack, hot fix and clustering installation. Migrated SQL Reporting Services from SQL 2005 to SQL 2008. Worked on rendering issues occurred post-migration. Migrated SQL Analysis Services from SQL 2005 to SQL 2008. Validated the Cubes data using MDX Queries. Involved in analyzing and designing Disaster Recovery/ Replication Strategies with business managers to meet the business requirements. Involved in allowing developers to access the SSRS using Team Foundation Server. Created custom reports using SSRS and Team Foundation Server. Responsible for SQL Server configuration, tuning and provided 24x7 dedicated support to all production, development and clustered servers. Working with developers to promote product releases from development to Test to Production environment. Environment: MS SQL 2005/2008/2008 R2, SSIS, SSRS, SSAS, Windows Server 2003/2008, T-SQL, MS Visual Studio, Team Foundation Server. FedEx, Harrison, AR Sept 09 Aug 10 Sr SQL Server DBA FedEx is the world s largest express transportation company providing fast and reliable delivery to 215 countries, including every address in the United States. FedEx uses business intelligence solutions to make the data in its information systems available for timely and accurate analysis. This project is intended to develop and deploy an intranet-based reporting application used by buyers, customers and marketing departments to generate backorder reports, service net reports, customer reports, freight bills, delivery receipts, call center reporting, etc. Responsibilities: SQL Server 2008/05 installation & configuration on windows 2003 system. Upgrading of SQL database from SQL Server 2005 to SQL Server 2008. Installed, Configured and maintained SQL Server Active/Active & Active/Passive Clusters. Integrated with development team and assisted them in optimizing SQL Queries and Stored Procedures. Tuned database by creating proper Indexes on different tables that improve the performance of T-SQL queries on the database. Created & maintained databases, table spaces, users, tables, indexes, stored procedures, roles, profiles and other schema objects. Implemented Database Mirroring between Primary Server and a Standby Server. Writing SSIS packages for daily sales and delivery reports as well as adhoc data transforms and data extraction for the Data Migration team and upgraded some DTS packages to SSIS packages. Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts. Involved in allowing developers to access the SSRS using Team Foundation Server. Created custom reports using SSRS and Team Foundation Server. Created Transactional Replication, Pull Subscription and defined editions to transfer data from branch to head office and vice versa. Involved in Creation of Dimensions using STAR Schema Involved in creation of stored Procedures, Functions and SSIS Packages, enforced database triggers for auditing. Performed backups, DBCC utilities, updated index statistics, monitored database and disk space and scheduled the backups for Databases and Transaction logs. Designed and documented a Disaster Recovery Plan for the databases and modified scripts for all jobs including Backup restore. Implemented Log Shipping as a part of disaster recovery. Used SQL Server Profiles to monitor and trace the slow running queries and optimize query execution with the use of Index Tuning Wizard and Rebuild Indexes if necessary. Responsible for SQL Server configuration, tuning and provided 24x7 dedicated support to all production, development and clustered servers. Worked on performance issues of Transactional Replication. Environment: MS SQL Server 2008, SSIS, SSRS, T-SQL, Replication, MS Visual Studio .Net, C#, VB, Visio, Windows 2003/2008 Intel Corporation, Chandler, AZ Dec 08 Aug 09 Sr SQL Server DBA Capacity Operational Data System (CODA) is a part of Intel Corporation s Data Warehouse system for analyzing various processes involved in chip components manufacturing and also estimating commercial and industrial prospects. This system is designed to use for decision makers. Responsibilities: Responsible for SQL development and Database Administration for SQL Server/ Analysis servers in development, testing and production environments. Administration of clustered SQL Servers in 24x7 environment. Installed, configured and maintained SQL Server Failover Clustering. Backups, Job maintenance, tuning and performance issues, troubleshooting, security issues, service pack patches and other security patches installation. Installation and configuration of SQL Server 2005 and SQL Client. Configured and maintained Database Mirroring for high availability. Estimation and Monitoring space requirements for databases and log files. Creating, copying, moving and managing databases across the servers based on project requirements. Implemented Database Mirroring between Primary Server and a Standby Server. Responsible for maintaining 2-node Clusters in SQL Server. Implementing different backup schemes such as Full, Differential and log. Designing and testing various disaster recovery mechanisms to ensure 100% data recovery in the event of failures. Involved in setting up database mirroring on SQL server 2005 (Manual / Automatic failover) Configured and maintained Transactional and Snapshot replication Initiated, managed and coordinated database change control items to predictably modify the database environments Designed and developed security strategies for interfacing databases with application software Performed data backup, recovery and transfer operations and worked on developing disaster recovery strategies Managed devices and databases, administered security, scheduled tasks, monitored server and database performance Involved in designing the logical and physical architecture for database. Data migration (import & export BCP) from Text to SQL Server. Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard. Performed development support, document reviews, test plan, integration of the system. Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server Fine tuning and optimization of SQL queries and stored procedures using SQL Profiler, Trace and Performance monitor and ensuring indexes are using updates statistics. Troubleshooting on network issues with TCP/IP and Protocols and also responsible for client configurations. Source data analysis, Source & Target mappings design and development. Scheduling batches and sessions, performance issues and troubleshooting. Load estimations and recovery management of failed sessions. Created documentation to install SQL Server, apply service pack, hot fix and clustering installation. Designing, implementing and monitoring various nightly loaders which trigger DTS packages and stored procedures and ensure that server resources such as memory, CPU and disk I/O are properly balanced. Working with developers to promote product releases from development to Test to Production environment. Environment: SQL Server 2000/05, 1+0 Configuration with clustered pairs, MS SQL Server DTS, Stored Procedures. Wells Fargo, San Francisco, CA Aug 07 Nov 08 SQL Server DBA Wells Fargo & Co. is a diversified financial services company with operations around the world, which is the fourth largest bank in United States by assets and the third largest by market cap. This project is intended to upgrade the company s SQL servers from SQL Server 2000 to SQL Server 2005. Responsibilities: Installed SQL Server 2005 on the servers according to the requirements. Applied Wells Fargo approved service packs and hot fixes. Configured SQL Server 2005 according to the requirement. Performed the hardening on the SQL Server 2005. Changed SQL directories owner to Administrator account. Implemented audit policy in the system registry for SQL Server 2005. Performed Full backup and restore on the SQL Server. Transferred the logins, jobs, linked servers. Responsible for maintaining 2-node Clusters in SQL Server. Successfully Migrated SQL 2000 DTS packages to SSIS packages using DTS Xchange tool. Created SQL admin accounts and dropped the Built-in-Admin. Changed all jobs owner from sa account to administrator account. Disabled SA account. Successfully Configured Snapshot, Transactional and Transactional with updatable subscription in Replication. Created Maintenance Plans for production servers (Full, Differential and Transactional Backups) using Litespeed. Created documentation to install SQL Server, apply service pack, hot fix and clustering installation. Created maintenance plan for user databases and system databases. Implemented database mail. Created operator and assigned the operator for jobs. Created various reports using SSRS and scheduled them as daily & Monthly. Delivered the final SSRS Report using the Request Handler. Implemented database mirroring. Supported on call on rotational basis and supported the databases 24x7 Configured the AWE. Created the script to find all SQL Server version, license type, service pack. Created the script to monitor the all server s logical disk free spaces. Removed quest users from databases. Revoked the privileges to Non-Sys Admins to execute stored procedures. Revoked the public role object level permissions. Transferred the database objects from development to QA to production. Environment: SQL Server 2000/2005, Windows Server 2003, SQL Light Speed. Liberty Mutual, Boston, MA Dec 06 July 07 SQL Server Developer Human Resource Management System (HRMS) is designed to handle the Human resource activities for the organization Liberty Mutual. HRMS is a web based three-tier architecture system that provides information about employee data, new hire, applicants, promotion, demotion, leave or absence, payroll data, and change of certain business roles required development of new modules to the system. This project was to build an effective and efficient database for HRMS system using SQL Server 2000 and its tools like DTS which provides good details of all Human Resource Activities of whole company. Responsibilities: Participated in gathering user requirements and online system specification. Coordinated with front end developer to put business roles. Involved in creating ER diagrams and mapping data into database objects. Installed and configured SQL Server 2000. Designed Databases, Tables and developed SQL scripts to insert, update and delete data in database tables. Designed physical development databases on SQL 2000 RDBMS using different Data Definition and Manipulation Languages (DDL/DML). Modified and redesigned existing database by adding tables and relationships to support online system in the development database. Defined Check Constraints, Business rules, indexes and views. Wrote User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible. Performed testing on Stored procedures, Indexes and Triggers. Extensively worked on gathering data from different databases and applications using DTS. Deployed different types of packages using DTS and transferred them into different formats like MS Excel, TTF file, MS Access. Optimized the performance of queries by modifying the existing index system and rebuilding indexes again with respect to I/O and also using Performance Tuning. Transferred data from various data sources using OLE DB connection by creating various DTS packages. Environment: SQL Server 2000, Query Analyzer, Enterprise Manager, VB Script. Keywords: csharp quality analyst database information technology microsoft mississippi bay area Arizona Arkansas California Colorado Massachusetts Michigan Nebraska Virginia