Oracle Database Administration With Production Support Specialist
Production Support Specialist
Location Remote
This is a 3 6-month contract to hire role, please submit candidates accordingly
Domain Experience (If any ) Healthcare (Mandatory)
Overall IT Experience 12+ Years And 4+ years of experience in production support, with a focus on both on-premise and cloud-based
Mandatory Areas
Must have Skills
Skill 1 8 Yrs of Exp Oracle Database Administration
Skill 2 8 Yrs of Exp Facets Clones
Skill 3 8 Yrs of Exp .NET Core, IBM MQ
Skill 4 6 Yrs of Exp - Oracle & PowerShell (Oracle Exadata & Netapp SMO)
Skill 5 - 6 Yrs of Exp - AWS, Azure
Skill 6 - 6 Yrs of Exp - HashiCorp
Skill 7 - 6 Yrs of Exp - Terraform
Skill 8 - 6 Yrs in Exp - SQL queries (Performance Tuning), MySQL
Skill 9 - 6 yrs In Exp - Shell Scripting
Skills 10 - 6 Yrs Of Exp - Datadog, ServiceNow(SNOW)
Position Overview: We are seeking a skilled Production Support Engineer to manage the day-to-day
operations and performance of critical applications and databases in a dynamic, high-demand
environment. The ideal candidate will have hands-on experience with Oracle databases, cloud
platforms, and a range of other enterprise applications, combined with strong problem-solving skills
and the ability to troubleshoot and resolve issues with minimal escalation.
This position involves overseeing database performance, managing deployments, and providing
support for a variety of technologies, including Facets, Oracle Exadata, and cloud-based databases.
The role requires working during standard U.S. hours with flexibility to support incidents and on-call
requirements.
Key Responsibilities:
Deployment and Incident Management
- Execute application and database deployments following established processes.
- Manage incidents, performing root cause analysis and resolving issues promptly with minimal
escalation.
- Actively participate in on-call rotations and respond to production incidents to minimize impact.
- Collaborate with cross-functional teams to troubleshoot and resolve critical system issues.
Problem Management
- Analyze recurring system issues to identify root causes and implement permanent fixes.
- Develop and refine processes to enhance system reliability and reduce incident occurrence.
Database Administration and Optimization
- Administer and troubleshoot Oracle databases, ensuring optimal performance and availability.
- Perform SQL query optimization and Oracle database performance tuning.
- Manage database backup/recovery processes using NetApp SMO/SnapCenter tools.
- Support Azure cloud databases and leverage HashiCorp/Terraform for infrastructure management.
- Maintain and optimize high-performance database systems such as Oracle Exadata.
System and Application Support
- Provide support for applications including Oracle, Facets Clones, .NET Core, .NET Framework,
Adobe, and IIS.
- Manage messaging systems like IBM MQ and web servers such as Apache.
- Perform Linux system administration tasks, including sudo/dzdo commands/scripts for system
maintenance and troubleshooting.
- Handle log cleanup, file management, and other server optimizations to ensure system health.
- Assist with MySQL database updates with guidance from experienced team members.
Automation and Scripting
- Develop and maintain scripts using Python, PowerShell, and Linux shell scripting to automate
routine tasks and improve efficiency.
- Utilize tools like HashiCorp, Tortoise Git, and Adoptium for version control and system
provisioning.
Performance Monitoring and Optimization
- Monitor system performance using tools like Datadog, identifying bottlenecks and implementing
solutions to improve efficiency.
- Proactively identify potential vulnerabilities and apply remediation measures.
Documentation and Standard Operating Procedures
- Follow and maintain comprehensive documentation for deployments, configurations, and incident
management.
- Ensure all activities adhere to standard operating procedures and compliance requirements.
Communication and Collaboration
- Provide clear and concise updates to stakeholders during incidents and problem management
processes.
- Collaborate effectively with developers, system administrators, and business units to align on
priorities and deliver solutions.
Key Qualifications:
- Bachelor s degree in computer science, Information Technology, Engineering, or a related field.
- Overall IT Experience 12+ Years And 4+ years of experience in production support, with a focus on both on-premise and cloud-based
systems management.
- Hands-on experience with Oracle Database Administration, including performance tuning,
troubleshooting, and SQL query optimization.
- Strong expertise in Oracle DBA, NetApp SMO/SnapCenter, and Oracle Exadata for managing large-
scale database environments.
- Proficiency in Unix shell scripting for automation and system administration tasks.
- Extensive experience in database backup/recovery processes, including hands-on knowledge of
Oracle OID.
- Experience with Azure cloud databases and HashiCorp/Terraform for cloud-based infrastructure
provisioning and management.
- Experience with Datadog for system monitoring and performance analysis.
- Familiarity with IBM MQ, Facets, and other enterprise applications for system integration and
support.
- Hands-on experience with .NET Core, .NET Framework, Apache, IIS, PowerShell, and Python for
application support.
- Strong command over Linux Shell Scripting for performing system tasks and troubleshooting.
- Ability to perform system optimizations, including the cleanup of logs, files, and directories
impacting server performance.
- Experience with version control systems like Tortoise Git for code management and deployment
workflows.
- Proven ability to handle on-call support and troubleshoot issues with minimal escalation, including
working during non-standard U.S. hours when necessary