MySQL DBA (train on PostgreSQL)- Reston, VA- estab. firm has cutting edge "start-up" culture - Mailing list pgsql-jobs

MySQL DBA (train on PostgreSQL)- Reston, VA- estab. firm has cutting edge "start-up" culture   

I am an independent, hourly Recruiter/Head Hunter and this opening is for one of my best clients located in Reston, VA (outside Wash., DC) who have hired me exclusively to find them a MySQL DBA to train on PostgreSQL (ideally candidate will have both) for this permanent, internal staff position. Please contact me if you are potentially interested or if you know someone who might be. There is no fee or contract in any way for you anyone you might be able to refer to me. My contact info is below.

A bit about my client:

My client is a well established technology services company and has about 60 employees. It is quite unique with its “start up software/silicon valley-like company culture”, which means that they are looking for individuals who have the “pizzazz" and high-tech savvy” to think out of the box, and who want to work for a company interested in staying current with leading edge technologies.

They have developed a SaaS platform for approximately 1200 Non Profit clients, 20,000 client users (aka campaign managers) and over 80 million supporters under management, and in 2012 they sent well over 10 billion emails on behalf of their clients. Currently they are also under-going a technology re-start and they are looking to expand their permanent, salaried, technical staff in the Reston, VA and Wash., DC offices to assist their efforts to re-build a significant portion of their technology platform. Thus, the creation of this position since this DBA will play a strong role alongside the company Data Architect in the migration and ETL of 90 % of their data from MySQL to PostgreSQL over the next two years.

Job description

This is a W2 salaried position w immediate benefits including a matched 401K and relocation assistance for right out of state candidate. Work with and report directly to the Director of Operations and assume responsibility for wide variety of database related tasks including strong role in the migration of 90 % of their data from MySQL to PostgreSQL starting this year and going through next year, with many other projects to follow.

Job description:

·       Own all DB aspects of the SaaS platform, including Lab (Dev, QA, Perf) and Production environments

·       Troubleshoot MySQL & PostgreSQL stability and performance problems at all levels (hardware, SQL and data model tuning)

·       Design and implement reliability and scalability improvements, including backup and recovery, replication, clustering and disaster recovery

·       Assist Development in data modeling (DDL)

·       Design and improve ETL processes to support subscription data loads, log harvesting and data mart

·       Design and implement cloud (AWS, Rackspace, VMWare) solutions, where appropriate

Candidate must be able to:

·       Demonstrate significant experience specifying, developing, building and maintaining highly reliable MySQL solutions, PostgreSQL is a plus but must be willing and able to learn PostgreSQL at a minimum

·       Demonstrate project estimation, scheduling skills and experience working in an Agile environment.

·       Recommend and plan for future server capacity.

·       Perform server performance tuning.  Baseline and forecast server performance data and tune server hardware and software configurations.

·       Demonstrate experience with mapping source to target as well as designing and developing, unit testing, troubleshooting, and tuning ETL.  Hands on experience with Pentaho ETL is a plus

·       Provide identification, diagnosis and resolution of production data problems in a fast-paced Production setting

·       Accomplish all of the above within a supportive team (sysadmins, developers, client services)  environment as well as independently with little formal oversight

Requirements:

·       6 - 8 years of hands on DBA experience and within all layers (RDBMS, ETL, OLAP, BI).

·       8+ years in IT overall with deep hands on Linux experience

·       Bachelor’s Degree in Computer Science or equivalent exp.

·  Demonstrated ability to work independently and interact with all levels: customers, internal management other tech staff

·  Demonstrated expertise in rapid and accurate problem localization, troubleshooting, resolution

·  Passion for getting to the Root Cause and preventing problems from recurring

·  Knowledge of Best Practices in database monitoring, maintenance, operation, updates, and security.

·  3+ years experience with large Schemas with large data sets (TBs) in a high-transaction rate environment

·  Experience with running DBs in both a virtual and physical capacity and the experience to know the pitfalls depending on data usage and access patterns.

You will be even more popular here if you have:

·  Hands on experience with Pentaho ETL

·  Hands on experience with BI tools

·  Experience with PostgreSQL in a Production environment

·  Experienced with “Big Data” processing and utilizing MapReduce

·  Experienced in trouble shooting and tuning data query performance for NoSQL

·  Thorough understanding of SDLC processes such as waterfall and Scrum/Agile

·  Experience with or exposure to Cloud based environments such as Amazon’s EC2 is a plus

I look forward to hearing from you or a referral from you.

Polly Fields

President and Sr. Recruiter

Career Strategies, Inc.

Hourly/Virtual Recruiting- All Levels

(301) 949-7876

pfields@career-strategies-inc.com

Polly Fields

President and Sr. Recruiter

Career Strategies, Inc.

Hourly/Virtual Recruiting- All Levels

(301) 949-7876

pfields@career-strategies-inc.com

"Give yourself the gift of work that inspires you!"