Job Overview
Keenly Digital is on hunt for a professional Microsoft SQL Server (MSSQL) Database Administrator (DBA) with a skill set of designing, implementation, maintenance, and performance of SQL Server databases. If you have what it takes to be an ace level Database Administrator, waste no time to apply and join our fast growing team of database engineers.
Requirements:

• At least Bachelor's degree in Computer Science, Information Technology, or related field.
• Proven experience as a SQL Server Database Administrator or similar role.
• In-depth knowledge of SQL Server database management and administration.
• Strong understanding of database design principles and normalization.
• Proficiency in SQL query optimization and performance tuning.
• Experience with database security and access control.
• Familiarity with high availability and disaster recovery solutions.
• Excellent problem-solving and troubleshooting skills.
• Strong communication and collaboration skills.

Responsibilities:
Installation and Configuration:

• Install SQL server software on appropriate hardware and operating systems.
• Configure SQL server settings including memory allocation, connection limits, logging, and authentication methods.

Database Design and Schema Management:

• Design and create databases and schemas based on business requirements.
• Optimize schema design for performance and scalability.
• Manage database objects like tables, indexes, views, and sequences.

Backup and Recovery:

• Implement backup strategies to ensure data protection and disaster recovery.
• Perform regular database backups and test restoration processes.
• Configure and manage SQL server s built-in backup tools like Job and Maintainance plan.

Monitoring and Performance Tuning:

• Monitor database performance, resource utilization, and query execution times.
• Identify and troubleshoot performance bottlenecks.
• Tune SQL server configuration parameters for optimal performance.

High Availability and Replication:

• Configure and manage replication for data redundancy and failover.
• Set up streaming replication, logical replication, or synchronous replication.

Automation and Scripting:

• Develop scripts and automation tools for routine tasks like backups and maintenance.

Troubleshooting and Incident Response:

• Investigate and resolve database-related issues such as data corruption and performance degradation.
• Document troubleshooting procedures and maintain a knowledge base for future reference.

Disaster Recovery Planning:

• Develop and maintain disaster recovery plans and procedures.
• Test disaster recovery plans regularly to ensure effectiveness.

Collaboration and Teamwork:

• Collaborate with cross-functional teams, including developers, system administrators, and network engineers.

Documentation and Training:

• Document configurations, procedures, and best practices.
• Provide training and support to developers and stakeholders on Postgre SQL usage and administration.

Benefits

• Competitive salary
• PTO and Sick leaves
• In-Patient Health insurance
• Provident fund and EOBI
• The work/life setup you need to be successful.
• A creative, collaborative, supportive environment that gives you the autonomy to explore new ideas, grow your skill set and create outstanding results
• The chance to make a genuine impact on the company’s growth
• Plenty of challenging work and the opportunity to stretch yourself
• The opportunity to work with amazing talent in a fast-growing company that really values their team.

Salary Package: Starting at 300,000 PKR
Office Timing: 9am to 6pm (Mon-Friday Pakistan time)
Job Type: Full-time
Pay: From Rs300,000.00 per month
Application Deadline: 01/09/2024