SUMMARY

• SQL Server DBA with 7+ years of IT experience in administration, analysis, design, development, testing, presentation and implementation experience using SQL Server 2008R 2/2008/2005/2000/7.0.
• Good Knowledge in installation, upgrade and configuration of MS SQL Server and databases in clustered and unclustered environments.
• Experience in T - SQL coding and testing: functions, views, triggers, stored procedures, etc.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity.
• Management of backup and restore, export and import, DTS and BCP utility.
• Experience in implementing different types of Replication Models
• Experience in creating packages, Scheduling Jobs, Sending Alerts using SQL Mail.
• Experience in SQL Server Integration Services (SSIS).
• Experience in Reporting Services.
• Experience in Log shipping with SQL Server 2000/2005/2008.
• Experience in Database Mirroring
• Experience in creating Maintenance Plan
• Experience in SQL Server Migration
• Documented disaster recovery plans and participated disaster recovery drills.
• Excellent interpersonal, analytical and communication skills.
• Good team player with strong analytical skills.

TECHNICAL SKILLS

LANGUAGES: C, T-SQL, PL/SQL, HTML, VB script, Java

RDBMS: MS SQL Server 2008R2, 2008, 2005, 2000, MS-Access

FRONT END: MS Visual Basic 6.0

OLAP TOOLS: MS OLAP Services Manager

WEB TECHNOLOGIES: XML, Java Script

OPERATING SYSTEMS: Windows 2000/2003/2008 Advanced ServerWindows NT 4.0 /3.51Windows 3.x,Windows 9.x

REPORTING TOOLS: Crystal Reports, Microsoft Reporting services

OTHER TOOLS: Idera Diagnostic Manager, SQL Defrag Manager, NetIq 3.0 SQL Monitor, Erwin 4.1, Lumigent Log Explorer 4.0, SQL safeLite speed, Datatect

HARDWARE: HP Proliants Servers, Compaq Servers, Dell Servers

WEB SERVERS: IIS 5.0 and IIS 6.0

PROFESSIONAL EXPERIENCE

Confidential, Wayne, PA

SQL Database Administrator

Responsibilities:

• Ongoing maintenance & administration of assigned systems
• Identifying the needs of clients and meeting these needs through proper data research
• Optimizing database performance through database performance tuning
• Configuring and validating database backup routines on a regular basis
• Assist with recovery of lost or corrupt data
• Ensure the integrity and security of data from unauthorized individuals
• Deploying and maintaining resilient data replication schemes
• Verify, maintain & troubleshoot database backups, integrity checks, and scheduled jobs.
• Copy databases and database objects between multiple servers across production, QA and development platforms.
• Assist with migrating SQL Server 2005 SP2 to SQL Server 2008
• Provide support to other developers and work with them to solve critical problems.
• Setting up and Troubleshooting clusters Application Center Clusters Performance tuning, and optimization of procedures and queries.
• Develop and document disaster recovery plan
• Resolving locking and blocking issues
• Performed daily support, troubleshooting, monitoring, optimization and tuning of server.
• Server & Application fine-tuning & trouble shooting. Monitoring SQL Server performance and network issues.
• Worked as a team member for 24X7 on call production support.

Environment: Microsoft SQL Server 2008\2005, Microsoft Windows Server 2003\2008, Dell PowerEdge R900, Data Synapse Grid Server

Confidential, Buffalo New York

SQL Database Administrator

Responsibilities:

• Install, maintain, and manage production, test, and development database environments.
• Develop, maintain, and perform various data loads and ETL processes.
• Responsible for ensuring database backups and restores to include scheduled testing and validation.
• Monitor and tune database performance, participate in capacity planning, including processing, storage, and back-up/recovery capacity.
• Monitor and maintain database security and usage.
• Develop database processes, scripts, and stored procedures.
• Develop, implement, and maintain corporate data architecture.
• Provide project estimates, plans, timetables, and acceptance testing guidelines for approved projects including upgrades to existing information systems or implementation of new information systems.
• Perform user support in various other areas as requested.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Configured Replication Server, worked on replication server.
• Experience using various DBCC commands like checkdb/checktable, showcontig, showstatistics etc. for checking database/table consistency and system performance.
• Data migration (import & export - BCP) from Text to SQL Server.
• Using DTS migrated the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
• Worked as a team member for 24X7 on call production support.

