| Job Title: |
|
Sr. Database Adminstrator |
| Category: |
|
Database Administrator (DBA) |
| Job For: |
|
Alumni |
| Total Positions: |
|
1 |
| Job Location: |
|
Islamabad |
| Gender: |
|
Both |
| Minimum Education: |
|
Bachelors |
| Career Level: |
|
Experienced Professional |
| Minimum Experience: |
|
1 Year10 Years |
| Required Travel: |
|
Not Required |
| Salary Range: |
|
PKR 0 to 0 per Month |
| Apply By: |
|
Feb 16, 2015 |
| |
|
|
| |
|
|
|
|
| Job Description: |
- Administration and maintenance of all SQL servers.
- Trouble shooting specific SQL Server BUGS and errors
- Supporting all development efforts by various development group
- On call support during off hours and weekends.
Skills Required:
- At least 1-3 years of experience as DBA of MS SQL Server (SQL 2000, SQL 2005 and SQL 2008).
- Experience in MS SQL Server installation, configuration.
- Strong understanding of major components of SQL SERVER architecture.
- Knowledge of SQL Server Net- library Architecture.Ability to resolve various network connectivity issues and problems.
- Strong knowledge of Microsoft SQL Server Replication.
- Experience in data modeling.
- Experience in setting up and maintenance of SQL Server LOG Shipping.
- Strong development skills (using stored proc, triggers, etc) for the purpose of development support.
- Performance monitoring and optimizing experience using Windows Performance Monitor and SQL Server Profiler.
- Strong troubleshooting skills for resolving various site performance issues and tuning.
- Understanding and basic administration of NT and windows platforms
- Ability to provide 24x7 support
- Manage Security for various production servers.
- Ability to design and implement Disaster recovery.
- Backup and restore strategy involving Complete database backup/restore, transaction log backup/restore
- Experience of working in an E-Commerce site.
- Thorough knowledge of Microsoft Cluster Architecture
- Experience with Visual Source Safe (VSS) for version control.
- Experience in schema design, stored procedures in SQL Server and integration with ASP .Net Applications.
- Hands on experience of SQL Query Optimization.
- Hands on experience of ETL operations in SQL Server.
- Hands on experience of Microsoft Full Text Search in SQL Server.
- Understanding of Reporting Services in SQL Server.
- Understanding of High Availability Solutions using SQL Server.
- Experience of UNIX system administration will be a plus.
- Basic Knowledge of Asp.net and PHP will be a plus.
- Experience with Visual Source Safe (VSS) for version control.
- Experience with DBARTISAN Change Manger a schema comparison tool.
- Experience with ERWIN for data modeling and system design.
- Experience with LOG EXPLORER Tool for capturing, reviewing and reporting on sessions and transaction on real time and backup SQL Server transaction Log files.
- Experience with SPOTLIGHT a performance monitoring tool.
About Allainet (Pvt) Ltd Allainet (Pvt) Ltd is a multinational IT startup company with the head office in Montreal, Canada and presence in 5 countries including United Kingdom, Dubai, Pakistan, India and USA. It was established in 1998 in Canada and has been present in Pakistan since 2005 with office in Islamabad. We are involved in bleeding edge IT technologies and are constantly working on innovative new ideas to make our mark in the IT industry globally. |
| Company Information |
|
|
Company Name: Allainet (Private) Limited
Company Description:
Allainet (Pvt) Ltd is a multinational IT startup company with the head office in Montreal, Canada and presence in 5 countries including United Kingdom, Dubai, Pakistan, India and USA. It was established in 1998 in Canada and has been present in Pakistan since 2005 with office in Islamabad. We are involved in bleeding edge IT technologies and are constantly working on innovative new ideas to make our mark in the IT industry globally.
Allainet's management consists of highly-qualified individuals who have worked with Nortel, Compaq, Newbridge, MCI, AT&T and many other well-known high-tech companies.
|
|
