Oracle Developer

Oxford Global Resources; Milwaukee (WI); On-site; USD 76,000 - 99,000; Full time

Benefits offered by this job

Supplemental medical

Dental

Vision

Life insurance

Disability

401(k) Retirement Savings Plan

Paid holidays

Paid sick leave

Job summary

Oxford Global Resources in Milwaukee, WI seeks an experienced Oracle Database Developer to design, maintain and optimize Oracle databases and code packages. You will be fluent in SQL, PL/SQL, DML and DDL and apply database development best practices to support web applications, tableau reports and maintain data integrity.

Responsibilities include database management, data modeling, data warehousing, archiving and collaboration with developers and analysts within SCRUM/SDLC.

Qualifications

• Fluent in SQL, PL/SQL, DML and DDL with database development best practices.
• Experience with Oracle 12c databases and reporting to executive management.
• Data warehousing, archiving, and modeling experience.
• Ability to document conceptual and technical designs.
• Strong written communication and ability to convey data relationships.

Responsibilities

• Database design, support, and security oversight.
• Data management, maintenance, and data integrity.
• Agile SCRUM/SDLC development.
• Collaborate with developers, scrum masters, and analysts on designs and JIRA documentation.
• Develop SQL packages and stored procedures to support apps/reports.
• Evaluate architecture and maintain DB objects for various applications/reports.
• Design physical structures and optimize applications with statistical structures.
• Participate in design discussions for new and existing applications.

Skills

Oracle SQL

PL/SQL

DML

DDL

Data integrity

Tools

Oracle 12c

JIRA

Job description

Summary

Existing applications are based on Oracle Exadata. Expertise to include a skilled Database Developer with demonstrated knowledge and solid experience in or associated with designing and maintaining databases and code packages. Successful candidates will be fluent in SQL, PL/SQL, DML and DDL and be able to apply database development best practices to support various web based applications, tableau reports and maintain data integrity.

Job Experience

• Experience and proficiency with Oracle SQL and PL SQL against an Oracle 12c database
• Experience producing reports and interacting with executive management
• Experience in data architecture and enterprise architecture
• Experience working in Data Warehousing, Archiving, and Modeling
• Experience creating documentation to support conceptual and technical design work
• Ability to apply the Business Process Model of an organization
• Strong organizational skills and ability to present relationships between data
• Strong written communication skills are necessary

Project Details

• Database management, design, support and security
• Data management, maintenance and integrity
• Agile Development utilizing SCRUM and SDLC
• Coordinate with various developers, scrum masters and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications in JIRA
• Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application / report developers
• Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database
• Evaluate all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects for various application / report components
• Design and implement various structures for all physical objects and recommend changes on applications through efficient statistical structures
• Perform research on all data processing functions and participate in design discussions related to the maintenance and enhancement of existing and newly created applications

Hourly Rate

55-72

Equal Employment Opportunity Statement

Oxford is an Equal Employment Opportunity Employer. All qualified applications will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Oxford will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.

Benefits

• Supplemental medical (we do not offer major medical)
• Dental
• Vision
• Life
• Disability benefit plans
• 401(k) Retirement Savings Plan
• Paid holidays based on eligibility
• Paid sick leave for applicable jurisdiction

Accommodation and Assistance

Oxford is committed to working with and providing reasonable accommodation to individuals with physical and mental disabilities. If you need special assistance or an accommodation while seeking employment, please email [e-mail]. We will make a determination on your request for reasonable accommodation on a case-by-case basis.