Database Architect

1 month ago

Chennai, Tamil Nadu, India PDI Technologies Full time
About PDI Technologies
PDI Technologies is a leading provider of integrated portfolio of global, cloud-based solutions and services to meet the needs of convenience retailers and petroleum wholesalers. Our mission is to simplify the complexity in the world of our customers by delivering innovative technologies that drive business growth and profitability.

Primary Responsibilities
  • Design and develop scalable data systems with good data governance that provide complete, secure, accurate and timely data for analytics.
  • Establish and maintain strong relationships with business stakeholders to understand their data requirements and provide solutions that meet their needs.
  • Build highly reliable & scalable data systems with good data governance that provide complete, secure, accurate and timely data for analytics.
  • Expertise in data & dimensional modeling with good business acumen in supporting new product features and services - including financial reporting.
  • Assist development and analytics organization to meet its delivery goals with regards to data design, flow and infrastructure.
  • Perform Data Modeling, Big data architecture design, support and implementation of OLTP, real time OLAP/data warehouse systems and ETL pipelines.
  • Track/Build & monitor data/system KPI's like storage, performance & usage.
  • Hands on administration of big data databases/compute engines (Redshift, EMR, Spark or similar) and optimization/tuning techniques.
  • Prepare required documentation as outlined by departmental standards.
  • Identify, analyze and back track data problems as needed.
  • Provide recommendations for application and system improvements.
  • Mentor other team members.
  • Work with business users to understand business requirements, issues and business and/or client processes.
  • Develop, test, and maintain high-performance of our data systems to meet the requirements of the business and/clients while adhering to departmental standards.
  • Perform quality assurance testing for all work performed.
  • Meet with agile teams as required to define and document application requirements.
  • Follow project development, deployment process & maintain industry standards and best coding practices.
  • Maintain security and organization of the company's data.
  • Provide off-hour support as assigned.
  • Gather business requirements/features, estimate the tasks, design & develop scalable solutions.
  • Work with manager to ascertain the company's data requirements.
  • Plan work to meet project deadlines, accommodate demands by development teams, set priorities and escalate issues appropriately.
  • Provide recommendations to development teams for data restructuring and performing complex maintenance.
  • Deploy and manage changes in development, staging and production.
  • Assist development and dev ops teams on SQL queries and tuning.
Knowledge, Skills & Abilities
  • At least 7 years' experience in data engineering, Data modeling, SQL, ETL, Big database, Data warehousing & basic-level administration of data infrastructure.
  • At least 7 years coding experience in Java, Python, R or other equivalent programming language.
  • At least 4 years big data experience.
  • At least 2 years' experience as technical lead architecting data lake/data warehouse/lake house systems & mentoring team of Data Engineers / DBAs.
  • Design, Development & implementation of OLTP & OLAP databases with efficient design, optimization techniques & data ingestion mechanisms.
  • Proficient in Python, SQL and PL-SQL, query tuning, optimization, ETL, ELT, Data Modeling and Data Warehouse systems.
  • Proficient in a variety of big-data tools and technologies, including Hadoop, Spark, etc., handling different storage formats like Parquet, Delta/Apache Hudi/Apache Iceberg.
  • Experience building data lakes & warehouse systems leveraging cloud environments including AWS technologies –S3, Redshift, Aurora/RDS, DMS, EC2, Glue spark, Cloud watch, & EMR.
  • Experience with data orchestration tools like Airflow.
  • Experience in building pipelines, ingesting data from heterogeneous systems onto data lake environments in real time.
  • Proficient in Business Intelligence (BI), analytic database and products, able to take business requirements and translate into database tables, pipeline design and tasks.
  • General data-specific concepts, frameworks and processes.
  • Agile development practices.
  • Working within an SDLC.
  • Designing data warehouses including definition, structure, documentation, maintenance, long-range requirements, operational guidelines, and protection.
  • Data governance, meta data management, data security measures, retention & archival across data lake layers.
