SUMMARY:

• Over 8 years of experience in IT industry as SQL Server Administrator/Developer and support of MS SQL Servers 2012/2008/2005/2000 in Production, QA, and Development environments.
• Experience in installation and configuration of MS SQL Server 2012/2008/2005/2000 versions.
• Experience in Creating Databases based on Functional Requirements and System Design.
• Administered, Maintained, Developed, Implemented Security Policies using Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience in creating Maintenance plans, jobs and alerts.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities, Database Engine Tuning Advisor (DTA) and Index Tuning Wizard.
• Experience in monitoring database performance using SQL Profiler and Windows Performance Monitor.
• Experience in Policy Based Management, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in implementing Backup and Recovery Strategies.
• Experience with configuring the high availability and Disaster recovery scenarios like clustering, Log shipping, mirroring and Replication.
• Experience in creating Linked Servers.
• Extensively involved in Upgrading SQL 2005/2000 to SQL server 2008, 2012.
• Experience in creating and maintaining Documents for future needs.
• Experience in using third party tools like Redgate and Litespeed for backing up and restoring the databases.
• Expertise in writing and reviewing Stored Procedures, Functions, Cursors and Triggers using T - SQL.
• Administer & Support mission critical databases and provide 24*7 Production support.
• Good communication, analytical and inter personal skills and ability to learn new concepts.

TECHNICAL SKILLS:

Databases: Microsoft SQL SERVER 2012 2008 R 2/ 2008/2005/2000 , ORACLE, MS Access

Languages: SQL, C, C++

Reporting Packages: SQL Server Reporting Services

Database Utilities: Enterprise Manager, Query Analyzer, Sql server Management Studio, Profiler, import & Export, Data Base Tuning Advisor, Business Intelligence Development Studio (BIDS), Perfmon

Operating System: Windows 2008/2003/2000 XP, UNIX, Linux

Tools: MS Visual Studio, MS Visio, Erwin, Redgate, Litespeed, Crystal Reports 2008 SAP Business Objects

PROFESSIONAL EXPERIENCE:

Confidential, PA

SQL Server DBA

Responsibilities:

• Responsible for the design of the backend MS SQL databases for public facing, medium-to-large scale applications.
• Designed and coded relational database objects in MS SQL, including tables, stored procedures, views, triggers, etc
• Converted the existing databases from SQL Server 2005 to 2012 version.
• Coordinated with the development team to build a new SQL solution for Autotab that will support statewide user requirements and business partners.
• Developed, tested and deployed SQL stored procedures to prepare data for use in Microstation, tabulation sheets, reports, data exports and required uploads to ECMS, Estimator, CDS NextGen and other identified applications to support single data entry requirements.
• Implemented local backups(Full, Differential and transactional log backup for the point in time recovery)
• Implemented the log shipping for Disaster recovery.
• Implemented Transactional replication for replicating certain tables from the client facing databases to the processing databases.
• Worked in Active Active, Active Passive Cluster environment as a High availability solution.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Resolved the performance issues by optimizing the existing slowly performing queries and the stored procs.
• Helped developers in importing and exporting the data using SSIS.
• Developed database management system manuals to document procedures for defining, creating, revising, expanding, archiving, and backup, recovery and maintenance of identified databases.
• Supported Deployments and Maintenances.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Environment:MS SQL Server 2005/2008/2008 R2/2012, SSIS,T-SQL, Win 2008/2003

Confidential, MI

