Senior Database Engineer(PostgreSQL)

1 month ago

Kochi, India Experion Technologies Full time

Senior Database Engineer(PostgreSQL)

JOB PURPOSE

Skills Mandate - PostgreSQL /Oracle ,AWS

An Oracle/PostgreSQL back-end Lead/Senior Developer is responsible for designing and managing
the Oracle/PostgreSQL database systems that form the foundation of an organization's data
infrastructure. To excel in this role, they need a robust set of technical skills. Here are the key
technical skills and knowledge areas that an Oracle back-end architect should possess:

• In-depth knowledge of Oracle/PostgreSQL Database architecture and components.
• Strong SQL and PL/SQL or PL/pgSQL programming skills for querying, data manipulation, and
stored procedure development.
• Proficiency in writing and maintaining PL/SQL or PL/pgSQL code, including procedures, functions,
packages, and triggers.
• Strong understanding of PL/SQL or PL/pgSQL syntax, data types, and control structures.
• Mastery of SQL for querying and manipulating data in Oracle databases.
• Knowledge of complex SQL queries, joins, and subqueries.
• Familiarity with database design principles and data modeling.
• Expertise in optimizing PL/SQL or PL/pgSQL code and SQL queries for performance.
• Knowledge of query optimization techniques, indexing, and execution plan analysis.
• Ability to work with database designers to implement efficient schema structures.
• Proficiency in data migration and ETL processes using Oracle tools like Oracle Data Pump and
Oracle Data Integrator (ODI).
• Familiarity with scripting languages (e.g., Shell, Python) for automating routine database tasks
and monitoring.
• Understanding of the operating systems that Oracle/PostgreSQL databases run on, such as Linux,
Unix, or Windows
• Mastery of Oracle Database tools like SQL*Plus, SQL Developer, and Oracle Enterprise Manager.
• Hands on Experience in Python is a plus
• Experience with AWS Cloud Infrastructure and or other cloud providers, specifically exposure in
AWS services (Lambda, Step functions, Kenesis, Kafka etc.)
• Familiarity with monitoring tools like Prometheus, Grafana, and pg_stat_statements.
• Effective communication skills for collaborating with cross-functional teams and conveying
technical concepts to non-technical stakeholders.
• Exposure in addressing with production issues in a timely manner with sound analytical and
problem-solving skills.
• Expertise in diagnosing and resolving complex database issues

Duties and responsibilities

