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:
Excelergy, part of the Harris Group of companies, is a world leader in high performance software solutions that optimize the customer care and billing processes in competitive retail energy markets. Our flagship product, Excelergy RevenueManager, is proven world-wide and supports multiple commodities through the entire customer lifecycle — from prospecting, to customer acquisition, customer service and billing — in residential, commercial and industrial markets.
The Position
As a DBA at Excelergy, you will be responsible supporting our database environments for customers as well as online systems for the development, operations team and professional services team. You will manage data in multiple systems across multiple data centres and provide expert guidance on the day to day operations and tuning of development, test and production systems with 100's of terabytes of data.
The Software Developer will report to the Director, Technology. It is envisioned, however, that the individual in this position should have a large amount of autonomy and not require large amounts of day-to-day support. This position may include some after hours and weekend support when necessary.
This position has access to sensitive data, therefore the successful candidate must have a high level of accountability and adhere to Corporate Compliance and Security.
Key Responsibilities
Perform application support, and Database (Microsoft SQL Server and Oracle) maintenance tasks.
Develop procedures and scripts for continuous improvement, repeatable processes and database maintenance.
Ensure consistency and completeness across customer systems.
Research technical problems and assist in identifying solutions.
Interact with application teams and client personnel on technical issues.
Coordinate database changes with technical team, projects team and management,
Provide expertise in SQL tuning, backup and recovery support, installation and configuration of Microsoft SQL Server & Oracle, patch installation, table and index partitioning, data archiving, database capacity planning, and complex security architectures.
Write SSRS reports and Power BI solutions.
Monitor and maintain database backups, optimization jobs, and integrity checks. Take corrective action as required.
Perform database performance tuning, query optimization, reports, jobs and processes.
Provide guidance and direction for new technology adoption.
Assist in leading the technical direction for Database Administration by coordinating and presenting technology solutions to Group Leads, Team Leads, Managers, and the client.
Participate in detailed design and product test execution as required.
Identify and initiate process improvements.
Identify and acquire industry technical and business knowledge.
Other projects and duties as required.
Education/Experience
Bachelors in Computer Science or Information Technology or equivalent work experience.
2-7 years of experience providing database administration services in the Windows environment.
Strong problem solving skills, including the ability to analyze complex problems and create well documented solutions.
Experience with Microsoft -SQL Server.
Proficient in T-SQL, PL/SQL and writing complex SQL.
Experience with instance configuration and tuning and query tuning.
Experience with database upgrades and patches.
Experience with database backup and recovery procedures.
Experience with writing PowerShell scripts.
Experience with SSIS packages.
Experience with SSRS.
Experience with Power BI solutions.
Sound knowledge in advanced concepts such as database replication, materialized views, stand-by database(s), etc.
Excellent written and verbal communication skills, interpersonal skills, and multi-tasking capabilities.
Ability to work under pressure both independently and within a team, in a fast paced environment.
Experience with Oracle 12c
Azure SQL Database
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.