SUMMARY:

• Microsoft Certified professional with over five plus years of proven experience in Administering and Managing of MS SQL Server Databases in Production and Non - production environments. Primarily Concerned with Managing the SQL Server Relational Database Management Systems Hosted on 2000/2005/ 2008/ 2008 R2/ 2012 Servers Running on Physical and Virtual Hardware Platforms in a 24 X 7 Environment using SQL Native Tools and Third party products. Excellent Experience of Team Player plus have capability to Work under stress full environment under minimal or no supervision.
• Managed Installation, Upgrade, Configuration and Administration of MS SQL Servers ( 2012, 2008/R2, 2005 and 2000 ) in Standalone & Clustered Servers.
• Hands on Experience on Database Administration and Support of MS SQL Servers in Production, testing, QA and Development environments.
• Involved in Designing, Reviewing and Creating Primary objects like Views, Indexes, Stored Procedure, Functions, Triggers Based on Logical Design Models, User Requirements and Physical constraints.
• Experienced in Administering SQL Server Security by Creating User Logins with Appropriate Roles, Monitoring the User accounts, Creation of groups, Granting the privileges to users and groups.
• Profound Experience in Database Backup, Recovery and Disaster Recovery strategies.
• Experienced in Implementing of High availability solutions like Log Shipping, Mirroring, Replication and Clustering.
• Experienced in Set Up and Performing Database Maintenance Plans, Scheduled and Automated SQL Server Jobs, Configured Database Mail, Created Alerts, Operators and Notifications.
• Established Remote MS SQL Servers as Linked Servers for fetching data.
• Experienced in Installation and Configuration of BI tools SSIS, SSRS and SSAS.
• Experienced in SQL Server Upgrade/Patching and Data Migration from MS SQL Server 2005 to 2008R2 and/ or 2005/2008R2 to MS SQL Server 2012.
• Experienced on DTS/SSIS Import Export Data from Various Sources, Bulk Insert, Log Shipping, BCP and DTS/SSIS Packages and Creating DTS.
• Experienced in 24/7 environment of technical Supporting of Troubleshooting and Resolved SQL Server and Database Related Problems including but not Limited to application, CPU, Memory, I/O and Disk Space.
• Provided a 24/7 Dedicated support for users in Production, Development and Testing servers and Responded on Tickets based on Requirements.
• Hand on Experience in MS SQL Server Performance Tuning and Monitoring Tools like Database Engine Tuning Advisor, SQL Server Profiler, Activity Monitor, Windows Performance Monitor, Confidential, Store Procedures, Client/Server Connectivity and DMVS.
• Articulated a very good Communication and Interpersonal Skills, Improved helping Mentality with an Excellent team Sprit.

TECHNICAL SKILLS:

RDBMS: MS SQL Server. DATABASE TOOLS SSMS, SSCM, SSDT, SSIS, SSRS, SQL Profiler, Activity Monitor, Database Engine tuning Advisor, Enterprise Manager, Query Analyzer, Oracle SQL Developer

LANGUAGES: SQL, T-SQL, Power shell.

APPLICATION: Visual Studio, Third Party SQL Server Performance Monitoring Tools (Spot Light And Red Gate), Microsoft Office Programs, Statistical Software Packages (SPSS, Genstat, GGE Biplot,)

PROFESSIONAL EXPERIENCE:

SQL Server DBA

Confidential, Chantilly, VA

Responsibilities:

• P erformed Installation and Configuration of SQL Server 2012/2008/2008 R2 and Applied Patches and Service Packs.
• Involved In Designing, Reviewing and Creating Primary Objects like Views, Indexes, Stored Procedure, Functions, Triggers Based on Logical Design Models, User Requirements and Physical Constraints.
• Configured and Supported SQL Server Log Shipping, Database Mirroring, Transactional and Snapshot Replication.
• Rebuild and Reorganize Indexes on Tables to Reduce Fragmentation and Enhance SQL Server Performance.
• Implemented in development of automated daily, weekly and monthly SQL server agent jobs such as but not limited to Database backup, Integrity checks, Indexing Maintenance and Update statistics.
• Setting/Configuring Automation Jobs, Alerts, Notifications, and E-Mails for System Errors, Fatal Database Errors, Disk Space Report and Hardware Error.
• Administered SQL Server/Database level Security and utilized Auditing and Data Encryption according to requirements.
• Deployed periodic reports based on the statistical analysis of the data using SSRS.
• Established Remote MS SQL Servers as Linked Servers for fetching data.
• Worked on Data Base Migration and SQL Server Upgrading from MS SQL Server 2005 To 2008R2 and /Or 2005/2008R2 to MS SQL Server 2012.
• Routine DBA Responsibilities Such as Temp db management, log file size management, Table partitioning, User Creation, Lock and Unlock user Accounts.
• I nstalled and configured of SQL Server Analysis Services (SSAS ), Reporting Services (SSRS ) and Integration Services (SSIS).
• Performed Routine DBA Responsibilities Such as Table Space Creation, User Creation, Lock and Unlock account.
• Evaluated Performance related issues like CPU, Disk I/O and Memory using Performance Monitor and improved the SQL server performance.
• Monitored, troubleshoot, Optimized and fine-tuned databases' Performance issues using, Stored procedures, Database Tuning advisor, SQL server Profiler, Activity Monitors, Confidential and DMVs.
• Fine tuned slow running T-SQL queries using Execution Plan and Database engine tuning advisor.

