What You'll Do
Design and maintain robust Oracle database architectures that support scalability and reliability. You'll configure instances, manage storage structures like tablespaces and redo logs, and ensure optimal performance through proactive monitoring and tuning.
Implement secure access controls, encryption, and auditing practices to protect sensitive data. You'll enforce least-privilege principles, manage user roles, and align database policies with compliance standards.
Perform regular maintenance including patching, version upgrades, and migration activities with minimal disruption. You'll plan and execute these changes across development, testing, and production environments while maintaining system stability.
Develop and manage backup strategies using RMAN, ensuring reliable recovery points and tested disaster recovery procedures. You'll define and verify recovery time and point objectives, regularly testing recovery workflows.
Analyze performance metrics using diagnostic tools such as AWR, ASH, or sp-reports to detect bottlenecks. Optimize queries, indexes, and execution plans in collaboration with developers to enhance application efficiency.
Automate routine tasks using scripting languages like Shell, Bash, Python, or SQL. You'll build and maintain scripts for monitoring, backups, and system checks to improve operational consistency.
Requirements
- Hold a Bachelor’s degree in Computer Science, Information Technology, or a related discipline
- Demonstrate extensive hands-on experience administering Oracle databases in production environments
- Possess strong command of SQL, including query optimization and schema design
- Show proficiency in database architecture, normalization, indexing, and performance tuning
- Have practical experience with installation, configuration, patching, and monitoring of Oracle systems
- Be skilled in using RMAN or similar tools for backup and recovery operations
- Be comfortable working in Linux/Unix environments and writing automation scripts
- Understand security best practices including authentication, access control, and encryption
- Display strong analytical abilities to troubleshoot complex database issues
- Communicate effectively with technical teams and stakeholders
- Operate fluently in both Polish and English
Technical Environment
You'll work with Oracle Database technologies, focusing on administration, replication, clustering, and failover solutions. The role leverages SQL, scripting tools, and performance diagnostics to maintain resilient, high-performing systems.
