OBJECTIVE

• A self - starter, innovative, constructive, and result oriented professional, seeking opportunity to work as a SQL Server DBA that will offer an opportunity for utilization of technical knowledge and further growth.

SUMMARY

• Over 7 years of experience that includes analysis, programming, support, installation, networking, and database administration.
• Proven abilities to direct and troubleshoot database administration and network administration as well.
• Physical and Logical database design, Development, Performance Tuning (with Profiler) and Query optimization (with Show Plan and Database Tuning Adviser).
• User Management, Security, Backup and Recovery.
• Well versed in implementing and administering Windows Server 2008, 2003, and NT 4.0, SQL Server 2008, 2005, 2000 and 7.0 and internetworking with TCP/IP.
• Including the back end development, writing stored procedures and triggers with Transact SQL (T-SQL),
• Worked with the development team in implementing Object Oriented, Client/Server applications using Visual FoxPro 5, Visual Basic 5 in the Environment of Windows 9x, Windows Server 2008, 2003, and NT 4.0, Novell 4.11, and SQL Server 2012, 2008/R2, 2005, and 2000.
• Strong working experience and knowledge with SQL Server Standby/Replication, Log shipping, Performance tuning, Backup/Recovery, Query Optimization and Security Management.
• Strong knowledge and working experiences as Database Administrator of MS SQL Server (7.0 & 2000, 2005, 2008/R2, 2012), MS Access 2000 & 2003, Sybase, Oracle.
• Strong knowledge and experiences administering Web Server (IIS-Internet Information Services) including installing, and configuring and monitoring.
• Good knowledge and working experience on Operating Systems (O/S) include Windows Server 2008, 2003, 2000, and NT 4.0, Windows 2000 professional, Windows XP Professional, and MS-DOS.
• Working experience also includes installing, configuring, and administering the above operating system
• Good knowledge and working experience in designing Network in Windows 2000/2003 server

TECHNICAL SKILLS

Database: SQL Server 2008/2005/2000 , MS Access 2003 & 2000, MySQL, Sybase, Oracle

SQL Tools: Query Analyzer, Profiler, Database Mail, SQL Mail, SQL Agent

Programming: SQL, T-SQL, Store Procedures, Trigger, Web Design, HTML, JavaScript, ASP, ASP.net

ETL Tools: SSIS/DTS, BCP, OSQL, ISQL

Reporting/Analysis Tool: SSRS (SQL Server Reporting Services), Crystal Report

Data Modeling: SSDD (SQL Server Database Diagram), ERWin, VISIO 2003/2007

Operating System: Windows NT4.0, Windows Server 2008/2003/2000 , MS-DOS, UNIX/Linux, VMware

Hardware/Storage: SAN, RAID

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Responsibilities:

• Installed, Configured, and Managed SQL Server 2012, 2008/R2, and 2005 in development, test, and production environment
• Installed and Configured SQL Server 2012 and 2008/R2 for testing different features and stability
• Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008
• Installed and Configured Operating Systems, Windows Server (2000 & 2003)
• Installed and Configured SQL Server Reporting Services (SSRS)
• Configured and Maintained Replications (Transactional)
• Configured Log Shipping as Standby database from Production database
• Upgraded databases from SQL Server and 2008/R2 to 2012
• Migrated MS Access 2000/97 databases into MS SQL Server 2000, 2005, and 2008
• Migrated Oracle 10g databases to SQL Server 2008
• Migrated MySQL 4.1.0 databases to SQL Server 2005 and 2008
• Applied SP (Service Pack) on SQL Server 2000, 2005, 2008
• Applied Patch on Windows Server 2003 Enterprise Edition
• Strong on database Performance tuning
• Writing T-SQL and Stored-Procedures
• Used DBCC to check database conditions and Rebuilding indexes as well
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• Data Modeling, developing E-R Diagram using ERWin, Visio, and SQL Server Data Diagram
• Backward & Forward Engineering with data modeling tools mentioned above
• Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Export & Import data from/to databases like Oracle, MySQL, and Access to/from SQL Server
• Generated Report using SSRS (SQL Server Reporting Services)
• Generated Report in Excel, html, and text as well
• Strong knowledge and working experience in Database Backup & Restore
• Experience with Point-in-Time Recovery
• Restored Database from backup
• Working experience and strong knowledge in disaster recovery
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Developed Different Maintenance Plans for database monitoring
• Monitor Server Activity, and solving problem as needed
• Monitor SQL Server Error Log, space usage

Confidential, New Carrollton, MD

Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2000, 2005 and 2008/R2 in development, test, and production environment
• Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008
• Installed and Configured Operating Systems, Windows Server (2000 & 2003)
• Installed and Configured SQL Server Reporting Services (SSRS)
• Configured and Maintained Replications (Transactional)
• Configured Log Shipping as Standby database from Production database
• Upgraded databases from SQL Server 7.0/ in testing and production environment
• Migrated MySQL 4.1.0 databases to SQL Server 2005
• Applied SP (Service Pack) on SQL Server 2000, 2005
• Applied Patch on Windows Server 2003, 2005 and 2008 Enterprise Edition
• Expertise in database Performance tuning
• Writing T-SQL and Stored-Procedures
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• Data Modeling, developing E-R Diagram using ERWin, VISIO, and SQL Server Data Diagram
• Backward & Forward Engineering with data modeling tools mentioned above
• Export & Import data from Flat file, CSV file, Oracle, MySQL, and Access to/from SQL Server Database using DTS, SSIS, and BCP
• Generated Report using SSRS (SQL Server Reporting Services)
• Generated Report in Excel, html, and text from database as well
• Strong knowledge and working experience in Database Backup, Restore and Point-in-Time Recovery
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Developed Different Maintenance Plans for database monitoring
• Monitor Server Activity, Error Log, space usage, and solving problem as needed

Confidential, Reston, VA

Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2000 in development, test, and production environment
• Upgraded databases from SQL Server 7.0 to 2000 in development, testing, and production environment
• Implementing business rules in Database.
• Setting up referential integrity to maintain data integrity.
• Creating stored procedures, triggers and other databases level constraints.
• Setting up user rights integrated with Windows NT security and AD
• Optimization and tuning by setting up appropriate indexes and regular data maintenance.
• Participating in database modeling and logical and physical design.
• Participating in the application development process and code reviews of database objects.
• Creating database design and development standards.
• Bench marked and run time improved production systems.
• Uploading of periodic data from remote sites.
• Documenting MS SQL Server database design, implementation and configuration.
• Developing scheduled task scripts.
• Installing and configuring MS SQL Server Service Packs applicable.
• Participated in Database Designing.
• Setting up MS SQL Server and database configuration parameters.
• Configuring MS SQL Server Clients.
• Developing and implementing DBA maintenance plan.
• Daily monitoring of MS SQL Server activity, error logs, NT event logs, space usage and security.
• Developing and testing a backup and disaster recovery Plan.
• Configuring and auditing MS SQL Server security.
• Managing database object permissions, user accounts and passwords.
• Administering NT Security for MS SQL Server.
• MS SQL Server performance monitoring and optimization.
• Analysis of MS SQL Server long-term performance trends.
• Creation of MS SQL Server database devices, databases and database objects.
• Scheduling and managing jobs on MS SQL Server.
• Monitoring jobs performance and impact on normal