黄山招聘

Position: The Database Administrator/Report Writer
Reports To: WW IT Systems Supervisor
Direct Reports: No direct reports currently

Overall Function---------------
The Database Administrator/Report Writer is responsible for maintaining and upgrading existing databases, setting up and supporting database users and troubleshooting database issues and end user issues. This position will be expected to design and create reports to meet end users' requirements, maintain and modify existing reports, set up user access to reports and perform troubleshooting activities related to a variety of internal reports and report software. The Database Administrator/Report Writer will also be expected to work with Business Intelligence Systems such as Oracle Interactive Reporting and Analysis, and be able to maintain and modify existing BI dashboards, design and create BI dashboards, set up and support BI users and troubleshoot BI issues.

Required Skills------------------
Excellent client service skills, ability to operate in time sensitive environment with competing deadlines. Prior experience with network administration and helpdesk support. Experience with MSSQL 2008r2 and Access databases, Oracle, Star Schema, Database Administration, Data Warehouse, ETL, and Reporting Services/Business Intelligence Systems. Knowledge of general software applications, ability to understand complex information and explain procedural manuals or methods. Ability to present information in one-on-one sessions and in small group settings. Ability to interpret an extensive variety of technical instructions in mathematical form

Required Experience---------------
Bachelor’s degree preferred, but willing to hire individual with an Associate’s degree. Must have 3-5 years of prior experience.

Role/Expectations: ？
1、Build and maintain interactive reports for key activities such as month end closing and sales reporting. ？
2、Provide a timely and effective response to user queries by analyzing, investigating and fixing them as required ？
3、Actively own and maintain support documentation ？
4、Perform ‘root cause’ analysis of user issues, provide immediate workaround for critical problems ？
5、Design and implement SSIS packages for server maintenance, data transfer and cleaning, and other tasks ？
6、Assist developers in SQL query tuning ？
7、Ensure availability of applications as per agreed Service Level Expectations or requirements by monitoring applications, related jobs and resolving issues ？
8、Learn the application and the associated business functionality
9、Install and support MS SQL servers and databases -- SQL Server 2008 R2 and 2005 ？
10、Performance and tuning of MS SQL server clusters. ？
11、Monitor MS SQL server clusters ？
12、Plan for and perform upgrades of MS SQL software ？
13、Develop strong relationship with the development and infrastructure support teams to resolve production issues in a timely manner ？
14、Ensure proper stakeholder communication and escalation as required ？
15、Good general awareness of Information Security policies and Technology Risk Management


Requirements------------- ？
3-4 years Database DB administration ？
MSSQL Database Administration ？
General ETL Experience ？
Oracle, interactive reporting repository ？
Oracle Database Administration ？
Database consistency checking ？
Database capacity/space management ？
Multingual Communication – English and Mandarin Chinese ？
Backup and recovery of all Database databases ？
Maintain Database data replication ？
Performance and tuning of Database servers ？
Plan for and perform upgrades to Database software ？
Plan for Database server hardware upgrades ？
Maintain Database server hardware ？
Monitor Database servers ？
Monitor daily Database data loading from production to development ？
Follow Disaster Recovery Process ？ Install and support ASE 15 Database servers and databases ？
Java programming a plus

上海任仕达人才服务有限公司诚聘