Senior Associate - Database development (PostgreSQL\PLSQL)

Responsibilities

• Build reusable code and libraries for future use.
• Writing reusable, testable, and efficient code
• Own & build new modules/features end-to-end independently.
• Collaborate with other team members and stakeholders.
• Work in an agile environment to rapidly build high-quality and robust features.
• Participate in DevOps.
• Implementation of security and data protection.

Required Skills

• Master in Node.js and frameworks available for it. (Nest.js / Loopback / AdonisJS)
• Excellent understanding of ES6 and OOP.
• Good understanding of SQL & No-SQL Databases. (MySQL / PostgreSQL)
• Understanding the nature of asynchronous programming and its quirks and workarounds.
• Open Source and DevOps enthusiast.
• Comfortable with Test Driven Development.
• Can learn and adapt fast, as well as identify and solve problems.

Bonus Skills

• Hands-on with TypeScript

Job Perks

• Get to work with a highly passionate team of engineers.
• Open and embracing culture towards the latest hot technologies.
• A high level of freedom & responsibility.

Title: Python Developer

Job Type: Full-time

Responsibilities:

• Developing and maintaining Python-based applications.
• Writing clean, maintainable, and efficient code.
• Integrating user-facing elements developed by front-end developers with server-side logic.
• Identifying and fixing bottlenecks and bugs.
• Participating in code reviews.
• Collaborating with cross-functional teams to design, develop and implement new features.

Requirements:

• Bachelor's or Master's degree in Computer Science or a related field.
• Strong proficiency in Python and its frameworks such as Django or Flask.
• Understanding of fundamental design principles behind a scalable application.
• Familiarity with code versioning tools such as Git.
• Knowledge of databases such as MySQL, PostgreSQL or MongoDB.
• Good problem-solving skills and attention to detail.
• Excellent communication and collaboration skills.

About Prêtture

We are India’s coolest SaaS ERP for Fashion, Lifestyle and Home Decor brands. Currently working across 100 brands like House of Masaba, Rahul Mishra, Raw Mango, Anamika Khanna and many others across India, helping them organise their end to end business workflow through our application.

We are currently working on new development and enhancement in the application and are hence looking forward to senior software developers.

The ideal candidate is a creative problem solver who understands the requirement and comes up with the solution keeping in mind the impact of the solution on existing code

Responsibilities

• Understand the problem statement and get the code done for the server side programming of our software including the database and other internal/external micro services communication
• Maintain the quality of code
• Impact analysis before actually writing any code
• Use the optimised SQL queries only

Qualifications

• At least 2-3 years' of experience using NodeJS and MySql/PostgreSQL (This is mandatory. Please do not apply in case of lesser experience in either NodeJS or MySQL/PostgreSQL)
• Bachelor's degree or equivalent experience in Computer Science

Office Location

 Navi Mumbai

Key Skills Required :

1. Proficiency in Python 3.x based web and backend development
2. Solid understanding of Python concepts
3. Strong experience in building web applications using Django
4. Experience building REST APIs using DRF or Flask
5. Experience with some form of Machine Learning (ML)
6. Experience in using libraries such as Numpy and Pandas
7. Hands on experience with RDBMS such as Postgres or MySQL including querying
8. Comfort with Git repositories, branching and deployment using Git
9. Working experience with Docker
10. Basic working knowledge of ReactJs
11. Experience in deploying Django applications to AWS,Digital Ocean or Heroku

Responsibilities :

1. Understanding requirement and congributing to engineering solutions at a conceptual stage to provide the best possible solution to the task/challenge
2. Building high quality code using coding standards based on the SRS/Documentation
3. Building component based, maintainable, scalable and reusable backend libraries/modules.
4. Building & documenting scalable APIs on the Open Spec standard
5. Unit testing development modules and APIs
6. Conducting code reviews to ensure that the highest quality standard are maintained
7. Securing backend applications and APIs using industry best practices
8. Troubleshooting issues and fixing bugs raised by the QA team efficiently.
9. Optimizing code
10. Building and deploying the applications

