Job Description :
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