Database Administrator

7 days ago


Vancouver, Canada Rocky Mountainer Full time

Purpose

Key Areas of Accountability

**Database Administration**:

- Install, administer, and maintain all SQL Server instances including service packs and security updates.
- Setup and administer all DB environments including Dev, Test, Staging and Production.
- Develop and manage databases across all environments including Database Services in Azure PaaS.
- Create and manage users and assign permissions based on the approved and appropriate level of access required.
- Create linked servers to SQL Server and other enterprise databases.
- Create database backups and setup automated backup schedules.
- Restore database from backups in the event of data loss, DB failure, corruption, and during regular DR testing.
- Develop and manage ETL jobs, Azure Data Factory services, SSIS packages, and support the Data and Insights team with maintaining data integrity and quality.
- Provide DB administration, support, and design for Capital and Operational IT projects, EDW and collaborate with the Enterprise Architecture team on any required design activities.
- Troubleshoot database or related issues as part of day-to-day operational activities.

**Documentation and Best Practices**:

- Define and maintain plans for monitoring and performance tuning: physical servers, virtual machines, database, and query tuning including the creation and maintenance of indexes, monitoring CPU, memory, and disk usage.
- Define and implement Best Practices for database administration and data integration in both on-premises and Cloud environments.
- Document all SQL Server environments, databases, processes, and workflows.
- Ensure documentation is kept up to date based on any changes to environments or instances.
- Adhere to Data architecture standards, IT best practices, methodologies, and disciplines.

**Qualifications**:
Education / Certifications / Knowledge
- College Diploma in Computer Science, IT or MIS with emphasis on Database Administration and/or equivalent experience.
- Professional certifications such as MSCA in Data Platforms, or Azure Data Engineer Associate.

Experience
- Working in an IT environment for 5 - 7 years in a Database Administration role.
- At least 5 years’ experience administering MS SQL Server 2012/2016 enterprise environments.
- At least 5 years developing and managing ETL jobs in an enterprise environment
- At least 2 years’ experience managing cloud-based database technologies, including Azure SQL PaaS implementations.
- Expertise in Microsoft BI and IM technology stack including Azure Data Lake and Data Factory.
- Understanding of Incident and Change Management and ability to follow process, procedure standards and methodologies.
- Understanding of Infrastructure, Business Applications, and Help Desk technology.
- Understanding of Operational Data Store for Systems Of records (CRM, Finance, Sales and Operations) and EDW for Analytics and reporting.
- Preparing database architecture reports for management teams.
- Working knowledge of Active Directory and related user management tasks.
- Working in an environment requiring constant and clear communications both verbal and written.
- Working in a team environment and experience working cohesively with related IT teams
- Understanding of the project management life cycle.
- Gathering information, analyzing, and providing trending analysis.
- Proven writing skills with the ability to organize and present information in various forms such as textual, graphical, and statistical.

