Database Administrator & Developer (SQL Server)

• Position Overview

The SQL Server Database Administrator & Developer is responsible for designing, developing, administering, and maintaining SQL Server databases across development, test, and production environments. The role combines hands-on database development (T-SQL, stored procedures, performance-tuning) with operational DBA responsibilities such as backup/restore, high availability, replication, and monitoring.

Key Responsibilities

Database Development

• Design and develop database objects including tables, views, stored procedures, functions, triggers, and indexes.
• Write efficient T-SQL queries, optimize slow-running code, and improve database performance.
• Collaborate with application developers to optimize SQL queries and schema.
• Support data modeling and database design activities for new applications.
• Create and maintain ETL processes, data transformations, and integration tasks (SSIS preferred).

Database Administration

• Install, configure, and maintain SQL Server instances (2012–2022).
• Manage database security: logins, roles, permissions, encryption, and auditing.
• Plan and manage capacity, performance, growth, and storage utilization.
• Perform regular database health checks and maintenance tasks (index rebuilds, updates, checks).

High Availability & Disaster Recovery

• Configure and maintain SQL Server high availability solutions:
• Always On Availability Groups
• Failover Clustering
• Log Shipping
• Replication (Transactional / Merge)
• Implement robust backup and restore strategies, including point-in-time recovery.
• Participate in disaster recovery drills and documentation.

Monitoring & Troubleshooting

• Monitor database performance, resource utilization, I/O, and query execution plans.
• Troubleshoot SQL Server errors, performance bottlenecks, and service outages.
• Implement monitoring and alerting using tools like SQL Server Agent, SCOM, SolarWinds, or native cloud tools.

Deployment & Automation

• Support CI/CD pipelines for database deployments (DevOps).
• Create and maintain automation scripts using PowerShell or T-SQL.
• Manage version control for database objects.

Collaboration & Documentation

• Work closely with developers, DevOps, infrastructure, and QA teams.
• Document database architectures, operational procedures, and schemas.
• Provide on-call support for production incidents when required.

Qualifications & Skills

Education

• Bachelor’s degree in Computer Science, Information Technology, or related field (preferred).

Technical Skills

• Strong expertise in Microsoft SQL Server (2012–2022).
• Advanced T-SQL skills for development and performance tuning.
• Experience with high availability technologies (AGs, Clustering, Replication).
• Strong understanding of indexing strategies, query plans, and performance tuning.
• Familiarity with SSIS, SSRS, or other ETL/reporting tools.
• Experience with PowerShell for automation (preferred).
• Knowledge of cloud-based SQL services (Azure SQL, AWS RDS, GCP Cloud SQL) is a plus.

Soft Skills

• Excellent troubleshooting and analytical skills.
• Strong communication and documentation capabilities.
• Ability to work independently and manage multiple tasks.
• Strong problem-solving and team collaboration skills.

Job Type: Full-time

Application Question(s):

• What is your current salary? (In PKR)
• What is your expected salary? (In PKR)
• How early you can join us? (In Days)
• If offered job in Bagh AJK, are you willing to relocate?

Work Location: In person