Ram Donga – MS SQL / Mongo DBA

On-Premise & Cloud (AWS/Azure)

Mobile : 425-***-**** E-mail : adhyn5@r.postjobfree.com

SQL Server Database Consultant with 11 years, seeking a challenging and professionally enriching job in the field of Database Administration utilizing my technical skills

Executive Summary

A dynamic professional with 11 years of experience as DBA

Experience with Agile/Scrum methodologies.

Self-motivated, responsible, confident and can multi-task and prioritize under changing and challenging workloads.

Areas of Exposure

Providing 24x7 support for Microsoft SQL server, Postgres and Mongo databases holding critical business data

Converting the Possible applications to open source (Like Postgres/MySQL) to save Money on the License cost.

Design and implement high availability strategies with replication, log shipping, database mirroring/Always On.

Hands on experience in DAG (Distributed Availability Group)

Experience creating roles, database access, performing Vaccum operations

Installation, Configuration, testing, upgrade and tuning of PostgreSQL databases

Expert level of Postgre SQL RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in large and very dynamic environments

Advanced knowledge of PL/pgSQL, triggers and writing change scripts.

Supporting multi node MS SQL Cluster (Active/Passive & Active/Active) instances.

Strong Knowledge in Aurora databases, AWS RDS, Postgres, AWS DMS

Write, debug and optimize complex Postgresql queries

Scripting experience on PowerShell and Python to automate the daily activities.

Providing support for AWS/Azure services like EC2/RDS/ SQL database

Administration of Postgres database servers

Good experience on AWS Schema Migration tool and DMS tools

Deploying, configuring, managing, patching, troubleshooting and optimizing.

Database migrations and upgrades from SQL Server 2008, 2005, 2000 to SQL 2012,2016, 2017 upgrades

Provide technical solutions to issues encountered by new and existing applications in the environment.

Supporting MS SQL databases in Microsoft clustered environments

Implementing operational automation using PowerShell scripting

Ensuring compliance with Database vendor license agreement

Attend high priority service restoration calls and providing technical assistance to application development teams.

Performance Tuning and Optimization, using native monitoring and also with troubleshooting tools like Confio Ignite.

Coordinate with offshore team members and share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Synchronizing and migrating data and database objects across non-production (development, QA, staging, UAT, etc) and production environments.

Azure/SQL migrations

Design and document database architecture (data modelling), including logical and physical layers.

Experience on MongoDB collection and indexes & aggregation framework.

Hands on operational experience like scaling, HA, Monitoring, Security and Backup.

Mongo DB Installation, Configuring and Monitoring Replica sets.

Working with other teams such as BA and Development in resolving the technical issues with respect to application

Configuration and deploy SSIS packages and SSRS reports.

Develop innovation, strategies, processes, and best practices.

Participate in weekly team meetings, planning, estimation, preparation of status reports and other such activities as required

Professional Experience:

Microsoft (Compunnel) Service Reliability Engineer since May 20 – till date

Company : Microsoft

Accountabilities:

Installing, configuring, administrating, and securing SQL Server 2000/2005/2008,2008 R2,2012,2014,2016,2017 and 2019

Deploy the service builds across the services using Azure Ev2 pipelines and sequence manger

Setup and supporting Microsoft Azure services.

Maintain and support Azure Key vaults.

Support F5 devices to rotate the servers to do maintenance.

Deploy and configure Virtual networks, VM’s and configure high availability.

Configure and support high availability solutions in SQL server management instances and Azure databases.

Building Data archival strategy with application teams by writing T-SQL Scripts.

Automating the Infra maintenance tasks, with PowerShell and Python.

Building the database servers based on the FDA, HIPPA and SOX regulations

Deploying the SQL servers in Azure and configuring the hybrid model.

Installing/Troubleshooting Always on / SQL High Availability clusters.

Optimizing, tuning and debugging code for improving batch efficiency with databases including re-indexing, updating statistics, recompiling stored procedures and functions

Expertise in Performance Tuning and Query optimization using native and third-party tools such as Idera’s SQL diagnostic Manager

Setting up SSRS reports and PowerShell reports for easy administration of Databases.

Implementing operational automation using PowerShell scripting

Beaumont Health Database Administrator Sr since Aug 18 – Apr 20

Company : Beaumont Health

Domain : Health Care

Accountabilities:

Installing, configuring, administrating and securing SQL Server 2000/2005/2008,2008 R2,2012,2014,2016 and 2017

Building Data archival strategy with application teams by writing T-SQL Scripts.

Integrating the on-premise environment to cloud.

Create and maintain SSIS packages, SSRS reports and SSAS cubes for OLTP and Data Warehouse environments.

Automating the DBA tasks, with PowerShell and Python.

ETL processing using SSIS packages and its components such as script tasks, control flow tasks, look up transformations, data flow tasks and event handling.

Building the database servers based on the FDA, HIPPA and SOX regulations

Planning, implementing all types of Backup (Full, Differential, Transactional) and Restore Operations

Design and document database architecture (data modelling), including logical and physical layers.

Experience on MongoDB collection and indexes & aggregation framework.

Hands on operational experience like scaling, HA, Monitoring, Security and Backup.

Mongo DB Installation, Configuring and Monitoring Replica sets.

Deploying the SQL servers in Azure and configuring the hybrid model.

Installing/Troubleshooting Always on / SQL High Availability clusters.

Optimizing, tuning and debugging code for improving batch efficiency with databases including re-indexing, updating statistics, recompiling stored procedures and functions

Expertise in Performance Tuning and Query optimization using native and third-party tools such as Idera’s SQL diagnostic Manager

