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.
Position Overview:
We are currently seeking a highly skilled and detail-oriented SQL Server and related DB technologies Operations specialist to join our team. Selected candidate will join a global DB Operations team responsible for providing support and maintaining the overall performance reliability, and availability of our database systems. The DBA Operations team will also collaborate with cross-functional teams to ensure optimal database performance and support the organization's data management objectives.
Want more jobs like this?
Get Data and Analytics jobs in Vancouver, Canada delivered to your inbox every week.
Responsibilities:
- Perform routine database administration tasks, including installation, configuration, migration, patches, and upgrades of database systems.
- Identify and resolve database performance issues, including tuning SQL queries, optimizing indexing, and implementing.
- necessary database changes.
- Conduct ongoing monitoring and proactive management of database systems to ensure high availability and performance.
- Support database backup and recovery activities, ensuring appropriate backup strategies and disaster recovery plans are in place.
- Collaborate with application development and infrastructure teams to provide database support for applications and projects.
- Troubleshoot and resolve database-related incidents and problems, both independently and in collaboration with other technical teams.
- Provide operational support, including capacity planning, system performance analysis, and resource utilization monitoring.
- Develop and maintain documentation related to database administration procedures, configurations, and troubleshooting steps.
- Participate in an on-call rotation schedule to ensure 24/7 availability and response to critical incidents.
- Provide Level 1 and Level 2 support for database-related incidents, working closely with the Incident, management, and
- escalation teams.
- Bachelor's or equivalent degree in computer science, engineering, information technology, or a related field.
- Proven work experience as a DBA or similar role, with expertise in database administration for large-scale systems.
- Minimum of 3+ years of experience in database administration or operations - Strong knowledge in Oracle and related RDBMS technologies.
- knowledge in Microsoft SQL Server, PostgreSQL, Greenplum, Sybase, MySQL, or IBM DB2 is a plus.
- Minimum of 3+ years of experience in Windows, Unix or Linux.
- Familiarity with cloud platforms (AWS, Azure, Google Cloud) and their RDBMS databases.
- Proficiency in Shell script or Power shell, SQL scripting, performance tuning, and optimization techniques.
- Familiarity with database monitoring and management tools.
- Experience with database backup and recovery strategies and techniques.
- Knowledge of data modeling and database architecture principles.
- Excellent troubleshooting and problem-solving skills.
- Strong communication and collaboration abilities to work effectively with cross-functional teams.
- Ability to work in a fast-paced environment and handle multiple priorities simultaneously.
- Demonstrated capacity for self-directed learning is required.
- Experience and knowledge of monitoring and monitoring tools e.g., SCOM, Datadog,
- Experience with issue, change control tracking software's e.g., Remedy-ITSM, JIRA
- Salary Range: $75,000 - $85,000 depending on experience. Compensation may vary outside of this range depending on a number of factors, including a candidate's qualifications, skills, competencies and experience, and location. Base pay is one part of the Total Package that is provided to compensate and recognize employees for their work, and this role may be eligible for additional discretionary bonuses/incentives, and restricted stock units.
- Bonus Eligible Position
- Benefits: Medical, dental, life and vision insurance.RRSP program with company match, paid parental leave, competitive vacation days and more. Medical insurance starts immediately upon hire.
- Location: Canada (Vancouver)
- Reporting to: Director DB Operations - Oracle (USA)
COVID-19 has accelerated change across our workplace, including our hiring practices. As a result, throughout your application process, you may be asked to connect with us virtually, and may not be required to meet in-person. Our recruiters will explain how virtual interviews will be held throughout the recruitment process, and they will be able to answer any questions you might have.
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.