Senior Database Administrator
This position supports a large public-facing database infrastructure with extremely high transaction frequency. This is a social networking website. The site has users in over 100 countries, in 6 languages and in all time zones. This DBA candidate should be well versed in concepts such as: performance tuning; infrastructure scaling; sharding & partitioning; replication; multi-data center (WAN) replication.
This is an on-site, full time position. No contractors or off-shore candidates will be considered.
Essential duties include...
- Continually improve database server performance and provide robust monitoring;
- Architect appropriate strategies for efficiencies (memcache, alternative storage engines, partitioning, sharding etc);
- Support development team in design decisions for new product features and assist in code refactoring;
- Develop data cleanup/archiving scripts;
- Maintain & monitor DB uptime/performance monitoring tools;
- Engineer backup/recovery strategies and associated scripts;
- Assure replication integrity (20+ slave environment), and create new slaves as needed;
- Configure database hardware for maximum resource utilization; manage configurations accordingly;
- Capacity planning for growth;
- Sustain “three 9s” (.999%) uptime goal;
- Assure high-availability to 2+ Million web users daily (60,000+ simultaneously);
- Support tens of millions of transactions per hour;
- Assist with rotating on-call support (1 out of every 8 weeks);
- Scan web logs and database error logs for clues to database performance bottlenecks.
Education and Training
- BS or BA degree or relevant experience required;
- At least 5 years of experience with high volume, high availability database environment.
Skills and Competencies
- Seasoned Database Administrator in high volume, public-facing application environment;
- Expert level database management and administration skills;
- Experience maintaining large multi-server database environments, including administration, troubleshooting and performance tuning;
- Comfort level with needing to be reachable 24/7 for website emergencies;
- MySQL EXPERIENCE HIGHLY DESIRED;
- Other database (MS SQL, Oracle, PostgreSQL, etc.) experience also considered for excellent candidates who are able to work hard and learn quickly.
This is an on-site, full time position.
No contractors or off-shore candidates will be considered.
