Position : Database Architect
No. of positions : 1
Location : Trivandrum
Reporting To:
Will report to the Sr director of Engineering
Reportees:
Sr. Oracle developers, Oracle developers & Jr. Oracle developers may be identified as necessary to achieve the department’s objectives.
Responsibilities:
The Database Architect will be accountable for the following but not limited to:
- The Database Architect maintains the data architecture and its components to ensure that it supports the overall reporting architecture and meets the overall functionality, system scalability and performance requirements
- Data warehouses / OLAP
- Long year experience with Database sizes 1TB+
- “Architected data warehouse”
- “Designed Data Marts”
- “Rearchitected Data model to allow for xyz”
- Design of Materialised views, cubes, etc
- Develop metadata standards for all data components, data models and business rules.
- Work closely with QA, Development and Database team.
- Work closely with Database team for data modelling and query optimisation.
- Data migration from other databases to Oracle (Co-ordinate with the Database team).
- ETL / Replication
- “Designed/Architected ETL processes”
- “Designed/Architected Replication“
- Performance tuning, query optimisation and benchmarking for PL/SQL applications.
- Be in touch with latest Oracle technologies
Qualification & Experience:
Essential:
- UG - B.Sc - Any Specialization;B.Tech/B.E. - Any Specialization;BCA - Computers
- Preferred: PG - M.Sc - Any Specialization;M.Tech - Any Specialization;MCA - Computers
- 12 years of development experience in SQL and PL/SQL on complex and large databases
- Strong experience in Oracle is required and Oracle certifications desired
- Knowledge in databases like Postgres, mysql or MS Access is also desirable
- Solid background in UNIX, ideally Solaris
- Excellent communication skills and team player
- Experience in product development involving large databases
- Good knowledge in product development methodologies and processes
- Knowledge in UNIX environment and shell scripting would be an added advantage
Desirable:
Experience in Banking or Telco or Retail background or data technology suppliers to Banking or Telco or Retail sectors
Compensation:
The compensation will be at par with the best in the industry, including Revenue linked incentives. Deserving candidates will also be considered for participating in the Flytxt stock option program.
Apply now.