Database Developer (SQL Server / Power BI / AI Productivity) (Pakistan Only)
About AllShore Talent
AllShore Talent is a leading remote staffing company, offering top-tier professionals working 100% remote to businesses worldwide. Specializing in IT and software development, design, administrative support, digital marketing, and more. AllShore connects organizations with skilled talent to meet diverse business needs.
Location: Remote / On-site (as applicable)
Position Overview
We are seeking a highly skilled Database Developer with deep expertise in SQL Server, T-SQL, data migration, and BI development.
The ideal candidate will have hands-on experience designing scalable databases, building complex stored procedures, optimizing data pipelines, and creating insightful dashboards in Power BI.
The candidate must also demonstrate the ability to leverage AI-powered tools (e.g., GitHub Copilot, ChatGPT, or Azure AI) to streamline query development, improve efficiency, and support faster delivery cycles.
Key Responsibilities
Design, develop, and optimize relational database architectures to support enterprise applications.
Write, review, and maintain complex T-SQL queries, views, triggers, and stored procedures.
Perform data migration, transformation, and cleansing across multiple environments.
Develop, schedule, and maintain SSIS packages for ETL processes.
Design and implement data models for reporting and analytics.
Build and publish Power BI dashboards and reports, integrating data from multiple sources.
Monitor and improve database performance, scalability, and security.
Collaborate closely with application developers, analysts, and business stakeholders to ensure data integrity and performance.
Use AI-assisted development tools to enhance productivity, accelerate coding tasks, and automate repetitive database operations.
Support data-driven decision-making through BI and analytics solutions.
Required Skills & Qualifications
Bachelor’s degree in Computer Science, Software Engineering, or a related field.
5+ years of hands-on experience in Microsoft SQL Server (2016 or later).
Strong experience in database design, normalization, and optimization.
Expert-level proficiency in T-SQL, including advanced query tuning and indexing.
Proven experience with SSIS (SQL Server Integration Services) for ETL processes.
Experience in data migration between heterogeneous systems.
Proficiency in Power BI report creation and data modeling.
Familiarity with database security, roles, and permissions.
Ability to use AI tools (e.g., GitHub Copilot, ChatGPT, Azure OpenAI, etc.) for query optimization, data analysis, and documentation.
Strong analytical and problem-solving skills with attention to detail.
Excellent collaboration and communication abilities.
Preferred (Nice-to-Have)
Experience with Azure SQL, Synapse Analytics, or Databricks.
Knowledge of data warehousing and dimensional modeling.
Exposure to Python or R for data analytics.
Understanding of Agile/Scrum methodologies.
Why Join Us
Work in an AI-first engineering culture, where automation and innovation drive everything we do.
Opportunity to collaborate on enterprise-grade applications and modern BI platforms.
Learn, experiment, and grow your skills with access to leading-edge tools and technologies.
This is a short-term project engagement, expected to last approximately 4 to 6 weeks, with a part-time commitment of around 4 hours per day.
Apply To This Job
AllShore Talent is a leading remote staffing company, offering top-tier professionals working 100% remote to businesses worldwide. Specializing in IT and software development, design, administrative support, digital marketing, and more. AllShore connects organizations with skilled talent to meet diverse business needs.
Location: Remote / On-site (as applicable)
Position Overview
We are seeking a highly skilled Database Developer with deep expertise in SQL Server, T-SQL, data migration, and BI development.
The ideal candidate will have hands-on experience designing scalable databases, building complex stored procedures, optimizing data pipelines, and creating insightful dashboards in Power BI.
The candidate must also demonstrate the ability to leverage AI-powered tools (e.g., GitHub Copilot, ChatGPT, or Azure AI) to streamline query development, improve efficiency, and support faster delivery cycles.
Key Responsibilities
Design, develop, and optimize relational database architectures to support enterprise applications.
Write, review, and maintain complex T-SQL queries, views, triggers, and stored procedures.
Perform data migration, transformation, and cleansing across multiple environments.
Develop, schedule, and maintain SSIS packages for ETL processes.
Design and implement data models for reporting and analytics.
Build and publish Power BI dashboards and reports, integrating data from multiple sources.
Monitor and improve database performance, scalability, and security.
Collaborate closely with application developers, analysts, and business stakeholders to ensure data integrity and performance.
Use AI-assisted development tools to enhance productivity, accelerate coding tasks, and automate repetitive database operations.
Support data-driven decision-making through BI and analytics solutions.
Required Skills & Qualifications
Bachelor’s degree in Computer Science, Software Engineering, or a related field.
5+ years of hands-on experience in Microsoft SQL Server (2016 or later).
Strong experience in database design, normalization, and optimization.
Expert-level proficiency in T-SQL, including advanced query tuning and indexing.
Proven experience with SSIS (SQL Server Integration Services) for ETL processes.
Experience in data migration between heterogeneous systems.
Proficiency in Power BI report creation and data modeling.
Familiarity with database security, roles, and permissions.
Ability to use AI tools (e.g., GitHub Copilot, ChatGPT, Azure OpenAI, etc.) for query optimization, data analysis, and documentation.
Strong analytical and problem-solving skills with attention to detail.
Excellent collaboration and communication abilities.
Preferred (Nice-to-Have)
Experience with Azure SQL, Synapse Analytics, or Databricks.
Knowledge of data warehousing and dimensional modeling.
Exposure to Python or R for data analytics.
Understanding of Agile/Scrum methodologies.
Why Join Us
Work in an AI-first engineering culture, where automation and innovation drive everything we do.
Opportunity to collaborate on enterprise-grade applications and modern BI platforms.
Learn, experiment, and grow your skills with access to leading-edge tools and technologies.
This is a short-term project engagement, expected to last approximately 4 to 6 weeks, with a part-time commitment of around 4 hours per day.
Apply To This Job