Microsoft Certified Professional seeking a SQL server DBA position with new challenges and opportunities to build upon my extensive knowledge and experience in MS SQL Server in the areas of Database Management/Administration, Development, Maintenance, Performance Tuning, Security, Data Transformation and Business Intelligence. Experience covers all aspects of database administration, Database Design/development, and Supporting MSSQL Server 2008/2005/2000 including data modeling, developing database objects including stored procedures, triggers, views, functions, constraints, developing and managing reports using SQL Server Reporting Services. I hold more than 6 years of experience as a SQL Server DBA and a team-player with excellent analytical, interpersonal, problem solving and communication skills.

Quick Profile

• Industry Focus: MS SQL Server DBA in Information Technology
• Job Title: SQL Server Database Administrator
• Experience: 6 Years
• Current Job: Prince William County School System
• Work Authorization: U.S Citizen
• Security Clearance: Clearable

Level of Education

• BS in Computer Science

Certificates

MCITP: Microsoft Certified IT Professional (DBA - SQL Server 2008)

Highlights of Technical Expertise:

Database Management:

• About 6 years of Relational Database Management System experience in different environments, Development, Test, and Production Environment (7.0 & 2000, 2005, 2008)
• Writing SQL/T-SQL, Triggers, Stored Procedure and working with developers in writing queries and debugging codes
• Reporting Services:
• Expert on Reporting Server/Services (SSRS) including installation, configuration and administration
• Developed and managed reports
• Managed security of users and reports
• Monitoring, diagnosing problems, and Performance Tuning
• Expert and experienced as a Database Administrator of MS SQL Server (7.0 & 2000, 2005, 2008)
• Strong work experience Database High Availability Solutions with SQL Server Database Mirroring, Standby/Replication, Log shipping
• Solid experience on Backup and Disaster Recovery
• Upgrading SQL Server 2000 databases to SQL Server 2005/2008 and SQL Server 2005 to SQL Server 2008
• Migrating to MS SQL Databases from Oracle, MySQL and MS Access Databases
• Familiar with DB2 and Sybase Database environments

Networking: Managing User accounts in Active Directory, Managing File Server, Backup Server, Configuring Network using ROUTER, SWITCH/'
Data Modeling:

• Worked on more than 8 Information Systems for data modeling
• Tools used for Data Modeling: SQL Server Database Diagrams, Visio, Erwin, Oracle SQL Developer
• Reporting Services:
• Expert on Reporting Server/Services (SSRS) including installation, configuration and administration
• Developed and managed reports
• Managed security of users and reports

Hardware: SAN, NAS, RAID

Operating Systems:

• Good knowledge and working experience on Operating Systems (O/S) include Windows Server 2003, Windows 2000 server, Windows 2000 Advanced Sever, Windows 2008 Server professional, NT 4.0, Windows XP Professional, and SMS-DOS. Windows 7 Professional
• Working experience also includes installing, configuring, and administering the above operating system

Programming:

• SQL, T-SQL, Store Procedures, Trigger, .NETkl and ASP.NET

Database Tools Used

SQL Server:

• SQL Server Management Studio (SQL 2005 & 2008), Enterprise Manager (SQL 200),
• Upgrade Advisor
• Query Analyzer
• SQL Profiler
• Database Tuning Advisor and Index Tuning Wizard
• Business Intelligence Development Studio
• SQLCMD
• Reporting Services Report Manager, Reporting Services Configuration and Report Builder
• SQL Configuration manager

Third-Party Tools Used:

• Data Modeling:
• ERWin, Visio, Toad Data Modeler
• Database Administration/Management:
• Idera SQL Admin Toolset
• Toad for SQL Server DBA
• Spotlight

Professional Experience

Current Job

Confidential, Jan, 2007 - Present
Woodbridge, VA

Database Administrator/DBA

Responsibilities:

• Installed, Configured, and Administered SQL Server 2000, 2005 & 2008 in development, test, and production environment.
• Installed, Configured and Administered Database High Availability Solutions using SQL Server Fail-Over Cluster Servers, Database Mirroring, Replication and Log Shipping in 2005, 2008 and 2000
• Migrated databases from SQL Server 2000 to 2005/2008 and 2005 to 2008 as well.
• Wrote SQL/T-SQL, Stored-Procedures and Triggers
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Monitoring and Performance tuning database & indexes
• SQL Server Error Log, space usage.
• Monitor Servers activity, solving problem.
• Created Backup strategy for production and development environment.
• Worked database backup and disaster recovery
• Rebuild Databases from backup (Restore & Recovered from media backup)
  Developed Database Maintenance Plan for different maintenance tasks
• Used DBCC for different database maintenance tasks and Rebuilding indexes
• Worked on Data Modeling projects for designing 4 systems
• Designed Logical & Physical Database using ERWin.
• Backward & Forward engineering using ERWin.
• Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints , Views, Stored Procedures, Triggers.
• ETL: DTS & SSIS:
• Solid experience with Import/Export Wizard, DTS Designer, DTSRun, DTSRunUI, and SQLAgent
• Transform data— Transform Data task, Data Driven Query task, Parallel Data Pump task
• Copy and manage data— Bulk Insert task, Execute SQL task, Copy SQL Server Objects task, Transfer Database task, Transfer Logins task, Transfer Master Stored Procedures task
• Run tasks as jobs from within a package— ActiveX Script task, Dynamic Properties task, Execute Package task, Send Mail task, File Transfer Protocol (FTP) task
• Analysis Services processing task
• Export & Import data from Oracle Database, MySQL, and Access Database including flat files like text, excel, and CSV files.
• Migrated MS Access 2000/97 databases into MS SQL Server 2000 and 2008
• Migrated Oracle and MySQL Databases to SQL Server 2005 and 2008

Confidential, Jan, 2005 - Nov, 2006
Alexandria, VA

Database Analyst/DBA

Responsibilities:

• Installed, Configure, and Administered SQL Server 2000, and 2005 in development, test, and production environment.
• Installed, Configured and Maintained Database High Availability Solutions using Replication and Log Shipping in SQL Server 2000 and 2005
• Configured and Administered Database Mirroring in SQL Server 2005
• Database Backup & Restored.
• Upgraded SQL Server 7.0 and 2000 databases to SQL Server 2005
• Migrated Oracle, MySQL, and MS Access 2000/2002/2003 databases to MS SQL Server 2000 and 2005
• Wrote SQL/T-SQL, Stored-Procedures and Triggers
• Monitoring and Performance tuning
• Monitor Servers activity, solving problem.
• SQL Server Error Log, space usage.
• Index tuning and Rebuilding
• Assisted SQL developers to optimize SQL queries and Stored Procedures.
• Created Backup strategy for production, test and development environment
• Worked on Backup and Disaster Recovery
• Created and Scheduled different jobs for backup and other different database maintenance tasks
• Developed Database Maintenance Plan.
• Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes.
• Data Modeling using ERWin.
• Designed Logical & Physical Database using ERWin.
• Backward & Forward Engineering using ERWin.
• Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints , Views, Stored Procedures, Triggers.
• Export & Import data from Oracle Database, MySQL, and Access Database including flat files like text, excel, and CSV files.
• Imported data from Oracle, Excel, Flat file, CSV file to SQL Server Database.

Security Clearance: Clearable
Citizenship: US Citizen
References: Available upon on request