SUMMARY

• Over 7 years of experience in database administration for very large and complex databases in SQL servers 2012, SQL Server 2008 R2, 2008 and 2005 in the fields of Retail, IT, Healthcare and Finance.
• Installed, upgraded, and administered SQL Servers 2012/2008 R2 and 2005 in virtual and physical environments.
• Installed Service packs, security updates and hotfix in SQL 2005, 2008, 2012. Expertise in T - SQL writing stored procedures, triggers and functions and creating indexes.
• Experienced in performance Monitoring and Tuning, Query Optimization via T-SQL, DMVs, System Monitor, DBCC Utilities, Database Tuning Advisor/Index Tuning Wizard, and SQL Profiler.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Proficiency and expertise on Database Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log shipping.
• Implemented Replication Models, i.e., Snapshot, Merge and Transactional.
• Experienced in implementing Database Mirroring.
• Good experience on high availably SQL server solution, including clustering and Always On.
• Worked on SQL Server 2012 migration from SQL Server .
• Developed and documented database migration strategies, ETL using SQL SSIS, Import/Export and BCP utilities.
• Experienced in installing, configuring, deploying and supporting Integration Services (SSIS) and Reporting Services (SSRS).
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, contained databases, security principals.

TECHNICAL SKILLS

Databases: MS SQL Server 2012, 2008/R2, 2005,MS-Acess

Programming: Transact SQL

SQL Server Tools: Enterprise Manager, Management studio, Profiler, Query Analyzer, Export & Import, DTA, SSIS, Replication, SQL Analysis services, Reporting services

Operating System: Windows server 2012/2008/2003 Advanced Server, NT & Windows

Third party Tools: Red gate, SQL Lite Speed, spotlight

PROFESSIONAL EXPERIENCE

Confidential, Morristown, NJ

SQL Server DBA

Responsibilities:

• Installed and administered clustered and stand-alone SQL server 2012 and 2008.
• Migrated SQL server 2008 to SQL Server 2012.
• Migrated SSIS packages from SQL Server 2008 to SSIS 2012.
• Implemented AlwaysOn on the clustered environment.
• Implement transactional replication model.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing and Contained Databases.
• 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).
• 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.
• Responsible for reviewing,optimizing and deploying database scripts requested by ApplicationDevelopment Team.

Environment: SQL Server 2008/2012, Windows Server 2012/2008, Clustered, SSIS, T-SQL

Confidential, Pittsburg, PA

SQL Server DBA

Responsibilities:

• Monitoring database performance, identifying bottlenecks, and proposing ways to optimize performance.
• Working with development teams to in corporate database changes required for release rollouts.
• Maintenance of existing trading instruments, and managing updates to their underlying data.
• Installation of new servers, and upgrade of existing servers with regard to service packs and new versions.
• Managing data backup and restores required for disaster recovery.
• The provision of extremely high levels of availability for the production, demonstration and test systems.
• Resolution of any problems in these systems in a timely and professional manner.
• Ensuring compliance with company security procedures.
• Transferring the data (ETL) to Data warehouse by SSIS.
• Developed, deployed and monitored SSIS Packages.
• Experienced in implementing Database Mirroring.
• Implemented Replication Models, i.e., Snapshot and Transactional.
• 24 X 7 Production Database on Call Support.

Environment: SQL Server 2008/R2/2005, Windows 2000, Windows 2003 Server, Clustered, T-SQL

Confidential, Pleasanton, CA

SQL Server DBA

Responsibilities:

• Support an enterprise implementation of SQL Server.
• Perform routine database management.
• Backup and restore databases.
• Troubleshoot SQL Server issues.
• Provide on call support for a large SQL Server implementation
• Debug and extend functionality of current batch or automated processes.
• Install and utilize SQL Server Management Studio to provide monitoring, administration and configuration management on database engines.
• Communicate with a wide variety of technical and business experts in both individual and group settings using email, self-generated documentation and presentations.
• Perform login management, install/patch, troubleshoot connectivity issues, monitor performance and tune in complex three-tier architectures.
• Maintain, create, and monitor various ETL processes
• Provide developer and end-user support for SQL Server databases including maintaining existing TSQL code, performance tuning, and troubleshooting database and database linkage problems.

Environment: SQL Server 2005, Windows 2003/2000 Server, SQL Query Analyzer, SQL Profiler.

Confidential, Addis Ababa, Ethiopia

Junior SQL Server DBA

Responsibilities:

• Installed SQL Server 2005, multi instances and service packs.
• Managing database backup and recovery Create database objects including tables, triggers, views, stored procedures, indexes, defaults and rule.
• Experienced in trouble shooting, performance tuning, query tuning, index tuning using DBCC command, Wizards and SQL Profiler.
• Maintenance of clustered and non-clustered indexes. Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Implemented and Scheduled Replication process for updating our parallel servers.
• Design and implementation of database maintenance plan.
• Automated messaging services on server failures, for task completion and success.
• Execute procedures to accomplish short-term business goals.
• Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Using database level triggers code for database consistency, integrity and security.
• Migrated data from MS Access and MS Excel to SQL Server.

Environment: SQL Server 2005, Windows 2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility.