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
Agency • Digital Media • eCommerce • Professional Services • Software • Analytics • Consulting
The React Native Developer will build efficient mobile applications, enhance user experiences, and collaborate in Agile teams while supporting junior developers.
Top Skills:
FlutterJavaScriptKotlinReactReact NativeSwift
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
