数据库管理员(Database Administrator)
|
|
| ||||||||||||
职位描述/要求：
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. 联系方式：
| |||||||||||||
 |
|
 |
|
| ||
 |
|
 |