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.
Salary Range: $100,000 to $120,000 per year
Salary Range
$100,000-$120,000 a year
Desired Candidate Profile
Qualifications : BACHELOR OF COMPUTER SCIENCE