Oracle DBA

Confidential Company

You will be responsible for install, maintain, support/troubleshooting predominantly Oracle products and help our customers making best use of the technology.

Provide primary support for critical, complex production Oracle databases running financial applications.

Perform Oracle Systems Database Administration across multiple Oracle database environments and ensure continuous 24x7 operation and availability in support of mission critical internal production applications.

Good knowledge of Unix Shell Scripting and be able to write/maintain OS level scripts (i.e., UNIX shell) for system DB maintenance.

Ensure the quality and consistency of data and database systems by following a defined set of procedures (change control, security procedures, user passwords, backups, etc.).

Strong operational experience with Oracle Database on RAC on Oracle 12C/19C and above with ASM Disk.

Migrate the existing Platform to the current engineered Standard of Oracle 12c, Active Data Guard, RAC and ASM for fast Test and Dev refreshes.

Actively participate in solutions architecture, product engineering and continual service improvement.

Perform various project related database requests for customers. Tasks can include DDL generation, cloning, schema and/or table level data refreshes, performance tuning, database consolidation.

Collaborate with application/development partners to address performance reported issues. Troubleshoot and resolve, in conjunction with Operational/Customer DBAs, database application issues across production, test and development environments.

Create a reliable backup strategy. Ensure database backups are appropriately managed. Manage backup/recovery and provide Disaster Recovery planning. Test backup and recovery scenarios, formulate disaster recovery procedures using storage technologies such as NAS and RMAN etc.

Provide input into architecture and design for new Oracle Database implementation.

Proactively manage and maintain security standards and controls.

Actively seek to optimize and simplify our architecture.

Take ownership of performance and capacity monitoring aspects of the DB.

Execution of data migration jobs and scripts as required.

Assist the infrastructure team in sizing hardware used for the DB.

Support and collaborate with product developers.

Contribute to the creation and maintenance of disaster recovery plans.

Determine and document DB policies, procedures and standards.

Performance testing and evaluation to ensure data security, privacy and integrity. Identification of bottle necks and deadlock issues.

Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.

Hand on experience on deploying and managing Oracle Database Encryption and Oracle Data Masking.

Good Working experience on Oracle Enterprise Manager for oracle database monitoring configuration and different reporting generation as per the business and operation requirements.