Is responsible for designing, implementing, and managing Oracle/Postgres
database systems to ensure data integrity, availability, and performance. They collaborate with cross functional teams to understand business requirements and translate them into efficient database solutions.
This role involves strategic planning, architecture design, performance tuning, and database security
management.
? Collaborate with stakeholders to gather and analyze business requirements for database systems.
? Design and architect Oracle/PostgreSQL database solutions to meet scalability, security, and
performance needs.
? Define data models, schema structures, and database configurations.
? Create, modify, and manage database objects (tables, indexes, views, etc.).
? Perform data migration, data transformation, and data loading task.
? Monitor database performance and identify and resolve bottlenecks.
? Optimize SQL queries and database queries for improved efficiency.
? Implement indexing and partitioning strategies to enhance performance.
? generate documentation showcasing the team's capabilities in winning new
opportunities.
? To adhere to the Information Security Management policies and procedures

  • Database Administrator

    6 months ago

    Kochi, Kerala, India HQ Account LLC Full time

    **Job Summary**: - The Database Administrator oversees storing, organizing, presenting, using and analyzing data and database management software. Whatever the information storage needs of the company are, the Database Administrator strives to meet them, this can include setting up new databases. Regularly performs routine tests and modifications to ensure...

  • Database Administrator

    6 months ago

    Kochi, India ChiSquarelabs Full time

    **Engineer (DBA - Postgres/MongoDB)** - Full-time **About this Job**: We’re looking for a database administrator.The individual in this role will be responsible for design, implementation and administration for our databases, as well as mentoring of lower level database administrators. **Rationale**: **Responsibilities**: - Provide support for,...

  • Senior Software Engineer- Node.js

    3 weeks ago

    Kochi, India InApp Information Technologies India Pvt Ltd Full time

    Senior Software Engineer- Node.js Senior Software Engineer/Team Lead - Node.js Experience - 5-7 years Responsibilities: - Architect and develop backend applications. - Write scalable, maintainable, and testable code. - Participate in code reviews and design discussions. - Develop and manage REST APIs with a focus on design and architecture. -...

  • Database Developer

    3 months ago

    Kochi, India Expeed Software Private Limited Full time

    Database Developer Responsibilities: Manage, monitor, and maintain database systems (SQL Server). Optimize database performance, ensuring fast query responses and efficient data retrieval. Implement and oversee data security measures, including backups and disaster recovery. Design and develop database schemas, indexes, and queries. Monitor and...

  • Senior Data Engineer

    1 week ago

    Kochi, India Recro Full time

    Title: Senior Data Engineer Skills: Python, PySpark, Azure, SQL, GithubDomain : Pharmacy solutions, clinical care services.Data Engineering project which needs to source data from multiple sources(Batch sources primarily, streaming sources is something that is good to have) to transform load into Data Lake. The client wants to use open stack technologies...

  • Senior Data Engineer

    1 week ago

    Kochi, India Recro Full time

    Title: Senior Data EngineerSkills: Python, PySpark, Azure, SQL, GithubDomain : Pharmacy solutions, clinical care services.Data Engineering project which needs to source data from multiple sources(Batch sources primarily, streaming sources is something that is good to have) to transform load into Data Lake. The client wants to use open stack technologies...

  • Database Administrator

    4 weeks ago

    Kochi, Kerala, India Applogiq Full time

    **Job title**: Data Base Administrator (DBA) **Location **:Trissur - 5+ years of proven experience in database administration. - Proficiency in managing relational databases such as **MySQL, PostgreSQL, Oracle, SQL Server**, or similar. - Experience with NoSQL databases like **MongoDB, Cassandra, or DynamoDB**. - Expertise in database scripting and...

  • Senior Data Engineer

    2 weeks ago

    Kochi, India Recro Full time

    Title: Senior Data EngineerSkills: Python, PySpark, Azure, SQL, GithubDomain : Pharmacy solutions, clinical care services.Data Engineering project which needs to source data from multiple sources(Batch sources primarily, streaming sources is something that is good to have) to transform load into Data Lake. The client wants to use open stack technologies...

  • Senior Data Engineer

    1 week ago

    Kochi, India Recro Full time

    Title: Senior Data EngineerSkills: Python, PySpark, Azure, SQL, GithubDomain : Pharmacy solutions, clinical care services.Data Engineering project which needs to source data from multiple sources(Batch sources primarily, streaming sources is something that is good to have) to transform load into Data Lake. The client wants to use open stack technologies...

  • Senior Data Engineer

    1 week ago

    Kochi, India Recro Full time

    Title: Senior Data Engineer Skills: Python, PySpark, Azure, SQL, Github Domain : Pharmacy solutions, clinical care services. Data Engineering project which needs to source data from multiple sources(Batch sources primarily, streaming sources is something that is good to have) to transform load into Data Lake. The client wants to use open stack technologies...

  • Program Manager

    2 weeks ago

    Kochi, India Experion Technologies Full time

    Career Opportunities: Senior Database Engineer(PostgreSQL) JOB PURPOSE Skills Mandate - PostgreSQL /Oracle ,AWS An Oracle/PostgreSQL back-end Lead/Senior Developer is responsible for designing and managing the Oracle/PostgreSQL database systems that form the foundation of an organization's data infrastructure. To excel in this role, they need...

  • Recro | Senior Data Engineer | kochi

    1 week ago

    kochi, India Recro Full time

    Title: Senior Data EngineerSkills: Python, PySpark, Azure, SQL, GithubDomain : Pharmacy solutions, clinical care services.Data Engineering project which needs to source data from multiple sources(Batch sources primarily, streaming sources is something that is good to have) to transform load into Data Lake. The client wants to use open stack technologies...

  • Recro | Senior Data Engineer | kochi

    1 week ago

    Kochi, India Recro Full time

    Title: Senior Data EngineerSkills: Python, PySpark, Azure, SQL, GithubDomain : Pharmacy solutions, clinical care services.Data Engineering project which needs to source data from multiple sources(Batch sources primarily, streaming sources is something that is good to have) to transform load into Data Lake. The client wants to use open stack technologies...

  • Recro | Senior Data Engineer | kochi

    1 week ago

    kochi, India Recro Full time

    Title: Senior Data Engineer Skills: Python, PySpark, Azure, SQL, Github Domain : Pharmacy solutions, clinical care services. Data Engineering project which needs to source data from multiple sources(Batch sources primarily, streaming sources is something that is good to have) to transform load into Data Lake. The client wants to use open stack technologies...

  • Recro | Senior Data Engineer | kochi

    1 week ago

    kochi, India Recro Full time

    Title: Senior Data EngineerSkills: Python, PySpark, Azure, SQL, GithubDomain : Pharmacy solutions, clinical care services.Data Engineering project which needs to source data from multiple sources(Batch sources primarily, streaming sources is something that is good to have) to transform load into Data Lake. The client wants to use open stack technologies...

  • Senior Python Developer

    4 weeks ago

    Kochi, India Art Technology and Software. Full time

    Senior Python Developer Position: Senior Python Developer Experience: 5+ years Location: Kochi (Work From Office - WFO) Immediate joiners preferred We are looking for an experienced Senior Python Developer to join our team and contribute to the development of a fintech application for our client. The ideal candidate will have significant hands-on...

  • Senior Python Developer

    13 hours ago

    Kochi, India Art Technology and Software Full time

    Position: Senior Python DeveloperExperience: 5+ yearsLocation: Kochi (Work From Office - WFO) Immediate joiners preferred We are looking for an experienced Senior Python Developer to join our team and contribute to the development of a fintech application for our client. The ideal candidate will have significant hands-on experience in Python development, a...

  • Senior Python Developer

    1 day ago

    Kochi, India Art Technology and Software Full time

    Position: Senior Python Developer Experience: 5+ years Location: Kochi (Work From Office - WFO) Immediate joiners preferred We are looking for an experienced Senior Python Developer to join our team and contribute to the development of a fintech application for our client. The ideal candidate will have significant hands-on experience in Python development,...

  • Database Architect

    6 months ago

    Kochi, India Beacon Maven Full time

    **What this role entail** - Analyse, Create and Own the database design and architecture requirements for the complex distributed systems - Design the databases for the microservices with well-defined bounded context and interaction with other services - Develop, and maintain high performance data-driven architectures - Align architecture with business...

  • Senior Systems Engineer

    2 months ago

    Kochi, India VIPoint Solutions Pvt Ltd Full time

    Senior Systems Engineer Qualifications and skills required: Graduate in any discipline with certifications preferred (Red Hat Linux Certified) Profiles having 5 plus years of Linux experience in IT industry. Hands on experience on Linux Administration / Troubleshooting / Security. In depth knowledge in the Linux operating system- Centos Control...