The World Leader In Serving Science
Senior Database Administrator
Location
Massachusetts
Posted
3 days ago
Salary
$136.4K - $171.9K / year
Seniority
Senior
Job Description
Senior Database Administrator
Thermo Fisher Scientific
• 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
Job 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
- 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
- Dissemination of 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, and short- and long-term disability in accordance with company policy
- Retirement and savings programs, such as our competitive 401(k) U.S. retirement savings plan
- Employees’ Stock Purchase Plan (ESPP) offers eligible colleagues the opportunity to purchase company stock at a discount
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
RICE Object Developer, Oracle Database Administrator
Copper River TechnologiesFederally recognized, Alaskan Tribal-Owned, 8(a) Certified IT cyber defense solutions & service provider.
• Maintain, update, and enhance legacy system application code, software, and release documentation. • Develop and modify RICE objects to implement system updates, enhancements, interfaces, reports, and fixes. • Resolve Discrepancy Reports (DRs) and System Change Requests (SCRs) to improve system performance and functionality. • Deliver Technical Solutions and Rough Order of Magnitude (ROM) estimates for system modifications. • Conduct and support Critical Design Reviews (CDR), Preliminary Design Reviews (PDR), and Test Readiness Reviews (TRR). • Monitor application logs, identify system issues, and perform ongoing reviews to ensure system stability. • Support the integration of system changes provided by external organizations. • Ensure compliance with security, configuration management, and software development best practices. • Work collaboratively with business analysts, testers, system administrators, cybersecurity personnel, and government stakeholders. • Provide technical documentation, user guides, training materials, and end-user support as required. • Develop, maintain, and optimize Oracle database objects including tables, views, indexes, stored procedures, packages, triggers, and PL/SQL code. • Design and maintain logical and physical data models supporting application enhancements and business requirements. • Configure, administer, and maintain Oracle database environments supporting development, test, staging, and production systems. • Monitor database performance and conduct tuning activities to optimize system efficiency and reliability. • Analyze and resolve database bottlenecks, locking issues, deadlocks, and performance degradation. • Develop and implement indexing strategies, query optimization techniques, and database performance improvements. • Support database upgrades, patching, configuration management, and software installations. • Coordinate and support database backup, recovery, and disaster recovery activities. • Manage database imports, exports, migrations, and data transformation efforts. • Maintain database integrity, availability, and security in accordance with government requirements. • Implement and maintain database security controls, user account administration, role-based access controls, and auditing mechanisms. • Support interface development and integration activities involving Oracle databases and external systems.
Database Administrator - Cloud Platform / Infrastructure
3CloudDelivering the ultimate Microsoft Azure experience.
Role Description 3Cloud is looking for an experienced Database Administrator who is comfortable managing multiple deadlines and varied customer requests. A strong OS background is preferred due to the many migration assessments and implementations required by the position. Experience with Azure is a must, along with flexible and creative analytical skills to fit the solution to the customer needs. - Work as a DBA for multiple customers, helping with Database Migrations, High Availability and Disaster Recovery solutions, SQL and Windows Clustering solutions, Monitoring, Backup/Recovery solutions, and Performance Tuning including remediation on performance blockers. - Manage multiple long-term database (Azure data services) projects at the same time. - Able to scope, plan, implement, and document and/or present a solution to the customer. - Provide cost effective Azure platforms to meet customer requirements. - Be able to work with Development, Test, and Production environments to support customer requirements at each level of work. - Assist with Security definitions and roles for various users in the environments and support Azure Infrastructure team in provisioning data services in Azure cloud. - Manage client expectations with regards to scope, cost, and timeline. - Author high quality project documentation and other project artifacts, including written case studies detailing use cases and project specifics. - Be an effective technical mentor to more junior level teammates. - Deliver complex projects on-time and within budget, proactively identifying and mitigating gaps and risks. - Expand your knowledge in multiple tools and technologies. - Foster a problem-solving culture that resolves issues through collaboration and partnerships with other parts of the organization. - Support internal 3Cloud objectives that help advance data services design and techniques. - Support the Sales Team on Presales efforts to define scope estimates for most projects when bandwidth allows. Qualifications - Bachelor’s degree in computer, engineering, data science or a related field; or equivalent work experience. - Has the ability to work both strategically and tactically in different customer environments. - Must be EXTREMELY detail oriented and self-directed. - Must be able to produce high-quality documentation for both internal and external distribution. - Must have multiple years working with a major RDBMS (Oracle/SQL Server) – preference given to deep experience with Microsoft products. - Should have done a few databases migration from different cloud platform/or on-prem to Azure. - Moderate experience with OS clustering concepts and technologies. - Understanding of security roles and how to implement database security. - Advanced level experience at the implementation and appropriate use of the following HA/DR technologies: Always On AG, Replication, Log shipping, Mirroring. - Advanced level experience with database objects/stored procedures. - Advanced level experience with performance tuning, monitoring, and troubleshooting. - Have a strong understanding of Cloud Infrastructure solutions and the delivery/execution of how they are implemented using IaC (Bicep or Terraform). - Drive to maintain knowledge of the latest technologies and how they may impact existing 3Cloud offerings. - Understanding of cloud ecosystem and leading-edge cloud emerging technologies. - Performance analysis, troubleshooting and remediation techniques. - Strong analytical problem-solving ability. - Strong presentation, written and verbal communication skills. - Self-starter with the ability to work independently or as part of a virtual project team. Requirements - You have over 2 years of experience in the following: - Designing and implementing logical and physical data models for cloud and hybrid data warehouse environments. - Implementing data architectures to support a variety of data formats and structures including structured, semi-structured and unstructured data. - Implementing multiple full life-cycle data warehouses. - Understanding of data architectures required to support data integration processing. - Data modeling technologies such as ER/Studio, ER/Win or similar. - Microsoft Azure Data Platform services including Azure Data Lake Store, Azure Storage, Azure Synapse, Azure Data Factory, Azure SQL database, Logic Apps, APIs. - Data profiling and creation of source to target mappings. - Ability to provision and configure Azure data service resources. Benefits - Full-time employment. - 📌 Remote in Philippines.
• Administer the Corrigo CMMS platform to ensure optimal system performance, data integrity, and adherence to operational standards through configuration management, system audits, and database maintenance protocols • Configure system settings including user access controls, property/asset hierarchies, work order scheduling processes, and system integrations to meet specific client requirements • Partner with client teams as the primary CMMS technical advisor and subject matter expert, processing data requests efficiently while maintaining accurate time tracking for reimbursable services • Develop reporting solutions and analytics that deliver performance insights, support account teams with complex data analysis, and maintain comprehensive database accuracy through regular validation • Analyze client change requests, provide impact assessments to support decision-making, and deliver system training and knowledge transfer to maximize platform adoption • Document and deploy configuration changes following change management protocols, explore innovative solutions within existing system capabilities, and implement process improvements based on industry best practices
Database Administrator
Jahnel Group, an Inc. 5000 companyWorld Class Software Creators Ready To Hustle For You
• Investigate and resolve application and data-related support tickets. • Write, test, and execute SQL scripts to perform data updates, corrections, and maintenance activities. • Troubleshoot production and UAT issues by analyzing data, stored procedures, and application behavior. • Identify root causes of system issues and work with development teams to implement solutions. • Support reporting and operational data requests across multiple business functions. • Modify and maintain existing stored procedures, queries, and database processes. • Collaborate with developers, business analysts, and stakeholders to understand system workflows and business rules. • Participate in ongoing application support, maintenance, and enhancement initiatives.




