Job Details: SQL Server Developer/ DBA
| Job Title: | SQL Server Developer/ DBA |
| Job ID: | 91377 |
| Company: | Human Capital Management |
| Position Type: | Permanent |
| Pay Rate: | doe |
| Skills: | SQL Server 2005 |
| Date Posted: | May-06-08 |
Title:SQL Server 2005 Developer/ DBA
Location Bridgewater, NJ
Lenth:Perm
Rate DOE
Job Summary:
Determines data requirements; develops data strategies; analyzes data; implements data schema; designs interfaces; tests data quality; maintains database performance; improves database performance; updates job knowledge; accomplishes organization goals.
Key Initiatives:
**Lead Development of new Data Warehouse Project
**Lead and Train Data Warehouse Design Team in dimensional modeling and utilization of SQL Server 2005 BI Solution
**Develop monthly and Quarterly Reporting Solutions for each business process in the company
Duties:
**Deployment of SQL Server Technology Uses Integration Services for ETL design and management, Analysis Services for aggregate data management and Reporting Services to deploy reports to users.
**Determines data requirements by interviewing customers; analyzing business requirements and applications; evaluating existing systems, hardware, and software; defining and analyzing data sources; validating data required; documenting requirements.
**Develops data strategies by establishing integrated architecture and hierarchy; establishing metadata and modeling standards; developing and evaluating logical and physical models; defining ETL strategies, including designing and validating schema; preparing transformation rules, indexing, directories, synchronization, back-up, retention, recovery, and error handling rules; mapping data from source to target using SSIS.
**Implements data schema by developing program, process, procedure, and quality solutions for data acquisition, extraction, cleansing, transformation, integration, loading, and replication; developing filtering, formatting, and data delivery processes to data marts; building SQL code, stored procedures, and triggers; creating views of data structures; documenting system.
**Designs interfaces using reporting services to create visualization through matrix reports and charting. Provides drill up, drill down and drill through capabilities.
**Maintains Aggregate Data Model using analysis services to create data cubes for ad hoc queries and as the basis for reporting services reports.
**Maintains database performance by completing SQL performance tuning; query performance tuning; database indexing and system monitoring
Human Capital Management, Inc. is a staffing firm focused on the most important part of the Information Technology industry-PEOPLE. We are dedicated to attracting the Mid-Atlantic region's most talented IT professionals. At HCMI we use the term partnering when describing relationships with our consultants. That is because we invest the time to understand the motivating force behind each consultant, provide consultants with a strong understanding of our clients' projects and strive to match each consultant with a project which will satisfy the consultant's short and long term needs. Only by connecting the best consultants to the best projects is HCMI able drive the New Economy. By focusing on web-centric technologies, HCMI has been able to identify, attract and develop intimate relationships with the most exciting web projects throughout the Mid Atlantic Region.
Please call (610)341-0790 for more information, or email: recruiting@ehcmi.com
Please refer to job code 91377 when responding to this ad.
| Location: [rss] | US-NJ-Bridgewater |
| Telecommute: | No (Onsite Position) |
| Contact Name: | Jaci |
| Contact Phone: | 610-341-0790 |
| Contact Email: | recruiting@ehcmi.com |
Principals only. Recruiters, please do not contact this job poster.
View other jobs in US-NJ-Bridgewater »
View other jobs in US-NJ »
View other SQL Server Developer jobs, SQL Server jobs, Database Administrator jobs, Tech jobs
View other jobs requiring these skills: SQL Server 2005
View other postings by Human Capital Management »
