Database Administrator - SQL Server
Mmagnatec Systems, Pakistan
Job Description
We are looking for an experienced SQL Server DBA to join our team! As a SQL Server DBA you will be responsible for the implementation, configuration, maintenance, and performance of critical Microsoft SQL Server RDBMS systems. You will mass update data in tables and upload data received from 3rd parties. You will work on query result optimizations.
Duties and Responsibilities
Manage Microsoft SQL Server databases
Configure and maintain database servers and processes.
Monitor system's health and performance
Ensure high levels of performance, availability, sustainability, and security.
Analyze, solve, and correct issues in real-time.
Provide suggestions for solutions.
Refine and automate regular processes, track issues, and document changes
Assist developers with query tuning, and schema refinement, develop queries, update the database.
Perform scheduled maintenance and support release deployment activities after hours.
Requirements and Qualification
Must know SSIS (SQL Server Integration Services).
Must know Crystal Reports.
Must be able to write scripts / stored procedures.
Must be able to write indexes and should have strong knowledge.
2 years of experience as a SQL Server DBA or similar role
2 years of experience with Performance Tuning and Optimization (PTO)
2 years of experience with backups, restores, and recovery models.
1 year of experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
2 years of experience with Windows servers, including Active Directory.
Sense of ownership and pride in your performance and its impact on the company’s success
Critical thinker and problem-solving skills
Team player
Good time-management skills
Great interpersonal and communication skills
MCTS, MCITP, and/or MVP certifications are a plus
Familiarity with PHP and ASP.net programming languages will be a plus.
Job Types: Full-time, Contract
Job Specification
Database Design
Database Applications
Database Administration
PHP
ASP.NET
Database Replication