Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Ramanjaneyulu Telaprolu

Philadelphia

Summary

Certified Azure Database Administrator with over 10 years of experience managing SQL Server production Databases,Postgres and MongoDB. Highly skilled at database maintenance, performance tuning and Optimizations; On-Prem to Cloud Migration, High Availability and Disaster Recovery Solutions I ma a passionate contributor to team success with records of empowering teams. A self-starter who is always motivated to learn, grow, and stay current.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Senior Database Administrator

Fivebelow
Philadelphia
07.2021 - Current
  • Have Over 10 years of experience in Administering SQL Server databases in production
    environments, ranging from 2012 to 2019 versions. Install and configure SQL Server 2016 database in standalone/cluster environment with availability groups. T-SQL scripts, RedGate
  • Azure Cloud professional with strong experience in migrating resources to Azure, Azure
    Administration, Azure Infrastructure Operations, and end to end Project Management.
    Produced high-standard database solutions to meet stability, reliability. Bash and PowerShell
  • Create and deploy ETL packages to achieve various task using Microsoft Integrations Services (SSIS), and Azure Data factor (ADF). Automate Backups, refreshes, maintenance Jobs, Bulk inserts data migration, data extraction, transformation and loading from multiple data sources
  • Effectively managed and reduced cost by effectively monitoring databases elastic pool. Configuring Azure Site Recovery for DR and Azure back-up on-premises/Azure Environment. Lead design, architecture, and deploy of solutions in Azure platform. Transact-SQL (T-SQL)
  • Migrate SQL Server Databases to Microsoft Azure hosted DBs, Managed instances. Configured High Availability Solution; Always-On, Log Shipping, migration, patching, troubleshooting, optimization, maintenance (modelling, High-Availability (HA) and Disaster Recovery (DR)).
  • Performed Database Migration from On-Premises SQL environment to Azure Database in cloud Manage database security and users in Active Directory, ensure Database Integrity and setup maintenance plans via SQL Agent. Stored Procedures,
  • Automated and reduce workflow with the help of store procedures, scripts, Redgate and Microsoft Integration services, that runs daily to reorganize, rebuild, update statistics, Backup.
  • Configured Transparent Data Encryption using AES256 Algorithm to make sure that all databases are fully encrypted and secure from Hackers and Malicious users,
  • Managed Servers and database level Security by Implementing the Triple As (AAA); Authentication, Authorization and Auditing. All User are Authenticated through the various security protocols, and are Authorize to resources, and audit all activities. Stored Procedures
  • Migrated VMs, SQL Databases from On-Prem to AZURE, configure Geo-replication for High availability, Azure Site Recover and manage database on Elastic pools and Manage instances.
  • Setup and manage Always-On High Availability for HA/DR, Log shipping to automate and Synchronize Backups to secondary server for Disaster recovery as an addition security for Mission Critical databases in our environment. Linux Administration, and Window’s Server.
  • Create Data Models for new and modernized legacy Databases, implement database design following best practices to maximize performance and reduce data redundancy.
  • Maintain Database Security and Consistency in oracle and SQL Server by running database validation Checks with RMAN, consistency checks with DBCC and DMVs proactively
  • Installation,migration,designing,backup, recovery, scripting and performance tuning in development,test and production MongoDb databases.
  • Hands on position responsible for configuring, integrating, and maintaining, Development, Staging and Production PostgreSQL databases.
  • Responsible for all backup, recovery, and upgrading of PostgreSQL databases.


SQL Database Administrator

XPO Logistics
Greenwich
02.2021 - 06.2021
  • Installed and upgrade SQL Server 2012 or greater and, applied security fixes. SQL Server
    Profiler, Query Store and Database Engine Tuning Advisor (DTA) for performance. Virtualization
  • Expertise in driving deployment of customers’ workloads into Azure and increasing satisfaction of by providing deployment guidance and support. Performed Database Migration from On-Premises SQL environment to Azure Database
  • Create centralized management server for simultaneous queries and master server to push SQL Server Agent jobs to each server. Organize DBA meetings to brainstorm strategies
  • Set up user profiles and access levels for database segment to protect essential data, Creating, granting, and monitoring user access rights and privileges through roles and profiles.
  • Minimized downtime by optimizing and monitoring High Availability for SQL Server, applying Database Mirroring, Log Shipping, Traditional Failover Clustering, and Always-On.
  • Implemented backup strategy following company SLA; physical cold and hot, and logical using
  • SQL Server and Oracle Production Database Administration, Support and Monitoring for
    proactive problem resolution. Involved in planning, setup, and implementation of new servers across entire enterprise.
  • Database migration using Exp/Imp/Data pumps, monitored performance tuning using Oracle enterprise manager OEM Console, SQL Developer, Explain Plan, AWR, ADRCI, ADDM, DRA,
  • Installing; configuring and administrating RedHat, Oracle Linux and other Linux Operating Systems, created groups and grant privileges. Microsoft SQL Server, Stored Procedures
  • Support and monitor over 150 development, TEST and PROD databases by proactively resolving issues and maintaining servers. Created and implemented database designs and data models, plan and implement security measures to safeguard business data. System Administration
  • Set up and controlled user profiles and access levels for each database segment to protect essential data, maintained technical and functional specifications to document database intentions and requirements. Backup & Recovery Systems, Unix, Technical Support
  • Performed physical, logical full, incremental, archival backups, compress, and Encrypt RMAN backups.
  • Took the backups using veeam tool on all On-Prem SQL servers

