About

• Having around 7+yrs experience in Database Designing and Administrating and Programming in SQL Server 2000, SQL Server 2005, and SQL Server 2008/2012.

• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services and T-SQL.

• Experience in implementing database backup/recovery strategy.

• Creation and maintenance of Databases, creating Roles and managing user permissions.

• Experience in Tuning SQL Queries & improving the performance of the Database.

• Proficient in developing Complex Stored Procedures, Indexes, Triggers, Cursors, T-SQL Statements, and User Defined functions, and Views

• Experience in Performance Tuning, Query optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.

• Performing data transfer.

• Migrating the databases using Scripts.

• Creating Scheduled jobs for various purposes.

• Creating partitioned tables and indexes.

• Maintaining archive logs, spaces for routine administration and alert and trace monitoring.

• Maintaining the space, monitoring the free space etc.

• Experience in implementing Log shipping, Mirroring and Replication.

• Conversant with all phases of Software Development Life Cycle involving System analysis, Database designing, development and implementation.

• Working with development team.

Services

As a database administrator, my responsibility includes handling the production and development databases. Following are the activities which defines my key responsibilities:

1. Ensuring the Backup of databases and updating the Backup Register.

2. Monitoring the database space and adding the datafiles in the database as per the requirement.

3. Exporting / Importing the various procedures, functions and triggers between databases (between production and development databases).

4. Working with the developers to perform the DBA related Activity.