Senior Oracle PL/SQL Developer in Liverpool, NY at Raymour & Flanigan

Date Posted: 11/1/2018

Job Snapshot

Job Description

Lead Database Developer
Syracuse, NY

Overview
In more than 60 years as an established, family-owned company, Raymour and Flanigan has grown into the largest furniture retailer in the Northeast with more than 100 showrooms in seven states, and we are continually expanding our territory. We have a strong foundation of experienced IT professionals with expertise in harnessing and maximizing organizational processes and their associated information to solve a wide variety of complex business needs.

The sustained growth and strength of Raymour and Flanigan requires us to continually Raise the Bar in the search for motivated and driven people to join our team. To those candidates selected, we offer stable employment, a strong compensation and benefits package, and a high-energy work environment. More importantly, we provide opportunities to learn and grow, and our end objective is to build a team of highly skilled software professionals who can support business needs and develop into qualified professionals we may consider for future roles in the Raymour and Flanigan management and executive teams.

Position Overview
Raymour & Flanigan's Application Development Team is looking for someone who is a positive influence and can provide technical leadership, expertise and guidance in an effort to continue the team's role of excellence. The person is an expert in the Oracle database development technology and will help with solution architecture and code design decisions. If you are a driven individual who is seeking challenges, then this is the position for you.

Essential Functions and Responsibilities
* Coordinate with business analysts, developers, and management in the design, architecture, and modification of current and development of new features and applications.
* Lead the technical design, development, testing and implementation of standard development procedures and techniques that support the requirements defined by users and analysts. Ensure that standards for database performance, availability and security are being met.
* Translate and document customer requirements, recommend system solutions, and formulate detailed specifications from which enterprise applications are developed.
* Implement solutions following the Software Development Lifecycle (SLDC), including requirements analysis, design, specifications, development, change management, testing and deployment activities
* Lead and participate in the conceptual phases of identifying and solving business problems and initiatives
* Explores, examines and interprets large volumes of data in various forms and recommends additional sources and methods for improvements.
* Work with business departmental teams to help define and document business requirements for new metrics and reports.
* Conduct code reviews on time and ensure adherence to best practices and development standards
* Delegate tasks, follow-up on deliverables, detect and report slippage
* Design, develop, and maintain applications, reports and data structures needed for line of business applications in an Oracle environment.
* Provide full technical documentation of analysis, design, development, and testing as well as any user documentation as required.

Required Skills and Experience
* Eight (8) years of relevant experience with Oracle database application development working on large scale applications; data warehouse experience is a plus.
* Ability to read, understand and translate complex and highly detailed user requirements into accurate application specifications; ability to research and initiate new technology, develop own learning strategy and applying/adapting new knowledge to different/changing situations; ability to lead team efforts and teach others new skills through demonstrated written and verbal competence in presenting ideas and concepts.
* Commanding knowledge and experience writing advanced SQL queries, PL/SQL stored procedures, functions & packages
* Thorough understanding of relational databases
* Ability to document concise design, development, and testing processes for assigned projects
* Ability to help create and map business needs/application requirements to technical solutions
* Good understanding of data modeling and data processing techniques
* Exceptional analytical and debugging skills
* Excellent communication and documentation skills
* Must be a team player and be able to communicate well with the IT team and stakeholders
* Proficiency using TOAD or equivalent developer tools
* Experience using source control applications such as Perforce
* UNIX experience

Helpful Skills and Experience
* Experience with OLTP and Big Data/Warehouse approaches, integration, and implementation
* Data Warehouse design and development, SSIS, and SSRS experience is a plus
* Willing to "cross-train" between Oracle and SQL Server application development technologies.
* Java, Perl programming, and Microsoft SQL/T-SQL experience

Benefits
At Raymour & Flanigan, we recognize and appreciate all of our team members' hard work and dedication. We pride ourselves on being a long term, privately held company that takes care of its associates by recognizing each individual's potential and investing in their future success!
Raymour & Flanigan provides a full range of comprehensive benefit programs to help you achieve your wellness and financial goals which include:
* Health Insurance (Up to 80% of premium paid) and Prescription Drug Coverage
* Dental and Vision Coverage
* Company paid Life Insurance
* Company paid Short-term Disability
* 401(k) Retirement Plan w/ Company Match & Profit Sharing
* Voluntary Life and Long-term Disability Insurance
* Flexible Spending Account
* Employee Assistance Program
Other Great Benefits:
* Weekly Pay
* Paid Vacation and Holidays
* Training and Development
* Tuition Reimbursement Program
* Generous Merchandise Discount

Raymour & Flanigan proudly supports a drug free and smoke free work environment.

Raymour & Flanigan is an Equal Employment Opportunity employer that does not discriminate against any associate or applicant on the basis of race, creed, color, religion, sex (including pregnancy), age, national origin, physical or mental disability, sexual orientation, marital or familial status, genetic information or other basis protected by law.