· Senior Oracle DBA with 13+ years of experience in Oracle Database Administration, specializing in Oracle RAC, Data Guard, Oracle Golden Gate, Exadata, PostgreSQL and MySQLenvironments.
· Managing Oracle Databases on AWS on EC2 and RDS services.
· Provision and Support Databases on AWS RDS cloud environment.
· Migrating databases to AWS Cloud Environment
· Designed, implemented, and administered Oracle GoldenGate replication environments supporting real-time data integration, disaster recovery, and reporting solutions.
· Configured and managed GoldenGate Classic Capture, Integrated Capture, Classic Replicat, Integrated Replicat, and Coordinated Replicat processes across large-scale production environments.
· Experience in OLTP and Data Warehousing, on-premises and in-cloud environments.
· Special interest and experience in AWS cloud infrastructure database migrations, Postgresql and converting existing ORACLE and MS SQL Server databases to PostgreSQL, MySQL and Aurora.
· Experienced in database conversion from Oracle and SQL Server to PostgreSQL and MySQL.
· Experience in Bash, Perl, Python scripting on Linux
· Experience with newer databases and key-value servers such as MySQL, Cassandra, MongoDB and PostgreSQL
· Good hands-on experience in EXADATA DATABASE MACHINE Storage cell administration maintenance tasks by using cellcli dcli utilities
· Good Experience in Applying Latest Bundle Patches to EXADATA
· Created scripts in Python which Integrated with DASHBOARD API’s to control instance operations.
· Experience with deploying configuration management and CI/CD services such as (Ansible, Jenkins, Docker, JIRA)
· Worked extensively on Oracle 19c, 12c, 11g, 10g versions.
· Installation and configuration of Oracle Enterprise Manager Cloud Control 13c
· Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
· Experience in installation, configuration and administration of Oracle 19c,12c,11g RAC, Oracle 10g RAC, Standby Databases (Active DataGuard) for High Availability, Disaster Recovery and Reporting purpose on operating systems UNIX( Sun Solaris, HP-UX, IBM AIX), LINUX (RedHat, OEL).
· Worked as a team member to provide 24x7 on call production database support.
· Hands-on experience in Oracle 19c, 12c and 11g RAC implementation & administration.
· Hands-on experience with RAC Clusterware configuration and patching, RAC Backup and Recovery.
· Expertise in Hot/Cold Backups and Cloning of Databases.
· Proficient in using Flashback Technology, Log Miner, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM).
· Expertise in database space management, memory tuning, and application tuning.
· Expertise in troubleshooting and performance tuning.
· Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
· Expertise in performing database refreshes using Export and Import utilities (exp/imp) at all level. Performed the same using Data Pump Export and Import utilities (expdp/impdp) in 19c &12c versions.
· Hands-on experience in Grid control, Streams, and Golden Gate.
· Used Cron jobs to automate many DBA tasks.
· Proficient in raising Service Request (SR) with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.
· Extensively used Oracle Enterprise Manager (OEM) to do the daily tasks regarding performance and maintenance.
· Good experience in Patching and Upgradation.
· Expertise in upgrading Oracle development and production databases from 19c,12c and 11g.
· Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM to improve the performance.
· Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck. Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments.
· Create database maintenance plans, including updating statistics, re indexing, structure modifications, Capacity plans, and index analysis.
· Hands-on experience in implementing enterprise databases on enterprise storage solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS).
· Experience in database cloning with RMAN and patch management.
· Hands-on experience in capacity planning.
· Performed point-in-time recovery whenever needed.
· Excellent communication and analytical skills.
TECHNICAL SKILLS:
· Operating Systems: Sun Solaris, HP UX, AIX, Linux (RedHat & OEL (Oracle Enterprise)), Windows 2000, XP.
· Automation: Ansible, Python, Unix Shell scripting, SQL, PL/SQL, SVN, Git, Docker.
· Database: Oracle 19c,12c and 11g , Postgresql 9.5/9.6, MySql 5.6/5.7, Aurora, AWS, EC2 & RDS
· Tuning Tools: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPAK, AWR, ADDM
· Protocols: FTP, SFTP, Ssh, Telnet, TCP/IP, Putty
· Languages: SQL, PL/SQL, C, C++, JAVA, VB, UNIX Shell Scripting
· Tools: and Utilities: RMAN, Import / Export, DataPump, SQL*Loader, ASM, TOAD
CERTIFICATIONS
· Oracle Autonomous Database Cloud 2019 Certified Specialist.
· AWS Certified Solutions Architect-Associate,
ORGANIZATIONS:
· Deloitte Consulting USI - India 08/2023 to 08/2024
· Optum Global Solutions – India 01/2020 to 06/2023
· JMR InfoTech – India 10/2017 to 12/2019
· Aspire Systems – India 02/2013 to 09/2017
Regards,
Chandu. A
Mail: Chandu.A@Amistadlabs.com
Gmail: AforAkkineni@gmail.com
Phone: +1 780-628-0860
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/sureshotjobs/CA%2BRonb-DA%2BmDgfYeRU7cEBOCA_uSpW%2B4te6mc9uuNT-ymf_QvQ%40mail.gmail.com.
