At a Glance
- Tasks: Manage production support databases and troubleshoot SQL queries.
- Company: Join a dynamic team focused on innovative tech solutions.
- Benefits: Competitive salary, flexible working hours, and opportunities for professional growth.
- Other info: Great chance to enhance your skills in a supportive environment.
- Why this job: Be part of a crucial role that ensures smooth operations in tech.
- Qualifications: Experience with Oracle, PL/SQL, and Unix scripting is essential.
Security Cleared Onshore who will be responsible for managing production support database having Oracle, PL/SQL knowledge and Unix scripting.
Your responsibilities:
Day to day responsibility will be:
Oracle Database Knowledge
- Good understanding of Oracle Database concepts
- Ability to write and troubleshoot SQL queries
- Joins, subqueries, views, indexes
- Data validation and data analysis
- Understanding of Oracle schemas, tables, and relationships
Production Support
- Incident, Problem, and Change Management
- Root Cause Analysis (RCA)
- Monitoring and ticket resolution
SQL Skills
- Query performance analysis
- Data fixes and data reconciliation
- Stored procedures/packages understanding
- Ability to analyze application issues using database data
ASG Skills
- OS - Linux, Windows
- CI/CD - GitLab, Jenkins, Spinnaker
Your Profile
Essential skills/knowledge/experience: (Up to 10, Avoid repetition)
- Good understanding of Production Support Estate with Oracle DB knowledge and Postgres knowledge
- Ability to write and troubleshoot SQL queries
- Joins, subqueries, views, indexes
- Data validation and data analysis
- Understanding of Oracle schemas, tables, and relationships
- Oracle PL/SQL knowledge- with OCA certified
- Certified AWS Solutions Architect
- Knowledge on CORE Devops, Terraform and Agentic AI
- Good communication skills, specifically: listening to customer needs, restating those needs, and documenting work
- Excellent problem-solving skills
- Ability to learn and apply new technologies quickly and self-directed
- Must be willing to work diligently to meet deliverable deadlines
- Demonstrated high degree of initiative and self-guided work.
- Ability to prioritize and plan own tasks and estimate level of effort for assigned tasks
- Good interpersonal and collaboration skills, strong team working ability.
#J-18808-Ljbffr
Production Support Engineer in Milton Keynes employer: Tata Consultancy Services
At TCS Interactive, we pride ourselves on being an exceptional employer, offering a vibrant and inclusive work culture that champions collaboration and creativity. As a Mid-Weight UX Designer, you will have the opportunity to grow your skills alongside talented professionals in a supportive environment, while contributing to impactful digital products that enhance user experiences. Our commitment to employee development, coupled with our focus on meaningful design, makes TCS Interactive a rewarding place to advance your career.
StudySmarter Expert Advice🤫
We think this is how you could land Production Support Engineer in Milton Keynes
✨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 Tata Consultancy Services 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 Tata Consultancy Services.
✨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 Tata Consultancy Services.
✨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 Tata Consultancy Services 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 Production Support Engineer in Milton Keynes
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 Tata Consultancy Services.
Craft a killer cover letter:Your cover letter is your chance to stand out—make it personal! Explain why you want to work at Tata Consultancy Services 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 Tata Consultancy Services
✨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 Tata Consultancy Services 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.
