SUMMARY:

• Certified with Microsoft professional SQL Server Database Administrator and have been discharging different SQL tasks for more than five years for different organizations on SQL Server 2012/2008R 2/2008/2005/2000.
• I have been working in data Migration, Consolidation and troubleshooting of SQL Server 2012/2008R 2/2008/2005.
• I was also working on high availability and disaster recovery solutions, and security.
• I am a keen and self - motivated professional looking for a stable position in a growing organization to utilize my experience and knowledge.
• In addition, I have been working in stressed environments, cooperative, team player and multi-task environments in timely manner.
• Installed, configured, deployed and administered SQL Server in clustered and stand-alone environments;
• Upgrade and migration of databases
• SQL Server security
• High availability solutions mainly mirroring, replication, log shipping, clustering and AlwaysOn.
• Performance tuning
• SQL Server Agent, backup and restoring of databases.
• Server Activity Monitor, SQL Server Error Log, Replmonitor, Mirroring monitor and others.
• Third party tools such as Spotlight for performance monitoring and Foglight for backup.
• SQL Server Integration Service (SSIS) and data transformation system (DTS) as well as SSRS
• SQL Server and Database audit configuration
• Maintenance plan, database mail, database operators and alerts.
• Documentations including the baseline for SQL server, clustering documentation
• Storage area network (SAN)
• Window Server 2012/2008R2/2008/2003
• 24/7/365 customer support

TECHNICAL ENVIRONMENT:

Databases: MS SQL Server 2012, 2008/R2, 2005,MS-Acess

Programming Language: Transact SQL

GUI: Import/Export, SQL Server Integration Services.

SQL Server Tools: SQL Profiler, Query Analyzer, Export & Import, DTS, SSIS, SSRS and SSAS

Operating System: Windows server 2012/2008/2003 Advanced Server, NT & Windows

Third party Tools: Foglight, Litespeed, spotlight

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

SQL Server DBA

Responsibilities:

• Monitor database performance and identify areas for optimization.
• Experienced in high availably solution, including clustering and AlwaysOn.
• Database migration and consolidation projects
• Experience in performance tuning, troubleshooting and query optimization
• Installation, configuration and deployment of SSIS, SSAS and SSRS
• Deploying software updates and patch management
• Managing data and log files
• Maintenance plans
• Back-up and recovery strategies
• Dynamic management views (DMV) and dynamic management functions(DMF)
• Database Tuning Advisor (DTA), profiler, extended events, Activity Monitor and Perfmon
• Used third party tools such as foglight, Spotlight, and Litespeed.
• Database and schema management
• Configured database mail, alert and jobs for the various backup, restore, maintenance plans
• Respond to customer calls, email, and tickets in a professional manner
• On call 24/7 support to databases on weekly rotation.

Environment: MS SQL Server 2012/2008R2//2008/2005, Windows Server 2008/2012 Operating systems, SSIS, and SSAS.

Confidential

SQL Server DBA

Responsibilities:

• Determining permission for effective Security
• Backup, restore and maintenance plan
• High availability and disaster recovery solutions like clustering, replication, mirroring and log shipping
• Installation of new servers and upgrade of existing servers with regard to service packs
• Developed, deployed and monitored SSIS Packages
• Stored procedures and functions in test and non-production environments
• SQL Server policy based management
• Data migration and upgrade
• Managed snapshot and merge replication
• Rebuild and reorganized fragmented indexes using DBCC and stored procedures
• Managed database mail and created jobs
• Engaged in the database design and changes
• Respond to customer calls, email, and tickets in a professional manner and resolve customer issues
• On call 24/7 support to databases on weekly rotation.

Environment: SQL Server 2008R2/2008/2005, Windows 2008R2/2008/2003 Server.

Confidential

SQL Server DBA

Responsibilities:

• Supported deployment of modules on Staging and then promoted to production servers
• Applied DTS-FTP (File Transfer Protocol) tasks to upload files in FTP after data churning
• Gathered end user requirements through meetings with manager and users
• Utilized joins and functions as appropriate to achieve project requirement
• Created triggers and constrains for the purpose of meeting business needs
• Communicated effectively with other staff to improve processes, solve problems and resolve conflict
• Administered all Production, development and test servers
• Identified all issues and reported to the project manager for resolution
• Worked in a large team environment, people with mixed skills
• Ensures successful, daily backups and guaranteed recoverability Responds to monitoring alerts and high severity problem tickets, applying analytical, problem solving, and resolution skills to handle scenarios
• Imported and Exported data from Excel, SQL server and text files
• Performed Data Scrubbing and Validation for implementation in production environment
• Produced custom reports as per business requirement for users at various levels
• Denormalized table for the purpose of running stored procedures in an efficient manner
• Implemented auto alerts, messaging & notifications

Environment: MS SQL Server 2008/2005, Windows Server 2003/2008