SUMMARY

• 5+ years of Microsoft SQL Server Database Administration & Development experience in SQL Server 2008R 2/2008/2005/2000.
• Installed SQL Server 2000/2005/2008/2008 R2/2012/2012R2 on new 32 - bit and x64-bit Operating System.
• Involved in Migrating from SQL Server 2008 to SQL Server 2012
• Experience in upgrading SQL server software to new versions and applying service packs and patches.
• Worked on applying SQL Server hot-fixes / Service Packs on all production and development instances on quarterly basis based on recommendations from Microsoft Tech-net.
• Installed SQL Server Client on all Client Desktops.
• Experience with SCOM, MOM and SCVMM
• Experience in working with Windows Servers / 2008/2012/2012 R2 .
• Proficient with SQL Management Studio, Enterprise Manager, Query Analyzer, Business Intelligence development studio, report builder 2.0, rescheduling jobs with SQL Server Agent.
• Expertise in deployments, renewals, process job tickets & bugs, test verifies backups and recovery.
• Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans.
• Experience on High Availability and Disaster Recovery like Replication, Log shipping, Mirroring and Clustering and database security and permissions
• Created Security by setting up groups and then logins for each Roles or Users for Maintenance of Databases.
• Documented Disaster recovery plans and participated in disaster recovery drills.
• Successfully tested and implemented Log Shipping technique used for warm backup solution for MS SQL server 2000/ 2005/2008/2012 databases.
• Proficient in implementing different types of Replication models like Snapshot, Transactional, Merge and Peer-Peer.
• Experience in Implementing Database Mirroring in SQL server 2005/2008.
• Good knowledge about New features in SQL server 2012.
• Involved in Installing, Configuring and Maintaining of Cluster in SQL Server 2008 and SQL Server 2005 in Active/Passive.
• Auditing database configuration and security configurations.
• Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor, Windows performance monitor, DMVs, Resource Governor, Data collection Reports, DBCC and Custom Script, Built in performance Report and Activity Monitor.
• Scanned the data pages, Indexes and checked the storage space used by each table.
• Experience with Database Backup and Restore.
• Experience in Scheduling and creating SQL Server jobs as well troubleshooting when jobs fail.
• Proficient in migration of Data from Excel, Flat file, Non SQL db’s Oracle/Db2/Sybase to MS SQL Server by using SSIS.
• Working knowledge in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) to manage ETL environment.
• Experience in working with huge databases, troubleshooting issues and documenting the causes.
• Developed writing parameterized Queries for generating reports, formatting report layout, sub reports using global variables, expressions and functions in SSRS 2005/2008R2.
• Ability to meet deadlines, quickly adapt to different project environments and ability to work with different team across geographical locations.
• Experience in providing good production support for 24x7 over weekends on rotation basis.
• Excellent organizational, interpersonal and communication skills with high level of adaptability and flexibility to adjust to changing work positions.
• Strong time Management skills and excellent team player.
• Ability to adapt quickly to changing environments.

TECHNICAL SKILLS

Languages: C, C++, SQL, T-SQL, PL/SQL

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

Web Servers: IIS 6.0, IIS 7.0, IIS 7.5, IIS 8.0, IIS 8.5

Operating System: Windows 2000, Windows 2003/2008/2012 R2Professional

Scripting: Powershell 3.0/2.0, VB Script

Disaster Recovery Tools: Log Shipping, Replication, Mirroring, Always On and Clustering Services

Tools: SCOM, SCVMM, MOM, WireShark, NetMon, LogParser, PortQry, telnet

PROFESSIONAL EXPERIENCE

Confidential

Service Engineer

Responsibilities:

• Installed SQL server 2012 on windows 2012 Enterprise Edition advanced servers, applied service packs and security fixes.
• Participated in servers Upgrade/Migrating from SQL server 2012 to SQL server 2012 R2 and redirecting users to migrated server.
• Created checklists to install SQL Server installation, service packs, security fix and MS SQL cluster installation.
• Maintained Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Responsible for adding server, running EVT to verify the environment and executing the Test cases in CMDB portal
• Worked on manual BVT to see if all the web services are working
• Worked on on-boarding the environment
• Worked with SCOM team to implement monitoring criteria for Web and SQL servers
• Implemented and Scheduled different Database Backup jobs like Full, Differential and Transactional log backup
• Working experience in a 2-node cluster environment where 1 node is active and the other passive.
• Have good experience in installing and configuring SSL for security reasons
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
• Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.
• Design and implement Backups and Restore database policies.
• Preparing/editing the config.xml file for smooth deployment using Octopus
• Install, configure and maintain systems running Windows 2008/2012/2012 R2 and IIS 8.0/8.5
• Involved in deployment with both UI and SQL
• Capacity Planning, Storage Planning, Hardware Upgrade’s and Preparing Estimates for Database, table size growth.
• Raised RFC’s to order for new SQL and WEB servers, SNAT, installing IIS and WEB servers, disk space issues
• Performance monitoring, remote administration, Web application management, automation for Internet facing applications.
• Install security patches, perform Service account password reset, SSL renewal and other regular maintenance work.
• Build operations documentation and update out of date or incorrect information.

