|
|
数据库管理员(Database Administrator) | [查看更多类似职位] |
|
工作地点 |
上海 |
发布日期 |
2008-03-22 |
工作年限 |
3年经验 |
|
薪水范围 |
面议 | 学历要求 | 本科 |
|
|
|
|
| 职位描述 |
职位类别： 计算机软、硬件/互联网/IT 工作地点： 上海 发布日期： 2008-03-21 工作经验： 3-5年 最低学历： 本科 管理经验： 否 工作性质： 全职 招聘人数： 2人 职位月薪： 1000-50000元/月 职位描述/要求： The DBA will be responsible for working with the Operations Support team and performing day-to-day administration of SQL Server tasks. Additionally, this will assist with optimization, recoverability, replication, integrity and security of the database that will be utilized for a new software product. Duties and Responsibilities Responsibilities include the following; other related duties may be assigned. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 1. Support and setup database environments on the Windows environment. 2. Perform logical and physical database designs. 3. Develop SQL scripts, stored procedures, functions for n-tier applications. 4. Review specifications and provide time estimates on the development of projects and features. 5. Write documentation for database environments. 6. Perform database administration tasks. 7. Work with development team involving C#.NET, ASP.NET, and ADO.NET. 8. Perform installation, configuration and upgrading of SQL Server software and related products. 9. Develop and Implement backup and recovery procedures and process for all databases. 10. Monitor database backups. 11. Perform performance and tuning of all databases. Education and Experience Bachelor’s degree from a four-year college or university and four years software/firmware related IT experience or equivalent experience required. 1. 4+ years of experience in database (SQL Server and/or Oracle) development. 2. Good understanding of SQL Server/Oracle Architecture (SQL Server 2005/2008) 3. Experience in creating database schemas. 4. Participate in the setup, configuration, installation and upgrading of all computer/infrastructure equipment including both physical and logical security for such systems. 5. Good knowledge and experience in administration of SQL Server/Oracle database environments (backup, recovery, replication, security, monitoring). 6. Experience in creating SQL statements (TSQL/PLSQL), Oracle packages, stored procedures, functions, triggers. 7. Experience in XML development. 8. Experience in designing Data Mart and OLAP structures in cluster and non-cluster.environment. 9. Knowledge of ETL tools. 10. Familiarity with query optimization and tuning. 11. Knowledge of DTS, Import, Export and Data Migration. 12. Knowledge of SQL Server features: SSIS, Service Broker, synonym, schema, exception handling. 13. Self-motivated and ability to troubleshoot production processes and solve problems in real-time. 14. Familiarity with C#.NET, ASP.NET, and ADO.NET is a plus. 15. Microsoft Certification is a plus. 联系方式： 公司网站： http://www.tcghl.com 地 址：上海市长宁区延安西路 1599 号怡翔大楼 801 室 邮政编码： 200050 联 系 人： 周小姐 .
|
|
| 原职位地址：点击进入原地址 |
|
|
|
