MS SQL Server DBA

Who we are:

Data by Design is a leading database consulting company with offices located in San Francisco CA, Eugene OR and Paris France.

You probably know us by our books like the "Microsoft SQL Server Unleashed" series, "Microsoft SQL Server High Availability" published by SAMS or by our performance and tuning tool SQL ShotTM.

We provide database consulting services for over 20 years, delivering high quality services to companies like Toshiba, Wells Fargo, Intel, Sony and Charles Schwabs.

Come join our team and work with the industry leading experts.

Qualifications & Requirements:

• Bachelor's degree in Computer Science or a related discipline, or equivalent work experience.
• At least 5 years of experience as a MS SQL Server DBA
• Self-starter with the ability to work both independently and cooperatively
• Experience working on large databases with high transaction volumes in a fast-paced environment
• Proven ability to maintain high-availability systems
• Experience with replication, mirroring and clustering
• Experience in database performance & tuning and Query Optimization

Responsibilities include:

• Design, maintain and ensure high availability of a production database system
• Develop and implement replication, mirroring and backup & recovery strategies
• Provide high level database support

Type: Full-time
Experience: Mid-Senior level
Functions: Information Technology
Industries: Computer Software
Job ID: HA-SQL-0120

Please send your resume as well as your availability and expected hourly rate to:

Mikael Bonnevie
Lead Account Manager
925-586-8082
mbonnevie@dataxdesign.com

Learn more about Data by Design at www.dataxdesign.com

SQL Server DBA

SQL DBA:

• Team Player - works well with others and takes directions willingly and/or work with minimal supervision
• T-SQL Skills - for coding/changing current or new Stored Procedures. For DML and DDL operation.
• SSIS Skills - able to modify or create SSIS packages
• SSRS Skills - able to modify or create SSRS Reports
• Ability to use versioning software - VSS separately and within VS 2005/2008
• MS Office Skills
• MS Visual Studio 2005/2008 skills
• MS OS understanding - able to take directions on OS processes as required
• Ability to deal with ambiguity and changing priorities
• Ability to deal with SQL Agent jobs and responds to issues for resolution
• Scripting in SSIS (nice to have)
• Working with environments from Dev to Test to Production on Enterprise level

Good opportunity to learn and work in SAP Basis.

Duration: 6 to 12 months
Location: Hillsboro, OR
Position Type: Contract
Start Date : ASAP - Able to join within 2 weeks from the offer

If this position interests you please send your resume in word format, availability and expected hourly rate?

Please send your resume to: Venky@sigmacgi.com . Any questions call me at 503-629-9457 work.

SQL developer

• 5+ years experience with T-SQL, SQL 2005, SQL 2008
• Languages: mssql, classic asp, (vb script - optional)
• Advantage: any knowledge with sensearray
• Type: Full time position
• Compensation: competitive salary, please contact for more information

Our company: www.profinity.com.
I am looking for someone who has very good experience with t-sql, and knows the coding languages we use (mssql, classic asp and vb script). It would also be nice if the person would have any experience with sensearray, but that is not an essential requirement. The person for this position also has to have a good understanding of business logic, so if there is a conversation about a project and how to build the database for it and the system around it, then he/she can take the essentials and build that system we need. Initially, the person will need to understand our system and build reports and doing performance tuning, etc. Then, as he/she understands our entire structure we would rely on him/her heavily to build the logic for the new projects. This position comes with great responsibility because we develop in a production environment. But of course we will give 100% support and dedication to this person to teach everything.

Norbert Veres
Business Manager
Profinity, LLC
Email: norbert@profinity.com.

We have some positions open for SQL Server developers.
 
Database Developers

Work site: Portland Metro Region
Program/Department: Applications Department
Hours: Full-time; 40 hours week
Pay Rate: Competitive pay based on education and experience
 
Position Summary:
 
Development of database applications and creation of reports as requested by authorized TFS staff. As well as compliance with regulatory and contract requirements.
 
Essential Duties:

