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.com, YP Local Ad Network, the popular YPmobile app and The YP Real Yellow Pages®, the largest print directory in the world by advertising revenue. YP.com, 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.
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
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.