Sql Server Database

Microsoft Certified SQL Server Database Administrator having more than five years of working experience on different components and technologies of SQL Server 2012, 2008 R2, 2005 & 2000. Hands-on experience on Installation, Configurations and Administration (Standalone/HA Solutions – Replications, Log Shipping, Mirroring, Clustering), Data Modeling, Backup/Recovery, and Designing DR Solutions. Also, experienced in SSIS, Reports, Development and management in SQL Server Reporting Services (SSRS), Monitoring and Managing Database Health, Performance Tuning, Partitioning, Index, Stored Procedures, Triggers, Functions, DMVs, Constraints & DBCC. Strong working experience on using database third party tools (Solar Winds, Idera, Fog light, Toad Data Modeler) and managing large databases in 24/7 environment.

General Skills:

Ability to adapt to changing environments

Excellent team player and quick learner

Excellent in Technical Support

Excellent in working with non-technical/Business Analyst/Management Team

Certifications:

MCSA (Microsoft Certified Solution Associate) - MS SQL Server 2012

MCITP (Microsoft Certified IT Professional): SQL Server – 2008, Database Administration

070-432: Implementation and Maintenance

070-450: Design, Optimize, and Maintain DB Admin

Trained on SQL Server Reporting Services 2008 – Administration & Development, July 2012, Learning Tree, Alexandria, VA

Trained on SQL Server Integration Services 2008 Administration & Development,2012,Learning Tree, Alexandria, VA.

Security Clearance: Clearable

Work Authorization: U.S Citizen

Technical Skill Summary:

Experienced in Installation, Configuration, System Analysis, Design, Implementation and Administration of MS SQL Server 2012, 2008R2, 2005, 2000 in Production, Test & Development.

Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading, and Migrating SQL Server 2012/2008 & R2/2005/2000 on Clustered and Standby Environments.

Excellent experience in Designing, Configuring, Implementing and Administering SQL Server Database High Availability Solution

Strong experienced in Configuring, Managing and Administering Database Mirroring, Log Shipping & Replication as a Disaster Recovery and High Availability solution.

Experienced in installing and configuring and upgrading of SQL Server failover cluster as a High Availability Solution.

Experienced in analyzing data integration, developing ETL process using SSIS and BIDS

Experienced in T-SQL programming in writing, managing and debugging Functions, Stored Procedures, and triggers

Experienced in installation, Configuration, and Administration of SharePoint server 2010

Experienced in installing, configuring, and managing Database Servers in VM Environment

Hands-on experience with T-SQL (DDL, DML, DCL) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.

Experienced in Performance Monitoring and Tuning for Instance, Database, and SQL Query using execution plan, Profiler, Database and Index Tuning Tools and Monitoring Server Activity, Error Log, space usage, and solving problem as needed

Experienced in managing Clustering and Always ON high availability groups

Knowledge and working experience on SSIS and DTS for data move and manipulation

Experienced on SQL Server Reporting Services, using SQL/T-SQL Scripting for customized Report Generation and Management

Experience in setting-up, and Managing Database Maintenance Automation like different types of Database Backups (Full, Differential & T-Log ) jobs, Index Management, Update Statistics History Cleanup etc.

Experienced in Managing Database Security and Audit

Experienced in Applying SPs for SQL Servers & OSs.

Experience in Database migration from RDBMS like Oracle, MS Access, and Sybase to SQL Server 2012/2008R2/2008/2005.

Experienced in upgrading SQL Server 2005 to SQL Server 2008/R2, and SQL Server 2008/R2 to SQL Server 2012

Experienced in configuring and setup Database Mail Server for database mail notification

Experienced in Database deployment in Production and refreshing in test environment

Experienced in administering AD (Active Directory)/Domain and monitoring user activities

Professional Experiences

Federal Maritime Commission February 2012 -Present

Washington, DC 20573

SQL Server Database Administrator/DBA

Responsibilities:

Installed, configured, managed, monitored and troubleshooting SQL Server 2008 R2 & 2012 in Test, Development and Production environment.

Upgraded SQL Server 2005 to 2008 R2, and 2008 R2 to 2012

Maintained SQL Server Failover Clustering Server and Always ON

Configured and Managed Replication, Log Shipping, Mirroring and Cluster Instances

Responsible for securing Database & SQL Server environment by granting proper level of permissions on various Objects.

Setup Database maintenance plans for Backups, Index Maintenance, Update Statistics, and Cleanup History etc.

Proactively monitored of SQL Server for disk space utilization, service status

Performance monitoring using SQL Server native and 3rd party tools

Built user-defined functions (UDFs), views, indexes, triggers, Stored Procedures.

Created customized reports using SQL Server 2008 R2 Reporting Services

Created SOP (Standard operating procedures) for all SQL Server activities like - Installing SQL Server, applying service packs and security fixes

Backed up and restored user and System Databases. Imported and exported data between MS SQL Server and Non +Microsoft SQL Server using SQL Transfer manager and bulk copy program

Scheduled and monitored all maintenance activities of SQL Server Instances

Monitored database status including CPU, memory, I/O, space, and deadlocks

Created alerts, notifications, and emails for system errors, insufficient resources, hardware errors, and security breach

Environment: Windows Server 2012/ 2008 R2 and IIS 7.5, 7.0 and 6.5, SQL Server 2012, 2008R2, 2008 and 2005. SharePoint 2010, 3rd party tools Idera,Toad Data Modeler, Solar wind

Federal Election Commission March 2009 -January 2012

Washington, DC 20581

SQL Database Administrator/DBA

Responsibilities:

Installed, Configured, Upgraded and Managed SQL Server 2008R2, 2005 development, test, and production environment.

Maintained Fail-Over Clustering using SQL Server 2008 R2

Configured Log Shipping as Standby database from Production database for Reporting purposes.

Configured and Maintained Transactional Replications for Load balancing.

Installed, Configured, Developed and administered SQL Server Reporting Services (SSRS).

Developed Ad-hoc Reports using Report Builder 3.0, 2.0

Designed and implemented Database Migration (development, testing and production environment).

Worked on data analysis, data modeling and generated E-R Diagram.

Applied forward and Reverse engineering for logical and physical database creation.

Maintained scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.

Used Monitoring tools such as Spotlight and Idera

Monitoring SQL Server Error Log, space usage (routine based)

Writing Functions, Triggers, and Stored Procedures

Assisted Database Developers to optimize SQL queries and Stored Procedures

Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP

Strong knowledge and working experience in Database Backup and Disaster Recovery

Restored Database from backup

Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well

Environment: SQL Server 2008R2, 2005 & 2000, Windows 2003/2000 Server. 3rd party tools Fog light, Toad Data Modeler

Education: B.S. in Computer Information Systems (CIS)

References: Available upon request

Contact this candidate