Technical Roles and Responsibilities
?Database Development and Optimisation using standard tools. Work as a major contributor to drive development assignments and solve issues.
?Develop high quality database schema to meet performance and expandability expectations.
?Optimisation of existing and development and review of new PL/SQL code for faster execution and rendering.
?Optimisation of existing DB objects (DB, Tables, Stored Procedure, and Triggers etc.)
?Use of advanced features in Oracle (11g) for DB optimization and better management and scalability of the existing DB.
?Responsible for database documentation required as part of SDLC.
?Carry out the upkeep and maintenance of DB using purge/partitioning and cleanup of extraneous objects on a regular basis
?Execute best practices on a continuous basis which improves reliability and efficiency of our delivery. Actively monitor volume and performance indicators of databases, and recommend solutions to solve any data problem.
?Participate in requirement analysis with business analysts and end users.
?Participate in design, coding, testing and documentation for bug fixes, enhancements and new module development.
?Contribute to reengineering initiatives to address deficiencies in existing system and apply better design principals.
?Monitor and enhance development processes to improve overall system performance in a global environment.
?Work with support teams, DBAs, end users and other stakeholders to resolve production issues.
?Coordinate with other teams in technology regarding deployment, interfaces and other development activities.
?Participate in SDLC processes such as change control, release and other activities.
?Provide second line support to production.
?Solid database skills in Oracle. Strong Experience working on 10g, 11g and distributed databases.
?Advanced knowledge of SQL and PL/SQL. Must have authored database objects (medium to high complexity) and written business logic of medium complexity using PL/SQL constructs.
?Good understanding of object creation, user / object permissions, query writing using simple to complex join operations.
?Experience in distributed computing software design. Experience in data design and distributed data storage.
?Experience of Interacting with Business Analysts, Developers, DBAs, and Unix Administrators to implement enhancement requests, and to diagnose and correct bug fixes.
?Experience in query optimization, DB optimization using partitioning and compression.
?Experience in writing test scripts and executing functional tests.
?At least 6 years of hands-on experience in SQL, PL/SQL & Oracle 10g and/or 11g.
?Experience in design of Oracle database in a distributed environment with good understanding on partitioning, hub/spoke mechanism.
?Experience in performance tuning Engineering (SQL Tuning, Instance Tuning, Database Tuning, OS Tuning & Capacity Planning of databases).
?Experience in building the databases using RMAN, IMP/EXP and DATA PUMP.
?Prior work experience on Oracle Golden Gate would be an advantage.
?Familiar with backup and recovery approach on enterprise databases.
Ability to work in a fast-paced dynamic environment to deliver high quality results under tight schedule and high pressure
Roles and Responsibilities
?Serve as the technical lead for building a new web based user front-end
?Recruit additional HTML5 developers
?Own the delivery and quality of work produced by the web development team.
?Demonstrate a systematic and disciplined approach to system architecture, component design and programming and follow a standard software development lifecycle
?Meticulous attention to detail and strong focus on clear and practical documentation
?Work closely with stakeholders, including Development Manager, Project Manager, Business Analysts, developers, and testers.
?Design, Code, Unit Test and support software components
?Act as the second line of support during production problems.
?Possibly extend the application front-end onto mobile platforms.
?Sound understanding of HTML5, CSS3
?Experience of Angular.js, Coffee Script, Bootstrap and knowledge of Node JS, Backbone.
?Knowledge of open source solutions and trending technologies
?Exposure to broader web technologies such as REStful API’s
?Deep knowledge on Java and PL/SQL on the server side.
?Strong understanding of web standards, accessibility, SEO, browser compatibility,