2
clicked apply

Database Analyst

Xeynergy   Colombo • Full-time

About this role

Who we are

XeynergyTM is a dynamic Software Development and IT Services company based in Colombo, Sri Lanka. Our primary focus is providing exceptional software development services to top offshore clients located globally. Founded by a seasoned group of industry professionals, XeynergyTM is committed to creating a network of highly skilled experts capable of working seamlessly alongside top international talent.

Key Responsibilities: 

Database Design & Optimization

  1. Develop, maintain, and optimize relational (SQL) and NoSQL databases, including Azure SQL Database, Redis, and Cosmos DB.
  2. Write and optimize efficient SQL queries, including advanced use of triggers and foreign keys, ensuring database performance and integrity.
  3. Perform database tuning and query optimization using tools such as Query Explanation.
  4. Maintain a high level of normalization and enforce referential integrity.

Data Management & Migration

  1. Lead data migration efforts between different database platforms, ensuring data accuracy and integrity.
  2. Set up and maintain database copies for testing and demonstrations.
  3. Design and maintain SQL Server Clusters and manage databases in Linux-based server environments.

Documentation & Collaboration 

  1. Create and maintain detailed ERD (Entity Relationship Diagram) documentation.
  2. Collaborate with developers, data scientists, and stakeholders to ensure database structures align with business needs.
  3. Provide technical guidance and mentoring on best practices for database use.

Reporting & Data Access

  1. Design and support reporting mechanisms, extracting data from SQL, Redis, and Cosmos databases.
  2. Develop tools and processes for querying and manipulating data in NoSQL databases.

Data Science Integration

  1. Work closely with data science teams, leveraging tools like Jupyter, Pandas, SciPy, TensorFlow, and Keras to enable advanced analytics.
  2. Integrate databases with data science workflows, enabling predictive analytics and machine learning models. 

Required Qualifications:

  • Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
  • 5+ years of experience with relational databases (e.g., SQL Server, Azure SQL).
  • 3+ years of experience with NoSQL databases (e.g., Redis, Cosmos DB).
  • Proficiency in writing, debugging, and optimizing SQL queries and triggers.
  • Strong understanding of database normalization, referential integrity, and performance tuning.
  • Experience with data migration, database clustering, and maintaining database environments on Linux servers.
  • Familiarity with ERD tools and documentation best practices.
  • Knowledge of Azure and hybrid cloud environments.
  • Experience querying and manipulating data in NoSQL platforms. 

Preferred Qualifications: 

  • Experience with Anaconda tools such as Jupyter, Pandas, SciPy, Keras, and TensorFlow.
  • Familiarity with Redis data structures and querying.
  • Strong scripting skills in Python or other programming languages.
  • Understanding of data security best practices and compliance standards. 

What We Offer:

  • Above market compensation package paid in US Dollars
  • Opportunities to work on cutting-edge data projects.
  • A collaborative environment focused on innovation and growth.
  • Professional development and training opportunities.
  • Other Benefits - Comprehensive health cover, Company paid internet facility with power backups