PostgreSQL DBA Job - 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 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.