Job Details: Data Warehouse Specialist
| Job Title: | Data Warehouse Specialist |
| Job ID: | 0500 |
| Company: | TFA Staffing Co |
| Position Type: | Permanent |
| Pay Rate: | Open |
| Skills: | SQL Server 2005, SSIS, SSAS, OLAP |
| Date Posted: | Jul-02-08 |
This is a senior position.
1. Project Description (please do not use EY specific acronyms)
The DBA will provide database expertise in architecture, design, implementation and integration of multi-tiered applications residing on RDBMS utilizing Microsoft® SQL Server?. The DBA must have an in-depth knowledge of relational, object oriented and data warehouse databases, design and implementation. The DBA will be responsible for application DB testing & support, D&R strategy and architecture, version control, object management, standards, code & design review, production staging & implementation planning, overseeing development efforts, support and training.
· Provide database solutions for application development
· Provide facility to produce and maintain quality data efficiently
· Provide documentation that articulates the database technical solutions that will be used to guide the delivery of the technical solution
· Add value to the business by facilitating improved process design
2. Please give a high level explanation of the application on which this candidate would work.
· Responsible for database technical design and architecture based on established standards
· Responsible for application database review & testing developed both in-house and/or by external vendor.
· Responsible for maintaining database code, objects, backups and version control in development, test and production environments.
· Setup & Maintenance of multiple database environment(s) on each given project
· Will work individually or with a technical team to develop a strategy and tools in order to perform data migration from multiple Platforms.
· Cross training of both other DBAs and support staff
· Script generation for auto population of test data
· Data migration analysis, design and implementation
· Work with off-site support staff on troubleshooting and repairing production issues
· KEY Deliverables:
· Entity Relationship Diagram (ERD) by utilizing CA AllFusion Erwin®
· White paper from research, development and tool evaluation
· Database installation document
· Database standards
· Feedback (document) from database reviews
3. Description of day to day tasks (please be as descriptive as possible)
4. Description of technical environment (.NET, Oracle, Websphere, etc.)
SQL Server 2005, SSIS, SSAS, OLAP
C .Additional Information
1. Desired Educational or Professional background? (i.e., BS Comp. Science, MCSE, CCIE, etc.)
MCDBA would be a plus.
2. Other Comments (include travel requirements, if any):
JE v2.0, Long Term Business Planning
Local candidates Only
| Location: [rss] | US-NJ-Parsippany |
| Telecommute: | No (Onsite Position) |
| Contact Name: | Cathy Tolliver |
| Contact Phone: | 504-377-7107 |
| Contact Email: | tfastaff@consultant.com |
| URL: | http://www.tfastaffing.com |
Principals only. Recruiters, please do not contact this job poster.
View other jobs in US-NJ-Parsippany »
View other jobs in US-NJ »
View other Data Warehouse Specialist jobs, Data Warehousing jobs, Systems Engineer jobs, Tech jobs
View other jobs requiring these skills: SQL Server 2005,
SSIS,
SSAS,
OLAP
View other postings by TFA Staffing Co »
