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

Database Administrator SQL

Stature Solutions

ایک سے زیادہ شہر، پاکستان

درخواست بھیجیں

مئی ۰۱, ۲۰۲۰ شائع ہوئی 1 نے دیکھا

PKR. 80,000 - 300,000/Month

The SQL Database Administrator will play an integral role in the implementation of SQL development, acceptance, and production environment, working closely with multiple infrastructure teams. Ongoing production support of existing databases is the primary role. The SQL DBA will provide administration support for various critical applications such as Microsoft SQL Server and MySQL.

Job Responsibilities:

Monitors capacity and performance for production and non-production databases to ensure they are highly reliable, efficient, cost effective, and provide the required functionality
Seeks opportunities to improve database performance by identifying tuning measures and implementing them when appropriate
Tests upgrades/new releases of database software and related products. Assesses impacts to customers and the database environment
Plays major contributor role in the testing and evaluating of new database products and tools. This includes the determination of their applicability to the database environment
Provides database problem resolution support, including off-hours coverage, based on required business service levels
Actively participates in day-to-day interactions with various cross-functional teams of developers, DBAs and associate product managers
Analyzes designs, creates and implements databases, including access methods, device allocations, validation checks, organization and security
Designs data models, logical and physical databases, data dictionaries and schemas
Checking high availability and/or disaster recovery process logs which will depend on the solution (Clustering, Replication, Database Mirroring, CDP, etc.) that is being used
Verifying backups on a regular basis by randomly choosing one or two backups and trying to restore verify
Checking for service packs/patches that need to be installed on SQL Server from either a hardware, OS, DBMS or application perspective
Performing capacity planning to ensure there is sufficient storage for a specific period of time such as for 3, 6, 12 or 18 months
Reviewing the fragmentation for databases to determine if particular indexes must be rebuilt based on analysis from a backup SQL Server
Scheduling an official maintenance requiring health checks on all premium databases and servers
Developing and monitoring ETL processes

Qualifications:

Hands on experience administering SQL Server 2008+, Mysql 5.0+, Mongodb 3.0+
Expert knowledge of SQL and NOSQL architecture and concepts
Experience optimizing database solutions for multi-terabyte databases
Good knowledge of database backup and recovery scenarios
Good knowledge of database tools and utilities for performance tuning and administration
Must have experience writing and optimizing T-SQL, MySQL and MongoDB query
Must have experience writing scripts using PowerShell and/or Python
Must have experience with SQL Server Clustering, Always On Availability Groups, Log Shipping and Replication
Able to effectively work independently and within a collaborative team oriented environment using sound judgment in decision-making
Excellent communication skills, both verbal and written, with excellent analytical and problem solving skills
Organized and detail-oriented, able to work well under deadlines in a changing environment and perform multiple tasks effectively and concurrently

Experience / Education:

3 to 5 years as a SQL DBA for MS SQL Server
SSIS experience mandatory
Bachelor’s Degree in Computer Technology or equivalent experience
Experience with T-SQL, tables, views, constraints, triggers, functions, stored procedures
Experience in MongoDB and MySQL will be a plus.

مہارتیں

Automation Languages Command SQL Clustering MongoDB NoSQL SQL CLR MSSQL Transact-SQL PostgreSQL SQLite

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

صنعت:

انفارمیشن ٹیکنالوجی

شعبہِ افعال:

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

کل عہدے:

2 آسامیاں

نوکری کی شفٹ:

دوپہر

نوکری کی قسم:

مستقل

محکمہ:

Software & Web

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

اسلام آباد, راولپنڈی, پاکستان

جنس:

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

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

بیچلرز

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

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

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

4 سال

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

مئی ۲۵, ۲۰۲۰

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

مئی ۰۱, ۲۰۲۰

Stature Solutions

انفارمیشن ٹیکنالوجی · 11-50 ملازمین - اسلام آباد, راولپنڈی

پیروی کریں

Stature solutions has been serving valued investors, customers, business companies and individuals since 2002 and since our inception, we are continually raising our horizon and scope to cater to our customers need and to meet international standards. In this short time, we have served many valuable and treasured clients and are constantly in process of regenerating and revitalizing our skill set and expertise in accordance with changing international standards and trends to provide immaculate and spotless results and services to our clients.