| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate GANESH VARMA
Email: EMAIL AVAILABLEPh: PHONE NUMBER AVAILABLESr Oracle DBAHaving over 8+ years of focused experience in IT industry in various domains like media, telecom, financial, retail, healthcare, and manufacturing. Extensive experience in relational database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management. Comprehensive experience as Oracle DBA/Oracle database Engineer; proficient in Oracle 10g/11g/12c/19c Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Tuning Oracle 10g,11g,12c,19c on Unix, AIX, Solaris, and Windows platform. Thorough understanding of the Oracle data dictionary, and have good experience in UNIX administration, Shell scripting. Exceptional team player with impeccable communication and interpersonal skills. Have experience with leading a team of Oracle DBAs and actively coordinated with the end user community.
PROFESSIONAL CERTIFICATION & TRAININGSs Oracle Certified Associate (OCA) - 12c Oracle Cloud Infrastructure Foundations 2021 - Associate Certified Oracle Cloud Data Management Certified 2023 Foundations Associate Oracle Cloud Infrastructure 2023 AI Certified Foundations Associate Received MongoDB training certificate from Mongo DB UniversityOracle DBA Experience Experience as an Oracle DBA (10g, 11g, 12c, 19c) in production and development environment with general purpose transactions, data warehousing and ETL Experience in creating, managing and monitoring highly transactional Oracle Production OLTP and installing and configuring OLTP databases from ground zero. Apply patches, upgrades, and security fixes to Exadata Oracle Databases.
Expertise in Oracle Multitenant CDB/PDB Administrator along with migration from non-CDB to PDB. Good knowledge of UNIX administrator for the Linux, Sun Solaris & AIX
Experience in Logical and Physical design of databases for OLTP and Data Warehouse. Worked in 24x7 production environment and provided day-to-day on-call support. Experience in Oracle 10g, 11g, 12c, 19c installation, upgrades, migration and implemented new features. Expertise in installing, configuring, and maintaining Standalone and RAC databases on various platforms.
Expertise in Oracle database replication, with experience in managing and creating/configuring Oracle Data Guard physical and logical standby databases via Manual and OEM. Experience in performing and testing of switch over and failover activities. Configuration of DG broker between primary and standby. Manage RAC environment for day-to-day database administration and performance tuning. Installing creating new ASM disk group or raw devices for RAC DBs Migrated Non-ASM single instance to ASM RAC instance. Expertise in performance tuning the production database towards optimal performance based on the changes in the database storage structures due to application change requirements. Monitoring and optimizing the performance of the Database through Database Tuning Tuning Applications, Tuning Memory, Tuning Disk Usage, Tuning OS Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TK prof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR and ADDM.
Deep knowledge of Oracle Database internals and exceptional performance tuning skills. Proficiency using Flash-Back Recovery, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM). Expertise in cloning/refresh of non-prod from production using RMAN. Expertise in data pump to perform Full DB, schema, tables refresh via export/import in standalone and RAC. Experience in capacity planning, space management, database upgrades/migration in RAC and standalone. Expert in planning/implementing backup/recovery strategies using RMAN (Netbackup, Commvault and Rubik) and without RMAN. Experience with Storage DAC, SAN , NAS Expertise in installation, configuration, and support of Golden Gate & share plex replication between different versions of Oracle Databases. Conflict detection and resolution in Active-Active replication environments using Oracle Golden Gate and Share plex. Monitoring EXADATA db nodes, cell nodes and disks through 13c OEM, dbcli and cellcli
Created and Migrated databases from non-Exadata to Exadata and Exadata (x.6) to Exadata (x.8).
Implement and manage backups, recovery procedures, and disaster recovery strategies for the Exadata environment.
Optimize database performance by tuning SQL queries, database parameters, and Exadata-specific features.
Collaborate with application teams to design, deploy, and maintain database schemas on Exadata.
Design and implement backup and recovery strategies for Oracle Databases running on Exadata, including full, incremental, and archival backups.
Creating and maintaining logins, synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security features. Expertise in maintaining database security. Monitor security logs and audit trails for suspicious activity and respond to security incidents according to established procedures.
Capable to analyze and perform DB Change requests ensuring 100% database availability. Expertise in PLSQL, Oracle Enterprise Manager (OEM), TOAD, Erwin Expertise in database management automation scripts to include install, config and maintenance jobs using python, and Ansible for configuration management. Supported and worked on Priority 1 SRs with Oracle Support during the Go-Live period. Provided off hours support, as needed, to support product enhancements, data uploads and technical issues. Developed DB provisioning automation tools using Python/shell scripts. Experience in developing and maintaining CI/CD pipelines for database code and schema changes to improve reliability and speed of deployments. Strong troubleshooting, problem solving, analytical and design skills.
Having good knowledge with PL/SQL procedures, triggers and shell scripting. Expertise in handling Very Large Database (VLDB) and OLTP environment. Monitor storage performance metrics and capacity utilization, and plan for expansion or optimization.AWS Oracle RDS & EC2 Experience: Experience on migration strategies for database migration to cloud on AWS Experience on migrating on-premises oracle database to AWS Expertise in implementing clustering and high availability solutions for Oracle databases in AWS Implemented high availability (HA) and disaster recovery (DR) strategies are implemented effectively for Oracle databases in AWS Experience on creating database on RDS and Migrating databases from On-premises to AWS RDS and EC2 and Aurora
Expertise in creating and managing the replication instance and Database Migration Service (DMS) tasks from one DB to other DB also adding tables in DMS tasks from Oracle instance to Postgres SQL and MySQL and Aurora to keep the replication sync between the DB s. Expertise in Performing Day to Day operations in Oracle AWS RDS instances like Full DB, Schemas and tables refresh activities. Expertise in stop and start/restart of RDS instances and adding memory and storage and monitoring the cloud trails for alerts. Good Knowledge on IAM and S3 bucket in AWS Maintained the monitoring and alerting of production and corporate servers using Cloud Watch service.
Postegres, MySQL Experience in installing and managing basic administration on MySQL DB and post egress databases. Having knowledge on MySQL / AWS Aurora databases and exposure to AWS Cloud ecosystem.SKILLS MATRIX :
Database: Oracle (10g, 11g, 12c, 19c), AWS RDS, MySQL, PostgreSQL on Unix, Aix, Solaris, OEL, Exadata and WindowsOperating Systems: Unix, Windows, AIX, OEL, Solaris, Exadata, Dell ServersTools / Utilities: Oracle SQL Developer, TOAD, Erwin, Recovery Manager, Veritas NetBackup for oracle on Solaris and AIX, DB verify, Exp/Imp, expdp/impdp, Server Manager, SQL* Loader, TKPROF, Log Minor, Stat pack, and Oracle Enterprise Manager grid control.Languages: UNIX shell programming, PL/SQL
Cloud: AWS, OCIPROFESSIONAL EXPERIENCECLIENT: Core Logic, USA Feb 2024 Till NowLead Oracle DBACore Logic, Inc. is an Irvine, CA based leading information services provider of financial, property, and consumer information, analytics, and business intelligence. The company analyzes information assets and data to provide clients with analytics and customized data servicesResponsibilities: Collaborated with stakeholders to define migration scope, assess data dependencies, and establish migration priorities. Implemented Cloud-based database solutions, reducing infrastructure costs by 45% percentage and improving scalability. Mainly Oracle Database Administration experience including Oracle Exadata, OracleEnterprise Manager Cloud Control 12c & 13c Release 2 (12.1.0.2), 11gR2,19c RAC
Assessed SCT reports, manual assessment of business logic intricacies to identify potential challenges and optimization opportunities. Ensured that security requirements and compliance standards are met during the migration and reviewed the user access, roles and permissions. Executed Successful migration of large databases, ensuring minimal downtime and data loss while maintaining data integrity. Worked multiple databases like Aurora, Oracle, MSSQL, MYSQL, PostgreSQL Experience in application Support, SQL Loader, Data pump, Data Guard, performing Flashback. Designed and implemented database solutions that reduced query response times, enhancing application performance. Designed and developed load balancing Mongo applications.
Migration Oracle Databases from On-Prem server to Cloud (AWS, OCI) using DevOps Tools like Ansible, Jenkins, and Terraform. Leveraged AWS RDS and EC2 instances to ensure seamless transition and optimal performance of Oracle databases in the cloud environment. Worked on oracle flashback technology Test and promote Quest SHAREPLEX replication tool between different instances for High Availability.
Managing relational databases like MySQL, PostgreSQL, Oracle, SQL Server, and MariaDB in the AWS cloud.
Designed scalable architectures for Oracle databases on AWS, considering future growth and ensuring the ability to accommodate increased workloads as the business expands. High Availability Solutions RAC, Golden Gate, RMAN. Implement and administer Automatic Storage Management (ASM) for managing Oracle database files. Implementation of First Start Fail over (FSFO) in Active Data Guard Configuration. Replication between different version of Oracle Database and across Golden Gate releases. Tracing connections to the Mongo database and monitoring utilization of resources for each process.
Table reorganization & Space Management.
Migration of 12C Databases to 19C. Worked on Cross platform migration using RMAN & Golden gate. Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
Writing Pl/SQL procedures and functions. Writing shell scripts to automate the data loading.
Monitoring the data loading jobs and tuning the Sql queries. Maintain Data Migration Strategy and Playbooks.Environment: Oracle Server 19c,12c,11g, Exadata, Postgres SQL, SQL, PL/SQL, RAC, RHEL7, AIX, OEM, Grid Control, TOAD, Golden Gate, Data Guard, GCP, AWS.Client : Texas Instruments, Dallas ,TX May-2023 to Dec-2023
Role : Sr. Oracle Database Engineer (L3)Responsibilities: Working in 24x7 production environment and provided on-call and day-to-day support. Advanced Backup and Recovery using Oracle s RMAN software; used offline/online for recovery in a production environment and scheduled the backups in OEM and Crontab scripts via NetBackup. Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
Changes were made dynamically whenever possible to fulfill high-availability requirements.
Creating/configure and managing standby databases for fail-over purposes via manual and OEM. Implemented High availability using Golden Gate and share plex Replication. Implanted Bi-directional replication using golden gate and share plex.
Implemented Stream, Golden Gates and share plex for Active-Active Replication between the Datacenter for High Availability. Implementing and maintaining database security (create and maintain users, roles and assign privileges)
Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory, and Operating System kernel parameters. Managed appropriate use of free space within tablespaces, reclaimed space whenever possible and requested to the storage and Unix team for more space and adding the respective new disks to ASM. Performing regular Oracle database maintenance like clearing Flashback, archive logs on various instances Managing data integrity also managing profiles, resources, and password security. As per the User requirement creating and managing the database users, roles, and privileges. Monitored the production Oracle alert logs for database errors to handle DB issues on day-to-day operations to enhance the respective applications smooth run. Monitored system resource availability and responded to system memory and data issues.
Oracle Multitenant CDB/PDB administration along with migration from non-CDB to PDB. Expert with OEM Grid Control. Performed refresh activities by Import/Export like schema, table, full database etc. Performed specific schemas and tables refresh from production to non-production database as per the user requirement. Managing RAC Environment efficiently. Expertise in Installation, Configuration, and support of Golden Gate replication between different versions of Oracle Databases.
Conflict Detection and Resolution in Active-Active Replication Environments Using Oracle Golden Gate replication. Expertise in database management automation scripts to include install, config and maintenance jobs using python, and Ansible for configuration management. Experience Develop and maintain CI/CD pipelines for database code and schema changes to improve reliability and speed of deployments. As a part of post database provisioning, developed scripts in python to check status and insert data. Monitoring EXADATA db nodes, cell nodes and disks through 13c OEM, dbcli and cellcli
Created and Migrated databases from non-Exadata to Exadata and Exadata (x.6) to Exadata (x.8).
implement and manage backups, recovery procedures, and disaster recovery strategies for the Exadata environment.
Optimize database performance by tuning SQL queries, database parameters, and Exadata-specific features.
Apply patches, upgrades, and security fixes to Exadata Oracle Databases.
Collaborate with application teams to design, deploy, and maintain database schemas on Exadata.
Environment: Oracle Server 19c,12c,11g, Exadata, MsSQL, SQL, PL/SQL, RAC, RHEL7, AIX, OEM, Grid Control, TOAD, Golden Gate, Data Guard, OCI, AWS, Sql Developer, Shareplex, SAP Basis, AIX, Solaris, cherwell.Company: Oracle Financial Services Software (OFSS) Feb 2022 to Apr 2023Project 3. Access BankRole : Sr. Database Administrator (L3)Responsibilities: In a Build team Member, we must perform the DB migrations and Upgrades from lower versions to higher version for all environments of an application and handover the Databases to a support engineer team. Perform the GRID and DB Installations of 12c and 19c Oracle versions and expertise in database creations and upgrading the ASM and databases from lower versions to Higher version. Creation and Maintenance of database storage structures such as Tablespace, Data files etc. Creating and managing the Users, roles, Profiles and providing the Privileges. Performed multiple DB migrations from Different Platform s via Data pump expdp/impdp (ex: AIX to OEL and OEL to OEL of different versions) Lead the team in upgrading the database from 11g/12c to 19c with DBUA and manual upgrade methods. Expertise in Installation, Configuration, and support of Golden Gate & share plex replication between different versions of Oracle Databases. Conflict Detection and Resolution in Active-Active Replication Environments Using Oracle Golden Gate and Share plex. Developed scripts in python to automate Oracle Database Provisioning. It includes GRID installation for Oracle RAC Environments Planning and implementing the Backup strategy using RMAN. Configure the scripts to run the backups as archival log backup every hour and incremental backup on daily and full back up on weekly basis. Creating/deploying and maintain the High Availability & failover technologies such as Data Guard and Real Application Clusters to maximize database availability. Oracle Multitenant CDB/PDB administration along with migration from non-CDB to PDB. Configure the data broker to the data guard for failover.Environment: Oracle Server 19c,12c,11g, Exadata, SQL, PL/SQL, RAC, RHEL7, AIX, OEM, Grid Control, TOAD, , Data Guard, OCI, , SQL Developer, AIX, Solaris Cherwell, PlSql Developer.Project 1.BSP Bank & Project 2: Eco Bank
Role: Sr. Database Administrator (L3)Responsibilities: Health check and remediation of oracle Databases for an application called FLEXCUBE, FCCM, FMW and OBIEE. As in a remediation team member the primary focus is verify the database as per the Oracle Standards and remediate the DB as per the Oracle recommendation standards and handover to the Operations DB team. Managing and supporting Oracle databases for the above-mentioned applications. Managing table spaces, data files, redo logs, tables, and its segments and Partioned tables. Managing data integrity also managing profiles, resources, and password security Physical Database Backup and recovery (Hot and Cold Backups) and Logical Backup Database Links, Creating and Managing Tablespaces and Datafiles, Creating and Rebuilding Indexes, Managing Database Security. Performance information and monitoring/interpreting alert log and trace files Use of SQL diagnostic and tuning tools like AWR/ADDM Reports Troubleshooting and maintenance of Oracle Database Performed refresh activities by Import/Export like schema, table, full database etc. Setup of Standby database for faster disaster recovery and Data Guard setup. Load balancing, databases/schema/table re-organization for faster performance.Environment: Oracle Server 19c,12c,11g, Exadata, SQL, PL/SQL, RAC, RHEL7, AIX, OEM, Grid Control, TOAD, Data Guard, OCI, , Sql Developer, AIX, Solaris Cherwell, PlSql Developer.Company: HCL Technologies - Oct 2016 to Jan 2022Project 4. Unilever Project 3 : Total EnergiesRole : Lead DBA (Shared resource of multiple Projects)Responsibilities: As a Lead DBA Handling multiple Build Projects from different clients. Handling and conducting daily basis calls to the team members and clearing the technical droughts and assigning the DB projects to the Team member. Created and Migrated databases from non-Exadata to Exadata (Exadata (x.6) to Exadata (x.8)) Monitoring EXADATA db nodes, cell nodes and disks through 13c OEM, dbcli and cellcli
Created and Migrated databases from non-Exadata to Exadata and Exadata (x.6) to Exadata (x.8).
implement and manage backups, recovery procedures, and disaster recovery strategies for the Exadata environment.
Optimize database performance by tuning SQL queries, database parameters, and Exadata-specific features.
Apply patches, upgrades, and security fixes to Exadata Oracle Databases.
Collaborate with application teams to design, deploy, and maintain database schemas on Exadata.
Perform the GRID and DB Installations of 12c and 19c Oracle versions and expertise in database creations and upgrading the ASM and databases from lower versions to Higher version. Creation and Maintenance of database storage structures such as Tablespace, Data files etc. Creating and managing the Users, roles, Profiles and providing the Privileges. Performed multiple DB migrations from Different Platform s via Data pump expdp/impdp (ex: AIX to OEL and OEL to OEL of different versions) Planning and implementing the Backup strategy using RMAN. Configure the scripts to run the backups as archival log backup every hour and incremental backup on daily and full back up on weekly basis. Experience in upgrading databases from 11g/12c to 19c using DBUA, Manual and Auto Upgrade methods. Handover of fully tested and operational DB to users. Experience in Installation and Maintenance of RAC (using SRVCTL/CRSCTL) with ASM As per the requirement and need installed various versions of Databases. Exporting and Importing database backups using Export & Import and Data pump utilities. Experience in Cloning production databases using RMAN. Setup and maintain all database backups for all production Oracle servers. This includes using native Rman backup. Expertise in Installation, Configuration, and support of Golden Gate replication between different versions of Oracle Databases. Conflict Detection and Resolution in Active-Active Replication Environments Using Oracle Golden Gate. Developed scripts in python to automate Oracle Database Provisioning. It includes GRID installation for Oracle RAC Environments Monitor all production Oracle Databases for disk usage to plan future disk space needs per database. Checking of Log files (Alert) and Trace files Involved in applying the CPU, PSU and RU patches in non-prod and prod environments. Modified the existing shell scripts to work as per current requirement of the application. Created indexes, constraints, triggers, synonyms in different schemas. Performed modifications on existing data objects as per change request and maintained it. Maintaining Archive logs and their spaces for routine administration, alert and trace monitoring Participated in whenever there is a requirement of applying Patches using Opatch utility and upgradation is required on Prod or Pre-Prod Instances. Configure physical & logical standby databases using Oracle Data Guard with manual method and OEM. Experience in performing and testing of switch over and failover Activities. Configuration of DG broker between Primary and standby.Environment: Oracle Server 19c,12c,11g, Exadata, SQL, PL/SQL, RAC, RHEL7, AIX, OEM, Grid Control, TOAD, Data Guard, SQL Developer, NetBackup, Solaris, Service Now.Project 2 : BrightstarRole: Oracle Database Administrator (L2)Responsibilities: Participate in 24x7 on-call rotation for production databases and attend meetings on upcoming and ongoing projects. Managing, Supporting, and troubleshooting the Oracle production and non-production Databases. Managing table spaces, data files, redo logs, tables and its segments and Managing data integrity also managing profiles, resources and password security of Users, Privileges and Roles. Physical Database Backup and recovery (Hot and Cold Backups) and Logical Backup Performing the table re-org and rebuild of indexes and stats gathering of database. Performance information and monitoring/interpreting alert log and trace files Use of SQL diagnostic and tuning tools like AWR/ADDM Reports Performed refresh activities by Import/Export like schema, table, full database etc. and full Db refresh from prod to non-prod using RMAN. Implement the automated Hot Backup scripts for the Daily full backup created in Crontab and OEM via Commvault tool. Enforced need of regular data purging processes from production, design, and development to deployment.
Setup of Standby database for faster disaster recovery and Data Guard setup. Load balancing, databases/schema/table re-organization for faster performance. Experience in Performance tuning, Application tuning and Query Optimization using Oracle supported tools such as EXPLAIN PLAN, TKPROF, AUTOTRACE, etc. Monitored and tuned long running jobs by working with the application and development team and analyzing objects, creating, or rebuilding indexes. Using SQL TRACE, Explain plan. Generated AWR reports on Oracle 11g database and analyzed the reports for Oracle wait events, time- consuming SQL queries, tablespace growth, and database growth. Managing basic administration on MySQL DB and progress. Experience on creating database on RDS and Migrating databases from On-premises to AWS RDS and EC2. Expertise in Installation, Configuration, and support of Golden Gate & share plex replication between different versions of Oracle Databases. Conflict Detection and Resolution in Active-Active Replication Environments Using Oracle Golden Gate and Share plex. Expertise in creating and managing the replication instance and Database migration Service (DMS) tasks from one DB to other DB also adding tables in DMS tasks from oracle instance to Postgres SQL and MySQL to keep the replication sync between the DB s. Expertise in Performing Day to Day operations in Oracle AWS RDS instances like Full DB, Schemas and tables refresh Activities. Expertise in Stop and start / restart of RDS instances and adding memory and storage and monitoring the cloud trails for alerts. Good Knowledge on IAM and S3 bucket in AWS Worked on Creating Identity Access Management policies (IAM) with Audit Team for user identities and for security breach. Created S3 buckets in the AWS environment to store files, sometimes which are required to serve static content for a web application.
Created snapshots to take backups of the volumes and ssimages to store launch configurations of the EC2 instances. Maintained the monitoring and alerting of production and corporate servers using Cloud Watch service.
Experience on migration strategies for database migration to cloud on AWS Experience on migrating on-premises oracle database to Azure cloud and AWS Expertise in implementing clustering and high availability solutions for Oracle databases in Azure Implemented high availability (HA) and disaster recovery (DR) strategies are implemented effectively for Oracle databases in AWS. Working on the Incidents and Requests and Changes as per the tickets raised by application team on a Service Now tool. Created schedule jobs, alerts, activity logs, error logs to capture any possible errors. Evaluated database performance and performed maintenance duties such as tuning, backup, restoration, and disaster recovery in SQL. Supported 247 production support and solved all kinds of critical problems. Gather client project requirements.Environment: Oracle Server 19c,12c,11g,10g, SQL, PL/SQL, RAC, RHEL7, AIX, OEM, Grid Control, TOAD, Data Guard, AWS, SQL Developer, Commvault Replication, Commvault Backup, SAP Basis, Solaris, SolarWinds, Service Now, Control-m.Project 1 : National Broadcasting Channel Universal (NBCU)Role : Oracle Database Administrator (L1)Responsibilities: Working in 24x7 production environment and provided on-call and day-to-day support. Implement the automated Hot Backup scripts for the Daily full backup created in Crontab and OEM via NetBackup tool. Maintained standby databases, in both local and remote locations, for fail-over purposes.
Replicated to a disaster recovery site for increased server manageability and availability. Implementing and maintaining database security (create and maintain users, roles and assign privileges) Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory, and Operating System kernel parameters. Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed. Enforce best practices in all areas of database administrator and architecture. Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues.
Expert with OEM Event and Job Managers, Change Manager, Diagnostics & tuning Packs. Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
Propagation from primary to standby via automated scripts, and sometimes uses standby databases to immediately restore primary database. Installation of RAC and Managing RAC Environment efficiently Proficient in RAC Performance Tuning.
Create and maintain materialized views. Monitored system resource availability and responded to system memory and data issues.
Enforced need of regular data purging processes from production, design, and development to deployment.
Performed refresh activities by Import/Export like schema, table, full database etc. Performed Full DB refresh from Production to Non-productions using RMAN. Creating and maintaining logins, synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security features. Working on the Incidents and Requests and Changes as per the tickets raised by application team on a Service Now tool. Installed and Configured Ms SQL Server 2008 R2/2012 Servers in Development, Staging, and Production Environments. Created databases, logins, roles, and granted appropriate permissions for Ms SQL Created schedule jobs, alerts, activity logs, error logs to capture any possible errors. Evaluated database performance and performed maintenance duties such as tuning, backup, restoration, and disaster recovery in SQL Supported 247 production support and solved all kinds of critical problems. Gather client project requirements.Environment: Environment: Oracle Server 19c,12c,11g,10g, SQL, PL/SQL, RAC, RHEL7, AIX, OEM, Grid Control, TOAD, Data Guard, AWS, SQL Developer, NetBackup, SAP Basis, Solaris, , Service Now, Control-m, M360.Company: Sura Technologies,India Jan 2016 to Sep 2016Role : Database AdministrationResponsibilities: As a Database Administrator Trainee at Sura Technologies, I have got an opportunity to gain hands-on experience and valuable skills in database administration under the guidance of experienced professionals.
Throughout the co-op program, I have been exposed to various aspects of database management, performance optimization, and troubleshooting within a real-world business environment. Assisting in the maintenance of database documentation and learning how to support the environment, configuring and troubleshooting workstation database access setup, creating documentation of every aspect of DBMS. providing database support during hardware configuration, loading database software on test environments; and monitoring new installations to ensure optimal performance. Generated and Executed the Script to Create the Oracle Database Objects. Utilized database migration techniques, resolved multiple delaying errors, and achieved target 35% earlier than scheduled.Environment: SQL, PL/SQL, RHEL7, Backup s, SQL developer, PLSQL developerEDUCATION Bachelor of Technology (B-TECH) in Computer Science & EngineeringSreyas Institute of Engineering and Technology, JNTUH University, India |
