PostgreSQL DBA - Shoreditch, London, UK
Greg Clough <[email protected]> Wed, 13 Dec 2017 12:41:02 +0000
| Newsgroups | gmane.comp.db.postgresql.jobs |
|---|---|
| Message-ID | <363BBEA35743F446BDCE9C3A149D5DB8BE444A@EXCH45CHUK03.uk.corp.local> |
WHY IPREO: Imagine a job where you... * Work directly with senior managers on a regular basis * Have a meaningful impact on the mission-critical products and services th= at clients rely on every single day * Collaborate with colleagues across business lines and regions At Ipreo, this is true for EVERY MEMBER of our global organization! Our tec= hnology solutions and analytical insights are relied upon by every major in= vestment bank and thousands of corporations around the world. WHAT'S IN IT FOR YOU: As a PostgreSQL Database Administrator, you will join a talented and dedica= ted team of database professionals with extensive experience in supporting = critical applications. You will work closely with your colleagues on the de= velopment team and in other technology groups. You will gain exposure to ex= perts on financial markets responsible for crafting our leading products an= d services. Your skills in database administration will be challenged and grow in an ex= citing environment. Your expertise in troubleshooting, analysing query plan= s, tuning SQL and writing advanced pgSQL will be leveraged and grow extensi= vely. You will utilize best practices to provide the highest quality and mo= st reliable support. You will be involved in identifying and implementing o= ngoing improvements to these practices. WHAT YOU'LL WORK ON: You'll perform both administrative and some development related work. Admi= nistrative functions are of course the primary focus of this role and will = include installations, upgrades, backups, replication and disaster recovery= setup, monitoring and capacity planning. Development related work will in= clude scripting changes for installations, and tuning of SQL statements, st= ored procedures, and indexes. Troubleshooting skills will certainly be a c= ritical success factor. This is a 24/7 rotational environment where each team member must be open t= o and available for night and weekend work in accordance with the team's sc= hedule. Day-to-day responsibilities will include, but not be limited to the followi= ng tasks: * Perform installations and upgrades of PostgreSQL * Manage database backups * Define maintenance plans * Configure replication * Setup disaster recovery * Monitor servers * Capacity planning * Script database changes * Tune SQL statements * Optimize stored procedures * Analyse query plans * Write advanced pgSQL * Troubleshoot problems * Writing scripts What we look for: * BA or BS required or equivalent related work experience * 2-4 years of experience in Database Administration with PostgreSQL * Ability to work nights and weekends as required * Knowledge of or experience writing SQL queries and/or other SQL developme= nt * Strong PostgreSQL troubleshooting skills * Linux/CentOS experience * Strong verbal and written communication skills * Self-starter and ability to work independently * Oracle experience is a plus Apply Here: https://ipreo.wd1.myworkdayjobs.com/en-US/IpreoExternalCareers= Site/job/London/Postgress-DBA_R1147 Some more details on me: https://www.linkedin.com/in/gclough/ Greg Clough Senior Technology Engineer Ipreo Castle House | 37-35 Paul St | London EC2A 4LS ________________________________ ****************************************************************** This e-mail message and any attachments are confidential. Dissemination, di= stribution or copying of this e-mail or any attachments by anyone other tha= n the intended recipient is prohibited. If you are not the intended recipie= nt, please notify Ipreo immediately by replying to this e-mail, and destroy= all copies of this e-mail and any attachments. Thank you! ******************************************************************