Description
Job Description:
SQL Server 2000 & SQL Server 2005 DBA
Installed and configured SQL Server 2000/SQL Server 2005
Worked with SAN Environment and good knowledge of SAN
Strong knowledge of Performance Tuning (includes usage of Profiler and other tools)
Strong knowledge of high availability solutions like cluster, replication, database mirroring required.
Strong knowledge to perform Disaster Recovery required
Provide technical support, consultation and guidance to project teams.
Strong knowledge of T-SQL required
DR Strategies, Capacity planning, design, DocumentationCertifications: Oracle Certified Professional 9i/10G Client Environment: SQLServer 2000, Enterprise Manager
Quest Foglight/Shareplex
Clustering, Backup software, Transact-SQL, DTS and other SQL Server tools and Unicenter
Skill and Experience Details:
-->Database Admin (L1)-Entry level position. Works under close supervision to perform low-leveldatabase management tasks such as adding users, managing space etc.Participates in testing back-ups, ensuring maximum up-time and maximumperformance of database. Familiarity with basic administrative commands isexpected at this level. Front-line interaction with users to assist with lowlevel trouble-shooting requirements.
-->Database Admin (L2)-A fully contributing team member who performs database management tasks suchas meeting user access requirements and resolving their problems. Responsiblefor ensuring that storage, archiving, backup and recovery procedures arefunctioning correctly. Writes database documentation, including data standards,procedures and definitions for the data dictionary with some generalsupervision. Front-line interaction with users to assist with escalatedtrouble-shooting requirements.
-->Database High Availability(L3)-Knowledge of HA (High Availability RAC/Cluster/Replication/DataGaurd/Standby/Database Failover strategy Database DR strategy/Flashback)
-->How is it setup and configured
--> What happens during a fail-over
-->What happens during fail-back, When is it typically done, What are the steps a DBA should perform in the event of a fail-over and fail-back
-->Database Performance Tuning(L2)-Performance & Tuning concepts
-->Concept of cache, configuring & troubleshoot,assign objects to cache
--> Indexes tuning and Design Adviser. Table and index maintenance
-->Database Backup and Recovery(L2)-Plan and Implement Backup and Recovery Methods Creating a Backup Plan & Recover
-->Identify type of data to backup, Point in time DB recovery using Roll forward
-->Archiving and retrieving logs and backup images from TSM and VERITAS.
-->Scheduling DB2 Partition Level Backup (RMAN/Native Tools)
-->Infra Storage Administration(L1)-Basic knowledge of Storage devices,RAID, Storage device connectivity,Networked Storage topologies,Storage protocols, Storage management,File Systems, Data
-->Management, Data backup and Data protection
-->MS SQL Admin(L2)-Understand New Features in SQL Server 2005 Data transfer and connectivitycommand list BCP, OSQL, ISQL, DTS Security
-->Creation of logins/users. Grant/deny permissions.
-->Advanced Database Maintenance work -- moving databasesbetween Servers, planning and sizing databases.
Configuration Management:
-->Goodknowledge of SP_configure, clear understanding of configuration parameters ofSQL Server at server level as well as database level.
-->Understanding Queryexecution plan Understanding of SQL Profiler & other Windows performancemonitoring tools, Performace counters, analysing profiler outputs RemoteAccess --Advanced -- Linked Server,
-->Querying linked server data TSQL --Advanced -- Writing complex queries/SP.
-->Resolving performance issues in SP/Queries.
-->Log Shipping -- Setup/Initialization/Failover Replication -- Setup/Initialization Connectivity Issues - resolving any connection issue to SQL Server like SSPI context error/SSL error. Handling
-->Fragmentation/Statistics/Index related issues related to slow performance.
-->Logical & Physical DatabaseDesign, normalization,
-->Codd's Rule Access Violation -- monitoring and troubleshooting any AV's in SQL Server. SQL Cluster Management Low Free MemoryBasic Log
-->Shipping Troubleshooting Basic Replication
-->Troubleshooting Installation of SQL Server instance on Cluster server.
-->Cluster Administration -- Understanding of Cluster Administration tool, Start/Stop SQL resources,Online/Offline Cluster Resources, getting SQL Cluster status usingquery(command line), moving resources between nodes. SQL Server Service Account Selection and Management, Network Connectivity, Lockdown ofSystem Stored Procedures, Schema, Encryption, Patchi