Apply For This Job

Close

Job Description

Senior Database Administrator

Company Overview 

Tazteq is a worldwide provider of IT and Enterprise software solutions, based in Lahore Pakistan with a Head Office in Silicon Valley, USA. We are looking for a Senior Data Base Administrator  to help us achieve our mission of automizing small-medium businesses in Pakistan.

 Job Mission:

The Senior Data Base Administrator  position will be responsible for maintaining the company’s database including back-up, stored procedures, performance tuning, capacity planning, monitoring critical events and documentation.

Key Areas of Responsibility: 

  • Create and manage multiple databases and assist in capacity planning 
  • Monitor, maintain database systems and troubleshoot problems that may arise
  • Maintain data integrity and security (manage roles and permissions of database users)
  • Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them
  • Develop strategies and implement solutions for managing back-ups, restoration and replication
  • Create and manage constraints and indexes
  • Support software developers with database operations including the development of complex SQL, tuning of DML, creation of stored procedures, and migrating changes from dev to higher environments 
  • Proactive housekeeping/archiving and shrinking of databases
  • Manage production, QA and development database environments
  • Create detailed documentation including diagrams of database infrastructure 
  • Learn relevant business processes and understand the data flow, criticality and dependencies
  • Effectively coordinate and communicate with all the stakeholders (internal teams and clients)
  • Set up and maintain database infrastructure for the company’s BI needs

Requirements / Qualifications: 

  • Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems
  • Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) will be a plus
  • Experienced in ETL (Extract-Transform-Load) development / data integration
  • Sound knowledge of RDBMS concepts, database architecture, and SQL/T-SQL
  • Proficient with RDMBS profiler for monitoring and troubleshooting database activity and performance
  • Hands-on experience in setting up, monitoring, and managing databases on AWS RDS
  • Knowledge of other databases like No SQL databases and In-memory databases and MCTIP     certification will be an advantage.
  • Ability to develop procedure documents and maintain detailed database related documents
  • An innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies

Education: Bachelors or Master’s degree in computer science 

Experience: 8 years

Location: Lahore

Shift: Morning (09:00 AM – 06:00 PM)

Gender: No Preferences

 

What benefits do we offer?

  • Health and life insurance
  • Provident fund
  • Annual bonus
  • Paid leaves
  • Company sponsored social events
  • Inhouse Gym and recreational activities

Job Details

Industry:
Total Positions:
1 Post
Job Shift:
First Shift (Day)
Job Type:
Job Location:
Gender:
No Preference
Minimum Education:
Bachelors
Degree Title:
BSCS
Career Level:
Experienced Professional
Minimum Experience:
8 Years
Apply Before:
Mar 03, 2020
Posting Date:
Feb 03, 2020
Show fewer details Read full job description

What is your Competitive Advantage?

Get quick competitive analysis and professional insights about yourself
Talk to our expert team of counsellors to improve your CV!
Try Rozee Premium

Global Engineering Services

Electronics · 1-10 employees - Lahore

pGlobal Engineering Services is an Engineering and Manufacturing Services company headquartered in Lahore, Pakistan. Since opening our doors in 1999, we have developed a reputation for consistently delivering quality on time. Global Engineering Services is an ASIC, Systems, and PCB architect and man ...Read More

Similar Job Titles

CRM Database Administrator

QuickStart, Karachi, Pakistan
Posted Jan 22, 2020

Database Administrator

Gourmet Foods, Lahore, Pakistan
Posted Feb 15, 2020

Database Administrator

MTBC, Multiple Cities, Pakistan
Posted Feb 15, 2020

Database Administrator

Croem Pakistan, Multiple Cities, Pakistan
Posted Feb 03, 2020
View All