Manager Data
Resume:
Ram Donga – MS SQL / Mongo DBA
On-Premise & Cloud (AWS/Azure)
Mobile : 425-***-**** E-mail : *********@*****.***
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