Database Architect

3 weeks ago

Noida, India SA Technologies Inc. Full time

Location - Noida

**Position Title: Database Architect**

Below are the key areas of expertise needed
Data Architecture
- Data Modelling and Design
- Data Storage and Operation
- Date Security
- Data Integration and Interoperability
- Document and Content Management
- Reference and Master Data
- Data Warehousing and Business Intelligence
- Metadata management
- Data Quality

**Key Skills-**
- PostgreSQL, MySQL, MS-SQL, Oracle Databases
- DWH Experience (Greenplum/Teradata/Exadata/Vertica/Hadoop or Open Source based)
- Azure SQL, Azure Synapse Solution and administration
- Containerization of DB server/services (Kubernetes, Open Shift, Docker-Container)
- Experience / Knowledge in data mining
- ETL tools such as Azure Data factory, Glue, Talend, Informatica, Snowflake and Open source based ETL tools
- Database Backup and recovery (Native Backup, RMAN, Integrating with Backup Tools)
- SQL Management (Query building, Execution, Programming)
- Database archival management, purging, etc.
- HA and DR configuration of Databases
- Data ingestion and Database integration
- Database User management and Key management
- Performance tuning of various databases
- Database migration/upgrade same and cross platform
Experience in Linux Administration.
- Experience in database middleware tools.
- Experience in sizing database and data management requirement.
- Experience in multi-terabyte production environments

**Education/Required Qualifications**

v. Total Experience: 15 years

vi. Relevant Experience: 12+ years

**Qualifications**:
v. Any Graduate Preferred: BCA/B.Tech/B.E./BSC or equivalent

**Professional Qualifications/Certification**

v. Database related certification

**Responsibilities**:

- Responsible for the Architecting systems architecture, design, and development of a large, scaled-out, real-time, high performing Data Lake / Data Warehouse systems (including Big data and Cloud)
- Requirements analyses and finalize in discussion with the customer
- Design, modelling based on the customer ecosystem based on the set the guidelines
- Convert the work package into modules and work closely to deliver the task
- Manage the team for the technical deliveries
- Creation of complex Queries to retrieving data from database using joins, Sub Queries, Correlated Sub-queries, and Hierarchical queries for data retrieval operations and converting into Views and materialized views based on business requirement.
- Creation of database objects like tables, indexes, views, Sequences, Synonyms, and constraints.
Develop Packages (SQL loader, Data pump, and Import/Export utilities) each to import data to Oracle base tables from external files like CSV, Excel, JSON and XML.
- Develop Shell Scripts for invoking SQL scripts and scheduled in using jobs.
- Performing Unit Testing and Performance Tuning for each program developed.
- Preparing below mentioned documents for each project;
- Prepare Requirement specification document
- Prepare Technical Design Document
- Coding and scripts documentations
- Supporting team for integration with apache Spark and other open source framework for data processing
- Well versed in the Data domains (Data Warehousing, Data Governance, MDM, Data Quality, Data Catalogue, Analytics, BI, Operational Data Store, Metadata, Unstructured Data, ETL, ESB)
- Responsible for installation and configuration of Databases, back up, restoring databases, setting up High Availability, Disaster recovery, performance tuning etc.
- Perform Relational Database Modeling and Database Design on different operating systems
- Responsible for PostgreSQL/MS SQL Database administration.
- Design and deploy high availability load balancing and DR in On-Premise as well in Cloud environment
- Design backup policy/template and configure overall database backup and recovery
- Database Performance tuning and optimization which includes Operating System-level parameters also.
- Responsible for Database migration from one platform to another
- Responsible for providing CDC solutions
Responsible to deploy and manage No-SQL databases like Hadoop HDFS, Hive etc.
- Responsible for working on cloud infrastructures such as Azure and AWS
- Responsible for developing SQL administration or data ingestion script using shell/PowerShell, PL SQL T-SQL, and PL/SQL
- Design and Development of database migration strategy
- Coordinate with a development team with schema conversion of database to PostgreSQL
- Monitoring and troubleshooting new database systems.
- Performance tuning in PostgreSQL and Oracle databases
- Configuring multiple databases as per requirement
- Provide support for on PostgreSQL/MS-SQL solution

