PL/SQL Developer

Vintti is a forward-thinking staffing agency at the forefront of global talent solutions. We specialize in connecting US-based SMBs, startups, and firms with highly skilled professionals from Latin America. Our innovative approach breaks down geographical barriers, allowing businesses to tap into a rich pool of diverse talent while offering Latin American professionals access to exciting international career opportunities. Vintti builds bridges across continents, fostering cultural exchange and driving business growth through strategic staffing solutions.

A PL/SQL Developer specializes in leveraging Oracle's PL/SQL language to design, code, and maintain database systems. This role involves writing efficient, scalable, and secure stored procedures, functions, and packages to support various applications and business needs. The developer collaborates with data analysts, database administrators, and application developers to optimize and troubleshoot PL/SQL code, ensuring high performance and reliability. Utilizing a thorough understanding of relational database principles, the PL/SQL Developer plays a critical role in managing data integrity and enhancing transaction processes within the organization.

- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 3+ years of experience working with PL/SQL development.
- Strong knowledge of Oracle databases and PL/SQL programming.
- Proficiency in writing complex SQL queries and optimizing performance.
- Experience with database design, data modeling, and architecture.
- Familiarity with ETL processes and data warehousing principles.
- Understanding of database security standards and best practices.
- Experience with performance tuning and troubleshooting database issues.
- Ability to write and maintain technical documentation.
- Knowledge of scripting languages for automating database tasks.
- Experience with code versioning tools, such as Git.
- Strong analytical and problem-solving skills.
- Ability to work collaboratively with cross-functional teams.
- Excellent communication skills, both verbal and written.
- Experience performing code reviews and providing feedback.
- Familiarity with unit testing and integration testing methodologies.
- Ability to respond to and resolve production database issues promptly.
- Willingness to stay updated with latest database technologies and trends.
- Experience mentoring junior developers.
- Ability to translate business requirements into technical specifications.

- Develop, test, and deploy efficient PL/SQL packages, procedures, triggers, and functions.
- Analyze and optimize existing PL/SQL code to enhance performance and manageability.
- Collaborate with application developers to design and implement integrated database solutions.
- Write and maintain complex SQL queries for reporting and data extraction.
- Perform code reviews and provide constructive feedback to team members.
- Troubleshoot and resolve database-related issues, including performance bottlenecks and error logs.
- Participate in database design and data modeling sessions to ensure proper structure and data integrity.
- Create and maintain comprehensive technical documentation for database procedures and design.
- Implement and enforce database security standards and procedures.
- Monitor database health, including job runs, space utilization, and system performance metrics.
- Coordinate with QA teams to validate and verify database functionalities and performance.
- Manage database migrations, ensuring data integrity and minimal downtime.
- Develop and execute unit tests and integration tests for PL/SQL code.
- Assist in the development and maintenance of ETL processes for data warehousing solutions.
- Automate routine database procedures and maintenance tasks using scripting languages.
- Provide production support by responding to urgent database issues and deploying fixes.
- Stay updated on the latest database technologies and best practices through continued learning and research.
- Support application teams with complex SQL query writing and optimization.
- Participate in meetings to understand business requirements and translate them into technical specifications.
- Mentor junior developers and provide guidance on PL/SQL development best practices.

The ideal candidate for the role of PL/SQL Developer is a highly skilled and experienced professional with a Bachelor's degree in Computer Science, Information Technology, or a related field, backed by at least 3 years of hands-on experience in PL/SQL development. They possess an in-depth understanding of Oracle databases and exhibit proficiency in writing and optimizing complex SQL queries to enhance performance. This candidate has a strong foundation in database design, data modeling, and architecture, coupled with familiarity in ETL processes and data warehousing principles. They demonstrate a solid grasp of database security standards and best practices, along with exceptional problem-solving abilities for performance tuning and resolving database issues. As a meticulous individual, they excel in creating and maintaining thorough technical documentation and leverage scripting languages to automate database tasks efficiently. Their experience with code versioning tools like Git, coupled with a collaborative approach to cross-functional team engagements, highlights their technical adaptability and teamwork prowess. The ideal candidate is an excellent communicator, adept at performing code reviews, providing constructive feedback, and translating business requirements into technical specifications. They are proactive, eager to stay abreast of the latest database technologies, and showcase strong mentoring and leadership capabilities, nurturing junior developers. Passionate about coding and database management, they exhibit a strategic, detail-oriented mindset, capable of working efficiently under pressure while maintaining a commitment to high-quality work and continuous improvement. The candidate thrives in a dynamic environment, bringing innovative solutions and a deep technical acumen, making them a valuable asset to our team.

- Develop, test, and deploy efficient PL/SQL packages, procedures, triggers, and functions.
- Analyze and optimize existing PL/SQL code to enhance performance and manageability.
- Collaborate with application developers to design and implement integrated database solutions.
- Write and maintain complex SQL queries for reporting and data extraction.
- Perform code reviews and provide constructive feedback to team members.
- Troubleshoot and resolve database-related issues, including performance bottlenecks and error logs.
- Participate in database design and data modeling sessions to ensure proper structure and data integrity.
- Create and maintain comprehensive technical documentation for database procedures and design.
- Implement and enforce database security standards and procedures.
- Monitor database health, including job runs, space utilization, and system performance metrics.
- Coordinate with QA teams to validate and verify database functionalities and performance.
- Manage database migrations, ensuring data integrity and minimal downtime.
- Develop and execute unit tests and integration tests for PL/SQL code.
- Assist in the development and maintenance of ETL processes for data warehousing solutions.
- Automate routine database procedures and maintenance tasks using scripting languages.
- Provide production support by responding to urgent database issues and deploying fixes.
- Stay updated on the latest database technologies and best practices through continued learning and research.
- Support application teams with complex SQL query writing and optimization.
- Participate in meetings to understand business requirements and translate them into technical specifications.
- Mentor junior developers and provide guidance on PL/SQL development best practices.

- Detail-oriented and highly organized
- Strong problem-solving and analytical thinking
- Excellent communication and interpersonal skills
- Proactive and able to work independently
- Team player with a collaborative mindset
- Eager to learn and quickly adapt to new technologies
- Strong sense of responsibility and accountability
- Ability to work efficiently under pressure
- Strong time-management skills
- Strategic thinker with attention to detail
- Technically adept with a deep understanding of PL/SQL and Oracle databases
- Passionate about coding and database management
- Committed to high-quality work and continuous improvement
- Innovative mindset and approach to solving complex problems
- Strong mentoring and leadership qualities

- Competitive salary range commensurate with experience.
- Comprehensive health, dental, and vision insurance.
- Retirement savings plan with company match.
- Generous paid time off, including vacation, sick leave, and holidays.
- Flexible work schedule.
- Opportunities for remote work or hybrid work arrangements.
- Professional development and training programs.
- Tuition reimbursement for further education.
- Career advancement opportunities within the company.
- Employee wellness programs and resources.
- On-site fitness center or gym membership reimbursement.
- Casual dress code.
- Company-sponsored social events and activities.
- Access to the latest technologies and tools.
- Collaborative and inclusive work environment.
- Performance-based bonuses and incentives.
- Employee recognition awards and programs.
- Paid parental leave.
- Life and disability insurance.
- Commuter benefits or transportation stipends.
- Employee assistance program (EAP) for mental health and wellbeing.
- Subsidized meals or on-site cafeteria.