People Matter

Cloud Architect - Oracle DBA

Ayasdi

Ayasdi

Software Engineering, IT
Bengaluru, Karnataka, India · India
Posted 6+ months ago
Introduction

At SymphonyAI, we are building the leading AI SaaS company for enterprise transformation across the most critical industry sectors. We provide focused AI applications designed to rapidly solve challenging business problems and deliver breakthrough insights, increasing operational efficiencies and growing revenue for customers


Job Description

JOIN US!

Symphony RetailAI is global leader in AI-enabled decision platforms, solutions, and insights for driving profitable revenue growth for retailers and CPG manufacturers – from customer intelligence to merchandising, personalized marketing to supply chain.

Our organization rapidly innovates to drive faster, more profitable decisions through AI, machine learning and voice technologies. To help high volume retailers and CPG manufacturers move beyond the hype of AI and toward the actual realization of benefits, we’ve launched a three-pronged approach to delivering profitable revenue growth – “Identify, Activate, Realize (IAR).” We identity growth opportunities through AI recommendations; activate plans and execute intelligent actions; realize the goal by measuring improvement in revenue and profit.

We put IAR to work each day in achieving our customer promise:

  • To show profitable growth in one year for our customers
  • Be the easiest to do business with
  • Have the best quality and service for customer success
  • To champion breakthrough AI-enabled innovation

THE OPPORTUNITY

You will get a chance to work in a company who has world class solutions in retail supply chain management and will help to understand the different aspects of supply chain management in retail sector. You will have opportunity in deploying and managing enterprise applications in Azure cloud, including AI/ML products which operates on High Performance Computing Servers powered by GPUs. You will have a chance to fine tune performance aspects, automate the deployments including monitoring and work on configuration management tools.

KEY ACTIVITIES

  • SQL/PlSql development.
  • SQL and PL/SQL development skills are pivotal in the professional landscape for several reasons like data management, optimize performance and data integrity etc.

  • Performance and tuning.
  • One of the primary goals of database performance tuning is to reduce response time for queries and transactions. Faster response times enhance user experience, particularly in applications where responsiveness is critical.

  • Database Administration, Availability and Stability.
  • Maintaining highly visible production databases and ensuring stability by designing, installing, upgrading, patching, tuning, monitoring and troubleshooting databases with large amounts of data (Terabytes) and high transaction rates. Immediate participation in an active on call rotation required. Candidate must be capable of providing off-hours support to avoid impacting database availability during normal business hours.

  • Enhance and Apply Technical Product Knowledge
    • Understand a give solution to assess its alignment with business needs, particularly with the new DevOps framework.
    • Keep abreast of emerging industry trends to continuously update operations and assess how competition differs from current state.
    • Communicate the business value of technical solutions.
    • Discover mutually beneficial solutions across customers while recognizing different styles.

KEY CRITERIA

  • Experience: 8 to 11 years with Oracle databases administrator cum developer requiring the following skills:
  • Strong Sql/PlSql development experience.
  • Understand the tables data and write queries for optimal performance.
  • Automation experience for Database related tasks.
  • Indexing on existing tables understanding the query structure.
  • Strong query performance analysis and execution plans reading and apply tweaks to enhance the query performance.
  • Data correction experience wherever required, example integrity constraint enable in case of data violations etc.
  • Experience in oracle baselines, sql profiles and advanced oracle performance features.
  • Understanding oracle statistics and maintenance window schedules.
  • Strong skill on oracle wait events and corresponding fixes.
  • Performance and tuning in database configuration level, like parameters, memory, storage and new feature implementations etc.
  • Errors handling and incident handling skills.
  • Multiple methodologies for database refresh like RMAN and datapump, snapshots and sparsdisk etc.
  • Exadata experience
  • Understanding advanced features of exadata.
  • Database administration on OCI especially on DBCS and ExaCs.
  • Experience on OEM configuration and administration.
  • Capacity planning, designing, and implementation of enterprise solutions using Oracle Database
  • Oracle DB migrations to OCI (DB Systems, ADW)
  • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
  • Strong experience with designing and performance tuning of large-scale databases.
  • Should have excellent presentation skills with a high degree of comfort speaking with internal and external executives, IT management, and technical teams including software development groups.
  • Should be able to work under a flexible work timings.
  • Should be able to solution, articulate and document architecture with sufficient detailing for implementation.
  • Preferred to have certifications towards Oracle databases.
  • Retail domain terminology will be helpful.

OUR VALUES

Our values are more than just words. We ask all of our employees to commit to certain behaviours to drive forward the culture we want to create and one that will make us successful, together. So check out our values e-book here and see for yourself what an exciting environment you’ll be joining.

  • We build trusted relationships
  • We openly connect & communicate
  • We are serious about quality
  • We are always innovating
  • We will win together
  • We are enthusiastic

About Us

SymphonyAI is an enterprise AI company transforming the world's largest industries with packaged AI applications. SymphonyAi is at the forefront of innovation, leveraging cutting-edge artificial intelligence and machine learning technologies to transform industries and drive business growth. As a global leader in AI-powered solutions, we empower organizations to harness the full potential of data-driven insights. SymphonyAi enterprise applications rapidly deliver transformative business value across retail, CPG, financial services, manufacturing, media, IT and enterprise operations, and the public sector.

We are on a mission to build a “World Class Engineering Team” with a high-performance culture. Over 3000 talented leaders, data scientists, and other professionals incubate and build SymphonyAI Group solutions.