Installing, configuring, and maintaining Oracle & Postgres database software and related tools.
Working with developers to design and implement new database features and structures.
Monitoring database performance, identifying bottlenecks, and optimizing database settings for optimal performance.
Developing and implementing backup and recovery strategies to ensure data availability and recoverability in case of failures.
Implementing security measures, managing user access, and ensuring compliance with security policies.
Performing database upgrades, applying patches, and maintaining the database environment.
Investigating and resolving database-related issues, including performance problems and security breaches.
Monitoring database health, security, and setting up alerts for critical issues.
Documenting database configurations, procedures, and troubleshooting steps.
Planning for future database growth and capacity needs.
Collaborating with developers to optimize database usage and performance.
Requirements
Strong understanding of Oracle & PostgreSQL database concepts, architecture, and administration.
Proven experience administering Oracle databases in production environments including creating, migrating databases and applying patches using command line tools.
Experience with Oracle's backup and recovery tools (e.g., RMAN).
Strong understanding of Oracle SQL tuning, indexing, and schema management.
Scripting proficiency and comfortable using the Linux command line shell environment and all its tools.
Knowledge of database security best practices.
Experience with performance monitoring and tuning tools.