Senior SQL Developer

HR WAYS (PRIVATE) LIMITED

٦ گھنٹے پہلے شائع ہوئی 12 نے دیکھا Report Job

PKR. 400,000 - 400,000/Month

We are seeking an Expert Level SQL Server Database Developer to join our development team. The ideal candidate will have extensive experience in designing, developing, and optimizing high-performance database solutions, as well as improving and refactoring complex existing stored procedures and SQL queries. This role focuses solely on database development and does not include DBA responsibilities like maintenance, backups, or server administration. We are looking for a candidate who can drive the development of efficient, scalable, and maintainable database systems for our applications.

Key Responsibilities:

Design, develop, and optimize complex SQL Server database systems to support application development and business requirements.
Improve, refactor, and optimize existing complex stored procedures and SQL queries to enhance performance, readability, and maintainability.
Write highly efficient T-SQL queries, stored procedures, views, functions, and triggers to meet the needs of high-performance applications.
Collaborate with application developers to design database schemas and data models that fit within the architecture of the applications.
Analyze and optimize queries for maximum performance, ensuring proper indexing and query structure.
Design efficient database structures for large-scale data sets, ensuring high performance and scalability.
Work on improving query performance by using execution plan analysis, query profiling, and optimization techniques.
Implement efficient data access patterns such as pagination, batch processing, and set-based operations to handle large datasets.
Collaborate with the development team to ensure database solutions integrate seamlessly with application code and APIs.
Assist in writing and optimizing ETL processes for data import/export and transformation.
Regularly review and refactor SQL code to improve performance, maintainability, and scalability.
Ensure data integrity and consistency within database solutions.
Mentor developers on SQL best practices, code optimization, and efficient database usage.

Required Skills and Qualifications:

8+ years of experience in SQL Server Database Development
Expertise in T-SQL, including writing and improving complex queries, stored procedures, functions, and triggers.
Proven experience in refactoring and optimizing complex existing stored procedures and SQL queries to enhance performance and readability.
Strong knowledge of query optimization, execution plan analysis, and indexing strategies.
Proven ability to design and optimize large, complex databases and handle high-volume data efficiently.
Experience with ETL development and data integration using tools like SSIS.
Strong understanding of database design principles, including normalization, denormalization, and data modeling.
Experience with modern database development practices, including version control for database code and integration with CI/CD pipelines.
Solid understanding of best practices in database security and data integrity.
Experience with cloud-based databases (e.g., AWS RDS) is a plus but not required.
Ability to work collaboratively in a team and translate business requirements into efficient database solutions.

Key Attributes:

Strong attention to detail and focus on writing high-quality, efficient SQL code.
Proactive and innovative approach to problem-solving and performance tuning.
Strong communication skills and the ability to collaborate with cross-functional teams.
Passionate about continuously improving database performance and development practices.

Job Details:

Experience: 3 to 6 years

Work days and timings : Monday to Friday

Core Hours: 10:30 AM to 6:00 PM (with a 1-hour break)

Flexible Hours: 1.5 hours can be worked between 9:00 to 10:30 AM or 6:00 to 7:30 PM

Total Work Hours: 8 hours