Database Specialist

5 months ago


Bengaluru, India Brillio Full time

About Brillio:

Born digital in 2014, Brillio is a powerhouse of digital transformations. Orchestrated around the superpowers of technology – Cloud, AI, Mobile, IoT, we are a partner of choice for leading companies around the world, helping them leverage digital technologies. We’re present in 15 locations across 6 countries – USA, Canada, Mexico, UK, Romania, and India. In a short span of 9 years, we have grown into a family of 6500+ people globally. We are proud of our award-winning employee centric culture and empower our employees by creating a diverse & inclusive workplace.


Job Description:

We are seeking a skilled and experienced Database Migration Specialist to join our team for a critical project involving the migration of databases from DB2 to PostgreSQL. As a Database Migration Specialist, you will play a key role in planning, executing, and overseeing the migration process while ensuring minimal disruption to business operations and maximum data integrity. You will collaborate closely with cross-functional teams including database administrators, developers, and system architects to ensure a smooth and successful migration.

Responsibilities:

  1. Migration Planning: Develop comprehensive migration plans outlining the migration strategy, timelines, resources required, and potential risks.
  2. Database Assessment: Conduct thorough assessments of existing DB2 databases to identify dependencies, performance bottlenecks, and potential compatibility issues with PostgreSQL.
  3. Schema Conversion: Analyze and convert DB2 database schemas to PostgreSQL-compatible formats, ensuring data integrity and optimal performance.
  4. Data Migration: Design and implement data migration strategies to transfer data from DB2 to PostgreSQL while minimizing downtime and ensuring data consistency.
  5. Query Optimization: Optimize SQL queries and database configurations to maximize performance and scalability on the PostgreSQL platform.
  6. Testing and Validation: Develop and execute comprehensive test plans to validate the accuracy, completeness, and performance of migrated databases.
  7. Documentation: Create detailed documentation of migration processes, procedures, and best practices for future reference.
  8. Training and Support: Provide training and support to internal teams on PostgreSQL database management, optimization, and troubleshooting.
  9. Continuous Improvement: Stay updated on the latest trends, technologies, and best practices in database migration and actively contribute to process improvements.

Requirements:

  1. Bachelor's degree in Computer Science, Information Technology, or a related field. Master’s degree preferred.
  2. Proven experience in database migration projects, particularly from DB2 to PostgreSQL, with a minimum of 5 years of relevant experience.
  3. In-depth knowledge of relational database concepts, SQL, and database design principles.
  4. Strong proficiency in both DB2 and PostgreSQL database administration, including performance tuning, backup and recovery, and security management.
  5. Experience with database migration tools such as IBM Data Movement Tool, AWS Database Migration Service, or similar.
  6. Excellent analytical and problem-solving skills with a keen attention to detail.
  7. Effective communication and collaboration skills with the ability to work across functional teams and stakeholders.
  8. Certification in DB2 and PostgreSQL administration is a plus.
  9. Experience with cloud platforms (AWS, Azure, GCP) and containerization technologies (Docker, Kubernetes) is desirable.
  10. Ability to work independently and manage multiple priorities in a fast-paced environment.


