• You have already applied to this job.
Database Administrator

Job Type
Full Time/Permanent
Job Location
Assignment Detail
Information Technology
Database Administration (DBA)
Total Position
No Preference
Minimum Education
Career Level
Experienced Professional
Minimum Experience
2 Years
Apply By
Sep 29, 2022
Posted On
Jun 29, 2022

Job Description

Database Administrator

We are looking for an individual in the role of Database Administrator who will focus improving the efficiency of our infrastructure and availability of our applications. This person will assist the Primary Data Engineer in the management and oversight of our database infrastructure with a focus on Microsoft SQL server. This candidate must have strong analysis and troubleshooting skills with experience supporting enterprise class applications and infrastructure.

Duties and Responsibilities:

  • Assist senior data engineer to ensure smooth operations for database infrastructure; includes setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access
  • Install and configure SQL server and regular software updates
  • Provide system optimization as suggested by collected metrics.
  • Ensure hardware resource configurations are maintained to improve the performance of the systems, including file growth and disk space
  • Perform periodical audit of database access rights to prevent unauthorized access and compliance with regulatory requirements
  • Ensure that database backups are always current and available for production databases. Following policies and practices in place to minimize the risk of data loss
  • Routinely import & update vendor data (Demographics, Polygons, Neighborhoods, and Schools)
  • Copy production databases into non-prod systems for development cycles
  • Participate in on-call rotation schedule for systems support
  • Assist our customers and employees with application issues
  • Participate in the analysis and staging of SQL code for application deployments, through a release process and other various functions which support the system development life cycle

Required Skills:
  • Bachelor's Degree in Computer Science, Computer Engineering, or Information Systems + 2 to 3 years' experience
  • 2+ years' experience in Database Administration including:
  • 2+ years' of T-SQL programming
  • 2+ years' working with MS SQL Server 2012 and newer
  • 1+ years' experience with SQL Server analytics (Profiler, DTA, SSMS, PerfMon, DMVs, and system sprocs)
  • 1+ years' experience working Microsoft database cluster technologies (Always-On failover, clustering, or mirroring, log shipping, etc)
  • 1+ years' experience with .NET framework
  • Strong analysis and troubleshooting skills including experience with SQL Profiler & Management Studio
  • Proactive self-starter with the ability to take ownership of tasks through to completion
Desired Skills:
  • Certifications: Microsoft Certified Systems Administrator (MCSA) or Microsoft Certified Solutions Expert (MCSE)
  • Experience with identifying top resource-intensive queries and suggesting ways to improve performance at the query-level
  • Experience with SQL replication topologies for data transfer between systems
  • Experience with SSIS or similar tools for MS SQL data import/export
  • Experience with Solarwinds, SQL Sentry or similar system monitoring tools
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 ©2022 Rozee.pk | ©2022 All other Rights Reserved to Contour Software (PVT) Ltd - a subsidiary of Constellation Software Inc.

Jobs in Pakistan