Vijai Kumar Mishra

About Vijai Kumar Mishra

Over 15 years of experience as Oracle Developer in Code writing, analysis, design, Application development, testing and production support using Oracle Database 12c/11g/10g/9i, SQL, PL/SQL, Oracle Fusion Middleware 11g, WebLogic Server, Oracle Developer Suite 10g, Oracle Form-6i, Oracle Reports 6i, and D2K.• Experience in Automotive Systems, Para banking control system, Retail Chain Management System, Accounting Management System, Employee Management System and Examinations Management System.• Proficient in developing Oracle PL/SQL Packages, Stored procedures, Functions, Triggers, Cursors, View, Index, Synonyms, Constraints, Db-link, Global Temporary Table (GTT), External Table, Function based Index (FDI), Collections and Records.• Experience to perform DDL, DML, DCL, TCL, Session Control and System Control Statement.• Managing User Privileges and Role to control access to schema objects and to control the ability to execute system operations.• Experience to perform Database Backup, Import and Export Data using (imp, exp) and Oracle Data pump (Expdp, Impdp).• Experience to perform Performance tuning of SQL and PL/SQL using explain Plan, Optimizer Hints and SQL Tracing (TKPROF).• Performing code analysis by grep command in UNIX and findstr command in Windows.• Conceptual knowledge of Oracle Physical Architecture Layout of Data file, Redo log file, Control file and Parameter file.• Ability to work in teams and independently with minimal supervision to meet deadlines.• Good communication, analytical and Interpersonal skills.• Ability to provide proper guidance to other developer provides tasks and review.• Experience in controlling the team and controlling the department as Technical Lead, Assistant Manager and Deputy Manager.

Experience

1. Manager IT at Medanta Hospital Lucknow U P India

   Medanta

   Jun 2022 — Present · Lucknow, IN

   Responsibilities:• Creating Anonymous block and database objects like Tables, Views, Procedures, Functions, Packages, Triggers, Synonyms, Constraints, Db-link, Global temporary table (GTT) and External table etc.• Doing Development and support work in Oracle SQL, PL/SQL, D2K, Linux and Shell Scripting.• Perform DDL, DML, DCL, TCL, Session Control and System Control Statement.• Doing Development and support work using ASP.NET and c#.• Design customized report using SSRS and ASP Grid View.• Writing complex SQL query using multiple tables and views using joins, sub queries, Built-In Functions, Aggregate function, Having Clause and Wildcard Operators etc.• Doing Oracle Database Administrators DBA for user management, Role management, table privileges, GRAN, Revoke, Index management, session management, performance tuning and optimizing query etc.• Working with RAC and ASM management for High Availability.• Working with Oracle GoldenGate 11g/12c Installation, configuration, troubleshooting and replication setup across heterogeneous database servers and ensure data synchronization.• Creating constraints on the tables and enforcing the Constraints & Indexes and relations between the tables to meet the requirements.• Created simple views, complex views, with read only view and force view based on the business requirement.• Involved in the performance tuning of SQL and PL/SQL using Explain Plan, Optimizer Hints, CBO and TKPROF.• Optimizing existing queries for better performance and less impact on database.• Perform development and support using complete development cycle.• Performing code analysis by grep command in UNIX and findstr command in Windows.• Connecting with user on Teams, Skype, CmRcViewer and msra to see the issue and resolve their problems.

Education

• Allahabad Agricultural Institute

  Master of Business Administration (M.B.A.), Computer and Information Sciences and Support Services

  2014 — 2016

• Allahabad Agricultural Institute

  Master of Computer Applications (MCA), Computer Programming, Specific Applications

  2007 — 2010

Skills

• Software Development
• Oracle Developer Suit 10g
• Oracle Applications
• Data Warehousing
• Oracle Developer 2000
• Mysql
• Oracle Application Server
• Sql
• Core Java
• Agile Methodologies
• Toad
• Databases
• Oracle10g
• Developer 6i
• Pl/Sql
• Obiee
• Sql*Plus
• Oracle Reports
• Sql Loader
• Oracle
• Toad 9.0
• Oracle 11i
• Sql * Plus
• Oracle Sql Developer
• Oracle Developer Suite
• Oracle Forms
• Oracle Sql