Profile

confidential, Certified SQL Server Database Administrator with above seven 7 years of experience with detail oriented, analytical and troubleshooting experience in different Microsoft products like Windows Server 2000, 2003 and 2008, and SQL Server 2000, 2005, 2008/R2 2012 , AD Active Directory , data modeling including gathering and analyzing business requirement. Solid working experience in managing large databases in 24/7 environment including installation, backup/recovery, database high availability solution, developed and managed reports using SQL Reporting Services SSRS , Creating stored procedures, triggers, functions, constraints, Monitoring and Performance Tuning using DMV, DBCC, SQL Server native tools as well as third party tools like Idera, Foglight, RedGate and Toad Data Modeler .

Professional Summary:

• Installing, Configuring, Updating, Deploying and Administering Databases in Test, Dev and Production environment
• Installing, Configuring SharePoint server
• Experience working on SharePoint Crate site collection ,document Management, List, Form, Perform backup and restore
• Installing VM workstation and configure windows server
• Performed Data Modeling, database design, and developing E-R diagram using Toad Data Modeler
• Solid experience on Backward Forward Engineering
• Performance Monitoring and Tuning for Instance, Database, and SQL Query using execution plan, Profiler, Database and Index Tuning Tools
• Monitor Server Activity, Error Log, space usage, and solving problem as needed
• Third party tools used for Backup ,Restore and Performance tuning RedGate , Foglight and Idera SQL Diagnostic Manager
• Strong knowledge and experience in configuring and administering High Availability Solutions like Database Mirroring, Replication, Log shipping, and Clustering
• Knowledge and working experience on SSIS and DTS for data move and manipulation
• Proven experience on SQL Server Reporting Services, using SQL/T-SQL Scripting for customized Report Generation and Management
• Create, set-up, and manage Jobs for Database Automation like index management, fragmentation management, backup, statistics etc
• Managed Security and database Audit
• Applied Service Pack SP for Operating Systems.
• Migrated databases from other databases like Oracle , MS Access, and Sybase to SQL Server 2005 and 2008
• Upgraded SQL Server 2000 to SQL Server 2005/2008, and SQL Server 2005 to SQL Server 2008/R2, and SQL Server 2012
• Working experience in configuring and setup Database Mail Server for database mail notification
• Moved and deployed databases in test and production environment
• Experience in administering AD Active Directory /Domain and monitoring user activities
• Best in providing excellent customer support, dealing with user and upper level management
• Enjoy working in a team environment and independently as well

Environment: Windows Server 2000, 2003 and 2008, and SQL Server 2000, 2005, 2008/R2 2012 , AD Active Directory , SAN, Raid, IIS 6.0, Web Server etc.

Professional Work History

confidential

SQL Database Administrator DBA

Currently working in SQL DBA position performing database administrator job as well as supporting configuring and analyzing client systems , testing and implementing software upgrades maintaining security configuration and patches tracking performance from backend, troubleshooting issues and building Adhoc for databases using T-SQL , stored procedures , triggers, views, functions, constraints etc.

Main Responsibilities:

• Configured Operating System, Windows Server 2000, 2003 and 2008
• Installed and Configured SQL Server 2005, 2008/R2 and 2012
• Installed, Configured SharePoint server, SharePoint Site Collection, Sites, document Management, back up restore, List, Views, Office Integration, Version, Forms, Performance Tuning
• Installing VM workstation and configure windows server
• Migrated databases from Oracle to SQL Server 2008
• Upgraded earlier versions of SQL Server 2000 to SQL Server 2005/2008, and SQL Server 2008/R2 to SQL Server 2012
• Rebuild Servers Restore Recover from backups.
• Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, and Clustering
• Run SQL Script, write T-SQL/Windows PowerShell and creating Triggers, Stored-Procedures
• Worked with developers to tune-up performance of SQL and T-SQL query
• Created and managed database security, data encryption, and applied object level security
• Setup and configured Database mail for notification purposes
• Developed Database Maintenance Plan
• Used DBCC and Alter statements for different database Administration tasks like check database consistency, rebuild indexes, statistics, and other jobs
• Used DMV Dynamic Management View for different database Administration tasks like find backup history, indexes fragmentation, statistics, and status of different jobs
• Extensive experience in using SSIS/DTS, BCP to import export data from flat files, excel, MS Access, and Other OLEDB databases to MS SQL Server databases

confidential

Role: SQL Server Database Administrator

EDCS collects disability information and establishes the Certified Electronic Folder CEF . The disability information is collected during interviews, from the internet i3368/i3820 , and from data prop agate from the mainframe MCS, MSSICS, MBR, and SSR . Although EDCS allows most disability, claims to be established electronically, EDCS exclusions will require a paper folder. EDCS edits should not be confused with exclusions. EDCS internal edits are the result of an unanswered question on a specific EDCS page

Responsibilities:

• Performed server installation and configurations for SQL Server 2008r2, 2008 , SQL Server 2005 and SQL Server 2000
• Performed installation of SQL Server Service Packs
• Upgraded databases from SQL Server 2000 to SQL Server 2005 and 2008/R2
• Create Scheduled Full, Differential and Transactional log backups.
• Setup backup and restoration jobs for development and QA environments
• Created transactional replication for the reporting applications
• Implemented disaster recovery solution at the remote site for the production databases using Log Shipping
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases
• Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance
• Used SQL Server Profiler to monitor and record database activities of particular users and applications
• Used DBCC commands to troubleshoot issues related to database consistency
• Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions
• Used Data Transformation Services DTS /SQL Server Integration Services SSIS of SQL Server to populate data from various data sources, creating packages for different data loading operations for application
• Reviewed DB Scripts from the development team before releasing them into the Production

Environment: Windows 2000 /2003 Server, SQL Server 2008r2, 2008 , SQL Server 2005, SQL Server 2000,T-SQL, PL/SQL, Erwin , HTML/, XML.

confidential

This project is an online brokerage and banking application. System consists of various modules like Loan Submission, Banking, Loan Locking, Pricing, Re-Lock, Withdraw, Extend Loan Expiry, Ready to Fund, Funding, Closing, Interest calculations, Buy backs, Mortgages Re-finance and Payments, Investing, Lending and Planning etc. It also generates reports based on clients' loan status like loans missing collateral documents, loans purchased, loans pending conditions, loans pending settlement review, loans not cleared for settlement. Various components in the system running fortnightly on different servers to send notifications like loans expiry, locking, funding, fee payments etc

Responsibilities:

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance
• Perform SQL Server service pack and Windows Service pack upgrades
• Extensively worked on Enterprise Manager for managing the database
• Troubleshoot performance problems and fine-tuning of databases
• Involved in Index Analysis and Performance Tuning
• Converting DTS packages into SQL Server 2005 Integration Services
• Migrating SQL Server 2000 data bases into SQL Server 2005 and SQL Server 2008
• Recovering the databases from backup in disasters
• To analyze long running queries and tune the same to optimize application and system performance

Environment: SQL Server 2008 SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

-------