Date: Tue, Sep 23, 2008 at 3:27 PM
Subject: PostgreSQL DBA job - contract to hire
To: selenamarie@gmail.com
Here is a copy of the job description:
Job Description:
Title: PostgreSQL DBA
Duration: 6 Months - FTE
Location: Lake Oswego, OR
Minimum 5 years of progressive experience performing PostgreSQL administration production environment; experience should include three or more years of database administration in an enterprise level environment with very large (> 1 terabyte) databases
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 PostgreSQL databases, perform version upgrades of existing databases
Install, upgrade and maintain all PostgreSQL-related server and administration software
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
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
Act as the final point of escalation and resolution for data related issues
Provide advanced technical support for database developers
Provide 24x7 database support as part of a rotation of DBAs
Design, implement and maintain archival and high availability strategies
Skills and abilities
Exceptional knowledge of the PostgreSQL database platform
Mastery of physical database design
Expertise in configuring, implementing and supporting high availability strategies with database systems including clustering, and replication
Mastery of ANSI SQL and/or PL-SQL
Experience in software development using Perl, Shell, or other scripting languages
Solution focused and methodical, careful attention to detail
Solid background using UNIX operating systems – Ubuntu Linux administration a plus
Experience with SQL Server and/or Oracle database platforms is desirable
Ability to perform capacity planning which supports the forecasting and purchasing processes
Ability to implement Database security safeguards and audit them
Consistently learning about trends and features in DB solutions, able to bring best practices to bear at solving DB and overall application problems
Ability to work in a high availability production environment where unplanned downtime is not acceptable
Ability to communicate ideas and designs to all stakeholders, including non-technical audiences
--
Selena Deckelmann
PDXPUG - http://pugs.postgresql.org/pdx
Me - http://www.chesnok.com/daily
No comments:
Post a Comment