Major Responsibilities:

  • Administration of databases, including set-up, backup processes, documentation updates, monitoring and maintenance. Understand and expand the architecture of the Microsoft solution.
  • Provide support for a large SQL Server Database environment.
  • Resolve and provide solution to technical issues arising in the production environment.
  • Design and implementation of database replication strategies for both internal and DR requirements procedures. Determine, implement, and manage database backup and recovery strategies, with focus on PIT recovery.
  • Support the design and implementation of added functionality. Assist with Disaster Recovery considerations for the DBA team.
  • SQL Server (troubleshooting, debugging, tuning and optimization of SQL queries and stored procedures).
  • DR: doing quality assurance of the database components released to production.
  • Support in the implementation of quality awareness in delivering efficient and cost effective services.
  • Support in development, implementation and ensure adherence of policies and procedures.
  • Maintain documentation and Configuration Management database (CMDB) for data accuracy.
  • Continuously discover, evaluate, and implement new tools to maximize efficiency.
  • Translate technical terminology into business language according to audience.
  • Support the management in appropriate staffing by participating in interviews and hiring of new staff and Guide and coach junior members of the team.

Major Requirements

  • Bachelor’s degree in information technology, computer science or related field
  • 5 plus years of experience in relevant role.
  • Demonstrate excellent verbal and written communications skills and effectively collaborates with other team members and project stakeholders.
  • Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems and experienced in (SSIS), (SSRS) and (SSAS).
  • Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
  • Proficient with SQL server profiler for monitoring , troubleshooting database activity and Database administration (Replication, design experience with RDBMS
  • Extensive experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage.
  • Knowledge of other databases like MySQL, No SQL databases and In-memory databases.
  • Sound knowledge in Security standards and Microsoft recommendations. Performance tuning & database optimization.
  • SQL Server (troubleshooting, debugging, tuning and optimization of SQL queries and stored procedures).

Job Details

Functional Area:
Total Positions:
1 Post
Job Shift:
First Shift (Day)
Job Type:
Job Location:
Gender:
No Preference
Minimum Education:
Bachelors
Career Level:
Experienced Professional
Minimum Experience:
4 Years
Apply Before:
Jun 22, 2019
Posting Date:
May 21, 2019

7NSoft Systems (Pvt) Ltd

Information Technology · 11-50 employees - Karachi

Legacy to the Cloud Founded in 2004 by visionaries from leading technology organizations, MLOGICA’s leaders envisioned a faster, more efficient way of modernizing IT infrastructures to eliminate the skyrocketing costs of legacy systems that had stymied innovation and eaten away at enterprise profitability for years. They also realized modernization offered their customers the opportunity to harness the power of globally dispersed data to build revenue. mission is to assist its customers in driving enterprise profitability through advanced analytics and Cloud modernization. Helping customers unravel the complexities of migrating mission-critical, enterprise applications, databases, infrastructure, and data—while saving them time, money and business disruption is how we do it.

What is your Competitive Advantage?

Get quick competitive analysis and professional insights about yourself
Talk to our expert team of counsellors to improve your CV!
Try Rozee Premium

Similar Job Titles

Database Engineer

Pakistan Single Window, Karachi, Pakistan
Posted Apr 09, 2024
I found a job on Rozee!