Oracle PL/SQL Lead - 100% Remote
Georgia IT, Inc.
Job Description
Oracle PL/SQL - 100% Remote
Job Location: Remote in Mexico/Brazil
Job Type: Contract
Job Description:
We are seeking an experienced Senior Specialist in Oracle Database Administration to manage, optimize, and support complex Oracle database environments. The ideal candidate will bring deep expertise in database performance tuning, administration, and cloud migration, while ensuring security, reliability, and compliance.
Key Responsibilities
Administer and maintain Oracle database environments to ensure high availability, reliability, and optimal performance.
Perform advanced DBA tasks including installation, configuration, patching, upgrades, and monitoring.
Conduct backups, recovery, and disaster recovery planning/implementation.
Optimize database performance through query tuning, indexing, and execution plan analysis.
Collaborate with development teams to support application/database requirements and resolve issues.
Implement and maintain security, compliance, and data integrity standards across all environments.
Lead migration and upgrade projects, including on-premises to cloud transitions.
Document configurations, processes, and procedures to ensure operational consistency.
Stay current with latest Oracle database technologies, features, and best practices.
Roles and Expectations
- Design, develop, and optimize complex SQL queries and PL/SQL procedures.
- Perform in-depth troubleshooting and performance tuning for databases and queries.
- Analyze execution plans and recommend strategies for query/database optimization.
- Collaborate effectively with DBAs, data architects, and analysts to implement optimization and governance strategies.
- Monitor database performance metrics and implement proactive improvements.
- Drive data migration and modernization initiatives, with a strong focus on cloud adoption.
- Establish and enforce best practices for governance, security, and compliance.
- Act as a senior technical resource, participating in interviews and technical assessments for Oracle DBA candidates.