PostgreSQL Jobs in Ahmedabad
DRF
● Able to integrate multiple data sources and databases like Postgres, MySQL,
mongodb, elasticsearch, cloud datastore, dynamodb.
● Understanding of the threading limitations of Python, and multi-process,
micro service architecture
● Good understanding of server-side templating languages like Jinja 2
● Basic understanding of front-end technologies, such as Angular, React,
JavaScript, HTML5, and CSS3
● Understanding of accessibility and security compliance depending on the
specific project
● Knowledge of user authentication and authorization between multiple
systems, servers, and environments
● Understanding of fundamental design principles behind a scalable
application
● Familiarity with event-driven programming in Python
● Understanding of the differences between multiple delivery platforms, such
as mobile vs desktop, and optimizing output to match the specific platform
● Understanding of cloud platform services like Google Cloud, AWS with
dockerized systems.
● Able to create database schemas that represent and support business
processes
● Strong unit test and debugging skills
● Proficient understanding of code versioning tools such as Git
.
Responsibilities:
• Make decisions and resolve issues regarding objectives and operations of the fleet assets
in the database management area to meet business objectives.
• Prepare reports on database scalability and capacity planning as needed.
• Lead team to achieve objectives.
• Interpret and develop policies and procedures for functions with low to moderate complexity within scope of responsibility.
• Mentor and guide talent development of direct reports and assist in hiring talent.
• Work closely with the product development team from the design phase of application & throughout their Agile development journey, the future enhancements & releases
• Participate in the application stress/load test & proactively identify & resolve the DB performance (batch/OLTP) issues that can potentially breach the SLA’s when the code
moves to production
• Highlight the new DB features to the product teams that could be used in the application as future enhancements & releases
• Support the Database Migration, Upgrades as part of Technology Life Cycle Management to be compliant with organization standards
• Provide DB Capacity Analysis & provide insights to product teams on future storage & hardware requirements based on the current data growth & overall performance
• Identify aging data, propose/develop/implement data archiving, purging & partitioning solutions to manage the data growth
• Handling Database/Schema Refreshes for the lower database environments
• Understand the RTO/RPO requirements for the application & databases to define the database backup and restore policy
• Managing Database Security Audit violations & resolving them
• DB User/Access/Roles management
• Troubleshooting & fixing production DB/SQL performance issues
• Providing Oncall support, working with vendor on DB issues, bugs & provide solution
• Schedule and Co-ordinate various maintenance activities with Support teams.
• Collaborate and influence all levels of professionals including more experienced
managers.
• Work on any new DB technology/new-features, POC requirements from application team
• Help the application team in migrating their databases to public cloud (AWS).
• Establish performance standards, evaluate performance, train, and mentor team.
• Evaluate the database configuration and processes according to established policies and procedures of the organization.
• Identify and recommend opportunities for process improvement and risk control development.
Required Qualifications:
• 6+ years of DBA experience on SQL or NoSQL DB with performance Tuning
• 4+ years of experience in managing other databases like MS SQL Server, MySQL, PostgresDB & RDS on AWS.
• Hands on experience with NoSQL/Document databases and their administration.
• Experience on automation using any programming or scripting language.
• Should have at least one RDBMS certification.
• Hands on experience with Always on and High availability DBs.
• Hands on with SQL and NoSQL Database.
• Excellent understanding of the MongoDB installation, configuration, maintenance, security and audit logging.
• Experience with performance tuning and managing 1TB of Data
• Experience in backup/recovery procedures.
• Good understanding on Access Methods, Joins, different Indexes & its usage, Index scans, interpreting EXECUTION PLANS, Table/Index Statistics, Histograms, wait events etc
• Strong on PL/SQL Programming.
• Excellent communication skills
• Excellent verbal and written communication skills.
• Excellent interpersonal and customer service skills.
• Problem-solving and good analytical skills
• Communication, teamwork and negotiation skills
• Ability to work in tight deadlines under pressure
• Flexible and adaptable to changing business/technology requirements
• A sense of ownership that drives quality in everything you do
• A forward-looking attitude that keeps you aware of the latest in database & cloud technology space.
Preferred Qualifications:
• AWS/Azure/OCI cloud Certified
• Working experience on Snowflake Cloud Datawarehouse DB
• Python Programming for Automation for building dashboards
• Basic knowledge on Tableau/PowerBI for reporting.
Education:
• Finished Bachelors or Masters in Software Engineering.
• Preferred: BE/ B. Tech. / MCA / MSc. / BSc
- 3+ years of Experience majoring in applying AI/ML/ NLP / deep learning / data-driven statistical analysis & modelling solutions.
- Programming skills in Python, knowledge in Statistics.
- Hands-on experience developing supervised and unsupervised machine learning algorithms (regression, decision trees/random forest, neural networks, feature selection/reduction, clustering, parameter tuning, etc.). Familiarity with reinforcement learning is highly desirable.
- Experience in the financial domain and familiarity with financial models are highly desirable.
- Experience in image processing and computer vision.
- Experience working with building data pipelines.
- Good understanding of Data preparation, Model planning, Model training, Model validation, Model deployment and performance tuning.
- Should have hands on experience with some of these methods: Regression, Decision Trees,CART, Random Forest, Boosting, Evolutionary Programming, Neural Networks, Support Vector Machines, Ensemble Methods, Association Rules, Principal Component Analysis, Clustering, ArtificiAl Intelligence
- Should have experience in using larger data sets using Postgres Database.
About the Job:-
We are looking for a skilled and innovative - Backend Engineer to join our growing company. As a Backend Engineer, you’ll work closely with our engineers to build backend for production-level enterprise products.
If you have excellent programming skills, a passion to learn trending tech stack, and work with growing company with an entrepreneurial mindset, we would like to meet you.
Job Type - Full time (Remote work)
Responsibilities:-
- Communicating with clients for day to day activity
- Gather and understand the technical requirement of the client
- Coordinating with Frontend and DevOps engineers
- Produce clean, efficient, and reusable code based on specifications
- Implementing 3rd party library
- Troubleshoot and debug applications
- Follow emerging technologies
Requirements:-
Must-Have:
- Node.js, Express.js
- Database: Postgress or MySQL
- Any ORM Framework (Sequelize or Typeform)
- Excellent communication and interpersonal skills
- Excellent analytical and time management skills
- Teamwork skills with a problem-solving attitude
Good to have:
- NestJs
- Typescript
- DevOps Practice over AWS or GCP
- OOPs concept
- Microservices
- RabbitMQ
Benefits:
- Positive work environment
- Remote work option
- Encourage and sponsor for learning and development programs
- Chance to work with advanced technology
- Opportunity to reveal a hidden talent
Responsibilities:
- Ability to work in an existing codebase and collaborate with a diverse team
- Experience in building enterprise-scale backend REST APIs with frameworks such as Nest.js & Express.js using an API-first paradigm
- Intimate knowledge of crafting highly performing database queries
- Hands-on experience implementing relational database structures, including tables, indexes, views, etc.
- A mindset towards building systems for the cloud and DevOps fundamentals
- Working knowledge of cloud infrastructure services is good to have. If not then willingness to learn should be there.
- Focus towards building security, performance, and scalability into services from the beginning
- Experience with debugging code and troubleshooting technical issues in order to craft appropriate solutions
Job description
Our client is a specialty pharmacy service business model that enables essential interactions between patients, prescribers, payors, and pharma on behalf of independent retail pharmacies (IRPs).
Do not apply if: • Not having Experience in JAVA, PostgreSQL, Angular
Position Summary: Software Engineer Full Stack Software Engineer will be a part of the core development team working closely with various stakeholders to implement functionality, to our business success. This role will drive excellence through the design, development, deployment, and maintenance of complex software applications by leveraging agile software development practices. Software Engineer will work with Java/Spring technologies to build scalable applications with great user experience.
Technical Skills: • Experience with Core Java, J2EE, Spring, Hibernate, HTML/HTML5, JavaScript, Jquery,Web Services, Micro services. • Understand and use Messaging Based Servicestechniques. • Working knowledge with PostgreSQL or similar SQLDatabases. • Working knowledge with AngularJS. • Strong knowledge in Object Oriented Concepts with Core Java. • Good understanding and practical experience with Enterprise Java Concepts and Methodologies. • Good understanding of software development process in an agile environment. • Excellent problem solving and troubleshooting skills. • Solid coding practices including documentation, code reviews and unittesting. • Knowledge of MongoDB and Junit will be an addedadvantage. • Experience with AWS infrastructure, e.g. S3, EC2, database services(RDS) will be an added advantage. • Contribute to Production Support and debugging across the platform while working with other software engineers. • Strong experience with Application server development - Service layer patterns using Spring.
Thanks
Anamika
Job Description
Mandatory Requirements
-
Experience in AWS Glue
-
Experience in Apache Parquet
-
Proficient in AWS S3 and data lake
-
Knowledge of Snowflake
-
Understanding of file-based ingestion best practices.
-
Scripting language - Python & pyspark
CORE RESPONSIBILITIES
-
Create and manage cloud resources in AWS
-
Data ingestion from different data sources which exposes data using different technologies, such as: RDBMS, flat files, Streams, and Time series data based on various proprietary systems. Implement data ingestion and processing with the help of Big Data technologies
-
Data processing/transformation using various technologies such as Spark and Cloud Services. You will need to understand your part of business logic and implement it using the language supported by the base data platform
-
Develop automated data quality check to make sure right data enters the platform and verifying the results of the calculations
-
Develop an infrastructure to collect, transform, combine and publish/distribute customer data.
-
Define process improvement opportunities to optimize data collection, insights and displays.
-
Ensure data and results are accessible, scalable, efficient, accurate, complete and flexible
-
Identify and interpret trends and patterns from complex data sets
-
Construct a framework utilizing data visualization tools and techniques to present consolidated analytical and actionable results to relevant stakeholders.
-
Key participant in regular Scrum ceremonies with the agile teams
-
Proficient at developing queries, writing reports and presenting findings
-
Mentor junior members and bring best industry practices.
QUALIFICATIONS
-
5-7+ years’ experience as data engineer in consumer finance or equivalent industry (consumer loans, collections, servicing, optional product, and insurance sales)
-
Strong background in math, statistics, computer science, data science or related discipline
-
Advanced knowledge one of language: Java, Scala, Python, C#
-
Production experience with: HDFS, YARN, Hive, Spark, Kafka, Oozie / Airflow, Amazon Web Services (AWS), Docker / Kubernetes, Snowflake
-
Proficient with
-
Data mining/programming tools (e.g. SAS, SQL, R, Python)
-
Database technologies (e.g. PostgreSQL, Redshift, Snowflake. and Greenplum)
-
Data visualization (e.g. Tableau, Looker, MicroStrategy)
-
Comfortable learning about and deploying new technologies and tools.
-
Organizational skills and the ability to handle multiple projects and priorities simultaneously and meet established deadlines.
-
Good written and oral communication skills and ability to present results to non-technical audiences
-
Knowledge of business intelligence and analytical tools, technologies and techniques.
Familiarity and experience in the following is a plus:
-
AWS certification
-
Spark Streaming
-
Kafka Streaming / Kafka Connect
-
ELK Stack
-
Cassandra / MongoDB
-
CI/CD: Jenkins, GitLab, Jira, Confluence other related tools
Responsibilities:
- Ability to work in an existing codebase and collaborate with a diverse team
- Experience in building enterprise-scale backend REST APIs with frameworks such as Nest.js & Express.js using an API-first paradigm
- Intimate knowledge of crafting highly performant database queries
- Hands-on experience implementing relational database structures, including tables, indexes, views, etc.
- A mindset towards building systems for the cloud and DevOps fundamentals
- Working knowledge of cloud infrastructure services is good to have. If not then willingness to learn should be there.
- Focus towards building security, performance, and scalability into services from the beginning
- Experience with debugging code and troubleshooting technical issues in order to craft appropriate solutions
Responsibilities
- Design and develop REST-based web services utilizing Java micro services web frameworks (Spring Boot)
- Apply design principles and patterns in creating enterprise level solutions, as needed
- Perform web services tuning and performance testing
- Implement unit tests as needed
- Support front-end developers in leveraging web services
- Automate/script common developer tasks, continually optimize personal and team workflows
- Infrastructure setup and configuration
- Engage in code review and feedback process
- Take a feature from inception to completion independently across the stack
- Collaborate with teammates on proposed UX/UI and provide feedback as needed
- Participate in and support the entire SDLC processes
Requirements
- Spring Boot, Spring Security, Spring JPA & Hibernate
- Relational data modelling concepts and experience in PostgreSQL, MySQL, or similar
- Adopted opinionated RESTful web services design patterns
- Microservices-based application architecture
- Application containerization technologies, including Docker, Kubernetes, and cloud-vendor implementations (AWS, Azure, other)
- Other modern technologies relevant to the technology stack defined here
- Javascript ES6 or later
- React
- Git
1. Communicate with the clients and understand their business requirements.
2. Build, train, and manage your own team of junior data engineers.
3. Assemble large, complex data sets that meet the client’s business requirements.
4. Identify, design and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
5. Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources, including the cloud.
6. Assist clients with data-related technical issues and support their data infrastructure requirements.
7. Work with data scientists and analytics experts to strive for greater functionality.
Skills required: (experience with at least most of these)
1. Experience with Big Data tools-Hadoop, Spark, Apache Beam, Kafka etc.
2. Experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc.
3. Experience in ETL and Data Warehousing.
4. Experience and firm understanding of relational and non-relational databases like MySQL, MS SQL Server, Postgres, MongoDB, Cassandra etc.
5. Experience with cloud platforms like AWS, GCP and Azure.
6. Experience with workflow management using tools like Apache Airflow.
We are looking for developers who are passionate about Python and know what are the benefits of python well.
Responsibilities:
- Design & implement new software modules based on the product requirements
- Debug existing software components, fix issues, and avoid regressions
- Be proactive, take ownership, and be accountable
- Familiar with Test Drive Development.
- Participate in software architecture, design discussions, and code reviews
Technologies we’re hiring for:
- Developed HTTP based REST APIs and implemented Authentication, Caching
- Worked with relational and NoSQL databases and aware of concepts like ORM, Migrations
- Languages & Frameworks: Python Django/Flask
- Database: Postgres/ Mongo
- Must have worked in a Unix/Linux based environment
- Advanced middleware like RabbitMQ, Celery Beat is definitely a plus.
Minimum 3+ year hands-on experience in Python needed
What do we do?
About MobileFirst: Mobile design & development studio focusing on great mobile app experiences. We have great exposure working with Startups, Enterprises and Design Studios. MobileFirst has worked with customers from the USA, India, UK, Kenya, and Israel.
We have catered to clients in Automobiles, Paints, Fashion, Sports, Transportation, Food, Music, Coupons, Smart Parking, Uber for X, etc.
What are we looking for?
- 1+ yr experience with React JS & React Web UI
- MEAN Stack or MERN Stack Experience is required
- MongoDB, Express JS, Angular JS & NodeJS
- Understanding of React & Redux is required
- Experience with MongoDB, Postgresql, MySQL database
- Comfortable in a work environment that requires strong problem-solving skills and independent self-direction coupled with team collaboration and open communication
- Understanding of RESTful web services
- Work in a fast-paced, creative atmosphere to develop new ideas that adapt to evolving user needs
- Experience using Git / GitHub
What should you have?
- Amazing debugging skills and problem-solving abilities
- Knowledge of Opensource Libraries & frameworks
- Command over algorithms, design trends & knowledge about popular applications on App
Who are we looking for?
Tech Savvy. Fast learner. Leader.
We don't see your college degree or we don't care if you are a dropout.
Job Perks
- Great Fun Learning exposure
- Training and Seminars on new Technologies
- Startup Experience
- Flexible timings and "work from home" options
Your primary focus will be the development of all server-side logic, definition and maintenance of the central database, and ensuring high performance and responsiveness to requests from the front-end. You will also be responsible for integrating the front-end elements built by your co-workers into the application. Therefore, a basic understanding of front-end technologies is necessary as well.
Responsibilities
- Integration of user-facing elements developed by front-end developers with server side logic
- Writing reusable, testable, and efficient code
- Design and implementation of low-latency, high-availability, and performant applications
- Implementation of security and data protection
Skills And Qualifications
- Strong proficiency with JavaScript & OOPS
- Knowledge of Node.js and frameworks available for it
- Understanding the nature of asynchronous programming and its quirks and workarounds
- Good understanding of server-side CSS preprocessors
- Basic understanding of front-end technologies, such as HTML5, and CSS3
- Understanding accessibility and security compliance
- User authentication and authorization between multiple systems, servers, and environments
- Creating database schemas that represent and support business processes
- Implementing automated testing platforms and unit tests
- Proficient understanding of code versioning tools, such as Git
- Knowledge of AWS will be preferable