Oracle Database Architect

Mount Talent Consulting
  • Delhi
  • 10-18 lakh
  • 7-12 years
  • 30 Nov 2015

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

*** We Required Professional who has 60% throughout in academics & 8+ yrs experience in Oracle Database Designing, Devlopement using PL/SQL on Architect Level for Gurgaon Location ***
Candidate Should have 60% throughout

Job Purpose :

Planning database deployment, upgrades & rollout, assuring vendor support, managing teams, and generating reports for customers and company management

Principal Accountabilities DB Design,Development,solutioning and supportability.

1. Design databases to support business applications, ensuring system scalability, security, performance and reliability
2. Develop/Enhance database models for applications, metadata tables, views or related database structures
3.Experience in large OLTP application, DB designs in telecom,Payments and banking industry preferably for Prepaid platforms,mobile banking and financial platforms
4. Plan effective Database capacity and architecture for the product installation at any type of environment whether it is standalone or real time cluster
5. Effectively diagnose, isolate, and resolve complex problems pertaining to database for any OLTP based product
6. Develop/Enhance PL/SQL procedures, optimised procedural codes, or optimised queries for applications
7. Develop database architectural strategies at the modelling, design and implementation stages to address business or industry requirements
8. Collaborate with system architects, software architects, design analysts, and others for product DB design enhancements
9. Review product database normalisation aspects and suggest better design to project engineering team/product management team/Product road map team (e.g. process change, training & development, work assignments)
10. Identify new tools for improving Product DB support. Develop and document database architectures
11. Propose product / solution design changes to facilitate high-quality DBA support (e.g. efficient table design, faster, simpler installation, remote monitoring & early warning, rich logs for fault identification)
12. Develop and propose long-term DB strategies after studying current deployment characteristics and customer problems
13. Modify/suggest configuration change of hardware, OS and application to fix problems in cases where DB Architect has to solve any critical problem
14. Assure compliance to company quality systems and participate in internal and external audits
15. Provide appropriate support to senior customer representatives or management where as a company participation is required at further level of bringing new business/retaining existing business.

Skills & Abilities:

1. Proven and deeper Oracle Database design experience with knowledge of OLTP application
2. Exposure/experience on other database systems like DB2, mySQL, SQL Server
3. Experience of writing SQL, PL/SQL, Procedure, Function, Packages
4. Practical experience in monitoring and tuning a database to provide a high performance service
5. Experience of architecting and designing advance database solution like High availability/disaster recovery product, database replication solutions
6.Must have played the role of DB architect for 2 years in Oracle database and/or DB2 database projects"

Certification(s) Required

Oracle, mSQL Design Certification

Job Posted By

About Organisation

Mount Talent Consulting