SUMMARY

• 6 years of experience in SQL server Database Administration and technical support
• Strong experience Installation, Server Configuration, Database Configuration, maintain RDMS system, writing TSQL programming, Security, Back Up, Recovery, Database Automation, Performance Tuning, configure and administrated VMware and BI ( Business Intelligence ) tools

TECHNICAL SKILLS

• SQL Server 2000 2005 2008 2008 R2 2012
• Microsoft Access
• Windows Server 2003R2 2008 R2 2012 2012R2
• Transact - SQL
• ASP
• ASP.net
• VB/JavaScript
• HTML
• Power shell
• DOS
• Visual Basic
• Query Analyzer
• Idera DBA Suite
• Idera (SQL Compliance Manager)
• SQL Doctor
• Toad
• Data Modeler
• Microsoft Office Word
• Excel
• PowerPoint
• Visio
• Visual Studio
• SSIS
• DTS
• IIS 5.0 6.0 6.5 7.0 7.5
• Share point
• VMware

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Responsibilities:

• Responsible for DBA tasks including system configuration, performance monitoring, backup and restore activities, indexing, development, performance tuning and version control assurance.
• Collaborated with Developers to ensure stored procedures, functions, views and tables met standards.
• Configured, supported, and optimized SQL Server and database configurations.
• Identified User needs to create and administer databases.
• Ensured that the database operates efficiently and without error.
• Make and test modifications to the database structure when needed.
• Maintained the database and update permissions.
• Merged old databases into new ones.
• Backup and restored data to prevent data loss.
• Ensured that organizational data is secure.
• Monitored SQL job failures, debugged, root cause analysis, resolution, documentation and escalation of priority issues.
• Monitored ongoing performance of SQL server database.
• Optimized TSQL application query performance and database design.
• Supported development and deployment of software applications.
• Installed VMware.
• Managed SQL databases in a virtualized environment.
• Performed SharePoint implementation and administration.
• Installed, configured and maintained SSIS, SSRS,

Confidential

Database Administrator

Responsibilities:

• Installed, configured, administration and maintained windows server 2008 and 2012 on standalone and clustered environment.
• Installed, configured, administration and maintained MS SQL Server 2005, 2008, 2008R2,2012 on standalone and clustered servers.
• Application database support including database import/export, security.
• Managed, maintained, and optimized 90+ SQL instances.
• Configured, supported, and optimized SQL Server and database configurations.
• Configured and maintained SQL database services in an enterprise environment.
• Managed SQL server policies(PBM).
• Upgraded databases from SQL server 2008 R2 to 2012.
• Migrated databases from existing server to new server.
• Designed database Backup & Recovery, DR Planning, SQL Server Agent/maintenance plans.
• Implemented periodic security controls. Manage database users and their appropriate level of permissions.
• Experience in performance tuning of T - SQL queries, indexes, disk I/O, memory, and CPU.
• Wrote complex stored procedures and SQL queries.
• Supported extensive DTS and SSIS implementations.
• Monitored SQL job failures, debugging, root cause analysis, resolution, documentation and escalation of priority issues.
• Monitored ongoing performance of SQL server database.
• Optimized TSQL application query performance and database design.
• Supported development and deployment of software applications.
• Basic familiarity with Active Directory Security Authentication Mechanisms,
• Installed VMware.
• Managed SQL databases in a virtualized environment.
• Performed SharePoint implementation and administration.
• Installed, configured and maintained SSIS, SSRS, and SSAS.
• Well documented every task based on requirements.
• Organized, prioritized, analyzed and verified requirements
• Wrote PowerShell Script for DBA maintain.
• Worked independently and in a team environment.
• Provided ongoing database technical support to the client and OIT staff as needed.
• Maintained quality control and data cross checks of databases.
• Managed updates/enhancements to database as needed.
• Add in sample data, test user functionality.
• Built in reports.
• Modified controls as required and/or necessary.
• Organized and prioritized multiple tasks and meet aggressive deadline.

Confidential

Database Engineer

Responsibilities:

• Installed, configured and managed SQL Server 2005, 2008R2 in development, test and production environment.
• Installed, configured and maintained Fail-Over Clustering using SQL Server.
• Installed and configured SQL Server Reporting Services (SSRS).
• Configured and maintained Mirroring Replications and Log Shipping as part of a high availability solution.
• Upgraded databases from SQL Server 2005 to 2008R2 in testing and production environment.
• Applied SP (Service Pack) on SQL Server.
• Expertise in database Performance Tuning
• Responsible for creating, modifying and managing tables, Indexes (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures and Triggers.
• Exported and imported data from Flat file, CSV file, Oracle, MySQL and Access to/from SQL Server Database using DTS, SSIS and BCP.
• Data modeling using Toad Data Modeler and Visio.
• Generated Report using SSRS (SQL Server Reporting Services.)
• Responsible for Database Backup, Restore and Point-in-Time Recovery.
• Created and modified database structure using Data Definition Language (DDL) statements to create tables and appropriate indices for optimal data access, as well as database objects such as store procedures, functions, views, and triggers.
• Calculated and trend database sizes and plan appropriately for growth.
• Communicated plans to Server Administrators.
• Monitored and scheduled automation jobs using SQL Server Agent and Maintenance Plan.
• Configured Database Mail, Operator, Notification, alert to send and receive database related information which can affect the performance.
• Monitored databases for optimal performance and find out performance problem in different way using SQL Profiler, Wait stats, DMV (Dynamic Management View), DMF (Dynamic Management Function), Activity Monitor, Extended Events, Error Log, Windows Performance Monitor.
• Identified and takes step to resolve poorly-performing queries that require tuning and/or optimization.
• Used SQL execution plan to find the cost and running process for TSQL code and optimize the code.
• Developed script to find out Missing Index, Unused Index, Duplicate Index, and Partial Duplicate Index.
• Created appropriate Index to optimized slow running query.
• Run various DBCC commands to Checks Database consistency.
• Review and create Extraction, Transformation, and Loading (ETL) processes for optimal access and data manipulation methods. using SQL Server Integration Services (SSIS).
• Executed and monitored ETL jobs in production servers.