Database Engineer - PostgreSQL

Position: Graphic Designer 

Department: Graphic Design 

Location: Gurgaon Haryana 

Reports To: Head of Dept. 

Company Overview: 

At BSDPL we are a dynamic and forward-thinking company known for delivering cutting-edge design solutions that elevate brands and engage audiences. We’re looking for a highly skilled Graphic Designer to join our creative team. This is a fantastic opportunity for an individual with exceptional design talent and experience using the latest industry-standard software and tools.  

Key Responsibilities: 

• Create visually engaging graphics for websites, social media, marketing campaigns, brochures, presentations, and other digital/print materials. 
• Develop design concepts that communicate a clear message and align with brand identity and objectives. 
• Present design ideas and concepts to the creative team and stakeholders for feedback and refinement. 
• Utilize the latest industry-standard design software and tools such as Adobe Creative Suite like Illustrator(must), Photoshop(must), InDesign and After Effects (good to have). 
• Keep up with the latest trends and innovations in design tools and software and apply them to your work. 
• Collaborate with other designers to maintain consistency in design direction across different platforms and media. 
• Design a variety of creative assets for digital channels, including website design, social media posts, email templates, display ads, etc. 
• Produce print-ready designs for marketing materials such as brochures, flyers, posters, banners, and packaging. 
• Stay updated with current design trends, industry innovations, and emerging design tools. 

Skills: 

• Expert knowledge of design software including Adobe Creative Suite (Photoshop, Illustrator, InDesign, After Effects) etc. 
• Strong experience of typography, color theory, composition, and design principles(must). 
• Experience designing for both digital and print formats. 
• Strong attention to detail and ability to maintain consistency across all designs. 
• Ability to work in a fast-paced environment while managing multiple projects and deadlines. 
• Strong communication skills to articulate design concepts and ideas clearly to non-design stakeholders. 

Qualifications: 

• Education: Graduate in any field (B.A., B.com., BBA, or any other discipline)  
• Experience: 2+ years of professional graphic design experience. 
• Certification in design. 
•  

Working Hours: 

• Full-time position with 9:30AM to 6:30PM working hours (Mon to Sat) 

Note: Final job confirmation process will take a minimum of 15 days after feedback evaluation. 

you will play a crucial role in the planning and execution in managing Ceo work. Your responsibilities will include handling inquiries, assisting with travel bookings, managing itineraries, and providing timely support to our clients before, during, and after their travels.

• manage a lively and constantly evolving calendar
• Keeping executive staff meeting minutes and agendas
• Act as gatekeeper, time advocate, and liaison creating efficiency and balance for your leaders’ schedule
• Coordinate internal and external meetings including but not limited to team meetings, off-site, one-on-ones, speaking engagements, and personal engagements
• Working closely with our CEO, helping drive cross-functional projects and associated timelines.
• Working with the executive team to facilitate the deliverables on key executive staff projects.
• Manage the tracking and progress of quarterly OKRs
• Offer coordination support for any candidate interviews as needed
• Book all domestic and international travel, taking into account costs, and proper documentation for any international travel using Navan or airlines directly (for both professional and personal travel)
• Handle multiple requests for the Executive’s time, utilizing strong judgment in prioritizing requests
• Format documents and presentations
• Run personal projects and errands for our CEO, as needed.

Job Description:

Candidate should ideally be a B.E/B.Tech graduate with around 3 to 5 years of experience, with core T-SQL scripting , performance tuning, SSIS, NOSQL skills. The current role requires a core T-SQL , NoSQL and SSIS developer. The SQL Developer will be responsible for:

• Creating & designing database and all database objects such as tables, views, StoredProcedures, functions etc.
• Writing and troubleshooting simple to complex SQL scripts, stored procedures, views, functions, etc. as per the requirement.
• Troubleshooting and fixing all performance issues with respect to databases (objects & scripts).
• SQL Query tuning and performance tuning.
• Develop/migrate existing scripts to SSIS.
• Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints, etc.
• Maintaining database objects (like tables, views,Stored Procedures) performance by following the tuning tips like normalization, indexes, etc.
• Importing and exporting the data from different sources using tools, writing required scripts.
• Works closely with other members of the team to accomplish the projects.
• Assists project teams to design and develop core business components utilizing  industry-accepted analysis and design standards.
• Provides and/or assists with, project management and project leadership.
• Create and maintain documentation for all the projects.
• Working with NOSQL databases (Mostly on MongoDB) .

PRIMARY SKILLS: 

TSQL, SQL, NoSQL, Performance Tuning, SSIS, Import & Export of data from different data sources and from different formats.

SECONDARY SKILLS:

Database Administration

REQUIRED SKILLS:

• 3+ years of professional experience in working with MSSQL Server 2008 and above.
• 3+ years of professional experience in writing TSQL scripts.
• Thorough experience in SQL query tuning and performance tuning.
• Experience in developing and maintaining SSIS packages.
• Experience in working with NoSQL databases. MongoDB would be preferable.
• Fluent knowledge of MSSQL server DBA.
• Should be a good team player and should possess good attitude and work ethics.
• Should possess excellent communication and written skills.

PREFERRED SKILLS:

• MSSQL DBA.
• SSIS.
• NOSQL, MongoDB

What you need to have:

• Strong passion for Sales with an Analytical & Entrepreneurial mindset
• Outstanding interpersonal as well as Written & Verbal communication skills alongside research capabilities
• Appetite to learn new skills and tools required for the job
• Ability to communicate, present, and influence all levels of the organization, including executive and C-level
• Ability to work comfortably across a disparate set of global cultures
• Should be comfortable to work in US time zone.

Skills we are looking for :

- Experience in developing full-stack applications at scale in ReactJs/AngularJs & NodeJs.

- Strong knowledge and experience in HTML(5), CSS, SCSS, and Advanced JavaScript

- Good knowledge of coding RESTful APIs.

- Strong knowledge of Web Storage (Cookie, Local Storage, and Session Storage)

- Knowledge of modern authorization mechanisms, such as JWT

- Familiarity with modern front-end build pipelines and tools

- Ability to work in a lean-agile development environment.

Good to know :

- Using GIT

- Knowledge of AWS

- Familiarity with GraphQL will be a brownie point

We are seeking an experienced web developer to join our friendly team to participate in the development of the next-generation app.

You will take a lead role in the technical side of our company with room to grow as we continue to grow.

Technologies/Frameworks: PHP, Laravel, Lumen, mySQL/postgres, react,

Skills Required :

- Extensive experience in PHP and Laravel (OOP experience).

- REST APIs and Integrations technologies

- JSON Language and scripting

- Familiarity with Bitbucket (Git), Node

- Database Management tools such as MySQL.

- Comfortable working with JavaScript and jQuery

- Understanding of coding best practices.

What you'll do :

- Work with us to contribute and plan ideas for features and improvements to the platform. Write clean, functional code on back-end to develop new features, integrations and refine existing ones.

- Help to improve our platform by refactoring existing code (PHP/Laravel/JavaScript). Work with, and sometimes manage the work of external contract developers.