Oracle Pl/sql Developer With Edb Postgresql @ DC Consultants

Job Description

Skill: oracle pl / sql , exception handling , database development , database , postgresql , pl / pgsql , linux , data structures , oracle , windows; Exp: 4-10 years; We are looking for experienced database developers proficient in Oracle PL/SQL and Postgres PL/pgSQL to build high-performing, scalable, enterprise-grade Data Modeling solutions for the Healthcare and Life Sciences industry. You will be part of a talented software development team that builds products, platform and solutions in Agile methodology. Responsibilities Identify and analyze user requirements and then propose the Design, development and implementation approach for a combination of Oracle and Postgres based applications. Develop PL/pgSQL solutions based on best practices of data warehouse solution architecture Use effectively the logical and physical Data Modeling using normalizing Techniques Debug faulty/performance issue related code and propose solutions based on Query Optimizer, Execution Plans, Profiler. AWR, other Performance tuning techniques Prioritize, assign and execute tasks throughout the development sprints Solutions to be developed for both Windows and Linux platforms Write well-designed, efficient, secure code Review, test and debug team members code Document development phases Ensure our applications are secure and up-to-date Requirements 4-10 years of database development experience Proven hands-on Software Development experience using Oracle and/or Postgres PL/pgSQL Hands on experience in designing and developing database solutions using Oracle and/or Postgres PL/pgSQL Good knowledge on logical and physical Data Modeling using normalizing Techniques, Oracle in memory database. Good knowledge of AWR, Query Optimizer, Execution Plans, Profiler, SQL tuning advisor Working experience in development of ETL process, DB Design and Data Structures Profound insight of Oracle Segment, Extent, data block and oracle database parameters Effectively made use of Table Partitioning, Collections, Analytical functions, Bulk Collections, Context, Exception handling Knowledge of Oracle Tablespace level, network level encryption Working experience in Healthcare Technology and knowledge of Argus Safety is a big plus Knowledge of Strong problem-solving skills and willingness to roll up ones sleeves to get the job done Excellent written and verbal communication skills Degree in Computer Science, Engineering or equivalent preferred

Employement Category:

Employement Type: Full time
Industry: Medical / Healthcare
Role Category: General / Other Software
Functional Area: Not Applicable
Role/Responsibilies: Oracle Pl/sql Developer With Edb Postgresql

+ View Contact

Keyskills:   exception handling database development database postgresql linux data structures oracle windows oracle pl sql pl pgsql