Database Operations Specialist - PostgreSQL (Hybrid - Flexible Options) (BJ-13921)

Role Overview

We are seeking an experienced Database Operations Specialist to join our dynamic team. Your role will be crucial for developing, maintaining, and optimizing our data management systems to support our organization's data-driven decisions.

Responsibilities

• Analyze solutions and implement best practices for our Postgres database environments

• Work on observability of relevant database metrics and make sure we reach our database objectives.

• On Call support on rotation with the team.

• Provide database expertise to engineering teams (for example through reviews of database migrations, queries and performance optimizations).

• Work on automation of database infrastructure and help engineering succeed by providing self-service tools.

• Plan the growth and manage the capacity of Broadridge's database infrastructure.

• Design, build and maintain core database infrastructure pieces that allow Broadridge to scale to assist hundreds of thousands of concurrent users.

• Support and debug database production issues across services and levels of the stack.

• Make monitoring and alerting alert on symptoms and SLOs, and not on outages.

• Document every action so your learnings turn into repeatable actions and then into automation.

• Design data structures with AWS technologies like Oracle/PostgreSQL RDS, DynamoDB, and Redshift.

• Establish data governance policies and procedures for data integrity and compliance.

• Work closely with IT teams, management, and other stakeholders to identify and meet data requirements.

• Translate business needs into technical specifications.

Your profile

• Bachelor's degree in computer science, Information Technology, or related field.

• 3- 5 years of experience running SQL Server/PostgreSQL/Oracle in large production environments.

• 2 years of experience with infrastructure automation and configuration management (Chef, Ansible, Puppet, Terraform…).

• Experience with Ruby on Rails, Django, other Ruby and/or Python web frameworks, or Go.

• Strong knowledge of relational and non-relational database systems (e.g., Oracle, MySQL, PostgreSQL, DynamoDB, MongoDB, Cassandra).

• Experience with cloud services (AWS, GCP, Azure) and understanding of cloud-based database management.

• Familiarity with database monitoring tools (e.g., Prometheus, Grafana) and automation tools (e.g., Ansible, Terraform).

• Team player with good communication skills, with an excellent level of English proficiency.