Ecommerce & Digital Marketing Executive

Role Overview

We are seeking a Senior SQL Developer & ETL Engineer with 5+ years of experience for a 100% remote opportunity.

Please Note: This is not a pure Data Engineering role. We are looking for a true SQL Specialist. Your core strength must lie in relational database development, schema design, and writing high-performance database logic with Python, ETL, Cloud. SQL mastery and database architecture are the absolute heart of this role.

If you are a database developer who loves diving into query execution plans, refactoring messy stored procedures for 10x performance, and building clean data models from scratch, this role is for you.

Key Responsibilities

1. Database Architecture & Schema Design

• Design, implement, and maintain robust relational database schemas.
• Architect optimal data models for both operational (OLTP) and analytical (OLAP/Data Warehousing) workloads.
• Implement Normalization (3NF) and dimensional modeling (Star/Snowflake schemas) as required.

2. Advanced Database Programmability

• Write, debug, and optimize highly complex Stored Procedures, Functions, Triggers, and Views to handle core business logic at the database level.
• Utilize advanced SQL techniques such as CTEs, Window Functions, and complex analytical queries to solve business problems.

3. Performance Tuning & Indexing

• Analyze query execution plans, identify performance bottlenecks, and implement advanced indexing strategies (B-Tree, Clustered/Non-Clustered, Partitioning).
• Refactor legacy SQL code and manage statistics, locking, and concurrency mechanisms to ensure sub-second response times.

4. Python & Cloud ETL/ELT Pipelines

• Develop, schedule, and maintain scalable data ingestion and transformation pipelines to connect disparate data sources.
• Leverage Cloud Data Platforms alongside modern Python libraries to build efficient data movement workflows.

5. Data Integrity & Governance

• Establish strict database constraints, data validation routines, and automated quality checks to guarantee absolute data accuracy.

Required Technical Skills

• Expert-Level SQL & DB Programmability (5+ Years): Mastery of writing server-side logic (Stored Procedures/Functions) and complex queries in enterprise platforms like PostgreSQL, SQL Server, Oracle, or MySQL.
• Advanced Database Optimization: Deep, under-the-hood understanding of database engines, execution plans, indexing strategies, and concurrency/locking control.
• Python for Data Engineering (3+ Years): Proficient in writing clean, modular Python scripts for API integration, data manipulation, and ETL processing (using libraries like Pandas, SQLAlchemy, or custom database connectors).
• Cloud Data Experience: Hands-on experience working with, migrating to, or developing within major cloud environments (AWS, Azure, GCP) and modern cloud data warehouses (Snowflake, BigQuery, or Redshift).
• Data Modeling Methodologies: Practical experience designing Star/Snowflake schemas, handling Slowly Changing Dimensions (SCD), and balancing normalization vs. denormalization.

Remote & Soft Skills

• Legacy Refactoring Mindset: You genuinely enjoy opening up a massive, poorly optimized 500-line legacy stored procedure and refactoring it for maximum efficiency.
• Autonomous Execution: Proven ability to manage your own time, architecture tasks, and deliverables without micromanagement in a fully remote setup.
• Asynchronous Communication: Exceptional written and verbal English communication skills to collaborate seamlessly across time zones.

Nice-to-Haves

• Experience migrating legacy on-premise infrastructure and stored procedures to modern cloud data warehouses.
• Familiarity with workflow orchestration tools like Apache Airflow or Prefect.
• Hands-on experience with dbt (data build tool) for in-warehouse transformations.

Our Vision:

Vapronix web is a platform for constant interaction of technology and human creativity. We aim to create a digital environment that connects people from around the world, fulfilling their entertainment and mind simulation needs while co-creating happiness and generating value for all.

Job Summary:

We are seeking a skilled and imaginative 2D Motion Graphic Designer to produce an enticing marketing video for our game apps. As a 2D Motion Graphic Designer, your primary objective will be to create a visually captivating and dynamic video that effectively showcases the unique features and excitement of our game apps to our users.

Key Responsibilities

1. Create engaging motion graphics, video edits, and promotional assets for game marketing.
2. Collaborate with marketing, content, and development teams to deliver creatives on time.
3. Research trends, competitors, and winning hooks to develop high-performing concepts.
4. Produce edits, variations, and iterations quickly while maintaining consistency and quality.
5. Take full ownership of the end-to-end creative process - assets, versions, feedback, and final delivery.
6. Optimize videos for multiple platforms and integrate music, SFX, and voiceovers where needed.
7. Stay updated on design tools, motion trends, and gaming industry best practices.

Requirements

• Proven experience in motion graphics with a portfolio (gaming creatives preferred).
• Proficiency in After Effects, Premiere Pro, and Adobe Creative Suite.
• Strong understanding of visual storytelling, video formats, audio editing, and color grading.
• Ability to create both reference-inspired and original creatives.
• Detail-oriented, deadline-driven, and capable of handling multiple projects.
• Strong communication skills and openness to feedback.

Key Responsibilities:

• Manage the full sales cycle: lead generation, prospecting, proposal development, negotiation, closing, and post-sales support.
• Develop and execute strategic sales plans to meet or exceed business targets.
• Build and maintain strong, long-lasting client relationships through regular communication and personalized service.
• Conduct high-impact presentations and product demos tailored to client needs.
• Lead, coach, and support the corporate sales team to achieve individual and team objectives.
• Monitor sales performance metrics and prepare regular reports for senior management.
• Identify emerging market trends and competitor activities to adjust sales strategies.
• Collaborate closely with internal teams (e.g., marketing, operations, finance) to ensure seamless client experiences.

Qualifications:

