Oracle DBA with over 12 years of information technology experience. Solid understanding and experience in Oracle technologies in 10g, 11g, 12c, 18C, 19C & 21c including RAC, ASM, Data guard and Goldengate. Install, tune, maintain and monitor Oracle database, products, and services on both Production and Development; including, but not limited to, capacity planning, database performance tuning, backup and recovery, and change/configuration management. Perform Installation, Patching, Upgrade, Migration, Cloning, troubleshoot issues/errors/Incidents, Collaborate with Oracle Support for bugs & issues resolutions and personal research. Experience to work with various Oracle features like Flash-Back Recovery, Data pump, RMAN, ASM, ASH, AWR, ADDM, ASMM, Automatic Undo management and Recycle Bin to accomplish my work. Experience in database migration, cloning and replication using different tools like RMAN, Goldengate, Data pump, AWS DMS, AWS SCT, SSMS, SSDT and Oracle SQL Loader. Design and plan the best database backup and recovery strategies and implementation. Experience on backup and restore Oracle databases using RMAN, SSMS and Data pump utility. Installation. Configuration, Upgrade and performance tuning of Oracle RAC, Data guard and ASM for High Availability and disaster recovery. Configure TDE for database security. High experience on Oracle GoldenGate for data replication and database migration. Tuning SQL statements using SQL tuning advisor, Explain Plan, SQL Trace, TKPROF and STATSPACK. Knowledge to maintain WebLogic server, installation, upgrade, patching, troubleshooting and deployments. Experience in Installing, configuring, administration and maintenance of mission critical client databases in SQL server 2008, 2008R2, 2012, 2014, 2016, 2017 and 2019 versions. Extensive experience upgrading SQL Server (In place Up and Side by side Up grade) based on application compatibility and fixing the orphan users. experience on configuring and maintaining SQL Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index rebuild, index reorganize based on fragmentation. Strong experience on identifying and troubleshooting database health, integrity checks and fixing them. Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security. Deploy and configure various AWS RDS instances and security group. Worked and managed multiple AWS RDS instances such as Aurora, Oracle, MSSQL, MySQL, and PostgreSQL. Migrate Oracle databases to AWS RDS using AWS DMS and Oracle data pump utility. Defined AWS Security Groups which acted as virtual firewalls that controlled the traffic, allowed reaching one or more AWS EC2 and RDS instances. Hands on experience in encrypting data using AWS Key Management Service (KMS). Worked tools like Ansible, chef and Puppet for automation. Significant Knowledge of scripting skills in bash/ksh, PowerShell, Python, Perl. Significant skills in project management methodologies like Agile, Kanban, Jira, Confluence and DevOps. Significant knowledge of containerized application such as Docker and Kubernetes. Deploy and manage database in the containerized application Docker and Kubernetes. Significant knowledge of managing and build Kubernetes cluster on cloud in EKS, AKS, GKE and OKE. Significant knowledge on code version control tool such as GIT, GITLAB and AWS S3 Bucket migrating on-premises workloads to Oracle Cloud Infrastructure. Participated in disaster recovery planning and testing for OCI environments. Conducted performance tuning and capacity planning to optimize OCI resources. Monitored OCI environments, performed troubleshooting, and resolved incidents promptly. Collaborated with cross-functional teams to identify and address infrastructure-related issues. Implemented security best practices to ensure the confidentiality and integrity of data on OCI. Managed and optimized OCI resources to ensure cost-efficiency while meeting performance requirements. Implemented and managed Oracle Cloud services such as Compute, Storage, Networking, and Identity and Access Management.
Experienced with SQL Server database management, ensuring optimal performance and reliability. Utilizes strong skills in performance tuning, data backup, and recovery to enhance database efficiency. Track record of implementing effective security protocols and maintaining high data integrity.
Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, UNIX & LINUX, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL Plus, SQL, Loader, OEM, TOAD 10.0, EC2, S3, RDS, ELB, EBS, VPC, Auto Scaling, Cloud Formation, Cloud Watch, Code Deploy, IAM, Route 53, SES, SNS, SQS, Cloud Trail
Environment: Oracle 11.1.0.4, 10.2.0.3, 9i, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL
Plus, SQL, Loader, OEM, TOAD 10.0, EC2, S3, RDS, ELB, EBS, VPC, Auto Scaling, Cloud Formation, Cloud Watch, Code Deploy, IAM, Route 53, SES, SNS, SQS, Cloud Trail
Environment: Oracle 10g/11g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM