SUMMARY:

• About 8 years of experience, Certified SQL Server Database Administrator/DBA looking for a SQL Server DBA position with opportunities to grow and contribute.
• Motivated and resourceful having professional experience working with SQL Server (2012/2008/2005/2000 ) in the areas of Installation, Configuration, Administration, Clustering technologies, Log shipping, Data Modeling, Maintenance, Performance Tuning, Security Management, Data Transformation using DTS/SSIS, Business Intelligence, Reporting Services, Developing Reports, Third Party Tools, developing and administering websites IIS.
• Monitor Server Activity, and solving problem as needed
• Monitor database metrics on daily basis
• Supporting clients/users on daily basis to support different issues
• Working with developers writing queries, and trouble - shooting performance related issues
• Worked on security, locking issues
• Worked on different issues like Backup, disks, performance, objects creation and management
• Used DMV, DBC, ALTER and other related T-SQL on daily basis
• Installation and Configuration:
• Installed, Configured, and Managed SQL Server 2012, 2008, 2005 & 2000 in development, test, and production environment
• Installed and Configured SQL Server 2012,2008 for testing different features and stability
• Database Upgraded (development, testing and production environment):
• SQL Server 2000 to 2005/2008
• SQL Server 2005 to SQL Server 2008
• Database Migrated (development, testing and production environment)
• Migrated MS Access 2003/97 databases into MS SQL Server 2000, 2005, and 2008
• Migrated Oracle 10g databases to SQL Server 2008 using SQL Server Migration Assistant for Oracle
• Migrated MySQL 5.0.15 databases to SQL Server 2008 using SQL Server Migration Assistant for MySQL
• Database Monitoring/Performance Tuning:
• Strong on database Monitoring and Performance tuning
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification. Monitor SQL Server Error Log, space usage
• Build a patch environment from scratch which include virtual servers database servers and web servers for testing purpose
• Applied SP patches and HOT Fixes on SQL Server 2000,2005,2008 r2.
• Applied Patch on Windows Server 2003 Enterprise Edition
• Managed Database clustering in SQL Server 2008 and Windows Server 2008 R2
• Installed, Configured and Maintained Database Mirroring, Log Shipping, and Replication
• Trouble shooting on daily basis
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Developed and Deployed Reports including Ad-hoc Reports

TECHNICAL SKILLS;

Other Reporting Tools used: Report Builder 3.0, 2.0

Data Modeling: Data Modeling tools used using Toad Data Modeler. Generated scripts. Backward & Forward Engineering for Logical and Physical Database Design

Database Programming: Wrote T-SQL, Trigger, and Stored-Procedures. Worked with Developers in writing codes and optimized queries

DTS/SSIS: Moving data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP Moved data from/to databases like Oracle, MySQL, and Access to/from SQL Server

Backup/Recovery: Strong knowledge and working experience in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery. Experienced with Database Crash and Recovery

Quick View of Tools used: Toad data modeler for SQL and Oracle, SQL Profiler, Business Intelligence Development Studio (BIDS) ERWin,Idera.

PROFESSIONAL WORK EXPERIENCE

Confidential

Responsibilities:

• Installed, Configured, and Managed SQL Server 2012 in development, test, and production environment
• Installed and Configured SQL Server 2012 SSRS to Upgrade the SQL server 2008 SSRS
• Create a perfect maintenance plan for backing up the user and system databases, optimize indexes and cleaning up the log and old history in SQL server 2012 Monitor the database backup activities and doing daily backup report for CommVult to ensure that the backups are successful and on time
• Experienced with Point-in-Time Recovery, Restored, Rebuild Database from backup
• Manage Active/Active Five node cluster in Windows server upgrading and patching the cluster nodes applied SQL2012 SP patches
• Used DBCC/DMV(dynamic management view) to check database conditions, rebuild indexes and other database Maintenance purposes Like checking Log and table space
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Deployed Reports and managed security of report server including folder level
• Apply the SP patches and cumulative hot fixes for 2008 and 2012 in development and production including Cluster nodes and VmWare SQL severs
• Consolidate SQL servers to reduce cost and improve efficiency by combing and reducing the SQL instances
• Trouble Shooting and Supporting Daily Operations:
• Supporting client/users on daily basis to support different issues, Trouble shooting database and application on daily basis, Work with developers and users to resolve database issue
• Strong on security and locking issues assign roles and creating users group in SQL server create SQL service account in active directory monitor user activities on daily basis, Strong on database Monitoring and Performance tuning Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification. Monitor SQL Server Error Log, space usage

Confidential, Washington, DC

