Position Title: Database Architect Position Summary: NEC Corporation India Pvt Ltd is looking for an energetic and highly skilled Database expert to design, build, deliver and support various data management related (SQL and No-SQL) solution which covers both SQL, No-SQL technologies and platform agnostic. Candidate should have very good tenure with distributed data management, data storage including databases (Relational, NoSQL, Big data, data analysis, data processing, data transformation, high availability, and scalability). 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
Added to this, candidate should have experience with below 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
• Integrating with application and services
• 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
• Total Experience: 15 years
• Relevant Experience: 12+ years

Qualifications:
• Any Graduate Preferred: BCA/B.Tech/B.E./BSC or equivalent
Professional Qualifications/Certification
• 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.
• Experience with application programs such as stored Procedures, Functions, Packages, cursors, collections, and triggers and materialized views using SQL and PL/SQL with exception handling.
• 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 for Database middleware related work and coordinating with application and development team
• 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