Database Architect
天津南开创元信息技术有限公司
- 公司规模:500-1000人
- 公司性质:合资(非欧美)
- 公司行业:互联网/电子商务
职位信息
- 发布日期:2014-05-29
- 工作地点:天津
- 招聘人数:若干
- 工作经验:八年以上
- 学历要求:本科
- 职位月薪:面议
- 职位类别:数据库工程师/管理员 系统架构设计师
职位描述
KEY RESPONSIBILITIES
The role will require the candidate to demonstrate a systematic and disciplined system design and programming approach following a standard software development lifecycle (SDLC). The candidate will be required to work closely with the Development Manager and a team of developers.
Technical Roles and Responsibilities
? Database Architecting, Design, Development and Optimisation using standard tools (eg. ERWIN). Work as a leading or major contributor to drive development assignments and solve issues.
? Lead the design/reengineering of large-scale Oracle databases.
? Design high quality database schema to meet performance and expandability expectations.
? Provide expertise to design optimal distribution strategies.
? 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.
? Strategise the upkeep and maintenance of DB using purge/partitioning and cleanup of extraneous objects
? Guide and mentor junior DB developers and review their work to bring about overall improvements in delivery.
? Implement 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.
? Conduct or participate in requirement analysis with business analysts and end users.
? Lead the 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.
? Define, 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.
SKILLS & QUALIFICATIONS
The role requires extensive experience in development of Financial Markets systems. Alternatively, experience of developing risk engines for a leading software vendor in this space may be acceptable. Good knowledge of derivatives and fixed income products, market data, and risk processes and methodologies are preferable.
Technical Knowledge
? Solid database skills in Oracle. Strong Experience working on 10g, 11g and distributed databases.
? Expert knowledge of SQL and PL/SQL. Must have authored database objects (medium to high complexity) and written complex business logic 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.
? Should have played a leading/major role on design and implementation of large scale database systems, led the design of database schema and implemented major database related modules (SQL, PL/SQL, inside Oracle or outside in Java).
? At least 10 years of hands-on experience in SQL, PL/SQL & Oracle RDBMS up to and including 11g.
? Experience in design of Oracle database in a distributed environment with deep 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
Preferred Domain Knowledge
? Good knowledge of derivatives, market data, and market risk processes and methodologies.
? Understanding of risk measures.
? Excellent knowledge of any specific asset class / line of financial instruments.
Other Preferred Skills
? Strong analytical & problem solving skills with experience to perform data mining and analysis of issues, identifying root causes, support production queries etc.
? Strong communicator (English – oral and written) with excellent interpersonal skills, ability to converse in appropriate levels of detail with COO group, Risk Managers / Analysts, Production Support teams, Local IT Management and relevant heads of business functions.
? Experience of strategic change and working with change management team to understand and support change strategy.
? Ability to be organised and work concurrently on multiple delivery work streams / multi-task on different requirements across various stakeholders, and to work independently and under pressure.
? Has sufficient technical depth to guide the design and support testing of fairly complex IT systems especially on the Data Modelling, DB Design and related aspects.
? Experience and skills to support Project Management tasks as required; ability to identify and appropriately escalate project risks and issues; candidate should have strong governance and control mindset.
? Cultural sensitivity and awareness to work with a range of people from diverse background and geographies.
? Mathematical background / Numerate degree would be beneficial.
The role will require the candidate to demonstrate a systematic and disciplined system design and programming approach following a standard software development lifecycle (SDLC). The candidate will be required to work closely with the Development Manager and a team of developers.
Technical Roles and Responsibilities
? Database Architecting, Design, Development and Optimisation using standard tools (eg. ERWIN). Work as a leading or major contributor to drive development assignments and solve issues.
? Lead the design/reengineering of large-scale Oracle databases.
? Design high quality database schema to meet performance and expandability expectations.
? Provide expertise to design optimal distribution strategies.
? 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.
? Strategise the upkeep and maintenance of DB using purge/partitioning and cleanup of extraneous objects
? Guide and mentor junior DB developers and review their work to bring about overall improvements in delivery.
? Implement 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.
? Conduct or participate in requirement analysis with business analysts and end users.
? Lead the 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.
? Define, 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.
SKILLS & QUALIFICATIONS
The role requires extensive experience in development of Financial Markets systems. Alternatively, experience of developing risk engines for a leading software vendor in this space may be acceptable. Good knowledge of derivatives and fixed income products, market data, and risk processes and methodologies are preferable.
Technical Knowledge
? Solid database skills in Oracle. Strong Experience working on 10g, 11g and distributed databases.
? Expert knowledge of SQL and PL/SQL. Must have authored database objects (medium to high complexity) and written complex business logic 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.
? Should have played a leading/major role on design and implementation of large scale database systems, led the design of database schema and implemented major database related modules (SQL, PL/SQL, inside Oracle or outside in Java).
? At least 10 years of hands-on experience in SQL, PL/SQL & Oracle RDBMS up to and including 11g.
? Experience in design of Oracle database in a distributed environment with deep 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
Preferred Domain Knowledge
? Good knowledge of derivatives, market data, and market risk processes and methodologies.
? Understanding of risk measures.
? Excellent knowledge of any specific asset class / line of financial instruments.
Other Preferred Skills
? Strong analytical & problem solving skills with experience to perform data mining and analysis of issues, identifying root causes, support production queries etc.
? Strong communicator (English – oral and written) with excellent interpersonal skills, ability to converse in appropriate levels of detail with COO group, Risk Managers / Analysts, Production Support teams, Local IT Management and relevant heads of business functions.
? Experience of strategic change and working with change management team to understand and support change strategy.
? Ability to be organised and work concurrently on multiple delivery work streams / multi-task on different requirements across various stakeholders, and to work independently and under pressure.
? Has sufficient technical depth to guide the design and support testing of fairly complex IT systems especially on the Data Modelling, DB Design and related aspects.
? Experience and skills to support Project Management tasks as required; ability to identify and appropriately escalate project risks and issues; candidate should have strong governance and control mindset.
? Cultural sensitivity and awareness to work with a range of people from diverse background and geographies.
? Mathematical background / Numerate degree would be beneficial.
公司介绍
南开创元信息技术有限公司成立于2000年12月,是在高新技术产业园区注册的IT企业,公司注册资本3000万元,在日本东京、北京设有子公司,现有员工800余名。
南开创元在成立之初就结合自身优势制定了以开拓日本市场为主的国际发展战略。十多年来不仅与日本多家世界著名的大型软件公司保持了长期稳定的战略合作伙伴关系,还承接了数百个以日本保险、证券、银行等金融领域为主的软件开发工程项目,其中80%以上是开发规模在数十万行甚至百万行代码的大型项目,积累了丰富的对日软件开发和管理经验,培养了一支技术能力强、管理经验丰富、成熟稳定的开发和管理团队。南开创元以优越的人才优势和高品质的服务,在同行业中名列前茅。
在传统业务稳步发展的同时,我们积极拓展新的业务领域,目前已在产业系、自动工厂、云平台、机器学习、图像识别等方面取得了可喜的进展。南开创元正朝着大型高科技企业集团的目标稳步发展。
南开创元是一家重视人才的企业,它将员工的发展作为人力资源管理的基本宗旨之一,公司为员工提供完善的培养培训体系及丰富的职业发展通道,提供良好的薪酬福利及理想的工作环境。期待您的加入、期待您的陪伴!
南开创元在成立之初就结合自身优势制定了以开拓日本市场为主的国际发展战略。十多年来不仅与日本多家世界著名的大型软件公司保持了长期稳定的战略合作伙伴关系,还承接了数百个以日本保险、证券、银行等金融领域为主的软件开发工程项目,其中80%以上是开发规模在数十万行甚至百万行代码的大型项目,积累了丰富的对日软件开发和管理经验,培养了一支技术能力强、管理经验丰富、成熟稳定的开发和管理团队。南开创元以优越的人才优势和高品质的服务,在同行业中名列前茅。
在传统业务稳步发展的同时,我们积极拓展新的业务领域,目前已在产业系、自动工厂、云平台、机器学习、图像识别等方面取得了可喜的进展。南开创元正朝着大型高科技企业集团的目标稳步发展。
南开创元是一家重视人才的企业,它将员工的发展作为人力资源管理的基本宗旨之一,公司为员工提供完善的培养培训体系及丰富的职业发展通道,提供良好的薪酬福利及理想的工作环境。期待您的加入、期待您的陪伴!
联系方式
- 公司地址:地址:span海泰绿色产业基地J座