[BBLISA-jobs] Seeking Boston, MA USA Area DBA (Cambridge, MA)

[sheeri kritzer]

(Note:  It is OK to forward this to individuals and lists, but please
let me know where you sent it so I don't send it twice)

You've heard me on the MySQL Podcast at http://www.technocation.org,
now come work with me, the "She"-BA!  That's right, a MySQL job where
you're not the ONLY MySQL DBA!  And where MySQL DBA'ing is the sum
total of your job function (no development, no sysadmin!)

The company I work for is an online social networking/dating site
(http://online-buddies.com is our corporate site). Our main product is
for men seeking men in 87 countries throughout the world. We're
looking for another MySQL DBA, as designing schemas maintaining data
integrity for our 1 million active customers (and growing fast!). The
salary is dependent upon experience of course, but the company I work
for pays on the high side of the industry standard for the Boston
area.

 Application Instructions
 Please send cover letter, ré7sumé and sample schema to
work at online-buddies.com, with this job's title as your subject.  The
sample schema should reflect your abilities, so if you send along a
schema you would like to see improved, include a description of what
you would love to do to that schema to make it better.

 The fun "requirements":

     * A schema of 1 database with 85 tables — all of which have an
auto-increment id as their primary key — makes you cringe
     * Knowing the difference between InnoDB and MyISAM storage
engines and when you might use them
     * You cry when you see field names like "ExtraInfo1? and "ExtraInfo2?
     * You want to poke your own eyes out when you see schemas full of
varchar(20) default NULL
     * When someone says, "Can you add a [type, ie, INT, BLOB] field
to the table for me?" your first response is, "Sure, why do you need
it?"
     * You know that "data warehouse" is not a synonym for "replicated
copy of the database" — and if you did not, your first thought upon
reading that was "It isn't? I wonder how the schemas would be
different?"
     * When designing a schema, you draw out an ER diagram first (or
are willing to learn how)
     * Thinking about what data will be stored is the most important
thing to you when you're creating a table, not how the application
will access it
     * You are comfortable with a job that does not involve writing
code in a procedural language, but are comfortable enough if you have
to help debug code written in a procedural language that you could.

 On to the more boring stuff.....
 MySQL Database Administrator

The MySQL DBA will ensure that all data remains consistent across the
database, that the data is clearly defined, that all users access data
concurrently, in a form that suits their needs, that there is
provision for data security and recovery control (all data is
retrievable in an emergency).

 Essential Duties/Tasks

 * assist in establishing the needs of users;
 * plan dataflow for a new or revised database;
 * help design databases;
 * test all new systems;
 * maintain data standards, including adherence to the Data Protection
Act, C.I.S.P or other security requirements as implemented and
dictated;
 * write database documentation, including data standards, procedures
and definitions for the data dictionary;
 * control access permissions and privileges;
 * ensuring that storage, archiving, backup and recovery procedures
are functioning correctly;
 * capacity planning;
 * work closely with IT project managers, programmers and developers;
 * provide technical support for outdated legacy systems;
 * ensure the database integrity and security;
 * commission and install new applications.

 Knowledge of Industry, Product, and Technology

 * Bachelor's degree
 * At least 2 years of experience that is directly related to the
duties and responsibilities specified.

 Education and other Qualifications

 * Knowledge of current technological developments/trends in area of expertise.
 * Ability to interpret data models and to develop database structures.
 * Ability to use standard diagramming techniques to design and
develop computer data models.
 * Ability to configure, manage, and maintain the operation of complex
relational databases.
 * Ability to develop and manipulate large, complex data sets.
 * Knowledge of computer and/or network security systems,
applications, procedures, and techniques.
 * Ability to operate on a scheduled 24-hour on-call basis.
 * Knowledge of data integrity methods and techniques a plus.
 * Technical writing skills.
 * Ability to install, maintain, modify, and upgrade MySQL.

About our Company
Founded in 2001, Online Buddies Inc., continues to enjoy extraordinary
growth as we achieve worldwide recognition for our product range of
alternative lifestyle online personals; each providing safe, friendly
and exciting sites through which members can express themselves,
communicate and interact with one another as they wish.

Our Mission is to build upon our reputation as an internationally
regarded leader for online personals as well as an organization that
positively impacts the communities we serve. We work to accomplish
this goal through partnerships with local, state and federal health
and human service organizations; providing our members with accurate
and easily accessible health-related information.

We acknowledge that our success begins with our ability to select a
uniquely talented and diverse workforce that is afforded equal
opportunity to enjoy both personal and professional growth,
contributing to our collective success as we work to achieve our
individual aspirations.

Application Instructions (repeated from top)
Please send cover letter, résumé and sample schema to
work at online-buddies.com, with this job's title as your subject.  The
sample schema should reflect your abilities, so if you send along a
schema you would like to see improved, include a description of what
you would love to do to that schema to make it better.

 -Sheeri