• Bachelor’s degree in Business, Marketing, or a related field
• Minimum 3 years of hands-on corporate or B2B sales experience
• Demonstrated success managing the complete sales cycle and closing high-value deals.
• Excellent verbal and written communication skills, with the ability to influence and negotiate effectively.
• Strong organizational skills and ability to manage multiple priorities.
• Proficiency in CRM tools and Microsoft Office Suite.

Job Description

Full Stack Developer (Java and Angular)

Location: Remote

Experience required: 3+ years

Requirements:

• Total 3+ years of experience in Java and J2EE development
• 3 years of experience in Full Stack development using Java and Angular 2.0 and above
• Experience in Spring Boot and Spring MVC
• 1 year of experience in AWS Services
• Experience in writing DB queries - SQL & PL SQL
• Experience in RESTful API/SOAP based services
• Good communication and interpersonal skills

About Optiblack LLC

Optiblack LLC is a company that specializes in providing tech and analytics services. We offer a range of solutions to help businesses meet their goals, including:

• Data Analytics: we can help you extract insights from your data to make informed decisions.
• Web Development: we can design and build custom websites for your business.
• Mobile App Development: we can create mobile apps for both iOS and Android platforms.
• AI and Machine Learning: we can leverage these technologies to automate tasks and improve efficiency.

Optiblack LLC has a team of experienced professionals who can help you with your project. They have a track record of success in delivering high-quality solutions to our clients.

About the Role

We are looking for a passionate and talented intern developer to join our growing team at Optiblack LLC. This is a fantastic opportunity to gain hands-on experience building and maintaining our React Native mobile application. You will work alongside experienced developers and contribute to a product used by millions of users.

Responsibilities:

• Develop new features and functionalities for our React Native mobile application.
• Collaborate with designers and backend developers to ensure a seamless user experience.
• Write clean, maintainable, and well-documented code.
• Fix bugs and identify areas for improvement in the existing codebase.
• Stay up-to-date with the latest trends and technologies in React Native development.
• Participate in code reviews and provide constructive feedback.

Qualifications:

• Strong understanding of React Native development concepts.
• Experience with JavaScript (ES6+) and related frameworks.
• Familiarity with React development principles is a plus.
• Experience with Git version control system.
• Excellent problem-solving and debugging skills.
• Ability to work independently and as part of a team.
• Strong communication and interpersonal skills.
• A passion for learning and staying updated with the latest technologies.

Bonus Points:

• Experience with building cross-platform mobile applications.
• Experience with UI/UX design principles.
• Experience with unit testing frameworks like Jest or Mocha.
• Experience working on Social Media Apps or having an interest in working on them.

** Internship Duration:** 3 Months

Location: Remote

To Apply:

Please submit your resume and a cover letter explaining your interest in the position and why you think you would be a good fit for our team

Mandatory

Exposure to the Trading and financial investment banking domain

All technical competencies are mandatory, and no relaxations/exceptions can be given.

Technical skills

Cloud computing (IaaS, PaaS, SaaS) -preferably in AWS

Compute/Container/Orchestration technologies (Docker, Kubernetes, ECS, EKS, Lambda/Serverless etc.)

Microservices & multi-tier architectures

DevOps/CI/CD (GIT/Bitbucket, Maven, Gradle, Jenkins, Sonar) GitLab is preferable

Java (Core & EE, Spring Boot, Spring MVC, Spring Cloud) & Python

RDBMS systems sucah as MySQL , Postgres and NoSQL, Storage Technologies (S3, EBS etc.)

API – GraphQL, REST, API Gateway

Integration and events/messaging technologies (Kafka, RabbitmQ, SNS, SQS)

Caching Solutions such as Elasticache/Redis, Hazelcast, EHCache

Observability and monitoring (Dynatrace, Cloud Watch, Grafana, Splunk, Datadog)

Very good understanding on Agile software releases and hands-on

Experience in project management tools like JIRA

Educational Qualification

Bachelor’s degree in computer science engineering/ECE/EEE, IT or MCA, MSc Computer Science

Position: Windows SRE

Responsibilities:

• Windows Site Reliability Engineer with experience in managing large websites where Millions of customers hit
• Manage and monitor all installed systems and infrastructure
• Install, configure, test and maintain operating systems, application software and system management tools
• Among your responsibilities will be the installation and configuration of storage, servers, Microsoft servers (Cluster Services, File Services, Active Directory Services, Certificate Authority services), Virtual Infrastructure (Hyper-V), IIS, MS SQL and backup system
• Proactively ensure the highest levels of systems and infrastructure availability
• Monitor and test application performance for potential bottlenecks, identify possible solutions, and work with developers to implement those fixes
• Maintain security, backup, and redundancy strategies
• Write and maintain custom scripts to increase system efficiency and lower the human intervention time on any tasks
• Participate in the design of information and operational support systems
• Provide 2nd and 3rd level support
• Liaise and collaborate with vendors and Zacks personnel for problem resolution, decision making, knowledge sharing

Requirements:

• Minimum 5+ years of Windows support experience, 7, 8, 10, and Microsoft Server (all)
• Windows server expertise
• Familiar with WAN/LAN technologies
• Understanding of the OSI model
• Virtualization - MS Hyper-V, VMware, vSan
• Strong understanding of Internet protocols including HTTP(S), SSL, TCP, IP
• MS IIS administration and configuration
• MS Active Directory
• MS Storage Space
• DNS and DHCP
• SSL certificates and PKI
• Familiar with the ITIL framework
• Strong PowerShell experience
• Information Security experience a plus Other Qualifications
• Excellent attention to detail

Experience: 8-10 years