Database Administrator Devops Engineer

Nagammai Ramanathan

Email:- ********.******@*****.***

https://www.linkedin.com/in/nagammai-ramanathan-10830b85/

Mobile:- 916-***-****

PROFESSIONAL SUMMARY

Passionate, skilled, and certified Azure SQL Database Administrator / DevOps Engineer with over 8+ years of extensive experience in managing and administering large-scale, complex databases across Microsoft SQL Server (2008R2 to 2022), both on-premises and in the cloud (Azure/AWS). Proven expertise in high availability and disaster recovery solutions including Always On Availability Groups, Failover Clustering, Log Shipping, and Transactional Replication. Successfully supported Very Large Databases (VLDBs) exceeding 4TB and led critical database migrations from on-prem to Azure PaaS.

Experienced in modern cloud data architectures, including Azure Data Lake (ADLS), Azure Databricks, and Snowflake, with hands-on knowledge in designing and automating CI/CD pipelines for data ingestion, curation, and transformation using Terraform and Azure DevOps. Proficient in integrating Databricks and Snowflake into enterprise ecosystems with secure storage integrations, metadata management, role-based access control (RBAC), and query optimization.

Strong experience in database development, performance tuning, automation using PowerShell, and implementing BI solutions with SSIS, SSRS, and Power BI. Adept in end-to-end data pipeline creation, monitoring, security implementation, and system integration using APIs. Collaborative team player with a strong attention to detail and a continuous learning mindset to deliver optimized, scalable, and secure data solutions.

TECHNICAL SKILLS

Cloud Technologies Azure,AWS

Databases MSSQL, MS Access, postgresql

Operating Systems Windows, Red Hat Linux, Ubuntu

CI/CD Tools Azure pipelines,jenkins

Configuration Management Tools Ansible, Terraform

Containerization Docker, Kubernetes

Version Control Tools GIT, Bitbucket, SVN, TFS

Scripting Languages Powershell, Python, YAML, Bash shell,

Virtualization Technologies VMware ESX/ESXi, Windows Hyper-V, Virtual box

Web Servers Apache HTTP 3.x, Apache Tomcat, Nginx

Monitoring Tools SCOM, Elastic, Azure monitoring, Azure sql insight

Repository Management JFrog, Nexus, Artifactory

IDE Tools Visual Studio Code

PROFESSIONAL EXPERIENCE

SQL Database Administrator Nov 2024 - Present

Client Flow Control Group – NC, Charlotte

• Experience in Database administration activities like Installation, Configuration, Backup & Recovery and Database Security.

• Extensive Knowledge on Successfully Troubleshooting Various SQL Server Issues.

• Experience in Azure IaaS and PaaS Environments.

• Migration of SQL Databases from On-promise to Azure Cloud.

• Experience in Analyzing, Resolving Performance Issues and Provide Recommendations.

• Extensive Knowledge of Database Migration, Database Refresh Activities.

• Experience in Creation, Management and Troubleshooting of High Availability Solutions Such as AlwaysOn, Replication and Log Shipping.

• Experience on creating changes and attending CAB meetings for approvals.

• Experience in Index Analysis and Providing Index Recommendation based on the Analysis.

• Experience on Microsoft Parallel Data Warehouse Deployments and Troubleshooting issues.

• Hands-on Experience in Managing User Security, Capacity Planning, SQL Patching.

• Experience on Rubrik backup.

• Hands-on Experience in Various SQL Monitoring Tools Such as SQL IDERA, SCOM.

Configuring warehouses, databases, and other Snowflake objects to meet specific project or organizational requirements.

Implementing and managing security measures within Snowflake, including data encryption, access controls, and network policies to protect sensitive information.

Managing data storage within Snowflake, including data loading, transformation, and extraction processes

Experience in Installation, Configuration, Migration and Troubleshooting of SSRS and SSIS Environments.

Successfully integrated numerous applications and connected them via APIs for seamless data exchange.

Experience in Developing T-SQL, PowerShell Scripts.

Excellent Team Player and 24/7 Production Experience.

