Key Responsibilities (not all-inclusive, nor exhaustive):

• Write data scripts in order to support the development and implementation of efficient and effective Databases components and build robots data models and logic.
• Keep up-to-date technical systems documentation for developed Data solutions in order to support systems maintenance.
• Resolve users queries independently, escalating if required, to ensure that standard IT questions are answered, and accurate information is provided.
• Maintaining and optimizing databases and testing and debugging databases
• Assist in the preparation of materials and the delivery of trainings on automated business processes to ensure efficient and effective use of Data systems.
• Collect and collate data, conduct basic analysis to support the development of accurate reports.
• Perform other related duties, as required.

Skills

Required Experiences for entry into the role:

• Proficiency with major DBMS platforms, such as Oracle, SQL Server, MySQL, PostgreSQL, and MongoDB, is required; we use Microsoft SQL Server. 
•    Experience in programming language such as C# and python is required
• Strong SQL (Structured Query Language) knowledge for creating and managing database structures, querying data, and optimizing performance is required. 
• The ability to design and optimize database schemas, including tables, indexes, keys, and relationships between tables, is required. 
• Familiarity with Entity-Relationship Diagrams (ERDs) and normalization principles is required. 
• Strong analytical and problem-solving skills to identify and address database issues effectively. 
• Good communication skills to collaborate with business stakeholders. 
• Attention to detail to manage data integrity and accuracy. 

Desired Experiences for entry into the role:

• Experience with T-SQL (Transact-SQL), PL/SQL (Procedural Language), or equivalents for stored procedures and functions   
• Scripting skills in Python, Shell scripting, or PowerShell for database automation tasks 
• Experience with Microsoft Azure DevOps, including Azure Pipelines and release management,
• Skills in query optimization, indexing strategies, and troubleshooting slow queries 
• Experience using performance monitoring tools for databases like SQL Server Profiler
• Knowledge of ETL (Extract, Transform, Load) tools such as SSIS (SQL Server Integration Services)   
• Understanding of database security best practices such as role-based access control, encryption, and auditing 
• Knowledge of data masking, encryption standards, and user authentication mechanisms