• Design, develop and manage data on various open-source SQL databases
• End-to-end performance tuning of Oracle, MariaDB, MySQL, PostgreSQL, and Aurora against very large data sets
• Database cluster connectivity and security
• Conduct database training
• Software installation and configuration
• Database patching and upgrading
• Using monitoring and management tools
• Troubleshoot various issues with other dba’s/developers
• Point of Contact for Vendor escalation
• Point of Contact for professional service to Customers
• Cross-platform migration from Oracle to MySQL/MariaDB/PostgreSQL/Aurora
• Support the creation, maintenance, and implementation of procedures regarding how problems are identified, received, documented, distributed, and corrected
• Ensures project documentation is complete, current, and stored appropriately
• Manages day-to-day project and scope changes
• Communicate and coordinate database changes, backups, and downtime to users
• Identifies potential security issues and recommend strategies to ensure database security
• Research and evaluate new technologies
• Proactively monitor systems for optimum performance and capacity constraints
• Establish standards and best practices for SQL
• Interact with and coach developers in SQL scripting
• Perform database backup and recovery
• Provides 24x7 support for enterprise database systems

• Must provide mentoring and training to other staff members
• Write procedural documentation including requirements for databases
• Develop and coordinate knowledge transfer
• Establishes enterprise-wide uniform infrastructure, including supporting defined departmental content processes and creating guidelines for content deployment
• Interacts with business units to gather, define, and organize the delivery of business solutions Data
• Modeling, design & implementation based on established standards
• Automate manual tasks

• Candidate with a college degree and relevant work experience
• 7+ years of hands-on DBA experience with Oracle, MySQL, MariaDB, and PostgreSQL and supporting tools
• Strong experience with Linux is required, including command-line editors, scripting (shell, Python, Perl, etc.)
• Experience in database performance tuning and strong SQL tuning skills
• Experience in database and cross-platform upgrades required Experience in all aspects of the software development lifecycle including requirements gathering, design, coding, testing and production support
• Must be familiar with RDBMS concepts, practices, and procedures
• Must have knowledge of network connectivity
• Extensive experience with Export/Import, Backup and Recovery
• Extensive experience with Database Replication Master/Slave, Master/Master (BDR)
• Extensive experience with MySQL (MariaDB, Percona) Galera cluster
• Experience with MaxScale
• Proficient in SQL Language
• Knowledge of ServiceNow, or similar Ticket Management Software
• Knowledge of SAN infrastructure including HP and NetApp
• Ability to work on projects at a time
• Knowledge of middle-tier application servers
• Strong troubleshooting and problem resolution skills
• Good knowledge of Data Modeling
• Knowledge of XML and JDBC

• Experience of NoSQL databases (Cassandra, Oracle NoSQL, MongoDB) is a plus
• Certifications on MySQL, PostgreSQL, and Aurora

Reporting and Business Intelligence

Minimum of 8 to 10 years of experience in Report building and Business Intelligence with

Profound knowledge on Oracle BI Publisher and BI Analytics with Oracle Fusion HCM domain especially in Core HR, Payroll and Absences modules

Primary skill:

• Experience generating BI publisher reports, dashboards and drill-down reports
• BI Publisher (RTF design/ eText/ Scheduling/ Parameter Handling/Bursting/backup and migration of reports to different pods)
• Design Oracle BI Publisher Data Models, Data sets and Templates/sub-templates
• Strong PL/SQL and Advanced PL/SQL experience
• Solid understanding of performance tuning best practices and experience improving end-to-end processing times
• Knowledge on the data models related to Fusion HCM (Core HR, Absence and Payroll modules)

Nice to have skills:

• Experience generating BI publisher reports, dashboards and drill-down reports
• Strong OBI Administrator activity
• Create mobile applications with Oracle Business Intelligence Mobile App Designer
• Use BI Mobile to access BI Content
• Create and modify Interactive Dashboards
• Knowledge of additional reporting tools viz. HCM Extract / OTBI / Analysis Dashboard would be an added advantage

Behavioural and Process Skills

• Experience working in Agile teams
• Self-motivated and self-directed abilities to prioritize and execute tasks in a high-pressure environment with "time-critical" deadlines
• Proven analytical, evaluative, and problem-solving abilities
• Possesses a team and customer service provision orientation