Ref No.: 17-00687
Location: Hoboken, New Jersey
Position: Oracle DBA
Location: Hoboken, NJ
Contract Duration: Fulltime

Job Description:
  • Provide database installation, administration, maintenance, monitoring, configuration, troubleshooting and performance-tuning
  • Administer database accounts, access rights, privileges, roles and profiles. Generate any violation reports as and when required
  • Design backup strategies, perform database backup and recovery, and database refreshes
  • Perform regular database housekeeping and maintenance activities necessary to keep the database in a healthy state and at optimal performance
  • Monitor and analyze disk usage, table extents, etc, of all the databases, and alert or report as per procedures
  • Perform capacity planning and/or management on system and database resources based on current applications and utilization rate.
  • Estimate and plan for growth with information provided on future application requirements, database growth, etc
  • Database objects deployment (e.g. creation/modification/deletion of database objects), script deployment and execution, load and/or extract data
  • Provide support for Disaster Recovery setup and testing
  • Perform software upgrades, installations and migration of database as and when required
  • Apply database patches as and when required
  • Handle service requests, incidents, problems and change/release requests as per Client guidelines
  • Co-ordinate with cross functional teams for any database administration specific activities
  • Create, modify and drop instances and databases with adherence to instance and database naming conventions
  • Suggest, evaluate and implement any new tools for databases
  • Create, modify, review scripts required for the maintenance of databases and instances
  • Provide database related support and services to third-party vendors as and when requested by Client as per process
  • Set up database auditing, manage audit trail and generate audit related reports when required
  • Involvement in Vendor license management as and when required (reporting on licensed database components used etc.)
  • Liaise with MGTI regarding hosting new environment issues and setup for databases
  • Project consultation/technology advice specific to database domain
  • Planning for Database Software upgrade evaluation
  • Provide consultation on new RDBMS features
  • Participate in database related software evaluation
  • Maintain documentation and SOP with respect to Client landscape and database operations
  • Database recovery as required by applications Tune all Oracle instance components including SQL and PL/SQL.
Education Level Required:
Engineering Graduate Or Relevant Experience.