| Oracle Database Administrator - Atlanta, GA (HYBRID mostly remote, LOCAL) - USC & GC only at Atlanta, Georgia, USA |
| Email: [email protected] |
| From: Deepshikha Dixit, DRK America LLC [email protected] Reply to: [email protected] Hi, Hope you are doing great!! Please let me know your interest in the below role- Database Administrator: III Atlanta, GA ( HYBRID mostly remote, LOCAL) 12+ months Visa: USC and GC Video Interviews (Must currently be in Atlanta to be submitted) The role involves delivering operational support for Oracle 19c databases within an environment encompassing Oracle RAC, Oracle Restart, ASM, Multitenancy, Data Guard, Goldengate, and Oracle Enterprise Manager. This position will play a critical role in ensuring our Oracle database systems' availability, reliability, and performance. This Oracle DBA will work closely with cross-functional teams to troubleshoot and resolve database-related issues, implement changes, and optimize database performance to support the organization's operational needs. Key Responsibilities: Administration and Maintenance: Install, upgrade, and patch Oracle Grid Infrastructure, Oracle database enterprise and standard editions, and related components Perform database backups, restores, and recoveries using RMAN and Commvault Data Protection for Oracle. Manage database space using ASM, ACFS, and filesystems. Migrate databases using Data Pump, RMAN duplicate, transportable tablespaces, and PDB clone. Implement development changes to Oracle schema objects. Participate in on-call rotation to provide 24/7 operational support. Ensure compliance with database policies and procedures. Perform routine maintenance tasks, including reorgs and index rebuilds. Security and Vulnerability Management: Manage database security and access controls. Regularly access security vulnerability reports and apply patches or mitigations in accordance with vendor recommendations. Apply Oracle quarterly release updates Resiliency Participate in DR testing and execution. Configure and maintain standby database with Data Guard. Configure and maintain logical standby using Golden Gate. Utilize flashback technology to return a database and/or database objects to previous state or run queries that return past data. Ensure database availability, reliability, and resiliency in accordance with MAA guidelines. Capacity Planning: Monitor database resource usage. Perform capacity planning at the instance, operating system, and storage levels. Performance Tuning: Monitor database performance using OEM and SQL scripts. Proactively identify and address database performance bottlenecks and inefficiencies by implementing SQL, database, and OS tuning techniques. Implement best practices to enhance database efficiency. Troubleshooting and Issue Resolution: Troubleshoot service problems. Root cause analysis. Provide solutions and definitive corrective measures. Automation: Maintain and enhance existing UNIX shell scripts and SQL scripts. Continuously explore opportunities for process improvement and automation. Documentation: Create and maintain database documentation, including database standards, best practices, procedures, and implementation plans. Skills Required: 7 plus years plus years with hands-on experience as an Oracle DBA. Strong experience with Oracle RAC Databases on ASM in an enterprise environment. Experience configuring and managing standby databases using Data Guard and Active Data Guard. Proficient in Oracle management tools, such as OEM, Data Guard Broker, RMAN, Data Pump, AWR, and SQL Tuning Advisor. Practical experience working with Multitenant databases. Strong UNIX scripting. Competence with AIX and/or Linux operating systems. Strong work ethic and self -motivator. Preferred: A strong understanding of Maximum Availability Architecture (MAA) with expertise in Gold and Platinum architectures. Practical experience in configuring and overseeing replication using GoldenGate. Experience with Commvault Data Protection. Experience with RMAN catalog in an HA environment. Experience supporting Oracle databases in AWS or OCI. Education: 4-yr College Degree preferably in Information Systems, Computer Science, Engineering, or related field. THanks & Regards, Deepshikha Dixit | Lead HR DRK America LLC |Naperville, IL 60563 [email protected] Keywords: green card Georgia Illinois |
| [email protected] View all |
| Sat Dec 09 00:02:00 UTC 2023 |