Essential Job Functions

• Provides more complex design documents and translates into component-level designs to accelerate development. Assists in developing strategy, design and data gathering approaches.
• Provides high level design expertise in support of development team efforts to provide flexible reusable components to increase cost effectiveness. Analyzes, designs and reviews design of applications and suites of applications to ensure that customer specifications are satisfied.
• Assists in overseeing relationships between application architects and development teams to ensure that product development and implementation are coordinated. Works with product development teams and senior designers in developing design requirements that are accurate and relevant to company needs. Recommends alternative courses of action as appropriate to meet requirement needs.
• Reviews and analyzes gathered information in technical research; evaluates tools and methodologies to ensure that designs adhere to current industry, client and company standards. Develops and provides technical documentation, participates and oversees test-plan development, integration and deployment.
• Assists in overseeing business process work sessions, project meetings and joint applications development sessions to ensure that product design decisions are communicated to departmental personnel.
• Functions as a domain expert and works closely with software developers to explain the application design, and coordinates activities between the two functions to enhance product quality and efficiency. Participates in cost analysis studies to determine feasibility of approaches.
• Utilizes experience in development methodologies, coding documentation, testing methodology and industry standards to define and develop project requirements, functional specifications and detailed design of application solutions for clients.
• Provides leadership and work guidance to less experienced personnel. Guides the work of less experienced developers to create, maintain and communicate details of application designs to ensure that designs are according to specifications.
• May provides technical consulting on complex projects. Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations, operating time and form of desired results.

Basic Qualifications

• Bachelor's degree or equivalent combination of education and experience
• Bachelor's degree in software engineering, computer science or related field preferred
• Six or more years of experience in develop, test and implement database programs using Oracle tools.
• Strong experience in Oracle development, PL/SQL and data modeling.
• At least 4 years of data transformation experience
• Experience with Oracle Version 11g and 12c
• Experience in Oracle version 12c new features.
• Extensive experience with oracle functions, procedures, triggers & packages.
• Experience in performance tuning: SQL and PL/SQL programs
• Provide ongoing support to frontend developers and DBAs.
• Fix problems related to database performance and provide corrective measures.
• Extensive experience in PL/SQL tables, Indexes, DDL, DML, Writing complex SQL statements, job scheduling etc.
• Experience in PowerShell for job automation
• Extensive experience in unit testing and integration testing
• Experience in writing load testing PL/SQL scripts.
• Experience in Oracle DataLoader
• Experience working with database connecters like Mulesoft , Salesforce etc.
• Experience in documenting Oracle programs.

Other Qualifications

• Oracle Developer certification is a plus
• Knowledge of Microsoft .Net and Java is a plus.
• Experience working on Oracle Cloud is a big plus.
• Experience of Salesforce is a big plus.

Work Environment

• Office environment
• Other US locations may be considered
• Remote work may be considered