For more information call (510) 655-6200

Database Administrator

DEPARTMENT: Product Development
JOB CODE: DBA
LOCATION: Emeryville, CA

Innovative Interfaces dedicates its energies to meeting the needs of libraries and the challenges of library automation. The company has fulfilled this mission with first-rate services and products such as the Millennium integrated library platform, the INN-Reach direct consortia borrowing solution, Electronic Resource Management, and the Encore discovery services platform. Today, thousands of libraries of all types in over 40 countries rely on Innovative's products, services, and support. The company is located in Emeryville, California with offices around the world.

Responsibilities

  • Setup and administer SQL databases for production, QA, and development.
  • Monitor and tune production SQL instances to ensure high performance and capacity; improve existing monitoring infrastructure.
  • Provide assistance to design/development teams and recommend best practices both in SQL and database design; lead logical and physical modeling efforts.
  • Design and implement replicated database instances.
  • Develop and implement database backup, recovery/failover, and disaster recover strategies. Lead efforts to test recovery strategies.
  • Assist with the creation of policies, procedures and standards and document daily tasks.
  • Write utility scripts to automate database management and monitoring.
  • Support migrations of databases between disparate hardware platforms.
  • Support efforts to migrate MySQL databases to Postgres.

Required Qualifications

  • Understanding of UNIX as a development environment.
  • 4+ years of hands on experience as a DBA.
  • 2+ years experience with Postgres or MySQL.
  • Ability to script in a high level scripting language.
  • Must have a strong understanding of performance optimization at query level, schema level, service level, OS level, hardware level.
  • Previous experience managing SQL in a high volume environment with stringent uptime requirements.
  • Solid understanding of storage technologies such as RAID, NFS, SAN etc.

Desired Qualifications

  • Working knowledge of open source monitoring software (Hyperic, Cacti, etc).
  • Working knowledge of networking, routing, load balancing.
  • Linux system administration experience.

Please fill out an application if you are ready to submit a résumé.

Innovative employs a staff of over 300 in Asia, Australia, Europe, and North America.