Oracle Database Administrator

As an Oracle Database Administrator / Developer at BizAcuity, your role involves administering, developing, and optimizing Oracle database environments on Microsoft Windows Server. You will utilize your expertise in Oracle APEX to support and enhance critical business systems. **Key Responsibilities:** - Install, configure, upgrade, and maintain Oracle Database on Windows Server - Administer Oracle services, listeners, and scheduled jobs in a Windows environment - Monitor database performance, availability, and capacity - Perform backup, recovery, and disaster recovery planning using RMAN - Manage users, roles, profiles, and database security - Troubleshoot Oracle database and Windows-related issues - Apply patches and updates for Oracle Database and related components **Oracle Development & APEX:** - Design, develop, and maintain applications using Oracle APEX - Develop and optimize SQL and PL/SQL (packages, procedures, functions, triggers) - Implement authentication, authorization, and security models in APEX - Integrate APEX applications with external systems and RESTful services - Maintain and enhance existing Oracle-based applications **Windows & Operations:** - Work with Windows Server services, scheduled tasks, and system monitoring - Coordinate with infrastructure teams for server maintenance and upgrades - Ensure compliance with security and operational standards in a Windows environment **Collaboration & Support:** - Gather and translate business requirements into technical solutions - Provide technical documentation and operational procedures - Support production environments and participate in incident resolution **Required Skills & Qualifications:** - Strong experience with Oracle Database Administration on Windows Server - Hands-on experience with Oracle APEX development - Advanced knowledge of SQL and PL/SQL - Experience with database backup, recovery, and performance tuning - Familiarity with Oracle networking (listeners, TNS) - Understanding of Windows Server administration fundamentals **Nice to Have:** - Experience with Oracle 19c or later - Knowledge of Oracle REST Data Services (ORDS) - Experience with IIS or APEX deployment on Windows - Familiarity with Oracle Cloud or hybrid environments - Oracle certifications (OCP, APEX Specialist) **Education & Experience:** - Degree in Computer Science, IT, or equivalent professional experience - 5+ years of experience with Oracle databases and PL/SQL - Proven experience developing and supporting Oracle APEX applications At BizAcuity, we are dedicated to helping enterprises optimize their data through Business Intelligence and Data Analytics services. Established in 2011, we have a strong leadership team and a talented group of over 200 engineers. Join us in delivering high-quality enterprise solutions using the latest technologies in data engineering and analytics. As an Oracle Database Administrator / Developer at BizAcuity, your role involves administering, developing, and optimizing Oracle database environments on Microsoft Windows Server. You will utilize your expertise in Oracle APEX to support and enhance critical business systems. **Key Responsibilities:** - Install, configure, upgrade, and maintain Oracle Database on Windows Server - Administer Oracle services, listeners, and scheduled jobs in a Windows environment - Monitor database performance, availability, and capacity - Perform backup, recovery, and disaster recovery planning using RMAN - Manage users, roles, profiles, and database security - Troubleshoot Oracle database and Windows-related issues - Apply patches and updates for Oracle Database and related components **Oracle Development & APEX:** - Design, develop, and maintain applications using Oracle APEX - Develop and optimize SQL and PL/SQL (packages, procedures, functions, triggers) - Implement authentication, authorization, and security models in APEX - Integrate APEX applications with external systems and RESTful services - Maintain and enhance existing Oracle-based applications **Windows & Operations:** - Work with Windows Server services, scheduled tasks, and system monitoring - Coordinate with infrastructure teams for server maintenance and upgrades - Ensure compliance with security and operational standards in a Windows environment **Collaboration & Support:** - Gather and translate business requirements into technical solutions - Provide technical documentation and operational procedures - Support production environments and participate in incident resolution **Required Skills & Qualifications:** - Strong experience with Oracle Database Administration on Windows Server - Hands-on experience with Oracle APEX development - Advanced knowledge of SQL and PL/SQL - Experience with database backup, recovery, and performance tuning - Familiarity with Oracle networking (listeners, TNS) - Understanding of Windows Server administration fundamentals **Nice to Have:** - Experience with Oracle 19c or later