At a Glance
- Tasks: Manage and optimise Oracle EBS and PostgreSQL databases in a global enterprise environment.
- Company: Join Diodes Incorporated, a leader in tech innovation and collaboration.
- Benefits: Competitive salary, flexible work options, and opportunities for professional growth.
- Other info: Dynamic team environment with opportunities for after-hours support and global collaboration.
- Why this job: Make a real impact by ensuring the reliability of mission-critical systems.
- Qualifications: 5+ years in Oracle DBA and 3+ years in PostgreSQL administration required.
The predicted salary is between 63000 - 77000 £ per year.
Job Description and Responsibilities
Position Summary
Diodes Incorporated is seeking an experienced Oracle E-Business Suite (EBS) and Postgre SQL Database Administrator (DBA) to support mission-critical production and non-production environments.
This role is responsible for database and application administration, monitoring, performance tuning, maintenance, security, backup and recovery, automation, and high-availability solutions across a global enterprise environment.
The ideal candidate has hands-on expertise with Oracle EBS R12.2, Oracle Database 19c, Postgre SQL, troubleshooting, performance optimization, and operational support.
The position requires close collaboration with application, infrastructure, security, and geographically distributed DBA teams.
- Principal Duties and Responsibilities
- Oracle EBS and Oracle Database Administration
- Manage, monitor, and maintain Oracle E-Business Suite R12.2 production and non-production environments.
- Administer Oracle Database 19c environments that support Oracle EBS applications.
- Perform Oracle EBS cloning, patching, upgrades, and scheduled maintenance activities.
- Apply Oracle EBS application and technology stack patches using ADOP and established change-management practices.
- Administer and troubleshoot Oracle Web Logic Server, Concurrent Manager, Workflow Mailer, and related EBS services.
- Diagnose and resolve Oracle EBS application, middleware, database, availability, and performance issues.
- Coordinate EBS deployments and code migrations with application and development teams.
- Support month-end, quarter-end, and year-end business processing activities.
- Plan and validate backup, recovery, disaster recovery, and high-availability procedures.
- Maintain database security, access controls, auditing, and operational documentation in accordance with company standards.
- Collaborate with local and remote DBA, infrastructure, application, and support teams.
- Install, configure, monitor, and maintain Postgre SQL databases in production and non-production environments.
- Perform Postgre SQL upgrades, patching, migrations, backup, recovery, and routine maintenance.
- Configure and maintain Postgre SQL replication technologies, including streaming replication and logical replication.
- Deploy and support Postgre SQL databases in Docker container environments; experience with Kubernetes is beneficial.
- Implement and support high-availability and disaster-recovery solutions.
- Monitor database performance and optimize SQL queries, indexes, memory settings, and database configurations.
- Analyze and resolve database locking, blocking, connectivity, and performance issues.
- Manage database growth, capacity planning, storage utilization, and data-retention requirements.
- Automate routine administration, monitoring, backup, and reporting tasks using shell scripting or other appropriate tools.
- Maintain runbooks, operating procedures, architecture information, and troubleshooting documentation.
- Operational Support and Collaboration
- Participate in scheduled maintenance and provide on-call support for critical database and Oracle EBS incidents, as required.
- Follow incident, problem, change, access-management, and audit-control processes.
- Communicate risks, status, root causes, and remediation plans clearly to technical and business stakeholders.
- Identify opportunities to improve reliability, security, performance, supportability, and operational efficiency.
- Required Qualifications
- Bachelor's degree in Computer Science, Information Technology, Information Systems, or a related field, or equivalent practical experience.
- At least 5 years of Oracle Database administration experience.
- At least 3 years of Postgre SQL database administration experience.
- Strong experience supporting Oracle E-Business Suite R12.2 environments.
- Hands-on experience with Oracle Database 19c administration, backup and recovery, and performance tuning.
- Strong knowledge of Postgre SQL architecture, replication, backup, recovery, security, and performance tuning.
- Experience with Oracle EBS cloning, patching, upgrades, and ADOP.
- Experience administering Linux or Unix platforms; AIX and Linux experience is preferred.
- Experience with database monitoring, diagnostic, and performance-analysis tools.
- Working knowledge of scripting and automation in Linux or Unix environments.
- Excellent analytical, troubleshooting, documentation, written communication, and verbal communication skills.
- Ability to work independently, manage competing priorities, and collaborate effectively in a global team environment.
- Preferred Qualifications
- Experience with Docker and Kubernetes container platforms.
- Experience administering Microsoft SQL Server or My SQL databases.
- Experience with enterprise high-availability, disaster-recovery, security, auditing, and compliance requirements.
- Experience supporting large-scale, business-critical systems in globally distributed environments.
- Provide planned after-hours or weekend support for maintenance, upgrades, and critical production issues when necessary.
- Coordinate effectively across time zones and maintain clear operational handoffs and documentation.
Senior Infrastructure Engineer in Greenock employer: Diodes Incorporated
At Diodes Incorporated, we pride ourselves on being an excellent employer, offering a dynamic work environment at our GFab Manufacturing Facility in Greenock. Our commitment to employee growth is evident through comprehensive training and development opportunities, ensuring that you can advance your career while contributing to innovative projects in the semiconductor industry. Join us to be part of a collaborative team that values your expertise and fosters a culture of continuous improvement and energy efficiency.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Infrastructure Engineer in Greenock
✨Join Local Tech Meetups
Get out there and mingle with fellow developers by joining local tech meetups. It’s a fantastic way to meet people who might be working at Diodes Incorporated or know someone who does. Plus, you can pick up some trendy tech skills and trends while you're at it!
✨Contribute to Open Source Projects
Show off your coding chops by jumping into open-source projects. Not only does this give you practical experience, but it also gets you noticed in the dev community. You'll create a killer portfolio that speaks volumes about your skills to Diodes Incorporated.
✨Tap into Online Developer Communities
Don’t underestimate the power of online developer communities like GitHub, Stack Overflow, and even Reddit. Participate in discussions, share your projects, and build your visibility. We can often find opportunities through these channels that can lead to a full-time gig at companies like Diodes Incorporated.
✨Explore Job Boards Specifically for Tech Roles
Keep your eyes peeled on job boards that focus on tech roles. Sites like TechCareers or Stack Overflow Jobs can often have listings for companies like Diodes Incorporated that might not show up on broader job sites. Make it a habit to check these regularly, and don’t hesitate to apply directly through our website!
We think you need these skills to ace Senior Infrastructure Engineer in Greenock
Some tips for your application 🫡
Show off your coding skills:When applying for a software engineering role, it's super important to showcase your coding skills. Make sure your CV includes your tech stack, any relevant programming languages you’re comfortable with, and examples of projects you've worked on. If you have a GitHub profile, link it up! We love to see code in action.
Tailor your portfolio:For a full-time role, we’d expect to see some solid examples of your work in your portfolio. Make sure to include at least two or three projects that highlight your problem-solving skills and your ability to work with different technologies. Focus on the projects that are most relevant to the position at Diodes Incorporated.
Craft a killer cover letter:Your cover letter is your chance to stand out—make it personal! Explain why you want to work at Diodes Incorporated and how your skills align with the role. Show us your passion for software development. We dig enthusiastic candidates who understand the value of collaboration and continuous learning!
Be clear and concise:When it comes to writing your CV and cover letter, clarity is key. Avoid jargon that could confuse us and stick to simple, direct language. Highlight your achievements with quantifiable results where possible, and keep everything easy to read. A well-organised application goes a long way!
How to prepare for a job interview at Diodes Incorporated
✨Brush Up on Your Coding Skills
For a full-time software engineering role, it's crucial that we stay sharp with our coding abilities. Expect technical questions that might involve solving problems on the spot or discussing algorithms. Practise on platforms like LeetCode or HackerRank to get comfortable with the types of questions that often come up.
✨Know Your Tools and Frameworks
Make sure we’re well-acquainted with the tools and technologies listed in the job description. Familiarise ourselves with any specific frameworks or programming languages mentioned. If Diodes Incorporated uses React or Node.js, for instance, be ready to discuss how we’ve used them in previous projects or coursework.
✨Showcase Your Projects
Bring along a portfolio that highlights our best work. This could be code samples, GitHub repositories, or any side projects we’ve built. Make sure we can talk through our thought process for each project, especially the challenges we faced and how we solved them—this shows our problem-solving skills in action.
✨Prepare for Behavioural Questions
While technical skills are key, full-time positions also require cultural fit. Be ready to discuss our previous experiences and how we handle teamwork, conflict, and deadlines. Brush up on the STAR method—Situation, Task, Action, Result—to clearly articulate our past experiences when discussing how we've contributed to a team.
