Database Administrator
Contour Software
Lahore, Punjab, PK
3d ago

The Division

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

Updating statistics

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 :

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

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

Report this job

Thank you for reporting this job!

Your feedback will help us improve the quality of our services.

My Email
By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
Application form