Gopi Ushakiran
Hyderabad
Summary
Having Around 8 years of Experience in IT. 8 years worked as MS sql database administrator and Azure Administrator on various versions on both on premise and Azure cloud in Bangalore, India
Overview
8
8
years of professional experience
Work History
CLOUD APPLICATION ADMINISTRATOR
CampusEAI India Pvt. Ltd
04.2023 - Current
- Providing production support as Cloud Service Engineer
- Providing Oracle Database and MS SQL Support to ensure 24
- 7 Support
- Install, configure, and troubleshoot Oracle 19c/12c/11G R2 databases
- Provision and Support Databases on AWS RDS cloud environment
- Migrating the on-premise databases to AWS Cloud Environment
- Backup the Database using the RMAN and Cloning the Database Using the RMAN from PROD to NON-PROD
- Appling the quarterly psu patching on database
- Responsible for daily space monitoring and adding data files and resizing Tablespaces
- Monitoring the databases using APM tool like Datadog,OEM tool.
SENIOR DATABASE ADMINISTRATOR
Harman connected services
Bangalore
05.2017 - 05.2020
- Providing DBA Support to ensure 24
- 7 Support
- Performing Daily health Check of database through Predefined Scripts and email alerts
- Performed database reorganization, schema reorganization using EXPDP/IMPDP
- Generated database health check reports(AWR and ADDM) Planning and implementing various database maintenance activities like table defragmentation, index rebuilding and gathering statistics
- Providing resolution to users regarding any database related Issues
- Creating Database links and Materialized Views to access the data from remote databases
- Managing and creating Primary Objects (Tables, Views and Indexes) & Creation of additional table space and other database objects with appropriate space allocation
- Creating users, assigning Privileges, Roles, Profiles and Quotas as per the requirements
- Checking for invalid objects and compiling them, Corrective action is taken for any of the problems before the start of business hours
- Involved in performance tuning
- Monitoring Cluster log, Alert log, trace files of database
- Monitoring Scheduled tasks, Disk usage, Database Health and Availability.
SOFTWARE ENGINEER
Xchanging Solution Limited
Bangalore
04.2016 - 04.2017
- Creation and Maintenance of Oracle Databases as per the requirement
- Export / Import of Tables, schemas from production to development databases
- Creating and granting the necessary roles, privileges and profiles to the users
- Working on Database patching
- Creating Tablespaces and adding datafiles
- Creating Database link as per Application requirement
- Creation of schema with quota maintenance Creation Partition tables to increase the performance Create and configure ASM Database
- Preparing the Work Instructions and SOP’s
- Participation in Installation, and configuration of DataGuard, Standby technologies in mission criti-cal systems and configuration of Switchover’s and Failovers with Physical standby database
- Checking the Datafiles Consistency using DBverify utility
- Red log and control file management
- Backup and recovery using RMAN, scripts for various database activities, troubleshooting etc
- Checking alert logs on regular basis for resolving problems
- Successfully provided 24
- 7 supports for the Databases.
Education
Masters in Technology - embedded systems
Jawaharlal Nehru Technological University
Bachelor of Technology - Electrical, Electronics and Communications Engineering
Jawaharlal Nehru Technological University
Skills
- Strong experience in MS SQL Database Administration
- Experience managing, deploying, and configuring Azure VMSS
- Experience with troubleshooting and resolving Azure service-related issues
- Create new Microsoft SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering
- Configure and maintain SQL Security controls
- Manage database backup and recovery, as well as disaster recovery planning, in coordination with the IT manager and System Engineer
- Create, change, and improve SQL Server Agent tasks and maintenance plans
- Proactively monitoring SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible
- Troubleshoot application sluggishness and poor performance
- In charge of database migrations and server updates
- Strong database migration experience
- Expertise and experience monitoring Azure workspaces, VM's, VM drives, Memory etc
- Responsible for maintaining existing databases with high-availability solutions, replication,
backup, restore, encryption, and disaster recovery solutions - Configure & Monitor Performance/Storage/Memory alerts on all Production Azure Servers to
ensure high availability of data - Experience in DB upgrade and migration
- Maintenance of the Oracle RAC
- Strong knowledge in backup stratages(RMAN,EXPDP and) and cloning
- Appling the patches of standalone database and RAC environment
- Monitoring, troubleshooting and performance issues on oracle databases
- Oracle database migration from on premise to cloud AWS EC2 and RDS instance
- Experience in AWS oracle RDS instance
- Worked on Devops tools like Aws ECS, ansible, github, Jenkins, shell scripting
Accomplishments
- Contributed to good customer service.
- Best complements from multiple Ellucian clients.
Personal Information
Nationality: India
Languages
English
First Language
English
Proficient (C2)
C2
Timeline
CLOUD APPLICATION ADMINISTRATOR
CampusEAI India Pvt. Ltd
04.2023 - Current
SENIOR DATABASE ADMINISTRATOR
Harman connected services
05.2017 - 05.2020
SOFTWARE ENGINEER
Xchanging Solution Limited
04.2016 - 04.2017
Masters in Technology - embedded systems
Jawaharlal Nehru Technological University
Bachelor of Technology - Electrical, Electronics and Communications Engineering
Jawaharlal Nehru Technological University
Similar Profiles
Ravish MehtaRavish Mehta
Associate Vice President - Client Success at CampusEAI India Pvt LtdAssociate Vice President - Client Success at CampusEAI India Pvt Ltd
MOHAMMED FAIZMOHAMMED FAIZ
Technical Project Manager at Infinite Computer Solutions Pvt LtdTechnical Project Manager at Infinite Computer Solutions Pvt Ltd
Chethan RChethan R
Senior Associate at Zomato india pvt ltd & grofers india pvt ltdSenior Associate at Zomato india pvt ltd & grofers india pvt ltd