SQL/oracle Database Architect

2 months 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)



  • Delhi, India Alchemy Techsol Full time

    Role : Oracle DBAExp : 8+Location : BangaloreMandatory skills : Oracle DBA, Any scripting (shell Preferred), Any cloud (AWS Preferred), Performance tuning, SQLMode of work : HybridNotice Period : Immediate to 30 days.Position Overview:As an Oracle DBA, you will be responsible for managing and maintaining our Oracle database systems to ensure optimal...


  • Delhi, India Oracle Full time

    Job DescriptionCustomer Success Services (CSS) is a unit within the Oracle’s Customer Service Organization that establishes long-term relationships with many of Oracle's customers through annuity-based service contracts and project based one-time services. CSS services team sells from a broad IT-services portfolio both in fixed price and T&M basis. CSS...


  • delhi, India Coffeee.io Full time

    Role- SQL Database ArchitectExperience- 6-8 yearsLocation- Bangalore (Hybrid)Skills- SQL, ETL, Azure1. Excellent SQL Skills. Deep understanding of SQL Server Architecture , SQL Performance tuning exposure.2. Expertise in writing T-SQL Queries, Dynamic-queries using Joins, Sub queries, Stored Procedures, Functions, Views, Triggers and CTE functions.3....


  • delhi, India Alchemy Techsol Full time

    Role : Oracle DBAExp : 8+Location : BangaloreMandatory skills : Oracle DBA, Any scripting (shell Preferred), Any cloud (AWS Preferred), Performance tuning, SQLMode of work : HybridNotice Period : Immediate to 30 days.Position Overview:As an Oracle DBA, you will be responsible for managing and maintaining our Oracle database systems to ensure optimal...


  • delhi, India SMC Group Full time

    Job Description for SQL server DBA PostgreMonitor system's health and performanceDefine, implement and support database backup and recovery policies using RMANPerform database restoration and recovery in the event of a failure.Experience on Oracle Database administration running on Window and Linux.Supports large number of Oracle databases.Production...


  • Delhi, India Oracle Full time

    ACS is industry-leading expertise with the highest customer satisfaction to support organization’s business every step of the way.• Available to work in 24X7 capability.•Must have solid Oracle RAC , Golden Gate & Data Guard experience.• Strong Performance tuning skills – Query level tuning / DB tuning / Memory level tuning.• Expert knowledge of...


  • delhi, India SMC Group Full time

    Job Description for SQL server DBA Postgre Monitor system's health and performance Define, implement and support database backup and recovery policies using RMAN Perform database restoration and recovery in the event of a failure. Experience on Oracle Database administration running on Window and Linux. Supports large number of Oracle databases. Production...


  • Delhi, India SMC Group Full time

    Job Description for SQL server DBA PostgreMonitor system's health and performanceDefine, implement and support database backup and recovery policies using RMANPerform database restoration and recovery in the event of a failure.Experience on Oracle Database administration running on Window and Linux.Supports large number of Oracle databases.Production...


  • delhi, India Careerfit.ai Full time

    Responsibilities : Database Management : Install, configure, and maintain Oracle database software and associated components. Create and manage database objects such as tables, indexes, views, and stored procedures. Automate routine database tasks using scripting languages. Perform schema design and optimization to ensure efficient data storage and...


  • Delhi, India Careerfit.ai Full time

    Responsibilities : Database Management : Install, configure, and maintain Oracle database software and associated components. Create and manage database objects such as tables, indexes, views, and stored procedures. Automate routine database tasks using scripting languages. Perform schema design and optimization to ensure efficient data storage and...


  • Delhi, India Careerfit.ai Full time

    Responsibilities :Database Management :Install, configure, and maintain Oracle database software and associated components.Create and manage database objects such as tables, indexes, views, and stored procedures.Automate routine database tasks using scripting languages.Perform schema design and optimization to ensure efficient data storage and...


  • Delhi, India Careerfit.ai Full time

    Responsibilities : Database Management : Install, configure, and maintain Oracle database software and associated components. Create and manage database objects such as tables, indexes, views, and stored procedures. Automate routine database tasks using scripting languages. Perform schema design and optimization to ensure efficient data storage and...


  • Delhi, India Careerfit.ai Full time

    Responsibilities :Database Management :Install, configure, and maintain Oracle database software and associated components.Create and manage database objects such as tables, indexes, views, and stored procedures.Automate routine database tasks using scripting languages.Perform schema design and optimization to ensure efficient data storage and...


  • New Delhi, India SMC Group Full time

    Job Description for SQL server DBA PostgreMonitor system's health and performanceDefine, implement and support database backup and recovery policies using RMANPerform database restoration and recovery in the event of a failure.Experience on Oracle Database administration running on Window and Linux.Supports large number of Oracle databases.Production...

  • DBA -Oracle PL/SQL

    5 days ago


    Delhi, India Novalink Solutions LLC Full time

    Job DescriptionDatabase Architect IV designs and builds relational databases. Develops strategies for dataacquisitions, archive recovery, and database implementation. Cleans and maintains thedatabase by removing / archiving / deleting data. Must be able to design, develop andmanipulate database management systems, data warehouses and...


  • Delhi, India Oracle Full time

    We are looking for dynamic and forward-looking engineers to join our database cloud engineering team. Candidate must have Oracle Database Administration experience as a Site Reliability Engineer or DBA on large production environments. Understand the end-to-end configuration, technical dependencies, and overall behavioral characteristics of large-scale...


  • Delhi Division, India Careerfit.ai Full time

    Responsibilities :Database Management :Install, configure, and maintain Oracle database software and associated components.Create and manage database objects such as tables, indexes, views, and stored procedures.Automate routine database tasks using scripting languages.Perform schema design and optimization to ensure efficient data storage and...


  • Delhi Division, India Careerfit.ai Full time

    Responsibilities :Database Management :Install, configure, and maintain Oracle database software and associated components.Create and manage database objects such as tables, indexes, views, and stored procedures.Automate routine database tasks using scripting languages.Perform schema design and optimization to ensure efficient data storage and...


  • Delhi, India Oracle Full time

    oTech Team within SaaS Engineering and Oracle Applications Labs (OAL) runs the Oracle software that runs Oracle. oTech is responsible for implementing, running, and improving nearly all of Oracle’s Enterprise and Cloud Applications. We use Oracle’s business requirements as a “test bed” for innovation. We often are ahead of the standard product...

  • PL/SQL Developer

    3 weeks ago


    Delhi, India Oracle Full time

    7 to 15 years of experience as Oracle PLSQL Developer.You possess experience in end-to-end Development and / or Implementation and / or Support activities covering expertise areas such as design of customizations, Coding and Unit testing, completing Test cycle rounds including End of Days, migrations, and Integrations for Oracle Core banking productsYou...