Programmer IV

5 days ago


Portland, Oregon, United States OLSA Resources Full time
Job Description

Working in the Business Intelligence group, the Database Developer will service the critical information and infrastructure needs across the organization. In this highly visible position, you will have the opportunity to design a solution handling the large data volumes. You will assist in analytics, as well as building and tuning queries, SSIS packages and SQL jobs. Responsibilities:

* Create complex analytic queries on large data sets

* Create stored procedures, triggers, and functions

* Analyze trends in key metrics

* Design and build processes that extract, transform and load data from production data sources to the data warehouse

* Identify performance bottlenecks and optimize key queries * Maintain uptime demands on the BI system Requirements: * Experience in database development role

* Recent experience administering SQL Server 2005/2008

* Knowledge of T-SQL language & SQL Server database engine

* Experience performance tuning T-SQL queries, indexes, disk I/O, memory and CPU

* Strong communication skills a must

* Skills that are desired but not absolutely necessary include: o Knowledge of .NET o Experience using Tableau software o Experience with using SSRS and SSIS

Qualifications


•Create stored procedures, triggers, functions, complex analytic queries on large data sets in a Business Intelligence environment.


•Design and build processes that extract, transform and load data from production data sources to the data warehouse


•Recent experience administering SQL Server 2005/2008


•Knowledge of T-SQL language & SQL Server database engine


•Experience performance tuning T-SQL queries, indexes, disk I/O, memory and CPU

Additional Information

M-F 8am to 5pm

Pay rate is $41.38+



  • Portland, OR, United States Lexicon Solutions Full time

    Equipment Maintenance Technician I IV (6 total openings across those skill levels) Job Overview: Our client is a leader in silicon wafer manufacturing, serving the semiconductor industry worldwide and partnering with leading chip manufacturers. They provide a competitive benefits package including medical, dental, and vision insurance, 401k matching,...


  • Portland, OR, United States Lexicon Solutions Full time

    Equipment Maintenance Technician I IV (6 total openings across those skill levels) Job Overview: Our client is a leader in silicon wafer manufacturing, serving the semiconductor industry worldwide and partnering with leading chip manufacturers. They provide a competitive benefits package including medical, dental, and vision insurance, 401k matching,...


  • Portland, OR, United States Lexicon Solutions Full time

    Equipment Maintenance Technician I IV (6 total openings across those skill levels) Job Overview: Our client is a leader in silicon wafer manufacturing, serving the semiconductor industry worldwide and partnering with leading chip manufacturers. They provide a competitive benefits package including medical, dental, and vision insurance, 401k matching,...


  • Portland, OR, United States Lexicon Solutions Full time

    Equipment Maintenance Technician I IV (6 total openings across those skill levels) Job Overview: Our client is a leader in silicon wafer manufacturing, serving the semiconductor industry worldwide and partnering with leading chip manufacturers. They provide a competitive benefits package including medical, dental, and vision insurance, 401k matching,...