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: Permanent DBA position - New Zealand
Sent from the PostgreSQL - jobs mailing list archive at Nabble.com.
