Database Administrator
Contour Software
Lahore, Punjab, PK
2d ago

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
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form