Position Overview
As a team member of the software development team you will be developing product features from internal and external customer requirements and clinical feedback.
Internally known as Senior Database Administrator.
Company Overview
At FUJIFILM Healthcare Americas Corporation were on a mission to innovate for a healthier world and we need passionate driven people like you to help us get there. Our cutting-edge healthcare solutions span diagnostic imaging enterprise imaging endoscopic and surgical imaging as well as in-vitro diagnostics.
But we dont stop at healthcare; our Non-Destructive Testing (NDT) team harnesses advanced radiography solutions to keep transportation infrastructure aerospace and oil and gas assets safe and running smoothly.
Ready to innovate collaborate and make a difference Join us and bring your big ideas to life while working in a dynamic flexible environment that fuels your creativity and drive.
Our headquarters is in Lexington Massachusetts an inspiring healthcare research hub in a historic town.
Fujifilm is globally headquartered in Tokyo with over 70000 employees across four key business segments of healthcare electronics business innovation and imaging. We are guided and united by our Group Purpose of giving our world more smiles. Visit : Description
Duties and Responsibilities :
- Complete the application of standard database technologies to software design implementation and testing.
- Working closely with other team members to coordinate assignments and communicate progress and / or difficulties.
- Interact with database vendor and support customer site databases as required.
- Application of standard database technologies to software design implementation and testing.
- Interact with database vendor and support customer site databases as required.
- Develop Oracle Stored procedures / Functions.
- Develop specialized data correction scripts.
- Develop mechanisms to resize the database based on customer needs
- Investigate Database performance bottlenecks using vendor provided tools
- Develop Database installation scripts using SQL PL / SQL PowerShell and windows scripting host.
- Develop database automated backup and recovery scripts per database vendors guidelines.
- Develop database upgrade scripts.
- Experience with converting Oracle databases to a postGreSQL DB.
- Develop mechanisms to ensure that the database meets its high availability goals.
- Review Oracle software releases like CPU patches.
- Develop Oracle silent installation scripts and integrate with the installation scripts.
- Review and implement various Oracle add-on options like Advanced Security Encryption.
- Performing with other duties as assigned.
- Comply with all applicable U.S. Food and Drug Administration (U.S. FDA) medical device regulatory requirements applicable ISO 13485 standard requirements and all other applicable laws regulations and standards.
Qualifications
Essential
BS or BE in Computer Science or related field.Excellent verbal and written communication skills.Proven problem-solving skills.Strong Database development discipline with a keen inclination to database security and maintaining database uptime.At least 7 years real-world database development experience that must include :In-depth database design such as entity relationship modeling
Working and complying within the overall product architecture with a focus on database performance.Being a pragmatic team player who can demonstrate initiative.Having the ability to work independently and meet deadlines.Expertise in developing software that runs on Windows Server platform () using the latest Oracle (12c 19c 23ai) database with a focus on Oracle installation backup and recovery High AvailabilityFrom a technology perspective must be :An expert in Oracle PL / SQL and related Oracle technologies.
Experienced dealing with Oracle Support and resolving time critical issues with various Oracle support tier members.Experienced in Oracle 19c 23ai Active Data Guard Oracle Real Application Clusters(RAC).Experienced in identifying and tracking Oracle performance bottlenecks within the application dbmsmonitor SQL monitoring AWR EM Tkprof.Experienced in Oracle RMAN backup and recovery Oracle Universal InstallerGood working knowledge of Oracle options like Advanced Security Encryption Compression etc.Good knowledge with Database access layers SQLNET Oracle Network and security layers (SSL etc.)Familiar with web technologies Microsoft IIS nodejs.Familiar with other development tools Microsoft VS TFSMinimal experience with non-Oracle Database technologies like SQL Server or any open source database like PostGres.Desired
Certified on Oracle productsNice to have exposure to :Agile / scrum development.
Non-Oracle technologies PostGres Mango MySQLExperience with one or more general purpose programming languages including but not limited to : C / C C# JavaScript HTML CSS PL / SQL SQL PlusPrevious experience in back-end PACS developmentFamiliar with cloud technology cloud databasesPhysical requirements :
The position requires the ability to perform the following physical demands and / or have the listed capabilities :
The ability to sit 75-100% of applicable work time.The ability to use your hands and fingers to feel and manipulate items including keyboards up to 100% of applicable work time.The ability to stand talk and hear for 25% of applicable work time.The ability to lift and carry up to ten pounds up to 20% of applicable work time.Close Vision : The ability to see clearly at twenty inches or less.Travel :
Occasional (up to 10%) travel may be required based on business need.In the event that COVID-19 vaccine mandates issued by the federal government or by state or local government become effective and enforceable the Company will require that the successful candidate hired for positions covered under relevant government vaccine mandate(s) be fully vaccinated against COVID-19 absent being granted an accommodation due to medical or sincerely held religious belief or other legally required exemption.
Applicants to positions where vendor credentialing or other similar requirements exist to enter facilities will be required to comply with the credentialing requirements of the facilities including complying with vaccine requirements.
For all positions the Company encourages vaccination against COVID-19 and requires that the successful candidate hired be willing to test for the COVID-19 virus periodically and wear a face covering indoors as required absent being granted an accommodation due to medical or sincerely held religious belief or other legally required exemption
EEO Information
Fujifilm is committedto providing equal opportunities in hiring promotion and advancement compensation benefits and training regardless of nationality age gender sexual orientation or gender identity race ethnicity religion political creed ideology national or social origin disability veteran status etc.
ADA Information
If you require reasonable accommodation in completing this application interviewing completing any pre-employment testing or otherwise participating in the employee selection process please direct your inquiries to our HR Department ( or ).
Required Experience :
Senior IC
Key Skills
Databases,SQL,High Availability,PL / SQL,Solaris,Microsoft SQL Server,Database Design,Performance Tuning,MySQL,Shell Scripting,Database Administration,Oracle
Employment Type : Unclear
Department / Functional Area : Engineering
Experience : years
Vacancy : 1