SUMMARY

• 7+ years of experience Database Administration, Development and support of MS SQL Servers 2012, 2008/2008R2, 2005, 2000 in production, QA, Development and Replication environments.
• Expertise in migrating of SQL Server database from 2005 to SQL 2008R2 including consolidating. Experience working with production (24 x 7) and development environment.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as backup, integrity verification, replication verification and indexing updates.
• MS SQL Server installation, configuration, performance tuning, client/ server connectivity, query optimization, back - up/recovery, running Database consistency checks using DBCC.
• Configured Log shipping from production to disaster recovery server.
• Database creation, restoration, recovery, User/Schema creation and maintenance space management.
• Monitoring memory usage, Monitoring batch jobs, running trace and create standards reports on query performance.
• Tuning the database using database engine tuning advisor and identifying and rectifying the cause of blocks and monitoring the traces.
• Monitoring and Automating SQL Server like configuring database mail, creating an operators, jobs, alerts and database maintenance plans.
• Writing TSQL code and stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
• Designing SSIS packages those involved in different tasks like ETL, maintenance plans, monitoring etc.

TECHNICAL SKILLS

Operating Systems: Windows Server 2003, Windows 2000 Server/ Advanced Server, Windows98/XP/Professional

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, SSIS

Languages: T-SQL, SQL, XML

Databases: SQL Server 2012/2008R 2/2008/2005/2000

Reporting Tools: SQL Server Reporting Server 2008/2005, SSIS

Application Programs: SQL Diagnostic Manager, SQL Server Profiler, SSMS, Dreamweaver, Microsoft

Others: SQL Server 2000/ 2005/2008/2008 R2, Data Modeling, Data Normalization, Relational Database Design Implementation, Log shipping, Mirroring, Replication, Query optimization and performance tuning, Database backup and recovery, Database upgrade, Development of stored procedure, functions and triggers, DTS, SSIS, ETC.

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

SQL Database Administrator

Responsibilities:

• Experience which includes Database Administration, Development and support of MS SQL Servers 2012, 2008/2008R2, 2005, 2000 in production, QA, Development and Replication environments.
• Expertise in migrating of SQL Server database from 2005 to SQL 2008R2 including consolidating. Experience working with production (24 x 7) and development environment.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as backup, integrity verification, replication verification and indexing updates.
• MS SQL Server installation, configuration, performance tuning, client/ server connectivity, query optimization, back-up/recovery, running Database consistency checks using DBCC.
• Configured Log shipping from production to disaster recovery server.
• Database creation, restoration, recovery, User/Schema creation and maintenance space management.
• Monitoring memory usage, Monitoring batch jobs, running trace and create standards reports on query performance.
• Tuning the database using database engine tuning advisor and identifying and rectifying the cause of blocks and monitoring the traces.
• Monitoring and Automating SQL Server like configuring database mail, creating an operators, jobs, alerts and database maintenance plans.
• Writing TSQL code and stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
• Designing SSIS packages those involved in different tasks like ETL, maintenance plans, monitoring etc.

Environment: SQL Server 2008R2, SQL Server 2005, Microsoft Office SharePoint, Microsoft Windows Server 2003, Enterprise edition (32-Bit X86), Microsoft SQL Server Report Server, Microsoft Internet Information System

Confidential, Denver, CO

SQL Database Administrator

Responsibilities:

• Experience in Database Administration, Design Development and Support of MS SQL Server 2008R2/2005/2000 in Production, Test, Development and Environments.
• Experience in RDBMS database design,performance tuning, optimization, backupand recovery in SQL Server 2000 and SQL Server 2005/2008/2008 R2.
• Experience inDisaster Recovery Planning, Execution and Testing at remote side.
• Experience in using SQL Server Tools like DTS,Import/Export Wizard, SQL Server Enterprise Manager, SQL ProfilerandSQL Query Analyzer.
• Migration experience fromMS SQL Server 2000toMS SQL Server 2005/2008,MS SQL Server 2005toMS SQL Server 2008.
• Master in performing administrative tasks: database files management,backup/restore, security management,Database Mirroring, data integrationandsynchronization.
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server 2005.
• Solid experience onhigh availabilitySQL Server solutions, includingReplication Models(Snapshot/Transactional).
• Expert in usingBulk Copy Program(BCP), Data Transformation Services (DTS)packages andSSIS (integration services)with MS SQL Server 2000/2005.

Environment: SQL Server 2008r2, 2005, DTS, SSIS, SSRS, SSAS (MS-BI 2008, 2005), Query Analyzer, Profiler, Import Export tools, SQL Server Agent, MS Access, T-SQL, Windows 2003 Advanced Server, MS Visio 2003 Enterprise Architect, Microsoft Windows Share Point Services 2.0, Visual Source Safe 2008.

Confidential, Chicago, IL

SQL Database Administrator

Responsibilities:

• Experience in creating, monitoring, backup, recovery and tuning SQL Server databases in a multi platform environment.
• Performed SQL SERVER database upgrades from version and applied patches to 2005 database server instance.
• Migrated Oracle databases to SQL server 2005 using SQL SERVER Migration Assistance 4.0.
• Assists in providing documentation detailing the design and architecture of the databases, as well as the administration, backup procedures and data recovery steps.
• Monitored application and database performance, and adjusted database parameters, application code or schema as needed.
• Monitored backup operations, and schedules manual backups as needed.
• Worked with system administrators to configure the system for optimal performance.

Environment: SQL Server2000, 2005, 2008, Windows 2003, 2000 Advanced Servers, SSIS, Office Communicator, MS Office

Confidential

SQL Database Administrator

Responsibilities:

• Manage Microsoft SQL Server databases of the company. Set up new user accounts and security access profiles of new users.
• Helped in implementing a log shipping technology to update some local databases. Set up and configured an automated process to update two local databases.
• Plan, develop and maintain database architecture for the company. Support AHCA, CMS, and internal operations reporting requirements. Work with .Net developers on enterprise solutions.
• Monitor the performance of the SQL server databases. Took some necessary measure to fix some performance problem once it occurred.
• Modified some SSIS packages to make it work more smoothly.
• Create new SSIS packages to import data from external service providers into the database of the company.
• Run some SSIS packages to transfer data and generate some reports according to a schedule.
• Administrated the SSRS report server. Granted access to specific reports to some new users. Helped in solving some report server related problems.

Environment: SQL Server, Windows NT 2003, SSIS