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
Want more jobs like this?
Get jobs in New York, NY delivered to your inbox every week.
- 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 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."