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)
WANT TO START A TALK ABOUT YOUR REQUIREMENT?
We assure our expertise will help your business to succeed