If you are passionate about database technologies and possess the skills and experience required to lead successful migration projects, we encourage you to apply for this exciting opportunity to join our team.


  • Database Specialist

    4 weeks ago


    Bengaluru, Karnataka, India Bosch Full time

    Job DescriptionKey Responsibilities:We are seeking a highly skilled Database Specialist to join our team at Bosch. The ideal candidate will have a strong background in database administration, with experience in MySQL, Oracle, PostgreSQL, and MSSQL.Key Skills:The successful candidate will possess excellent problem-solving skills, with the ability to work in...

  • Database Specialist

    7 days ago


    Bengaluru, Karnataka, India SAP Full time

    Key Role Responsibilities:You will be responsible for key database deliverables and drive escalations as a technical specialist in the area of performance and troubleshooting of SAP HANA. Your role will be SAP HANA/MSSQL senior specialist, responsible for strategic customer contact from a technical standpoint for SAP HANA/MSSQL. You will need to collaborate...


  • Bengaluru, Karnataka, India Vyana Consultancy Full time

    Job Title: Cloud Database SpecialistJob Summary:Vyana Consultancy is seeking a skilled Cloud Database Specialist to join our team. As a Cloud Database Specialist, you will be responsible for designing, developing, and implementing databases in AWS, ensuring high performance, security, and scalability.Key Responsibilities:Design and develop databases in AWS,...


  • Bengaluru, Karnataka, India Idexcel Full time

    Job Requirements:We are seeking a highly skilled Database Systems Specialist to join our team at Idexcel. The ideal candidate will have a minimum of 4 years of hands-on experience in MySQL/PostgreSQL and a strong understanding of Unix.The successful candidate will also have good knowledge of script languages like Python and experience in BI development and...


  • Bengaluru, Karnataka, India SAP Full time

    Database Operations Role Summary We are seeking a skilled Senior Database Specialist to join our team in Global Database operations. This role will be responsible for key database deliverables and driving escalations as a technical specialist in the area of performance and troubleshooting of SAP HANA. As a SAP HANA/MSSQL senior specialist, you will be...

  • Database Specialist

    2 weeks ago


    Bengaluru, Karnataka, India Telescopp Full time

    Database AdministrationAt Telescopp, we are seeking a skilled Database Administration Specialist to join our team. The ideal candidate will have a strong understanding of database concepts and architecture, with experience in designing, implementing, and maintaining database systems to meet business needs.Key Responsibilities:Design and implement database...


  • Bengaluru, Karnataka, India Société Générale Assurances Full time

    Job Title: Senior Database SpecialistAt Société Générale Assurances, we are seeking a highly skilled Senior Database Specialist to join our GTS/PAS/DRE Team.Responsibilities:Lead database performance analysis and tuningExpert in Oracle DG, RAC, and ASMDeep knowledge of Oracle database architectureExpert problem identification and trouble shooting...


  • Bengaluru, Karnataka, India Vyana Consultancy Full time

    Database ExpertiseAt Vyana Consultancy, we are seeking a skilled AWS Database Specialist to join our team. The ideal candidate will have in-depth knowledge of AWS DB services, including Amazon RDS, Dynamo DB, and Redshift. Key responsibilities include designing and implementing databases in AWS, monitoring database performance, and troubleshooting issues....

  • Database specialist

    7 days ago


    Bengaluru, India Brillio Full time

    About Brillio:Born digital in 2014, Brillio is a powerhouse of digital transformations. Orchestrated around the superpowers of technology – Cloud, AI, Mobile, Io T, we are a partner of choice for leading companies around the world, helping them leverage digital technologies. We’re present in 15 locations across 6 countries – USA, Canada, Mexico, UK,...


  • Bengaluru, Karnataka, India Innovate Solutions Full time

    We are seeking a talented Database Development Specialist to join our team at Innovate Solutions.This is a remote position that involves designing, developing, and maintaining databases, as well as implementing and optimizing SQL queries. As a Database Development Specialist, you will play a crucial role in ensuring the efficient management and utilization...


  • Bengaluru, Karnataka, India Verint Full time

    Job Title: Database Systems SpecialistWe are seeking a Database Systems Specialist to join our team at Verint. The ideal candidate will have a strong background in database administration and a passion for delivering high-quality solutions.Key Responsibilities:Administer, optimize, and maintain MSSQL databases for optimal performance and data...


  • Bengaluru, Karnataka, India ScaleneWorks Full time

    Database Administration ExpertDatabase Design and AdministrationWe are seeking an experienced Database Systems Specialist to administer and manage our Oracle 12c and 19c databases. The ideal candidate will have expertise in Database design, configuration, migration, and administration, including experience with RAC, Data guard, and RMAN.Key...


  • Bengaluru, Karnataka, India ICC Staffing Services Private Limited Full time

    Job Title: Neo4j Database SpecialistJob Summary:We are seeking a skilled Neo4j Database Specialist to join our team at ICC Staffing Services Private Limited. As a Neo4j Database Specialist, you will be responsible for designing and implementing graph database models in Neo4j based on application and analytics requirements.Key Responsibilities:Design and...


  • Bengaluru, Karnataka, India Oracle Full time

    Job Title: Devops Database SpecialistKey Responsibilities:As a Devops Database Specialist, you will be responsible for defining and deploying autonomous database services with a deep focus on architecture, production operations, capacity planning, performance management, deployment, and release engineering.Key Skills:We are looking for candidates with strong...


  • Bengaluru, Karnataka, India Innovate Solutions Full time

    Database Development SpecialistInnovate Solutions is seeking a highly skilled Database Development Specialist to join our team. As a key member of our database team, you will be responsible for designing, developing, and maintaining complex SQL queries and stored procedures.The ideal candidate will have a strong understanding of relational database...


  • Bengaluru, Karnataka, India SAP Full time

    We're seeking a seasoned database professional to drive global database operations and be a technical specialist in SAP HANA and MSSQL. As a key member of our team, you will be responsible for delivering critical database solutions and collaborating closely with our problem management, incident management, and technical architecture teams to ensure...


  • Bengaluru, Karnataka, India Brillio Full time

    About Brillio: We are a powerhouse of digital transformations, born digital in 2014. Our superpowers include Cloud, AI, Mobile, and IoT. We are a partner of choice for leading companies worldwide, helping them leverage digital technologies. We have 15 locations across 6 countries – USA, Canada, Mexico, UK, Romania, and India. Our award-winning...


  • Bengaluru, Karnataka, India Société Générale Assurances Full time

    Database Systems SpecialistWe are seeking a highly skilled Database Systems Specialist to join our team at Société Générale Assurances. As a key member of our GTS/PAS/DRE Team, you will be responsible for providing 24/7 production database support to our customers across the SG group.Key Responsibilities:Database performance analysis and tuningExpert in...


  • Bengaluru, Karnataka, India SAP Full time

    Drive Innovation in Database OperationsWe're seeking a skilled Database Systems Specialist to join our team, where you'll play a key role in driving innovation in database operations. As a technical specialist in SAP HANA and MSSQL, you'll be responsible for key database deliverables and will drive escalations to closure by engaging with different...

  • Database Specialist

    2 weeks ago


    Bengaluru, Karnataka, India SLK Full time

    Database Design and ImplementationAs a Database Specialist at SLK Software Private Limited, you will collaborate with application developers to design and optimize DB2 databases that meet application requirements within the z/OS environment. Your expertise in database implementation will involve installing, configuring, and setting up DB2 database instances...