یہ کمپنی اب اس نوکری کیلیۓ مزید سی ویزنہیں لے رہی۔

Database Administrator

Global Engineering Services

فروری ۰۳, ۲۰۲۰ شائع ہوئی 11 نے دیکھا

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

مہارتیں

Database Performance Tuning Stored Procedures MySQL RDS

نوکری کی تفصیلات

صنعت:

برقیات

شعبہِ افعال:

ڈیٹا بیس انتظام (DBA)

کل عہدے:

1 اشاعت

نوکری کی شفٹ:

پہلا پہر

نوکری کی قسم:

مستقل

نوکری کا مقام:

لاہور, پاکستان

جنس:

کوئی ترجیح نہیں

کم از کم تعلیم:

بیچلرز

ڈگری کا عنوان:

BSCS

کیریئر کی سطح:

تجربہ کار پیشہ ور

کم از کم تجربہ:

8 سال

اس سے پہلے درخواست دیجیۓ:

مارچ ۰۴, ۲۰۲۰

تاریخِ اِشاعت:

فروری ۰۳, ۲۰۲۰

Global Engineering Services

برقیات · 1-10 ملازمین - لاہور

پیروی کریں

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 manufacturing company. It provides services globally to various clients in several areas including, ASIC Design and Verification, Systems Design, PCB Designing, CAM Engineering and Electronic Manufacturing.Having such a wide range of highly integrated services, we offer a unique combination that has culminated in our joint success. With a dedicated team of EE's and ME's conducting all Design, Part Selection, Simulation and Ibis Modeling, a Superior Materials Management Group, and an Exceptional Manufacturing Staff, augmented by our brand new state of the art RoHS compliant manufacturing equipment, we remain heads above the rest. Unlike our competitors, all of our services offered are in-house making us the correct choice as your â��time sensitive partner'./p