Activities to Be Performed: *Develops and maintains specialist knowledge of database concepts, object and data modelling techniques and design principles and a detailed knowledge of database architectures, software and facilities. *Analyses data requirements to establish, modify or maintain object/data models. *Evaluates potential solutions, demonstrating, installing and commissioning selected products. *Uses database management system software and tools to investigate problems and collect performance statistics and create reports. *Carries out routine configuration/installation and reconfiguration of database and related products. *Design and implement RDBM and OODBM systems *Define data structures, logical and physical databases using CASE tools *Revise database design; implement stored procedures, triggers; apply normalization and other harmonization activities *Define advanced queries *Use built-in Data Access classes in Application Frameworks to create Database Interfaces and classes in applications to be able to access and manage databases *Evaluate and select commercial or academic databases for use *Prepare Data Dictionaries and other related database documentation
Requested Skills & Competencies *Knowledgeable of both relational and non-relational (NOSQL) database principles, design, implementation and/or administration *Knowledgeable of Object Oriented Database principles design, implementation and/or administration *Experience with writing queries and query optimization *High-level knowledge of other computing disciplines including software development, system integration and IT service provision *Understanding of polyglot consistence and map reduce technologies.
Desirable Specific Experience: *Microsoft Certified Solutions Associate SQL Server 2012 *Microsoft Technology Associate IT Infrastructure *Oracle Database 11g Administrator Certified Professional *Oracle Enterprise Manager 11g Certified Implementation Specialist *Oracle Weblogic Server 11g Certified Associate