DB Architect

5 days ago

Level Western Aqua Whitefields HiTech City Telangana Hyderabad India Amphora Full time ₹ 12,00,000 - ₹ 36,00,000 per year


Role: DB Architect (Senior-Level) [FTE]
Location: Hyderabad, India
Amphora Software Pvt. Ltd. is the premier software solution provider for energy trading, logistics and risk management in the global crude oil, refined products and energy derivatives marketplace. Our team includes some of the most experienced software designers, developers and business analysts in the commodities industry today. Since our inception, our main goal has been to provide the trading community with the most robust, user-friendly, enterprise-wide software package available. We continue to launch new products that address customers' needs and adjust to dynamic market demands.
Reports to: Direct report to the Chief Architect.
Role purpose:  100% FTE allocation to; (1) development of T-SQL code which is managed as an application and (2) the split of an existing SQL dbase into 10 separate product/commodity specific databases (data modelling, schema, ER, ETL solution). We seek a technologist with exposure in the Commodities industry who is passionate about technology and has experience developing code for structured database manipulation in enterprise-wide solutions.
Technical Roles and Responsibilities: 
[SFIA alignment: DATM-L4 | DTAN-L4 | DBDS-L4 | DENG-L4 | DBAD-L4 | DATS-L3 | MLNG-L2 | BINT-L3 | VISL-L4] | SCTY-L3 | PEDP -L5 | IRMG-4]
  • Design and develop database architectures that meet business requirements for performance, scalability, and security.
  • Create and maintain database diagrams in sync with data models, schemas, and databases
  • Develop and enforce database standards and best practices.
  • Expertise in Monolithic and Microservices Architecture to split the databases based on Products Strategy and Separation of Concerns
  • Solutioning for Analytics and Reporting
  • Knowledge in Data Fabric, lake house etc
  • In depth understanding of Analysis Services
  • Strategy and Data Transformation, including ETL and ELT Transformations
  • Understanding of Service oriented architecture of DB,
  • Database isolation micro services strategies adhering to Product Architecture
  • Data Modeling, Data Governance, Data Lifecycle Management aligning with Business goals and Product Architecture
  • Designing privacy-friendly products, services and systems that respect customer privacy and embed data protection
  • Performing impact assessments, identify risks whilst enabling prudent use of data and addressing issues with products and services
  • Creating privacy risk models and frameworks
  • Supports the implementation of information and records management policies and standard practice.
  • Monitors the implementation of effective controls for internal delegation, audit and control relating to information and records management.
  • Reports on the consolidated status of information controls to inform effective decision-making.
  • Identifies risks around the use of information. Recommends remediation actions as required.
  • Devises and implements master data management processes for specific subsets of data.
  • Assesses the integrity of data from multiple sources.
  • Provides advice on the transformation of data from one format/medium to another. Maintains and implements information handling procedures.
  • Enables the availability, integrity and searchability of information through the application of formal data and metadata structures and protection measures.
  • Investigates enterprise data requirements where there is some complexity and ambiguity.
  • Plans own data modelling and design activities, selecting appropriate techniques and the correct level of detail for meeting assigned objectives.
  • Provides advice and guidance to others using the data structures and associated components.
  • Implements physical database designs to support transactional data requirements for performance and availability.
  • Develops and maintains specialist knowledge of database and data warehouse concepts, design principles, architectures, software and facilities.
  • Assesses proposed changes to object/data structures and evaluates alternative options.
  • Implements data warehouse designs that support demands for business intelligence and data analytics.
  • Designs, implements, and maintains complex data engineering solutions to acquire and prepare data.
  • Creates and maintains data pipelines to connect data within and between data stores, applications and organisations.
  • Carries out complex data quality checking and remediation.
  • Develops and configures tools to enable automation of database administration tasks.
  • Monitors performance statistics and create reports.
  • Identify and investigates complex problems and issues and recommends corrective actions.
  • Performs routine configuration, installation, and reconfiguration of database and related products.
  • Applies existing data science techniques to new problems and datasets using specialised programming techniques.
  • Selects from existing data sources and prepares data to be used by data science models.
  • Evaluates the outcomes and performance of data science models. Identifies and implements opportunities to train and improve models and the data they use.
  • Publishes and reports on model outputs to meet customer needs and conforming to agreed standards.
  • Applies given machine learning techniques to data, under the guidance of technical leadership.
  • Analyses and reports findings and remediates simple issues using algorithms implemented in standard software frameworks and tools.
  • Sources and prepares data for analysis and performs standard business intelligence analysis activities.
  • Creates and delivers standard reports in accordance with stakeholder needs and conforming to agreed standards.
  • Investigates the need for new or revised business intelligence analysis.
  • Contributes to the recommendation of improvements. Engages with stakeholders under direction.
  • Applies a variety of visualisation techniques and designs the content and appearance of data visuals.
  • Operationalises and automates activities for efficient and timely production of data visuals.
  • Selects appropriate visualisation approaches from a range of applicable options.
  • Contributes to exploration and experimentation in data visualisation.c
  • Applies and maintains specific security controls as required by organisational policy and local risk assessments.
  • Communicates security risks and issues to business managers and others. Performs basic risk assessments for small information systems.
  • Contributes to the identification of risks that arise from potential technical solution architectures. Suggests alternate solutions or countermeasures to mitigate risks. Defines secure systems configurations in compliance with intended architectures.
  • Supports investigation of suspected attacks and security breaches.
  Other Roles and Responsibilities:
  • Adherence to the company Engineering Excellence practice by following mandated practices and patterns.
  • Accounting for personal daily time and attendance.
  • Such tasks as the Company may reasonably request from time to time.
