Oracle Developer

Greetings, Hope you are doing well. Please go through below Job description and lf you are comfort/available for the position then respond with latest/updated resume to srinivas@wavsols.com or 630-397-0596/140 Job Title: Oracle Developer Duration: 6+ Months Zip Code: 28262 Location: Charlotte, NC Required Skills: • 7+ years pl/sql oracle development • Experience with 12c or exidata required • Strong programming/development skills using PL/SQL (package, procedures, functions, triggers) and batch coding skills such as Bulk collections, dynamic SQL, and parallel processing. • Ability to troubleshoot and diagnose problems quickly and communicate proposed solutions • Knowledge and experience with Performance tuning • Developing PL/SQL Packages, Procedures Functions, Cursors and Triggers. • Proficient in performance tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing and Hints. • Business logic development experience • Ability to understand large data sets and create reports • Self starter- end to end development with no guidance Day to Day Responsibilities/project specifics: Wholesale customer onboarding conducts periodic reviews of medium and high risk customers manually. This project will be to utalize mongoDB/big data to automate this process by bringing in 3rd party data to compare to our data to inquire if periodic review is necessary for the customer, or if the data we have is sufficient. This person will be helping from the ground up with the deisgn of the database structure onward to take leadership over this aspect of the overall initiative. Provides the highest technical expertise for the planning, analysis, design, implementation, maintenance, and control of the organization's server-class database, engaging with DBA teams, architecture, Scrum Master, QA, BSA, Product and supporting teams to create efficient and consistent solutions. Assures successful sprint and release planning following agile development methodology. Leads the most complex or critical data/ database management initiatives that typically involve multiple disciplines and multiple business groups, including database architecture, design, integration, and/or data modeling. Assists operations team in database installations, including troubleshooting and problem resolution. Recommends improvements to web application processing issues and design. As the recognized technical expert, consults extensively with multiple client groups to provide strategic solutions, influencing longrange internal and enterprise-level data/ database architecture and management strategies. Designs and certifies next generation database technologies related to Oracle 18 and 19C, PostgreSQL, AWS RDS, AWS RedShift, MongoDB, CouchBase, Vertica etc. Oracle Streams, High Availability systems, Partitioning, Data Guard/Standby Database, Change Data Capture, Data Warehousing. Handles multiple/conflicting projects and deadlines. Works on call and provides 24/7 production support. Communicates with management, development teams, vendors and systems administrators on a variety of technical issues. Interacts with customers (internal / external) to meet process deliverables. Provides technical leadership and recommendations into the future direction of database technology. Mentors and trains DBA operations team with the installation, configuration, and maintenance of databases, provide knowledge transfer on a regular basis. Develops best practices and enforce these standards across the team. Required Qualifications: 7+ years of database (DB) technologies experience 3+ years of Logical + Physical Data Modeling experience 7+ years of experience in software development Desired Qualifications; Working knowledge of Agile methodologies and tools Strong technical and task/timeline-oriented skills Experience implementing new technologies Experience managing one or more industry-standard development tools or scripting languages Experience with large data sets, transactional platforms, or a combination of both