Database Administrator

You have a life. We like that about you.

At OCLC, we believe you'll do the best work of your life when you're living the best life possible.

We work hard to build the technology that connects thousands of today's libraries. But we also work hard to make a job at OCLC a meaningful part of a balanced life- not a substitute for one.

Technology with a Purpose. OCLC supports thousands of libraries in making information more accessible and more useful to people around the world. OCLC provides shared technology services, original research and community programs that help libraries meet the ever-evolving needs of their users, institutions, and communities. With office locations around the globe, OCLC employees are dedicated to offering premier services and software to help libraries.

The Job Details are as follows:

In this role, we look first and foremost for people who are passionate around solving business problems through innovation and engineering practices. You will be part of the Data Platform Engineering team responsible for administration, infrastructure planning, and scaling of all Relational Database and Cloud technologies within OCLC. This position will work closely with the development teams to tune and troubleshoot applications to maintain high performing environments.

Additionally, you will provide guidance for best practices and standards for the data platforms to your development partners.

This position will be responsible for the administration and support of multiple relational database technologies both on-premise and within AWS. You will work closely with infrastructure and development teams to ensure business applications are highly available and performing within agreed on service levels.

Responsibilities:

• Install, manage, and tune SQL Server, MySQL and PostgreSQL databases.
• Develop and enforce operational best practices to maintain availability and responsiveness of database environments,
• Work in embedded development teams to understand usage patterns and tune applications to provide reliable and optimal performance,
• Review existing software/hardware architecture and identify opportunities for improvement in the areas of scalability, maintainability, backups, usage and performance,
• Automate repeatable tasks to reduce hands on administrative work,
• Participate in on-call support rotation,

Qualifications

Required:

• 3-5 years working technical experience with designing, building, installing, configuring, and supporting database servers, including but not limited to SQL Server, PostgreSQL and MySQL and cloud database solutions.
• Experience with database backups, recovery, and cloning.
• Solid understanding of Windows Server and open source Linux operating systems (CentOS, SuSE, Red Hat)
• Expertise in typical database administration duties such as capacity management, performance tuning, and database hardening (security)
• Strong knowledge of scripting and automation tools (e.g. Ansible, Bash, Python, XLRelease)
• Experience with MySQL and PostgreSQL replication, AlwaysOn Availability Groups and/or other high availability technologies.

Desired Skills/ Experience:

• Experience with AWS technologies and related solutions (EC2, S3, RDS, Aurora, DynamoDB, Snowflake)
• Experience supporting a production multi-site enterprise environment
• Experience working within a Scrum/Agile framework
• Familiarity with FedRAMP Compliance