SUMMARY

• Seven years of experience as a certified SQL SERVER DBA, experienced in installation, configuration, design, development, implementation and administration of different SQL SERVER environments (production, test and development)
• Proficient in SQL SERVER 2012, 2008R2, 2008, 2005 and 2000 on operating systems Windows server 2003, 2008, 2008 R2, 2012, Windows Vista, Windows 7, Windows 8 and VMware
• High level of energy, integrity and work ethics with an exceptional ability to deliver outstanding bottom line results
• Strong interpersonal and communication skills with the ability to work in a team as well as independently with minimal supervision
• Organized and able to manage multiple priorities

TECHNICAL SKILLS

Operating Systems: window server 2012, 2008R2, 2008, 2003 and 2000

Networking &Active Directory: TCP/IP, SMTP and HTTP

Storage Management: SAN and RAID

Tools: SSMS, SQL Profiler, Spotlight and Idera.

PROFESSIONAL EXPERIENCE

SQL SERVER DBA

Confidential, Chantilly, VA

Responsibilities:

• Installing, configuring, upgrading and monitoring MS SQL SERVER
• Monitor 24/7 production operations management (incident break/fix, change, service requests and vulnerability management)
• Perform Backup and recovery for user and system Databases. This includes establishing standards and schedules for Database Backups, verifying the Database Backup jobs and making sure that the Backup schedules meet the recovery requirements
• Restoring the Database in the event of failure/corruption including point in time recovery.
• Configure, maintain and support the SQL SERVER mirroring, log shipping, clustering and replication
• Monitoring and managing the SQL SEVER clustered environment and configured SQL SERVER clustering including load balance planning.
• Configuring AlwaysOn on test environment.
• Maintaining and monitoring DR sites and took the right step if needed.
• Creating database and Database objects like Tables, Stored Procedures, Views Triggers, user defined data types and Functions.
• Automating Job Creation, scheduling and monitoring tasks and alerts.
• Performing Database object migration between database Servers/instances, (e.g., development, testing, production) and between different versions.
• Upgrading Database from SQL SERVER 2005 and 2008R2 to SQL SERVER 2012.
• Installed, configured and deployed SQL reports using SSRS services.
• Automat, migrate and deploy SSIS packages.
• Configure linked server to run queries between SQL SERVERS.
• Extracting, transforming and loading (ETL) data from excel, flat file, MS access to MS SQL SERVER by using SSIS services and import\export wizard.
• Manage unexpected growth of transaction log files (LDF) of the Database.
• Responsible for database performance monitoring and tuning to identify performance issues. This includes ensuring that the server is running with optimal performance, monitoring event logs and error logs for the database server errors.
• Check SQL SERVER query execution plan like actual execution plans/ estimated execution plan.
• Perform capturing and troubleshooting blocking and deadlocking issues.
• Configure and set up the mail server for the database mail notification.
• Apply Database compression and backup compression when needed to release disk space.
• Work on DBCC commands and data management view (DMV) commands.
• Monitor space requirements of the Databases and if required added storage space.
• Manage SQLuser logins, Database user accounts, serverroles, Database roles and its permissions
• Develop database maintenance plans for various purposes, checked Database integrity, performed index maintenance, updated Database statistics, performed Database backups, shrink Database, maintenance clean up task and clean up history
• Managing Database in different recovery models (simple, bulk logged and full) as per the Database criticality and business requirements
• When performance issues came, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
• Documenting the company’s database related information

Environment: SQL SERVER 2012, SQL SERVER 2008R2, SQL SERVER 2008, SQL SERVER 2005, Windows Server2008, Window server 2003, Spotlight, SAN, RAID, Microsoft SQL ServerVisual Studio 2010, Microsoft SQL ServerVisual Studio 2008, MS Business Intelligence Development Studio 2008.

SQL SERVER DBA

Confidential, Vienna, VA

Responsibilities:

• Involved in installation, configuration and management of SQL SERVERinstances
• Created Database and Database objects like Tables, Stored Procedures, Views Triggers, user defined data types and Functions
• Performed Database object migration between Database servers/instances, (e.g. development, testing, production) and between different versions
• Performed Backup and recovery for user and system Databases. This included establishing standards and schedules for Database Backups, verifying Database Backup jobs and making sure that the Backup schedules meet the recovery requirements
• Configured and monitored high availability/disaster recovery strategies like log shipping, replication, mirroring and clustering
• Applied Database compression and backup compression when needed to release disk space.
• Used DBCC to generate statistics, reorganize and rebuild indexes
• Used profiler to identify the problematic queries to diagnose and take necessary actions.
• Managed SQLuser logins, Database user accounts, serverroles, Database roles and its permissions
• Configured, monitored and managed SQL SERVER clustered environment
• Monitored space requirements of Databases and if required adding storage space
• Managed 24 X 7 dedicated Databases
• Maintained and monitored DR sites and took the right step if needed
• Captured and troubleshoots blocking and deadlocking issues
• Worked on different recovery models (simple, bulk logged and full). Skilled to change and choose the recovery mode as per the Database criticality and business requirements
• Created maintenance plans to check database integrity, update statistics, reorganize index, Database Backup and clean up tasks for system and user Databases as required

Environment: Windows server 2008, Windows server 2003, windows server 2000, MS SQL SERVER2008, SQL SERVER 2005, SSRS, SSIS, Erwin, SQL SERVERProfiler, Database engine tuning Advisor, Upgrade Advisor

SQL SERVER DBA /HELP DESK

Confidential

Responsibilities:

• Installed, configured and managed SQL SERVER instances on different servers/platforms and applied patches and service packs to keep the database at a current patch level
• Performed Backup and recovery for the user and system databases
• Configured log shipping mirroring and replication for high availability and disaster recovery
• Implemented automated maintenance tasks and notifications such as rebuild, reorganize indexes and Database integrity checks etc
• Monitored server activities against database, Error Log and space usage
• Managed 24 X 7 dedicated Databases
• Created and managed the SQL server database users and logins with appropriate roles, monitored SQLSERVER security permission to users and groups
• Performed Database object migration between different environments and versions
• Upgraded SQL SERVER Database to a new version of the SQL SERVER database
• Developed Database maintenance plans for various purposes, checked the Database integrity, performed index maintenance, updated the Database statistics, performed the Database backups, shrink Database, maintenance clean up task and cleaned up the history
• Worked on different recovery models (simple, bulk logged and full). Skilled to change and choose the recovery mode as per the Database criticality and business requirements

Environment: SQL SERVER 2008, SQL SERVER 2005, SQL SERVER 2000, Windows SERVER 2008, Windows Server 2003, Idera, spotlight, SAN, RAID and Microsoft SQL SERVERVisual Studio 2005.