Oracle /SQL Developer - Software Systems Specialist III (Remote, SE Texas) - CMC IT

This job was posted over 30 days ago, so it has most likely closed. See newer jobs like it.

Written by AI from the job title and company, not by Talentify.io, so some details may not match this job. The employer's own page has the real description.

Overview

The Oracle/SQL Developer - Software Systems Specialist III at CMC IT will play a pivotal role in designing, developing, and maintaining database solutions that support critical business applications. This position is responsible for analyzing system requirements, writing efficient SQL queries, ensuring data integrity, and optimizing database performance. The ideal candidate will work collaboratively with cross-functional teams to implement innovative database solutions in a remote environment, specifically servicing the southeast Texas region.

Job Responsibilities

• Develop and implement complex SQL queries and scripts to enhance application functionalities.
• Participate in architecture discussions to define database structures and frameworks.
• Optimize SQL and PL/SQL queries for performance enhancements.
• Collaborate with system architects and analysts to gather and analyze data requirements.
• Conduct thorough testing and debugging of database solutions to ensure reliability and accuracy.
• Document technical specifications, processes, and procedures for future reference.
• Support the deployment of database updates and upgrades while ensuring minimal disruption to services.
• Monitor database performance and resolve any issues related to data access and application functionality.
• Train and mentor junior developers on best practices in database development.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Minimum of 5 years of experience in Oracle and SQL development.
• Proficiency in PL/SQL, SQL, and database design principles.
• Strong understanding of database performance tuning and optimization techniques.
• Experience with data modeling tools and techniques.
• Familiarity with ETL processes and data warehousing concepts.
• Ability to communicate effectively with technical and non-technical stakeholders.
• Certifications in Oracle Database or relevant technologies are a plus.

Technologies & Tools

The position predominantly utilizes Oracle Database, SQL Server, PL/SQL, and supplementary tools for database administration and management. Familiarity with modern data analysis tools and ETL technology will be beneficial. Additionally, exposure to cloud database platforms and Agile development methodologies will enhance productivity and collaboration.

Ideal Candidates

The ideal candidate for this role should possess strong analytical skills, be detail-oriented, and have the ability to troubleshoot complex database issues. They should demonstrate a passion for continuous learning and staying current with the latest database technologies. Moreover, successful candidates will have excellent communication skills to effectively interact with team members and stakeholders, as well as a proactive approach to problem-solving and project management.