Super Windows/SQL Server SysAdmin (Work from home office)

Note: This is a work-from-home-office position.  You can be located anywhere in the USA, provided you have a properly equipped home office from which to work.

Are you a super Windows Systems Administrator / SQL Server Database Administrator (DBA) with expertise in administrating Internet Information Services (IIS) and SQL Server? Do you have dreams in SMTP and SQL?  Are you looking for a new challenge with a fast-growing company that this year made both the Inc. 5000 list and the Software 500 list?

JangoMail (www.jangomail.com) is seeking a full time, detail-oriented and experienced Windows Systems Administrator / SQL Server Database Administrator (DBA) to join our small, nimble, unique, and fun team. JangoMail is a Dayton, Ohio based highly profitable, rapidly growing and successful web-based email marketing system that allows businesses to create, send, and track email campaigns. JangoMail was launched in the fall of 2001 and has over 2,000 customers worldwide.

The Systems Administrator will be responsible for maintaining all of JangoMail’s servers, including administering our SQL Server databases, administering our SMTP sending servers, and configuring our IIS servers.  The Systems Administrator will also oversee the daily operation of the JangoMail engine and take appropriate measures when a problem is discovered.  In addition, the Systems Administrator will be in charge of the infrastructure for our new SMTP service, JangoSMTP (www.jangosmtp.com).

PRIMARY JOB RESPONSIBILITIES

• Managing our core servers (database server, web server, corporate email server) and our 40 SMTP sending servers. All servers are Windows 2003 Standard and Enterprise editions.
• Managing our Domain Name Server infrastructure, which is currently a third party ASP service.
• Recommending hardware configurations, and researching pricing and options when new equipment is needed.
• Administering our SQL Server 2000 databases.  Expertise in the SQL language is a must.  This job will be part DBA and part systems administrator.
• Administering the JangoMail application using our internal web-based tools.  For example, a customer’s List Import job needs to be prioritized above other Import jobs…write the SQL to do that.  Or, kill a customer’s email campaign immediately, and then report back to the customer as to how many email messages were sent before the kill.
• Write custom SQL scripts or generate custom reports from the database as requested by clients
• Making sure all servers are patched, up to date, performing optimally, and error free
• Monitor performance of servers, storage systems, and troubleshoot bottlenecks and recommend solutions to correct performance issues

EXAMPLES OF DAY TO DAY TASKS AND PROBLEM SCENARIOS

• All three SMTP sending servers at hosting company X have gone down.  Re-route the affected clients’ emails through different servers, and contact the hosting company to get the servers back online.
• The CPU on the core SQL Server is pegged at 100%.  Determine why.
• The JangoMail system is generally running slow.  Run a SQL Profiler trace to determine if there are any problem queries with improper indexing.
• A core server is running out of disk space.  Research options to add more storage capacity to our existing Dell storage array.
• The core JangoMail web server has had a hardware failure.  Manually failover to our backup server, and contact Dell to resolve the hardware issue on the primary server.
• A client is complaining that his email campaign has been sitting in the queue for 30 minutes, and it’s urgent that the email go out now.  Execute a SQL command to re-prioritize that client’s email campaign.
• A client has requested a dedicated server.  Contact one of our hosting providers, make the purchase, and configure the new Windows 2003 server with our SMTP sending software.
• Write a custom SQL script to monitor campaigns that are over 15 minutes delayed, and email a report to all staff when the campaigns are 15 minutes delayed.
• A client is unable to export his email list using the JangoMail export feature because the list is over 1 million addresses.  Manually generate the report using SQL Server’s Enterprise Manager, place the file on our FTP server, and inform the client that the file’s ready for download.
• Write SQL Server stored procedures to select/delete/update data in tables.

REQUIRED SKILLS AND EXPERIENCE 

• Intimate knowledge of the SMTP protocol and the individual SMTP commands
• Strong experience as a Database Administrator (DBA) in SQL Server 2000
• Windows Server 2003 administration
• Internet Information Services administration
• Initimate knowledge of how DNS (Domain Name System) works, particular MX and TXT records
• Superior written communication
• Strong organization skills and attention to detail
• Must be a whiz at analyzing numerical data, graphs, charts, and trends over time
• Ability to work independently from a virtual home office, without being distracted by being at home
• Super fast touch typing (at least 80 WPM)

To apply:

Send cover letter and solution to the below problem in the body of your email and your resume as an attached Word .RTF (Rich Text Format) file to SysAdmin2009 at us.jangomail.com (Replace “at” with an @ sign.)  Your cover letter should include a description of your experience in the aforementioned areas along with why you are the perfect candidate for this job.  Lastly, please answer the following questions within your email message so that I know you have the skills to be successful in this role:

1. SQL: Given a table called EmailAddresses and the columns ID (int) and EmailAddress (varchar(100)), write a SQL SELECT statement that retrieves all email addresses that occur more than twice in the table.

2. SQL: Given a table called Data with one single column ID, assume that there are ten rows in the table, with ID=1, ID=2, ID=3, and so on up to ID=10. Write a SQL SELECT statement that retrieves all of the IDs, but in an order such that the row with ID=5 is the first row returned. The order of the other nine rows does not matter.

3. DNS/SPF/SenderID: Determine if the IP Address 216.200.206.15 is allowed to send email “from” hotmail.com.  Explain why or why not.

What happens after you apply?

At JangoMail we use the Topgrading recruiting methodology. All applications will be read.  Based on historical statistics, 95% will be discarded for not following the directions. Out of the remaining 5%, only 1/5 will answer all three questions correctly. So the 1% of all applicants that follow directions and answer the questions correctly will be invited to participate in a 15 minute phone call. A select number of those candidates will then be invited to participate in a 3-4 hour technical test, done remotely with virtual meeting software. And lastly, the final candidates will be invited to meet me in person for the final interview in Chicago.

And one final note…

This ad has been written by me, the president of JangoMail.  I will also read every single response.  I’m looking for just the right, cream-of-the-crop person.  I’ve been told by recruiters that I will not be able to find one single person that has all the skills I desire.  Please help me prove them wrong.