Job Description
Job Details
:PositionOracle DBA (Ref: 16452)
:LocationNashville, TN 37243 United States
:Duration6 Months 15 Days - Contract
:Openings1
:Deadline10/18/2024
Pay Rate:
Description:
***Remote
We are looking for a 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 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, 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, 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.
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.
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.
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.
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.
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.
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.
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.
Required / Desired Skills
- Oracle (Required 7 Years)
- Oracle 12c (Required 7 Years)
- Oracle 8i/9i/10g (Required 7 Years)
- Oracle Exadata (Required 7 Years)
- PostgreSQL (Required 4 Years)
Job Tags
Contract work, Remote job,