Objective

• Seeking a position as a SQL ServerDBA to deliver innovative information technology solutions

SUMMARY

• 9+ years of IT experience including SQL SERVER 2012/2008/2008 R2/2005/2000 Database Administration, Development, Performance Tuning and Windows System Administration.
• Experience in New Installing, SQL Server stand - alone, virtualized, and clustered, Patch, Configuration & Maintenance of MS SQL
• SQL Server 2005 DDL/DML Triggers, Migration, Upgrading 2005 database to SQL server 2008R2.
• Creating Databases, Transactions, Tables, Joint, Indexes, Constraints, Stored Procedures, Triggers, Views, Functions and Cursors using SSMS.
• Experience Database Security: Granting and revoking end user access to resources.
• Database Maintenance: backup and restore, Recovery and Disaster Recovery procedures, integrity checks, index rebuilds, assigning Roles To Users, usually as jobs, setting them up and periodically reviewing them to make sure they are operating correctly.
• Expert in Monitoring SQL Server Performance, Troubleshooting using SQL Profiler, and Scheduling Jobs using SQL Server Agent. Index Tuning Wizard (or) DTA, Windows Performance Monitor and Maintenance plan.Performance Monitor/Profiler to resolve Dead Locks or long running queries.
• Experience in implementing many types of High availability such as Clustering, Database Mirroring, Log Shipping, and Replication.
• Installation and configuration of Microsoft reporting, and integration services, (SSRS, SSIS) ETL experience, Experience in creating SQL Server 2005/2008/2008 R2 Reporting services.
• Creating the SSIS, DTS Packages for Data Migration and Modification using DTS Lookups and transformations.
• Indexes (Clustered/Non-Clustered) and partitioning of VLDBs (Very Large Data Bases 900GB-1TB) for improving the Data base performance.
• Troubleshooting system wide problems including Network, database & third party software.
• Possess skills in Network, OS installation and Hardware troubleshooting.
• Production (24 x 7) support.
• Excellent interpersonal and Communication skills, detail oriented, aggressively penetrating into the root cause, organized and highly motivated.

TECHNICAL SKILLS

Operating Systems: Windows 2008, Windows 2003, Windows 95/98/ME/NT/2000/XP, VISTAWindow 7, Window8, Window 8.1

RDBMS: MS-SQL server 2012/2008/2008 R2/2005/2000

Languages: SQL, Confidential -SQL Scripting, C++

Tools: /Utilities Enterprise Manager, Management studio, Profiler, Query Analyzer, Export & Import, DTS, SSIS-Integration Services, Replication, SSRS-Reporting Services, ETL

Front End Tools: MS FrontPage 98/2000, MS Office 97/2000/XP, MS Project 2000, MS Outlook 97/2000

Database Modeling/ Schemas: Erwin, UML

Web Technologies: XML, Visual Studio

Microsoft products: MS Office Suite- Word, Access, Excel, Word and Power Point, and MS-Access 97/2000/2003/2007/2010

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL Server DBA

Responsibilities:

• Installations and configurations of sql server 2008, 2008r2, and 2012applying service packs, and Upgrading SqlServers R2 and 2012
• Database Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Created DTS packages in SSIS, and SSRS, SQL server 2000, 2005, 2008, 2008R2.
• Managed security on Production and Development environments.
• Creating and maintaining various databases on Production and development environments usingSQLServer 2008r2/2012.
• Installed and configured SQL Server Reporting Services.
• Responsible for Database Backupandrecovery.Monitoring the database backup, drive space, log space and Critical errors for all production servers,
• Implemented high availability technologies: Logshipping/Replication/Mirroring/Clustering/AlwaysOn.
• Created and maintained various logins and managed security based on the required access.
• Implemented and tested the point in time recovery of the production databases.
• Responsible for Performance and troubleshooting problem solving of issues related to the SQL Server and Oracle databases.
• Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication
• 24x7 and on-call support duties.

Environment: SQL Server 2008, 2008R2, 2012 SQL Server 2005 Enterprise Edition, SSIS, SSRS, SAN storage systems.

Confidential, Columbus, OH

SQL Server DBA

Responsibilities:

• Installations and configurations of sql server 2008, 2008r2, applying service packs, and Upgrads
• Microsoft sql server in the following environments: Development, test, qa production, stand alone, clusters, and virtualized.
• Responsible for Database Maintenanceand Security.Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database. Creating and managing user accounts / logins for development purpose.
• Worked extensively on creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e. Import and Export), BCP, Transact-SQL, Backups, Recovery, and SQL Server Agent, SQL Server profiler using SQL Server.
• Worked extensively on Data Maintenance like Re-indexing, Integrity Checking, Database Shrinking.
• Implementation of Point in time Backup and Recovery Plans of all databases and maintain documentation.
• Responsible for rebuilding the indexes and tables as part of performance tuning
• Implemented Disaster Recovery for SQL Server DBA Production Database as Fail-Over or Standby Servers.
• Involved in setting up, managing and maintaining High availability technologies: Installation Cluster
• Responsible for non-production and production support for SQL server database based applications and assist in trouble shooting production issues and application performance issues.
• Experience working on Database Engine Tuning
• Experience with 2000, 2005, 2008, 2008R2

