SUMMARY:

• Over 5 years of IT Experience in SQL Server database Administration, Design and Development and Support of Confidential SQL Server 2014/ 2012/2008 R2/2008/2005 in Development, Test and Production Environments.
• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2014/2012/2008 R2/2008/2005 on Clustered and Standby Environments.
• Database Management Systems (DBMS) experience in Installing, Configuration, Maintenance and Administration of SQL Server.
• Good experience working with the SQL 2012 new feature Always ON.
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments.
• Expertise in Database Backup and Recovery procedures point of time by using native and lit speed.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in using Performance Monitor, Profiler to identify Deadlocks, blocking, long running queries.
• Good experience in data (table) partitioning, filtered indexes, Policy based management.
• Migration from SQL server 2005 to 2008R2/2012 by using In - Place upgrade process and as well as side-by-side upgrades process, and documented the Upgrade Process.
• Expert in Data Extraction, Transforming and Loading (ETL) and migration of database objects from one server to another server and database to another database using DTS and SSIS.
• Experience in implementing different types of High Availability techniques: Replication models like Snapshot, transactional, Log shipping and Database Mirroring in Clustered Environment.
• Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and also expert in tuning Complex Queries.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMV’s and DMF’s, Reindexing, Updating Statistics and online indexing.
• Expertise on Business Intelligence Tools to Create SSRS Reports, and SSIS Packages.
• Extensively worked on Data and Backup compression in SQL Server 2008/2008R2/2012.
• Expertise in implementation of security models; Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
• Extensively used tools like SQL Profiler, Database Engine Tuning Advisor and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Worked on Cloud and Azure environment.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio (SSMS)

Data Warehouse Tools: MS SQL Server 2005/2008/2012 / Integration Services

Business Intelligence Tools: SQL Server 2005/2008/2012 Business Intelligence Development Studio

Programming Languages: T-SQL

Reporting Tools: SQL Server 2005/2008/2012 Reporting Services

Development Environment: Visual Studio 2005/2008/2012

Operating Systems: Windows XP/2003/2008 Server, Win 3.x/95/98, Vista, Win 7

PROFESSIONAL EXPERIENCE:

Confidential, MD

SQL Database Administrator (DBA)

Responsibilities:

• Managing and administering SQL server which include 2005/2008/2008 R 2/2012/2014.
• Migration and upgrade databases to different version.
• Managing the database server’s security as per the organizational policy standards.
• Managing all aspects of physical SQL Server database administration which includes: security setup and enforcement, ID creation, installations, upgrading, patching, troubleshooting and tuning.
• Manage regularly scheduled backups and database recovery.
• Implemented SQL Data Compression Using Sql server 2008 for Compressing Data, table compression Log Files.
• Created new database objects like Tables, Functions, Indexes, Triggers and Views using T-SQL in Development and Production environment for SQL Server 2012.
• Worked in Active passive cluster environment as a High availability solution.
• Recovered the System and User databases from suspect mode.
• Tuning queries which are running slow using Profiler by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Checking Database Health by using DBCC Commands and DMVS.
• Designed Data Integrator jobs with Error Handling and email notifications.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Development Servers and handling maintenance Jobs.
• Participating in 24X7 on call services.

Database Administrator

Responsibilities:

• Installed, Upgraded and Migrated from SQL server 2005 and 2008 to 2008R2 and 2012.
• Implemented and maintained Always ON new concept in SQL 2012.
• Worked in Active-Passive and Active-Active Cluster environment as a High availability solution.
• Used Policy Based Administration feature on SQL Server 2008R2 and 2012.
• Created new database objects like Tables, Stored Procedures, Indexes and Views using T-SQL.
• Created maintenance plan, automated jobs: backup, update statistics, rebuild index, reorganize Index, maintenance cleanup, history cleanup and notify operator tasks and email configuration.
• Tuning queries which are running slow using Profiler and Statistics using joins, indexes, updating and Statistics.
• Expert in Performance Tuning, Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security, permissions and integrity planning.
• Administered databases in the cloud.

SQL Database Administrator (DBA)

Responsibilities:

• Installed, configured, and maintained MS SQL server 2012 on Windows Server.
• Installed latest service packs and hot fixes.
• Performed back end support for customer relationship management (CRM) application
• Installed and maintained HA technologies log shipping, mirroring and replication.
• Created and maintained relational databases and database objects.
• Created indexes for fast data retrieval and improved performance.
• Monitored connections, investigated and resolved locking, blocking and deadlock.
• Created, customized and implemented backup strategies based on business need.

Database Administrator (DBA)

Responsibilities:

• Managed SQL server, assisted in installation, configuration, backup, recovery and upgrade servers.
• Designed and implemented backup strategies based on SLA.
• Designed and implemented database maintenance tasks.
• Trouble shooting performance issues such as blocking, deadlock, and DB resource contention.
• Ensure data integrity and identify potential data errors.
• Managing SQL server configuration manager.