Systems Administrator I

You must Sign In before continuing to the company website to apply.

Smart SummaryPowered by Roshi

Responsible for Oracle SQL queries, ticket resolution, and maintenance of custom-built applications. Key tasks include database queries, SQL query optimization, ticket resolution, system monitoring, documentation, and collaboration. Must have a strong desire to learn, problem-solving skills, and excellent communication. On-site full-time opportunity at Thermo Fisher Scientific in Bengaluru, India and Manila, Philippines.

Work Schedule

Standard (Mon-Fri)

Environmental Conditions

Office

Job Description

This role will focus on Oracle SQL queries and updates as well as ticket resolution.

Further responsibilities include managing and maintaining a custom-built application. This role specifically emphasizes knowledge in Oracle SQL, which involves writing, optimizing, and troubleshooting SQL queries for efficient data retrieval and manipulation.

Key responsibilities include:

Database Queries and Manipulation: Being able to write SQL queries to return information from multiple tables in a clear and concise report. Writing SQL queries that will insert, update and or delete records on 1 or more tables.

SQL Query Optimization: Analyzing and optimizing SQL queries to improve database performance and minimize execution time. This involves identifying bottlenecks, indexing strategies, and rewriting queries to enhance efficiency.

Ticket Resolution: Responding to and resolving technical issues and service requests raised by end-users or system monitoring tools. This requires an individual who is excited to solve new problems in a timely manner while being able to clearly communicate the issues and resolutions.

System Monitoring and Maintenance: Implementing monitoring tools to proactively identify and resolve potential system issues. Regularly monitoring system performance, capabilities, and implementing necessary monitoring.

Documentation and Reporting: Maintaining accurate and up-to-date documentation of system configurations, processes, and procedures. Generating reports on system performance/functionality, incidents, and resolutions to ensure transparency and facilitate knowledge sharing.

Collaboration and Support: Collaborating with cross-functional teams, such as developers, network administrators, and security specialists, to ensure smooth system operation and resolve complex issues. Providing technical support and guidance to end-users and stakeholders.

Overall, a Systems Administrator with a focus on Oracle SQL and ticket resolution plays a crucial role in ensuring the reliable and efficient operation of our proprietary systems and databases, while providing prompt resolution to technical issues and maintaining a high level of user satisfaction.

A strong desire to learn new things and a drive to solve complex puzzles is a must. The Systems Administrator job requires communication with our Business Users as well as an understanding of their workflow and processes. Due to the highly regulated nature of our business, proper documentation and adherence to regulations is a must.

Set alert for similar jobsSystems Administrator I role in Bengaluru, India or Manila, Philippines

Company

Thermo Fisher Scientific

Job Posted

6 months ago

Job Type

Full-time

WorkMode

On-site

Experience Level

0-2 Years

Related Jobs

Validation Analyst

Thermo Fisher Scientific

Manila, Metro Manila, Philippines

+1 more

Posted: a year ago

Essential Functions Participates as a validation representative at project team meetings and completes assigned action items. Provides direction for future releases to software systems; reviews change requests. Communicates proactively with all project team members and provides regular feedback to management concerning timeline/budget or resource constraints. Provides validation support for new releases and modifications to applications throughout the software development life cycle. Prepares validation plans, test cases and supporting validation documentation and executes test cases.  Reviews PQ and change control documentation with leadership per SOP.  Ensures test scripts challenge the functional requirements and adequately demonstrate that the application meets the expectations of the business customer.  Assists in the execution of test scripts to produce evidence that the computer system consistently performs its intended functions accurately and reliably, proving the software functions correctly. Creates, updates, and manages sufficient data within the testing environment to accurately test software functionality. Works with leadership to address any PQ related issues arising from client or internal audits. Manages assignments to meet deadlines and produce high quality deliverables. Remains familiar with relevant applicable regulations, and SOPs.  Participates in the identification of user requirements and system design and assists in the preparation and review of system documentation such as requirements and design specifications for software systems and/or instrumentation. Job Complexity Works on problems of moderate scope where analysis of situations or data requires a review of a variety of factors. Job Knowledge Developing professional expertise, applies company policies and procedures to resolve a variety of issues. Supervision Received Normally receives general instructions on routine work, detailed instructions on new projects or assignments.  Exercises judgment within defined procedures and practices to determine appropriate action. Business Relationships Contacts are primarily internal to the company with infrequent external customer / vendor contact on routine matters. Builds productive internal / external working relationships.   Qualifications:    Education and Experience:   Bachelor's degree or equivalent and relevant formal academic / vocational qualification Previous experience that provides the knowledge, skills, and abilities to perform the job (comparable to 2+ years).   Knowledge, Skills and Abilities:  Client-focused approach with strong interpersonal skills, and strong oral and written communication skills and ability to teach others Strong attention to details and problem-solving skills Demonstrated competency with Microsoft Office Suite (Word, Excel, PowerPoint, and Project). Proven ability to learn new computer software with minimum of instruction Positive attitude, enthusiasm toward work, and the ability to work well with others Effective organization and time management skills with the ability to adapt and adjust to changing priorities and manage multiple assignments with challenging/conflicting deadlines Solid understanding of clinical trials operational processes and terminology and solid understanding of the software development life cycle (SDLC) Strong troubleshooting skills and ability to analyze software defects, assess the cause of test failures, and explain how errors are produced Ability to attain, maintain, and apply a working knowledge of GCPs, applicable SOPs/WPDs, and process maps Ability to review and critique SDLC documentation including requirements, functional design, system design, and test plans. Ability to assess the cause of test failures Demonstrated ability to coordinate project activities and work and communicate effectively on a multi-disciplinary team   Working Conditions and Environment:    Work is performed in an office environment with exposure to electrical office equipment.    Physical Requirements:   Frequently stationary for 6-8 hours per day.   Repetitive hand movement of both hands with the ability to make fast, simple, repeated movements of the fingers, hands, and wrists.    Ability to access and use a variety of computer software developed both in-house and off-the-shelf. Ability to communicate information and ideas so others will understand; with the ability to listen to and understand information and ideas presented through spoken words and sentences.  Frequently interacts with others to obtain or relate information to diverse groups.    Works independently with little guidance or reliance on oral or written instructions and plans work schedules to meet goals.  Requires multiple periods of intense concentration.  Performs a wide range of variable tasks as dictated by variable demands and changing conditions with little predictability as to the occurrence.  Ability to perform under stress.  Ability to multitask.    Regular and consistent attendance.  

