Oracle DBA

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 administration 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.

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.