Welcome
View Jobs
Job Details
BackBack
Company Overview

AeroInfo Systems is a division of Boeing Canada based in Richmond, B.C. and is a world class provider of aircraft operations information technology products and services. Our present passengers (customers) include major airlines and aircraft manufacturers. If you are motivated, creative with a positive attitude, and looking for state-of-the-art technology, you can be a crew member of one of the greatest companies in the aerospace industry.

 

 AeroInfo Systems, A Boeing Company, is gaining altitude and we want YOU to be on board as we continue to soar to new heights!

What do you get? Beyond just a paycheck
  • Must be able to provide afterhours on-call support and work modified shifts then necessary
  • Must be able to lift moderately heavy equipment (e.g. servers, desktops, etc.)
  • Outstanding organizational skills, ability to prioritize effectively, and experience with technical project management.
  • Highly service-oriented, reliable, responsible, self-motivated, and enthusiastic.
  • Excellent communication skills and ability to interact professionally with a diverse group of customers and staff.
  • Ability to interact with all levels of an organization in a professional, diplomatic and tactful manner.
  • Ability to work productively in cross-functional teams or resourcefully and independently as an individual.
Title Senior Systems Administrator (Database Administrator)
Excited Yet? Position Details The Senior Systems Administrator is responsible for providing advanced systems administration of AeroInfo’s Corporate IT infrastructure, 3rd Level escalation support for complex issues and provides technical leadership for IT department managed projects which includes coordination of implementations, upgrades, migrations and IT problem management. Senior Systems Administrators will assist management with technical direction to ensure the highest levels of infrastructure availability, capacity and will assist with the development of long-term IT strategies that aligns with AeroInfo’s strategic initiatives and corporate goals.
Responsibilities

 Database Administration

  • Establishes IT department standards for SQL Server administration based on industry best practices
  • Provides production Microsoft SQL Server administration which includes performance monitoring and tuning, clustering (high-availability), data migration and backup/recovery strategies.
  • Provides operational support and automates SQL server administration through SQL scripts and writing stored procedures
  • Provides guidance as a technical liaison between IT and Finance departments.
  • Develops SQL Server Reporting Services (SSRS) reports
  • Develops and deploys SQL Server Integration Services (SSIS) Packages
  • Maintains custom interface tools and applications based on .NET
  • Assist application development teams with a focus on storage, performance and availability design.
 
Systems & Network Administration
  • Provides advanced server administration and maintenance. 
  • Designs and leads projects for the implementation, upgrade and/or migrations of corporate business applications with management and end-user community.
  • Establishes standards enterprise patch management and helps to maintain and enforce IT Security and ISO 27002 controls
  • Designs, implements and optimizes enterprise backup and disaster recovery practices.
  • Trains and mentors other junior team members and actively participates in knowledge sharing efforts

 

Support Coverage

  • Provides seamless, escalated 3rd level technical support for complex technical issues
  • Provides overflow and backlog Incident Request support 

 

IT Projects
  • Leads on corporate IT projects and assists IT management with development of efficient project charters, resource planning, risk and communication plans
  • Facilitates and trains IT department staff during project transitions and “hand-offs” to operations.
Requirements
  • Bachelor of Science degree in Computer Science, Information Systems or equivalent work experience. 8 years or more of related technical experience may be substituted for degree requirements.
  • At least 8 years of experience in IT Infrastructure support and server administration in a medium-sized environment (200 - 1000+ server

         systems)

  • At least 8-10 years experience supporting and troubleshooting distributed, N-Tier applications, software and operating systems.
  • At least 1 premiere IT Certification: Microsoft MCSE, Cisco CCNP, VMware VCAP, CISSP, etc.
  • Advanced knowledge of Windows Server OS. Knowledge of Macintosh OS X, Linux and Unix is a plus.
  • Ability to quickly learn new technologies and keep abreast of the latest technological advances.
  • Strong experience with enterprise administrative scripting using a major scripting language (Perl, VBS, PowerShell, Batch Programming)
  • Advanced knowledge of Microsoft SQL Server 2005, 2008
  • Strong knowledge of T-SQL scripting and stored procedure development (PL/SQL is a plus)
  • Experience with transactional and merge SQL server replication
  • Strong experience with database performance and query optimization
  • Outstanding organizational skills, ability to prioritize effectively, and experience with technical project management.
  • Experience with hardware and software procurement and managing vendor relationships.
City Richmond
State/Province British Columbia [BC]