GURUNADHA GOLLA
**********@*****.*** 409-***-**** https://www.linkedin.com/in/gurusqldba/
Executive summary:
Seasoned SQL Server Database Administrator with over 15 years of experience managing mission-critical production environments (SQL Server 2000–2022), along with 5 years of experience in Azure and AWS Cloud. Expertise in T-SQL development, performance tuning, and HA/DR solutions including Always On, Replication, and Clustering. Strong background in designing scalable data architectures, cloud migrations Azure (PAAS & IAAS), AWS RDS, and automation using PowerShell. Proficient in SSIS, SSRS, Datadog, Grafana, SolarWinds, Octopus Deploy, Azure DevOps and Agile Scrum. Successfully managed over 2,000 SQL instances, supporting OLTP and OLAP workloads with a strong focus on RTO and RPO objectives.
Professional Experience:
15+ years of production Database administrator experience in MS SQL Server all versions (SQL 2000–2022).
Strong experience as an Azure DB (PAAS & IAAS), Managed Instances, AWS RDS and Elastic Pools.
Proficient in writing T-SQL objects such as tables, primary key, foreign key, views, indexes, and SPs
Implemented backup & restore strategies both OLTP and OLAP, focus on meeting RTO and RPO objectives.
Experience in Upgrade and Migrate on-premises databases to Azure cloud using Data Migration Assistant
Experience in Capacity Planning, implement Audit, CDC, Dynamic data masking and Encryption (TDE)
5+ years of team leading and managing experience for the database production support
Proficient in writing T-SQL objects such as tables, primary key, foreign key, views, indexes, and SPs
Configured HA/DR solutions: Always-On Availability Groups, Log Shipping, Mirroring, and Replication.
Expert in identifying bottlenecks related to CPU, memory, disk I/O using Extended Events, DMVs.
Performance tuning through indexing, statistics, blocking, Deadlock, execution plans, and fragmentation.
Implemented role-based security, at instance, database, and object levels using AD groups.
Experience in using BCP, DBCC, DMV, SQLCMD, SQL Agent Jobs, database mail, alerts and operators.
Experience with ETL tools including SSIS, SSRS, SSAS, and cloud Azure Data Factory, Power BI.
Experienced in using data modeling tools Erwin, DB Forge, and SSMS Diagrams to design RDBMS structures.
Implemented monitoring and alerting tools AppDynamics, Grafana, Datadog, SolarWinds and Azure Monitor. Eliminated months of production problems and Improved transaction processing speed by 60%.
Proficient in PowerShell automation results in HTML format and send email using Microsoft Graph API.
Familiar with Azure DevOps, for version control, CI/CD, and packages deployments via DACPAC
Successfully led large-scale SQL migrations including Oracle to SQL Server for 6 TB of data with indexing.
Supported ServiceNow ticketing, created SOPs, and developed dashboards to enhance operational visibility.
Domain Experience 7 years in banking, 5 years in healthcare, and 2 years onsite in Kuala Lumpur, Malaysia.
Technical Skills:
Database Administration
MS SQL Server DBA 2000, 2005,2008, 2012, 2014, 2016, 2017, 2019, 2022, 2025
Cloud DBA
Microsoft Azure, Azure DevOps, Azure Portal, SaaS, IaaS, PaaS, AWS RDS
Programming Languages
T-SQL, PowerShell, PL/SQL
BI / Data Tools
Power BI, SSIS, SSRS, DTS, Azure Data Studio, azure storage explorer
Methodologies
Agile, Scrum, Waterfall
Source Control
Octopus Deployment, GitHub, Infrastructure as Code IAC
Ticket & Monitoring
ServiceNow, SCOM, Grafana, Redgate, LightSpeed, AppDynamics
Web &.NET Technologies
ASP.NET, ADO.NET, C, C++, Python, HTML, CSS3, DHTML
Scripting Languages
JavaScript, jQuery, Visual Basic
Certifications Details:
AZURE DP-300 Microsoft Azure Database Administrator
MCITP: 70-450 Designing, Optimizing, and Maintaining a Database Server Infrastructure
MCTS: 70-432 SQL Implementation and Maintenance
MCTS: 70-431 SQL Implementation and Maintenance
Oracle: 1Z0-052 Oracle 11g Administrator Certified Associate
Work Experience:
Database Administrator May 2025 – Till Date
Company: ISHA TECH LTD
ROUND ROCK, TEXAS
Roles and responsibilities:
Installed, configured, and maintained SQL Server instances, including standalone and clustered deployments.
Designed and implemented backup and disaster recovery strategies, ensuring RPO/RTO compliance and regular recovery testing.
Tuned and optimized database performance by analyzing execution plans, indexing strategies, and query refactoring.
Monitored SQL Server health using native tools and custom alerts to proactively address performance and availability issues.
Configured and maintained high availability and disaster recovery solutions such as Always on Availability Groups, log shipping, and failover clustering.
Automated routine administrative tasks using PowerShell scripts, T-SQL, and SQL Server Agent jobs.
Scheduled and executed regular database maintenance activities including index management, statistics updates, and integrity checks.
Evaluate and implement new tools and cloud services to enhance infrastructure performance; lead Proof of Concept (PoC) initiatives for emerging technologies.
Senior Data Architect \ Lead Data Architect June 2019 – Apr 2025
Company: Eurofins, Health care
Bangalore, India
Roles and responsibilities:
Worked as Database Administrator, supporting Health care services by managing SQL operations ensuring backup, restore, security, high availability and performance across critical systems for business continuity.
Designed and implemented SQL Server on cloud, including Azure SQL Databases, Managed Instances, and AWS SQL server.
Developed database standards, naming conventions, and best practices for AWS cloud infrastructure
Evaluate and implement new tools and cloud services to enhance infrastructure performance; lead Proof of Concept (PoC) initiatives for emerging technologies.
Due to Ransom virus attack over 50 production and development database files and logs files renamed with “*we apologize” virus extension and corrupted, Lead and rebuild all SQL servers from scratch.
Collaborated with application teams to translate business requirements into efficient data models. Created logical and physical data models, ensuring normalization, referential integrity, and indexing strategies.
Designed and developed web-based tools for SQL Backup and Restore, Job monitoring, SQL server performance monitoring, Reporting, alerting etc.
Acted as a key point of contact for SQL server-related issues and escalations, resolving complex problems and ensuring smooth operations. Provided technical guidance and mentorship to junior team members,
Collaborated with cross-functional teams—including developers, DBAs, Windows administrators, DevOps engineers, and product support teams—to ensure seamless and efficient DevOps processes.
Led automation initiatives using PowerShell to streamline SQL Server management tasks including installation, optimization, security enforcement, performance monitoring, and data integrity checks.
Developed a comprehensive monitoring tool to track SQL Agent jobs, displaying job status, enabled/ disabled states, errors, and catalog failures through a centralized dashboard with real-time.
Developed Grafana-based monitoring solutions for SQL Server, enabling real-time visualization of key performance metrics, including CPU usage, memory, disk I/O, query stats, database health as line graphs, bar charts, pie charts, and heatmaps, to offer insightful insight into performance and trends.
Led end-to-end database architecture designing, planning, and deploying SQL Server environments from scratch, covering 500+ servers across CID, CIT, UAT, CIP, PPD, PRD, and Azure Cloud environments.
Led migrations from on-premises to AWS, with hands-on expertise in AWS RDS backups, disaster recovery and high availability.
Proficiently developed interactive SSIS, SSRS and Power BI reports, transforming business data into Wherehouse and translating complex data into visually appealing and insightful visualizations, such as charts, maps, KPIs, cards, published Power BI reports, and shared PDF reports through email.
Spearheaded Scrum meetings, including Sprint Planning, Daily Stand-ups, Sprint Reviews, and Sprint Retrospectives, ensuring effective collaboration and timely project delivery.
Worked on “Service Now” ticketing tool to Manage incident, service, and problem tickets, providing prompt resolutions to technical issues, minimizing downtime, and ensuring seamless operations.
Developed web tools empowers users to perform Database Refresh tasks seamlessly between environments (PROD to NON-Prods). It is a fully automated backup and restoration process. Users simply need to input the source and target database information, and the tool takes care of the entire restoration process automatically. This tool is implemented in 200 SQL servers and more than 3000 databases.
June 2014 – May 2019
System development Senior specialist\ Project Manager
Company: Xerox Corporation (Xpress Banking)
Worked on designing the database for a digital banking app by creating secure and efficient data structures to support fast customer onboarding and easy access for both bank staff and customers.
Upgraded over 300 SQL servers to the latest service pack level in a tenure of 4 months with the proper follow-ups and approvals from the different Business managers
Played key role in Xerox and Conduent Separation, with respect to the DBA 40 new business and over 1000 SQL instances added to offshore DBA support, this transition process was happened from Guatemala City to India, I have Actively Involved and recruited 20 new dba members in India, Supervised team members to go throw KT process and understand day-to-day operations, total transition process was completed in 3 months.
Lead and succeeded Critical failover and fail back process on 25 production & DR Sites around 200 + database’s, this failover process includes all high availability log shipping, mirroring, replication, clustering and always on, with in 24hrs span of time we completed the total failover and fail back process.
Performed Data Migration from Oracle to SQL server with volume count of 6 TB data, which also includes, Setup SQL Server with high-speed SSD storage drives, data Loading, Converting, Copying, separating active and inactive data, archiving old data. Creating necessary index and statistics for Sql query processing.
Deployed database change scripts and implemented the change management process through CAB.
When performance issues arise, found the most effective way to increase performance including server configuration changes, index/query changes, or hardware changes.
Interface with Oracle for technical support and worked with standard components of the Oracle databases including backups, restores, data pump, archiving, and review of error logs.
Troubleshooting issues like Locking, Blocking and Deadlock.
Allocation of DBA Workload, Supervised the assigned tasks, which includes day-to-day activities
Coordinated DBA team meeting weekly and monthly to analysis the incident and service ticket volumes
Created SOP documents, Daily shift handover, weekend on call support and monthly Shift roster planning.
Apr 2013 – May 2014
Lead SQL server Database administrator
Company: ITC InfoTech (UNIFI aviation LLC)
Served as a Database Administrator for Unifi, the largest ground handling and aviation services provider in North America, supporting transportation services by managing backend SQL Server operations, ensuring high data availability, and maintaining performance across critical systems for daily business continuity.
Performing the database up gradations from lower versions to higher versions and database refreshes form production to development.
Configuring SQL Server instance-level, database-level and object-level security policies, best practices.
Monitoring performance using both System Monitor and Profiler tool
Capturing and tuning the long running query using red gate monitor tool.
Created Database Maintenance Plans for Index Defrag, checking database integrity, rebuilding indexes, Reorganize Index and updating statistics.
Resolve tickets that are raised on Footprint Help Desk, Handling incident management calls
Performed failover clustering whenever necessary.
Developed SQL installation standards, automated installation process.
Working in rotational shifts and providing on-call support on weekends.
Managed team of two DBAs, Preparation of weekly report
Creating requests and follow-up with various teams globally to complete the request on time
Verify the SQL Server FULL and transaction log backups were successful.
Collect index fragmentation information.
Analyzing Error Logs and take proper action to resolve any issues.
Mar 2012 – Mar 2013
Senior Database Administrator
Company: Comtel Solutions (CITI Bank Kuala Lumpur, Malaysia)
Roles and Responsibilities:
Worked as a Senior Database Administrator in Citigroup’s Asia Pacific Regional Database Team, providing 24/7 production support for over 3,000 SQL Server instances across the region, ensuring high availability, performance, and reliability for critical banking applications.
Creating schema objects such as tables, views, cursors, indexes and SPs and maintaining fragmentation
Updated scripts for client to each Version Release, triggers and views to the tables.
Performing DB up gradations from lower to higher versions and database refreshes between PROD to DEV.
Designed SQL Server instance-level, database-level and object-level security policies.
Monitoring performance using both System Monitor and Profiler
Used BCP utility to publish table output to .CSV, .TXT .XLS etc...
Recover PROD DB from Software and hardware failure, failover clustering whenever necessary.
Provided 24x7 on-call support via Sage Help Desk, resolving critical DB outages and high-priority tickets.
Sep 2010 - Mar 2012
Senior database administrator
Company: MICROLAND Limited (Demand Media)
Worked as a SQL Server DBA at Demand Media, supporting large-scale content platforms like eHow.com and LIVESTRONG.com by managing database performance, ensuring high availability, generating business-critical reports, and supporting data-driven strategies using ETL jobs and legacy DTS packages.
Administered security by creating logins, assigning appropriate roles, and granting privileges.
Performed side by side upgrade of multiple SQL Server 200 instances to SQL Server 2008R2
Responsible for database backups and restoration, Scheduling daily backups, DBCC checks.
Transferring Data into various locations Using snapshot Replication and transaction replication
Assisted MYSQL database in migrating data from SQL Server 2005
Creating and maintaining the SSIS Packages and troubleshooting the old SSIS packages.
Monitored SQL services and validated job execution status, promptly addressing failures.
Check the Windows NT Event Viewer, SQL Server logs for error messages.
Monitored and recorded disk space usage to ensure adequate capacity for database and log file growth.
Dec 2009 - Aug2010
Database Administrator
Company: Advanced Computer Solutions (ACS)
Worked at ACS supporting multiple clients under the Microsoft Gold Partner Program. Provided help desk support, handled service tickets, performed server backups and restores, and managed database objects.
Installation, configuration and maintenance of MS SQL Server2000/2005.
Configured SQL 2005 using Surface Area config tool and tuned databases using Database Tuning Advisor
Managed Logins, Users, Roles and User permissions
Configuring, managing and troubleshooting Log shipping issues by continuous monitoring.
Evaluated and configured automated, routine maintenance tasks including performance tuning indexes and stored procedures, check deadlocks, and create and scheduling jobs.
Scheduled and supported routine jobs and alerts, including regular backup and index rebuilds.
Education Details:
MCA (Master of Computer Applications) SVU University, India Successfully completed in 2009
BSC (Bachelor of Computer Science) SVU University, India Successfully Completed in 2005