Postres DBA job posting BC Canada
Amador Alvarez <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.jobs |
|---|---|
| Message-ID | <CA+vGRthgU981c1fWFqC-kwGpigHq1-8x0Fhp=a5OtjVpx_ahnA@mail.gmail.com> |
> > > 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, > > [email protected] > ** > > > ** > > * > * >