Environment: SQL Server 2012/2012R2, T-SQL, Windows 2003/2008, IIS 8.0/8.5,RDCM, SCOM

Confidential, NYC

SQL Server DBA

Responsibilities:

• Involved in installations, upgrades, patches and fixes.
• Migrated the data from SQL Server 2000/2005 to SQL Server 2008.
• Involved in the complete lifecycle and capacity planning of mission critical Databases.
• Monitoring and Troubleshooting jobs in Production, Preview and Development environment.
• Providing 24x7 supports to Production, Preview and Development servers.
• Scheduling SSIS jobs (SQL Agent), Migrating DTS packages to SSIS packages, using DTS upgrade wizard.
• Generating Reports as per the requirement using SSRS 2005
• Involved in Health Check process for SQL Server databases using Database Maintenance Plans.
• Writing DTS as well as SSIS packages for daily sales and delivery reports as well as for adhoc data transforms and data extraction for the Data Migration team.
• Also upgraded DTS packages to SSIS.
• Have good experience in installing and configuring SSL for particular websites for the security purposes
• Using SCOM to monitor the datacenters
• Assisted in the design and development of the Data Modeling and Data Warehouse design.
• Replaced a transaction log replication with mirroring on a report server and took reports from snapshots of the mirror database.
• Coordinated physical changes, current space utilization and performance monitoring of two replicated production servers and two development servers.
• Designing Logical and Physical Data Models with Visio.
• Increased the availability of production databases by setting up mirroring.
• Conducted performance tuning on regular basis to improve performance of slow running queries and stored procedures.
• Implemented Security, which included creating Logins, Users and granting permissions to users.
• Managing security roles in SQL Suite & Install updates and patches.
• Good Hands on experience in configuring virtual machines using Hyper-V and SVMM.

Environment: SQL Server 2000/2005, MS Access, T-SQL, SSIS, SSRS, DTSRUN, Windows2003, Light speed, HYPER-V

Confidential, irvine, TX

SQL Server DBA

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model
• Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Created SSIS packages to export data from Oracle to SQL Server Database.
• Performance: Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
• Supported clustering and replication for servers.
• Generated database SQL scripts and deployed databases including installation and configuration
• Responsible for tier 2 support for more than 10 SQL Servers in a 24x7 mission-critical/production environment.
• Worked on CDC(Change Data Capture)
• Maintained cluster servers to provide high availability.
• Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems
• Used ER/Studio to reverse engineer legacy database from Sybase to SQL Server.
• Created and tuned stored procedures, triggers and tables.
• Created several materialized views and UDF’s to be accessed by the new front end applications.
• Managed Materialized and Partitioned views for better performance.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Provide 24 X 7 supports to all production, development, staging and clustered servers.
• Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.

Environment: SQL Server 2000/2005, T-SQL, CVS, Windows NT/2000/XP/2003, VMWARE

Confidential, IL

SQL Server DBA

Responsibilities:

• Installed SQL server 2005 on windows 2008 Enterprise Edition advanced servers, applied service packs and security fixes.
• Migrating from SQL server 2005 to SQL server 2008 and redirecting users to migrated server.
• Changes in schema and stored procedures according to changes made in application.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Responsible for creating Virtual machines by using HYPER-V Manager and SCVMM tools
• Worked with SCOM team to implement monitoring criteria for IIS and SQL servers
• Responsible for Hosting WCF web services on IIS and good experience configuring IIS security for both web applications and web services.
• Responsible for Application pools creations according application security and performance needs.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
• Created checklists to install SQL Server installation, service packs, security fix and MS SQL cluster installation.
• Implemented and Scheduled different Database Backup strategies like Full, Differential and Transactional log backup
• Working experience in a 2-node cluster environment in production where 1 node is active and the other passive.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping.
• Have good experience in installing and configuring SSL for security reasons.
• Writing scripts to automate SQL tasks using power shell.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
• Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.
• Design and implement Backups and Restore database policies.
• Preparing the golden bits and scripts for smooth deployments to production using applications like Octopus and Sequence manager.
• Install, configure and maintain systems running Windows server 2003/2008 & IIS 6.0/7.0 and participate in server upgrade and planning.
• Good experience in generating reports using SSRS services.
• Involved in deploying and managing websites on IIS servers in both Preview and Production environments.
• Capacity Planning, Storage Planning, Hardware Upgrade’s and Preparing Estimates for Database, table size growth.
• Preparing RCA’s/Postmortem for high Severity tickets/issues.
• Performance monitoring, remote administration, Web application management, automation for Internet facing applications.
• Work on monitoring solutions using Microsoft System Center Operations Manager SCOM and Site Scope.
• Install security patches, IPAK’s, perform Service account password reset, SSL renewal and other regular maintenance work.
• Build operations documentation and update out of date or incorrect information.
• Provided 24/7 supports to all production, development, staging and clustered servers.

Environment: SQL Server 2005/2008, T-SQL, Windows 2003/2008, IIS 6.0/7.0,HYPER-V, SCVMM