Feeds:
Posts
Comments

About: JShah

Full Name
J Shah
Website
http://sqldbpool.wordpress.com
Details
I have 5 years of experience in database technologies. Responsibilities 1) Database design. 2) Installation of MS-SQL Server, Managing Multiple instances on one server. 3) Managing multiple servers with different configurations. 4) Database Engine, MS-SQL server SSIS, MS-SQL server Full-Text Search. 5) Managing Memory for Large Databases, Linking Servers, Configuring SQL Mail, Database Mail and SQL Server Agent Mail. 6) Configuring High Availability Database Mirroring, Log Shipping, Replication. 7) Backup and Restore of the databases, backup on tape and restore form tape and Disaster Recovery. 8) Security considerations for MS-SQL server, (SQL injections). 9) Automating Administrative Tasks. 10) Migration of the older versions to 2005. 11) Monitoring and Tuning for Performance. 12) Patch management for development, staging and Production databases. 13) Production Server Alert setup (Disk, Memory, Processor etc) using performance and monitor tool. 14) Database archiving task. 15) Writing stored procedures, functions and triggers. 16) MySQL Clustering setup on Linux Machine using Linux-HA Service and DRBD (Distributed Replicated Block Device). 17) Database Report design using Microsoft Reporting Service, Crystal Reports and BIRT (open source). 18) Capacity planning exercises to properly identify required hardware, software, database configuration/architecture necessary to support application need. 19) Data Modeling, schema design and review. 20) Tuning and debugging high performance, high availability databases. 21) Reviewing and applying database schema changes. 22) Creating a large number of replicas. 23) Replication setup in MySQL. 24) XML handling using MSSQL Server 2000/2005

Posts by JShah:

Older Posts »