Skills & Abilities
- Results-oriented and customer-focused. Demonstrated ability to develop effective working relationships with internal and external customers.
- Able to drive and manage change.
- Able to manage multiple conflicting priorities, reprioritize tasks, establish priorities, work independently, and meet deadlines.
- Demonstrated ability to multi-task, probe, analyze and problem-solve complex issues.
- Strong interpersonal skills and the ability to adapt in a complex and changing environment.
- Work with detailed technical information and hands-on technology experience.
- Ability to maintain information in confidence and exercise good judgment.
- Communicate clearly and concisely.



  • Vancouver, British Columbia, Canada Themesoft Inc. Full time

    OverviewThemesoft Inc. is a leading provider of innovative solutions for the modern enterprise. As a Senior Database Administrator, you will play a critical role in ensuring the reliability and scalability of our databases.


  • Vancouver, Canada Wood Plc Full time

    Overview / Responsibilities: **Database Administrator and Programmer** position in our growing Vancouver office. **Role Overview** **Key Responsibilities** The scope includes the creation and support of robust database tools as well as the updating of existing databases in moving them to current platforms. Data management considerations for handling...


  • Vancouver, Canada Ronald McDonald House BC and Yukon Full time

    **About the Organization** At Ronald McDonald House Charities® British Columbia and Yukon (RMH BC), we envision a province where families stay close to their sick children. Today, 2 out of 3 Canadians live in a city or town without a children’s hospital. Our Mission is to give sick children the healing power of being together with family. As a champion...


  • Vancouver, Canada Breakdown Services, Ltd. Full time

    **Breakdown Services/Actors Access** is the leading provider of Casting information in North America. As such we provide cutting edge software centered around the casting process including Auditions. Our clients are Actors, Casting Directors, Talent Representatives and Filmmakers. We are currently seeking an experienced **SQL Database Administrator** to...


  • Vancouver, British Columbia, Canada Tekshapers Full time

    "Responsibilities:6+ years of experience in a Oracle Database Administration roleDatabase team will be responsible for fulfilling all database infrastructure needs for the client site. This includes new database builds, support, engineering, deploying schema changes to production databases while maintaining DB availability targets, implementing security...


  • Vancouver, Canada Binance.us Full time

    Launched in 2019, Binance.US is the fastest growing and most integrated digital asset marketplace in the United States, powered by matching engine and wallet technologies license from the world’s largest cryptocurrency exchange - Binance. Our mission is to provide liquidity, transparency, and efficiency to financial markets by creating products that...


  • Vancouver, Canada Breakdown Services, Ltd. Full time

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. This position works together with the Production DBA and the Senior Software...


  • Vancouver, Canada Breakdown Services, Ltd. Full time

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. This position works together with the Production DBA and the Senior Software...


  • Vancouver, British Columbia, Canada Themesoft Inc. Full time

    Role: MSSQL Database Admin Location: Vancouver/Calgary – Hybrid working with 3 days from office. Contract will be for 1 year+ Strong intermediate to senior SQL Server DBA ~ SQL Server must be the primary database ~Skills required: duplications, back-up, replication, SSIS, SSRS, SSAS, ETL, foundational SQL ~ Not looking for architects, Big Data/HADOOP...


  • Vancouver, Canada Binance.US Full time

    Launched in 2019, Binance.US is the fastest growing and most integrated digital asset marketplace in the United States, powered by matching engine and wallet technologies license from the world’s largest cryptocurrency exchange - Binance. Our mission is to provide liquidity, transparency, and efficiency to financial markets by creating products that...


  • Vancouver, Canada Samsung Electronics Full time

    Position Summary We’re looking for a highly motivated Database Administrator to join our Cloud Engineering team. If you want to work for one of the most recognized brands in the world and one of the Top 100 Employers in Canada, then please keep reading! What We Offer: - Hybrid Work - Competitive Salary - RRSP Matching - Employer Paid Flexible Health...


  • Vancouver, British Columbia, Canada Themesoft Inc. Full time

    Company OverviewAt Themesoft Inc., we are seeking a highly skilled and experienced Senior Database Administrator to join our team. As a key member of our database services group, you will play a critical role in ensuring the reliability, scalability, and performance of our enterprise operational database environments.


  • Vancouver, Canada WATERMAN'S MARKETING INC. Full time

    **Tasks**: - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models **Supervision**: - 1 to 2 people **Computer and technology knowledge**: - Database software -...


  • Vancouver, Canada Ntirety Full time

    **POSITION PURPOSE**: The PostgreSQL Database Administrator is responsible for being part of a team of Database Administrators remotely supporting multiple database installations on our client's systems all over the world. In order to be eligible for the Employee Bonus Plan, all employees are required to be performing their job duties satisfactorily during...


  • Vancouver, Canada Ntirety Full time

    **POSITION PURPOSE**: The PostgreSQL Database Administrator is responsible for being part of a team of Database Administrators remotely supporting multiple database installations on our client’s systems all over the world. In order to be eligible for the Employee Bonus Plan, all employees are required to be performing their job duties satisfactorily...


  • Vancouver, Canada Ntirety Full time

    **COMPANY OVERVIEW**: When it comes to a cybersecurity crisis, the question is not if, but when it will happen - that’s why Ntirety’s mission to provide proactive compliant security is crucial in today’s business landscape. No matter what role or department you work in, being a part of Ntirety means supporting all of our different teams to help keep...


  • Vancouver, Canada Ntirety Full time

    **COMPANY OVERVIEW**: When it comes to a cybersecurity crisis, the question is not if, but when it will happen - that's why Ntirety's mission to provide proactive compliant security is crucial in today's business landscape. No matter what role or department you work in, being a part of Ntirety means supporting all of our different teams to help keep our...


  • Vancouver, Canada Alida Full time

    Postgres skills are essential for this position. We would like to see Oracle exposure and nice to have some SQL server as well. Must be open to learning these skills in order to support 24/7 uptime of all database systems. **Responsibilities**: - Manage postgres Databases in multiple AWS regions through many product lifecycle environments, from development...


  • Vancouver, Canada Motorola Solutions Full time

    Company Overview At Motorola Solutions, we believe that everything starts with safety. It’s the constant that empowers people to confidently move forward. It can fill a flight or sell out a stadium. It can care for a patient or graduate a class. As a global leader in public safety and enterprise security, we create and connect the technologies that help...


  • Vancouver, Canada Ignite Technical Resources. Full time

    **Database Administrator (SQL) - Contract position in Vancouver (hybrid model).** On behalf of our client in **Vancouver,** **Ignite Technical Resources** is looking for a **Database Administrator (SQL).** **Role Description**: **Responsibilities**: - Develop plans for providing reliable, recoverable, and scalable database/computing environments to store...