Job Title: SQL Server DBA / Analyst
Date Posted: 11-03-2006
Job Location: Massachusetts-Boston North
Job Type: Full Time
Education Level: Bachelors Degree
Work Experience: 5+ to 7 Years
Job Shift: First Shift
Yearly Salary:DOE (Depend on Experience)
Company Name: 3am Labs
Company Website: www.3amlabs.com
Contact Information: 3am Labs   3am Labs (dba-jobs@3amlabs.com)
Job Description:
Companies worldwide rely on 3am Labs for powerful, secure remote access and support solutions.
Anchored by an executive team with a proven track record for success, 3am Labs offers the
excitement of an evolving company in a dynamic industry with the stability of a venture-backed
organization. Our fast-growing customer base includes Fortune 1000 businesses worldwide, with
over 1 million registered users in over 150 countries. By joining the 3am Labs team, you'll
become part of a forward-thinking company that's actively shaping the future of the remote
access industry.

The Database Architect is a key and central figure in the business and technical operations of
3am Labs. The Database Architect acts in the highest technical role in the design, testing,
implementation, maintenance, and control of 3am Labs’ physical, relational, and
object-oriented databases across multiple platforms and computing environments in the delivery
of 24x7 web application services. The Database Architect acts in an analyst role in the
implementation of business processes to fulfill requests from executive, sales, marketing, and
product management teams for ad hoc and automated delivery of streamlined data for analysis of
web traffic and product revenue.

Job Responsibilities:
• Own the enterprise data model
• Ensure 24x7 database uptime for the web application service, https://secure.logmein.com
• Lead the data services team to design intranet and extranet reporting database schema and
related infrastructure for real-time data access for executives and distribution partners
• Act as part of the development team to design application database schema and related
infrastructure
• Play a lead role in NOC data services management, multinode cluster management, and
distributed data center management
• Manage the flow of data from the OLTP web application service to the corporate data
warehouse DSS to the executive’s desktop
• Perform system optimization and improvement planning
• Integrate ecommerce systems; and support daily revenue reporting systems for CFO
• Integrate CRM systems; and support daily regional reporting systems for sales team
• Integrate web advertising campaign management and email delivery systems; and support daily
web traffic reporting systems for marketing team
• Design and develop additional reporting systems as requested

Qualifications:
• 5+ years DBA experience with Microsoft SQL Server in a 24x7 web environment
• 5+ years experience with Erwin or other data modeling tools
• 5+ years experience writing T-SQL stored procedures
• 5+ years experience with Microsoft IIS, ASP, ASP.Net, ODBC, html, javascript, vbscript
• Experience supporting 100+ GB databases at 1,000 SQL transactions/sec
• Experience with high volume e-commerce transaction payment systems, including VeriSign and
PayPal
• Experience with DBCC trace flags to trouble-shoot performance and resolve deadlock issues
• Datacenter experience, multinode clustering skills (Microsoft)
• Experience with Profiler, PerfMon, SiteScope, and other performance and index fragmentation
analysis tools
• Experience with ETL, DTS, log shipping, database mirroring, and other sophisticated data
management techniques in a 24x7 production environment
• Experience with OLAP business intelligence tools and reporting infrastructure
• Any experience with C++ is a big plus
• Experience with Oracle and mySQL extremely helpful
• Experience with Kayako customer support system is a plus
• Very security oriented mind
• Experience working with development teams in multiple countries
• Engineering or computer science degree
• Excellent written and oral communication skills

E-Mail to:  dba-jobs@3amlabs.com 
Save this job to My Search now     
Back to Search Results



Advance Job Search -- Job Description
Site Map Horizon Career CopyRight Advertising E-mail Friends Press Release Classified Ads Job Fairs Networking Advice and Resources My Account Post Resume Find Jobs Horizon Career