What are the responsibilities and job description for the Oracle DBA position at VeeRteq Solutions LLC?
Job Title: Oracle DBA Location: Jacksonville, FL Job Summary:
As an Oracle DBA, you will be responsible for the design, implementation, and maintenance of Oracle databases within our organization. With a strong background in SQL database administration and Linux systems, you will ensure the optimal performance, security, and reliability of our database systems. You will also be tasked with troubleshooting and resolving database-related issues, automating processes, and ensuring best practices for data management are followed.
Key Responsibilities
As an Oracle DBA, you will be responsible for the design, implementation, and maintenance of Oracle databases within our organization. With a strong background in SQL database administration and Linux systems, you will ensure the optimal performance, security, and reliability of our database systems. You will also be tasked with troubleshooting and resolving database-related issues, automating processes, and ensuring best practices for data management are followed.
Key Responsibilities
- Install, configure, and maintain Oracle databases, ensuring optimal performance, security, and availability.
- Perform database backups, restore, and disaster recovery procedures.
- Monitor database performance and optimize query performance using tools like Oracle Enterprise Manager, SQL tuning, and indexing.
- Perform database upgrades and patching, ensuring that Oracle environments are up-to-date with the latest patches and security fixes.
- Manage and maintain SQL databases, including performance tuning, query optimization, and troubleshooting.
- Collaborate with developers, system administrators, and network engineers to ensure that databases are properly integrated with applications and infrastructure.
- Administer Linux-based systems that support Oracle databases, ensuring proper system configuration, security, and performance.
- Implement and manage database replication, clustering, and high-availability solutions (e.g., Oracle RAC).
- Create and maintain database scripts, jobs, and schedules for automation and operational efficiency.
- Perform routine database maintenance tasks such as reorganization, data archiving, and table partitioning.
- Troubleshoot and resolve database-related issues, including performance bottlenecks, query failures, and data corruption.
- Develop and implement security policies for database access, encryption, and auditing to ensure compliance with industry standards and regulations.
- Maintain and optimize database storage, ensuring efficient use of space and capacity.
- Prepare and maintain documentation related to database architecture, processes, and procedures.
- Participate in on-call support for database issues as needed.
- 10 years of overall experience in the IT industry.
- Strong experience with Oracle database administration (versions 11g, 12c, and beyond).
- Solid background as a SQL DBA, with expertise in SQL Server or similar relational databases.
- In-depth knowledge of Linux administration, including experience with Linux-based systems that support Oracle databases.
- Strong experience in database backup, recovery, and disaster recovery planning.
- Proven ability to optimize database performance, including SQL query tuning, indexing, and storage management.
- Hands-on experience with Oracle RAC (Real Application Clusters) and Oracle Data Guard for high availability and disaster recovery.
- Experience with database monitoring tools such as Oracle Enterprise Manager or other third-party solutions.
- Familiarity with database automation tools for provisioning, patching, and backup.
- Knowledge of database security best practices, including encryption, access control, and auditing.
- Strong understanding of database storage management and disk performance optimization.
- Proficiency in writing shell scripts and SQL scripts to automate tasks and enhance efficiency.
- Excellent troubleshooting skills, with the ability to diagnose and resolve complex database issues.
- Strong communication and collaboration skills, with the ability to work across teams to resolve database-related challenges.
- Experience with Oracle Exadata and other Oracle engineered systems.
- Familiarity with cloud-based databases (e.g., Oracle Cloud, AWS RDS, Azure SQL Database).
- Experience with performance tuning and load balancing in Oracle databases.
- Knowledge of containerization technologies like Docker, particularly in database environments.
- Experience with DevOps tools and practices related to database provisioning and deployment.
- Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent practical experience).
- 10 years of experience in the IT industry.