SQL Server DBA

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2008/2000.
• Created DB objects like Tables, Stored procedures, Functions, Triggers and Views using T-SQL.
• Implemented Database Mirroring with High Availability Mode in SQL 2008.
• Managed the use of disk space, memory and connections. Running DBCC consistency checks, fixing data corruption in application databases.
• Worked with Transparent Data Encryption using SQL server 2008.
• Implemented Resource Governor in SQL server 2008.
• Created Logins, users, roles and involved in Daily User Maintenance.
• Migrated databases from SQL Server 2000 to SQL Server 2008.
• Used Performance Monitor, Profiler, and Database Engine Tuning Advisor to solve Dead Locks/Long running queries.
• Used Policy Based Management feature (SQL Server 2008).
• Worked on reviewing the code developed by developers.
• Worked with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Generated automation alerts for backup jobs, scheduled jobs, and system performance.
• Solved Tickets on Daily Basis for Production Issues.
• Worked with tools like LiteSpeed for backups and Restore.
• Worked with System and Networks administrators as a team to analyse system performance, determining proper applicability of maintenance and programmatic approaches versus hardware solutions.
• Prepared and documented database Backup and Maintenance Plans.
• 24 X 7 Production Database on Call Support.

Environment: MS SQL Server 2000/2008, T-SQL, Win 2008/2000, LiteSpeed

Confidential

SQL Server DBA

Responsibilities:

• Installation & Configuration of SQL Server 2005/2000 Servers
• Created new Instances, databases, schemas, objects and table spaces/file groups.
• Worked with the application team, SME, business leads and vendors to identify project requirements.
• Responsible for production support, of 80 total servers in which 53 are mission critical production servers.
• Configuration, creation and administration of jobs, schedules, DTS tasks.
• Involved in Creation of DB objects like Indexes, Stored procedures & triggers using T-SQL
• Created Logins, users & roles and involved in Daily User Maintenance
• Created Database Maintenance jobs to perform Full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler
• Capacity planning and allocating disk storage for databases.
• Created Linked Servers across Other SQL Servers and MS Access and uploaded data using the linked servers
• Set up Transactional Replication between servers and troubleshoot the issues
• Worked on Active/Passive two node Clustering servers for high availability.
• Monitoring and tuning the performance of database using Perfmon, SQL Profiler and Trace files.

Environment: MS SQL Server 2005/2000, T-SQL, Win 2003

Confidential

SQL Server DBA

Responsibilities:

• Installation, Creation, Administration and Maintenance of SQL Server Databases (Production / Development / test)
• Maintenance of Production and Development Servers, ensure the availability of the production databases to end-users and development database to developers in a 24x7 environment
• Security Implementation, Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
• Data transfers between various servers using DTS.
• Involve in co-ordination between On-site and off-shore teams member. Working effectively around the clock for resolving issues
• Wrote stored procedures, which generates SQL statements depending upon the combination of parameters passed for the search module.
• Involved in creation and design of Database and its normalization.
• Creating and managing DB objects such as tables, views, indexes, stored procedures, triggers and constraints.
• Involved on implementing Backups/Restores of data, index and log files.
• Involved in configure and maintaining Replication Server
• Perform code review on SQL and related code as needed.
• Documenting and bug fixes and resolution of Tickets

Environment: SQL Server 2000, Visual SourceSafe, Enterprise Manager, Windows 2000, Data Transformation Services (DTS)

Confidential

Software Engineer

Responsibilities:

• Worked on call 24/7 Support on weekly basis.
• Installation and configuration of MS SQL Server and Clients.
• Database designing, Logical and Physical Data modelling using Erwin. Transformed logical model into Physical SQL Server Database, Created SQL tables using scripts
• Implement high availability through database mirroring and Merge Replication.
• Knowledge Import / Export using DTS and BCP utility.
• Involved in deployment of SQL scripts.
• Designed DTS packages to refresh data on Development and QA/Staging.
• Wrote dynamic stored proc to create Database Roles and grant permission to roles and adding logins to specified roles.
• Designed new schema for data partition and created Partition views for better performance.
• Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.
• Performance Tuning, Analyze, tuning and optimizing for SQL Server Application by using performance monitor. Assist the SQL Developers in SQL tuning.
• Created Stored Procedures and triggers to perform automated rules, updating to related tables.
• Discussions with Product team for new features.

Environment: MS SQL Server 2000, Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS)