*Hi* *Please go through the below position and if you feel comfortable, then please send me your updated resume*
*Role: Senior DB2 DB Developer* *Interview: Phone and Skype* *Duration: 12+months * *Location: Denver, CO* This Senior DB2 DB Developer will be developing a backend database for the new clinical app. *Day to Day:* -They will be working on modeling a physical data model on a DB2 DB. -They will work on a 3 tier application and work with the middle tier team -They will be doing physical database modeling and DBA -Responsible for developing back end - database - new clinical application -Middle Tier - provisioning an object and initial relational model -Take the model and optimize it for the db2 database -Adding necessary storage modeling complement, partitioning, indexing, auditing, archiving -Responsible to deliver database code to ensure that it’s working optimally for transactional clinical system *2 critical aspects to have:* -Need to have pretty extensive exp w/physical data modeling -DBA exp with database -What is best way to create database code on db2 -How to optimize for high volume process -Self start and learned to lead team on those decisions -Provides expertise in data replication out of transactional db2 system into other systems -IBM infosphere change data capture product - highly beneficial -Db2 -IBM change data capture (CDC) product -Working on oracle system that will be connected to transactional system -Oracle database coding and optimization and physical modeling -Knowledge of high volume transactional, modern, three tier systems is key -IMDG - In memory data grid - experience is extremely beneficial - that is what the transactional system will be connected to -Knowledge of scrum and agile process to deliver agile cadence -Knowledge of healthcare data - very beneficial to model correctly Sr. DB Developer focuses on designing, coding and optimizing database structures to operate in concert with application architecture components. S/he works as a member of a multi-functional Scrum team. The stakeholders of the Scrum team are: architecture team, product owner, and process modeling team, front-end application team, middle-tier team, infrastructure and operations team, data management team. Duties will include, but not limited to: - Creating physical data models - Installing and optimizing physical models for DB2 and Oracle RDBMS. - Optimizing the performance of the OLTP DB(s) to support a 3-tier system architecture, utilizing indexing, partitioning and in-memory data grid - Designing and implementing data management processes: security, lifecycle management and operational readiness. - Integrating and optimizing DB with data virtualization solutions, such as Denodo cache, for performance at high transaction volumes. - Implementing data replication for DB2, Oracle, MSSQL and Netezza using IBM Infosphere CDC tool. - Designing and implementing data integration and data conversion solutions via SQL, Informatica and IBM Infosphere CDC tools. - Bachelors in Computer Science or Masters Computer Science or equivalent preferred. - 10 years of experience and expertise with data modeling and RDBMS technologies – WILL LOOK AT SOMEONE WITH 5-7 years of experience - Certification in IBM DB2 technology is preferred - Certification in IBM CDC technology is preferred - Certification in Oracle DB technology is preferred - It is advantageous to have an outstanding programming skills *Critical Skills* - Critical to success are “soft skills”, such as ability to work collaboratively and quickly learn new skills to support multi-functional deliverables of Scrum team; crisp communication and social skills to effectively interact with the stakeholders listed about to receive input into deliverables; well-developed coaching skills to train and knowledge transfer to internal resources; mature writing skills to deliver required documentation; mature EQ skills to be able to adopt and assimilate quickly into the company culture; positive attitude and flexibility to adjust to fast changing environment. *Required Skills* - Required knowledge and prior experience working with the latest versions of the DB2 DB. - Required knowledge and prior experience working with the latest versions of the Oracle DB. - Required knowledge and prior experience working with standard data constructs such as XML, XSD, JSON, 3NF, Data Volt. - Required knowledge and prior experience with data modeling of OLTP and ODS systems - Required knowledge and prior experience working with IBM Infosphere CDC - Required knowledge and prior experience with DB tuning and lifecycle management, such as Partitioning and Compression. - Required knowledge and prior experience working with healthcare data domain and its standards, such as HL7, FHIR, FHIM, etc - Required knowledge and prior experience working with data modeling and data management tools, such as IBM InfoSphere Data Architect, IBM Information Governance suite, Erwin, Sparx EA - Required knowledge and prior experience working with Unix scripting technologies - Required knowledge and prior experience working in Scrum Agile methodology - Required knowledge and prior experience working in Domain Driven Design (DDD) methodology *Preferred Skills* - Preferred knowledge and prior experience working with the JPA tool - Preferred knowledge and prior experience working with the In Memory Data Grids (IMDG), such as Extreme Scale - Preferred knowledge and prior experience working on Services Oriented Architecture (SOA) - Preferred knowledge and prior experience working with IBM Fast Track and Infosphere Governance Catalog (IGC) - Preferred knowledge and prior experience working with Informatica technologies - Preferred knowledge and prior experience working with Microsoft technologies, such as MS SQL Server DB, T-SQL and bcp, .NET services - Preferred knowledge and prior experience working with Hadoop technologies [image: logo] *Ankush Nirala* | Technical Recruiter | Apetan Consulting LLC Tel: 201- 620- 9700* 112 | Mail: 72 Van Reipen Avenue # 255 Jersey City, NJ 07306 | Corp.Office: 15 Union Avenue, office # 6, Rutherford, New Jersey 07070 | [email protected] | G-talk: [email protected] | www.apetan.com *[image: https://s3.amazonaws.com/images.wisestamp.com/icons/facebook.png]* <http://www.facebook.com/Apetanconsulting> *[image: https://s3.amazonaws.com/images.wisestamp.com/icons/linkedin.png]* <http://www.linkedin.com/company/apetan-consulting-llc?trk=top_nav_home> *[image: https://s3.amazonaws.com/images.wisestamp.com/icons/twitter.png]* <http://twitter.com/ApetanLLC> [image: e verify] *Disclaimer*: We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at [email protected] and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience.
![https://s3.amazonaws.com/images.wisestamp.com/icons/facebook.png]*](https://s3.amazonaws.com/images.wisestamp.com/icons/facebook.png]*){kind=link}
![https://s3.amazonaws.com/images.wisestamp.com/icons/linkedin.png]*](https://s3.amazonaws.com/images.wisestamp.com/icons/linkedin.png]*){kind=link}
![https://s3.amazonaws.com/images.wisestamp.com/icons/twitter.png]*](https://s3.amazonaws.com/images.wisestamp.com/icons/twitter.png]*){kind=link}