Sr. Architect

☞ Stefanini, Inc

View: 104

Update day: 06-05-2024

Location: Greater Noida Uttar Pradesh Noida

Category: IT - Software

Industry: IT Services & Consulting

Position: DBA

Job type: Full Time, Permanent

Salary: ₹ 15,00,000 - 22,50,000 P.A.

Experience: 10 - 20 years

Loading ...

Job content

Architect & Streamline the Data Model and implement DB normalization from design phaseReview the queries by analyzing explain plan and execution time. Then optimize these by creating right indexes and Data ModelProvide technical expertise in support of the design of complex physical data models that describe the structure for data storage, data indexing, data manipulation, and data retrieval applications.Ensure software and solutions are stable and scalableCoordinate with teams across the entire program to ensure alignment with developers" needsMentor and train Database Administrators Act as a focal point for best practicesCollaborate with UX and Product on cross functional teamsGather and present requirements for new featuresBreak down barriers to development progressPresent progress to stakeholders

Required Candidate profile

* 10+ years of relevant experience in Oracle Database Administration including SAP and Data Management Platform

* Extensive experience inOracle Database, Oracle RAC, ASM, Maximum Availability Architecture (MAA)

* Multitenancy Architecture - Creating pluggable database, Plugin non-CDB to CDB

* Oracle DB Upgrade (11g, 12c, 18c,19c)

* Oracle Database Performance Tuning

* Understanding of Oracle Cloud platforms - OCI, SaaS and PaaS

* OCI Gen1/Gen2 DB Migration

* OCI Autonomous Transaction Processer DB (ATP)

* OCI Autonomous Data Warehouse DB (ADW)

* Active/Passive DataGuard - DG Broker/Switchover/Failover

* Cross Platform Transportable Tablespaces (XTTS)

* Database migration to Cloud Using Export/Import, MV2DB, ZDM etc

* OCI Disaster Recovery, RMAN backups, Clone/Refresh

* OCI ExaCs & ExaCc

* Oracle DB Patching(Quarter Updates, GRID, Exadata DB)

* Technical Troubleshooting Skills

* Experience in Oracle Enterprise Manager (OEM) 11g/12c/13c is a plusOracle RDBMS

* Oracle Database Migration using multiple tools & technologies

* Experience in Database Maximum Availability Architecture and it"s best practices

* Experience in Performance tuning of Oracle Database and SQL tuning

* Experience in Data Integration tools like Oracle Data Integrator (ODI) & GoldenGate

* Very strong/hands-on following areasMultitenant Administration

* Oracle Cloud Infrastructure DB System Administration (ADB, VM DBSystem, ExaCS, ExaCC, BM DBSystem)

* Database Migration and Upgrade

* RAC, ASM, Dataguard

* Performance Tuning

* Expertise and Experience in solution architecture of complex Data Management systems, including re-platform of such systems

* Experience in managing large Database Consolidation projects, including planning, architecture and execution

* Experience in Building and managing Linux OS systems with good understanding how the Linux kernel works (IO, Network,etc)

* Experience in Building and managing Virtualized systems (KVM, OVM, Containers/Docker) and ability to read and understand source code

* Experience of managing Cloud Databases in any public cloud platform (Oracle, AWS, Azure, etc)

* Systematic problem-solving approach combined with a strong sense of ownership and drive.

* Additional skills preferred: Working experience in any NoSQL Database or Databases like SQL Server / Postgres / MySQL will be an added advantage

* Scripting/coding skills (Shell, Perl and Python). Knowing Java, REST Architecture and JSON is a plus

Loading ...
Loading ...

Deadline: 20-06-2024

Click to apply for free candidate

Apply

Report job
Loading ...
Loading ...

SIMILAR JOBS

Loading ...
Loading ...