Database Architect

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