What are the responsibilities and job description for the Oracle PL/ SQL Developer position at HS Solutions?
Job Details
Position : Oracle PL/ SQL Developer Location: Miami, FL.
Duration : Long Term Contract
Key Responsibilities:
- Collaborate with cross-departmental enterprise stakeholders to design and develop database solutions.
- Develop and optimize PL/SQL code for various applications.
- Work closely with development teams to peer review code and deploy it using Gitlab, Bitbucket, and Jenkins CI/CD pipelines.
- Design database systems to meet complex business needs and create appropriate technical documentation to support project delivery and support plans.
- Develop and maintain stored procedures, functions, triggers, and other advanced PL/SQL concepts like records and collections.
- Ensure code and design quality with appropriate logging, monitoring, tracing, and security standards in place.
- Help troubleshoot and resolve issues related to database performance and integrity.
- Perform root cause analysis for production issues and come up with solutions that will prevent them from happening in the future.
- Participate and contribute to grooming technical user stories.
- Mentor and coach junior members of the team on database development best practices.
Education and Experience:
- Bachelor s degree in computer science or related field.
- At least 10 years of experience with Oracle SQL and PL/SQL Development.
- At least 8 years experience in advanced PL/SQL concepts like records and collections.
- Database performance tuning skills.
- Experience and knowledge of Linux Shell scripting.
- Experience with Java or Oracle BRM is a plus.
- At least 3 years of experience in the software development life cycle.
- Ability to work in a team in a diverse/multiple stakeholder environment.
- Experience in the Telecom domain is required.
- Excellent Analytical and communication skills are a big plus.
- Experience and desire to work in a global delivery environment.
Skills and Qualifications:
- Extensive experience developing PL/SQL code.
- Excellent stakeholder management and communications skills are required.
- Experience with CI/CD processes & technologies.
- Demonstrated performance of threat modeling, risk assessment techniques, and code reviews.
- Experience working with Oracle databases.
- Experience using tools such as JIRA, Confluence, Bitbucket, or other Git-based source control.
- Experience with database design and architecture.
- Experience with data migration and ETL processes.
- Proficiency in the following concepts:
- Oracle Cursors
- Collections
- Procedures, Packages, Functions
- Bulk Collect
- Materialized Views
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
