Oracle Database Developer
- Plano, TX
- Permanent
- Full-time
Plano, TX (ONLY LOCAL CANDIDATES)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.