Other Skills and Experience
  • Cloud experience, such as AWS, GCP or Azure.
  • Building/Managing data lake & lake house architectures.
  • Experience working on different data lake storage formats.
  • Excellent oral and written communication.
  • Multi-tasking and managing multiple priorities.
  • Working well in a team-oriented, collaborative environment with people from different disciplines and varying degrees of technical experience.
  • Working in an Agile team environment.

  • Database Solution Architect

    3 weeks ago

    Chennai, Tamil Nadu, India Logic Information Systems Full time

    Database Solution Architect Job DescriptionWe are seeking a highly skilled Database Solution Architect to join Logic Information Systems. As a Database Solution Architect, you will be responsible for developing high-quality database solutions that meet the needs of our business.Key Responsibilities:Development of database solutions that meet business...

  • Database Architect

    3 weeks ago

    Chennai, Tamil Nadu, India 3110 K-T India Full time

    Job RequirementsWe are seeking a Database Architect to join our team at 3110 K-T India.Key ResponsibilitiesDesign and implement database architectures for large-scale applications.Develop and maintain database systems, ensuring high performance and data integrity.Collaborate with cross-functional teams to integrate database solutions with cloud-native...

  • Database Solutions Architect

    3 weeks ago

    Chennai, Tamil Nadu, India Innova ESI Full time

    Database Solutions ArchitectAt Innova ESI, we're seeking a skilled Database Solutions Architect to design and implement database solutions that meet our business requirements. As a key member of our team, you'll be responsible for migrating data between different database platforms, optimizing database performance, and ensuring data integrity, security, and...

  • Cloud Database Architect

    5 days ago

    Chennai, Tamil Nadu, India Sampoorna Consultants Pvt. Ltd Full time

    Job Title: Cloud Database ArchitectJob Summary:We are seeking a Cloud Database Architect to join our team at Sampoorna Consultants Pvt. Ltd. The successful candidate will design and implement scalable, secure, and high-performance database architectures on cloud platforms.Key Responsibilities:Design and deploy cloud-native databases on Azure cloud...

  • Senior Database Architect

    3 days ago

    Chennai, Tamil Nadu, India iagami Full time

    About the Role:We are seeking an experienced Database Architect to join our team at iAgami Technologies. As a key member of our database team, you will be responsible for designing, developing, and maintaining our database systems to ensure optimal performance and scalability.Key Responsibilities:- Design and implement database schemas, tables, and...

  • Cloud Database Architect

    3 days ago

    Chennai, Tamil Nadu, India 5100 Kyndryl Solutions Private Limited Full time

    At 5100 Kyndryl Solutions Private Limited, we are seeking a skilled Cloud Database Architect to join our team. The ideal candidate will possess minimum 7 years of experience as a MongoDB DBA and be proficient in MongoDB administration, performance tuning, backup and recovery, high availability (HA) and disaster recovery (DR) options, and ops manager...

  • Cloud Database Architect

    2 weeks ago

    Chennai, Tamil Nadu, India Expeditors Full time

    About This RoleWe are seeking a highly skilled Cloud Database Architect to join our team at Expeditors.Key ResponsibilitiesEnsure the recoverability of data through the design, implementation, and practice of defined database disaster recovery strategies.Establish and maintain the quality of data throughout the organization to support business goals.Monitor...

  • Database Systems Architect

    3 days ago

    Chennai, Tamil Nadu, India myGwork Full time

    Welcome to this exciting opportunity at myGwork, a leading employer committed to diversity and inclusivity. We are seeking an experienced Database Systems Architect to join our team.About the RoleThis is a key position within our Database Administration team, responsible for designing, implementing, and maintaining the backbone of our technological...

  • Database Systems Architect

    3 weeks ago

    Chennai, Tamil Nadu, India Expeditors Full time

    About the RoleWe are looking for a skilled Database Administrator to join our team at Expeditors. As a key member of our Development and Deployment team, you will play a critical role in shaping the future of our cloud native technologies.Your responsibilities will include:Designing, implementing, and maintaining our database systems to ensure their...

  • Enterprise Database Architect

    5 days ago

    Chennai, Tamil Nadu, India ValGenesis Full time

    Job DescriptionWe are seeking an experienced Enterprise Database Architect to join our team. The successful candidate will be responsible for designing and developing efficient and scalable database solutions using MS SQL Server and PostgreSQL.Responsibilities:Database Development: Design, develop, and optimize complex database solutions, including stored...

  • Principal Database Architect

    4 weeks ago

    Chennai, Tamil Nadu, India Gen Full time

    About the RoleWe are seeking a highly skilled Principal Database Architect to design, develop, and implement cutting-edge database solutions for our team. The ideal candidate will have a strong background in database architecture, design, and development, with expertise in multiple database management systems.Key ResponsibilitiesDesign and develop database...

  • Principal Database Architect

    4 weeks ago

    Chennai, Tamil Nadu, India Gen Full time

    About the RoleWe are seeking a highly skilled Principal Database Architect to join our team at Gen. As a key member of our database engineering team, you will be responsible for designing, building, and maintaining our database infrastructure. This includes designing and implementing database architectures, developing and maintaining database systems, and...

  • Senior MySQL Database Architect

    1 month ago

    Chennai, Tamil Nadu, India Solverminds Solutions & Technologies Pvt Ltd Full time

    Job Title: Senior MySQL Database ArchitectJob Summary:We are seeking a highly skilled Senior MySQL Database Architect to join our team at Solverminds Solutions & Technologies Pvt Ltd. The ideal candidate will have a strong background in designing, implementing, and maintaining large-scale MySQL database systems.Key Responsibilities:Design and implement...

  • Senior Database Architect

    4 weeks ago

    Chennai, Tamil Nadu, India DOTCOD Full time

    Job Description:At Dotcod, we are seeking a highly skilled Senior Database Architect to join our team. As a key member of our data solutions team, you will be responsible for designing, developing, and maintaining highly scalable data management systems.Key Responsibilities: Design and develop data solutions that meet the needs of our business. Develop and...

  • Database Solutions Architect

    6 days ago

    Chennai, Tamil Nadu, India Quantra Technology Solutions Full time

    OverviewWe are seeking a highly skilled Database Solutions Architect to join our team at Quantra Technology Solutions. This role plays a vital part in developing, testing, and maintaining databases for efficient data handling.Job DescriptionThe SQL Developer will ensure the stability, performance, and reliability of SQL databases while optimizing queries to...

  • Senior Oracle Database Architect

    6 days ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Job DescriptionWe are seeking a highly skilled Senior Oracle Database Architect to join our team at Virtusa.About the RoleThe ideal candidate will have extensive experience in Oracle PL/SQL development, with hands-on knowledge of UNIX and AutoSys. They will also be proficient in using Presto Tool for querying multiple databases and have expertise in...

  • Database Architect

    3 weeks ago

    Chennai, Tamil Nadu, India Twixor Full time

    Key Responsibilities:The ideal candidate will be responsible for creating, installing, and managing our databases at Twixor. To ensure optimal database performance, they will analyze database issues and monitor database performance.Key Responsibilities:• Manage database changes and re-designs• Analyze database issues and troubleshoot or configure the...

  • Database Architect

    3 weeks ago

    Chennai, Tamil Nadu, India Trane Technologies Full time

    Job SummaryThe Database Administrator will be responsible for managing and optimizing our database systems, with a special emphasis on migrating data to the cloud and supporting the existing database system. This includes designing, implementing, and maintaining database systems to ensure high performance, availability, and security. Key...

  • PostgreSQL Database Systems Architect

    3 days ago

    Chennai, Tamil Nadu, India Wipro Full time

    Job Overview We are seeking a skilled PostgreSQL Database Systems Architect to join our team at Wipro. As a key member of our database operations team, you will be responsible for providing technical expertise in architecture planning and design of our databases, as well as managing their day-to-day operations. Responsibilities The successful candidate will...

  • Database Architect and SQL Developer

    6 days ago

    Chennai, Tamil Nadu, India Gainwell Technologies Full time

    Job OverviewWe are seeking a highly skilled Database Architect and SQL Developer to join our team at Gainwell Technologies. As a key member of our data management team, you will be responsible for designing, developing, and maintaining complex databases that meet the needs of our clients.About the RoleIn this role, you will have the opportunity to work on a...