We are hiring a postrgesql DBA based out of our San Jose, Location at Archer. http://www.archermobile.com/careers
Primary areas of responsibility will include:
- 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 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 mulch-geographical regains
- Validate High Availability plan and perform regular DR testing.
- Perform Linux administration duties as needed.
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, C or other scripting language
• 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
- 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 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 mulch-geographical regains
- Validate High Availability plan and perform regular DR testing.
- Perform Linux administration duties as needed.
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, C or other scripting language
• 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
