Janakiram Bhupati
Summary
Certified Azure Database Administrator with over 9 years of experience managing SQL Server production Databases to Orchestrate work flows for system development life circle and maintenance which ensure smooth business operations, reliant architecture and highly scalable elastic applications. Highly skilled at database maintenance, performance tuning and Optimizations; On-Prem to Cloud Migration, High Availability and Disaster Recovery Solutions and 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
12
12
years of professional experience
1
1
Certification
5
5
Languages
Work History
Azure SQL Database Administrator
Adp- Automated Data Processing
06.2014 - Current
- Have Over 9 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 - Handling More than 100+ Production servers in different environments 30+ Dev and QA servers and 5500+ Databases
- 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 AWS EC2 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, 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 SQL Server by running database validation Checks, consistency checks with DBCC and DMVs proactively
Database Administrator
Webadda Technologies
01.2012 - 05.2014
- Installed and upgrade SQL Server 2008, 2012 or greater and, applied security fixes. SQL Server Profiler, Query Store and Database Engine Tuning Advisor (DTA) for performance. Virtualization
- 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
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- 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 Database Administration, Support and Monitoring for
proactive problem resolution. Involved in planning, setup, and implementation of new servers across entire enterprise. - Installing; configuring and administrating 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, Technical Support
Education
Master of Computer Applications - Computer And Information Sciences
OSmania University
Hyderabad, TG04.2011
Skills
- Installed SQL in standalone/Clustered
- Azure AD connect & Federation services
- Database Migration to AWS EC2
- Log Shipping, Always-On High Availability
- Performance Monitoring & Tuning
- Azure Site/Recovery (ASR), Service Vault
- Performance Monitoring & Tuning
- 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: Azure Database Administrator Associate DP-300
- Microsoft Certified: MCTS 70-432: MS SQL Server @ 2008, Implementation and Maintenance.
REWARDS & RECOGNIZATIONS
▪ Awarded as Stellar Performer of Month for Cpay to Vista Migration (Jan-2018).
▪ Awarded as Star Performer of Month for transition of On-premises to cloud (Oct-2017)
▪ Awarded as Star Performer of Month for Business Continuity Planning (BCP) & Disaster Recovery Planning (DR) (Dec 2016).
▪ Best Employee – Awarded Best Employee rewarded with Incentive in 2015 at ADP.
▪ ADP Recognition Award for Application Migration, ADP Club Member for 2015.
Timeline
Azure SQL Database Administrator
Adp- Automated Data Processing
06.2014 - Current
Database Administrator
Webadda Technologies
01.2012 - 05.2014
Master of Computer Applications - Computer And Information Sciences
OSmania University
Similar Profiles
Catherine MarquezCatherine Marquez
Payroll Input, CSR, Amendment Coordinator at Adp- Automated Data ProcessingPayroll Input, CSR, Amendment Coordinator at Adp- Automated Data Processing
Divya RaoDivya Rao
District Manager at ADP (Automated Data Processing)District Manager at ADP (Automated Data Processing)
Cody ShanleyCody Shanley
Inside Sales Representative at ADP- Automated Data ProcessingInside Sales Representative at ADP- Automated Data Processing
Stacy KienleStacy Kienle
Technical Product Specialist II at ADP- Automated Data ProcessingTechnical Product Specialist II at ADP- Automated Data Processing
Sajinesh TKSajinesh TK
Azure SQL Database Administrator at Atos Pvt LtdAzure SQL Database Administrator at Atos Pvt Ltd