SUMMARY

• 7+years in depth experience in MS SQL Server 2012/2008R2/2008/2005 as Database Administrator in Health, Banking, and standard & certification domain.
• Good experience in production environment including SQL server installation, configuration, upgrade, maintaining and monitoring, performance tuning, optimization, backup, restore, disaster recovery.
• Good experience in migration, monitoring, security planning and troubleshooting high availability environment.
• Expertise in Installs, deployments, service accounts resets, add patches, performing upgrades & migrations, process job tickets & bugs, test verify backups and recovery.
• Expertise in setting up High availability environments likeactive - active and active-passive clustering,Database Mirroring,Replication,Log shipping, Involved in setting up SQL servers from scratch on clustered environment, linked servers.
• Experience in installation, configuration and deployment of SSIS Packages, design techniques, ETL processes and RDBMS.
• Strong understanding of components of SQL Server Architecture,Backups and Restore Strategy.
• Experience in maintaining thesecurity for databases and SQL Server Reporting Services.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Proficient with SQL Management Studio, Query Analyzer, rescheduling jobs with SQL Server Agent,SQL Profiler, OLAP, OLTP and trouble shooting.
• Experience in installation,configuration,deployment and maintaining security of SSRS
• Experience in creating reports usingSSRSand worked onOLAP environment.
• Strong knowledge in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Interest in the area of Administration,DatabaseDesign, analysis and production support for larger and complex database.
• ExperienceinMigratingSQL Server 2008 to SQL Server 2012.
• Experience working withproduction and 24 x 7on call environments.
• Good team player, self-motivational, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Database: MS SQL Server 2012/2008 R2/2008/2005, MS Access

Languages/Tools: T-SQL, C++,Java, PowerShell, Visual basic 6.0, SQL, Lite Speed, Spot lightRed gate, DTA, SDT, Configuration manager, Serve manager, SSMS

Operating System: Windows NT 4.0, Windows server 2000/2003/2008/2008 R2

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

SQL Server DBA

Responsibilities:

• Involved in buildingout new data-center servers, configuring SQL 2012 in cluster environment
• Index Defragmentation byRebuild/Reorganizeof Indexes on aweeklybasis across all big size Databases.
• RunningDBCC consistency checks, and fixing data corruption in user databases.
• Install, configure, deploy and maintain security of SSIS and resolving issues that come up.
• Working on Hardware Upgrades, which involve RAM, andProcessor Upgrade.
• Setting up Clusters, logs shipping and Replication.
• Identifying problems and troubleshooting it for optimal performanceusing Service Manager, DMV’s server side traces.
• Performing Standby DBA, Working on day-to-day operation and closely with other team such as NT, Network, and Server tools to identify and troubleshoot the problem.
• Installed and Configured 4-node high availability SQL Active/Passive clusters.
• Expertise in alwayson high availability.
• Created and implemented Transactional replications.
• Implemented SQL security for application users using Active Directory.
• Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance test.
• Perform full Backups and transaction log backups. Restore them whenever necessary; create back up strategies and schedule them for execution.
• On call 24/7 supports to databases on weekly rotation.

Environment: Microsoft SQL Server 2012/2008/2008 R2, MS Windows Server 2003/2008, C++, Visual Studio, T-SQL, SQL Profiler, Spot light, Idera, Red gate, DTA, SDT.

Confidential, Reston, VA

SQL Server DBA

Responsibilities:

• CreatedMaintenance plan for the performance of SQL server covers databaseIntegrity Checks, Update Database Statistics and indexing.
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery.
• CreatedClustered and Non Clustered Indexes on tables, views, and columns.
• Actively involved inSystem Performance by tuning SQL queriesandstored procedures by using Execution plan, SQL Profiler,Database Engine Tuning Advisor and Windows performance monitor.
• Deployed the databases into the production server in clustered environment.
• Actively involved inSQL Server Replicationfor copying and distributing data and database objects from one database to another and thensynchronizing between databases to maintain consistency.
• Actively involved inMerge Replicationconfiguration, Worked onSnapshot replicationto overwrite the database at the subscriber or in updating the initial database replication.
• Security administration by creating Roles, Users, Logins and granting the Rights.
• Implementation of database and data architecture monitoring technologies and procedures and proactively monitor the database systems and resources to ensure secure, stable, high-performing services with minimum downtime.
• Implementeddatabase mirroringforhigh availability.
• Created or maintain clear documentation regarding all components of database administration.
• Rebuild indexes on tables to reduce fragmentation.
• Proactively monitored, identified, isolated and resolved server problems to avoid impact on the business.
• 24/7 Production support for SQL Server databases.

Environment: Microsoft SQL Server 2005/2008/2008 R2, MS Windows Server 2003/2008, Visual Studio, T-SQL & SQL profiler.

Confidential, Houston, TX

SQL Server DBA

Responsibilities:

• Involved ininstallation, configuration, and migrationof MS SQL Server 2005/2008 servers.
• Involved inData modeling, designing and building Relational Databasesusing Tools like Erwin and SQL Database Diagrams.
• Implemented Transactional Replication and Snapshot replication.
• Creating user logins with appropriate roles, dropping and locking the logins.
• Monitoring the user accounts, creation of groups, granted privileges to users and groups.
• Worked onperformance tuning of queries on different database.
• RunningDBCC consistency checks, and fixing data corruption in user databases.
• Query optimizationand increasing the performance of store procedures by looking into theexecution plan, Indexes, Outdated Statistics.
• Maintained Operators, Categories,Alerts,Notifications
• Maintained Jobs, Job Steps and Schedulesas well asMonitored Connections, locksand Performance of SQL server
• Involved inConfiguring and Monitoring SQL Server clustering and Log Shippingfor high availability on SQL 2005/2008
• Installation of Service Packs and Hot fixes and also created the documentation for tracking and installation purposes.
• 24/7 Production support for SQL Server databases

Environment: Windows 2003 Server, MS SQL Server 2005/2008, T-SQL, DTS, SQL, lite Speed, DTA, Red gate.

Confidential, Addis Ababa, Ethiopia

SQL Server DBA

Responsibilities:

• Maintained Operators, Categories,Alerts,Notifications, Jobs, Job Steps and Schedulesas well asMonitored Connections, locksand Performance of SQL server.
• Installation and configuration of SQL Server 2005 on windows 2003 and maintenance of Servers in Production and Development Environment.
• Optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Up-gradation of SQL databases from SQL Server 2000 to SQL Server 2005.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency check, and index de-fragmentation by DBINDEXDEFRAG and DBREINDEX.
• Monitored database status including CPU, memory, I/O, space, and dead lock issues using SQL Server Utilities.
• Implemented database mirroring and responsible for Database and Log Backups & Restoration Strategies.
• Developed stored procedures and triggers, provided assistance to development teams on tuning data, indexes and queries.
• Successfully implementeddatabase mirroringwithhigh availabilitymode in SQL Server 2005.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers.

Environment: Windows 2003 Server, MS SQL Server 2000/2005, TSQL, DTS, C++, C, Visual basic 6.0.