Setting up SSRS reports and PowerShell reports for easy administration of Databases.

Implementing operational automation using PowerShell scripting

Cardinal Health (Wipro) Lead Database Administrator since Apr 16 – Aug 18

Company : Cardinal Health

Domain : Health Care

Accountabilities:

Installing, configuring, administrating and securing SQL Server 2008 R2, 2012,2016 and 2017

Integrating the on-premise environment to cloud.

Migrating the applications from other database services to SQL servers

Building the database servers based on the FDA, HIPPA and SOX regulations

Planning, implementing all types of Backup (Full, Differential, Transactional) and Restore Operations

Providing day-to-day Support and Maintenance of SQL Server databases

Upgrading the applications to cloud (EC2/RDS)

Deploying the SQL servers in Azure/AWS and configuring the hybrid model.

Working on Amazon web services to migrate systems by using DMS (Data migration services)

Installing Always on / SQL HA clusters.

Setting up monitoring by using cloud watch logs (AWS) and Activity log in (Azure)

Building Data archival strategy with application teams.

Optimizing, tuning and debugging code for improving batch efficiency with databases including re-indexing, updating statistics, recompiling stored procedures and functions

Expertise in Performance Tuning and Query optimization using native and third-party tools such as Idera’s SQL diagnostic Manager

Analysing and developing Conceptual, Logical and Physical database models using CA’s Erwin data modeller tool and Microsoft Visio

SQL Server Business Intelligence Development Studio knowledge to create SSIS packages, SSRS reports and SSAS cubes for OLTP and Data Warehouse environments.

Experienced with ETL processing using SSIS packages and its components such as script tasks, control flow tasks, look up transformations, data flow tasks and event handling.

Setting up SSRS reports and PowerShell reports for easy administration of Databases.

Microsoft (Mindtree) Technical Specialist since Jan 13 – Apr 16

Project : Office365 Microsoft online cloud services

Location : Redmond

Accountabilities:

Installing, configuring, administrating and securing SQL Server 2000/2005/2008,2008 R2,2012 and 2014

Configuring replicas.

Resolving data/Configuration issues in Replication.

Planning, implementing all types of Backup (Full, Differential, Transactional) and Restore Operations

Providing day-to-day Support and Maintenance of SQL Server databases

Moving Database from one Server to another by using Backup & Recovery, Export & Import, and Attach & Detach

Deploying the SQL servers in Azure and configuring the hybrid model.

Setting up security polices and crating appropriate logins, roles and application roles

Writing COSMOS big data queries to analyse the business/system trends.

Administrating high availability solutions like Log shipping, Mirroring, Clustering and Replication

Performing Maintenance tasks like rebuilding, reorganizing indexes, update statistics and checking database integrity at regular intervals

Identifying and monitoring Memory usage, CPU utilization, Cache hit, Physical reads counters using performance monitor

Identifying and resolving Blocking and Deadlocking issues by using Activity Monitor, System stored procedures and profiler

Setting up SSRS reports and PowerShell reports for easy administration of Databases.

Configuring and maintaining Repl sets and shard’s for High availability

Cardinal Health (Wipro) Project Engineer since Aug’ 11- Jan13

Project : Cardinal Health

Domain : Health Care

Accountabilities:

Installing, configuring, administrating and securing SQL Server 2000/2005/2008,2008 R2

Worked for AIMS server build.

Administrating databases in SQL Server 7.0/2000/2005/2008 and 2008R2

Migrating databases from SQL Server 7.0 to SQL Server 2008 R2

Scheduling daily maintenance tasks using jobs and maintenance plans

Scheduling and monitoring all maintenance activities including database consistency check, update statistics, and index maintenance through maintenance plans

Managing Logins and Permissions

Identifying and resolving Blocking and Deadlock issues by using Activity Monitor Profiler

Troubleshooting TempDB and Log file issues

Used SQL Profiler for troubleshooting, tuning of SQL Server performance

Good TSQL Scripting

Moving data base using Export, Import wizard, BCP and Bulk Insert operations

Monitoring Log shipping and troubleshooting errors

Experience in SSIS and SSRS.

SunTrust (Infosys) Sr Process Executive Feb’09-Jul’11

Company : SunTrust

Domain : Banking

Accountabilities:

Performed regular Administration activities from Managing system resources, users and database to the fine-tuning level and implemented the project successfully

Install and Configure SQL database 2000, 2005, 2008 and 2008R2 for development and production environment for multiple customers

Worked on Database Maintenance, Backups and Recovery Plans.

Administer MS SQL server by creating user Logins with appropriate roles, granting and denying login privileges, monitor the user accounts, creation of groups, granting database and application roles to users and groups.

Schedule and maintain routine Jobs, Tasks, and Alerts.

Monitor SQL Error Logs/ Schedule tasks/data activity/ eliminate blocking and deadlocks/ user counts and connections/ locks.

Installed, configured and administrated SQL server 2000 and SQL server 2005, 2008.

Constantly checking functionality of the environment and taking necessary action when an alert is thrown from alerting mechanism by taking a prompt action based on its severity and considering the resolution of the issues as most primitive tasks.

Carrying out Installations and up gradations of SQL server Database engine and client tools through all the versions and administrating the same.

Knowledge on Administrating SQL server Mirroring, log shipping and other high availability methodologies.

Dealing with security requirements of SQL Server I.e. Database Access Permissions

Certifications:

Microsoft Certified Professional

Microsoft Azure114X-Azure Fundamentals

Mongo Certified DBA

Academic Credentials

2008 Bachelors in Computer Science

Contact this candidate