PLSQL Developer

Job Description

Position Name: Sr PL/SQL Developer Experience: 4+ years Primary Skill Set: PL/SQL Development, Triggers, Cursors, Collections, knowledge in PostgreSQL and Cassandra. Location: Hyderabad Job Description Sutherland Global is looking for a Senior PL/SQL Developer who will help build and maintain the database technologies that enable millions of Americans to connect and converse with information and one another. You will work in a complex, fast-paced, and highly elastic environment that provides opportunities to navigate different teams and projects. 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. Skills, Experience, and Requirements Education and Experience: • Bachelors degree in computer science or related field. • At least 8+ 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. 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 • Autonomous Transactions • Triggers • Exception Handling • SQL Queries writing skills • Performance tuning