Kforce

Senior PL/SQL Developer

3+ months agoNew York, NY

Responsibilities

Kforce has a client in search of a Senior PL/SQL Developer - Cost Accounting.Summary:The Senior PL/SQL Developer is a key member of the Data Warehouse and Cost Accounting Module team that is responsible for implementing and delivering business intelligence and reporting solutions. The Senior PL/SQL Developer is primarily responsible for creating and maintaining relational and dimensional data structures within the data warehouse and operational data store to meet functional requirements and optimize performance. The PL/SQL development team will create procedures and materialized views joining many sources for reporting, based on the technical documents provided.Key Tasks:

  • Write PL/SQL and SQL Queries
  • Optimize performance
  • Troubleshoot Database
  • Be part of application development team and assist in all stages of development from conception to development to testing to optimization
  • Design and develop clinical application database layer
  • The Database Developer will evaluate, implement and support database infrastructure/technologies and development processes to support database development and corporate products and services
  • Responsible for oversight and development of OLTP and DSS database architecture, design, programming and implementation for database projects
  • Builds, enhances and maintains a Master Data Management process with a focus on enhancement and enrichment of the data
  • Build a data governance module which provides the ability for insight and data corrections/enhancements
Request for Statement of Work:
  • Design of specialized data structures for the purposes of data consumption by a public facing website and/or business intelligence data visualization
  • Data modeling and corporate-level data management experience preferred
  • Create and maintain document to support developed applications


Skills

  • Bachelor's degree in Information Technology, Computer Science, Mathematics or equivalent is required
  • 8+ years of IT experience (preferably healthcare)
  • 5+ years of Oracle Database experience
  • 3-5 years of SQL/ETL and/or database administration, including of data architecture management
  • Strong Oracle Database Development skills
  • Knowledge of InterSystems Cache' is a plus
  • Builds and maintains complex PL/SQL, T-SQL Scripts, UNIX Shell scripts, Stored Procedures, Triggers, etc.
  • Performance tune of large clinical databases, employing various techniques such as schema bound views, database partitioning, and ETL/Query optimization
  • Extensive knowledge of data architectures related to large database implementations geared towards OLTP
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Kforce is a professional staffing services firm offering Technology and Finance & Accounting jobs with top employers nationwide. We specialize in providing contract, contract-to-hire and direct placement opportunities, with over 50 years of experience in the staffing industry. Kforce offers many consultants comprehensive benefits depending on employment status, including medical, dental, 401(K), life insurance and disability. Our vision is to be "the firm most respected by those we serve."