Senior Database Administrator - Oracle

Auctane Poland Sp. z o.o. is an international company with a team representing 20 nationalities and speaking 10 languages. The company operates in a cross-cultural atmosphere with English as the company language. The role involves working on international projects and collaborating with IT teams, developers, and business stakeholders to maintain and optimize relational database systems.

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Strong knowledge and hands-on experience with Oracle Database Administration.
• In-depth knowledge and proficiency in SQL (Structured Query Language).
• Proficiency in managing SQL database systems.
• Solid understanding of database architecture, data modeling, normalization, indexing, and query optimization techniques.
• Experience in database administration tasks such as installation, configuration, backup and recovery, security management, and performance tuning.
• Experience with core database administration activities including installation, configuration, patching, backup and recovery, performance tuning, and monitoring.
• Experience using Oracle Recovery Manager (RMAN) or equivalent tools for backup and recovery operations.
• Familiarity with Linux/Unix environments and basic scripting for automation of administrative tasks.
• Knowledge of database security best practices and experience implementing security measures such as user authentication, access controls, encryption, and auditing.
• Strong troubleshooting and problem-solving skills with the ability to diagnose complex database issues.
• Effective communication and collaboration skills to work with development and infrastructure teams.
• Communicative level of English and Polish.

• Develop database schemas, tables, and indexes to optimize performance and ensure data integrity.
• Implement and maintain database security measures, including user authentication, access controls, and data encryption.
• Analyze and interpret database performance metrics to proactively identify areas for improvement.
• Install, configure, and maintain Oracle database software and related components across development, testing, and production environments.
• Perform database upgrades, migrations, and patching (PSU/RU) while minimizing downtime.
• Manage Oracle homes, database instances, and listener configuration.
• Plan and execute database version upgrades and compatibility changes.
• Monitor database performance and troubleshoot issues such as slow queries, database locks, and resource contention.
• Maintain and review AWR/ASH-like diagnostic reports or equivalent monitoring data.
• Identify and address performance bottlenecks through query optimization, index tuning, and database configuration adjustments.
• Perform regular backups and disaster recovery procedures to ensure data availability and integrity.
• Configure and maintain RMAN backup strategies including full, incremental, and archived log backups.
• Regularly test database recovery procedures to ensure disaster recovery readiness.
• Document and maintain disaster recovery plans and recovery time objectives (RTO/RPO).
• Manage tablespaces, data files, redo logs, and archive logs.
• Perform capacity planning and forecasting to support future growth.
• Optimize storage allocation and database layout to improve I/O performance.
• Manage user roles, privileges, and access policies following least-privilege principles.
• Ensure compliance with data protection policies and regulatory requirements.
• Develop automation scripts (Shell, Bash, Python, or SQL scripts) for routine administrative tasks.
• Automate backup verification, monitoring checks, and maintenance tasks.
• Perform database maintenance.