As a Database Administrator you will be responsible for assisting in the administration, design, implementation, and repair of the various databases used throughout the organization.
Working some weekends and evenings may be required. This is a unique opportunity to join a team that will be able to set the company up for success. This position is permanent full-time, and includes a competitive base salary and full benefits package. This position is located in Victoria.
Key Accountabilities
Ensure high volume transactional database availability and performance meets the organization’s requirements.
Define database design and infrastructure standards in conjunction with the development team.
Assume responsibility for database related problems; pursue root cause analysis and problem resolution
Optimize existing queries. Identify and tune slow queries to improve performance
Implement database best practices and research evolving database standards
Produce suitable documentation
Develop and implement appropriate monitoring and alerting scripts
Participate in code reviews and provide recommendations and guidance to developers about database matters
Writing custom reports to satisfy business stakeholders
Education and Experience
5+ years of progressive experience managing high volume transactional databases.
The candidate must possess the ability to work independently in a dynamic work environment.
We primarily run PostgreSQL but experience with any of the following will be acceptable:
PostgreSQL (preferred)
MySQL
Oracle
A good understanding of database replication architectures and processes
Systems administration experience in a Linux environment is required
Excellent SQL knowledge and ability
Experience writing stored procedures, views, partitioning, and triggers.
Must be available to work on-call after regular business hours (weekly rotation)
Excellent communications skills (verbal and written)
Development experience an asset (python, shell, php)
Experience with NoSQL (Riak, MongoDB,CouchDB) an asset
Computer Science or related degree, or equivalent combination of education and experience.
Candidates must be authorized to work in Canada.
Please send me an email if you are interested or you needed more details,