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 PostgreSQL experience to work for a 12 month contract in Southborough, MA?
Job DescriptionTitle: Sr. Database Developer
Location: Southborough, MA
Duration: 12 month project
Visa: 1099, W2 Direct candidates preferred
From the hiring manager: We must have a resource who has experience in PostgreSQL and migrating dB from Oracle to PostgreSQL. They must have advance knowledge with PostgreSQL.
DESCRIPTION:
We are looking for a Sr. Database Developer with strong Database migration (from 11i to PostgreSQL) 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 (PostgreSQL)
• 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 PostgreSQL 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 PostgreSQL 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
Thanks and Regards
Ahmed
Sr. Technical Recruiter
Phone: 781-797-1032
Additional InformationSkills Required
- Advanced PostgreSQL experience, including PostgreSQL 9.4
- Oracle 11g experience
- Database migration experience from Oracle 11i to PostgreSQL
- Experience migrating schemas, stored procedures, packages, and database links
- Ability to convert Oracle packages and stored procedures to PostgreSQL functions
- SQL and PL/SQL scripting skills, including stored procedures and PSQL scripting
- Database performance tuning experience
- Ability to troubleshoot and resolve database system issues during migration
- Strong analytical, problem-solving, and troubleshooting skills
- Ability to work with technical and business teams
- At least 5 years of relevant industry experience
- Continuous integration and deployment experience, especially Jenkins
- Understanding of ORM development, such as iBatis or Hibernate
- Pivotal Cloud Foundry experience
What We Do
XpertTech is an IT and business-process outsourcing company that helps businesses operate and scale through staffing, managed IT services, mobile and other application development, digital marketing, finance and accounting, and HR and payroll solutions. It provides remote professionals and dedicated support across operational functions, combining technology services with back-office outsourcing to reduce overhead and streamline day-to-day business processes for growing organizations.
