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 hours, and opportunities for professional growth.
- Other info: Work in a dynamic team with global reach and excellent career advancement.
- Why this job: Make an 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.
Diodes Incorporated is seeking an experienced Oracle E-Business Suite (EBS) and PostgreSQL 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, PostgreSQL, 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 WebLogic 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.
- PostgreSQL Administration
- Install, configure, monitor, and maintain PostgreSQL databases in production and non-production environments.
- Perform PostgreSQL upgrades, patching, migrations, backup, recovery, and routine maintenance.
- Configure and maintain PostgreSQL replication technologies, including streaming replication and logical replication.
- Deploy and support PostgreSQL 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 PostgreSQL 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 PostgreSQL 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 MySQL databases.
- Experience with enterprise high-availability, disaster-recovery, security, auditing, and compliance requirements.
- Experience supporting large-scale, business-critical systems in globally distributed environments.
Work Expectations
- 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 Inc
Diodes Inc provides a supportive work environment that encourages employee growth through training and development programs. The company's commitment to innovation and quality ensures that employees are part of a forward-thinking team. With a focus on collaboration, Diodes Inc fosters a culture where every team member can contribute to impactful projects.
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 Inc 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 Inc.
✨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 Inc.
✨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 Inc 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 Inc.
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 Inc 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 Inc
✨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 Inc 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.