Principal Validation Analyst ( Manual Testing)

Thermo Fisher Scientific

Bengaluru, Karnataka, India

+1 more

Posted: a year ago

As a Principal Validation Analyst, you will lead validation activities for systems and applications, create validation plans, execute test cases, review change controls, and mentor team members. You will ensure that computer systems consistently meet business requirements and regulatory standards. This full-time hybrid opportunity in Bengaluru, India, and Manila, Philippines requires 8+ years of overall experience with at least 5 years in manual testing.

Customer Care Rep I

Carelon

Taguig, Metro Manila, Philippines

Posted: a year ago

Responsible for customer inquiries regarding insurance benefits, claims, and more. Requires basic training completion, PC skills, and positive customer relations. Role includes data analysis, troubleshooting, and meeting department goals. On-site full-time opportunity at Carelon in Taguig, Metro Manila, Philippines.

Sr Systems Developer ( Talend ETL & Snowflake)

Thermo Fisher Scientific

Taguig, Metro Manila, Philippines

+1 more

Posted: a year ago

Essential Functions   Understands and develops components and services according to specifications within a team environment. Prepares detailed system documentation including requirements, specifications, test plans and user manuals. Performs unit and system tests and, as needed, validation testing. Assists DBA with database design and implementation. Strong SQL and Analytical skills to pull data from Snowflake/Oracle/SQL Server and perform usage analysis and/or data profiling. Understanding of data warehousing and data modelling principles Experience in understanding both logical and physical data models Coordinates with Operations staff on deployment of applications. Works with business partners to analyze and address support requests including training. Provides support for existing systems and technologies, including second line application support during and after deployment. Ensures all activities are performed with quality and compliance. Design and implementation of ETL batches that meet the SLAs for the business’ Business Intelligence reporting. Development of data collection, data staging, data movement, data quality and archiving strategies. Plan and conduct ETL Unit and development tests, monitoring results and taking corrective action when necessary. Design and implement automation processes to control data access, transformation and movement and ensures source system data availability   Working hours for India - 1PM to 10 PM IST Manila - 3:30 PM to 12:30 PM PST   Knowledge, Skills and Abilities   Must have 8-10 year's experience who has min 2-3 year's experience in Talend and min 7 year's experience in SQL and EDW . Experienced in the use of the Talend ETL tool and Snowflake/Any Cloud based tools ( Must Have ) Client focused approach with strong interpersonal skills Must be able to multitask and pay close attention to detail Open to PROD support during the week and weekends Solid knowledge of basic relational database platforms (Snowflake, Oracle, SQL Server) and languages (PL/SQL, SQL) ( Must Have ) Build processes supporting data transformation, data structures, metadata, dependency and workload management Strong logic, analysis, and problem-solving skills A good understanding of the concepts and best practices of data warehouse ETL design. ( Must Have ) Ability to follow functional ETL specifications and challenge business logic and schema design where appropriate, as well as manage their time effectively Have designed and developed ETL work packages on at least one data warehouse project. Expertise in building and optimizing cloud data pipelines, architectures and data sets. Experience with AWS cloud services: Glue, S3, Databricks, EC2, EMR ( Nice to Have )

Reporting Specialist

Carelon

Taguig, Metro Manila, Philippines

Posted: a year ago

JOB DESCRIPTION Responsible for preparing and ensuring accuracy of reports on operational data and metrics. Primary duties may include, but are not limited to: Conducts research required to verify report accuracy. Manipulates and enters data to prepare required reports. Ensures relevance and accuracy of reporting. Requires a H.S. diploma or equivalent and 1-3 years related experience; or any combination of education and experience, which would provide an equivalent background. Written and oral communication skills required. Good PC office software and keyboard skills required.

Operation's Manager for Contact Center

Carelon

Taguig, Metro Manila, Philippines

Posted: a year ago

JOB DESCRIPTION Description Responsible for providing oversight for customer service staff. Responsible for establishing departmental policies and procedures.  Primary duties may include but are not limited to: Directs implementation and administration of benefit programs. Prepares and communicates information to appropriate parties regarding benefit programs, procedures, changes, and government mandated disclosures. Audits to monitor efficiency and compliance with policies; prepares specialized reports; may be assigned to special project work consistent with the role and dictated by the needs of the business. Hires, trains, coaches, counsels, and evaluates performance of direct reports.  Requires BA/BS; 1 year of experience in a leadership role and 5 years related customer service experience, or any combination of education and experience, which would provide an equivalent background.