Senior Oracle Database Administrator

Role Title: Senior Oracle DBA

Location: Austin, TX (Onsite)

Duration: Full-time with Apexon

Required Skills :

Oracle DB, SQL, data modeling, SQL tuning, 12+ years of experience in implementing, administering, managing, and monitoring databases in production and non-production environments, ensuring data integrity and security.

• 12+ years of advanced knowledge in developing and optimizing Oracle SQL and PL/SQL code.
• Proven ability to lead large, complex initiatives and performance tuning improvements, including using Explain Plan for query optimization.
• Strong knowledge of Oracle internal views, functions, and architecture, including tablespace consolidation and index analysis.
• Experience with Oracle 11/19c databases on Solaris/Linux systems for troubleshooting and optimization.
• Proficiency in Oracle SQL Developer and Erwin Modeling tools for creating data models, including star schemas.
• Experience using Agile methodologies in large development projects.

Preferred Skills :

• Able to work with ErWin tool for reverse engineering and create subject areas.
• Able to work on AWS and its technology.

Responsibilities :

• Design, develop, and maintain database solutions and support applications developers.
• Collaborate with development teams and stakeholders to enhance the applications and implement new solutions.
• Perform advanced database administration tasks, including performance monitoring, tuning, and providing database-related support.
• Participate in Agile practices such as backlog grooming and user story development.
• Provide production, development, and test environment support, including on-call support for troubleshooting.
• Develop and modify Linux shell scripts to support day-to-day database administration tasks.
• Advanced expertise in Oracle SQL and PL/SQL development and tuning.
• Able to work with ErWin tool for reverse engineering and create subject areas.
• Able to work on AWS and its technology.
• Must have good knowledge of PostgreSQL