Lead Database Administrator - Postgres

at  Broadridge

Toronto, ON, Canada -

Start DateExpiry DateSalaryPosted OnExperienceSkillsTelecommuteSponsor Visa
Immediate20 Dec, 2024Not Specified25 Sep, 20245 year(s) or aboveDatabase Systems,Cloud Applications,Azure,Automation Tools,Design Skills,Django,Sql Tools,Configuration Management,Python,Bash,Mongodb,Mysql,Information Technology,Ruby,Computer Science,Data Modeling,Cassandra,Design,Postgresql,Scripting Languages,AwsNoNo
Add to Wishlist Apply All Jobs
Required Visa Status:
CitizenGC
US CitizenStudent Visa
H1BCPT
OPTH4 Spouse of H1B
GC Green Card
Employment Type:
Full TimePart Time
PermanentIndependent - 1099
Contract – W2C2H Independent
C2H W2Contract – Corp 2 Corp
Contract to Hire – Corp 2 Corp

Description:

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.
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

Broadridge associates helped us envision our Connected Workplace - a work model that allows associates around the globe, dependent upon their role responsibilities, take advantage of the benefits of both on-site and off-site work to support our clients, one another, and the communities where we live and work. Our Connected Workplace is grounded in the concept of FACS: Flexible, Accountable, Connected, and Supported, which is our commitment to our associates. FACS supports our strong culture and allows us to achieve business goals while supporting meaningful work-life integration for our associates.
We are dedicated to fostering a diverse, equitable, and inclusive environment and committed to providing a workplace that empowers associates to be authentic and bring their best to work. We believe that associates can only do their best when they feel safe, understood, and valued, and we work diligently and collaboratively to ensure Broadridge is a company—and ultimately a community—that recognizes and celebrates diversity in all its dimensions

Responsibilities:

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


REQUIREMENT SUMMARY

Min:5.0Max:10.0 year(s)

Information Technology/IT

IT Software - DBA / Datawarehousing

Other

Graduate

Computer science information technology or related field

Proficient

1

Toronto, ON, Canada