Kelly IT Resources is looking for a Senior Application DBA - SQL Server for an exciting direct hire opportunity in the Portland Oregon area. ***All applicants must be able to provide evidence that they are authorized to work in the United States without sponsorship*** Candidate must have extensive experience in administrating SQL Server 2005 and 2000 databases. Microsoft certification - MCITP (Database Administrator) is a strong plus. Experience with an agile process is a strong plus. Essential Functions & Job Scope ' Work closely with development team to design and implement SQL Server databases for complex business applications. Scope includes designing and developing client's OLTP applications, DW and BI applications. ' Evaluate new database technologies such as SQL Server 2008 and facilitate adoption decisions. ' Coach and mentor the development team members on best practices for database technologies. Collaborate with developers to design complex features, data structures and database code. ' Review and approve data model designs developed by application developers. Maintain data models and keep them up to date. ' In collaboration with Production DBA develop database sizing for each client and provide hardware recommendations. ' Provides technical consulting in identifying, implementing and supporting new SQL Server database function. ' Performs problem resolution and root cause analysis along with recommending and implementing preventive techniques. Tune existing stored procedures or write new stored procedures to improve performance or to resolve production issues. Ensure standardization of SQL coding practices and adherence to coding standards, change control, SQL best practices. Applicant Requirements ' 10+ years of software industry experience. ' 5+ years of experience in working as application DBA with a medium to large size development team using MS SQL Server. At least 3+ years of experience in designing applications using SQL server 2005. Exposure to SQL server 2008 strongly preferred. ' 3+ years of experience in data modeling and data architecture. ' 3+ years of experience in designing and developing a large scale data warehouse. ' 3+ years of experience in evaluating technology and design options and making recommendations to management. ' 3+ years of experience in mentoring junior SQL developers on best design and coding practices for SQL server 2005. ' 3+ years of experience in writing MDX and designing DW schemas. Candidates is expected to be an expert in MDX. ' Microsoft certification ' MCITP (Database Administrator) is strongly preferred. ' Experience in XP/SCRUM team is strongly preferred. ' A Bachelor's degree or equivalent specializing in computer science, management information systems, or some other analytical or computer-related discipline is desired. ***All applicants must be able to provide evidence that they are authorized to work in the United States without sponsorship*** Relocation benefits are not available for this position. This position requires you to be onsite - no telecommuting. No 1099 or Corp to Corp! Interested candidates should click send resume in WORD format to [email protected] Kelly IT Resources is a highly specialized and rapidly expanding business unit of global staffing provider, Kelly Services, Inc. Launched in 1999, Kelly IT Resources provides information technology specialists across all IT disciplines, including operating systems, programming languages, database administration, application development, website design and development, networks, e-commerce, ERP development, software engineering, and project management. Kelly IT Resources maintains more than 50 company-owned and operated offices throughout North America, Europe, and the Pacific Rim. Visit www.kellyit.com.