Database Administrator

Job Description

Responsible for demonstrating database administration, advanced performance analysis and tuning skills. Design and development of database, data warehouse and multi-Dimensional database.

Job Responsibilities

Areas of Responsibilities:

• Design and develop databases, data warehouses and multidimensional databases.
• Design and implement measures, measure groups, granularity, calculated measures, and aggregate functions.
• Implement cubes and implement and configure dimensions in a cube.
• Develop reports using prescriptive analytics and predictive modelling using regression, classification, and clustering techniques.
• Configure authentication and authorization for reporting solution.
• Implement interactivity in reports and configure report data sources and datasets.
• Implementation, Management and Maintenance of SQL database server and other storage devices.
• Performance Monitoring and Tuning of Database Server and other storage devices.
• Routine Maintenance including Log Management and Monitoring.
• Optimization of Storage.
• Establishing standards and schedules for database backups using System Centre Data Protection Manager.
• Recording, developing, and ensuring backups, their schedules and test recovery & restoration procedures for each database.
• Managing Database Users and Security.
• Supporting Development Teams with RDBMS related Issues.
• Perform the role of the principal designer responsible for complex systems and their subsystems employing deep knowledge of current technology and tools, as well as relevant systems that already exist.
• Monitoring performance and managing parameters to provide fast responses to end users.
• Maintain documentation and procedures to ensure adherence to database / data storage / data backup policies, procedures, and regulations.
• Ensure the availability of database backups both onsite and offsite.
• Controlling access permissions and privileges. ETL, moving data, merging data, etc.
• Provide required database management, operations, and support and upgradation capabilities for the IT Department.
• Incorporate changes in database structure by following proper change and experience in data preparation, visualization, analysis, and dashboard development using Tableau/ MS Power BI.

Qualification and Experience:

• Bachelor’s degree (Hons) in IT, Computer Sciences or Software Engineering or any other relevant / similar degree from a recognized university; and
• 3 years’ post qualification experience in the relevant field including at least two years’ experience in public sector.

Note: Experience in private entities shall be accepted if such entity is registered with SECP, Registrar of Firms or any other Public Sector Regulatory Authority.

Competencies & Personal Attributes:

• Experience in SSAS, SSRS and SSIS. Experience TSQL/PLSQL programming.
• Experience in Artificial Intelligence and Machine Learning using Python.
• Experience of MS SQL and MYSQL tuning.
• Knowledge of computing, and Storage systems using System Center Data Protection Manager.
• Experience in data preparation, visualization, analysis, and dashboard development using Tableau/ MS Power BI.
• Strong leadership, team building and problem-solving abilities.
• Inquisitive and detailed oriented with strong analytical skills.
• Excellent communication skills, i.e. written and verbal.

Appointment:

Appointment shall be made by Director General on the recommendations of the Contractual Employment Committee.

Salary and Benefits:

SPPP-4 + any other benefit admissible to SPPP-4 as mentioned in Schedule-III

Degree Level

• MS/M-Phill (18 years)
• Masters/Bachelors (Hons) (16 years)
• 18 Years of Education
• 16 Years of Education

Degree Area

• Computer Engineering/Sciences
• Computer Networks
• Information Technology
• Software Engineering
• Computer Engineering/Sciences 1
• Software Engineering 1

Required Skills

• Analyze, Design and Implement Database Structures
• Database Architecture & Design
• Database Management
• Database Tuning
• SQL Databases Design

Required Tools

• AQL Server
• JQuery
• HTML
• XHTML
• CSS
• .NET
• MVC
• Web API
• SOAP
• WCF
• API Programming
• Web Programming
• Java Script
• Mysql
• Sql
• Oracle
• ASP
• PHP
• JSP

---