Qureos Mentor

Ansira

<div>The Database Developer works closely with the team of database developers to create and implement solutions for various products. The ideal candidate will have experience working in SQL queries ,writing stored procedures and triggers. Also will be responsible for diagnose and resolve production issues, design, test and deploy database schemas and to optimize of existing database queries and procedures.<div>
Responsibilities:</div><div></div><ul><li>
Create a database and normalize the database into small tables by applying rules of Normalization, define check constraints and apply business rules</li><li>
Write T-SQL queries</li><li>
Create stored procedures, functions and triggers</li><li>
ETL from various sql and no-sql data stores to Operational Data Stores</li><li>
Verify and execute scripts developed by teams in staging and production environments</li><li>
Diagnose and resolve production issues</li><li>
Design, test and deploy database schemas</li><li>
Database performance tuning including identifying bottlenecks with suitable fixes</li><li>
Create &amp; implement custom sql scripts to automate various database operations including data migration</li><li>
Create and maintain database documentation</li><li>
Create performance benchmark conformance report for newly developed and altered functions</li><li>
Assist software developers to achieve performance benchmark</li><li>
Optimization of existing database queries and procedures</li></ul><div></div><div>
Required Skills:</div><div></div><ul><li>
3 years of Microsoft SQL Server Development experience including 2008 and/or 2014</li><li>
Strong experience in T-SQL, Indexing, Functions &amp; Stored Procedures</li><li>
Ability to write sql scripts for data migration from sources like excel, oracle, MySql, MS Access, csv/text file etc.</li><li>
Should be able to troubleshoot SQL queries for performance tuning</li><li>
Experience with SQL Profiler</li><li>
Experience in DTS, SSIS, SSRS, SSAS</li><li>
Familiarity with .net technologies (No development experience required)</li><li>
Database analysis and designing &amp; database design methodologies</li><li>
Good problem-solving abilities</li></ul><ul><li>
Good written and verbal communication skills</li><li>
Ability to work in a team and individually</li></ul></div><div></div>

Database Developer -II

<div>
 Ansira is a marketing services company with an internal creative services department. We are currently seeking an entry level creative designer to join our team. We are looking for an innovative thinker with the ability to manage a high volume of individual projects under challenging time constraints. Our ideal candidate is tech-savvy and efficient with great attention to detail and the ability to solve problems quickly and creatively. This position reports the Sr. Manager &ndash; Creative Services.
 <br/>
 <br/>
 <strong>
  Responsibilities
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Manages individual design queue ensuring timeliness of delivery across all creative projects to meet our service level agreements
  </li>
  <li>
   Responsible for managing multiple design projects of varying complexity, ensuring adherence to client instructions, maintaining high design standards, and following both industry compliance regulations and brand guidelines.
  </li>
  <li>
   Follows up with questions and requests in a timely manner.
  </li>
  <li>
   Communicate and coordinate with clients, on-site design team and account managers
  </li>
  <li>
   Maintain a high standard of design quality, customer service, and professionalism
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Requirements
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Expert Knowledge of Adobe Creative Suite &ndash; Illustrator, InDesign, Photoshop
  </li>
  <li>
   Basic understanding of Microsoft Office programs &ndash; Word, Excel, PowerPoint
  </li>
  <li>
   Confident understanding of the print industry and production process
  </li>
  <li>
   Strong typography, understanding of color, hierarchy and layout reflected in portfolio of work
  </li>
  <li>
   Ability to handle multiple responsibilities, establish priorities and consistently meet required deadlines
  </li>
  <li>
   Ability to follow strict brand and visual guidelines
  </li>
  <li>
   Must be fluent in English with excellent written and verbal communication skills
  </li>
  <li>
   Ability to work independently with careful attention to detail and organization
  </li>
  <li>
   Resourceful problem solver
  </li>
  <li>
   Ability to thrive under pressure in a fast-paced environment, balancing tight deadlines with great design and brand consistency
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Experience
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Bachelors degree in BFA or related field
  </li>
  <li>
   1+ years of relevant professional design experience reflected in a portfolio of work
  </li>
  <li>
   Experience utilizing AI in creative design a plus
  </li>
 </ul>
</div>


Creative Designer

Join Ansira and explore 2   exciting career opportunities. They're hiring for various roles with options for remote or on-site work. Apply today and become part of their innovative team.

Ansira

ABOUT_COMPANY

Database Developer -II

Creative Designer