赴加拿大银行项目开发,招聘Oracle/sybase DBA
Job Description
The Resource will be required to:
a) Understand existing e-Procurement suite of applications’ data model and databases (Oracle and Sybase) setup
b) Install and rebuild the same data model and databases set up in China
c) Provide a stable database development platform for developers
d) Explain data model and interact with application developers and report builders
e) Assist in schema design – OLTP / Transaction schema vs Reporting / Data Warehouse schema
f) Perform Oracle upgrade from Oracle 9i to Oracle 10g
g) Perform Sybase ASE 12.5 migration to Oracle 10g
h) Develop scripts for data migration
i) Develop Sybase Stored Procedures and Oracle PL/SQL
j) Develop database code for web-based application
k) Prepare and document data dictionary and Entity-Relationship (E/R) diagram
l) Participate in code reviews
m) Assist in SQL performance tuning
Skill Set Requirements
The Resource shall possess the following skill set(s):
Minimum 5 years of IT experiences with
a) In-depth application development and database administration using Oracle 9i or above
b) In-depth application development and database administration using Sybase ASE 12.5 or above
c) Extensive experience writing SQL in stored procedures
d) Solid background in tuning and optimizing queries
e) Good understanding of corporate culture and processes
f) Experience in full project life cycle
g) Strong verbal and written skills in English
h) Excellent team player
Possessing the following experiences are considered a plus
i) Data Model in Service Oriented Architecture (SOA)
j) Object-Relational (O/R) Mapping and use of Hibernate
k) Data replication and high availability setup
l) XML features in database
m) Banking / financial / credit-card background – familiar with industry’s terminology