SUMMARY:

• Over 4+ years of Technical experience as SQL Server Database Administrator, System Analysis, Security and Support of MS SQL Server 2008, 2005 and 2000 in Production, Testing, Development, Replication and Cluster Server Environments.
• Successfully installed MS SQL Server 2000, 2005 and 2008 in standalone and Clustered Environments.
• Upgraded SQL Server from version and .
• Experience in investigating and applying necessary SQL Server database service packs and patches and troubleshooting all database related issues.
• Ensure the databases are highly secure, available, and recoverable.
• Perform database check - up and maintenance to ensure optimum performance
• Performed Normalization and built Referential Integrity Constraints.
• Extensive knowledge of RDBMS.
• Experience developing, troubleshooting and optimizing T-SQL and PL/SQL code, ETL/SSIS processes and SSRS reports.
• Experience performing SQL Server replication (transactional, snapshot, SQL and Oracle target).
• Proficient in installing, configuring, upgrading and patching all RDBMS listed above, as well as OLTP performance troubleshooting.
• Extensive knowledge and experience in developing Stored Procedures, Views, Triggers, cursors and Complex Queries on SQL Server 2000/2005/2008.
• Conducted Database Backup and Restore, Attach and Detach, Recovery and Disaster Recovery procedures.
• Involved exclusively in Disaster Recovery plans like Clustering, Database Mirroring, Log Shipping and Replication.
• Successfully implemented and troubleshooted Snapshot, Transactional and Merge Replication.
• Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
• Created and Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules for system errors, insufficient resources, fatal database errors, hardware errors, security.
• Experience on SSIS (SQL server Integration Services), SSRS (SQL server Reporting Services) & SSAS (SQL Server Analysis Services).
• Experience in data migration from Oracle/Access/Excel Sheets using Integration Services (SSIS).
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Created and generated Reports and deployed on the Intranet using SQL Server Reporting Services (SSRS).
• Performed Data Transformation Services and Transformed data between servers using tools like Bulk Copy Program (BCP), Export/Import, Data Transformation Services (DTS) and Integration Services (SSIS).
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Extensively Monitored Database Performance with multiple tools like Performance Monitor, SQL Profiler, PSSDIAG, NEXUS, MPS REPORTS, Event Viewer, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, Resolve Dead Locks/Long Running Queries, accessibility and efficiency.
• Extensive experience in writing complex Transact-SQL.
• Conducted Database Backup and Restore, Attach and Detach, Recovery and Disaster Recovery procedures.
• Involved exclusively in Disaster Recovery plans like Backup/Restore, Database Mirroring, Log Shipping
• Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
• Created and Maintained Alerts, Notifications, Jobs, Job Steps and Schedules for system errors, insufficient resources, fatal database errors, hardware errors, security.
• Experience in data migration from Access/Excel Sheets using import/export and BCP utilities.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Extensively Monitored Performance with multiple tools like Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, Resolve Dead Locks/Long Running Queries, accessibility and efficiency.
• Experience in Troubleshooting all database related issues.
• In Depth knowledge in analyzing Query Plans, Extended Stored Procedures and improving efficiency by re-indexing, update statistics, Recompiling stored procedures, Troubleshooting Dead Locks and capture data using SQL Profiler, Performance Monitor and DBCC Commands.
• Worked closely with management, applications development Team, and users on database solutions to resolve business problems.
• Experience on working with production Servers and 24 x 7 On-Call environments.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Actively involved in setting up Active-Active/Active-Paasive clustering in production and Testing Environments and also troubleshooted issues with the same.Applied Hotfixes and Service Packs in clustering environments.
• Conducted Database mirroring in High Performance and High Availability mode and troubleshooted issues with the same.

TECHNICAL SKILLS:

Databases: MS-SQL Server 2005/2008/2008 r2/2012, MS Access 2003.

Languages: Java,C#, VB Script, Java Script, HTML, XML

SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyser, Export & Import,Precise i3 for SQL Server.

Operating systems: Windows 2003/2008/2010

Software Packages: MS Office 97/2000/XP,2003,2007, MS Outlook 2003,2007, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

SQL Database Administrator

Responsibilities:

• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes.
• Created and maintained various databases for Production, Development and Testing environments using SQL Server 2008r2, 2005.
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and troubleshooted issues with the same. Applied Hotfixes and Service Packs in clustering environments.
• Conducted Database mirroring in High Performance and High Availability mode and trouble-shooting issues with witness servers.
• Involved in migration of SQL 2005 TO SQL 2008r2
• Performed daily backups and developed recovery procedures
• Migrated the data across different databases and different servers using SSIS,BCP and Import/export tools.
• Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server. Used SQL Server error-logs and event viewer to troubleshoot issues.
• Implemented and configured database monitoring tools and focused on providing a high availability database.
• Troubleshooted issues with log file full and database size increasing beyond threshold.
• Creation of new database, planning the location of data, index, and transaction log files on the disks
• Involved in Capacity Planning, data modeling and Logical/Physical database Design
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources
• Provided support to the application developers on the application databases
• Handled the database components of application releases
• Handled 24/7 production Issues .
• Used i3 performance tool and Hydra software to monitor Databases and Servers.
• Performed Stress tests and monitored tests in regard to CPU, network bottlenecks and latencies, blocking and long running queries, page faults.
• Worked closely with application developers to help determine any issues with sql script, sql server performance, normalization, security and database/server connectivity and database schemas.
• Developed and deployed stored procedures, created triggers and audits.
• Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff/log backups, refreshing database environments periodically or on demand. Also set up notifications for failure of jobs etc.
• Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies.
• Proactively monitored, determined and solved issues at sql/database/server levels.

Environment: Windows 2003, MS-SQL Server 2008r2/2005,2008,2012, 2016, .NET Framework, Visual Studio,i3 performance tool.

Confidential, Virginia

MS SQL Server DBA

Responsibilities:

• Installed SQL Server 2008r2 on Standalone and Clustered Environments.
• Upgraded /Migrated of SQL Server from version r2.
• Installed Microsoft Service Packs/Patches/Hotfixes.
• Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.
• Conducted Backup and Restore of Databases and Schedule Maintenance plans to perform regular Backups.
• Performed Attach/ Detach, BCP, Import & Exports and Copy Database Wizard.
• Created Tables, Stored Procedures, Views, Triggers, Cursors and Complex Queries on SQL Server 2005/2008.
• Query Optimization and Performance tuning for optimization like maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.
• Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Troubleshooted Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
• Collected data using PSSDIAG, MPS Reports, Profiler to analyze and tune for better optimization.
• Troubleshooted and resolved Blocking, Deadlocks and Long Running Queries.
• Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Developed, deployed and monitored SSIS Packages including upgrade from DTS to SSIS.
• Created Reports using SSRS 2005/2008.
• Utilized DMV’s, Data partitioning and Performance Dashboards reports with SQL Server2005.
• Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshooted Replication Problems.
• Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
• Created various Jobs, scheduled & ran jobs and troubleshooted the failed jobs.
• Provide 24X7 support for the Critical issues like Server Failures and Database inconsistencies like Database Log File full, Suspect, Offline, Missing log files etc.

Environment: Windows 2003, MS SQL Server 2005/2008/2008 r2, T-SQL, Visual Studio.Net 2003, Crystal Reports, LITESPEED, MS Access, DTS, BCP, SSIS, SSAS, SQL Profiler.

Confidential

SQL Server DBA

Responsibilities:

• Installed and configured Windows NT/2008, SQL Server 2008.
• Responsible for the systems study, analysis, systems design and database design, ER modelling, Dimensional Modelling, coding, testing, implementation and documentation.
• Database creation and location of database file.
• Upgraded SQL Servers database from version .
• Managed SQL Server users/ NT users.
• Conducted Replication of SQL Server databases.
• Setup log shipping of production databases to maintain standby copy of production databases and for offloading query processing from the production server.
• Restored the database on production server or development servers as per requirement.
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Tested the application for deployment, functional behavior.
• Updated Microsoft patches/Service packs on SQL Server 2005 and Windows NT.
• Installation, configuration and supporting of IIS servers.
• Involved in database designing using Normalization.
• Developed DTS (Data Transformation Services) Packages Created Transact SQL scripts based on functional requirements as defined by design documents. The package does data transformation between Ms Access and Ms SQL Server 2005.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Tuned SQL statements and Stored Procedures.
• Extensively used DTS to load data from different data sources.
• Helped application teams in query analyzing and its optimization. Coordinated with users for downtime and maintained the system running 24X7.
• SQL server database backups/restoration and recovery of NT server/SQL Servers
• Implementation of Active directory, group policy in windows 2008.
• Look after virus issue and the virus patches applied to the servers.

Environment: MS SQL Server 2005 and 2008, T-SQL, DTS, Replication, MS Access, Visual Studio, Windows 2008 server, Windows NT