Database Administrator 3 at Careers Integrated Resources Inc

Job Title: Database Administrator 3

Job Location: Remote

Job Duration: 8+Months (Higher possibility of Extension)

Job Summary:

• 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.
• The candidate must also be willing to participate in a rotational 24x7 on-call Production Support.

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.

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.

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.

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.

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.

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.