Environment: Windows Server 2008, Microsoft SQL Server 2008, Microsoft .NET Framework, Microsoft SQL Server 2008 Integration Services, Microsoft SQL Server 2008 Reporting Services, Dell PowerEdge Server R810

Confidential, Jacksonville, FL

SQL Database Administrator

Responsibilities:

• Analyze, design, code, test, implement, and maintain database software for complex applications of client-server based systems.
• Design, implement, and maintain high-performance, high-availability database architectures.
• Apply programming and project management tools, practices and standards to application development activities.
• Collect and produce 3rd party and original software configuration and installation documentation as appropriate, and provide data management support as needed.
• Implement data security practices for database applications to prevent the disclosure, modification or destruction of data.
• Monitor user and system activity logs; and maintaining data integrity for mission-critical databases.
• Work TEMPeffectively with users throughout application design, development and maintenance processes.Participate in troubleshooting user problems related to software, hardware and network usage.
• Resolve problems that involve database connectivity, data entry, software compatibility, and database server hardware failure.
• Installs, patches, upgrades, maintains, and supports the database in all environments.
• Implements database access procedures including the administration of User IDs.
• Assists in development and improvement of database administration-related plans, processes, procedures, standards and priorities.
• Worked as a team member for 24X7 on call production support.

Environment: Microsoft SQL Server 2008 Enterprise, Microsoft Office SharePoint Server 2007, Microsoft SQL Server 2008 Reporting Services,HP ProLiant DL785 server, HP StorageWorks MSA2000fc G2 SAN storage

Confidential

SQL Database Administrator

Responsibilities:

• Install, upgrade, configure, and tune SQL Server analytic environments
• Analyze relational and storage engine issues and provide appropriate solution
• Implement monitoring solutions for analytical environment
• Perform and Manage database backup and recovery Process
• Reviewed security consideration for SQL Server 2005 installation.
• Hands on experience with DTS/SSIS, Reporting and Analysis Services in 2005/2008.
• Analyzing workloads and their response time.
• Migration of DTS to SQL Server Integration Service (SSIS).
• Migration of Stored Procedures from .
• SQL performance tuning.
• Knowledge in Extended Stored Proc.
• Worked as a team member for 24X7 on call production support.
• Setting up Clusters in SQL server 2005/2008 (Active/Passive)
• Maintaining both DEV and PRODUCTION servers in sync.
• Setting up SQL Database Mirroring.
• Maintain reliability and availability of existing MS SQL environments.
• Suggesting Cost saving Techniques. Designing/ Implementing Backup policies for databases.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.
• Managed Login and User: adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Implement SQL Server Log Shipping.

Environment: SQL Server 2005/2000 Enterprise Edition, Windows Server 2003 Enterprise edition, Compaq Proliants Server.

Confidential 

SQL Database Administrator

Responsibilities:

• Install clustered and non-clustered SQL Server system according to best practices standards
• Backup and restore SQL Server Databases using 3rd party tool SQLsafe.
• Perform redirected restores of databases to Test, QA and development system.
• Install Service Packs on clustered and non-clustered SQL Server systems.
• Install and configure various SQL Server replication models using various topologies.
• Troubleshoot, diagnose, remedy and document SQL Server performance and other customer issues
• Upgrade and migrate SQL Server database
• Create procedures, scripts and for repeatable Administrative tasks
• Demand forecasting & capacity planning
• System monitoring & operational performance tracking
• Worked as a team member for 24X7 on call production support.

Environment: SQL Server 2005/2000 Enterprise Edition, Windows Server 2003 Enterprise edition, Compaq Proliants Server