Eng SW Dev II

Axcelis Technologies•Beverly, MA

1d•$95,086 - $142,628

About The Position

Job Description: Application Database Developer This position is for an individual contributor role contributing to development activities across a span of functional areas. The ideal candidate will have strong technical skills and knowledge of relational database as well as hands on experience in SQL and PL/SQL coding, DB administration, and performance tuning. They will have development experience in large development projects utilizing formal development processes and techniques. They will also be expected to demonstrate strong communication skills for encouraging standards within the team on the best practices to utilize. They will need to show initiative and be very involved in the Requirements, Design and Code Review process to reinforce these practices. Finally, they will need to work well with others especially in the SQA group in preparing review and test plan material and hold well (with extra work time if necessary) to the schedules they create. Overview: Database engineer responsible for designing, implementing, debug and installing Oracle or SQL databases for Axcelis Ion Implanters

Requirements

Expert practical knowledge of: Database design and implementation tasks, techniques, and tools; Physical data modeling; Database modeling tools; The relevant database management systems; The associated data definition, data manipulation, and database query languages (e.g., SQL, PL/SQL, JDBC, ODBC); The programming languages for producing database wrappers and stored procedures; The database design and implementation standards and guidelines.
Solid practical knowledge of: Logical data modeling; the theory, practice, and tools of database management; the major reusable persistence mechanism and patterns; Database security mechanisms; the theory, practice and tools of software engineer.
Basic practical knowledge of the: Application domain; business enterprise of the customer's organization; Integration and database testing theory, practice and tools; Configuration identification, configuration control, and associated configuration management tools.
Education: A bachelor’s degree in computer science, Information Technology, or a related field.
Minimum 2-3 years industry experience.
Technical Proficiency: Expertise in SQL and procedural languages (PL/SQL).
Experience with relational database management systems (Oracle, PostgreSQL, etc.).
Knowledge of database design, data modeling, normalization, and indexing strategies.
In-depth knowledge of Oracle database technologies and tools
Strong problem-solving and analytical skills.
Excellent communication and teamwork abilities
A strong grasp of software development methodologies, such as Agile and Scrum, is expected

Nice To Haves

Master’s degree in computer science is preferred
Experience interacting with user interface software modules is desired.
Familiarity with cloud database services (AWS RDS, Azure Database, etc.) is a plus.
Any previous experience in the semiconductor industry is a plus.
Proficiency in scripting languages like Python or Bash for automation is beneficial

Responsibilities

Design, create, and maintain Oracle databases.
Optimize database performance and ensure data integrity.
Produce the database layer of software components (e.g., database wrappers, stored procedures, triggers etc.).
Produce database loading and batch-processing routines.
Troubleshoot and resolve database-related issues.
Monitor database performance and tune as necessary.
Ensure database security and compliance with data privacy regulations.
Perform data migration and conversion tasks as needed.
Document database architectures and processes.
Take part in the design evaluations.