Oracle DBA
Share
Job Location:
Monthly Salary:
Posted on:
3 hours ago
Vacancies:
1 Vacancy
Job Summary
Oracle DBA
Irving TX / Tampa FL / Edison NJ
Irving TX / Tampa FL / Edison NJ
Job Description
Must Have Technical/Functional Skills
Oracle DBA
Mandatory
Oracle DBA prior experience needed
Mastery of SQL and PL/SQL.
Proficiency in Linux/Unix and Windows Server operating systems.
Experience with scripting languages like Shell Python or Perl for automation.
Knowledge of cloud platforms (e.g. Oracle Cloud Infrastructure (OCI) AWS or Azure) is increasingly required.
Certifications: Oracle Certified Professional (OCP) or Oracle Certified Master (OCM) certifications are highly desirable.
PL/SQL Proficiency (Mandatory):
Extensive experience in developing debugging and optimizing complex stored procedures functions triggers and packages using PL/SQL.
Strong understanding of relational database concepts including normalization indexing and referential integrity.
Experience with a major relational database system (e.g. Oracle PostgreSQL SQL Server).
Performance Tuning (Must Have)
Proven ability to diagnose and resolve database performance issues across relational and NoSQL environments.
Expertise in query optimization (e.g. analyzing execution plans rewriting inefficient queries).
Experience with index tuning partitioning strategies and database configuration for optimal performance.
Familiarity with database monitoring tools and techniques.
Design and administratio of Oracle DB in financial domain
Work on PL-SQL queries development fine tuning and migration
Design and development of Cloud based DWH using Snowflake
Implementation and Roll-out of on prem and cloud-based application development projects
Work on fixing application issues and enhancement items
Mentoring junior developers in the team and identify opportunities for product improvements implementation of best practices et al.
Work on application troubleshooting perform root cause analysis as well as address identified issues
Track the project status issues risks and updates timely with senior leadership.
Key Skills
- Administration & Operation
- DBA
- Design Management
- Drafting
- Administrative Services
- Corrosion
