Database Administrator

Job ID: DA-2131 Location: Albany NY

Job Duties:

  • Administration of (11g to 12c) Oracle RAC and Vertica databases, Cloud control(13c), server and application tools on Linux environments.
  • Design and implementing security Policies in Oracle and Vertica (Access Policies) databases on row/column level.
  • Performing disaster recovery activities in fail-over scenarios, Documenting and maintaining Disaster Recovery procedures.
  • Design and Allocate system storage and planning future storage requirements for the database system.
  • Developing scripts and reports using SQL, PL/SQL and shell scripts for performance monitoring and tuningthe database server on a regular basis to identify bottlenecks such as parts of the system that are slowing down processing and remedy them.
  • Supporting Application developers with various performance, connectivity and security related issues on various projects and resolving them in a timely manner.
  • Daily maintenance of the Oracle databases 11g/12c for production as well as development, testing environments, and are not limited to:
    • Applying necessary quarterly patches as needed for Oracle 11g/12c RAC databases.
    • Preparing Database backups for all the database environments and testing the recovery scenarios.
    • Creating Users, Roles, Profiles, VPD (Virtual Private Database)/Access policies on rows/columns, andassigning query and update privileges to roles and roles to users.
    • Managing Database Structure, Table/Index segments, Rollback Segments, Undo Segments, Constraints, partitioning of tables and creating materialized views.
    • Managing Storage Allocation, space issues in the database level for tablespace and regular file system cleanup at LINUX level.
    • Monitoring and resolving locking conflicts and other monitoring tools and handling alerts, notifications.
    • Checking Database instances, Listeners running or not.
    • Troubleshooting performance related issues on database level or PL/SQL query level.
    • Troubleshooting/Installing/Managing ASM (Automatic Storage Management) related tasks.
    • Providing 24*7 on-call production database support and maintenance activities.
  • Creation and migration of databases and applications into new server clusters.
  • Configuring Oracle RAC database with OID/OVD (Oracle Internet/Virtual Directory).
  • Configuring various data Load jobs in between Oracle-Oracle, Oracle-Vertica, Vertica-Oracle, Vertica-Vertica databases using DART (Data at rapid Transport) Product.
  • Moving huge amount of data using transportable tablespace method from one Oracle database to another.
  • Configuring automation of data load processes with Daily, Weekly, Monthly, Yearly and on-demand schedules.
  • Deploying DDL and DML scripts in Development, Test, UAT and Production databases.

 

Please fill the below form to apply for the position

(All fields are required)

Upload Resume:

WANT TO START A TALK ABOUT YOUR REQUIREMENT?

We assure our expertise will help your business to succeed

Contact Us

Copyright © 2018 Maxpro, Inc. All Rights Reserved.