Roundbox Systems, Inc.
PostgreSQL Database Administrator
San Ramon, CA
We areexperiencing explosive growth of ouron demand service and we areseeking a Postgres DBA with Linux chops that also has some past or currentOracle DBA experience. This team is responsible for implementing and managing all aspects of our customer-facing infrastructure in a high-performance global production environment.
Primary Areas of Responsibility:
Working hand-in-hand with both the Development and Operations teams on all aspects of the hosted PostgreSQL architecture in an Agile fashion.
Work closely with Development and Operations teams to develop and maintain stored procedures, compiled SQL, etc.
Ensure that data access methods, database kernel patches, APIs, etc. are kept current.
Assist in migrations from Oracle to PostgreSQL
Assist and maintaining and evolving the clustered and highly available PostgreSQL architecture.
Assist in evolving the PostgreSQL infrastructure to scale effortlessly through both cloud and premise architectures
Author and maintain scripts to perform various aspects of administration. The DBA will document these scripts and maintain them in the source repository
Rotating 24x7 On-call support
Create advanced monitoring and tuning scripts to ensure the databases are always running at the best performance possible.
Ensure backups are taken and are valid across multi geographical regions
Validate High Availability plan and perform regular Disaster Recoverytesting.
Perform Linux administration duties as needed.
Develop and implement a plan/system/methodology to ensure maximum reliability and availability of database systems. Proactively monitor database system status, gathering performance metrics and making tuning and High Availability recommendations to determine early warning signs of problems and prevent issues from arising.
Qualifications / Necessary Skills:
Strong knowledge of data relationships, data normalization
Mastery of one or more of the following scripting languages: SQL, Perl, Python, Ruby, bash, or other scripting language
Understanding of Virtualization, LVM, SAN and RAID in relationship to PostgreSQL databases
Cacti, Nagios, or other monitoring and metrics tools
Ability to learn quickly and adapt to a fast paced growing and evolving service delivery system
Ability to manage projects through their entire life cycle
Excellent communication skills