Monitoring the performance of Snowflake environments and executing performance tuning strategies to optimize query execution and resource utilization.

Providing technical support and training to users on how to effectively use Snowflake features

Collaborating with data engineers, analysts, and IT teams to support data-related activities.

Role: Azure SQL Database Administrator Apr2022 –Nov 2024

Client AT&T - Dallas, Texas

Responsibilities:

•Responsible for migration operational support and database installation of AT&T on-premises to Cloud Hadoop/Databricks/ADLSv2 Data Lake infrastructure.

•Implemented automation to satisfy AT&T Public Cloud requirements for monitoring and security, performance, and the automated provisioning of 6000 containers for ETL Ingestion in the Azure Data Lake ADLSv2 storage infrastructure.

•Expert in SQL Server Database Administration, including SQL Server on VM, Azure SQL Database, and Azure SQL Managed Instance.

•Expertise in implementing security models, Database authentication modes, creation of logins, granting permissions, and assigning roles to users on databases.

•Configured and maintained Elastics DB pools.

•Led operational support and automation of AT&T on-premises/Cloud Hadoop/Databricks/ADLSv2 Data Lake

infrastructure.

•Responsible for patching and rehydration of virtual machines and virtual machine scale sets for ant config findings or vulnerabilities reported.

•Monitored Azure SQL Servers, using Azure Monitor with SQL Insights, ELK, and Log Analytics for comprehensive, built-in monitoring for SQL databases.

•Created and troubleshooted end to end Azure DevOps automation pipeline that deploys Azure Databricks workspace

for a client.

•Provided support to code Azure pipeline to deploy Azure Databricks for different application teams.

•Experienced in provisioning and troubleshooting ADLSgen2 storage account access issues from different platforms

(Databricks, Snowflake, NIFI and DEEP). Developed the CI/CD pipeline automation using Terraform and Microsoft’s DevOps Stratum toolkits to orchestrate the Azure Databricks (ETL/Data curation/ingestion) PaaS offering. This replaces the on-premises Hadoop data lake used by AT&T applications transitioning from on-premises to cloud infrastructure.

•Provided the cloud services Authentication,Infrastructure management,Metadata management,Access control,Query parsing and optimization for snowflake.

•Managed Production environment for High Availability and implemented Always ON availability group with three replicas for reporting and backup.

•Experience with Data Migrations, Upgrades, Clustering, Database Mirroring, Replication, and Log Shipping.

•Experience in database development, administration, and management for PostgreSQL.

Role: Senior SQL Database Administrator Feb 2021 – Apr2022

X-Fusion Technologies - Sacramento, California

Responsibilities:

•Managed Production environment for High Availability, implemented Always ON availability group and SQL cluster .

•Create and maintain comprehensive database documentation, including database schemas, configurations, and procedures.

•Resolving performance related issues to Blocking, Deadlocks and long running queries.

•Performing upgrade,patching and Migration of lower version SQL Servers to SQL 2019/2017/2016/2014.

•Installing/Configuring SQL Server 2019/2017/2016/2014/2012 Always on availability groups for high availability.

•Managing Microsoft Active\Active, Active\Passive Clusters in SQL environment

•Spearheaded the migration of massive datasets totaling over 5TB from a legacy data warehouse to Snowflake, ensuring seamless transfer with no downtime using Azure Blob Storage or Data Lake Storage Gen2 as external stages for data loading/unloading.

•Creating storage integrations to securely connect Snowflake with Azure containers.

•Defining external tables for querying staged data directly from Azure.

•Assigned RBAC roles to manage user access to systems and data based on predefined roles, minimizing the risk of unauthorized access. Data masking, on the other hand, safeguards sensitive data by replacing it with fictional data, while encryption transforms data into an unreadable form, securing it from unauthorized access.

•Implementing Log Shipping and always on availability groups for disaster Recovery,Backups (RPO/RTO), Failover clustering, SAN replication and high availability.

•Used third party tools IDERA, Diagnostic Manager and SCOM for monitoring SQL Servers.

•Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.

