Full-Time

Lead Database Administrator

Postgres

Posted on 11/30/2024

Broadridge

Broadridge

10,001+ employees

Technology solutions for financial services industry

Fintech
Financial Services

Senior

Toronto, ON, Canada

This is a hybrid role requiring a home office setup.

Category
Data Management
Data Engineering
Data & Analytics
Required Skills
PowerShell
Chef
Bash
Microsoft Azure
Python
Puppet
MySQL
Ruby
Postgres
AWS
Go
Prometheus
Jenkins
Terraform
Ansible
MongoDB
Oracle
Linux/Unix
Cassandra
Django
Google Cloud Platform
Requirements
  • Have at least 5 years of experience running SQL Server/PostgreSQL/Oracle in large production environments.
  • Have at least 2 years of experience with infrastructure automation and configuration management (Chef, Ansible, Puppet, Terraform…).
  • Have experience with Ruby on Rails, Django, other Ruby and/or Python web frameworks, or Go.
  • Have strong programming skills.
  • Have solid knowledge of the internals of SQL Server/PostgreSQL/Oracle.
  • Have experience working in a distributed production environment.
  • Have excellent written and verbal English communication skills.
  • Have an urge to collaborate and communicate asynchronously.
  • Have an urge to document all the things so you don’t need to learn the same thing twice.
  • Have a proactive, go-for-it attitude. When you see something broken, you can’t help but fix it.
  • Have an urge for delivering quickly and iterating fast.
  • Know your way around Linux/PowerShell and the Unix Shell.
  • Have the ability to orchestrate and automate complex administrative tasks.
  • Have a passion for stable and secure systems management practices.
  • Possess data modeling and data structure design skills.
  • Bachelor’s degree in computer science, Information Technology, or related field.
  • Proven experience as a Database Administrator, Database Engineer, or similar role, with a focus on site reliability engineering principles.
  • 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).
  • Proficient in scripting languages (e.g., Jenkins, Python, Bash) for automation.
  • Excellent problem-solving skills and the ability to work independently or as part of a team.
  • Continuously improve skills in coding, development, and design with a focus on Python, SQL Tools, and Cloud Applications.
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.

Broadridge Financial Solutions offers technology-driven services for the financial services industry, focusing on processing and managing large volumes of financial transactions. They provide data management, analytics, and essential communications, helping clients track investments and comply with regulations. Unlike competitors, Broadridge has visibility into 95% of ETF assets and 90% of long-term mutual fund assets, enhancing client engagement. The company's goal is to be a vital partner for financial institutions, equipping them with the tools and insights needed for effective investment management.

Company Stage

IPO

Total Funding

$3.1B

Headquarters

New York City, New York

Founded

1962

Simplify Jobs

Simplify's Take

What believers are saying

  • Broadridge's strategic acquisitions, such as CompSci and AdvisorTarget, enhance its capabilities in SEC filings and digital marketing, respectively, positioning it for continued growth.
  • The integration with Transaction Network Services for global futures and options platforms reduces operational risks and simplifies market data management for clients.
  • Broadridge's extensive client base and handling of significant ETF and mutual fund assets provide a stable revenue stream and growth opportunities.

What critics are saying

  • The departure of key executives, such as the CFO, could lead to strategic misalignments and operational disruptions.
  • The highly competitive fintech landscape requires continuous innovation, and failure to keep pace could erode Broadridge's market share.

What makes Broadridge unique

  • Broadridge handles over $10 trillion in daily trading volume, making it a critical player in the financial markets with unmatched transaction processing capabilities.
  • Their comprehensive suite of services, including data management, analytics, and essential communications, provides end-to-end solutions for financial firms, unlike competitors who may offer more fragmented services.
  • Broadridge's focus on regulatory compliance and ESG performance monitoring sets it apart in helping clients navigate complex regulatory environments.

Help us improve and share your feedback! Did you find this helpful?