Permanent DBA position - New Zealand

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
requirementsInstall, configure, and test new databases, perform version
upgrades of existing databasesPerform DB profiling and optimization; analyze
and propose schema changes to PostgreSQL databases as neededProactively
monitor activity, utilization, exceptions and database health; propose and
deploy appropriate improvements; automate repetitive tasksProduce 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
databasesCollaborate with the Infrastructure Architect to create and
maintain database technology roadmaps and deployment plansPerform 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 standardsWork 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 environmentsDesign, implement and maintain
archival and high availability strategiesAct as the final point of
escalation and resolution for database related issuesProvide advanced
technical support for application developers*Requirements*Highly motivated
“self-starter” capable of managing large pieces of a project without direct
managementSolid experience with PostgreSQL and PostGIS in a Linux
environment is a mustAble to tune PostgreSQL server settings based on
application and environmentAbility to write complex SQL and stored
proceduresHave 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 etcAble to perform capacity planning
which supports the forecastingConsistently learning about trends and
features in DB solutions, able to bring best practices to bear in solving DB
and overall application problemsAbility to work in a high availability
production environment where unplanned downtime is not acceptableGood
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 dataExperience with standard
PostgreSQL tools pgpool, PgBouncer, PL/Proxy and pgFouine to name a few
along with nagios monitoringExperience with NoSQL architectures and
databasesScripting or programming experienceExperience with maintaining
infrastructure and maintaining uptimeExperience with database infrastructure
and techniques to achieve high scale in an IaaS environment like
AWShttp://careers.eroad.co.nz/vacancies/showVacancy/11



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Permanent-DBA-position-New-Zealand-tp5730268.html
Sent from the PostgreSQL - jobs mailing list archive at Nabble.com.