Posted Sep 26, 2017 1 views
Job Description:
- Provide support for a large SQL Server Database environment.
- Administration of databases, including set-up, backup processes, documentation updates, monitoring and maintenance. Understand and expand the architecture of the Microsoft solution.
- 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.
- Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
- Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
- Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
- Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
- 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.
- Support the design and implementation of added functionality. Assist with Disaster Recovery considerations for the DBA team.
- 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).
- Database administration (Replication, design experience with RDBMS.
- DR: doing quality assurance of the database components released to production.
- Ongoing database performance tuning and upgrades, including: monitoring and evaluation of all database patches and service packs.
- Assist setting up clustered SQL Server Environment.
- Enforce DBA standards to all the stored procedure deployed to production.
- Provide operational support to the reporting database servers.
- Do daily, monthly health check of the server.
- Setup and manage the maintenance and backup plans, Setup jobs, give permissions, perform monitoring and tuning.
- Design and manage database import / export processes used to populate test databases and global data marts. Assist setting up mirroring and log shipping.
- Deploy and support DTS and SSIS packages. Transact SQL and stored procedure development.
- Research problems and recommend corrective actions. Assist management with resource capacity planning.
- Implement and enhance database security using proven methodologies.
- SSIS and SSRS.
Standard Duties:
- 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.
- Supervise and manage vendors and subcontractors.
- Translate technical terminology into business language according to audience.
- Support the management in appropriate staffing by participating in interviews and hiring of new staff.
- Guide and coach junior members of the team.
Skills
Job Details
7NSoft Systems (Pvt) Ltd
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?
Similar Job Titles
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Ali Aziz
CEO
Shopistan
Muzammil Baig
Digital Marketing Manager
IT Services Group
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Zohaib Ali
Marketing Manager
Digital Online Devices
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Aqib Irshad
Head of HR, Training & OD
FINCA
