Job Title: |
|
Senior Database Administrator |
Category: |
|
Database Administrator (DBA) |
Total Positions: |
|
1 |
Job Location: |
|
Lahore |
Gender: |
|
No Preference |
Minimum Education: |
|
Bachelors |
Career Level: |
|
Experienced Professional |
Minimum Experience: |
|
5 Years |
Salary Range: |
|
PKR 100,000 to 150,000 per Month |
Apply By: |
|
Dec 21, 2019 |
|
|
|
|
|
|
|
|
Job Description: |
This is a Technical position responsible for the configuration, installation, operations, support, monitoring and optimization and security of the Company’s databases. This position requires 5+ years of experience in MS SQL Database administration. Develop a methodology for the ongoing assessment of database performance and the identification of problem areas, memory leaks, long-running queries, resource usage monitoring.
Required experience/skills:
- Strong database administration skills; 5+ years of experience working with MS SQL Database, Cloud Server setup
- SQL Server installation, upgrades, migrations, and configuration
- Establishes databases, users, roles, and permissions
- Initiate, monitor, and troubleshooting
- Knowledge of indexes, index management, and statistics.
- Configure and maintain mirroring
- Install database service packs and cumulative updates as necessary
- Create SQL jobs to automate tasks
- Manage releases and perform testing
- Experience with management of data warehousing environments
- Develop a security scheme for the database environment, as well as assisting in disaster recovery if necessary.
- Proven experience in troubleshooting and resolving database problems.
- Proven experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
- Proven experience with backups, restores, and recovery models.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) and clustering options for SQL Server.
|
Required Skills: |
Database,Oracle,My Sql |
Company Information |
|
Company Name: Basecamp Data Solutions Company Description: We provide data management solutions for clients. We offer the cost benefits of offshore resourcing with the peace of mind and quality of dedicated local management. We design intelligent data management systems to maximize efficiency and robustness of client businesses. Our key business and systems analysts work with clients locally to develop the right data systems customers' need, not elaborate systems that hinder operational flexibility and efficiency. A major benefit our clients get with us is our local business and systems analysts match the client business needs with smart system designs to deliver optimal solutions for both short-term and long-term client goals.
|
|