Sr. Database Developer

Hope you are doing well! We have an immediate opening for a Sr. Database Developer from one of our esteemed client Located in Southborough, MA.

Please let me know if you would be interested in this position.

Do you have any Postgre

SQL experience to work for a 12 month contract in Southborough, MA?

Location:

Southborough, MA

Duration: 12 month project

From the hiring manager:
We must have a resource who has experience in Postgre

SQL and migrating dB from Oracle to Postgre

SQL. They must have advance knowledge with Postgre

SQL.

DESCRIPTION:

We are looking for a Sr. Database Developer with strong Database migration (from 11i to Postgre

SQL) experience on online solutions including continuous integrations and establishing DB Links between two different databases. As a Sr. Database Developer you will drive the continued migration activities of our web-based application to bring new ideas and technologies to the table.

As part of these migration activities, you will work with other team members based in Southborough, MA to ensure migration activities will be done as per the schedule with a high standard. You will have the opportunity to drive regular knowledge sharing sessions with peers. Strong analytical and troubleshooting skills are important, along with a keen focus on delivering value to our customers

Effective communication, collaboration and self-organization are key competencies required from all development team members along with the ability to work in a fast-paced, ever changing environment.

PRINCIPAL DUTIES AND RESPONSIBILITIES

• Work with DBA’s on migration activities including database design where ever is needed and implementation enhancements

• Primary on migrating schemas including SP’s, DB Links etc. from one database (11i) to another database (Postgre

SQL)

• Able to convert Oracle Packages/Stored Procedures to Postgres Functions

• Optimize queries, stored procedures and database design where ever is needed.

• Develop and implement best practices during migration process

• Assist in Defining and implementing maintenance plan for Postgre

SQL database system

• Identify and communicate impediments to your team and actively work to remove them.

• Continually strive for technical excellence.

An Ideal Candidate must have

• Experience in Postgre

SQL 9.4, ORACLE 11g

• Experience in SQL, PL/SQL scripts skill including SPs, PSQL scripting, Postgres Functions

• Experience in performance tuning skills

• Ability to proactively identify, troubleshoot and resolve current database systems issues during the migration process

• Ability to take ownership for initiatives and Problem-solving skills

• Ability to work comfortably with both technical and business teams

Bonus

Skills:

• Experience of Continuous Integration and Deployment (Jenkins)

• Understanding ORM development such as IBatis, Hibernate etc.

• Pivotal Cloud Foundry (PaaS) technologies

5+ years relevant experience in industry