PL/SQL Developer

Experience-8+years

Location -Plano TX

Roles & Responsibilities

Salary -100-110k PA

Skills -Oracle PL/SQL -Production support

• Replicating, Multi-Data Center Oracle database management.
• Developing and testing packages and stored procedures using PL/SQL.
• Troubleshooting, performance, and tuning mission critical databases.
• Strong, demonstrated abilities to tune queries and to analyze AWR reports to prevent and diagnose performance-related issues in the Database.
• Implementing and executing code-based CI/CD deployment plans on the back end is preferred.
• Work with engineering and application support teams to identify, triage, and resolve performance issues.
• This requires expertise in database level tuning and the ability to analyze, optimize and tune complex SQL queries.
• Ability to analyze informational content of backend APIs/Messages and driver relational database design to meet business requirements.
• Monitors database and replication servers for resource utilization.
• Uses knowledge and expertise of existing database environments to make recommendations for opportunities to share data and/or reduce data redundancies.
• Analyze performance results to identify bottlenecks, potential optimizations and highlight opportunities for performance improvements.