Sr. Database Administrator

Thermo Fisher Scientific • Waltham, MA

3d • Remote

About The Position

Thermo Fisher Scientific Inc. is seeking a Sr. Database Administrator to provide comprehensive Oracle database support in a high-performance, highly available environment. This role involves collaborating with application and business support teams to analyze, design, and implement complex database solutions. The administrator will be responsible for installing, configuring, and managing Oracle database environments on Unix, Linux, and Windows operating systems, as well as implementing and supporting high-availability solutions. Key tasks include performing Oracle database patching and upgrades across various platforms (Exadata, RAC, virtual machine, Veritas clustering, Data Guard, Golden Gate), tuning database efficiency, ensuring compliance with strict audit standards (SOX, PCI, FDA, FISMA, HIPAA), managing database security, performing backup and recovery, and automating routine tasks. The position requires troubleshooting complex issues in a dynamic environment and may involve up to 5% domestic travel. Remote work or telecommuting is an option.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or related field of study.
• 10 years of Oracle DBA experience on Unix, Linux, and Windows platforms, or related experience.
• Installation, configuration, and management of Oracle databases, including standalone databases, and clustered databases using RAC, Oracle Exadata, Veritas active/passive clustering, virtual machine, Oracle Data Guard, and Oracle Golden Gate.
• Oracle Exadata, including configuration, installation, patching, and routine support.
• Engaging and managing Oracle support and Oracle Platinum support teams.
• Analyzing and tuning Oracle database environments, including configuring databases for optimal performance and tuning problematic SQL and PL/SQL.
• Oracle Golden Gate and data replication, including installation and deployment of Golden Gate locally and hub installations, instantiation of replication, and replication troubleshooting.
• Creating and maintaining automation scripts for routine database administration tasks.
• Unix/Linux shell scripting required or equivalent experience with Powershell, Perl, and Java.
• Ensuring database audit compliance, including SOX, PCI, FDA, FISMA, and HIPAA controls.
• Oracle database backup, recovery, and cloning using Oracle Rman, Veeam, EMC disk cloning, Data Domain, NFS, and Oracle ZFS backup technologies.
• Database physical and logical design for transactional and data warehouse systems.
• Managing databases in Amazon Web Services and Oracle Cloud deployments including RDS, EC2, and ATP installations, including resizing, patching, security, and maintenance.
• Analyzing, implementing, managing, and testing large heterogenous Database Disaster Recovery implementations.
• Database security including patching, user creation, password rotation, privilege management, profile management, and database encryption.
• Supporting large ERP systems including SAP, JD Edwards Enterprise One, ecommerce, and large data warehouses.
• Implementing and maintaining PostgreSQL, MySQL, and Redshift databases.

Responsibilities

• Provide comprehensive Oracle database support in a high-performance, highly available environment.
• Collaborate with application and business support teams to analyze, design, and implement complex database solutions.
• Install, configure, and manage Oracle database environments on Unix, Linux, and Windows operating systems.
• Implement, configure, and support high-availability solutions for Oracle databases.
• Perform Oracle database patching and upgrades in a heterogeneous landscape, including Exadata, RAC, virtual machine, Veritas active/passive clustering, Data Guard, and Golden Gate.
• Ensure optimal Oracle database efficiency by performing database tuning, SQL and PL/SQL tuning, and hardware/operating system consulting related to database performance.
• Ensure database compliance with strict audit standards including SOX, PCI, FDA, FISMA, and HIPAA.
• Ensure adherence to change control policies.
• Manage database security at all levels.
• Perform database backup, recovery, and cloning.
• Automate and maintain automation for routine database tasks.
• Troubleshoot and resolve complex issues in a highly dynamic environment.
• Disseminate information to both technical team members and leadership, documenting and maintaining documentation for critical processes and SOPs.

Benefits

• A choice of national medical and dental plans, and a national vision plan, including health incentive programs
• Employee assistance and family support programs, including commuter benefits and tuition reimbursement
• At least 120 hours paid time off (PTO), 10 paid holidays annually
• Paid parental leave (3 weeks for bonding and 8 weeks for caregiver leave)
• Accident and life insurance
• Short- and long-term disability
• Competitive 401(k) U.S. retirement savings plan
• Employees’ Stock Purchase Plan (ESPP)

What This Job Offers

• Job Type: Full-time
• Career Level: Senior