1. Develop and maintain Electronic Medical Record (EMR). Including:
1. Stored procedure writing to facilitate advanced forms and reports.
2. Reporting using Microsoft SQL Server Reporting Services and Crystal Reports.
3. User interface form development.
2. Maintain the security and confidentiality of client records and other confidential information.
3. Respond to requests from authorized TFS employees for changes to EMR in a timely manner.

Additional Responsibilities:

1. Other duties may be assigned.

Qualifications Required: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
 
Education: Bachelors Degree in Management Information Systems or 5+ years equivalent experience and education in related field.
 
Experience: 2+ years developing stored procedures against a SQL-based enterprise-level relational database (Microsoft SQL Server preferred. Oracle, MySQL, or other relational database experience will be considered); 2+ years creating and distributing reports (Microsoft SQL Server Reporting Services and/or Crystal Reports preferred); 2+ years User interface form development (such as Delphi, Oracle Forms, Oracle Application Express (Apex), .NET, C#, Java EE, Powerbuilder, Visual Basic, Access or other closely related experience).
 
Job Knowledge: Operates within established and accepted office procedures and practices. Makes decisions within established guidelines, organizational policy and procedures, federal, state and local laws, rules and regulations and the requirements of this job description. Deals with highly sensitive and confidential resident information. Errors in work could result in confidentiality of sensitive information being compromised, loss of organizational accreditation and accreditation-dependent funding or the release of incorrect information, which may reflect negatively on the organization. Position functions as a support to Database Administrator, Program Evaluation Specialist, Records Manager, Network Administrator, and Chief Information Officer.
 
Skills: Computer skills with relational database programs.

No calls, please. Send cover letter and resume by email to jobs@trilliumfamily.org, or fax to 503-205-3552, or mail to 3415 SE Powell Blvd., Portland, OR 97202.
 
Consideration of candidates will begin immediately, and position may close without notice (open/posted until filled).

Ensequence, the interactive TV Company, enables programmers, service providers, and advertisers to create and deploy a high volume of uniquely branded interactive television experiences that increase programming ratings, advertising effectiveness and merchandise sales. The company manages the technical complexities of iTV implementation and enables its customers to quickly, affordably and dependably deploy interactive television, making content more powerful and engaging than it has ever been. Ensequence's customers include the largest and most innovative programmers and service providers in the media industry: NBC Universal, MTV Networks, ESPN, Showtime Networks, The Walt Disney Company, Turner Broadcasting, HBO, QVC, Rainbow Network Communications, Comcast, Time Warner Cable, Canoe Ventures, DISH Network, DirecTV and Verizon.
 
Summary:
This is a senior software development position responsible for database conceptualization, design, development and maintenance for the Ensequence product line of software. The incumbent must be experienced with Database Architecture/Analysis focused on MS SQL Databases. The incumbent will work closely with Architects, Development Managers, Technical Program Manager, and the software development team to ensure high-quality software releases.
 
Essential Functions:

• Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.
• Design databases to support business applications, ensuring system scalability, security, performance and reliability.
• Develop data models for applications, metadata tables, views or related database structures.
• Develop load-balancing processes to eliminate down time for backup processes.
• Develop or maintain archived procedures, procedural codes, or queries for applications.
• Develop and document database architectures.
• Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
• Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
• Create and enforce database development standards.
• Demonstrate database technical functionality, such as performance, security and reliability.
• Effectively communicate with all levels of the organization, to include development team, management and internal and external customers.

Key Knowledge, Experience, Skills and Abilities:

• At least 5 years Database Architect/Analyst experience focused on MS SQL Databases include SQLServer 2008
• Solid knowledge of C#/.Net
• Excellent written and oral communication skills. Attention to detail and the ability to prioritize and juggle multiple projects simultaneously are critical.
• Ability to distill high-level architecture to written functional specifications
• Work cooperatively with all members of the organization
• Ability to identify options, suggest solutions and act decisively when necessary to advance a project.

Additional Skills and Abilities

• Profiling, debugging and performance optimization a plus
• Software tools such as Visio and/or other modeling and flowchart tools a plus
• Knowledge of one or more Iterative software development processes a plus

Experience

• 5+ years Database Architect/Analyst experience focused on MS SQL Databases

Each employee is important to the success of Ensequence, so along with our central location in downtown Portland, amazing view and great working environment, we also offer the following benefits:

• Medical, dental, vision, prescription
• Company-paid Life, Long- and Short-term disability
• Flexible Spending Account
• 401(k)
• Stock Options
• Transportation reimbursement
• Health Club membership
• 10 paid Holidays
• Generous PTO plan
• Direct Deposit
• Team Environment
• Casual professional atmosphere (every day is 'casual Friday')
• Fridays are bagel and doughnut day

Please submit your cover letter with salary expectations and your resume. To apply now for this position please Click here.
 
Ensequence is an EEO Employer.

DATA CONVERSION SPECIALIST
 
About the Job

The Data Conversion Specialist is responsible for using various tools to complete data conversions from other software packages into Viewpoint Construction Software. Responsibilities include performing activities such as T-SQL scripting, data mapping, data modeling, data cleansing, and data transfer. Works closely with the Technical Services Project Coordinator to ensure project timelines are met. This position requires the ability to work in a leadership role individually and as a team member, regular interaction with customers, and the ability to maintain good working relationships between the team and the customer.

We are seeking mid-level candidates with a Bachelor's degree in accounting, computer science or business (with computer science classes) and a minimum three years of data conversion experience, or an equivalent combination of education and experience.

Job Responsibilities:

1. Performs data mapping between third party data to the Viewpoint data.
2. Codes SQL scripts and SSIS packages to convert data
3. Corrects data using SQL modification statements.
4. Monitors, tracks, and documents conversion activities in CRM system.
5. Communicates (with the Project Coordinator) to the customer on the progress of the conversion.
6. Meets scheduled project timelines.

Requirements are:

• The ability to understand the data architecture of the Viewpoint system and identify where this data is to come from in the legacy system.
• Excellent problem-solving skills and a strong customer-service orientation; committed to insuring timely, quality solutions to customer issues.
• Strong understanding of accounting principles and practices sufficient to manage accounting system data conversions efficiently and effectively.
• The ability to understand technical concepts and communicate them clearly to individuals with varied backgrounds and skill levels.
• Strong SQL knowledge and familiarity with various types of databases.
• Intermediate to advanced proficiency in Microsoft Transact SQL and familiarity with various types of databases.

Preferred, but not required are:

• Familiarity with SQL Server Integration Services.
• Knowledge of the construction industry and construction accounting.
• Experience using Timberline Construction Software, JD Edwards, CGC Construction Software, or other construction accounting software.

Rock Solid is our business style

With more than 225 software professionals, Viewpoint Construction Software, a division of Coaxis based in Portland, Oregon, has developed leading software solutions and support to the construction industry since 1976. Combining that solid history with a driving innovative spirit, we are building a company at the forefront of innovation. We developed a set of features and functionality that resonates with the needs of users in the construction industries and these qualities are embodied in software that is comprehensive and user-friendly; it's flexible, scalable and adaptable. We are proud of our product and proud of our extraordinarily productive work teams.

Viewpoint is committed to providing its employees with a rich selection of benefits, on-site workout facility, generous paid time off, and a variety of employee-experience enhancements that make it a great place to work - a workplace based on creativity, innovation, collaboration.

TO APPLY OR LEARN MORE: Click here NO RECRUITERS PLEASE!

Coaxis is an Equal Opportunity Employer

Please contact Allison Bregoli: Allison.bregoli@coaxis.net.

Reports Specialist

The Reports Specialist position is responsible for developing custom reports, dashboards, and cubes for Viewpoint Construction Software customers using Crystal Reports, MS Reporting Services, and Excel. The Report Specialist also provides support to customers using standard Viewpoint reports as well as those creating their own custom reports.

Responsibilities

1. Discuss, design, quote, and develop custom reports, cubes, spreadsheets, and SQL queries per individual customer specification (custom projects).
2. Provide telephone and Internet support to customers who have questions or issues related to standard and custom reports, cubes, spreadsheets, and SQL queries.
3. Provide Internet-based training and consulting for customers developing their own reports, cubes, and spreadsheets.

Competencies needed to perform this job well:

• Two-year college degree and a minimum of two years experience developing reports using Crystal Reports or an equivalent combination of education and experience.
• Ability to write SQL queries, stored procedures and views.
• Strong technical skills with a variety of business software tools including MS Office applications.
• Basic familiarity with business accounting applications (e.g. payroll, accounts payable, accounts receivable, purchase orders).
• Identifies and resolves problems in a timely manner and gathers and analyzes information skillfully.
• Demonstrates excellent written and verbal communication skills. Listens effectively, transmits information accurately and understandably, and actively seeks feedback. Effectively presents and explains information to various group sizes and levels of knowledge.
• Manages competing demands and is able to deal with frequent change, delays or unexpected events
• Demonstrates professionalism, discretion, and good judgment in all interactions with co-workers, customers, vendors and others.
• Prioritizes and plans work activities, uses time efficiently and develops realistic action plans.
• Requires the ability to sit and work at a keyboard and computer monitor for extended periods of time, and to communicate with customers and co-workers by phone and computer.

Preferred Competencies:

• Familiarity with commercial construction industry (e.g. job costing, equipment tracking, project management) is an asset for this position but not required.
• Experience with SSRS (SQL Server Reporting Services)

Rock Solid is our business style

With more than 225 software professionals, Viewpoint Construction Software, a division of Coaxis based in Portland, Oregon, has developed leading software solutions and support to the construction industry since 1976. Combining that solid history with a driving innovative spirit, we are building a company at the forefront of innovation. We developed a set of features and functionality that resonates with the needs of users in the construction industries and these qualities are embodied in software that is comprehensive and user-friendly; it's flexible, scalable and adaptable. We are proud of our product and proud of our extraordinarily productive work teams.

Viewpoint is committed to providing its employees with a rich selection of benefits, on-site workout facility, generous paid time off, and a variety of employee-experience enhancements that make it a great place to work - a workplace based on creativity, innovation, collaboration.

TO APPLY OR LEARN MORE: Click here

NO RECRUITERS PLEASE!

Coaxis is an Equal Opportunity Employer

Please contact Allison Bregoli: Allison.bregoli@coaxis.net.

Sr. Database Administrator
Smarsh® provides hosted solutions for archiving electronic communications, including email, instant messaging and social media platforms such as Facebook, LinkedIn and Twitter. Founded in 2001, Smarsh helps over 10,000 organizations manage and enforce flexible, secure and cost-effective compliance and records retention strategies and mitigate risk. For more information, visit www.smarsh.com or follow Smarsh at www.twitter.com/SmarshInc.
 
Position Summary:
The Smarsh development team is seeking to add a highly qualified senior database administrator to focus on the support and infrastructure for high-volume, multi-terrabyte SQL Server databases. The successful individual will be a subject matter expert on SQL, experience with complex large databases, and looking for a challenge to take your career to the next level!

Technical Requirements:

• BS/MS - computer science or relevant engineering discipline strongly desired
• 5 - 10 years' experience working in a high transaction, 24x7 Microsoft SQL database environment
• Expertise in database performance tuning and optimization
• Expertise in database disaster recovery planning and recovery across multiple data centers
• Extensive experience with database replication, mirroring and transaction log shipping
• Demonstrated ability to solve complex database administration problems
• Thorough understanding of database performance monitoring and analysis tools
• Ability to work with database developers and engineers to analyze database performance and identify problems in areas such as: execution plans, index coverage, and SQL server statistics
• US work authorization required

Additional Requirements:

• The ability to communicate effectively within cross-functional teams.
• Share new ideas openly within a team environment.
• The ability to think outside of the box to resolve issues and create solutions.
• Willingness to learn and adapt to new technologies.
• Professional demeanor and strong work ethic.

Smarsh is an Equal Opportunity Employer. Qualified applicants will be considered without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable law.

Please contact Stephanie M. Roth: sroth@smarsh.com.