Sr Database Developer / Architect
YP Intellectual Property, LLC - San Francisco, CA

This job posting is no longer available on YP Intellectual Property, LLC. Find similar jobs:Senior Database Developer jobs - YP Intellectual Property jobs

Are you looking for a fast moving, creative environment where you can use your expertise to develop and market cutting-edge interactive and digital products?

YP is one of the largest local search, media and advertising companies in North America. The company creates local search and advertising products that encourage consumers to discover and engage with local businesses across online, print and mobile platforms. YP's suite of local offerings includes its flagship products, YP Local Ad Network, the popular YPmobile app and The YP Real Yellow PagesĀ®, the largest print directory in the world by advertising revenue., which attracts over 30 million monthly online unique visitors, is also accessed by millions of users each month via the mobile web.

The YP(SM) Local Ad Network helps advertisers grow their business and distributes ads to a distinguished list of top publishers. YP's wide range of local ad products such as premium listings, performance-based advertising, direct mail and search engine marketing provides advertisers an opportunity to increase their presence among consumers who are looking for a local business. YP's advertising products address the diverse needs of nearly a million local businesses and help drive tens of billions of dollars in local commerce annually.

YP products are backed by one of the industry's largest local advertising sales forces made up of several thousand media consultants and other resellers.

Join our dedicated and talented team of individuals all focused on creating the best products in the marketplace. We currently have an opportunity for an experienced Sr Database Developer / Architect in our San Francisco, CA offices.

Work as a senior level project team member for application development projects, responsible for developing database solutions for new features.

Develop project-level database ER designs to support application engineer data needs.

Document database processes and best practices.

Build complex database integration and data feed processes for both OLTP and OLAP database systems.

Write stored procedures, user defined functions, triggers and other database code objects as needed

Optimize all database objects and code to ensure best possible performance within department standards

Maintain existing database code library.

Work closely with .Net application engineers to ensure their requirements for data are met.

Act as key contributor to planning long term database architecture for primarily OLTP systems.

Required Experience:
Bachelor's or Master's degree from an accredited 4-year university

5 - 10 years experience with SQL Server designing database and writing SQL code Required

Skills and Characteristics:
Expert knowledge of Microsoft SQL Server 2005 or 2008, TSQL, and SSIS

Experience with high transaction or very large databases in a fast paced environment

Previous experience working as a database engineer or database administrator with database design/coding responsibilities

Experience with data design concepts, with the ability to turn requirements into data designs incorporating features that support data integrity as well as outstanding performance in a high-volume environment

Ability to understand application code techniques (VB, C#, .Net) in order to write database code that delivers data properly to the application

Experience with data modeling tools such as ERWIN or ER/Studio Ability to work closely with other application engineers and translate data requirements into database design and code

Excellent verbal and written communication skills

Able to create process and flow diagrams to support design work.

Self-directed and able to work with minimal supervision

Desired Skills:
Programming experience with C#, VB, C++, .Net

DBA operations experience

Oracle and/or MySQL database experience

We offer competitive salaries, excellent benefits including a matching 401(k), bonuses, and a casual yet high-energy work environment. Send us your resume today.

YP LLC is an Affirmative Action/Equal Opportunity Employer and we are committed to hiring a diverse and talented workforce. EOE/AA/M/F/D/V

Notice to Recruiting Agencies: search firms, headhunters or consulting firms. All unsolicited resumes sent to an YP LLC email address, to an employee of YP LLC, or to our resume database will be considered property of YP LLC, and we will not be obligated to pay any referral fee associated with such resume. Permission to send resumes may only be granted in writing by YP LLC. We are not accepting additional recruiting service providers at this time. Thank you for your interest in working with YP LLC.