PostgreSQL Developer

PostgreSQL Developer
 

Projects technologies:

• Backend: Node.js, ActionHero.js, Next.js (ES6 & TypeScript)
• Warehouses: PostgreSQL v11+ / Redis / RabbitMQ
• FrontEnd: ECMAScript, React, MobX, RxJS, Lodash, Moment, Kendo UI, HTML5, CSS3, SASS
• JS Development Tools: Babel, Webpack, Jest
• Cloud Provider: AWS — GCP
• CI/CD: Bitbucket, gcr.io
• Infrastructure Management: Docker / Kubernetes / GCP & AWS ECS
• Architecture: Role-Based Pods, Microservice Architecture, REST API

Knowledge, Skills & Abilities:

• Proficient with PostgreSQL.
• A minimum of 3 years engineering experience in database roles working in mission critical, high traffic environments. Solid understanding of database fundamentals; relational and non-relational databases.
• Experience using source control and git.
• Basic understanding of cloud computing, and distributed systems. Experience with database replication and sharding.

Nice to have:

• Familiarity with Kubernetes, Docker.
• Experience with non-relational databases.
• Experience with NoSQL.
• Experience with Kafka, Oracle, MySQL or MS SQL.
• Passion for data technology and real world data applications.
• Jira.

Opportunities:

• Broad and advanced technology stack — huge opportunity to grow, learn and diversify your skills
• Possibility to dive into cross-cultural communication and use English in daily meetings
• Coffee, tea, candy, season fruit, and vegetables.
• Various sports events and team-building activities where we celebrate our team and company’s victories and achievements.
• Comfortable office within walking distance of the metro station.
• Hybrid work with a flexible schedule (starting from 8 to 11 am, 8-hour workday, work remotely several days in a week / month)
• 15 working days of paid vacation.
• Weekly check points with a supervisor to monitor and assist in completing assigned tasks.
• Environment for development and growth: English courses, specialized courses, regular performance reviews.
• Relocation package (support with moving, one-time bonus)
• Paid medical insurance.
• Yearly performance bonus.
• Udemy unlimited membership.
• SportLife membership.
• Experience and knowledge sharing between teams.
• Engage with new technologies and innovative products.

Responsibilities:

• 3+ years SQL development experience using Transact SQL.
• Knowledge of relational and reporting database schema designs.
• Experience with data cleansing and/or ensuring data integrity.
• Work with engineering and business stakeholders to understand database requirements.
• Quantify and communicate the impact of software, usage, and infrastructure changes as it relates to database health.
• Evangelize current database best-practices and help developers avoid common pitfalls by working directly with them in the design, development, and code review phases.
• Implement best-practices for data access, governance, and lineage.
• Evaluating, benchmarking, and recommending the best relational and non-relational data stores.
• Diagnose and troubleshoot database and application performance problems.
• Perform on-call rotations to provide support for urgent production issues
• Ability to work collaboratively on a team.
• Good communication and documentation skills
• Interface with SMEs and stakeholders to determine features and requirements
• Database unit testing.
• Plans and tools for database lifecycle management.
• Design and implement queries and reports for data extraction.
• Database configuration and tuning.
• Knowledge of inheritance and partition design