SQL Server DBA Resume Columbia, MD - Hire IT People

PROFESSIONAL SUMMARY:

I am a SQL server database administrator with more than 4 years’ experience in almost all aspects of SQL server database administration ranging from SQL server 2012 installation to disaster recovery, performance tuning, mirroring, log shipping, index optimization, failover cluster to operational procedures.
My rich strong and diversified experience has developed in me, the required skills necessary for any organization to develop, monitor and or implement a sound SQL server data administration standard, that will be cost effective and still meet the expectations of the client.
My strong sense of judgment and high organizational skills couple with my excellent communicational, leadership, team work, and quick learning skills have given me the confidence in taking initiatives and responsible risks.

TECHNICAL SKILLS:

Proficient in administration and installation of windows OS 2008 R2. Windows 2012R2.
Performance tuning
SQL server administration 2003/2005/2008/2012 windows server
EMC SAN
VMWARE

PROFESSIONAL EXPERIENCE:

SQL Server DBA

Confidential, Columbia, MD

Responsibilities:

Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
Installed and administered 3 - Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
Rebuilding / monitoring the indexes at regular intervals for better performance.
Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).
Implementing the snapshot isolation and DDL triggers.
Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
Performed installation of SQL server Enterprise 2012 SP1 CU 5 64 bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).
Clustering
80+ clustered instances implemented across SQL Server 2008 and 2012
Log shipping log shipping pairs implemented ranging from SQL Server 6.5 through 2012
Failover and failback implementations along with development of support center push button failover routines

Environment: SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, .NET, Microsoft Reporting Services.

SQL Server DBA

Confidential

Responsibilities:

Installing, Designing, Development, Implementation and Administration of Databases.
Database migration, database warehousing and database chance management.
All phases of Database Operations
Backup/Restore
Monitoring
Security
Capacity planning
Performance and analysis tuning
Infrastructure planning and Implementation
All phases of data architecture including requirements gathering, data modeling, physical implementation
Storage and memory allocations
Standard operational procedures
ISO 2700 (information security) implementation
ISO 9001(quality management system) implementation

Environment: SQL Server 2008, SQL Server 2005, Windows 2003/2000 Server, Enterprise Manager, SQL Profiler.

SQL Server DBA

Confidential

Responsibilities:

Worked on Dynamic Management Views in SQL Server 2005.
Installed, and managed reports using SQL Server 2005 Reporting Services.
Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
Performed daily tasks including backup and restore by using SQL Server 2005tools like SQL Server Management Studio, SQL Server Profiler, storage management, SQL Server Agent, and Database Engine Tuning Advisor.
Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
Monitored and optimized Performance using execution plans and Index tuning.
Rebuilding the indexes at regular intervals for better performance.
Worked on DBCC commands and Dynamic Management Objects.
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Complete documentation about the database. Recovering the databases from backup in disasters.
Monitoring the servers using Idera third party software.
Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment: SQL Server 2005/2003 .Net Framework 2.0, C#.Net, Asp.Net2.0, Windows 2000, Windows 2003 Server, MS TFS, MS-Access.