Get your dream job within 2 days (HURRY UP)ENROLL NOW
+


Job Id : 8575

Jobtitle : ORACLE DBA - OPT

Location : Princeton, NJ

Company Name : Cygnus Professionals

Industry : Information Technology

Salary : $54,540 - $110,540  YEAR

Job type : Fulltime

Posted on: 2019-12-11


Required Skills : Oracle, Oracle DBA, ACCESS, RAC, Data Guard, DBA, OEM, Performance Tuning

Benefits : No benefits are available


Job Description/Duties:

  • Performs all Oracle Database Administration related activities for major ETS projects independently with minimal supervision
  • Participates in projects as assigned providing expertise related to Cloud Database Architecture (AWS or Azure)/support AWS cloud migration projects.
  • Experience with administration of Databases on AWS Cloud
  • Analyzes database and information needs of projects and applications in order to recommend and implement cost-effective solutions.
  • Troubleshoot and resolve RAC and Redhat clustering issues in all database environments
  • Schedules and coordinates database maintenance activities.
  • Strong capability and ability to resolve highly technical and complex database and infrastructure related issues on their own before they impact production and ETS business.
  • Provides technical expertise to the development of solutions for such items as DBMS tools and utilities usage, database administration, backup and recovery, database performance tuning and monitoring.
  • Ability to influence development organizations to comply with database best practices and ETS database standards.
  • Runs transaction access path analysis sessions with application developers, analyzing specifications and code to ensure that data access and database designs are as efficient as possible. Make recommendations for improvements in these areas, if necessary.
  • Assures quality of database analysis and design across projects, thus enabling company-wide data reusability.
  • Trouble-shoots database and/or software problems as they apply to design, implementation, or installation activities.
  • Schedules and coordinates database maintenance activities including such items as database reorganizations and restructures.
  • Coordinates and/or participates in database stress tests, analyzes results, and makes recommendations for design or coding changes based upon those results.
  • Participates in on-call, overnight off-hour production problem resolution activities.
  • Develops and maintains DBMS related standards and procedures, knows where they are located, and makes full use of them.
  • Follows ETS software development processes.
  • Researches, evaluates, and tests new software and DBMS related tools and facilities as they pertain to the existing DBMS environment, database designs, procedures, and applications.
  • Monitors current DBMS performance and develops procedures, where necessary, to improve the DBMS environment as required.
  • Identifies and supports quality improvement initiatives.
  • Performs other assignments to comply with the SR&T corporate purpose and mission to add business value, increase revenue, decrease costs, improve productivity, and support the strategic initiative/directive.
  • Complies with all ETS security and audit standards. Ensures security of company information by ensuring database is secure and monitors environment to identify improper access.

Knowledge, Skills, and Abilities:

  • Experience in managing, maintaining, patching, upgrading and ensuring operational continuity of the Oracle Database and associated components using the following Oracle products:
  • Oracle Enterprise Manager
  • Oracle Data Guard
  • Oracle Recovery Manager
  • Oracle RAC implementation
  • Oracle Automatic Storage Management (ASM)
  • Oracle Golden Gate- replication
  • Good UNIX, Linux knowledge and scripting is a must.
  • Experience supporting MS SQL Server and/or Postgres highly preferred.
  • Experience with administration of Databases on AWS Cloud using RDS and/or EC2.
  • Demonstrate recent, professional exposure to support alternate RDBMS database flavors like MS SQL SERVER, Postgres, Aurora, & NoSQL.
  • At least 5-7 years as Lead Oracle DBA on all aspects of Oracle Database Administration in a large/challenging database environment.
  • Experience with automation tools (Ansible, Jenkins) & container technologies (Docker, CoreOS) is a plus.
  • Experience supporting internet/web based database applications with heavy concurrent user volume.
  • Experience working on RAC database applications, OEM, RMAN, Data guard & Golden Gate.
  • Skilled in SQL statement tuning with detailed understating of AWR and StatsPack reports, database performance tuning.
  • Experience operating in traditional and agile project models
  • Willingness to work on-call DBA rotations in a 7x24 environment
  • Strong interpersonal skills to resolve problems in a professional manner, lead working groups, negotiate, and create consensus with both internal associates and external customers.
  • Proficient at time and priority management.

Education:

  • The candidate should have a Bachelor degree or Masters in Computer Science or 7 to 10 years of related experience in IT or a related field.

Latest jobs for you

  • Java solution Architect - H1B/GC

    Themesoft Inc Philadelphia, PA

    Job Description: Generally requires 11 years of related experience At least 5 years of ...

    View Job
  • Sr. Forgerock Engineer - OPT/H1B

    Sigmaintel Detroit, MI

    Job Description : Onsite project Experience in developing and deploying Identity and ...

    View Job
  • Functional Tester - OPT/H1B

    IT-SCIENT LLC Englewood, CO

    Required Skills: Establish API and near neighbor testing for Unify Id and Domain Services ...

    View Job
  • Senior Technology Architect/Java Architect - H1B

    IT-SCIENT LLC Sunnyvale, CA

    Job Description : Experience with java writing Restful micro services Test-driven ...

    View Job
  • Full Stack Java Developer - H1B/OPT/CPT

    K Anand Corporation Plano, TX

    Job Description: 8 years of experience Fullstack development experience using JAVA, J2EE, Web ...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First