The Oracle DBA manages database software and environments, ensuring performance, security, and recovery. Responsibilities include installation, configuration, performance tuning, and automation using Python scripting.
Oracle DBA responsibilities:
Database management and maintenance
- Install, configure, patch, and upgrade Oracle database software and related products.
- Manage the database throughout its lifecycle, from development to production.
- Design and implement database schemas and storage structures, including tables, views, and indexes.
- Create and maintain stored procedures, functions, and triggers using PL/SQL.
- Manage and troubleshoot complex Oracle GoldenGate replication environments.
- Automate routine database tasks using Python scripting.
- Configure and maintain high-availability solutions like Oracle Real Application Clusters (RAC) and Data Guard.
Performance and monitoring
- Monitor database health, performance, and resource utilization using tools like Oracle Enterprise Manager (OEM).
- Perform performance tuning and optimization to resolve bottlenecks and ensure fast query responses.
- Use diagnostic tools like AWR (Automatic Workload Repository) to analyze performance.
- Troubleshoot and debug database issues, providing timely resolution.
Security and access control
- Implement and enforce security policies, procedures, and standards.
- Manage database user accounts, roles, privileges, and security protocols.
- Ensure compliance with internal and external regulations.
- Conduct regular security audits and monitoring.
Backup and recovery
- Develop and implement backup and recovery strategies to ensure data integrity and availability.
- Use Oracle Recovery Manager (RMAN) for backups and restores.
- Perform regular testing of recovery plans.
Required qualifications and skills
Experience
- Prior experience as an Oracle DBA, with relevant experience managing complex Oracle databases.
- Proven experience with Oracle Application Express (APEX) development.
- Hands-on experience with Oracle GoldenGate installation, configuration, and troubleshooting.
- Experience with Python scripting for database automation and management.
- Strong knowledge of Oracle database architecture, administration, and internals.
Technical skills
- Proficiency in SQL and PL/SQL.
- Strong command of Linux/UNIX operating systems.
- Experience with high-availability solutions such as Oracle RAC and Data Guard.
- Knowledge of performance tuning and monitoring tools (e.g., OEM, AWR)
Top Skills
Awr
Data Guard
Linux/Unix
Oracle Database
Oracle Enterprise Manager
Oracle Goldengate
Oracle Rac
Pl/Sql
Python
SQL
Similar Jobs
Information Technology
The role involves building data ingestion pipelines, optimizing ETL processes, and developing AI-driven solutions using various frameworks and databases.
Top Skills:
CsvHashicorp VaultIcebergJupyterhubNeo4JOracle DbParquetPgvectorPostgresPower BIPythonS3Spark
Insurance
The Data and Integration Architect designs and manages solutions for system integration, ensuring data integrity and seamless communication across platforms while leading development efforts.
Top Skills:
APIsCicdDb2JSONMicrosoft Sql ServerMiddlewareMongoDBMqMySQLOracle DbPostgresPower BISoap
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Lead tax compliance engagements for high net worth clients, manage projects, perform reviews, mentor staff, and maintain tax expertise.
Top Skills:
AccountingCpaTax Compliance
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
