Sql Server Production Support
Resume:
nAGarjuna
Nagarjuna
*********@*****.***
Summary
13+ years of IT experience as Production Support Database Administrator of Microsoft SQL Server in Insurance, Human Resources, Financial, Publishing, Health Care & Tele Communication Sectors
Experience
COSTAR Group, Washington D.C
April 2024 – Present
Senior MS SQL Server DB Administrator – Production Support
GEICO, Chevy Chase, MD
May 2023 – April 2024
Senior MS SQL Server DB Administrator – Production Support
TEOCO Corporation, Fairfax, VA
July 2018 – May 2023
MS SQL Server DB Administrator – Production Support
ProMatrix Corp : Ceridian HCM, Inc., Alpharetta, GA
Sept 2015 – Jun 2018
MS SQL Server DB Administrator – Production Support
ProMatrix Corp: American Red Cross, Ashburn, VA
May 2012 – Aug 2015
MS SQL Server DB Administrator – Production Support
Promatrix Corp: MacMillan Publishers, New York City, NY
Oct 2010 – April 2012
MS SQL Server DB Administrator
Education
Masters in business administration (MBA – IS)
Major: Information Systems - Sorrell College of Business
Troy University, Troy, Alabama, USA
2008-2010
Bachelors in computer science and engineering (btech – cse)
Major: Computer Science and Engineering
Jawaharlal Nehru Technological University
Hyderabad, Telangana, India,
2003-2007
Technical Skills
Operating Systems:
Windows Server, Linux Red Hat, Unix, Mac.
Database:
MS SQL Server 2000, 2005, 2008 R2, 2012, 2014, 2016, 2017, 2019, 2022 Azure SQL, Oracle, PostgreSQL, My SQL, Mongo DB
Databricks, Snowflake, Mongodb.
Database Tools:
SQL Server Management Studio, SSIS, SSAS, SSRS, SQL profiler, Perfmon, Sentry One, Power shell, DTA, Commvault, Evault, Idera, Redgate, SolarWinds, EDB Enterprise Tools, Tableau, Power BI
System/Network monitoring:
PRTG Monitor, Fog-light, MS Dynamics, BMC True sight, Nagios, Zero VM-Replication.
Software & Application Tools:
Python, Java, C, C++, C#, BMC Remedy, Service Now, Atlassian Products (JIRA, Confluence), Documentum, Visual Studio, GITHUB, CDC Pipelines,
Other Skills:
Automation, IIS, SSL certificates, Encryption, System Analysis & Engineering, Database Design, Data Analysis, Technical Writing and Documentation.
Detailed Summary
• Over 14 years of IT experience in Database Administration, Design, Development, Installing and Support of VLDB’s over 40 TB in MS SQL Server 2000-2022 in Azure/AWS, Production, Testing and Development Environments.
• Heavy Experience in Database Migration from MS SQL server 2000-2012 to 2014-2022 as well as Azure SQL.
• Heavy experience in developing the variety of proof of concepts for SQL Server features testing and future implementations specific to the existing environments and limitations.
• Expertise in Establishing and promoting SQL best practices guidelines & coding standards for Application teams.
• Participate in design and architecture review of application design, providing optimal design recommendations for application-to-database interaction.
• Experience on DBA activities like Migrations, Maintenance, and Performance Tuning on SQL and NoSQL.
• Expert in managing SQL Server in Physical and Azure Cloud PaaS, IaaS, Virtual Environments like VMWare.
• Expertise in planning and implementing DB Security and Permissions in Multi-Tenant Environments.
• Expertise in providing Solid Technical recommendations to improve Performance as wells as Costs.
• Has Solid knowledge in implementing HA DR solutions like Always ON, Replications, Log Shipping, Database Mirroring Techniques, VM Level Replications (Zerto).
• Experience in Software Development Life Cycle (SDLC), agile methodology including lean best practices.
• Expert in monitoring SQL Server with Diagnostic Manager, Native, Third-Party Tools and configuring Alerts using SQL Mail and PowerShell.
• Experience in Installing and configuring SQL Server Cluster in Active/Passive and Active/Active environments.
• Implemented Custom Backup and Restore Strategies in SQL Server using Native SQL Backups and also using Third party tools.
• Experience in supporting Enterprise Postgres 12-16 Migrations and Administration using EDB tools.
• Expert in using Ticketing and Change Management software.
• Expert in Using SQL Server DMV's for Performance Tuning, Wait Stats and Monitoring.
• Experience in Tuning, Query Optimization, DB Consistency Checks using DBCC Utilities, and Power Shell.
• Experienced in Configuring Azure Backups, Subscriptions, Firewall Settings, Azure SQL Query Tuning, Azure Data Import and Exports, Working on Memory, Temporal Tables.
• Experienced in Azure SQL DB Security, Dynamic Data Masking, Transparent data encryption.
• Experienced in providing and configuring Azure SQL High Availability Solutions like Geo Replication, Server Failover groups and SQL DB Synchronization.
• Experience in providing trend analysis, Proactive monitoring, Cost Estimates for Azure Resources and Storage.
• Experience with Azure apps technologies such as Azure SQL, AZ Copy, SQL Server DW, Azure AD, etc.
• Experience in creating dash boards and monitoring production environment using Azure Stream Analytics.
• Experience in using different Transformation tools like DTS, SSIS Packages and BULK INSERT.
• Experience in design, troubleshoot and optimize reports in SSRS to meet business requirements.
• Expert in T-SQL writing and developing Database Objects, Triggers, stored procedures, Functions and Views.
• Experience in writing PowerShell scripts for Automation, Executions, Monitoring, Alerting and Reporting.
• Experienced in Import and Export of huge data with scrubbing PIA Data.
• Experienced in providing quality 24/7 on call operational Support for Production Environments.
PROJECT SUMMARY
Costar Group, Washington D.C Mar 2024 - Present
Senior MS SQL Server Database Administrator
CoStar Group, Inc. is a Washington, DC-based provider of information, analytics, and marketing services to the commercial property industry in the United States, Canada, the United Kingdom, France, Germany, and Spain. Founded in 1987 by Andrew C. Florance, the company has grown to include the online database CoStar and many online marketplaces, including Apartments.com, Homes.com, LoopNet, Lands of America, and BizBuySell.
Team:
CoStar Group DBA – DC Team
Projects:
Homes.com Migration project – MS SQL Server 2016-2022, AWS RDS SQL, PostgreSQL, Snowflake,
Apartments.com Revamp - MS SQL Server 2012-2019, MySQL
Costar Analytics Subscription - MS SQL Server 2012-2019, Oracle, Snowflake, Databricks
Responsibilities:
• Managed and maintained SQL Server databases across multiple versions including SQL Server 2019, 2022, and AWS SQL Database, ensuring optimal performance, availability, and security.
• Worked under the leadership of famous SQL server Guru Kun Lee.
• Worked on the Microsoft Replications with re-distributors and distributed AG setups.
• Implemented robust backup and recovery strategies for critical databases exceeding 25 TB, minimizing data loss and downtime during disaster scenarios.
• Conducted proactive performance tuning and optimization using native SQL Server tools and third-party monitoring solutions, resulting in improved query response times and system efficiency.
• Worked and implemented SQL Server High Availability (HA) solutions such as Always On Availability Groups and disaster recovery (DR) strategies to ensure business continuity.
• Automated routine tasks and database maintenance using PowerShell scripts, reducing manual effort and enhancing operational efficiency.
• Collaborated with cross-functional teams to support data analytics initiatives, integrating SQL Server databases with business intelligence tools like Power BI for insightful reporting.
• Provided 24/7 on-call support, responding to and resolving production issues including performance bottlenecks, database corruption, and security vulnerabilities.
• Conducted capacity planning and hardware resource allocation for SQL Server environments, ensuring scalability and optimal performance across development, testing, and production environments.
• Administered Windows Server environments, including Active Directory and failover clustering, to support SQL Server installations and ensure seamless integration with enterprise infrastructure.
• Maintained compliance with industry best practices and regulatory requirements, implementing security policies, access controls, and encryption measures to safeguard sensitive data.
• Designed and optimized MongoDB schemas to support high-performance applications, ensuring efficient data storage and retrieval.
• Implemented indexing strategies (compound, TTL, text, and geospatial indexes) to improve query performance.
• Developed and managed MongoDB clusters with replication and sharding for high availability and scalability.
• Performed database migrations from SQL to MongoDB, ensuring data integrity and minimal downtime.
• Optimized aggregation pipelines for complex queries, improving performance and reducing execution time.
GEICO, Chevy Chase, MD April 2023 – Mar 2024
Senior MS SQL Server Database Administrator
For more than 75 years, GEICO has stood out from the rest of the insurance industry. Standing as one of the nation's largest and fastest-growing auto insurers with Advance technologies, low rates, outstanding service and clever marketing. It’s a wholly owned subsidiary of Berkshire Hathaway.
Team:
Production Support L1 and L2
Projects:
Billing – MS SQL Server 2012-2022, Azure SQL, PostgreSQL
Auto Policy - MS SQL Server 2012-2019, MySQL
Multi Line Commercial - MS SQL Server 2012-2019, Oracle
Internal Applications - MS SQL Server 2012-2019, PostgreSQL
Responsibilities:
• Extensively worked on database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2012, SQL Server 2019 SQL Server 2022 and SQL Server in Azure IaaS
• Worked on Performance Tuning and Optimization, using native and third-party monitoring and troubleshooting tools.
• Worked knowledge of Systems Center Operations Manager (SCOM) and IDERA diagnostic Manager.
• Implemented Solid SQL Server backup and recovery strategies for VLBD’s more than 20 TB.
• Worked on defining hardware requirements and storage capacity planning for development, testing, QA and production for capacity planning and performance.
• Extensively worked on SQL Server High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Administering Windows Server, including Active Directory and failover clustering.
• Tons of experience with Production support gained in Top Severity calls, including support of Performance, Plan Cache, parameter Sniffing, SSIS, SSRS, SSAS, Data cubes, replication, Always ON Lag
• In depth experience with Azure SQL DB and automation of database objects.
• Design and implement automated scripts and strong knowledge of system tables and DMV's.
• Experienced in working with Microsoft Azure IAAS and PAAS solutions.
• Experienced working with data analytics teams and business intelligence tools especially PowerBi
• Experienced with SQL Server Reporting Services, SQL Server Integration Services and/or SQL Server Analysis Services.
• Integrated Microsoft Dynamics with SQL Server databases for seamless data flow and reporting.
• Developed custom workflows, dashboards, and reports in Microsoft Dynamics to meet specific business requirements.
• Worked on many productions Firewall and network security issues on collaborating with multiple teams.
• Demonstrated Advanced working knowledge of Windows Server management such as disk administration, general performance health counters and overall server configuration
• Worked of Networking concepts such as subnetting, telnetting, IPV4 routing protocols and overall network connectivity.
• Supported PostgreSQL Migrations and Administration using EDB tools.
• Monitored database performance using tools like MongoDB Atlas, MMS, and custom scripts to identify bottlenecks.
• Implemented security best practices by managing roles, authentication, and encryption.
• Automated backup and restore processes to ensure data integrity and disaster recovery readiness.
• Integrated MongoDB with applications using drivers for Node.js, Python, and .NET.
• Resolved replication lag and failover issues in MongoDB replica sets to ensure high availability.
• Provide 24/7 on call support with other SQL Server DBA’s and production support team members.
•
TEOCO Corporation, Fairfax, VA July 2018 – April 2023
MS SQL Server Database Administrator
TEOCO was incorporated in 1994 and has been doing business in the United States since 1995. Headquartered in Fairfax, Virginia, TEOCO is the leading provider of assurance and analytics solutions to communication service providers worldwide. TEOCO's product portfolio includes: margin assurance, service assurance, and customer analytics. TEOCO provides proprietary software products and services for network cost management, revenue assurance, and business intelligence solutions. TEOCO offers on-demand, network cost optimization solutions designed to process large volumes of detailed records and to deliver new insight into cost and revenue data. TEOCO's customer base consists of tier-one and tier-two service providers globally, including large incumbents in the Americas, Europe and Asia-Pacific. TEOCO's most recently reported U.S. sales of $172 million attest to the company's success. TEOCO is the parent network of subsidiary companies located around the world.
Team:
Database Administrators Team
Projects:
AT&T, Sprint, Century Link Conductor – MS SQL Server 2012-2019, Azure SQL
Jira Ticketing System - MS SQL Server 2012-2019
Finance Systems - MS SQL Server 2012-2017, PostgreSQL
SharePoint application- MS SQL Server 2012-2017
Responsibilities:
• Install and configure new SQL Server stack applications to specified guidelines or 3rd party application Requirements.
• Manage, restore and disaster recovery for database backup of current database applications.
• Interact with vendors to periodically test restoration of the backups.
• Migrate customers and standalone servers hosting hundreds of databases from legacy domain to new domain.
• Configuring security within established guidelines and perform related task/audits.
• Refresh test and Development environment databases with latest production copies.
• Worked with business stake holders and end clients on internal/third party audits.
• Coordinate with Windows SA and Storage administrators to implement new hardware for hosting databases which is scalable and provides optimal performance.
• Follow processes and escalate as required and take ownership of Incident and service requests and follow
Through to completion.
• Monitor the storage usage for capacity planning.
• Monitor & troubleshoot issues with all SQL Server stack products (i.e. SSMS, SSRS, SSIS, SSAS, etc.) and
advise developers on the most efficient database design (tables, datatypes, stored procedures, etc.)
• Build and maintain documentation related to the organization’s database environment.
• Implementation of process to enable centralized monitoring of all databases and automate error notifications.
• Monitoring SQL server performance using SQL Profiler to find performance, blockings and dead locks.
• Preparation of project management and technical documentation.
• Providing documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Analyzing long running slow queries and tune the same to optimize application and system performance.
• Analyzing the SQL Server configuration settings for better server management.
• Work with Cloud operations teams on server level issues to prevent/resolve issues as needed.
• Provide 24/7 on call support with other SQL Server DBA’s and production support team members.
Ceridian HCM, Inc., Alpharetta, GA Sept 2015 – Jun 2018
MS SQL Server Database Administrator
Ceridian HCM is a global human capital management technology company serving over 25 million users in more than 50 countries with employees in the USA, Canada, Europe and Mauritius. Ceridian is enabling thousands of small and big companies across the globe to design their workforce for maximum effectiveness and efficiency. Its cloud-based HCM technology transforms payroll, benefits, workforce management, human resources and talent management into human capital management that delivers results.
Team:
Hosting Operations - Production Support – DBA Team
Projects:
Ceridian/Dayforce Human Capital Management Application – MS SQL Server 2008-2012
Responsibilities:
• Participated in meetings and worked with the infrastructure team, Windows and Storage teams in finalizing the design structures and completed on time.
• Installed and administered two-Node Cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Backup and recovery processes and maintenance to ensure recovery timelines are met and assist development in lower environmental restores.
• Notification/Alerts management and resolution (i.e. SQL Agent Job Failures, Capacity Shortages, System Outages, etc.)
• Hands on database instance maintenance tasks (i.e. DB Integrity Checks, Index Maintenance, etc.) and how to resolve.
• Configuring security within established guidelines and perform related task/audits.
• Work with business stake holders on any internal/third party audits.
• General knowledge of TSQL and best code standards for ad-hoc script review and deployment practices.
• Deployment of database change scripts provided by customers and 3rd parties.
• Worked on Very large databases and Administration of different SQL Servers versions (2008 and 2012) on
production, test and development clustered and standalone environments. (Physical and Virtual environments).
• Follow processes and escalate as required and take ownership of Incident and service requests and follow through to completion.
• Monitor and troubleshoot issues with all SQL Server stack products.
• Advise developers on the most efficient database design (tables, datatypes, stored procedures, etc.)
• Using profiler trace and other tools to find most frequently run queries and help resolve issues with those queries.
• Identifying and re-solving the Performance issues/bugs during new release of application.
• Rebuilding the indexes and Defrag at regular intervals for better performance.
• Monitored and modified Performance using execution plans, plan guides and Index tuning.
• Managing the SQL native and third-party backups on regular basis.
• Configuring Temp-DB. Handled extreme ad-hoc query operations.
• Monitoring the servers using SQL Sentry, Fog-light and MS Dynamics.
• Transferring the data to Pre-Production with decryption and Scrubbing of PIA Data.
• Extensively worked on DBCC commands and Dynamic Management Views in SQL Server 2012-2016.
• Implemented Resource Governor to control the CPU issues.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Installed, authored, and managed daily/weekly and ad-hoc reports across all environments.
• Install and configure new SQL Servers application to specified guidelines or 3rd party application requirements
• Build and maintain documentation related to the company’s database environment.
• Work with other teams on server level issues to prevent/resolve issues as needed.
• Work with other teams on change requests to analyze effect to SQL Machines.
• Work with the team to determine the correct technology to meet application requirements which could include clustering, log shipping, mirroring, Always-On, or other technologies.
American Red Cross, Ashburn, VA May 2012 – Aug 2015
Database Administrator
The American Red Cross (ARC), also known as the American National Red Cross, is a humanitarian organization that provides emergency assistance, disaster relief and education inside the United States. Today, in addition to domestic disaster relief, the American Red Cross offers services in five other areas: community services that help the needy; communications services and comfort for military members and their family members; the collection, processing and distribution of blood and blood products; educational programs on preparedness, health, and safety; and international relief and development programs.
Team:
Run and Maintain – Production Support
Projects:
Microsoft Share Point 2010 Migration project – SQL Server Cluster 2012
AFES – Armed Forces American Red Cross Project - SQL Server 2008 R2
DSARS – Disaster Services Automated Reporting Services – SQL Server 2008 R2
Microsoft TMG and Exchange Project – SQL Server 2008 R2
SAF dovetail Project – SQL Server 2012
WebSense 7.0 - InfoSec Project – SQL Server 2012
Responsibilities:
• Datacenter migration and Consolidation for the American Red Cross’s critical applications managed by the vendors hosted in different data centers.
• Worked on Very large databases and Administration of different SQL Servers versions (2000, 2005, 2008 and 2012), MySQL and Mongo on production, test and development clustered and standalone environments. (Physical and Virtual environments).
• Migrated SQL server 2008 R2 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Participated in meetings and worked with the infrastructure team, Windows and Storage teams in finalizing the design structures and completed on time.
• Installed and administered Two-Node Cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Troubleshooting and resolving database integrity issues, performance issues like blocking, deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Worked on Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Used OLAP in storing the historical data to evaluate the trends.
• Detect and troubleshoot ODBC, ms.net/SQL connections, SSIS packages, Stored Procedures, SQL Server related CPU, memory, I/O, disk space and other resource connections with data flow.
• Satisfying the backup and restore requests, working knowledge on recovery models, database and log shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
• Worked on building and updating indexes, index management, integrity checks, configuration, patching. Statistics work and managed them effectively.
• Used T-SQL efficiently in troubleshooting day to day incidents, SSIS, SSRS and Stored procedures
• Used a wide variety of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, Perf-Mon, DMVs, system stored procedures) in different trouble shooting instances and Resolved many database problems
• Participated in the SQL Development – ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
• Experienced in developing and implementing a data architecture in Agile methodology.
• Expert in configuring Temp DB. Handled extreme ad-hoc query operations.
• Experienced in SSIS development and deploying them on production servers during the maintenance cycles or end of sprint cycles, which followed consistent application of Agile methodologies across the enterprise.
• Implemented the DR (Disaster Recovery Mechanisms), High availability and Always ON features for SQL Servers.
• Widely used SSRS in generating the day to day business and SQL Space reports
• Daily tasks include investigation of performance issues, backup failures, failed SQL jobs or packages and replications. Trouble shoot and fixing Part of Run and Maintain.
• Provided 24/7 on call support with other SQL Server DBA’s and production support team members.
• Maintained error reporting and documentation, Team wiki, with the common problems with solutions in day to day activity.
MacMillan Publishers, New York City, NY Oct 2010 – April 2012
MS SQL Server Administrator
Macmillan Publishers Ltd is the leading company with a rich history in the publishing industry and one of the largest U.S. publishing houses. The adult trade collection comes from a distinctive conglomerate of leading publishing imprints. Macmillan’s other primary focuses are on educating the leaders and thinkers of tomorrow with its college and academic titles, magazines and journals.
Projects:
Macmillan and BFW (Bedford, Freeman and Worth Publishing Group) Academics Project – SQL Server 2000, 2005 and 2008 R2
Team:
Production Support DBA
Responsibilities:
• Installed and configured over 60 SQL Server instances (2008R2 and 2005) for data center migration.
• Analyzed existing SQL Servers and developed migration plans for side-by-side upgrades in both production and QC environments.
• Successfully migrated more than 300 user databases from SQL Server 2005 to 2008.
• Configured SQL Server 2008R2 Multi-Node Multi-Instance Clustering for small application environments.
• Implemented log shipping for disaster recovery in production systems.
• Designed database maintenance plans, covering integrity checks, updating statistics, and re-indexing for optimal performance.
• Utilized NetApp SnapManager for SQL Server with automated email alerts for snapshot failures.
• Managed and created database user roles and responsibilities.
• Supported code upgrades using Visual Studio in collaboration with developers.
• Proactively performed SQL Server performance tuning at the database, T-SQL, and operating system levels, maintaining response times and automating routine DBA tasks.
• Created and managed database objects such as tables, procedures, triggers, constraints, indexes, and views.
• Developed processes for automating maintenance jobs, tuning SQL Server locks and index configurations, and implementing backup strategies with automatic notifications.
• Maintained the Datatel administrative suite, supporting Student, HR, and Learning platforms.
• Assisted in upgrading content requests for Macmillan textbooks for instructors.
• Collaborated with the storage team for LUN creation and migrations in SQL Server clustering.
• Configured virtual servers using VMware.
• Worked extensively on exporting/importing data, transactional and merge replications, log shipping, and creating data snapshots both within and across databases.
Contact this candidate