Logo
ESR Healthcare

Lead plsql architect Tampa FL ref

ESR Healthcare, Tampa, Florida, us, 33646


Experience level:

Mid-senior

Experience required:

6 Years

Education level:

Bachelor’s degree

Job function:

Information Technology

Industry:

Financial Services

Compensation:

View salary

Total position:

1

Relocation assistance:

No

Visa:

Only US citizens and Greencard holders

Job DescriptionThe Lead Application Support Engineer role will be responsible for Level 3 technical support and development of applications within the IT Solutions Delivery department for the Repository and Derivatives Services (RDS) area. As part of the Level 3 application support team, contribute to project initiatives for APAC, EMEA, or US regions for our Global Trade Repository (GTR) and Securities Financing Transaction Regulation (SFTR) systems. This is a highly technical position with an emphasis on providing expert consultative services to development teams.

Responsibilities include:

Contributing to technology-specific best practices & standards.

Contributing to success criteria from design through deployment, including reliability, cost-effectiveness, performance, data integrity, maintainability, reuse, extensibility, usability, and scalability.

Providing expertise on significant application components, vendor products, programming languages, databases, and operating systems.

Executing on the plan by building components, testing, configuring, tuning, and deploying solutions.

Qualifications

Partner with development teams to provide input during the design and development phases of the SDLC.

Identify and implement efficiencies and improvements to standard processes and procedures such as automation through scripting, programming, etc.

Comply with Change Management procedures to facilitate pre-production/production deployment plans, including any vendor software upgrades.

Collaborate during Root Cause Analysis with any follow-ups that would require application changes to prevent an issue from reoccurring.

Provide application coverage for alerts in a timely fashion with business impact analysis.

Review and keep live documentation up to date to provide our support colleagues with the most up-to-date documentation.

Facilitate information for any ongoing audits.

Review, understand, and comprehend Business Continuity plans.

Translate business requirements into software solutions.

Participate in thorough code reviews with a goal of illustrating quality engineering practices and to produce the highest quality code possible.

Requirements

Bachelor’s Degree in Business Administration or Bachelor of Science.

6+ years' experience in application development and system analysis.

Strong SQL/PLSQL Developer Skills (ORACLE): Execution plans, understanding indices, partitions, parallel execution, and strong debugging skills.

Very strong Python foundation: web frameworks, event-driven programming, and proficient in debugging techniques.

Experience in developing and using AWS cloud stack (S3, SQS, Redshift, etc.) is a big plus.

Experience with and understanding Data Warehouse implementations for Business Reporting (Snowflake) is a big plus.

Knowledge of Java/JEE and coding best practices.

Working coding skills in Web Services, Spring, Soap/Rest APIs, and JavaScript Frameworks for modern web applications.

Comfortable in operating in a Unix environment and has experience with shell scripting (bash, ksh, sh, etc.).

Understanding DevOps techniques and practices like Continuous Integration, Continuous Deployment, Test Automation, Build Automation, and Test Driven Development (TDD) and tools like Jenkins, CloudBees, Git Repositories, etc.

Understanding the need for Code Coverage and Code Quality.

Experience in Agile Scrum methodology.

#J-18808-Ljbffr