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
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Design, develop, and maintain identity governance solutions using SailPoint IdentityIQ; troubleshoot IAM issues and improve IAM processes.
Top Skills:
Active DirectoryAzure DevopsBeanshellDatabase TechnologiesJavaLdapPowershellPythonRestSailpoint Identityiq
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
