Talent.com
Database Administrator

Database Administrator

GenpactMontreal, QC, Canada
1 day ago
Job type
  • Full-time
Job description

With a startup spirit and 90,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it! We dream in digital, dare in reality, and reinvent the ways companies work to make an impact far bigger than just our bottom line. We’re harnessing the power of technology and humanity to create meaningful transformation that moves us forward in our pursuit of a world that works better for people.

Now, we’re calling upon the thinkers and doers, those with a natural curiosity and a hunger to keep learning, keep growing. People who thrive on fearlessly experimenting, seizing opportunities, and pushing boundaries to turn our vision into reality. And as you help us create a better world, we will help you build your own intellectual firepower.

Inviting applications for the role of Oracle DBA

Location : Montreal, QC

This is an experienced Oracle Database Administrator position where the individual will be responsible for overseeing and managing the Oracle databases.

In addition, this DBA will be responsible for providing 2nd and 3rd level support for all DB related issue or outages.

Ensures the smooth operation of the infrastructure in order to provide maximum performance and availability. Maintains close vendor relationships to support current technology solutions and provide roadmap strategies for all Database management systems.

The candidate also must be flexible to work in 24

  • 7 environments.

Responsibilities

  • The main responsibilities include : vulnerability remediation which would be the primary task
  • Should work on configuration, implementation, support of Oracle Database Production servers and technical guidance of junior team members
  • Understand business requirements and design solutions accordingly
  • Ensure quality standards in release implementation especially in DML / DCL / DDL & Data Fixes of any form
  • Resolve incidents, escalate to client management and Oracle Vendor as necessary
  • Create SOPs
  • Perform root cause analysis for P1 / P2 / P3 and P4 incidents and / or proactively based on business needs
  • Work with the Genpact, client or 3rd party teams for the implementation of changes
  • Follow the required policies and procedures for the incident, problem and change management
  • Ensure service performance expectations are met with service levels and quality
  • Raise / escalate any service related issues and risks to track lead and / or ITS lead
  • Technical guidance of junior team members (when applicable)

    • Qualifications

  • Graduate or post graduate in Technology with Computers or IT stream
  • Graduate or post graduate in any stream with course in Computers or IT stream

    • Must have skills

  • Knowledgeable about the Oracle; Sybase and SQL Database architecture
  • Hands-on experience with Oracle 12c installation, configuration and disaster recovery procedures
  • Oracle E-business suite R12.2.x
  • ADOP Patching, Ad-utilities, EBS CPU Patching
  • EBS Cloning, Product Patching
  • EBS Workflow mailer configurations, Having good knowledge of GL.
  • Worked on multiple Oracle Databases releases
  • Perform DB refreshes
  • Perform DB installs and refreshes
  • Knowledge of shell scripts
  • UNIX – Solaris / Linux – all current releases
  • Database user creation
  • Hands on with RMAN backup recovery
  • Adding of datafiles and space management
  • Well versed with Index and Reorganization of database objects
  • Change management and apply datafixes
  • Well versed with audit concepts
  • Analysis and implementation of CPU patching on production system independently
  • Understanding of database concept as a SME and ability to provide solutions
  • Good Understanding of OPatch concepts
  • Well versed with performance & tuning of databases
  • Exposure of database recovery scenarios
  • Experience of database upgrades
  • Good understanding of RMAN, ADDM and ASH reports
  • Sound experience of Database export / import functions
  • Experience of database character set conversion
  • Knowledge of Database monitoring tools
  • Must have very good trouble shooting and analytical skills
  • Excellent communication skills (verbal and written)
  • High energy, results driven person with strong interpersonal skills
  • Ability to work under minimal supervision

    • Preferred / Desired Skills :

  • Capital Markets Domain knowledge is preferred
  • Knowledge of ITIL, integration across IPC (Incident, Problem & Change Management)
  • Sound knowledge of Oracle v12 Database ( PDB & CDB)
  • Knowledge of Oracle Apps R12.2will be a plus

    • Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military / veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. For more information, visit www.genpact.com . Follow us on Twitter , Facebook , , and YouTube .