Loading...
Share this Job

Tech Lead/Architect(Database)

Date:  Sep 26, 2021
Location: 

PUNE, MH, IN

Requisition ID:  30738

About Avaya

Businesses are built by the experiences they provide, and every day millions of those experiences are delivered by Avaya Holdings Corp. (NYSE: AVYA). Avaya is shaping what's next for the future of work, with innovation and partnerships that deliver game-changing business benefits. Our cloud communications solutions and multi-cloud application ecosystem power personalized, intelligent, and effortless customer and employee experiences to help achieve strategic ambitions and desired outcomes. Together, we are committed to help grow your business by delivering Experiences that Matter. Learn more at www.avaya.com.

Job Information

Job Code: 00194006

Job Family: Research and Development

Job Function: Software Engineering

ABOUT THE RESPONSIBILITIES

  • Develop database procedures, functions and triggers using PLPG/SQL.
  • Develop shell scripts for database operations.
  • Perform database tuning and performance monitoring of PostgreSQL.
  • Assist developers with database activities.
  • Tune database queries
  • Database support for DB issues
  • Communicate with CloudOps team and Cloud Provider on Database Issues.
  • Maintain existing software systems by identifying and correcting software defects.
  • Review and analyze business requirements and provide technical feasibility and estimates.
  • Involve in development of Product and Service level BDDs.
  • Participate in Agile ceremonies like SCRUM, Sprint Planning etc.

ABOUT THE REQUIREMENTS

SKILLS & COMPETENCIES

  • Practical & strong understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
  • Good understanding of views, Synonyms, materialized view, Indexes, Joins, Partitioning and sharding.
  • Tune database queries
  • Good understanding of the Linux operating system and its tuning
  • Conversant with shell scripting
  • Monitor application related jobs, data replication backup / restore, PITR related activities
  • Perform general technical trouble shooting, give consultation to other development team members, handle customer escalations and communication with vendors.
  • Working experience on large scale multi-tenant deployment and handling large volume of data.
  • Installation, configuration and upgrading of PostgreSQL in any public, private, or hybrid cloud infrastructure.
  • Install and configuration for scaling, high-availability, disaster recovery, monitoring for PostgreSQL.
  • Experience on Azure Hyperscale is a huge plus
  • Database support for DB issues
  • Experience in implementing Database Security techniques.
  • Experience and good understanding of Oracle, Informix and SQL Server databases, related utilities and tools is desirable.
  • Experience in any Data Lake technology (Hadoop, Big data etc.) is huge plus.

 

Experience

15 - 20 years of experience

Education

Bachelor degree or equivalent experience
Advance Degree preferred

Preferred Certifications

Footer

Avaya is an Equal Opportunity employer and a U.S. Federal Contractor. Our commitment to equality is a core value of Avaya. All qualified applicants and employees receive equal treatment without consideration for race, religion, sex, age, sexual orientation, gender identity, national origin, disability, status as a protected veteran or any other protected characteristic. In general, positions at Avaya require the ability to communicate and use office technology effectively. Physical requirements may vary by assigned work location. This job brief/description is subject to change. Nothing in this job description restricts Avaya right to alter the duties and responsibilities of this position at any time for any reason. You may also review the Avaya Global Privacy Policy (accessible at https://www.avaya.com/en/privacy/policy/) and applicable Privacy Statement relevant to this job posting (accessible at https://www.avaya.com/en/documents/info-applicants.pdf).