Database Engineer - New York, United States - Lorven technologies

    Lorven technologies
    Lorven technologies New York, United States

    3 weeks ago

    Default job background
    Description

    Job Description

    Job DescriptionJob Title: Database Engineer
    Job Location: NYC, NY (Remote Position)
    Duration: 12 Months Contract    Job Description:
    Position Duties:
    • Install, configure, customize, create, implement, and support Oracle databases in Non-RAC and RAC environments, and software and related tools/products for the database systems
    • Implement Grid Infrastructure release 19c on an OS Unix/Linux platform support databases
    • Implement Oracle Automatic Storage Management (ASM) cluster Filesystem and maintain it; Add new disks to an ASM disk group
    • Patching grid infrastructure and Oracle RDBMS
    • Set up Oracle database security environment
    • Carry out DB Performance Tuning and RMAN backups
    • Working with Oracle, implement best-of-class solutions
    • Utilize Linux Administration skills as needed; develop UNIX shell scripts; Automation using ansible; work with the Database team and teams of Unix engineers and administrators to design, build, upgrade, and support the necessary Oracle infrastructure to meet the needs
    • Work hands-on on more extensive projects such as migration, implementing new features, architectures, and validation
    • Configure Golden gate replication; both integrated and microservices-based configuration
    • Configure Oracle RAC and ASM technologies on Redhat Linux
    • Configure Oracle Data Guard with Active and Standby database modes
    • Assist developers and end users in implementing best practices and addressing performance issues in implementation
    • Ensure all databases are backed up and meet the business's Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO)
    • Lead team efforts in adopting modernized architecture such as hybrid cloud and database ready for hybrid cloud
    • Perform RCA; manage different database encryption technologies; and implement DR by design and validate
    • Perform special projects and initiatives as assigned
    • Experience with the latest Oracle versions and their features, including Multi-tenant Architecture, Oracle Partitioning, Real Application Testing (RAT), and Oracle Database Vault
    Mandatory Skills/Experience:
    • Minimum 12 years of hands-on experience in database engineering
    • Ability to work independently
    • Experience implementing/managing Oracle Databases in an RAC environment with at least two years of production support
    • Experience Implementing Grid Infrastructure release 19 or higher on a Redhat Linux environment
    • Experience implementing ASM cluster Filesystem with knowledge of how to maintain it for successful operational delivery
    • Knowledge of Best Practices for adding a new disk to an ASM disk group
    • Experience patching grid infrastructure software
    • Familiarity with Oracle database resource manager
    • Familiar with Ansible/automation/scripting
    • Familiarity with huge pages on Linux
    • Experience supporting a high-availability production database
    • Experience in configuring/supporting Oracle Active Data Guard required
    • Experience in database architecture and design, Oracle Advanced Security Option, and Golden Gate for Oracle Replication
    • Knowledge of working on cloud environments, preferably AWS & AZURE
    • Participate in application/DB outage incidents during troubleshooting and provide solutions and RCA
    Desirable Skills/Experience:
    • Experience with Oracle Advanced Security Option is highly desirable