• You have already applied to this job.
Database Administrator
 
Job Detail
Industry
Information Technology
Category
Database Administration (DBA)
Total Position
1
Job Type
Full Time/Permanent ( Third Shift (Night) )
Department
PS/IT
Job Location
Lahore
Gender
No Preference
Minimum Education
Bachelors
Career Level
Experienced Professional
Minimum Experience
3 Years
Apply By
Dec 27, 2020
Posted On
Sep 27, 2020
Job Description

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 worlds 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:
  1. Discovery sessions to identify, troubleshoot, document, and resolve database performance issues.

  2. Perform Query Optimization Tasks.

  3. Develop Complex SQL Scripts and Perform database archiving based on certain parameters.

  4. Develop stored procedures, views, custom functions, triggers, and cursors.

  5. Oracle to SQL transitions and vice versa

  6. Perform Database Schema comparisons – reference vs actual.

  7. Index utilization reporting

  8. Collaborate with Development Team, Application Support and QA teams to resolve database issues affecting application modules.

  9. Troubleshoot DB response times and tune queries accordingly

  10. Work with the Product Line Manager to ensure a strict adherence to our SLA and rule out items not coming under Maintenance Contracts.

  11. Communicate effectively with management.

  12. Develop good working relationships with internal teams.

Desired Skills and Qualifications:
  • Bachelors 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

    • Rebuilding indexes

    • 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]

  • 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

Contents and Compilation ©2020 Rozee.pk | ©2020 All other Rights Reserved to Contour Software (PVT) Ltd - a subsidiary of Constellation Software Inc.

Jobs in Pakistan