5+ years of database development experience. Deep knowledge of relational integrity, SQL (including Postgres, Oracle and others) and object relational models.
Experience in creating Packages(Postgresql or Oracle), Stored Procedures , Function, triggers, Dynamic SQL , Logging & Error Handling. Similar experience on Oracle would also be a fit.
Experience with Postgres/Postgres Plus Advanced Server (MUST).
Defining & maintaining database physical structure which includes defining schema, tables, Keys, Indexes etc.
Must have strong experience in designing Auditable Database.
Experience in drawing ER diagrams, Data Flow Diagrams/Process Diagrams
Defining functional capabilities, security, backup and recovery specifications.
Experience in test-driven development (TDD) will be an advantage.
Strong Knowledge about best practices & implementation of transactional / time driven database.
Expertise in implementing architectures for large scale databases and supporting server integrations.