SUMMARY:

I am a qualified candidate can provide SQL Server Database Administration support for production and development environments and have strong Experience to perform database monitoring and tuning, database backups, migrations, and more . I am looking for a SQL Server DBA position which is fit with my knowledge and personality.

KEY SKILLS/EXPERTISE:

• Ability to tailor a system to meet specific organizational needs.
• Excellent communication and interpersonal skills.
• Ability to adjust with new environments.
• Have the ability to work as part of a team and independently
• Self - motivated, Detail-oriented, proactive in communicating progress and issues
• Able to manage time too effectively to meet deadlines and prioritize workload.

TECHNICAL SKILLS:

Experience & Knowledge: Installation & Configuration of SQL Server Software 2008R 2/2005/2000. Experience in Production, Test and Development Environment Monitoring, diagnosing problems Performance Tuning/Optimization Backup & Recovery. Security Management. Database Log Shipping Admin/Implementation. Database Mirroring Admin/ Implementation. Database Replication SQL Server Database Migration, upgrade. T-SQL, Store Procedures, Trigger, Functions, Working Experience with ASP, ASP.NET. Working experience with SQL Server Integration Services (SSIS) using ETL tools. Knowledge of SQL Server Reporting Services (SSRS)

Operating Systems: Working experience on Operating Systems (O/S) include Windows Server 2008, 2008 R2/2003, 2003 R2, Windows XP/7 Working experience also includes installing, configuring, and administering the above operating systems

Hardware/Storage: SAN, NAS

SQL Server Tools Used: SQL Server Management Studio, Enterprise Manager, Upgrade Advisor, Query Analyzer, SQL Profiler, Database Tuning Advisor and Index Tuning Wizard, Business Intelligence Development Studio, SQLCMD SQL Configuration manager

Third-Party Tools Used: SQL Doctor----Health check, Patch Analyze, backup Analyze, quick indexing (Defragment indexes), Diagnostic Tools, Administrative Tools., 2003/2007

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

Database Administrator

Responsibilities:

• Performs all duties as assigned and necessary. Capacity Planning for Servers and Databases
• SQL Server 2008, 2005 & 2000 in development, test, and production environment. Windows Server 2003, 2008
• SQL Server 2000 to 2005/2008/2008 R2 SQL Server 2005 to SQL Server 2008/2008 R2
• SQL databases into MS SQL Server 2000, 2005, and 2008
• Applied SP (Service Pack) on SQL Server 2000, 2005, 2008, 2008 R2 Applied Patch on Windows Server 2003, 2003 R2
• Create database users, implement privileges, grant user permission, and perform auditing.
• Strong on database Monitoring and Performance tuning Scheduled jobs to automate different activities such monitoring database health, disk space, job alert, index monitoring, stats monitoring etc
• Read and write T - SQL, Trigger, and Stored-Procedures Assisted Database Developers to optimize SQL queries and Stored Procedures
• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Experienced with Point-in-Time Recovery Restored Database from backup
• Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database Maintenance purposes as well
• Working experience with SQL Server Integration Services (SSIS) using ETL tools.
• Exported and Imported databases and database objects using Export/Import Wizard.
• Active involvement with capacity planning to plan for proper hardware based on growth patterns, database activity, and future project.
• Installed, Configured and Maintained Database Mirroring. Configured Log Shipping as Standby database from Production database for Reporting purposes. Database Replication: Snapshot and Transactional

Confidential, Washington, DC

Responsibilities:

• Working experience in Production & Development environments.
• Performs all duties as assigned and necessary. Involved in capacity planning, hardware & software requirements.
• Installation, Configuration, Upgrade SQL Server 2000, 2005 & 2008R2 Installed and Configured & Manage Operating Systems/Windows Server 2003 & 2008.
• Migrated databases from SQL Server 2000 to 2005 and 2005 to 2008 in test and production environment
• Develop plans for and be able to execute disaster recovery for SQL server database systems.
• Develop and maintain Database backup strategy.
• Monitor Database performance issues and Server issues.
• Troubleshoot the issues, implements preventive actions.
• Used DBCC to check physical and logical consistency of database Implementation and management of database security for users.
• Advocate proper data access and database maintenance.
• Write and Review store procedures to ensure optimal performance, security purposes and recurring tasks.
• Possesses a very good understanding of database architectural design, modeling and development methodology.
• Working experience with SQL Server Integration Services (SSIS) using ETL tools.
• Export & Import data from Oracle Database, MySQL, and Access Database including flat files like text, excel.
• Effectively articulate database requirements to non-database teams, document strategies to resolve business requirements using database structures.