View all jobs
Senior Database Developer
Cambridge, MAYou will be responsible for administering and maintaining the Oracle database infrastructure for an in-house application. This database includes intellectual property tracking, accounting, and document management to enable the TLO staff to provide the best quality service to the community in the management of our intellectual assets.
Position Summary:
You will be responsible for the daily administration of the Oracle database and its support of the application. You would also be responsible for technical support on application and data integrations with the primary database (e.g. Tableau reporting, Microsoft Access data export/import).
Responsibilities:
- Administration of the Oracle database that supports the app.
- Provide ongoing support for TLO staff and other users of the app including troubleshooting end user hardware/software issues and connectivity issues
- Consult with TLO staff to design and implement enhancements to existing database tables/views, PL/SQL code and reports
- Work with TLO staff and external vendors on upgrades and bug fixes as required
- Create and provide information and reports to the Director and other TLO staff as requested
- Work closely with the external vendor, Project Manager, and TLO IT and Website Manager to assist in the upgrade to a new IP database
- Ensure cost effective management of IT related costs
- Serve as a liaison for the TLO to: IT consultants, vendors and central IT resources within MIT
- Establish, manage and maintain standards and systems for security of data in the TLO
- Prepare system and user documentation as needed
Qualifications and Technical Skills:
- 2-3 years of experience in Oracle database administration
- 5-6 years of experience with Oracle database development (SQL and PL/SQL)
- Experience with Tableau Desktop
- Familiarity with document management platforms
- Experience with Linux and/or Unix operating systems
- Experience with Microsoft Windows (7/10) desktop operating systems
- Excellent problem-solving, and troubleshooting skills
- Ability to work independently and to exercise good judgment and discretion in the performance of all work assignments
- Strong organizational skills and attention to detail and ability to manage multiple projects simultaneously
- Strong interpersonal skills that reflect courtesy, diplomacy, and a collaborative approach to develop and maintain effective working relationships with end users and customers of the TLO
- Excellent written and verbal communication skills; be able to explain the work in plain language to management with no data experience