Database Administrator 数据库管理员
上海铱力物流有限公司
- 公司规模:150-500人
- 公司性质:合资(欧美)
- 公司行业:交通/运输/物流
职位信息
- 发布日期:2020-09-17
- 工作地点:上海-长宁区
- 招聘人数:1人
- 工作经验:3-4年经验
- 学历要求:大专
- 语言要求:英语良好
- 职位月薪:1-1.5万/月
- 职位类别:数据库工程师(DBA)
职位描述
POSITION: Database Administrator
LOCATION: 上海市长宁区天山路310号5F
Description:
This is a Sybase DBA role largely responsible for providing operational database services to the organization. Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents, reviewing service related reports (e.g: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved, responding to database related alerts and escalations and working with development team to come up with strategic solutions to recurring problems.
Work Activities:
· Cooperates with the development team to improve the system efficiency and stability
· Formulates the strategy of database backup and contingency plan
· Sets up and implements the database synchronization between different company sites
· Oversee backup, clustering, mirroring, replication and failover
· Sustaining the security and integrity of data
· Build database scheme, tables, procedures and permissions
· Set up data sharing and disk partitioning
· Develop database utilities and automated reporting
· Create, test and execute data management languages
· Analyze and sustain capacity and performance requirements
· Analyze, consolidate and tune database for optimal efficiency
· Restore and recover corrupted databases
· Install and test upgrades and patches
· Implement security and encryption
· Participates in the design & implementation of the data warehouse
· Evaluate and recommend new database technologies
· Continually updating technical knowledge and skills by attending in-house and/or external courses, reading manuals and accessing new applications
· Perform other relevant tasks as required
Requirements:
· A service oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues
· Capable of multi-tasking and working with a variety of people
· Able to self-manage time, prioritize tasks, provide estimates of how much time is needed to complete own tasks, set own deadlines, and deliver tasks on time
· Strong experiences in Database Administration in Sybase ASE, ASA, IQ, etc
· Experiences in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc
· Experiences in Performance Tuning, Query Optimization, using Performance Monitor, Plan Viewer and other related monitoring and troubleshooting tools
· Ability to identify and troubleshoot Sybase DB Server related CPU, memory, I/O, disk space and other resource contention
· Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication and High Availability strategies for Sybase database environments
· Strong knowledge of how indexes, index management, integrity checks, configuration, patching, How statistics work, how indexes are stored, how they can be created and managed effectively
· Solid acquaintance with Linux server, security delegation, network protocols, storage components
· Expert experience in implementing operational automation
· Knowledge of all kinds of Sybase Server tools
· Ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
· Documentation skills for processes and procedures
· Independent problem-solving, self-direction
· Willing to work overtime, living in Songjiang/Qingpu/Minghang district preferable
· Good written, spoken English is an advantage
职能类别:数据库工程师(DBA)
公司介绍
铱力物流,作为本地的第三方物流服务商和物流咨询公司,致力于在中国引入市场最需要的、世界上最先进的物流行业流程、技术和系统方案。在中国,作为市场上崭新的行业,铱力实现的是其在物流和供应链管理方面的专业知识和技术,并以国际化的管理和专业化的业务方式,成为新一代企业中的优秀代表。
Our company is experiencing constant growth, thus we require new talents to join us.由于公司业务持续增长,我们迫切需要才俊之士的加入。
WE ARE LOOKING FOR PEOPLE WHO
Are team players and service-minded
Demonstrate strong leadership characteristics
Are customer oriented
Possess uncompromising ethics
Have a sense of entrepreneurship and a mind geared for business
Are highly motivated, open-minded and willing to learn
Possess great analytical skills and problem solving abilities
Seek personal growth and opportunities for hands-on training
Aspire to link their professional and personal life.
Are keen to be part of a young dynamic company and who want to lead it to success.
我们正在寻找这样的人士:
具有团队精神和服务意识
表现出良好的领导个性
以客户为本
具有诚实的道德品质
具有创业精神和商业思维
积极主动,思维开放,愿意学习
良好的分析技能和解决问题的能力
寻求个人发展和培训机会
个人的价值观与公司的价值观一致
愿意成为年轻、有活力的公司的一部分,并愿意引领公司到成功
We offer:
我们为您提供:
Competitive remuneration and benefits
富有竞争力的薪酬和福利
Comprehensive social insurance
完善的社会保险
Additional commercial medical insurance and Personal accident insurance
补充商业医疗保险及人身意外险
Working Lunch
工作午餐
Free shuttle bus services are available at convenient pick-up points for staff to take to and from the office.
提供地铁站至公司的免费上下班班车
联系方式
- Email:sherry@skyzone.zone
- 公司地址:地址:span松江区洞薛路885号3号仓库