**Job Information**:
Job Opening ID

**SA-6820-JOB**
***

Industry

**IT Services**
***

City

**Noida**
***

State/Province

**Uttar Pradesh**
***

Country

**India**
***

Zip/Postal Code

**201301

  • Database Architect

    3 weeks ago

    Noida/Hyderabad/Bangalore, IN NLB Services Full time

    Company Description : Founded in 2007, NLB Services is a fast-growing global technology and digital talent solutions provider with headquarters in Alpharetta, Georgia (USA). We have a vast global presence and strategic partnerships with leading Fortune 500 companies. Our team of over 8000 professionals brings unparalleled domain depth and exceptional digital...

  • Database Architect

    4 weeks ago

    Noida,Hyderabad,Bangalore, India NLB Services Full time

    Company Description : Founded in 2007, NLB Services is a fast-growing global technology and digital talent solutions provider with headquarters in Alpharetta, Georgia (USA). We have a vast global presence and strategic partnerships with leading Fortune 500 companies. Our team of over 8000 professionals brings unparalleled domain depth and exceptional digital...

  • Database Architect

    2 weeks ago

    Noida, India SM IT SERVICES Full time

    - Minimum 10 years - Noida - Service Based 5 days working - Database Design and Development: Design, implement, and maintain database architectures that align with business requirements and industry best practices. Develop data models, schemas, and database structures for optimal performance and scalability.- Performance Optimization: Monitor and...

  • Lead Consultant, Database Architect

    2 weeks ago

    noida, India Genpact Full time

    Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose – the relentless pursuit of a world that works better for people –...

  • Lead Consultant, Database Architect

    2 weeks ago

    Noida, India Genpact Full time

    Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose – the relentless pursuit of a world that works better for people –...

  • SFCC Backend Architect

    7 days ago

    Hyderabad/Noida/Gurgaon/Gurugram/Pune, India Augmented Database pvt ltd Full time

    Position Name : SFCC Backend Architect Relevant Experience : SFCC Backend architect - 6+ years Location : Hybrid (Hyderabad, Pune, Gurugram, Noida) Required Skills : - Experience in developing business solutions using Salesforce Commerce Cloud (Demandware).- Good knowledge of SFCC / Demandware Script, Java OOP/Node.js.- Expertise in RESTful web services,...

  • Head - Database Administration

    4 weeks ago

    Noida, India Acumont Solutions Full time

    Key Responsibility Areas : - Architect, Design and Develop solutions to support business requirements.- Use skill sets to Analyze and manage a variety of database environments such as Oracle, Postgres, Cassandra, MySql, Graph DB, etc- Provide optimal design of database environments, analysing complex distributed production deployments, and making...

  • Solution Architect

    4 weeks ago

    Noida, India Airtel India Full time

    Network Architect will be a key member of the Systems Engineering team which will be focused on evaluating and solution in the area of Cloud - compute, network, storage and database infrastructure. The architect will serve as a primary technical advisor and will be responsible for adopting new technologies, design scalable, maintainable and highly available...

  • Data Architect

    4 weeks ago

    noida, India Zenon Analytics Private limited Full time

    Sr. Data Architect / Data Architect Experience: 10+ Years Summary: The Data Architect will design and implement data solutions that support the organization’s strategic business goals. Responsibilities: • Focuses on enterprise-wide data modelling and database design. • Tests, monitors, manage and validate data warehouse activity including data...

  • IndiaMART - Database Manager - Solution Design & Architecture

    1 week ago

    Noida, Ghaziabad, India IndiaMART Full time

    Key Responsibility Areas :- Architect, Design and Develop solutions to support business requirements.- Use skill sets to Analyze and manage a variety of database environments such as Oracle, Postgres, Cassandra, MySql, Graph DB, etc- Provide optimal design of database environments, analysing complex distributed production deployments, and making...

  • IndiaMART - Database Manager - Solution Design & Architecture

    1 week ago

    Noida, India IndiaMART Full time

    Key Responsibility Areas :- Architect, Design and Develop solutions to support business requirements.- Use skill sets to Analyze and manage a variety of database environments such as Oracle, Postgres, Cassandra, MySql, Graph DB, etc- Provide optimal design of database environments, analysing complex distributed production deployments, and making...

  • IndiaMART - Database Manager - Solution Design & Architecture

    1 week ago

    noida, India IndiaMART Full time

    Key Responsibility Areas :- Architect, Design and Develop solutions to support business requirements.- Use skill sets to Analyze and manage a variety of database environments such as Oracle, Postgres, Cassandra, MySql, Graph DB, etc- Provide optimal design of database environments, analysing complex distributed production deployments, and making...

  • IndiaMART - Database Manager - Solution Design & Architecture

    1 week ago

    Noida, India IndiaMART Full time

    Key Responsibility Areas :- Architect, Design and Develop solutions to support business requirements.- Use skill sets to Analyze and manage a variety of database environments such as Oracle, Postgres, Cassandra, MySql, Graph DB, etc- Provide optimal design of database environments, analysing complex distributed production deployments, and making...

  • Java Architect

    7 days ago

    Noida, India SourceFuse Technologies Full time

    **Job Information**: Work Experience 8+ years Industry IT Services City Noida State/Province Uttar Pradesh Zip/Postal Code 201301 - Technical Lead and architect on projects consisting of migrations to cloud native technologies in the JAVA ecosystem - Collaborate with the sales support or account team by acting as technical experts in customer...

  • .NET Architect

    1 week ago

    noida, India Coforge Full time

    Job Title- .NET Architect Experience- 12 - 18 years Skills- .NET core, SQL server, Design patterns & Architecture Locations- Greater Noida & Bengaluru Mode - Mandatory Work from office Shift Timings- 2:00 PM - 10:30 PM We at Coforge are hiring .Net Architects with the following skillset: Responsible for technical design, development (database and/or...

  • .NET Architect

    1 week ago

    Noida, India Coforge Full time

    Job Title- .NET ArchitectExperience- 12 - 18 yearsSkills- .NET core, SQL server, Design patterns & ArchitectureLocations- Greater Noida & BengaluruMode- Mandatory Work from officeShift Timings- 2:00 PM - 10:30 PMWe at Coforge are hiring .Net Architects with the following skillset:Responsible for technical design, development (database and/or GUI), and...

  • .NET Architect

    1 week ago

    Noida, India Coforge Full time

    Job Title- .NET ArchitectExperience- 12 - 18 yearsSkills- .NET core, SQL server, Design patterns & ArchitectureLocations- Greater Noida & BengaluruMode- Mandatory Work from officeShift Timings- 2:00 PM - 10:30 PMWe at Coforge are hiring .Net Architects with the following skillset:Responsible for technical design, development (database and/or GUI), and...

  • Java Architect/Senior Architect

    4 weeks ago

    Bangalore,Noida, India Squareroot Consulting Pvt Ltd. Full time

    Hiring Java Architect or Senior Architect for SaaS Product Company in Fintech domain.Looking for Tech Architects who have built fault tolerant, Scalable and High Available Systems. Must be hands on coding/designing & have built for scale.Position: Software ArchitectExperience : 10+ YearsLocation: Bangalore, IndiaEducation: BE/BTech/MS/MTech (Preferably from...

  • AEM Full Stack Developer

    7 days ago

    Noida/Gurgaon/Gurugram/Hyderabad/Pune, IN Augmented Database pvt ltd Full time

    Position : AEM Fullstack DeveloperRelevant Experience : 6+yearsJob Location : Hyderabad, Pune, Noida, Gurugram (Hybrid)Job Description : We are seeking an experienced AEM Full Stack Developer with a proven track record in architecting, developing, and managing Adobe Experience Manager (AEM) solutions. The ideal candidate will have extensive expertise in...

  • AEM Full Stack Developer

    7 days ago

    Noida/Gurgaon/Gurugram/Hyderabad/Pune, India Augmented Database pvt ltd Full time

    Position : AEM Fullstack Developer Relevant Experience : 6+years Job Location : Hyderabad, Pune, Noida, Gurugram (Hybrid) Job Description : We are seeking an experienced AEM Full Stack Developer with a proven track record in architecting, developing, and managing Adobe Experience Manager (AEM) solutions. The ideal candidate will have extensive expertise in...