Valuepoint Systems is one amongst the top 100 IT companies in India. Valuepoint has been the chosen partner for providing IT Infrastructure, Integrate it as well as maintain it over its complete life cycle. Our core business lies in enabling clients to setup and run businesses and critical applications. Our innovative range of solutions helps our clients leverage their business and sustain a global advantage.
Our solutions span across the entire technology lifecycle. From design to setup and management of your infrastructure. And in every realm of technology, from computing architecture to networks, security and much more.
SQL DBA Professionals - Pune
10/5/2016 4:35:20 AM
SQL DBA Professionals
This is in regard to an Job Opening for SQL Server DBA with 5 - 8 years experience.
JOB DESCRIPTION :
Analyze the current database environment to identify:
i. System maintenance problems
ii. Space utilization (fragmentation)
iii. Memory Utilization (buffer utilization and setups)
iv. Object maintenance issues
1. File structure availability
2. Data Dictionary consistency (CHECKDB and CHECKCATALOG)
3. Index Reorganization
4. Table Reorganization
vi. Databases or tables not In use
vii. Records candidate for archival
viii. Tables in need of indexing
ix. Stored procedures
1. Utilization and capacity
i. Document all items from the Analysis, as well as:
1. Current System State
2. Current standards
a. Number of tables
c. Last used.