Senior Database Administrator (APEX/DB Automation/Erwin Modeling)

Gejits infotech Inc - Austin, TX

Full-time - Senior

Austin, TX

About the position

The Senior Database Administrator (APEX/DB Automation/Erwin Modeling) at Gejits Infotech Inc is responsible for managing and optimizing database solutions for a direct state client in Austin, Texas. This remote position requires extensive experience in database administration, automation, and performance tuning, ensuring data integrity and security across production and non-production environments. The role involves collaboration with application development teams to enhance database solutions and support various business initiatives.

Responsibilities

• Design, develop, maintain, and improve database solutions for the TIERS applications portfolio.
• Work closely with application development teams and business stakeholders to enhance the TIERS applications portfolio and implement new solutions.
• Build databases and applications using web platform technologies including Java/J2EE, SOAP/REST web services, Spring, JPA, jQuery, AngularJS, IBM WebSphere, Oracle, PostgreSQL, and more.
• Perform advanced logical database administration, performance monitoring, and tuning, providing database-related support to application development teams.
• Utilize Agile development practices to participate in backlog grooming and user story development.
• Design, develop, build, and test databases to support new program and business requests, enhancing scalability and stability of applications.
• Provide application and database operations triage support to troubleshoot and resolve issues in production, development, and test environments, including on-call support as required.
• Develop and modify existing Linux shell scripts for daily tasks and provide process documentation.
• Design and develop Enterprise CI/CD workflow for DB automation using automation orchestrators like Jenkins.
• Advanced expertise in developing and managing SQL and PL/SQL code.
• Hands-on experience implementing Oracle APEX tool set.

Requirements

• Minimum of 10 years of experience in database administration.
• Experience implementing, administering, managing, and monitoring application databases in production and non-production environments.
• Advanced knowledge and expertise in developing and optimizing Oracle SQL and PL/SQL code.
• Experience with DB automation to align Enterprise CI/CD workflows and familiarity with automation orchestrators such as Jenkins.
• Hands-on experience with APEX development.
• Experience leading complex initiatives for performance tuning improvements and advising developers on tuning options.
• Experience supporting cross-functional development teams to optimize application/query performance.
• In-depth knowledge of Oracle internal views, built-in functions, and architecture for data analysis and query support.
• Proven ability to analyze and resolve complex issues in development and production databases using Oracle 11/19c.
• Advanced knowledge in monitoring, troubleshooting, and fine-tuning SQL and PL/SQL on Oracle databases in Solaris/Linux environments.
• Experience using Oracle SQL Developer and Erwin Modeling tool for data modeling.

Nice-to-haves

• Experience with Agile methodology in large development projects.
• Knowledge of EIR Accessibility standards and assistive technologies.

Benefits

• Remote work opportunity within Texas.
• Long-term contract duration.