Applications Administrator

Systems Administrator – Oracle SQL Focus

Location: Office Environment
Work Schedule: Standard (Mon-Fri)
Environmental Conditions: Adherence to Good Manufacturing Practices (GMP) Safety Standards

Role Overview

We are seeking a skilled Systems Administrator with a strong focus on Oracle SQL to join our team. This role involves managing and maintaining a custom-built application, optimizing SQL queries, and resolving technical issues. The ideal candidate will have expertise in writing, optimizing, and troubleshooting SQL queries to ensure efficient data retrieval and manipulation.

Key Responsibilities

• Database Queries and Manipulation: Develop and execute SQL queries to extract information from multiple tables, as well as insert, update, and delete records across one or more tables.

• SQL Query Optimization: Analyze and optimize SQL queries to enhance database performance and reduce execution time. Identify bottlenecks, implement indexing strategies, and rewrite queries to improve efficiency.

• Ticket Resolution: Address and resolve technical issues and service requests from end-users or system monitoring tools. Solve problems promptly and clearly communicate issues and solutions.

• System Monitoring and Maintenance: Implement and utilize monitoring tools to proactively identify and address potential system issues. Regularly monitor system performance, capabilities, and make necessary adjustments.

• Documentation and Reporting: Maintain accurate documentation of system configurations, processes, and procedures. Generate and review reports on system performance, incidents, and resolutions to ensure transparency and support knowledge sharing.

• Collaboration and Support: Work closely with cross-functional teams, including developers, network administrators, and security specialists, to ensure smooth system operations and resolve complex issues. Provide technical support and guidance to end-users and stakeholders.

Qualifications

• Technical Skills:

  • Proficiency in Oracle SQL, including writing, optimizing, and troubleshooting queries.
  • Experience with SQL query optimization techniques, indexing strategies, and performance tuning.
  • Familiarity with system monitoring tools and practices.
  • Strong documentation skills and experience with reporting on system performance and incidents.

• Soft Skills:

  • Excellent problem-solving abilities and a keen interest in solving complex technical challenges.
  • Strong communication skills to interact effectively with business users and technical teams.
  • Ability to understand and adapt to user workflows and processes.

• Experience:

  • Experience managing and maintaining custom-built applications.
  • Proven track record in resolving technical issues and managing service requests.
  • Knowledge of Good Manufacturing Practices (GMP) and adherence to regulatory standards.

• Education:

  • Relevant technical certification or degree in Computer Science, Information Technology, or a related field.

Why Join Us?

As a Systems Administrator focused on Oracle SQL and ticket resolution, you will play a critical role in ensuring the reliability and efficiency of our proprietary systems and databases. We value a strong desire to learn and a proactive approach to solving complex problems. This role requires adherence to regulatory standards and effective communication with business users. If you are committed to delivering high-quality technical support and optimizing system performance, we encourage you to apply.