PostgreSQL Database Administrator

Job Description   - Omniflow and Java Developer

Should have working experience between 6-8 years in Java development

Mandatory skills are good knowledge of object oriented concepts, experience of working on Spring boot application, should have worked on hibernate ORMS and candidate must have clear understanding of database concepts

Optional skills include knowledge of angular framework and postgreSQL database

Good to have knowledge of jBPM open source workflow

Qualifications

Master or Bachelor degree in Engineering/Computer Science /Information Technology

Additional Information

Skills and Competencies:
Strong documentation skills
Excellent communication skills, both written and verbal
Decision making and problem solving skills
Good organizational skills        

Job Description: Backend Developer – Design Qandy

Who are we?

Design Qandy delivers personalised luxury interior design to India’s discerning homeowners and corporates. Led by highly admired luxury brand builders, internationally trained designers, world-class technology professionals and curated teams of turnkey project execution specailists. We seek perfection in design and are committed to bringing back trust and excitement in the design process.

Know more about us on designqandy.com and https://instagram.com/designqandy?igshid=YmMyMTA2M2Y=

Our work culture?

We are a lean team of high performing go-getters, we take ownership in our roles and lead with knowledge. Debates and discussions are an important part of our culture and we encourage people to bring unique perspectives to their conversations. Most importantly, we love solving problems.

Each day is inspiring and we encourage you to apply for this role and experience it for yourself.

What would you be required to do?

·      Write code and tests, build prototypes, solve issues, profile, and analyze bottlenecks

·      Design performance gauging, building robust APIs to support mobile and desktop clients

·      Manage and optimize scalable distributed systems on the cloud

·      Optimization of web applications for performance and scalability

·      Develop automated tests to ensure business needs are met and allow for regression testing

·      Participate in the entire application lifecycle, focusing on coding and debugging

·      Write clean code to develop functional web applications

·      Troubleshoot and debug applications

·      Perform UI tests to optimize performance

·      Manage cutting-edge technologies to improve legacy applications

·      Collaborate with Front-end developers to integrate user-facing elements with server-side logic.

·      Gather and address technical and design requirements

·      Provide training and support to internal teams

·      Build reusable code and libraries for future use

What skills we are looking for?

·      Good communication skill to communicate with stakeholders, project managers, quality assurance teams, Regularly and other developers regarding progress on the long-term technology roadmap

·      Curious and progressive mind to Create and maintain workflows with teams to provide visibility and to ensure workload balance for consistent visual designs

·      Good technical knowledge to Produce quality code, raising the bar for the whole team on quality and speed

·      Through analytical skills to Recommend system solutions by comparing advantages and disadvantages of custom development and purchase alternatives

Skills Needed:

·      PHP Laravel Framework, PHP Design Patterns.

·      Proficient in MySQL, PostgreSQL, MongoDB

·      APIs, REST API, SOAP API, API Security, Open APIs

·      Push Notifications, Laravel Events, Queue, Observers

·      Excellent foundation in computer science, algorithms, and web design

·      Experience writing highly secure web applications

·      Experience with core AWS web-enabling technologies

·      Growth mindset, challenging status quo to find new solutions and out-of-the-box ideas

·      Experience designing RESTful APIs, specifically for mobile apps

·      Computer science degree or equivalent experience

·      Experience leading a team

·      3-6 Years’ experience in back-end development.

As a back-end developer, you’ll work on our back-end app that is built with Ruby on Rails. You’ll help to plan and develop new features, review other people’s code, fix bugs, help in technological and business decisions, and support the internal team.

Responsibilities

• Work in our main app back end built with Ruby on Rails
• Act as an architect of new features
• Review other people's code
• Fix bugs
• Help in decisions of technology and business
• Support internal team
• Refactor code

Requirements

• At least 3 years of industry experience
• At least 1 year of experience working on Ruby on Rails projects
• Comfortable in dealing with server infrastructure and deployment processes
• Experience with continuous delivery and automated testing.
• Experience with refactoring Ruby on Rails applications
• Experience in designing, developing and maintaining APIs
• Can work for at least a couple of hours during Japanese business hours

Nice to haves

These aren’t required, but be sure to mention them in your application if you have them.

• UI/UX design principles
• Good understanding of coding best practices and design patterns
• Understanding of security technologies (encryption, authentication, OAuth 2.0)
• Contribution to open source projects
• Interest and ability to learn other coding languages as needed
• Agile Development experience

• Deliver features in an end-to-end manner: technical design, development, testing, deployment, and maintenance.
• Provide technical leadership and own specific areas of the platform.
• Work closely with Product Managers to translate product requirements to engineering specifications.
• Lead code review efforts and quality efforts in your area of ownership.
• Participate in product discussions, taking ownership and initiative.
• Work independently in a fast-paced environment.
• Mentored and guide junior engineers.

Must Haves:

• Minimum 2 years of working experience in Ruby on Rails/ Python/ Node.JS.
• Strong problem-solving skills, data structures, and algorithms.
• Excellent experience on databases like MySQL, PostgreSQL, etc.
• Familiarity with tools for code reviews, version control (GIT).
• A knack for writing clean, readable Ruby/ Python/Node.JS code.
• Experience in application server hosting and monitoring.
• Understanding of fundamental design principles behind a scalable application.

Nice to Have:

• Hands-on with search platforms (Solr, Elasticsearch, etc).
• Prior experience with microservices-based architecture/SOA/distributed systems.
• Able to implement automated testing platforms and unit tests.
• Experience with common AWS service EC2, RDS, S3, SES, etc.

Key Competencies:

• Building Effective Team
• Solving Problems Creatively
• Learning Agility
• Drive For Result

• 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

DeepSource is working on building tools that help developers ship good code. There are over 40 million developers in the world, and all of them write and review code in some form. There’s a massive opportunity to impact how software is built right from where the code is written using automation and intelligence, that not only improves developer productivity but also increases software’s robustness.

The Language Engineering team works on the source code analyzers, including both programming languages and configuration-as-code systems. As a member of the Language Engineering team, you will work on building the best, most comprehensive, Scala analyzer in the world. You will add new rules and Autofixes for finding more issues with code and automatically fixing them. You will be involved with the community to understand the problems with static analysis tools in the Scala ecosystem.

• Identify bad code practices in Scala and write new analyzers to detect them.

• Improve the coverage of automatically fixable issues.

• Ensure fewer false-positives are reported by the analyzer.

• Work on the internal tools that support analysis runtimes.

• Contribute to open-source static analysis tools.

• Strong foundational knowledge in Computer Science.

• At least 3 years of professional software development experience in Scala and Java.

• Understanding of the nuances of execution of the source code (AST, data flow graphs, etc).

• Familiarity with Scala best practices followed in the industry.

• Native experience with Linux/Unix environment.

• A focus on delivering high-quality code through strong testing practices.

We offer competitive compensation with meaningful stock options, a generous vacation policy, and a workstation of your choice, to name a few of the perks.