31 Aug
Oracle PL/SQL Developer (Must have SQL Server Development)
Kansas, Manhattan 00000 Manhattan USA

Vacancy expired!

Ideal candidate would have healthcare experienceCandidates must have experience with SQL Server Development experienceThe 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. 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. PL/SQL development team will create procedures and materialized views joining many sources for reporting, based on the technical documents provided. 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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 applications3. Qualifications / Required 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 OLTPAbout TEKsystems:We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.TEKsystems is a equal opportunity employer and will consider all applications without regard to race, genetic information, sex, age, color, religion, national origin, veteran status, disability or any other characteristic protected by law.

Vacancy expired!


Report job