Technical Experience and Expertise:    A broad range of technology knowledge to an appropriate level of competency including but not limited to:
  • T-SQL programming and Microsoft SQL server.
  • Microsoft SQL server database services (SSRS, SSAS, SSIS).
  • Microsoft Azure cloud services (DaaS, Analysis Service, Storage Containers and so on).
  • No-SQL (unstructured datastore) such as MongoDB (Azure Cosmos).
  • Microsoft Visual Studio (for Symantec modelling) and Python (for ETL).
  • SQL Server IAAS to PAAS Migration Strategy
  • Remote connection methods for cloud hosted database services access.
  • Data security techniques for data at rest and data in transit such as transparent data encryption (TDE).
  Skill Set:
  • Be self-motivated, proactive with thoroughness and attention to detail in communication, documentation etc. without assumption.
  • Strategic and analytical thinking with ability to grasp customer requirements.
  • Ability to conceptualize solutions and present ideas to management and stakeholders.
  • Great communication and negotiation skills with the ability to be proactive in adapting to technology needs and requirements.
  • Well organised with strong time management capability.

Experience:
  • 10+ years' experience in developing database code/configuration for enterprise applications, ideally within a commodity trading or Financial Services industry/sector.

Qualifications:
  • A relevant undergraduate degree is mandatory for this role. Postgraduate qualifications are desirable.


Level:
Team Lead - Band H

  • Technical Architect

    2 weeks ago

    Level , Western Aqua, Whitefields, Hi_Tech City Telangana, Hyderabad, India Amphora Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Role: Technical Architect [FTE]Location: Hyderabad, IndiaAmphora Software Pvt. Ltd. is the premier software solution provider for energy trading, logistics and risk management in the global crude oil, refined products and energy derivatives marketplace. Our team includes some of the most experienced software designers, developers and business analysts in...

  • DB Architect

    2 weeks ago

    Hyderabad, Telangana, India warrior tech solutions Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Hi,Greetings from EWarriors Tech Solutions. We are hiring for the following position:Role: DB Architect (NoSQL)Location: Hyderabad (Onsite)Experience: 8+ YearsEmployment: ContractNotice: Immediate Joiners / Less than 15 DaysPrimary:· 4–5 years of experience as a MongoDB Architect, with strong knowledge of internals, aggregation framework, indexing, and...

  • Oracle DB Migration Architect

    2 days ago

    Hyderabad, Telangana, India Adv Techminds Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    We are hiring an Oracle DB Migration Architect to lead database migrations across platforms. Must have strong expertise in Oracle GoldenGate (including Hub methodology) and proven experience in large-scale migrations.Mode: RemoteKey Skills:Oracle DB migration strategy and execution.Oracle GoldenGate expertise.Large-scale DB migration...

  • DB automation

    2 weeks ago

    India Virtusa Full time

    Job Description Minimum of 5 Years of Mongo DBA Architect, Strong Internals, Aggregation framework, Indexing and experience with MongoDB Atlas. Minimum of 5+ Years of Hadoop DBA Architect, experience with Hadoop distributions (Cloudera, Hortonworks, or Apache) and Strong knowledge of Hadoop ecosystem components: HDFS, YARN, Hive, HBase, Spark, Oozie,...

  • Director - DBS

    4 days ago

    Bengaluru, India Danaher Full time

    Job Description Bring more to life. At Danaher, our work saves lives. And each of us plays a part. Fueled by our culture of continuous improvement, we turn ideas into impact - innovating at the speed of life. Our 63,000+ associates work across the globe at more than 15 unique businesses within life sciences, diagnostics, and biotechnology. Are you ready to...

  • Director - DBS

    23 hours ago

    Bengaluru, India Danaher Corporation Full time

    Job Description Bring more to life. At Danaher, our work saves lives. And each of us plays a part. Fueled by our culture of continuous improvement, we turn ideas into impact innovating at the speed of life. Our 63,000+ associates work across the globe at more than 15 unique businesses within life sciences, diagnostics, and biotechnology. Are you ready to...

  • Software Architect for DB

    2 weeks ago

    Hyderabad, India Cubic Corporation Full time

    Job Description Business Unit: Cubic Transportation Systems Company Details: When you join Cubic, you become part of a company that creates and delivers technology solutions in transportation to make people's lives easier by simplifying their daily journeys, and defense capabilities to help promote mission success and safety for those who serve their nation....

  • DB automation

    2 weeks ago

    Hyderabad, Telangana, India Virtusa Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Minimum of 5 Years of Mongo DBA Architect, Strong Internals, Aggregation framework, Indexing and experience with MongoDB Atlas. Minimum of 5+ Years of Hadoop DBA Architect, experience with Hadoop distributions (Cloudera, Hortonworks, or Apache) and Strong knowledge of Hadoop ecosystem components\: HDFS, YARN, Hive, HBase, Spark, Oozie, Zookeeper, etc.Minimum...

  • Cosmos DB Developer

    7 days ago

    Chandigarh, India Emerson Full time

    Job Description Job Description Job Description: We need a skilled Senior Developer proficient in Cosmos DB to lead developing scalable NoSQL databases on Azure Cosmos DB. Extensive familiarity with distributed data systems and a track record of successfully integrating Cosmos DB with modern digital applications are essential for this position In This Role,...

  • Aws Solution Architect

    2 weeks ago

    Hyderabad, Telangana, India Tata Consultancy Services Full time

    TCS invites Applicants for AWS Solution Architect Exp: 10 Yrs to 12 Yrs Location: HYD, BLR Excellent knowledge in AWS IoT Core and must have experience in IoT Device Management, Provisioning, Authentication, Command & Controls. Must be skilled in other AWS services - S3, IoT Core, Fargate, API Gateway, Lambda, Dynamo DB, RDS, Elastic Load Balancer, Route...