SQL Server Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008 & 2005 in development, test, and production environment
• Installed and Configured SQL Server 2008 for testing different features and stability
• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Experienced with Point-in-Time Recovery, Restored, Rebuild Database from backup
• Installed, Configured and Maintained Database Mirroring including automatic fail-over option in SQL Server 2008
• Configured Log Shipping
• Clustering using SQL Server 2008
• Configured and Maintained Replications
• Used DBCC/DMV(dynamic management view) to check database conditions, rebuild indexes and other database Maintenance purposes Like checking Log and table space
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Deployed Reports and managed security of report server including folder level
• SSIS Package create, deploy and manage
• Moved data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server
• Oracle 10gR2/11gR2 databases to SQL Server 2008 R2
• My-SQL 4.1.0/5.0.15 databases to SQL Server 2008 R2
• SQL Server 2005 to SQL Server 2008/2008 R2.
• Strong Theoretical and Practical work experience on Conceptual, Logical, and Physical Data Model
• Worked on data modeling projects from starting to finishing, generated scripts for objects, Developed Relationship
• Backward & Forward Engineering for Logical and Physical Data Model respectively
• Trouble Shooting and Supporting Daily Operations:
• Trouble shooting database and application on daily basis, Work with developers and users to resolve database issue.

Confidential, Arlington, VA

SQL Server database Administrator

Responsibilities:

• Installation and Configuration: Installed, Configured, and Managed SQL Server 2008 /R2, 2005 & 2000 in development, test Environment. Installed, Configured and upgrade web sites. Installed and Configured SQL Server 2008 for testing different features and stability. Build and configure a patch environment from scratch which include virtual servers database servers and web servers, creating Databases installing services, Clients and web sites, IIS 6.5. Build and configure entire new environment. Applied SP patches on SQL Server 2000,2005,2008 r2
• Strong knowledge and working experience in Database Backup and Disaster Recovery, Refreshing backups, Detached and Attached Databases
• Trouble shooting on daily basis
• Experienced with Point-in-Time Recovery, Database Crash and recovery
• Database Monitoring/Performance Tuning: Daily monitoring of SQL Server checking the Database integrity
• Monitor SQL Server Error Log, space usage
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Managed Database Replication (Transaction and Merge)
• Trouble shooting on daily basis

Environment: MS SQL Server 2008, 2005, 2000, Windows Server 2003 Enterprise Edition and Windows Server 2008r2 Enterprise Edition

Confidential, Reston, VA

SQL Database Administrator/DBA

Environment: MS SQL Server 2008, 2005, 2000, Windows 2000 Advanced Server, Windows Server 2003 Enterprise Edition and Windows Server 2008 Enterprise Edition.

Responsibilities:

• Installation and Configuration: Installed, Configured, and Managed SQL Server 2008 /R2, 2005 & 2000 in development, test, and production environment installed and Configured SQL Server 2008 for testing different features and stability.
• Database Migrated: Migrated MS Access 2003/97 databases into MS SQL Server 2000, 2005, and 2008 Migrated Oracle 10g databases to SQL Server 2008 using SQL Server Migration Assistant for Oracle Migrated MySQL 5.0.15 databases to SQL Server 2008 using SQL Server Migration Assistant for MySQL.
• Database Monitoring/Performance Tuning: Strong on database Monitoring and Performance tuning. Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification. Monitor SQL Server Error Log, space usage.
• Patch Management: Applied SP and HOT Fixes on SQL Server 2000, 2005, 2008.Applied Patch on Windows Server 2003 Enterprise Edition.
• Database High Availability: Managed Database clustering in SQL Server 2008 and Windows Server 2008 R2 Installed, Configured and Maintained Database Mirroring, Log Shipping, and Replication Trouble shooting on daily basis.
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)Developed and Deployed Reports including Ad-hoc Reports Other Reporting Tools used: Report Builder 3.0, 2.0.
• Modeling: Data Modeling tools used using Toad Data Modeler. Generated scripts. Backward & Forward Engineering for Logical and Physical Database Design.
• Wrote T-SQL, Trigger, and Stored-Procedures. Worked with Developers in writing codes and optimized queries.
• Moving data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP. Moved data from/to databases like Oracle, MySQL, and Access to/from SQL Server.
• Strong knowledge and working experience in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery.

Confidential, Washington DC

SQL Database Administrator/DBA

Responsibilities:

• Installed and configured SQL Installed and Configure SQL Server 2000, and 2005 in test and production environment. Working experience and strong knowledge in disaster recovery(restore/ rebuild database from tape back up) Configured logShipping from production to standby server(running as a Replication server) Configured and maintained Replication.
• Assisted SQL developers to optimize SQL queries and Stored Procedures
• Grant internal/external developers to development servers, shares
• Created Backup strategy for production and development environment
• Database Backup & Restore.
• Scheduled jobs Setup and configure Database mail for notification purposes. Developed Database Maintenance Plan
• Monitor Servers activity, solving problem. Monitor and resolve Mantis bug tracker for client issues. Troubleshooting connectivity issues Permissions, etc with custom applications and SQL.SQL Server Error Log, space usage
• Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes
• Export & Import data from Oracle, MySQL, and Access Database including flat files like text, excel, and CSV files into SQL Server databases
• Extensive experience in using DTS, SSIS, BCP to import data from different sources of data into SQL Server Databases
• Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• Used DBCC to check physical and logical consistency of database and Rebuilding indexes
• Database Monitoring - Used CleverPath Dashboard to monitor and diagnose different problems