Software Developer III
US - CA - San Francisco
We are hiring an experienced Postgres developer for our Oracle to Postgres database migration project. The candidate will be working as a senior member in our team, responsible for coding, testing, performance tuning and capacity planning with Postgres database during the migration. You will work with a group of experienced developers and QA testers in San Francisco and Beijing. You can work remotely or in our San Francisco office.
Reviewing current DB schema in Oracle and identify potential issues when moving to Postgres and suggest solutions, so that DB design, workflow etc. can be modified.
Migrate schema including stored procedures from Oracle to Postgres, and review modified schema to identify and suggest solutions to potential problems ahead of time.
Optimize queries, DB configurations, replication, fail-over, vacuuming, clustering, etc. based on the application workload.
Work with production DBA to prepare production hardware spec, optimize configurations, and do capacity planning for production.
Solve problems that come up during migration of schemas, for features not supported in Postgres and recommend optimum alternatives.
Suggest strategies for database migration, use of tools if needed, rollback strategies etc.
Applicants must have a strong background in Postgres database application development.
Minimum 3 years of Postgres application development experience, and prior Oracle experience
Experiences in Postgres pgSQL applications, performance and capacity tuning, data replication, HA design, and clustering.
Worked on database migration (into Postgres) projects
Be able to work independently and is a problem solver.
Good communication and collaboration skills, good team player.
6 months but may extend depending on project needs