Sql Server Database
Resume:
Raghu Veer
[pic]
****************@*****.***
Summary:
. 8+ years of reliable operational experience in MS SQL Server
****/******/****/****/**** Database Administration and Development.
. 2 + yrs of experience in administering oracle 9i, 10g and 11g
databases.
. Extensive experience in installation and configuration of MS SQL
Server 2012/2008 R2/2008/2005/2000 (64 and 32 bit) Clustered and Stand
alone environments as per the industry best practices and applying
service packs, hot fix and cumulative updates in Development/Test, QA,
UAT and Production environments.
. Installing/creating and configuring database in oracle 9i, 10g and 11g
in standalone and RAC as per the customer requirements in
Development/Test, QA, UAT and Production.
. Experienced in gathering analyzing business requirements and
implementing them to design server's architecture, forecasting
capacity planning of databases and allocating as per the criticality
of the applications.
. Provided guidance to development staff on creating, maintaining MS SQL
Server Database Objects.
. Experience in writing T-SQL (DDL, DML and DCL) for various database
administration activities.
. Experience in developing/optimizing Stored Procedures, Functions, and
Triggers.
. Administering and fixing database performance issues by using DBCC
commands, DMV's and AWR, ADDM, ASH Reports in SQL Server and Oracle
database respectively.
. Solid SQL Server Administration skills for various administrations
skills like backup strategies, setting up the type of recovery models
(simple, bulk and full) for databases depending upon the criticality
of the database disaster recovery.
. Good hands on experience in physical backup and logical backup of the
oracle database using RMAN and User managed backups and
Import/Export/Data pump respectively for disaster recovery.
. Recovering the databases in case of database corruptions and restoring
databases as per application team request in different environments.
. Responsible for creating Jobs/Maintenance plans and maintaining
schedules by using SQL Server Agent and monitoring them by using Job
activity monitor.
. Creating logins (AD and SQL Server authenticated) in SQL Server and
users in databases understanding requested roles and assigning only
desired roles and Privileges making the database highly secured.
. Created users and roles and granting privileges to both roles and
users as per the security best practices.
. Solid experience in implementing SQL Server Transparent Data
encryption for securing the backups.
. Successfully tested, implemented and administered Log Shipping and
Database Mirroring in MS SQL Server 2008/2005/2000 and used as backup
solution in case disaster recovery.
. Experience in implementing different types of Replication models like
Snapshot, Transactional and Merge Replication.
. Solid experience of implementing Partitioning of tables for better
query performance in very large database environment (VLDB's) and
moving data using sliding window technique to archived databases.
. Extensive experience in query optimization and tuning of T-SQL
queries/scripts and improving the performance of the queries by having
a right type of indexes (Clustered and non Clustered) on the right
column of a table and database performance issues using SQL profiler
(Dead Locks/ Long running queries), DMV's, database tuning advisor and
Activity Monitor.
. Monitoring performance issues by using TOP, VMSTAT, IOSTAT and PRSTAT
at the operating system level.
. Experience in creating alerts, configuring Database mail in SQL Server
and working with HPOVO alerting system.
. Extensive experience in developing and deploying SSIS packages using
file system and SQL Server deployment.
. Hands on experience in migrating databases from MSSQL Server 7.0 to
2000, 2000 servers to 2005 and 2005 to 2008/2008 R2 Servers in all
clustered and non-clustered environments.
. Extensive experience with Data modeling, logical and physical database
design using ERWIN tool.
. Knowledge in Windows Server Administration, RAID system, and SAN
Storage Technologies.
. Documenting the outline of the databases, server details
(configurations and passwords) issues raised during the life cycle of
application.
. Good communications skills with self-motivated and ability to think
outside the box and strong inclination for finishing job before the
deadline, has capability to learn new technologies quickly and
effectively.
SKILL MATRIX:
RDMS types and versions: SQL Server (2012/2008R2/2008/2005/2000), Oracle(
9i,10g, 11g (11.2.0.3)).
ETL: SQL Server Integration Services (2005/2008/2008R2)
Reporting: SQL Server Reporting services and Analysis services
(2005/2008/2008R2)
Operating Systems: Windows Server (2008R2/2008/2003/2000), Linux 9,10 and
11, Solaris 9 and 10 and Ubuntu.
Tools used: SQL Managment Studio, Visual Studio, Report Builder 2.0,Idera
Tools (Idera Backup and Performance monitoring), Foglight (Performance
Analysis and Litespeed), AVAMAR, IBM Tivoli Manger, proc mon, TOAD, SQL
Developer, TOAD, HPOVO, DBspi Monitoring Tool, ESX clusters, Legato Backup,
SQL Profiler.
Softwares: Microsoft Products(Word, Excel, Visio),Adobe.
Contact this candidate