Current jobs related to Database Administrator - Vancouver - Rocky Mountainer


  • Vancouver, Canada Azad Technology Partners Full time

    Overview Join AZAD Technology Partners as a Database Administrator and work with a team responsible for overall development, enhancement, operations and maintenance of enterprise databases. This role provides database administration support for all systems operating on the Control Center Network and supports Database Management Systems, Business...


  • Vancouver, Canada Azad Technology Partners Full time

    OverviewJoin AZAD Technology Partners as a Database Administrator and work with a team responsible for overall development, enhancement, operations and maintenance of enterprise databases. This role provides database administration support for all systems operating on the Control Center Network and supports Database Management Systems, Business Intelligence...


  • 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

    **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 Treez, Inc. Full time

    Treez is not for everyone. Are you right for Treez? The company values at Treez are: - **S**tay Curious - **P**resent Solutions - **E**mbrace Simplicity - **E**ncourage Candor - **D**rive to Outcomes With **SPEED**, Treez team members are making an impact at our growing startup. We are motivated by our mission and do what it takes to get the job done. We...


  • Vancouver, Canada Long View Systems Full time

    Long View. A career that helps you get more out of life. A Long View career helps you get more out of life. We don’t just say it, we prove it. Every day. We’re proud of our reputation as one of North America’s most dynamic IT providers — and we’re even prouder of our culture that allows our people to live life to its fullest. At Long View, we...


  • 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 Colton’s Couture International Full time

    Education: College/CEGEP - Experience: 2 years to less than 3 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Develop and implement data administration policy, standards and models - Research and document data requirements,...


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

Database Administrator

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