Environment: MS SQL Server 2012/2008R2/2005 64 bit, Windows Server 2003/2008/2012 , T-SQL

SQL Server DBA

Confidential

Responsibilities:

• Installation and Configuration of SQL Server 2005/ 2008/2008 r2 and Applied Patches and Service Packs to Keep the Database at Current Patch Level.
• Created and Managed Stored Procedures, Indexed Views, User Defined Functions, Triggers, Database Constraints to meet Business requirements and Policies.
• Involved with Various Business Groups while Developing their Applications, Assisting in Database Design, Installing SQL Server Clients, Phasing from Development to Production environment.
• Tested Improved SQL Scripts and Deployed them to Production environments.
• Automated and Enhanced Daily Administrative Tasks like Space Management, Hard Ware Errors, Fatal Database Errors, Object Alteration, Backup & Recovery and Performance monitoring .
• Export and Import Data from Other Data Sources like Flat Files Using SQL Server Import/Export Wizard and SSIS.
• Performed Database migration and SQL Server Upgrading from Ms SQL Server 2005 to 2008r2.
• Designed and Implemented Comprehensive Backup Plan and Recovery procedures.
• Configured and Supported SQL Server Log Shipping, Database Mirroring, Transactional and snapshot Replication.
• Managed SQL Server Security Including Implementation of SQL Logins, Roles, Authentication modes and SQL Server Audits for Various Users.
• Planed, Designed and Scheduled Database Maintenance & Administrative Tasks on a Daily and Weekly basis and Follow up and Troubleshoot problems.
• Monitored, troubleshoot, Optimized and fine-tuned databases' Performance issues using Database Tuning advisor, SQL server Profiler, Monitors, Confidential and DMVs
• Evaluated Concurrency issues (blocking and dead lock) in SQL server by using DMVs, Trace Flags, SQL alert, Store procedures, Confidential, and Activity monitor; and Resolved by adding Index, Tuning queries, Identifying missing index and using appropriate isolation level.

Environment: s: MS SQL Server 2005/2008/2008 R2 Developer, Standard and Enterprise edition, Windows Server 2003/2008,, Performance Monitor, BCP & Export import tool, Linked Server.

SQL Server DBA

Confidential

Responsibilities:

• Installed and Configured MS SQL Server 2000/ 2005/2008/2008 r2 and Applied Service Packs and Hot Fixes.
• Created and Managed of Databases, Tables, Views, Triggers, Stored Procedures, Schemas and Indexes.
• Set Up and performed Database Maintenance Plans, Scheduled and Automated SQL Server Jobs, Configured Database Mail, Created Alerts, Operators and Notifications.
• Established and Scheduled Database Backup Procedures after Installation Process is done.
• Established DR solution, High availability of database servers like Configuration and supported SQL server using Database mirroring, replications and Log Shipping.
• Administered and applied SQL Server Security best practices and transparent data encryption.
• Configured Linked Server to Access Remote Servers as well as Data Transferred using Distribution queries.
• Rebuild and Reorganize Indexes on tables to reduce fragmentation and enhance SQL Server Performance.
• Monitored Jobs to Make Sure all Scheduled Jobs run successfully every night.
• Data Extraction/Transformation, Migration of Data from Excel, CSV, Flat files to MS SQL Server using SSIS and BCP.
• Solved SQL Server performance issues ;Tuned and optimized Queries for maximum efficiency using custom tools and third party procedures.

Environment: Ms SQL Server 2000/ 2005/2008/2008 r2,T-SQL,Windows 2003/2008 Server.