Description :
Job Title: Database Engineer
Job Category: IT Operations
Product: Zune
Date Posted: 10/02/2008
Job Code: 245986
Location: WA - Redmond
Travel Required:
Does working with SQL Server in a world-class production environment excite you? Does finding cool solutions to challenging technical problems make your day? Do the behind-the-scenes workings of an entertainment service intrigue you? If so, then this may be a terrific opportunity for you!
The Zune Services Team is looking for an experienced DBA with a background in supporting production OLTP or decision support applications. The qualified individual will be on a team responsible for supporting the best entertainment platform in the world.
Key Roles and Responsibilities:
The core duty will involve providing expertise to the Zune Service feature teams in support of the design, development, and implementation of a world-class online service. The candidate should be able to provide accurate and timely resolutions to challenging technical problems while representing the team in a positive, professional manner. Candidates should be comfortable discussing complex technical scenarios and solutions with varying customer skill levels leading to a deep understanding of the issue, root cause, and resolution options.
Required Skills & Experience:
* 5+ years Experience managing SQL Server 2000/2005 on a Windows 2000/Windows Server 2003 platform in a DBA role supporting high availability enterprise systems
* Proficient experience in maintaining production reporting or OLTP systems, including familiarity with the SQL Server Engine and its tools set. Knowledge of Analysis Services / OLAP and related Business Intelligence tools is a plus.
* Expertise with implementation and support of data migration scenarios from OLTP systems to other OLTP or decision support systems, including experience with DTS/SSIS.
* Expertise supporting OLTP SQL Server systems and applications with high volume of transactions.
* Expertise with implementation and support of database replication.
* Expertise with implementation and support of log shipping and database mirroring.
* Strong troubleshooting skill set in SQL Server 2005 including, but not limited to: performance (blocking, query optimization), query failures (deadlocks, exceptions), distributed queries, logical and physical database design, security models.
* Experience designing databases and database systems.
* Experience with development of data migration scenarios, including understanding of pitfalls to avoid.
* Experience in capacity planning methodologies; experience providing SQL Server capacity planning data and recommendations.
* Created/Applied MOF/ITIL in an initiative
* Solid understanding of SQL technology for supported service area, strong teamwork, coordination, cross-group collaboration skills.
* Passion for the care and feeding of SQL Server and of databases.
* Ability to multitask and reprioritize work in a changing business climate.
* Excellent verbal and written communications. Good documentation skills.
Definite pluses:
* Experience with Webstore.
* MCDBA certification in SQL Server 2005.
* Experience in SQL 2008
* Experience in SQL Debugging and reading crash dumps
Quoting David Pogue from NYT:
"Funny, isn't it? In the music world, Apple and Microsoft have now completely switched roles. You buy Apple if you want to play it safe - and you buy Microsoft if you think different."