PlSQL Architect

2 days ago

Pune Maharashtra, India Virtusa Full time

Skills from Primary Skill Cluster Oracle PL/SQL(19c), Oracle Performance Tuning, Unix, DB Parameters tuning, data pump or other DB native, ETL tools, table re-org, partition setup, maintenance, swap, RDBMS- Oracle, SQL Server, MSSQL, ANSI SQL, AutoSys, Control-M, OEM tools
Skills outside Primary Skill Cluster Shell scripting, Autosys, ETL
**Job Description**:
Responsibilities: Good experience in requirement gathering/ analysis, DB design, coding, Unit testing, SIT Support
Engineers would need to be hands on and are capable of conversing with Architecture teams.
Design, implement and maintain database system to meet business requirements.
Convert the Business need in to Technical complex queries/procedures.
Ability to write complex sql queries/PL SQl Code for reporting purpose.
Monitor Database performance and troubleshoot issues
Support all day to day activities related to database like data consolidation, data migration scripting, performance tuning.
Required Skills: Having 10+ Years of strong expertise in PL/SQL programming, Oracle Database Management, DB Design/Architecture & Normalization
Strong experience with Oracle 18c/19c and knowledge of Oracle database features
Proficient in DB performance tuning & optimization Techniques
Experience with Datawarehouse & ETL process is preferred
Expertise in Data Modelling
Expertise in Unix Shell Scripting
Solid Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle.
Experience in data migration/conversation using SQL*Loader.
Experience in Data migration using import and export.
Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose.
Expertise in writing procedures, functions, views, materialized views as required.
Responsible for performance tuning activities in the project.
Having good experience on Client Interaction and Presentation Skills.

Nice to have skills: Autosys, ETL
Knowledge of Big Data is plus
Citi or Banking experience in the Compliance domain preferred.
Experience in the Agile Scrum Methodology

**About Virtusa**

Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 30,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.

Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.

Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.

  • Pega CDH Architect

    3 weeks ago

    Pune, India Virtusa Full time

    Pega CDH Architect - CREQ Description JD:pega-1 10+ years of software development experience specifically in Pega CDH 5+ programming and software development life cycles Waterfall, Agile, Scrum 6+ years of experience being Pega Lead Decisioning Architect or lead developer. Expert knowledge of relational databases SQL Server, PLSQL structure and development...

  • Pega CDH Architect

    3 weeks ago

    Pune, India Virtusa Full time

    Pega CDH Architect - CREQ Description JD:pega-1 10+ years of software development experience specifically in Pega CDH 5+ programming and software development life cycles Waterfall, Agile, Scrum 6+ years of experience being Pega Lead Decisioning Architect or lead developer. Expert knowledge of relational databases SQL Server, PLSQL structure and development...

  • Architect

    5 days ago

    Pune, India Persistent Systems Full time

    About Position:We are seeking Architect in hands on experience in OutSystems, ODC 11, OutSystems Web.Role: ArchitectLocation: All Persistent LocationsExperience: 12+ yearsJob Type: Full Time EmploymentWhat You'll Do:The OutSystems Architect works closely with business teams to understand requirements, design, and develop solutions that optimize business...

  • Architect

    1 week ago

    Pune, India Persistent Systems Full time

    About Position:We are seeking Architect in hands on experience in OutSystems, ODC 11, OutSystems Web.Role: ArchitectLocation: All Persistent LocationsExperience: 12+ yearsJob Type: Full Time EmploymentWhat You'll Do:The OutSystems Architect works closely with business teams to understand requirements, design, and develop solutions that optimize business...

  • Architect

    1 week ago

    Pune, India Persistent Systems Full time

    About Position: We are seeking Architect in hands on experience in OutSystems, ODC 11, OutSystems Web.Role: ArchitectLocation: All Persistent Locations Experience: 12+ yearsJob Type: Full Time EmploymentWhat You'll Do: The OutSystems Architect works closely with business teams to understand requirements, design, and develop solutions that optimize business...

  • Architect

    1 week ago

    Pune, India Persistent Systems Full time

    About Position: We are seeking Architect in hands on experience in OutSystems, ODC 11, OutSystems Web. Role: Architect Location: All Persistent Locations Experience: 12+ years Job Type: Full Time Employment What You'll Do: The OutSystems Architect works closely with business teams to understand requirements, design, and develop solutions that optimize...

  • Architect

    1 week ago

    Pune, India Persistent Systems Full time

    About Position:We are seeking Architect in hands on experience in OutSystems, ODC 11, OutSystems Web.- Role: Architect- Location: All Persistent Locations- Experience: 12+ years- Job Type: Full Time EmploymentWhat You'll Do:- The OutSystems Architect works closely with business teams to understand requirements, design, and develop solutions that optimize...

  • Architect

    6 days ago

    Pune, India Persistent Systems Full time

    About Position:We are seeking Architect in hands on experience in OutSystems, ODC 11, OutSystems Web.- Role: Architect- Location: All Persistent Locations- Experience: 12+ years- Job Type: Full Time EmploymentWhat You'll Do:- The OutSystems Architect works closely with business teams to understand requirements, design, and develop solutions that optimize...

  • Oracle PlSQL

    2 weeks ago

    Pune, Maharashtra, India Virtusa Full time

    Skills from Primary Skill Cluster (Min 3 technical primary skills) Oracle PL SQL, Oracle Performance Tuning, Unix, DB Parameters tuning, data pump or other DB native Skills outside Primary Skill Cluster Agile, CI CD Pipeline, JIRA Job Description: Architect and Design scalable Data and AI solutions. Evaluate technologies, tools, and platforms. Identify and...

  • Data Modeler/ Information Architect/ Data Architect

    4 days ago

    Pune, Maharashtra, India CRISIL Full time

    The Data Modeler/Architect is responsible for translating the enterprise business needs into conceptual, logical and physical data models. Provides expertise on data modeling tools, techniques and best practices and leads the design and implementation of the data architecture and data modeling solutions supporting enterprise information management, business...