A retail systems integrator that helps you design, implement, integrate and maintain any major retail software platform.
Senior Database Administrator – Ops Engineer
Location
Massachusetts
Posted
70 days ago
Salary
0
Seniority
Senior
Job Description
Senior Database Administrator – Ops Engineer
RedIron
• Test databases, correct errors, and make necessary modifications • Plan, coordinate, and implement security measures to safeguard information in files • Modify existing databases and database management systems • Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions • Perform all aspects of Oracle database administration • Actively participate in the daily Operational activities of customer databases • Monitor production, test, and development database environments and actively pursue any issues limiting the performance, scalability, and availability of these systems • Database bug resolution, address database security vulnerabilities • Analyze trends, report potential problems or areas of improvement concerning internal and customer databases • Performance tuning by analyzing Oracle AWR, ADDM, ASH reports • Setup, Configure and support Physical Standby (Active Data Guard) databases for high availability with proficiency in failover/switchover mechanisms • Setup, Configure Oracle database backups via Recovery Manager (RMAN) utility for Disaster recovery • Manage Database users, roles, and privileges • Provide Technical support to Customers • Plan Database refreshes from Production to non-prod environments to test application changes • Engineer migration plan for Oracle Databases from on-premises environments to AWS and devise suitable approach • Improve Database query workflow via implementing Oracle Table partitioning • Work on Oracle Export Import Utility (Classical & Data Pump) for Object level granular migration • Validate Oracle Database objects code and error corrections • Engineer parameters modifications in Database Management Systems • Automate Statistics collection against Enterprise Database servers to ensure Data dictionary views/tables/schemas are all current • Work closely with DevOps teams to review CPM backups periodically and to establish continuous delivery to Development teams • Devise learning curve via Test cases/Database Proof of Concepts • Participate in Managed Services on-call rotation
Job Requirements
- B.S. degree in Computer Science, Information Systems or related field
- 5 years of experience with Oracle databases
- Knowledge of Oracle database 10g/11g/12c and Oracle Middleware (Weblogic) 11g/12c
- Oracle PSU patching
- Oracle Database Performance tuning
- Oracle Active Data Guard
- Oracle database backups via Recovery Manager (RMAN)
- Oracle Table partitioning
- Oracle Export Import Utility
- Linux Shell Scripting
- Postgres RDBMS
Benefits
- Telecommuting available, work remotely from anywhere in the United States
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
Oracle GoldenGate Database Administrator
Wavestone Germany AGLet’s power the future together. Vom Business Case bis hin zur Umsetzung: Als führendes Beratungsunternehmen für strategische Transformationen sind wir vertrauenswürdiger Partner für unsere Kunden - und für unsere Mitarbeitenden. Verantwortungsvoll, leistungsstark und immer mit dem Menschen im Fokus. #WeAreWavestone Mit unserem 360°-Portfolio an Beratungsleistungen verbinden wir erstklassige Branchenexpertise mit einem breiten Spektrum an branchenübergreifenden Kompetenzen, arbeiten interdisziplinär und denken über den Tellerrand hinaus. Wir freuen uns über eine Kontaktaufnahme!
Role Description Wir suchen einen erfahrenen Datenbank Administrator (Senior Consultant) für die Sicherstellung des Betriebs von Oracle Golden Gate im Rahmen eines Projekts bei einem führenden Versicherungsunternehmen. Der ideale Kandidat verfügt über mindestens sechs Jahre Berufserfahrung und tiefgehende Kenntnisse in der GoldenGate-Architektur. - Sicherstellung des stabilen Betriebs für Oracle Golden Gate - Review der eingesetzten Verfahren und Architekturen - Durchführung von Know-how-Transfer und Aufbau von Fachwissen bei weiteren Teammitgliedern - Installation und Konfiguration von Oracle GoldenGate Microservices (OGGMA) - Einrichtung von Extract- und Replicat-Prozessen für verschiedene Anwendungsfälle - Konfiguration von DML-Replikationen sowie Konfliktbehandlung (Conflict Detection & Resolution) bei bidirektionalen Setups - Monitoring und Troubleshooting inklusive Analyse von Lag, Checkpoint-Problemen und Blockaden - Durchführung von Fehlerdiagnosen über GoldenGate Logs, Eventlogs und Performance Views - Sicherstellung von Performance und Stabilität der Systeme - Optimierung der Systemparameter durch gezieltes Parameter-Tuning (z.B. BATCHSQL, FETCHOPTIONS, DBOPTIONS) Qualifications - Senior Consultant mit mindestens 6 Jahren Berufserfahrung in der Datenbank-Administration - Fundierte Kenntnisse der Oracle GoldenGate-Architektur einschließlich Extract, Replicat, Trail Files, Checkpoints sowie Classic & Integrated Extract / Replicat - Expertise in der Installation und Konfiguration von Oracle GoldenGate Microservices (OGGMA) - Erfahrung mit unidirektionaler, bidirektionaler und Multimaster-Replikation sowie Replikation zwischen heterogenen Systemen (z. B. Oracle zu Db2 z/OS) - Kenntnisse in der Einrichtung von Extract/Replicat-Prozessen und Konfiguration von DML-Replikation - Erfahrung in der Konfliktbehandlung (Conflict Detection & Resolution) bei bidirektionalen Setups - Sicherer Umgang mit Oracle Version 19c und Redhat Linux in virtualisierten Landschaften - Kompetenz in Monitoring, Troubleshooting und Performance-Tuning von GoldenGate (Lag-Analyse, GG Logs, Parameter-Tuning) - Erfahrung im Einsatz von Tools wie Ansible, Oracle Enterprise Manager, Dynatrace und Rubrik - Verhandlungssichere Deutschkenntnisse Requirements - Ausgeprägte Kommunikationsfähigkeit und Teamfähigkeit - Hohe Problemlösungskompetenz und kritisches Denken - Anpassungsfähigkeit und Flexibilität im Projektumfeld Benefits - Der Einsatz kann zu 100% remote erfolgen - Einarbeitung nach Bedarf am Standort in Kiel vorgesehen
Database Administrator – e-health
Cambio GroupCambio är ledande i Norden inom e-hälsa med innovativa digitala lösningar för regioner, kommuner och privata vårdgivare.
• You will be a key member of our DBA team at Cambio, working closely with four experienced colleagues responsible for operating and maintaining our medical records system — a business-critical service delivered to healthcare customers. • In this position, you will play a central role in operating large scale database platforms within a 24/7 healthcare environment, where performance, stability, and high availability are essential. • You will work hands-on with mission critical areas such as clustering, performance optimization, capacity planning, availability, administration, and the management of both internal and external environments. • If you are interested, there may also be an opportunity to take on team‑lead responsibilities over time, acting as a point of contact for collaboration and communication within the team and towards key stakeholders.
Lead database administrator
MarkMonitorMarkMonitor, part of Clarivate, is an enterprise-level domain registrar that helps brands optimize their domain strategies and safely and effectively manage the
Design, develop, and maintain MSSQL databases, perform capacity planning, and ensure database performance and integrity. Collaborate with stakeholders to implement security measures and support development teams in optimizing database queries.
Database Administrator, DBA
Authentic8The Silo Web Isolation Platform from Authentic8 enables anyone, anywhere, on any device to utilize the web without risk.
• Own the availability, incident response, and operational health of the company’s PostgreSQL platform databases (Eng, QA, and Production) • Ensure high availability and disaster recovery processes are tested and functioning. • Implement PostgreSQL changes with minimal service interruption. • Perform live schema updates and patches in coordination with Engineering and DevOps. • Plan for database growth, execute tuning analysis, and conduct performance optimization. • Review and assist with SQL query optimization, identify and resolve deadlocks. • Coordinate schema deployments with DevOps. • Support ad hoc query needs from Customer Success, Sales, and Marketing teams. • Ensure all PostgreSQL security best practices are applied and monitored. • Help restructure or re-architect current and future databases to support performance and scalability. • Lead data integration projects that centralize company data from multiple systems into one or more centralized data pools (e.g., BigQuery). • Architect and implement data pipelines (ETL/ELT) from systems such as Salesforce (CRM), Zuora (billing and revenue management), PostgreSQL (service data), Pendo.io (product analytics), Freshdesk (customer support/ticketing), Jira (work management and issue tracking). • Partner closely with Business Operations analysts to: Align on data models and schema designs that support reporting and analytics as well as build performant queries and transformations for ongoing business intelligence. • Ensure centralized data repositories are clean, consistent, and optimized for analysis. • Implement monitoring and alerting for data pipeline health and performance.
