Logo
Diverse Lynx

Oracle Database Developer

Diverse Lynx, Plano, Texas, us, 75086

Save Job

Amazon Web Service(AWS) Cloud Computing, Oracle Database 12C Administration

Oracle Database Developer is responsible for the design, development, implementation, and maintenance of database solutions using Oracle technologies.

Key responsibilities typically include: Database Design and Development: Designing logical data models and translating them into physical schema designs for Oracle databases. Creating and managing database objects such as tables, views, indexes, sequences, and synonyms. Developing and optimizing PL/SQL stored procedures, functions, packages, and triggers. Writing and tuning complex SQL queries for data retrieval, manipulation, and reporting. Performance and Optimization: Performing query tuning and database performance optimization. Troubleshooting and resolving database-related performance issues. Implementing and managing indexing strategies and partitioning techniques. Data Management and Security: Ensuring data integrity, security, and compliance with best practices. Developing and implementing data backup, recovery plans, and procedures. Managing database security and access controls. Collaboration and Support: Collaborating with application developers, database administrators, and other stakeholders to integrate database solutions and ensure seamless application functionality. Providing technical and functional support for Oracle-based applications and systems. Participating in code reviews, system testing, and deployment processes. Automation and Documentation: Developing and maintaining scripts for automation and data processing (e.g., using Unix Shell Scripting, Python). Creating and maintaining technical documentation for database designs, procedures, and processes.

Required Skills and Qualifications: Proficiency in SQL and PL/SQL. Experience with Oracle database versions (e.g., Oracle 12c, 19c). Understanding of relational database concepts and data modeling. Knowledge of database performance tuning and optimization techniques. Familiarity with database security principles and best practices. Strong problem-solving and analytical skills. Excellent communication and collaboration abilities. A Bachelor's degree in Computer Science, Information Systems, or a related field is often required.

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.