We are hiring a Senior Postgresql DBA for our head office in Vancouver, BC. This is a full time position requiring you to be onsite (ie – not a remote position). Position Description: Location: Vancouver, BC Term: Permanent Full Time
Global Relay is the world leader in cloud-based messaging, archiving and search technology for the financial sector. Global Relay is headquartered in Vancouver's Gastown, with offices in New York, Chicago, London and
Singapore. We strive to be a top employer and were recognized by numerous awards including Top 10 Best Companies to Work for in BC (2012 and 2011), CEO of the Year (for our CEO Warren Roy in 2012) and Deloitte's list of 50 fastest-growing companies in Canada
(2012).
Since 1999, more than 16,000 firms spanning 90 countries have entrusted Global Relay to securely archive their electronic messaging -- including email, instant messaging, BlackBerry, social media (LinkedIn, Twitter,
Facebook) and more. Our intuitive apps for iPhone, iPad, BlackBerry and Android let people access all their communications anytime, anywhere. With over 200 employees, Global Relay is growing at a rapid pace in Vancouver and internationally. Global Relay provides
fantastic opportunities to individuals with passion in business and technology. For those with international business aspirations, Global Relay offers invaluable exposure to doing business with some of the most influential companies in the world. Global Relay
is also ideal for people who want to create cool technologies using massively scalable "big data" architecture and a strong focus on mobile. Apply today -- we have three floors of great open space offices with a fast-paced vibe, lots of amenities, a roof top deck & BBQ, all located in
the heart of Gastown near Waterfront Station. To learn more about our culture and community involvement, please visit (www.globalrelay.com) The Role:
The Senior Database Administrator is responsible for managing the Global Relay's production PostgreSQL and Microsoft SQL database systems. This includes the development, review, and maintenance of database scripts, custom
reports, data extracts, and ongoing optimization of databases and applications to ensure the highest level of database and application performance. As part of the IT Operations team, the Senior Database Administrator will work closely with business users and
developers to assist in managing updates to staging and production environments. This will include reviewing proposed database changes as well as recommending and implementing changes to optimize performance and ensure high availability. Responsibilities:
·
Monitor and maintain all internal and external PostgreSQL and Microsoft SQL databases
·
Perform routine archiving, security, and auditing related tasks, according to applicable policies and procedures
·
Support client database functions, including data extraction, transformation, and loading (ETL) services
·
Provide management reports, customer reports, and data extracts
·
Conduct research, analysis, and profiling to develop methods to improve database performance, functionality, and availability
·
Plan, communicate, execute, and document database related maintenance and upgrades
·
Assist with space management initiatives and database migration projects
·
Support audit and security processes including access control and user management
·
Make recommendations on existing and future storage and system infrastructure
·
Ensure that all issues in staging and production environments are addressed quickly Qualifications:
·
Minimum of 5 years of experience in database administration, development, and support
·
Experience in Linux / Unix / Windows
·
Experience in PostgreSQL 8.x / 9.x
·
Experience in Microsoft SQL 2005 / 2008
·
Experience in database architecture modeling, design, and implementation
·
Expert knowledge in database performance tuning and query optimization
·
Ability to work with agile teams to support dynamic and high-availability environments
·
Strong knowledge of database backups/restores, clustering, mirroring, and replication
·
Experience in documentation and presentation of technical tasks and implementation plans
·
Thorough knowledge of database design and optimization
·
Excellent technical troubleshooting and issue documentation skills
·
Excellent written and oral communication, problem solving, and organization skills
·
Strong initiative and ability to work under minimal supervision
·
Excellent ability to work in a collaborative team environment
·
Able to meet project schedules and quality standards
·
Able to balance priorities and work under pressure
·
Ability to work in a fast-paced, entrepreneurial, high-tech environment
·
Database certification an asset
·
Linux certification an asset To Apply: Please send your resume to
brian.thompson@xxxxxxxxxxxxxxx Brian Thompson talent acquisition specialist Global Relay Archive supports email, instant messaging, BlackBerry, Bloomberg, Thomson Reuters, Pivot, YellowJacket, LinkedIn, Twitter, Facebook and more.
Ask about
Global Relay Message — The Future of Collaboration in the Financial Services World
|