SQL/oracle Database Architect

2 weeks ago

Delhi, India Yo Hr Consultancy Full time

SQL/Oracle Database Architect

Location: Delhi

Experience: 5-10 Years

Must-Have:
Experience in SQL or Oracle, OLTP, Data Warehousing workloads, and RDBMS.

JD:

- 5-10 years of direct hands-on DBA support for Oracle/SQL database.
- Experience working on an Application/ Development team or experience as an Application DBA.
- Hands-on operational DBA expertise in the areas of Replication, Log shipping, High Availability and Backup/Recovery.
- Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
- Logging, managing, and resolving SR's with Oracle database system support.
- Experience in installing and configuration tools for database system.
- Estimate DBMS capacities; develop methods for monitoring database capacity and usage.
- Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
- Experienced in the creation of development, staging, and production database instances, and the migration from one environment to another.
- Responsible for regular backups and recovery of databases.
- Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving).
- Managing tablespaces, data files, and other databases objects like indexes, functions, triggers, views, Users/Privileges/Roles and Password security, Databases/Schemas refresh using Export & Import utilities.
- Oracle RDBMS experience required.
- Comprehensive skills in database architecture, Installation & configuration, logical and physical design, automation, documentation, installs, shell scripting, catalogue navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
- Extensive experience in handling transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads
- Strong understanding of command line and server administration

**Salary**: ₹1,200,000.00 - ₹1,500,000.00 per year

**Experience**:

- DBA: 5 years (required)
- SQL/Oracle: 5 years (preferred)
- OLTP: 3 years (preferred)

  • Oracle Database Administrator

    2 weeks ago

    Delhi, India Sky Systems, Inc. (SkySys) Full time

    Role: Oracle Database Administrator (DBA) Position Type: Full-Time Contract (40hrs/week) Contract Duration: Long Term Work Hours: 3:30 AM to 1:00 PM EST Work Schedule : 8 hours/day (Mon-Fri) Location : 100% Remote We are seeking an experienced Oracle DBA with strong expertise in managing Oracle databases on AWS (EC2/RDS). The role involves deploying,...

  • Oracle Database Administrator

    2 weeks ago

    Delhi, India Sky Systems, Inc. (SkySys) Full time

    Role: Oracle Database Administrator (DBA)Position Type: Full-Time Contract (40hrs/week)Contract Duration: Long TermWork Hours: 3:30 AM to 1:00 PM ESTWork Schedule: 8 hours/day (Mon-Fri)Location: 100% RemoteWe are seeking an experienced Oracle DBA with strong expertise in managing Oracle databases on AWS (EC2/RDS). The role involves deploying, configuring,...

  • Oracle HCM Functional Architect

    2 weeks ago

    Delhi, India Oracle Full time

    Job Summary:We are seeking an experiencedOracle HCM Solution Architectto lead the design, implementation, and optimization of Oracle HCM Cloud solutions. This role requires a deep understanding of Oracle HCM Cloud modules, HR business processes, and enterprise architecture. The ideal candidate will work closely with business stakeholders, project managers,...

  • Oracle Database Administrator

    4 days ago

    Delhi, India Insight Global Full time

    Pay is up to 25 lakh based on experience.We are looking for an experienced Oracle Database Administrator (DBA) to join our team, with proven expertise in managing Oracle databases on Amazon Web Services (AWS). This role requires strong hands-on experience with Oracle Enterprise Manager (OEM) for proactive monitoring and performance tuning. Familiarity with...

  • Oracle Database Administrator

    2 weeks ago

    Delhi, India Insight Global Full time

    Pay is up to 25 lakh based on experience.We are looking for an experienced Oracle Database Administrator (DBA) to join our team, with proven expertise in managing Oracle databases on Amazon Web Services (AWS). This role requires strong hands-on experience with Oracle Enterprise Manager (OEM) for proactive monitoring and performance tuning. Familiarity with...

  • Oracle Database Administrator

    2 weeks ago

    Delhi, India Insight Global Full time

    Pay is up to 25 lakh based on experience.We are looking for an experienced Oracle Database Administrator (DBA) to join our team, with proven expertise in managing Oracle databases on Amazon Web Services (AWS). This role requires strong hands-on experience with Oracle Enterprise Manager (OEM) for proactive monitoring and performance tuning. Familiarity with...

  • Oracle Database Administrator

    2 weeks ago

    Delhi, India Insight Global Full time

    Pay is up to 25 lakh based on experience.We are looking for an experienced Oracle Database Administrator (DBA) to join our team, with proven expertise in managing Oracle databases on Amazon Web Services (AWS). This role requires strong hands-on experience with Oracle Enterprise Manager (OEM) for proactive monitoring and performance tuning. Familiarity with...

  • Oracle HCM Functional Architect

    2 days ago

    New Delhi, India Oracle Full time

    Job Summary: We are seeking an experiencedOracle HCM Solution Architectto lead the design, implementation, and optimization of Oracle HCM Cloud solutions. This role requires a deep understanding of Oracle HCM Cloud modules, HR business processes, and enterprise architecture. The ideal candidate will work closely with business stakeholders, project managers,...

  • Oracle Database Administration

    1 day ago

    Delhi, India AHRC Pvt Ltd Full time

    Job description: - Performing both Oracle and also operating system performance Monitoring and the necessary adjustments. - Be able to provide a strategic database direction for the organization. Key requirements: - 5 plus experience with ORACLE database administration. - Knowledge in Oracle 11g/12c. - Knowledge on Data guard. - Knowledge on RMAN backup...

  • Oracle Database Administrator

    1 week ago

    Delhi, Delhi, India Tata Advanced Systems Limited Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    Key Responsibilities:Manage tablespaces, ASM disk groups, and grid infrastructure status checksOracle RAC detailsOracle 19C and Familiarity with ExaCC console, OCI basics, Cloud ControlMonitor performance using AWR, ADDM, ASH reportsstorage server health checksOracle DB installationDB restorationPerform regular backups & recovery using RMANMonitoring with...