DB Operations Specialist – SQL Sever
City : Vancouver - 555 Burrard Street
Category : Associate
Industry : Financial Technology
Employer : Broadridge Financial Solutions
We are currently seeking a highly skilled and detail-oriented SQL Sever 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.
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 one of advanced database systems like Oracle, Microsoft SQL Server, PostgreSQL, Greenplum, Sybase, MySQL, or IBM DB2.
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.
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.