Home

NAGENDRA - SQL DBA - 13+ Profile

[email protected]

Location: Frisco, Texas, USA

Relocation: YES

Visa: H1B

Professional Summary Microsoft certified MSSQL & Azure Administration with over 13+ years of experience in Azure & MSSQL Database Administration in extensive expertise in the Finance, Healthcare and multiple domains. Proven track record of architecting and managing mission-critical database environments, ensuring compliance with industry-specific regulatory requirements. Seeking a senior leadership role to leverage my in-depth domain knowledge & technical proficiency in SQL, MongoDB, PostgreSQL, Azure (IAAS & PAAS), AWS & Google cloud to drive operational excellence in database management Lead SQL Server Administration and Azure with 24X7 Production Support of SQL Server also specializes in MS SQL Server in Production, Test and Development Environments in finance, Healthcare and different domains. Experience in design/Automation of Backup, Restore and Recovery Plans for all prod databases. Extensive experience in Database migrations, upgrade SQL Versions from On-prem to Azure IAAS and PAAS (Azure SQL and Managed instance) with different tools and techniques. Expertise in configuration & troubleshooting in Log Shipping, Mirroring, Replication, AlwaysOn & Clusters. Proficient in SQL Server development, writing complex queries, stored procedures, Joins, functions, & triggers. Developed and optimized stored procedures and functions for efficient data processing. Corporate trained and Hands - on experience in Azure Cloud Services (PaaS & IaaS/Managed instance). Implemented & managed Azure Elastic Pools to optimize resource utilization & cost-effectiveness. Experienced in configuring Virtual machines, Load balancer Geo-Replication, Availability Group & Data Sync. Build servers in Google cloud and migrate the databases/servers from on-premises to Google cloud. Spin up the servers in Google Cloud by using JSON code through Jenkins CI/CD pipeline. Worked and supported big databases over 32 TB in Production, Testing and Development Implemented and managed Multi-Subnet Cluster Always-ON (AAG) & Distributed availability solutions (DAG). Experience with Third part backup tools like Net Backup, TSM, Data Domain, Networker. Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities, Capacity Planning. Experience in Query tunning and suggesting the index creation, index removal, index modification, file group modifications, and rebuild index, data archival, Table partitioning, and purging strategies, update statistics and Cardinality Estimation (CE) with detailed understanding the execution plans. Implementing on best security plans, application interface and user management, Creating Roles, managing user Permissions, resolving deadlocks and ensure that they also adhere to SOX compliance standard. Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Oracle to MS SQL Server by using DTS Import/Export utility, and SSIS package. Configuring encryption on database/server with Gemalto SafeNet and Transparent data encryption (TDE). Experience in preparing Stored procedures, views, and Tables. T-SQL DDL/DML/DCL. Good working knowledge of Active Directory, Kerberos authentication and fixing the SPN issues. Install and configure Scale-out deployment in SQL Server Reporting Services (SSRS) on multiple servers. Hands experience multi cloud technology AWS and Google cloud of administration and migration. Configuring Linked servers SQL to SQL & Oracle and Installing Oracle client s software. Environment and Database activities at the server level to maintain SSRS environment up and running. Good knowledge on different database like Sybase, Oracle, PostgreSQL, MongoDB and MySQL Implemented HA for SSIS packages, configured Always On Availability Groups, uninterrupted ETL processes. Monitor and address performance bottlenecks in both databases and ETL processes, involves managing databases while ensuring smooth and efficient movement of data through ETL processes ITIL framework processes such as Incident, Change, Problem, Service Request Management. Automating SQL Server tasks with PowerShell can greatly enhance efficiency. Automate PowerShell scripts to collect and analyze performance metrics, including CPU usage, memory utilization, disk I/O, and query performance. Technical Skills Database Technologies: SQL Server 2005 to 2019, sMongoDB 4.0,4.2,4.4 Cloud Technologies: Azure (IAAS, PAAS/Managed Instance), Google Cloud, AWS Backup Third party tools NetBackup, TSM, Data Domain Boost, Networker Scripting T-SQL, PowerShell, Shell scripting Business Intelligence Tools: SSRS, SSIS, SSAS Operating System: Windows Server, Linux DevOps Tools: Jenkins, GitHub, Terraform, Ansible. Ticketing Tools: JIRA, ServiceNow, BMC Remedy Third party Tools: Redgate, SolarWinds, SQL Profiler, DB Tuning Advisor, Confluence, DPA Achievements Client appreciation for implementing resource optimization strategies, leading to save 41K Hard dollar savings reduction in hardware and infrastructure costs in Azure virtual machines. positive client feedback for developing and implementing automation scripts for routine database maintenance tasks Awarded the Star Performer of the Year for outstanding achievements. Certifications Certified Microsoft Azure Administrator Associate (AZ-104). Certified Microsoft SQL Server 2008 (70-434). Professional Experience SanMar, Frisco, TX May 2023 Till date Lead SQL DBA SanMar, we do more than make and sell t-shirts. We build meaningful connections that elevate lives. As the largest supplier of wholesale imprint able clothing and accessories in the United States, our products and the connections they create impact organizations, individuals, and the world we live in. It all started more than 50 years ago with a business philosophy that has held true since day one: Be Nice and Tell the Truth. Family owned and operated, SanMar is based in Issaquah, Washington, with eight distribution centers nationwide and apparel from more than 30 celebrated brands. Implement, configure, and maintain performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of Applications. Expertise on Azure Experience IAAS, PAAS and Managed instance and Migrations On-prem to IAAS and PAAS. Configure the high availability features depends on requirement high availability solutions such as Always ON, Replication, Failover clustering, ensuring data redundancy and minimizing downtime. Proficient in writing and optimizing T-SQL queries for data retrieval, modification, and reporting. Implemented error handling and transaction management within procedures and functions. Good understanding on Database security, application interface and user management. Experience in debugging and tracing SQL performance issues using SolarWinds tool. Experience in SQL replication, log shipping, mirroring, and AG groups. Working in Azure storage, Azure SQL Database, Azure Virtual Machines, DMS, Azure Data studio, Azure AD, Azure Vault, Azure DNS and Azure VPN Gateway. Hands on Microsoft SQL Server Always on along with TDE configuration for High critical financial data Proficient in deploying, configuring, and managing Azure SQL Databases across various service tiers and performance levels. Skilled in optimizing database performance through query tuning, indexing, and resource utilization. Experience with Microsoft Azure resource groups, networking, Active Directory and storage accounts. Experience on Installation and configuration of SQL failover cluster and Always ON availability groups. Automated PowerShell scripts configured for CPU, Disk space, Backup and Memory issues. Experienced for management roles, network and data masking policies, global user(service) & role privileges management. Automation PowerShell scripts to configure the Always ON HADR setup and sync issues. Provide guidance and support to Application Developers. Install, deploy and manage MongoDB on physical and virtual machines Create, configure and monitor large-scale, secure, MongoDB sharded clusters Support MongoDB in a high availability, multi-data center environment Experience in design and developing Application leveraging MongoDB Administering SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges at user/Database Level. Creating custom stored procedures to update statistics and reduce index fragmentation on daily or weekly basis depending on database load. Refreshing QA, Dev environments from production databases Breaking and re-enabling mirroring on the event of Maintenance Activities and involved migrating logins and jobs. Expertise in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities and Dynamic Management Views DMV's. Worked on Backup Tools DDBoost, Networker and Monitoring tools Redgate, SolarWinds. Hands-on experience in using GitHub to retrieve Json files, used Jenkins for pipeline modifications to the servers on GCP. CoreLogic Irving, TX Oct-2019 to May-2023 Lead SQL Database Administrator- Manager CoreLogic, Inc. is an Irvine, CA-based corporation providing financial, property, & consumer information, analytics, and business intelligence. The company analyzes information assets and data to provide clients with analytics and customized data services. The company also develops proprietary research and tracks current and historical trends in several categories, including consumer credit, capital markets, real estate, fraud, regulatory compliance, natural hazards, & disaster projection. The company reported 2018 revenue of $1.79 billion. Handling Team and Installations and configuration SQL Server 2017 and SQL Version 2019. Deployment, maintenance, upgrade & support of cloud platforms Azure/Google cloud in IAAS, PAAS models. Excellent knowledge & hands on experience in Migrations from on-premises to Azure IAAS & PAAS servers. Installation and configuration of SQL Server 2012/2014/2016 Windows Failover Cluster. Migrate SQL server database from on premise to Azure IAAS Migration using Azure Site Recovery, setting up and testing HA & DR. Designed and developed databases for various applications, ensuring efficient data storage and retrieval. Proficient in writing and optimizing T-SQL queries for data retrieval, modification, and reporting. Experience with managing and optimizing costs on an ongoing basis through rightsizing, instance planning, and automation based on usage patterns Azure cloud. Implemented distributed availability solutions, including database mirroring, log shipping, and Always On Availability Groups, Distributed availability (DAD), to ensure continuous data access and minimize downtime. Implement, configure, and maintain performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of Applications. Led migration efforts from on-premises SQL Server to Azure Cloud, utilizing Azure Data Lake for data storage and analytics Implemented high availability solutions for databases on Terraform-provisioned VMs availability groups. Designed and implemented infrastructure using Terraform to automate the creation of virtual machines for database deployments. Implement data transformations using ADF's data flow functionality, including data cleansing, enrichment, aggregation, and conditional logic. Configure and monitor numerous MongoDB instances and replica sets Create users and provide appropriate permissions based on the requests Enabled security on mongo instances authorization on all production server to keep the data safe. Develop and schedule Apache Spark jobs, notebooks, and workflows on Databricks, orchestrating data transformations and analytics Develop data solutions that utilize cloud-based technologies and platforms (PaaS etc.) Assist with schema design, code review, SQL query tuning. Provide guidance and support to Application Developers. Administering SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges at user/Database Level. Extensive use of SQL Server DMV's for resolving performance issues. Configured SQL jobs using PowerShell scripts to setup the sync objects and logins in regular process. Creating custom stored procedures to update statistics and reduce index fragmentation on daily or weekly basis depending on database load. Refreshing QA, Dev environments from production databases Breaking and re-enabling mirroring on the event of Maintenance Activities and involved migrating logins and jobs. Setting up Log Shipping, Replication for SQL Server production boxes. Raising Cases with Microsoft in case of a Critical/Recurring Production Issues and working with them for resolving the same by implementing the suggestion. Novartis Health care, East Hanover, NJ Aug-2015 to Oct 2019 Sr. SQL Server DBA Novartis International AG is a Swiss multinational pharmaceutical company based in Basel, Switzerland, ranking number two in sales (46.806 billion US$) among the world-wide industry in 2010. Novartis employs nearly 115 000 people in over 140 countries. Novartis is the only company with leading positions in each of these key areas like Pharmaceuticals, Alcon, Sandoz, Consumer Health, Vaccines and Diagnostics. Novartis Strategy to provide healthcare solutions that addresses the evolving needs of patients and societies worldwide Installation, Upgradation, Maintenance & Troubleshooting of the SQL Server 2005/2008/2008R2/2012/2016 Database on standalone & clusters. Managed 2500+ SQL Server instances on multiple environments in Production, Testing and Development. Experience in Azure environments. Create, maintain, and execute SQL Server jobs, SQL Server Scripting, Indexes, Views, Stored Procedures. Migrate SQL server database from on premise to Azure IAAS/PAAS Migration using Azure Experience with cloud database backup and transaction recovery techniques. Installation of SQL Server 2012/2014/2016 with automated process of PowerShell tools. Implement, configure, and maintain performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of Applications. Experience in creating automated backups, restoration DB s, indexing & update starts through SQL Agent Jobs & Maintenance plans. Engage in regular internal and external audits to ensure ongoing compliance with SOX requirements Monitoring the SQL Server health check and fixing the issues of Blocking, Deadlocks. Implemented and maintained robust access controls and authentication mechanisms within SQL Server databases to ensure compliance with Sarbanes-Oxley (SOX) regulations. Implemented Log Shipping and Database Mirroring. Monitoring with SQL Profiler to capture and save data about the event to a file or table to analyze later. Migrate SSIS and SSRS from One server to other servers and troubleshoot the issues. Develop data solutions that utilize cloud-based technologies and platforms (PaaS etc.) Extensive use of SQL Server DMV's for resolving performance issues. Responsible for administration which involves Installation of Multi/Single nodes, upgrading to latest versions, migrating/creating Tenants, Troubleshooting Load issues, Data Sources Creation and User Administration. Expert in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities and Dynamic Management Views DMV's. Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Experience on SQL Server clustering and Keen interested to work on clustering. Involved in AlwaysOn for High Availability and reporting purpose and created the documentation. Installation of SQL Server /service packs on Client systems, Failover Cluster Installations and Configuration of Windows Cluster Resources. Experience in configuring the failover cluster and co-ordinate with OS team during the OS maintenance tasks. Experience in preparing the Standard Procedure (SOP) documents for Disaster recovery plans and implemented without any issues. PepsiCo, Harrison, NY Nov-2010 to Aug-2015 SQL DBA PepsiCo is a global food and beverage leader with 22 brands that generate more than $1 billion each in annual retail sales. PepsiCo's products are sold in more than 200 countries and territories around the world. The database administrators are responsible for monitoring the systems and environments of both the centralized and distributed Application. The purpose of this is to verify systems and all their related databases, networks, and applications are 100% operational. Any anomalies should be identified and documented. The anomalies should either be corrected, if part of the database administrator s responsibility Installation and configuration of SQL server 2005/2008 in development, production, testing, environments. Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups both at database and server level. Applying Builds on Prod and Dev Environments, Monitoring Scheduled tasks on client systems. Updating Clients on daily/monthly/weekly status of the servers through meetings and reports, Suggestions if any Installation of SQL Server /service packs on Client systems, Failover Cluster Installations and Configuration of Windows Cluster Resources. Configuring linked servers and administering them, Responsible for deployment of all objects in Production environment. Configuring the regular backups in SQL server and monitoring the backup failures. Monitoring the SQL Server health checks and fixing the issues of Blocking, Deadlocks, TempDB contention issues and connection failures of end users/application teams. Co-ordinating with application and Developing team and deploy the latest production on weekly basis. Addressing and resolving ad-hoc requests from the clients. Monitoring disk space alerts and shrinking log, data files to groom the disk space. Adding users in the Database and granting permissions and Scheduling jobs in SQL Server. Attending change deployment Bridge calls and ensure to complete the change requests successfully Experience configuring the Log shipping and Mirroring concepts and troubleshooting. Involved in Addressing Performance Tuning of DBs/Instances Depending upon the Configuration and their Performance, fine tuning of Queries to help execute them in less time. Good experience on patches and security updated on different SQL versions. Involving the Migration plans & implementing the migrations of SQL server lower versions to higher versions. Documenting of Standardized Procedures, troubleshooting issues to ease quick resolution if the issue reoccurs. Keywords: continuous integration continuous deployment quality analyst database active directory information technology container edition microsoft Arizona California Colorado New Jersey New York Texas