Senior Software Developer (SQL Server + VB.NET)

About Contour Contour Software has grown from a dozen people to over 2,000 staff across 3 cities, in less than 14 years. As a subsidiary of Constellation Software Inc., we are proud to be part of a global enterprise software conglomerate that has grown to become one of the top 10 software companies in the world, with employees and customers in 100+ countries. With a broad-based and ever-growing portfolio of market-leading, vertical-market enterprise solutions covering more than 100 industry domains in predominantly mature markets, CSI's recipe creates the perfect environment for professionals to build fulfilling, long-term careers. What started as an R&D & Accounting back-office, has progressed into a full-service Global Centre serving all functions and departments, at the divisional as well as operating group/corporate level. Today Contour employees, located in Karachi, Lahore & Islamabad, are serving CSI divisions located in time zones spanning the globe, from Sydney to Vancouver. With the global growth of Constellation as the wind in our sails, we are only just getting started! THE DIVISION Owner Relations Technology is an IT company that is growing fast. We supply a unique software solution for Property Managers and Hoteliers worldwide. We specialize in developing robust Owner Accounting and Owner Portal software solutions for Condo Hotels, Fractional Hotels, Timeshare Resorts, HOAs, Residence Clubs, and Property Management Companies. Our client base consists mainly of 4- and 5-star Resort hotels in North America, the Caribbean, Europe, and Asia. THE POSITION: We seek a highly skilled Senior Software Developer with extensive experience in data migration, SQL Server, stored procedures, query tuning, and database performance optimization. This role is critical to successfully migrating approximately 60 legacy databases to a new database version as part of a high-impact modernization project. The ideal candidate will have a strong technical background, proven expertise in database migrations, and the ability to troubleshoot and optimize complex database systems. The role will involve collaborating with cross-functional teams to ensure data integrity, minimal downtime, and optimal performance throughout the migration process, as well as maintaining and enhancing existing applications for data processing or database interaction. The selected candidate will work out of the Contour Software Lahore/Islamabad office, as an extension of the division-based R&D department. KEY RESPONSIBILITIES: • Analyze, plan, and execute the migration of 60 databases from an old version to a new version of the database. • Develop and implement strategies to ensure data consistency, accuracy, and completeness during migration. • Identify and resolve potential schema changes, data types, and compatibility issues. • Write, optimize, and maintain complex SQL queries, stored procedures, and functions to support migration. • Tune database queries for performance and scalability, ensuring minimal latency and resource consumption. • Maintain and enhance existing applications for data processing or database interaction. • Ensure the compatibility of applications with the updated database architecture. • Monitor and analyze database performance metrics and implement solutions to address bottlenecks. • Configure indexes, optimize schemas and apply best practices for database design. • Work closely with project managers, analysts, and other developers to understand requirements and timelines. • Create and maintain comprehensive documentation for migration processes, code changes, and database configurations. • Provide training or support to the team to transition to the new database version. • Diagnose and resolve technical issues related to database performance and migration challenges. • Ensure data security and compliance with organizational standards throughout the project. QUALIFICATIONS: Technical Skills: • Strong proficiency in SQL Server (versions 2016 or later preferred). • Expertise in application development and maintenance. • Proven experience with data migration projects involving multiple databases. • Advanced skills in query tuning, performance optimization, and database profiling. • Experience with ETL processes and tools is a plus. • Knowledge of database security, indexing strategies, and normalization principles. Experience: • Minimum 5 years of experience as a SQL Developer or Database Engineer. • Hands-on experience with large-scale database migrations or upgrades. • Familiarity with legacy database systems and strategies for transitioning to modern platforms. Soft Skills: • Strong analytical and problem-solving abilities. • Excellent communication and teamwork skills. • Ability to manage multiple tasks and meet deadlines under pressure. • Detail-oriented with a commitment to delivering high-quality results. Exciting Benefits we offer: Market-leading Salary Medical Coverage – Self & Dependents Parents Medical Coverage Provident Fund Employee Performance-based bonuses Home Internet Subsidy Conveyance Allowance Profit Sharing Plan [Tenured Employees Only] Life Benefit Child Care Facility Company Provided Lunch/Dinner Professional Development Budget Recreational area for in-house games Sporadic On-shore training opportunities Friendly work environment Leave Encashment Disclaimer: At Contour, we attribute our success to the unique contributions of our diverse staff. We’re committed to fostering a culture of respect that thrives on the varied perspectives and experiences of all individuals we recruit, employ, promote, and compensate. Since day one, we’ve adhered to a policy that champions a work environment honoring the worth and dignity of each person while being free from all forms of employment discrimination. In our continuous effort to promote inclusivity, we extend our commitment to individuals with special needs by providing reasonable accommodations. We actively encourage qualified individuals with special needs to apply for the various openings within our company. Should you require assistance in completing the application process or have any inquiries regarding special facilities, please do not hesitate to contact our HR team. Your unique talents and abilities are welcomed and valued here.