What are the responsibilities and job description for the Oracle Database Administrator (DBA) position at VeriiPro?
Job DescriptionPrimary Responsibilities
- Install and configure Oracle databases and related software (e.g., Oracle RAC, Data Guard, etc.).
- Monitor and optimize database performance, including tuning SQL queries, and adjusting database parameters.
- Implement backup and recovery strategies using Oracle RMAN or other tools, ensuring data integrity and disaster recovery preparedness.
- Configure and maintain database security, including user accounts, roles, and privileges. Ensure databases comply with security policies and standards.
- Apply patches and upgrades to Oracle databases to ensure they are up-to-date and secure.
- Resolve database issues quickly, including performance bottlenecks, connectivity problems, and corruption.
- Manage Oracle replication and clustering technologies such as Oracle Data Guard, RAC (Real Application Clusters), and GoldenGate.
- Plan and execute database migrations, including upgrades to new Oracle versions or moving data between systems.
- Utilize Oracle Enterprise Manager or other tools to monitor system performance and produce reports for system health, utilization, and security.
- Work with stakeholders to assess system growth and prepare for future database capacity needs.
- Maintain accurate documentation for all database configurations, procedures, and policies.
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience as an Oracle DBA (typically 5 years or more).
- In-depth knowledge of Oracle database architecture, including installation, administration, performance tuning, and security.
- Experience with Oracle database backup and recovery tools (e.g., RMAN).
- Strong knowledge of SQL, PL/SQL, and scripting languages.
- Familiarity with database replication technologies like Oracle Data Guard and GoldenGate.
- Experience with Oracle RAC and Oracle Exadata is a plus.
- Strong troubleshooting and problem-solving skills.
- Knowledge of cloud platforms (e.g., Oracle Cloud, AWS, Azure) is a plus.
- Excellent communication and teamwork skills.
