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