Environment: SQL Server 2008, 2008R2, SQL Server 2005/2003.SAN storage systems.

Confidential, New Jersey

SQL Server DBA

Responsibilities:

• Installations and configurationsof SQL Server 2008, 2008R2,2012 applying Service packs.
• Worked extensively on creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e. Import and Export), Backups, Recovery, and SQLServer Agent, SQL Server profiler using SQLServer.
• Responsible for Database maintenances and security. Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database. Creating and managing user accounts / logins for development purpose.
• Worked extensively on creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e. Import and Export), Backups, Recovery, and SQL Server Agent, SQL Server profiler using SQL Server.
• Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database. Creating and managing user accounts / logins for development purpose
• Worked extensively on Data Maintenance like Re-indexing, Integrity Checking, Database Shrinking.
• Involved in Scheduling Tasks and Setting Alerts, Managing Task Scheduling, setting up a SQL Mail, Managing Alerts, Monitoring and Tuning. SQLServer, SQL Suggested better Scheduling Strategy for jobs to overcome Blocking and Dead Locks.
• Responsible for rebuilding the indexes and tables as part of performance tuning
• Responsible for maintaining High availability servers like Clustering and Log shipping, Mirroring and Replication
• Created DTS packages in SSIS, and SSRS, SSIS, 2000, 2005, 2008, 2008R2.
• Implemented Disaster Recovery for SQL Server DBA Production Database as Fail-Over or Standby Servers.
• Responsible for Maintaining Production Servers, Monitoring Performance issues, Trouble Shooting and Solving Production Issues. Experience working on Database Engine Tuning.

Environment: SQL Server 2008,2008R2, 2012 SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS.

Confidential, New York

SQL Server DBA

Responsibilities:

• Installations and configurations of MS SQL Server 2005, 2008, 2008 R2 Applying Service packs.
• Microsoft sql server in the following environments: Development, Test, QA, and Production.Stand alone, clusters, and virtualized.
• Worked extensively on creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e. Import and Export), BCP, and Transact-SQL, Backups, Recovery, and SQLServer Agent, SQL Server profiler
• Responsible for Database maintenances and security. Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database. Creating and managing user accounts / logins for development purpose.
• Worked extensively on creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e. Import and Export), BCP, Transact-SQL, Backups, Recovery, and SQL Server Agent, SQL Server profiler using SQL Server.
• Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database. Creating and managing user accounts / logins for development purposes.
• Implemented Data Transformation Services(DTS),BCP, Log shipping and Bulk Insert.
• Involved in setting up, managing and maintaining High availability technologies:Log shipping, Mirroring, Replication, and Clustering.
• Production (24 x 7) Environment.
• Created DTS packages in SSIS, and SSRS, SSIS, 2000, 2005, 2008, 2008R2.
• Responsible for Query optimization and Performance tuning.

Environment: SQL Server, Query Analyzer, Outlook, DTS, BCP, Enterprise Manager, Windows 2000 Server, SSIS, SSRS

Confidential, Springfield, VA

SQL Server DBA

Responsibilities:

• Installed SQL server 2005and applied service packs.Migrated databases from SQL server 2000 to SQL server 2005.
• Responsible for Database maintenances and security. Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database. Creating and managing user accounts / logins for development purpose.
• Worked extensively on creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e. Import and Export), BCP, Transact-SQL, Backups, Recovery, and SQL Server Agent, SQL Server profiler using SQL Server.
• Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database.
• Creating and managing user accounts / logins for development purpose
• Worked extensively on Data Maintenance like Re-indexing, Integrity Checking, Database Shrinking.
• Monitored, done the troubleshooting for import export, maintenance, log shipping, replication jobs.Implemented log shipping and performed change role.
• Rebuilt the log shipping standby databases.
• Added the new data files for existing databases. Increased the space in existing data files.
• Resolved blocking issues in databases, and troubleshot the slow runningqueries and applications.
• Created indexes, updated index statistics and rebuild indexes.
• Restored the very large database from multiple backup files.
• Transferred logins jobs server 2000 to SQL server 2005.
• Implemented database mirroring on SQL server 2005.
• Assigned the privileges to newly created stored procedures.
• Supported on call 24\7 on rotational basis
• Performed Data with Microsoft SQL Server 2000/2005, SSIS, and SSRS.

Environment: SQL Server 2000/2005, Windows 2000/2003 Server

Confidential, Columbus, OH

SQL Server DBA

Responsibilities:

• Installation and configuration of MS SQL Server 2000/2005and applied service packs.
• Administration of SQL Servers in Production and Development environment
• Responsible for Database maintenances and security.
• Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database.
• Creating and managing user accounts / logins for development purpose
• Developed Backup and Recovery Strategies, and Disaster Recovery Plan
• Successfully implemented indexes on tables for optimum performance.
• Performed Index analysis for tables and came up with more efficient solutions to use Clusteredand Non-Clustered Indexes for significant performance boost using index tuning wizard.
• High availability such as Clustering, Database Mirroring, Log Shipping, and Replication.
• Created SSIS packages to import data from MS Access, Excel to SQL 2005.
• Created report models and deployed on report server using SSRS
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.

Environment: MS SQL Server 2000/2005, Windows 2000 Advance Server, MS Excel, MS Access, SSIS and SSRS