Database Administrator

<p>BCMEA represents&nbsp;49 waterfront employers comprised of ship owners, agents, stevedores, container &amp;&nbsp;cruise ship terminal operators, and by extension more than 8,500 longshore men and women. We optimize our members&rsquo; operations&nbsp;through our expertise in labour relations, safety &amp; training, and recruiting.</p> <p>Our&nbsp;member companies are a vital part of the BC economy&nbsp;&amp; a mainstay of the coastal community, operating 24 hours/day, 365 days/year,&nbsp;&amp;&nbsp;moving 60 million tonnes of goods</p>

Vancouver, BC

BC Maritime Employers Association

<p>The BCMEA represents approximately 49 waterfront employers and, by extension, the more than 8,500 men and women who work for them. Our customer- members are ship owners and agents, stevedores, container and cruise ship terminal operators. We help optimize our members&rsquo; operations by adding our expertise in labour relations, safety &amp; training, and recruiting.</p> <p>BCMEA member companies are a vital part of the BC economy and a mainstay of the coastal community. Operating 24 hours a day, 365 days a year, our partners move 60 million tonnes of goods worth 53 billion dollars around the globe every year. If you&rsquo;ve got it, we helped you get it.</p> http://www.bcmea.com/

keywords: database,teamwork,reporting,leadership,technical,develop,teamwork,code,document,oversee,microsoft,establish,planning,database,performance,experience,knowledge,skills,database,code,degree,analysis

Full Time

Salary + Benefits

Overview: <p>Reporting to the Manager, Software Engineering, the purpose of a Database Administrator is to design, develop and maintain our enterprise databases.&nbsp; The position will be responsible for all aspects of the data layer including overseeing database policies, standards and processes.&nbsp; The role actively participates in team projects including the development and maintenance of application data layer as well as leading data integration projects.</p>
Responsibilities: <p>Develop database standards, policies and processes for the team:</p> <ul> <li>Develop database architectures and data models following best practices</li> <li>Provide leadership and strategy in data warehousing and analytics</li> <li>Mentor and train team members with modern day database administration best practices including query optimization, database tuning, database and application troubleshooting</li> <li>Continuously learn new product features in the core Microsoft products and in 3rd party tools, to be able to make recommendations that improve operations</li> <li>Document internal systems and processes relevant to the database team</li> <li>Liaise with third party vendor technical support to communicate and resolve issues</li> </ul> <p>&nbsp;</p> <p>Ensure databases have high integrity, high availability and are always running optimally:</p> <ul> <li>Optimize and refactor existing T-SQL code in stored procedures, functions &amp; triggers to reduce system complexity and eliminate technical debt</li> <li>Provide standby database support for highly critical applications when necessary</li> <li>Monitor and troubleshoot functional and performance database issues</li> <li>Work as part of a team and provide 24x7 support when required</li> </ul> <p>&nbsp;</p> <p>Plan, organize and execute routine databases maintenance:</p> <ul> <li>Oversee the installation, configuration, upgrade and patching of database servers and related products periodically and coordinate test plans with team members to ensure systems are functioning appropriately</li> <li>Establish and maintain backup and recovery policies and procedures</li> <li>Manage regular security reviews of data vulnerability scan and remediation of open vulnerabilities</li> </ul> <p>&nbsp;</p> <p>Participate in cross functional team projects and improvement efforts:</p> <ul> <li>Provide leadership in data integration projects including the design, development, testing and maintenance of Web Services, WebAPI&rsquo;s and SSIS packages</li> <li>Assist in Application Rewrites and New Strategic Initiatives by collaborating with team members on the data model and data layer development</li> <li>Contribute to the technical quality of new application by ensuring data integrates well with legacy applications</li> <li>Provide support to developers by troubleshooting and communicating database issues</li> </ul>
Requirements: <ul> <li>Excellent interpersonal skills and able to communicate with a wide range of audiences across the organization, including management</li> <li>Expert in T-SQL with the ability to refactor and optimize complex legacy code</li> <li>Strong SQL Server experience including SSIS, SSRS, index analysis</li> <li>Advanced knowledge of SQL Server AlwaysOn and HADR concepts</li> <li>Expertise in replication and mirroring</li> <li>Strong interest and ability to analyze systems for availability and reliability</li> <li>Hands on experience with SQL Server 2012, 2016, 2017</li> <li>Experienced in MySQL database administration</li> <li>Experienced in .NET Framework, Entity Framework Core and Powershell</li> <li>Knowledge of dimensional modelling techniques to support analytics processes</li> <li>Knowledge of SDLC, Agile, Scrum</li> <li>Awareness of Docker and Kubernetes</li> <li>Awareness of NoSQL data persistence technologies</li> <li>Degree in computer science or equivalent discipline</li> <li>8+ years of hands on experience in a Database Administrator role</li> </ul>