Lead Database Administrator – Postgres
City : Toronto - 120 Bremner Blvd
Category : Associate
Industry : Financial Technology
Employer : Broadridge Financial Solutions
At Broadridge, we've built a culture where the highest goal is to empower others to accomplish more. If you’re passionate about developing your career, while helping others along the way, come join the Broadridge team.
We are currently seeking a highly skilled and detail-oriented Database Administrator to join our team. The DBA will also collaborate with cross-functional teams to ensure optimal database performance and support the organization's data management objectives.
Basic Purpose:
Seeking a highly skilled and experienced Database Operations Specialist to join our dynamic team.
Crucial for developing, maintaining, and optimizing our data management systems to support our organization's data-driven decisions.
Will have a strong background in Jenkins CI/CD components, database optimization, data governance, and collaboration with cross-functional teams.
Job 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.
Required Skills/Competencies:
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.
Recruitment Process
Throughout your application process, you may be asked to connect with us virtually or in-person. Our recruiters will explain how hybrid interviews will be held throughout the recruitment process, and they will be able to answer any questions you might have.
Background Check Process
Broadridge requires employees to complete a background check that is completed by one of our service providers. We use this service to complete the following checks:
Employment verification
Education verification
Credit inquiry
Canadian criminal record check
Workplace Flexibility
We are committed to supporting flexible work arrangements, investing in technology or other resources to enable you to work from home effectively, wherever possible.
At this time this is a hybrid role, and therefore you should have a basic home office set up, high-speed internet, and the ability to work without distractions during core business hours.
Accessibility & Accommodation
Broadridge is an equal opportunity employer and is committed to a diverse and inclusive workplace ensuring that equal employment opportunities are provided to all individuals, regardless of race, colour, gender identity, sexual orientation, marital status, creed, age, disability, religious affiliation, or national origin or citizenship. If you require any accommodations during the recruitment process, please notify our recruitment team.
#LI-Hybrid
#LI-RB1