SQL Database Administrator

SALESFORCE
Sanfrancisco
07.2018 - 01.2021
  • 24X7 production support with a rotation basis.
  • Resolving the tickets assigned based on the priority as per the SLA.
  • Installation & Configuration of SQL Server 2005, 2008, 2012 and 2014 on remote systems
  • Daily Checking the health of the Databases Application wise.
  • Daily monitoring the DB space Management issues and allocating the required space to the databases.
  • Monitoring the temp db full and transactional log full issues.
  • Applying patches to test/dev/productions servers.
  • Creation of SQL Logins, Roles and Authentication Modes.
  • Configuring High Availability techniques like Log shipping, Database Mirroring, SQL Server Failover Clustering, Always On Availability Group.
  • Upgradation /Migration of SQL Server 2005 & 2012 databases to SQL Server 2008,2012& 2014
  • Maintaining the Security of the Database, assigning responsibilities as part of Security Monitoring SQL Server performance by finding deadlocks and blocking
  • Designing and supporting high availability SQL Server solutions that include Log shipping, Database Mirroring , Replication, & clustering.
  • Maintaining the Security of the Database and giving permission to the Users on demand.
  • Designing backup strategy for production and test environments
  • Developing disaster recovery procedures for production servers
  • Designing Database maintenance plan for database consistency and optimization
  • Troubleshooting system issues, monitoring scheduled jobs and proactively tuning the queries on jobs.
  • Monitoring the status of Maintenance jobs – schedule to run daily and on weekends.
  • Rebuilding the indexes at regular intervals for the better performance.

SQL Server Database Administrator

State Street
Boston
01.2016 - 06.2018
  • Provided 24x7 On-Call Support to Customers.
  • Ensure all instances and databases are up and Running.
  • Using Storage Properly and Analysis of database growth and recommendations for additional capacity (hardware, memory etc) and Space Management (Data file and Log files).
  • Schedule and monitoring maintain routine Jobs, Tasks, and Alerts with mail configuration.
  • Identifying and resolving Index Fragmentation and index-statistics issues.
  • Proficiency in Query optimization and improve Performance Tuning using indexes, SQL Profiler, Execution Plan, DBCC and DMVs.
  • Perform query tuning on long running queries.
  • Able to configure Performance Counters to test new application and the analyze them.
  • Different SQL Login's and users with right's are created on the database Security for Develops group, Tester's group, Production Support group and DBA's, Administrator groups (On production, Development, testing and UAT server)
  • Resolving Space management issues like Database and log file Space issues.
  • Remove any unneeded space from the transaction log and data files by shrinking the databases.
  • Responsible for Migrating databases from SQL server 2005 to SQL Server 2008.
  • Configure and administrating high availability Log-shipping and Database Mirroring.
  • Implementing and managing all replication topology to across multiple sites.
  • Identifying and resolving Blocking and Deadlocking issues by using Performance Monitor, Activity Monitor, Profiler, System Stored Procedures and DMVs
  • Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance test.

Education

Master of Science - Computing Software Technology

The Robert Gordon University
Aberdeen,UK
01.2012

Bachelor of Technology - Computer Science And Engineering

JNTU
Hyderabad,TS
05.2007

Skills

  • Installed SQL in standalone/Clustered
  • Azure AD connect & Federation services
  • Database Migration to Microsoft Azure
  • Log Shipping, Always-On High Availability
  • Performance Monitoring & Tuning
  • Azure Site/Recovery (ASR), Service Vault
  • Performance Monitoring & Tuning
  • Hands on experience on Postgres Databases Administration
  • Hands on Experience on MongoDB Databases administration
  • Azure, Network, Storage Disaster Recovery
  • Managed Instances, Elastic Pools, Azure VM
  • Configured (TDE) to Encrypt All databases
  • Managed Azure compute and services
  • ETL: SSIS, Azure Data Factory (ADF) SSRS

Certification

  • Microsoft Certified: Microsoft Azure Fundmentls AZ-900

Timeline

Senior Database Administrator

Fivebelow
07.2021 - Current

SQL Database Administrator

XPO Logistics
02.2021 - 06.2021

SQL Database Administrator

SALESFORCE
07.2018 - 01.2021

SQL Server Database Administrator

State Street
01.2016 - 06.2018

Master of Science - Computing Software Technology

The Robert Gordon University

Bachelor of Technology - Computer Science And Engineering

JNTU

Similar Profiles

CREATE PROFILE
Ramanjaneyulu Telaprolu