Responsibilities:
Skunkworks is currently looking for a top of the line DBA to help build and expand our location-based service platform and manage the server software architecture that will power the next breed of mobile applications coming out of our social networking service.
Description:
Your responsibilities will focus on service delivery: designing, implementing, and maintaining a best-in-class infrastructure with strict availability and performance requirements. You'll be expected to work across functional boundaries, contribute to process development, and participate in an on-call rotation.
The most important job requirement is the ability, experience, and desire to provide a computationally intensive service, non-stop. Your troubleshooting skills should be top-notch, and your communication skills should be strong.
- Rotating 24x7 On-call support
- Develop high performance relational databases to store content, user personalization information, and billing/tracking data, etc. Develop and implement maintenance and administration procedures for the database systems.
- Ensures that backups are performed regularly on all databases.
- Work closely with software engineers to develop and maintain stored procedures, compiled SQL, etc. Ensure that data access methods, database kernel patches, APIs, etc. are kept current.
- Develop a system for gathering database performance metrics. Using these metrics, develop a plan to ensure that database systems are correctly configured for optimal performance. Manage and/or participate in implementation of database system tuning, to ensure optimal performance.
- Ensure that database systems are adequately monitored. Develop and implement a plan to ensure maximum reliability and availability of database systems. Proactively monitor database system status to determine early warning signs of problems.
- Author and maintain scripts to perform various aspects of administration. The DBA will document these scripts and maintain them in the source repository.
Requirements:
3-5 years experience as a DBA2-3 years experience of Postgres administration and tuning in a high-performance Linux environmentMust have strong knowledge of data relationships, data normalizationSQL, Perl, python, ruby, bash, C or other scripting experienceUnderstanding of LVM, SAN and RAIDZabix, Nagios, or other monitoring and metrics toolsAbility to learn quickly and adapt to a fast paced growing and evolving service delivery systemAbility to manage projects through their entire life cycleExcellent communication skillsStrong English language skills
