Title: Oracle Database Admin
Local Nashville, Tennessee, Remote
Oracle Advanced (7-9 Years)
Oracle 12c Advanced (7-9 Years)
Oracle 8i/9i/10g Advanced (7-9 Years)
Oracle Exadata Advanced (7-9 Years)
PostgreSQL Proficient (4-6 Years)
Key Responsibilities:
- 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 with 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 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.
Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Minimum of 5 years of experience in database administration with a focus on Oracle and PostgreSQL.
- Advanced knowledge of database architecture, performance tuning, and security principles.
- Strong problem-solving skills and ability to work under pressure.
- Familiarity with automation tools and scripting languages.