| Looking for Pega Devisioning Consultants & Oracle PL/SQL Developer for Hybrid Roles at Irving, Texas, USA |
| Email: [email protected] |
| Title: Oracle PL/SQL Developer with Performance Tuning (AWR Report) Location: Irving, TX, Silver Spring, MD, Ashburn, VA, Bedminster, NJ (Hybrid) Duration: Long Term Need senior solid candidate, Strong PLSQL coding exp in production environment. Able to Analyze AWR report and do performance tuning by PLSQL Query. Development PL/SQL expert - collections, bulk collect and DML, exception handling, best practices for performance and scalability. Data modelling - basic ER creation / maintenance, strong data modelling principles, strong physical modelling (indexes global vs. local, partitions, mat views) Performance Tuning AWR analysis - identify system bottlenecks, poorly performing SQL / DML, misuse of DB resources, and provide solutions incl communicating with and educating development teams on best practices Query tuning - analysis of why a query is slow and provide recommendations for indexing, rewrites, hints, etc. Complex query tuning - able to analyze very large and complex queries to isolate the trouble spots and provide solutions as above. Proficiency with other tools such as ASH, ADDM, TKPROF, DBMS_PROFILE, SQLT Ideally the candidate should have a deep knowledge of Oracle DB internals and be able to communicate / educate on how to best take advantage of the database for business needs. Top must have Skills: Experienced SQL & PL/SQL developers (lets start small max 3) with 6+ years relevant hands-on experience including complex query performance analysis and tuning. Experience using AWR, ADDM, ASH for application / database tuning is also required. Experience using Toad and/or SQL Developer for tuning / coding. Candidates should be detail oriented and have good written and oral communication skills. They should have worked (hands on) Oracle 19c and previous Oracle versions for the above requirements Job Title : Pega Decisioning Consultant Location : Irving, TX (Hybrid) Duration: Long Term Working Model : Hybrid, 2-3 days in the office Must Have Skills: (Most Important): PEGA PRPC 8+, CDH, Java Script, HTML 5.0. Desired Skills: NBA Designer, ADM, PEGA 8.8.3, 1:1 customer engagement optimization, 1:1 customer engagement Implementation. Education/Certifications: Bachelor's in computer science or equivalent Certifications: CSSA with CPDC/CPMC. Responsibilities: Lead Design and develop Applications using Pega CDH. Manage Proposition/Offer matrix. Review the implementation and follow standards. Design and manage ADM and predictive models. Develop Next Best Action Strategies. Responsible for development of agile stories as indicated by the lead. Responsible to make sure the changes are deployed successfully to higher environments. Should be working closely with QA team to ensure the changes are tested properly. Act as a mentor to junior resources. Experience with Pega PRPC technologies. Experience working on Pega DSM (Decision Management). Experience on the ADM and predictive models Nice to have understanding of Inbound marketing. Good understanding of the Strategies and the proposition management Job Duties: You will be responsible to Review requirements, design and implementation of applications using Pega CDH to the VZ internal organization. You are required to understand the role of different systems in the organization and guide the team to fetch and post data from & to the right source. You are responsible to consider application scaling, performance, & other operational aspects during design and ensure they are met. In this role, you will be interacting with Business, Marketing, IT, PMO, and various other stakeholders offshore and onshore. As most of the meetings happen in the US time, you will be responsible to plan the work so it is done seamlessly by teams across geography. This role requires regular status updates to the management. Ensure the status of the ongoing Initiatives, post production monitoring, end-end utilization, system specific metrics, management deck updates are accurate. Participate in team calls, schedule calls with stakeholders, development, testing, and other teams. Thanks & Regards, Syed Mubasheer "Certified Woman Owned Minority Business Enterprise (WMBE)" 222 West Las Colinas Blvd, Suite # 540, East Towers, Irving, Texas, 75039 USA Email: [email protected] Keywords: quality analyst database information technology procedural language Maryland New Jersey Texas Virginia Looking for Pega Devisioning Consultants & Oracle PL/SQL Developer for Hybrid Roles [email protected] |
| [email protected] View all |
| Tue Apr 23 22:24:00 UTC 2024 |