EROAD is a rapidly growing company in size, customers, features and data. We are looking for an experienced DBA to take ownership of large databases (Terabytes) and support on-going scalability efforts as EROAD’s global growth continues. Responsibilities Collaborate with others to determine and deploy database solutions to business prioritized requirements, including business continuance and information security along with functional requirements Install, configure, and test new databases, perform version upgrades of existing databases Perform DB profiling and optimization; analyze and propose schema changes to PostgreSQL databases as needed Proactively monitor activity, utilization, exceptions and database health; propose and deploy appropriate improvements; automate repetitive tasks Produce score card reports against KPI’s showing trends and progress against continuous improvement targets. Collaborate with team members to create, publish and maintain database deployment methods and procedures for PostgreSQL databases Collaborate with the Infrastructure Architect to create and maintain database technology roadmaps and deployment plans Perform database backup and recovery duties; establish standards and schedules for database backups; develop and routinely test recovery procedures for each database; ensure that backup schedules meet the recovery requirements and conforms to all database and data quality policies and standards Work closely with project teams to ensure project success; coordinate product releases, data structure evolution, and manage and synchronize data promotions between development, test and production environments Design, implement and maintain archival and high availability strategies Act as the final point of escalation and resolution for database related issues Provide advanced technical support for application developers Requirements Highly motivated “self-starter” capable of managing large pieces of a project without direct management Solid experience with PostgreSQL and PostGIS in a Linux environment is a must Able to tune PostgreSQL server settings based on application and environment Ability to write complex SQL and stored procedures Have the ability to think holistically within the system and databases beyond just tuning queries and indexes – think horizontal scale, sharding, in-memory DB where suited etc Able to perform capacity planning which supports the forecasting Consistently learning about trends and features in DB solutions, able to bring best practices to bear in solving DB and overall application problems Ability to work in a high availability production environment where unplanned downtime is not acceptable Good communication skills and an ability to build strong working relationships with customers, business and technology stakeholders at all levels Nice to have Requirements Experience with GIS data Experience with standard PostgreSQL tools pgpool, PgBouncer, PL/Proxy and pgFouine to name a few along with nagios monitoring Experience with NoSQL architectures and databases Scripting or programming experience Experience with maintaining infrastructure and maintaining uptime Experience with database infrastructure and techniques to achieve high scale in an IaaS environment like AWS http://careers.eroad.co.nz/vacancies/showVacancy/11 -- View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-DBA-Job-New-Zealand-tp5773156.html Sent from the PostgreSQL - jobs mailing list archive at Nabble.com. -- Sent via pgsql-jobs mailing list (pgsql-jobs@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-jobs
