Role Overview
As a Senior Oracle Database Administrator, you will oversee the full lifecycle of Oracle database systems, from design and deployment to performance tuning and security. Your work will directly impact system reliability, scalability, and data accessibility across development, testing, and production environments.
Key Responsibilities
- Design and implement database structures including schemas, tables, and indexes to support application needs and optimize query performance.
- Configure and maintain Oracle database instances, listeners, and Oracle homes across multiple environments.
- Monitor system health using diagnostic tools such as AWR/ASH and sp-reports to detect and resolve performance bottlenecks.
- Perform database upgrades, patches, and version migrations with minimal disruption to operations.
- Implement and manage robust backup strategies using RMAN, including full, incremental, and archived log backups.
- Regularly test recovery procedures and maintain documented disaster recovery plans aligned with defined RTO and RPO objectives.
- Enforce database security through user access controls, role-based privileges, encryption, and auditing in compliance with regulatory standards.
- Optimize SQL queries, execution plans, and indexing strategies in collaboration with developers to enhance application efficiency.
- Automate routine administrative tasks using Shell, Bash, Python, or SQL scripts to improve operational consistency and reduce manual effort.
- Support high availability and resilience through configuration of replication, clustering, and failover solutions.
- Participate in code and design reviews to ensure database alignment with application architecture and best practices.
- Document configurations, procedures, and runbooks to ensure operational clarity and continuity.
- Respond to production incidents as part of an on-call rotation, providing timely resolution for critical database issues.
- Conduct capacity planning and storage optimization to support long-term growth and performance demands.
- Stay current with evolving Oracle technologies, features, and industry trends through independent learning and professional engagement.
Qualifications
- Bachelor’s degree in Computer Science, Information Technology, or a related discipline.
- Proven experience administering Oracle databases in production environments.
- Strong command of SQL and deep understanding of query optimization, indexing, and execution plan analysis.
- Hands-on experience with database installation, configuration, patching, backup, recovery, and performance monitoring.
- Familiarity with RMAN for backup and recovery operations.
- Working knowledge of Linux/Unix systems and scripting languages for automation tasks.
- Understanding of data security principles, including authentication, access control, encryption, and compliance requirements.
- Strong analytical and problem-solving abilities when diagnosing complex database issues.
- Effective communication skills with the ability to collaborate across technical teams and stakeholders.
- Conversational proficiency in both Polish and English is required.
Technology Environment
- Oracle Database
- SQL and PL/SQL
- RMAN
- Linux and Unix operating systems
- Shell, Bash, and Python scripting
- Database replication, clustering, and failover architectures
- Performance monitoring with AWR/ASH and sp-reports
