Pr. Database Developer

Role Description

ZIN requires Database Developers for its Lahore office.

The Database Developer requires a solid understanding of database technologies, particularly SQL Server and be skilled in producing complex queries.

The Database Developer will understand and be experienced in performing ETL (Extract, Transform & Load) tasks on large volumes of data using SSIS (SQL Server Integration Services) from various data sources such as but not limited to CSV, XML and JSON.

The Database Developer will primarily focus on the Telecom product, however, will also work with other teams within the business on integration of the database and general maintenance and performance management of the company’s databases.

Responsibilities

  • Monitoring and maintaining existing ETL processes for internal and external data feeds
  • Developing ETL processes, working as part of an agile development team
  • Developing SQL scripts and Stored Procedures
  • Working closely with Data Science teams; preparing and analyzing data
  • Supporting development team on database design best practices
  • Improve system performance by conducting tests troubleshooting and integrating new elements
  • Optimize new and current database systems
  • Define security and backup procedures
  • All work will be fully documented and stored within appropriate version control solutions
  • Working with other teams to ensure they have the data required to perform their roles

Skills & Requirements

Essential Requirements:

  • Experience creating, performing, and maintaining ETL tasks using technologies such as SSIS
  • Experience with relational database technologies such as SQL Server
  • Experience in database administration tasks using Microsoft SQL Server 2014-2019 (Schema maintenance, tuning, performance analysis, backups etc.)
  • Writing complex T-SQL queries and SQL Stored Procedures

Highly Desirable:

  • Experience of the Telecom industry (especially subscription management and CDRs) would be beneficial
  • Understand Information security (E.g. GDPR)
  • Scrum/Agile Methodology
  • Working with PowerShell
  • Working with Azure DevOps
  • Source Control such as Git
  • Working with .NET
  • Experience of producing test data for QA environments
  • Experience with large (>100,000 rows) datasets or datasets of mixed quality.
  • Working with API integrations (JSON, Restful etc). Using Postman or similar tools
  • Working with databases in the Cloud (ideally AWS)

Experience

  • 8 – 10 + Years of overall experience.

Education

Bachelor OR Masters degree in Computer Sciences from a well-reputed university.

Salary Package

  • Attractive Salary
  • Out Door Medical
  • In-door Medical
  • Provident Fund
  • Company Paid Certification
Department Database
Experience 8 – 10+  Years
Location Lahore 
No. of Position 1
Education BCS/MCS/MSc.

Apply For Job