Careers

Position : Senior Technical Consultant (Data Base)

CGG is conducting Online Interviews for Senior Technical Consultant (Database)

Looking for candidates with 10 – 15 Years of experience.

Experience

  • Should have an experience of over 10+ years solid experience of DB development of latest versions.

Educational Qualification

  • : M. Tech, MCA, B.E (Comp), B. Tech with 60% marks.

 

JOB PROFILE:

  1. 10+ years solid experience of Oracle development under a 10g or 11g environment.
  2. Advanced PL/SQL knowledge required.
  3. Must have very strong experience with creating PL SQL scripts.
  4. Must have strong PL SQL stored procedure, packages, functions, & triggers.
  5. Any wider SQL or DB experience would be desirable e.g. Postgres, MSSQL, MySQL etc.
  6. Strong experience in tuning Oracle queries in large databases.
  7. Good experience in loading and extracting large data sets.
  8. Analytical and critical thinking skills; agile problem-solving abilities.
  9. Detail oriented, self-motivated, able to work independently with little or no supervision, and is committed to the highest standards of quality for the entire release process.
  10. Must have excellent communication skills.

Roles &Responsibilities:

  • Providing training on Database to employees/Team
  • Assist the Development teams in sizing hardware used for the DB.
  • Interacting with all project teams & PL/SQL developers for DB activities
  • Database Auditing for all projects and submission of monthly report on Audit activities
  • Review of critical projects and suggestions on Clean Up of redundant tables, back up tables, etc.
  • Performance Tuning for large data bases and Submission of monthly report on suggestions given
  • Proactive study and execution of existing legacy Databases and propose for Migration : Submission of monthly report on suggestions given
  • Review of DB architecture of critical projects and submission of Monthly report on project reviewed and suggestions given
  • Audit Compliances as per CMMI/ISO/ISMS
  • Quarterly updates of DB Policies; process documents / System documentation and Processes / Architecture Documents for all critical projects
  • New Technology implementation / configurations
  • Open Source Tools adoption and use in applications
    1. Checking for number of connections of individual Schemas to the Databases.
    2. Exporting/Importing DB Schemas from Live to Test both vice-versa, Creation/Dropping of Schemas as per the request from developers.
    3. Creation of Triggers for restricting the schemas in accessing particularTables to a Point of Time.
    4. Creating Tablespace for respective Schemas and adding Datafiles to those Tablespaces.
    5. Granting Privileges to Schemas which are intimated by respective Project Leaders.
    6. Resolving issues which are encountered in the database (Quotas of Tablespace, Adding Datafiles, Size Management, Space Management, Inactive Sessions, Long Running Queries, and Lock/Unlock of Schemas).
    7. Monitoring Archive Logs of every Instance respective Database.
    8. Removing Old Archives which are unusable from time to time.
    9. Cross checking the last night backup of each and every Live Database.
    10. Monitoring the Alert Log File of every Instance.
    11. Tracing the cause of errors which are notified in Alert Log File.
    12. Creation of Database Links in Between the Databases which are intimated by respective PL's.
    13. Creation & Maintenance of Automated Schedules (Cron Jobs) in the Databases (WhenNew Schema is created).

     

Interested candidates can apply in below mentioned link by end of  31-05-2023. Looking for Immediate Joinees.

https://www.careers.cgg.gov.in/apply.do

Note:

  • Candidates applied within 6 months are not applicable.
  • Canvassing in any form leads to the cancellation of application.