Senior SQL Server DBA and Azure SQL Engineer

SRIKAR AJJA

SUMMARY:

Over ** years of experience in Microsoft SQL Server database design, development, support, and administration across SQL Server 2022, 2019, and 2016 in Development, Testing, Staging, and Production environments, both onpremises and in Azure.

Extensive experience in the installation, upgrade, and configuration of Microsoft SQL Server across standalone and clustered environments.

Skilled in installing cumulative updates, hotfixes, and security patches on both clustered and non clustered servers.

Experience migrating databases between Microsoft SQL Server and Azure, including SQL Server 2014/2016 to SQL Server 2019/2022.

Provisioned Azure SQL Server and Azure SQL Databases using the Azure Portal and PowerShell.

Set up Active Geo Replication and standardized high availability solutions.

Configured server level and database level firewall rules for secure Azure SQL connectivity.

Designed and implemented comprehensive Backup/Restore and Disaster Recovery (DR) strategies, including point in time recovery and full DR documentation.

Hands on experience with third party backup tools such as Redgate, Tivoli Storage Manager (TSM), Tivoli Data Protection (TDP), Veeam, and Cohesity.

Experience creating and managing Users, Logins, Server Roles, and assigning Permissions for secure database access.

Extensive experience maintaining SQL Server High Availability solutions using Failover Clustering including SQL Server 2022 deployments.

Hands on experience with SQL Server 2019 AlwaysOn technology, including managing a 3 node cluster.

Managed databases up to 16 TB in size within clustered environments.

Monitored CPU usage, I/O statistics, and memory utilization to identify OS level performance bottlenecks, including enabling database level traces for performance testing.

Strong experience in SQL Server Performance Tuning and Query Optimization using native and third party tools such as Windows Performance Monitor, SQL Profiler, Spotlight, and Redgate SQL Response.

Experience creating SSIS packages, scheduling Jobs, and configuring Alerts using SQL Agent and Database Mail.

Extensive experience deploying and maintaining SSIS packages and SSRS reports.

Hands on experience with Attunity/Qlik Replicate for ingesting data from SQL Server to Hadoop and other destinations like Hadoop and Big Query.

Strong skills in Object Oriented Analysis, Design, and Programming, with the ability to quickly learn and adapt to emerging technologies.

Excellent communication, presentation, analytical, and interpersonal skills.

Delivered 24/7 support, including scheduled and emergency night and weekend work/OnCall.

EDUCATION & CERTIFICATION:

Master of Science in Software Engineering from Stratford University, Falls Church, VA

MCTS 70-431: Microsoft SQL Server 2005 - Implementation and Maintenance

PROFESSIONAL EXPERIENCE:

Client: Ford Motor Company, Dearborn, MI

Contract through Systems technology group Inc.,

Sep 2016 – Present

Sr Database Admin

Responsible for reviewing and resolving backup issues using SQL native, Veeam, Cohesity backup strategies.

Installing, maintaining, and upgrading SQL Server binaries, instances, and databases.

Supporting database structure changes and data modifications for application development, testing, and deployment.

Enforcing IT policies and security requirements for database access and controls using ISP standards.

Working with a wide variety of customers with diverse technical skills and needs.

Managing incoming incidents and customer requests through ticketing systems like BMC, and ServiceNow.

Monitoring and troubleshooting Azure Data Factory pipelines.

Collaborating with infrastructure teams including OS administrators, web server admins, and network administrators.

Coordinating changes with infrastructure teams through change control and ticketing systems.

Collaborated in Agile Scrum ceremonies, code reviews, sprint reviews, and capacity-planning sessions utilizing Rally and Jira.

Creating Database Maintenance Plans for SQL Server performance, including integrity checks, updating statistics, and re indexing.

Creating and managing Azure virtual networks.

Upgrade the PostgresSQL version from 17.5 to 18.1 and operator version from 5.8.2 to 5.8.6.

Performed PITR(point in time recovery) using the existing backup/repo.

Engineered and maintained SCOM 2025 and 2019 infrastructure across database servers using dual-homed configurations.

Designed custom SCOM rules and monitors to trigger targeted alerts and automate incident management.

Maintaining PII data security by encrypting databases using Transparent Data Encryption (TDE).

Successfully testing and utilizing TDE encryption suspend/resume options to manage encryption scans and reduce performance impact during peak hours for large databases.

Resolving latency issues in Qlik Replicate tasks by manually applying transactions and analyzing task logs to identify and fix errors.

Environment: Windows server 2016, 2019, 2022; MS SQL Server 2016, 2019, 2022; SCOM 2016, 2019, 2025, Jira, Rally, ServiceNow, BMC

Client: Cincinnati Children’s Hospital, Cincinnati, OH

Contract through: V-soft consulting group Inc.,

June 2015 – Aug 2016

MS SQL Server DBA

Cincinnati Children’s, a nonprofit academic medical center established in 1883, is one of the oldest and most distinguished pediatric hospitals in the United States.

Responsible for installation, configuration, diagnostics, and database administration of the SQL Server environment.

Involved in Migrating SQL Server 2008/2008 R2 to SQL server 2014 in Development, Test database servers

Administered the MS SQL Server by creating user logins with appropriate roles, locking and dropping the logins, monitoring the user accounts, granting the privileges to users

Design and Implementation of Business Intelligence applications using SQL Server Integration Services (SSIS) and Reporting Services(SSRS)

Modified database structures including tables, dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements

Client: Xerox Corporation, Webster, NY

Contract through: V-soft consulting group Inc.,

April 2011 – May 2015

MS SQL Server DBA

Xerox is a multinational corporation which is specialized in products related to document management and digital Imaging. They are also well established in the IT services and consulting fields. They have various applications that help the company and the clients to manage/operate more efficiently and effectively their devices.

Work with the product management and engineering teams to design (using ERD) databases for next generation solutions.

Serve critical information needs across Managed Print Services/Engineering Services & Support platform.

Work closely with application developers and various team members from different departments across the organization.

Develops capacity and licensing requirements for new servers, databases, and applications.

Work closely with Microsoft to resolve issues that arise in the Production environment.

Participate in initiatives to analyze and improve data quality.

Ensure overall quality of implementation and support features during testing/bug fixing phase of the software development lifecycle.

Hands on experience on EMC networker/legato software to perform database backups and restore operations

Extensively worked on tickets, work order and incidents created by development users and end customers as well using Xerox service manager

Hands on experience on maintaining small & medium sized databases and large sized databases, 4 - 16 TB as well

Client: Arkansas Department of Health, Little rock, AR

Contract through: V-soft consulting group Inc.,

Apr 2010 – March 2011

MS SQL Server DBA

The Arkansas Department of Health (ADH) is a unified health department, with a main office in Little Rock and 94 local health units in each of the state’s 75 counties. The Center for Health has among its many branches Chronic Disease, Family Health, Women, Infants and Children (Immunization Network for Children, INC), and Oral Health. ADH maintains the vital (birth and death) records statewide.

Installed and configured SQL Server 2005, 2008 on Standalone and Clustered Environments

Involved in Migrating SQL Server 2000/2005 to SQL server 2005/2008 in Development and Production databases

Maintain database including consistency checks, and index defragmentation

Truncating/shrinking transaction logs, checking data allocation errors and any data inconsistencies and updating database statistics

Contact this candidate