Senior Oracle DBA

International Logic Systems, Inc. (ILS) is seeking an experienced Senior Oracle Database Administrator (DBA) to manage, optimize, and ensure the security and efficiency of our Oracle databases. The ideal candidate will have extensive experience with the latest Oracle database versions and tools, certified expertise in Oracle Database Administration, and a commitment to maintaining high availability and optimal performance of our database systems. This role involves managing complex database environments, implementing backup and recovery strategies, and supporting development and production environments.

• Database Administration: Oversee the installation, configuration, maintenance, and upgrades of Oracle databases (latest versions) on various operating systems.
• Performance Tuning: Utilize tools like AWR, ADDM, and SQL tuning to monitor and enhance database performance and optimize SQL queries.
• Backup and Recovery: Implement and maintain robust backup and recovery strategies using RMAN and Oracle Data Pump to ensure data integrity and availability.
• High Availability and Disaster Recovery: Configure and manage Oracle Data Guard, RAC, and other high availability solutions to ensure minimal downtime.
• Security Management: Ensure database security in compliance with industry standards; manage user access, roles, and privileges.
• Database Monitoring: Use Oracle Enterprise Manager and other monitoring tools to proactively identify and resolve database issues.
• Database Development Support: Assist developers with database design, efficient SQL coding, and data loading processes.
• Automation and Scripting: Develop and maintain automation scripts for routine database maintenance tasks using Shell scripting or PL/SQL.
• Documentation: Maintain accurate documentation for database configurations, processes, and changes.
• Incident Management: Quickly troubleshoot and resolve complex database issues, ensuring minimal impact on production.

• Experience: Minimum of 10 years of experience as an Oracle DBA, with expertise in managing Oracle 12c, 19c, and newer versions. Experience with SQL Server or DB2 is a plus.
• Certification: Current Oracle Database Administration certification (e.g., Oracle Certified Professional [OCP] on Oracle Database 19c or 21c).
• Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.

Technical Skills:

• Proficient in Oracle tools such as Oracle SQL*Loader, SQL Developer, Oracle Data Pump, RMAN, Oracle Grid Infrastructure (ASM), and Oracle Enterprise Manager (OEM 13c or higher).
• Experience with Oracle RAC, Data Guard, and ASM for high availability.
• Strong understanding of database security, backup, and recovery best practices.
• Proficiency in scripting languages like Shell and PL/SQL.
• Performance Tuning: Advanced knowledge of performance tuning methodologies using tools like STATSPACK, AWR, ADDM, and TKPROF.
• Analytical Skills: Excellent problem-solving skills and ability to perform root cause analysis for performance or system issues.
• Communication Skills: Strong communication skills for working with cross-functional teams and documenting technical processes.