LTI Mindtree - Atlanta, GA
posted 3 months ago
LTIMindtree is seeking an experienced Oracle DBA with a strong background in Dataguard and Goldengate, particularly in cloud environments, specifically AWS. The primary focus of this role will be managing Oracle RDS databases on AWS, which includes creating new databases and implementing changes or enhancements to existing application content. The ideal candidate will have a minimum of 5 years of experience in building and supporting Oracle RDBMS, particularly with Real Application Clusters (RAC) and Automatic Storage Management (ASM) across versions 11, 12, and 19. The role requires proficiency in using various command line and GUI tools to access and manage Oracle databases, both on-premise and in the AWS Cloud. Familiarity with Oracle data movement tools such as SQL Loader and DataPump is essential. The candidate should also be skilled in using RMAN for database backup and restore operations, and have experience in creating, running, and debugging KORN shell scripts for automation purposes. Additionally, the DBA will assist developers in deploying DDL structural changes to database objects and will be responsible for macro-level database performance analysis and diagnosis. This includes understanding wait events and performance metrics through tools like Oracle Enterprise Manager and AWS CloudWatch. The candidate should also have a background in SQL query performance tuning, utilizing tools like EXPLAIN PLAN or SQLT TRCA to optimize database performance.