Plsql Developer

Oracle Sr. PL/SQL Developer

Position Summary

Working in an agile software development environment, the Oracle Sr.PL/SQL developer is responsible design and documentation at an application level for wide variety of applications/services. The candidate would utilize engineering and programming skills focused on participating with Architecture, Operations and Enterprise Delivery PPM teams within Agile processes. The role will include systems and solution design within the existing architecture, as well as design/implementation of improvements to meet business needs. The candidate will work collaboratively with the Development, IT Operations, and QA teams both onshore and offshore in implementing software configuration management best practices to accelerate and optimize delivery methodologies. The candidate is responsible for preparing value stream mapping and look for continuous improvement.

The ideal candidate will be a team player and a self-starter who enjoys a fast-paced job, thrives on problem solving, and is committed to delivering seamless product availability to large enterprises.

Job Responsibilities

• Responsible for maintaining the tools and processes for a large, enterprise level system in a fast-paced, agile, service-oriented environment.
• Work with team members to manage and administer enterprise-wide development tools – GIT, GitHub, SVN (Subversion), SonarQube, Confluence.
• Automate build, packaging, testing, and deployment processes using DB scripts.
• Responsible for continuous integration and continuous deployment for multiple initiatives across all products.
• Work with production release team to identify and implement methodology for highly flexible and responsive releases (weekly, biweekly, monthly, and bimonthly).
• Automate end to end build processes, patching, and production product deployments.
• Structure and maintain the software configuration management to build very secure and high availability systems.
• Working closely with Delivery teams to engineer solutions for production/enterprise automation efforts across all lines of business within Enterprise Delivery PPM.
• Review deployment procedures and execute deployments that ensure environment reproducibility.
• Incorporate software testing automation at multiple levels (component, configuration item, subsystem, system) and monitor results.
• Emphasize automation, implement processes, procedures, and best practice guidelines for code management.
• Guide teams with development best practices, including improved scalability, performance, reliability, and speed to market.

RELEVANT EXPERIENCE & QUALIFICATIONS

• Masters or bachelor’s in engineering in IT/ Electronics / Communication / Computer Science / Information Systems.
• 8+ years of experience in Oracle Database Development with latest development skills on Oracle PLSQL
• Experience using the SQL Developer or Toad software packages
• Experience with writing ad hoc scripts and stored procedures/functions
• Experience writing queries, Views, procedures, functions, packages, and reports for enterprise Oracle environment
• Designing databases/schemas and ensuring their stability, reliability, and performance.
• Design, model, create, and implement database systems based on the end user's requirements.
• Experience in performance tuning of SQL and PL/SQL.
• Analyse and suggest improvements for application's performance.
• Identifying and fixing issues from DB side as well as application end.
• Experience in Data Modelling and Query Optimization
• Nice to have No SQL DB / AWS RDS or similar experience
• Prepare documentations for database applications.
• Familiarity with Enterprise Oracle DB deployments.
• Experience with collaborative version control systems (Git/ GitHub/ Subversion/ Bitbucket).
• CI/CD Project Management Tools: JIRA, Confluence.
• Release deployments and support

ATTRIBUTES AND BEHAVIORS

• Works collaboratively with technical staff and reporting officials to resolve data discrepancies and/or to clarify reporting procedures
• Maintains an accurate and comprehensive inventory of data, data systems, data architecture, and data storage
• Processes data extracts using data retrieval and management tools
• Builds effective partnerships with co-workers throughout the organization by freely sharing appropriate information and helping when needed
• Assists with other duties as assigned
• Protects confidential information

SKILLS & COMPETENCIES

• Excellent verbal and written communication skills
• Strong organizational skills and adaptive capacity for rapidly changing priorities and workloads
• Ability to work well independently and maintain focus in a highly dynamic work environment.
• Comfort in working with team members that are remote and located in the US, India, or other geographies
• Ability to work within a matrix organization