We are looking for senior-level database administrator with advanced expertise in both Oracle and PostgreSQL, along with a deep understanding of database architectures, security principles, and performance tuning methodologies. The candidate should also have strong problem-solving skills, attention to detail, and the ability to work under pressure while managing multiple complex database systems.
1. Database Installation and Configuration
· Install, configure, and maintain Oracle Multi-Tenant Architecture and PostgreSQL database servers.
· Set up instances, database parameters, and schema objects.
· Perform upgrades and patch management to ensure databases are up-to-date with the latest features and security patches.
· Experience Red Hat Linux Operating Systems.
2. Database Architecture and Design
· Collaborate with development teams to design and implement efficient, scalable database solutions.
· Create database structures, including tables, views, indexes, and constraints.
· Define data storage, indexing strategies, and partitioning schemes for optimal performance.
3. Database Performance Monitoring and Tuning
· Monitor database performance and system resource utilization to ensure high availability.
· Identify bottlenecks, analyze slow queries, and tune databases for optimal performance.
· Utilize tools like Oracle AWR, PostgreSQL pg_stat_statements, and other performance analysis tools.
· Implement performance improvements such as indexing, query optimization, and caching mechanisms.
4. Backup and Recovery
· Implement and manage backup and disaster recovery strategies (e.g., RMAN for Oracle, pg_dump for PostgreSQL).
· Ensure data integrity and availability through regular backups and replication.
· Perform recovery tasks in the event of database corruption or failure.
5. Security Management
· Configure and maintain database security, ensuring appropriate user permissions and roles are in place.
· Encrypt sensitive data, ensure secure connections, and apply security best practices.
· Monitor for potential security threats and resolve vulnerabilities in both Oracle and PostgreSQL environments.
6. Capacity Planning and Scalability
· Analyze and forecast future database storage requirements.
· Plan for scalability, ensuring the databases can handle increasing workloads and data growth.
· Optimize database storage and processing capabilities, balancing performance with cost.
7. Data Migration and Integration
· Perform data migrations between Oracle, PostgreSQL, and other databases.
· Develop and manage ETL (Extract, Transform, Load) processes for data movement and transformation.
· Ensure data consistency and integrity during migration and integration efforts.
8. High Availability and Clustering
· Implement and manage high availability solutions such as Oracle Data Guard Replication, RAC and PostgreSQL streaming replication or clustering.
· Configure failover mechanisms to minimize downtime in case of hardware or software failure.
9. Database Troubleshooting and Issue Resolution
· Resolve database-related incidents such as connectivity issues, slow performance, and data corruption.
· Provide technical support to development and operations teams for database-related problems.
· Perform root cause analysis and implement preventive measures.
10. Automation and Scripting
· Automate routine database administration tasks using scripts (e.g., Bash, PowerShell, PL/SQL for Oracle, PL/pgSQL for PostgreSQL).
· Develop automation tools for monitoring, backups, and performance tuning.
11. Collaboration and Documentation
· Work closely with development, DevOps, and infrastructure teams to support application and system requirements.
· Document database configurations, processes, and procedures.
· Provide training and mentoring to junior DBAs or development teams on database best practices.
12. Compliance and Auditing
· Ensure databases comply with relevant regulatory standards (e.g., GDPR, SOX, HIPAA).
· Regularly audit database security, usage, and access logs.
· Manage and maintain database audit trails and security logs.
13. Innovation and Continuous Improvement
· Stay current with new database technologies, tools, and techniques.
· Propose and implement improvements to database systems, increasing efficiency, performance, and security.