This job ad has been posted over 40 days ago...
0

applicants

Full-time Sr. Microsoft SQL Database Administrator

at VanderHouwen & Associates, Inc. in Oregon | OR Jobs


Location:
Portland, OR

Required Skills:
SQL database

Summary
The Sr. Microsoft SQL Database Administrator will be responsible for administration of application databases, using the Microsoft SQL Server database management system and for design, development, population and maintenance of MS SQL Sever reporting data repositories.
Responsibilities
Work with Application Business Analysts and Reporting Analysts to present data for reporting or extraction.
Work with application programmers in development and maintenance of database applications, report writing and publishing.
Serves as MS SQL Administrator including on-call support. The SQL DBA ensures best performance of the databases, including proper backups and restores, and administers necessary upgrades.
Monitors and troubleshoots SQL Server Integration Services (SSIS) ETL jobs and packages.
Monitors Epic Clarity ETL jobs that load to a SQL Server database and maintains upgrades to the Clarity ETL Console.
Resource for technical staff for data design, data extract/transform/load (ETL) monitoring and development, and query tuning.

Qualifications
Bachelors degree in Computer Science, Mathematics or related field or equivalent experience.
Experience:
Minimum 5 years experience SQL database administration
Experience in writing and implementing SSIS packages.
Experience in MS, SSRS, Crystal Reports T-SQL, Visual Studio, and Team Foundation Server.
Business Objects Enterprise experience
Monitoring and tuning (Business Objects Enterprise and Epic /Web-E and Universe)
Experience with Epic Clarity ETL some Business Intelligence platform highly desirable. Experience with SSAS preferred.
Ability to work with Application Business and Reporting analysts to develop and document data specifications for a wide variety of business purposes in a health care environment.
Expertise in administration of SSIS development, deployment and administration.
Database design, data modeling and documentation.
Knowledge of T-SQL
Installation and configuration of SQL Server for clustering and high-availability.
Database sizing, disk capacity planning and monitoring.
Demonstrated ability to write complex joins to efficiently access data.
Demonstrated ability to use appropriate development tools to author and implement stored procedures for use by report authors and application programmers.
Ability to work with personnel of varying technical backgrounds and proficiencies.
Strong written and verbal communication skills and documentation abilities.
Able to work well in a team-oriented environment as well as independently.
Strong analytical, problem-solving and decision-making skills.
Flexible in responding to rapid change and able to multi-task.



Recent jobs at VanderHouwen & Associates, Inc.
Contract tech jobs : Data Analyst at VanderHouwen & Associates, Inc. in Hillsboro, OR 21-12-2014
Contract tech jobs : Java Application Engineer at VanderHouwen & Associates, Inc. in Beaverton, OR 08-12-2014
Full-time Digital Signage Expert at VanderHouwen & Associates, Inc. in Oregon | OR Jobs 10-06-2014
Full-time WindChill Developer at VanderHouwen & Associates, Inc. in Oregon | OR Jobs 10-06-2014
Full-time Systems Manager at VanderHouwen & Associates, Inc. in Oregon | OR Jobs 10-06-2014

« Go back to category
Is this technology job ad fake? Report it!   
Recommend to a friend
Published at 02-03-2014
Viewed: 258 times