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
InOrg Global Charlotte, North Carolina, USA Office
Charlotte, NC, United States, 28208
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
Information Technology
As a BPI Developer, you will implement digital solutions using Java and Neo4J, manage CI/CD processes, create telecom models, and automate infrastructure.
Top Skills:
AngularAnsibleAWSBpmnCamundaCSSCucumberD3.JsDockerDroolsEksElastic SearchGitGulpHTMLIntellijJavaJavaScriptJSONJunitKafkaKubernetesMavenMicrosoft SsmsMs Visual StudioNeo4JNode.jsOracle DbOsmPackerPostgresPostmanReactRestRhelSoapuiSpringSsoTerraformTypescriptWorkflow
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
