Trapeze North America, a division of Constellation Software Inc., provides enterprise solutions that consider the full 360 degrees of transport.
The company has grown its solution portfolio and global presence to become one of the world's leading companies of software solutions and intelligent transport systems.
Trapeze Group provides its solutions to public and private transport organizations and authorities across Europe, North America, and the Asia Pacific.
The Position :
As a database developer in our Client Care department, you will be working with internal teams and existing clients to troubleshoot database / application performance issues, query optimization tasks, data archiving.
This will also involve developing complex SQL queries, views, functions, troubleshooting and resolving issues with the data.
The chosen individuals will work as an extension of the Client Care department.
Primary responsibilities include :
Discovery sessions to identify, troubleshoot, document, and resolve database performance issues.
Perform Query Optimization Tasks.
Develop Complex SQL Scripts and Perform database archiving based on certain parameters.
Develop stored procedures, views, custom functions, triggers, and cursors.
Oracle to SQL transitions and vice versa
Perform Database Schema comparisons reference vs actual.
Index utilization reporting
Collaborate with Development Team, Application Support and QA teams to resolve database issues affecting application modules.
Troubleshoot DB response times and tune queries accordingly
Work with the Product Line Manager to ensure a strict adherence to our SLA and rule out items not coming under Maintenance Contracts.
Communicate effectively with management.
Develop good working relationships with internal teams.
Desired Skills and Qualifications :
Bachelor's Degree in Information Systems, Computer Engineering or equivalent technical Degree; or equivalent combination of education and experience.
Minimum 5+ years of programming or complex T-SQL scripting experience.
Experience using tools as TOAD, SQL Developer.
Ability to comfortably deliver training or conduct meetings in front of a group of people
Strong troubleshooting skills and analytical thinking to resolve issues.
Positive, proactive, take charge attitude and attention to detail.
Strong time management skills with the ability to meet deadlines for multiple, concurrent projects.
The candidate should have excellent verbal and written communication skills
The candidate may be required to work after-hours or on weekends up to 20% of the time
PowerShell experience for SQL Server and Azure.
Nice to have :
Basic Database Administration in SQL Server and Oracle
backup strategies / plans
VMware / ESxi administration
Basic understanding of Active Directory.
Understanding of mapping applications, ArcGIS, Google / Bing Maps
Work Shift : 5 : 00pm to 2 : 00am (Pakistan Standard Time)
Exciting Benefits we offer :
Medical Coverage Self & Dependents
Parents Medical Coverage
Employee Performance-based bonuses
Home Internet Subsidy
Profit Sharing Plan Tenured Employees Only
Child Care Facility
Company Provided Lunch / Dinner
Professional Development Budget
Recreational area for in-house games
Sporadic On-shore training opportunities
Friendly work environment