•Worked on transactional replication, and monitoring and troubleshooting replication issues.

•Deploying and monitoring SSIS Package tools of SQL Server to populate data from various data sources.

•Scheduling backups for databases and Transaction logs. Performing restoration operations and suggested backup strategies.

•Controlling user access controls, permissions, user roles and managing data security.

•Cleaned and transformed data using Power BIs Query Editor to prepare ETL processes to optimize reporting datasets.

•Created data models, tables within Power BI to support efficient, optimized data warehousing and reporting workflows.

•Involving in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using DMVs, Wizards and SQL Profiler.

•Performance tuning (Server Level, DB Level, Query Level, CPU, memory, Disk I/O, tables, index Rebuild/Reorganize).

•Setup, Configure and Administer SSRS and design SSRS reports based on the requirements.

•Document and troubleshoot complex issues related to Azure PaaS services: Microsoft Azure SQL Database and Managed Instance.

Database Administrator Jan 2020 – Feb2021

Synergy Quad - Sacramento,California

Responsibilities:

•Installing SQL Server 2012/2014/2016 cluster/non-cluster environments.

•Planning/Communicating/Coordinating/Installing SQL Server patches and security updates.

•Migrating 2012 R2,2014 databases to SQL 2016,2019 using in place upgrade and side by side approach.

•Creation and Implementation of Standard Maintenance plans for backups, index

•rebuild/reorganize, database integrity checks and history clean ups on all the Production servers.

•Worked on creating and troubleshooting of SSIS packages and SSRS.

•Implemented standard backup and Recovery procedures as per the applications criticality.

•Participated disk capacity planning for prod/non-prod servers.

•Configured SQL / DB MAIL for sending server / database alerts.

•Responsible for monitoring and troubleshooting performance issues at the server level, database level and query level.

•Worked on high data availability solutions Clustering and always on availability groups (AAG).

•Query tuning based on the results derived out of the SQL profiler and performance monitors.

•Resolved Incident tickets, Change Requests and RITM requests.

•Creating and Troubleshooting of DTS/SSIS packages.

•Responsible for providing cut out solutions for database servers resolving issues in a limited amount of time.

•Change Management: Creating and implementing configuration changes to the existing database servers on a planned level.

•Performance tuning (hardware, network, front end, memory, tables, indexes, etc.).

•Provided 24 x 7 Production support for the database and application issues.

Database Administrator-Customer Engineering support May 2017 – Dec 2019

Client TCS - Sacramento, California

Responsibilities:

Advanced level troubleshooting of on-prem sql servers, databases, and queries.

Meet SLA and communicate with customers effectively in Critical Situations.

Communicate and work with Product Group and other teams to resolve client issues.

Analyze logs to find root cause analysis on events, behaviors, queries, connections, and issues related to SQL service.

Assist customers with firewall rules, vnet rules, geo-replication, monitoring, DMVs, etc.

Recommend clients regarding service best practices and educate them by providing “How-To” documentation.

Conducted standard product workshops in always-on-availability groups.

Worked on post-operational review of product implementations.

Conducted Product Upgrade/SQL SERVER Migration Assessments

Act as onsite technical contact, providing customer visibility, problem resolution for corporate customers.

Business Acumen/Business focused technology application.

Designed technical documents as per client requirements.

Improve the performance of SQL Queries and stored procedures using SQL Profiler.

Role: Systems engineer Jan 2008– Sep 2012

TCS- Bangalore,India

Responsibilities:

•Worked on live production environment. Solved and supported the client's issues.

•Assist various teams on system environment, security issues, and offshore teams by debugging.

•Installed and mounted the application on UNIX, oracle, and Windows server from scratch.

•Expertise in creating, maintaining database objects like Indexes, Functions, views, Triggers, and constraints.

•Installed, maintained, and refreshed the database.

•Performed database patching and implemented the new components.

•Hands on experience in taking complete database backup, recovering and trouble shooting.

•Expertise in scripting Perl and SQL.

•Developed the Distributor tool.

Education:

Master’s in computer applications 2007

Bharathidasan University

Contact this candidate