Kamalpreet Kaur

908-***-****● acouio@r.postjobfree.com

Experience Summary

* Over 7 plus years of IT experience with exceptional skills in all phase of SDLC, which includes Requirement gathering, Analysis, Database Design, Development, Administration and Support of Microsoft SQL Server 2000/2005/2008/2012 in Development, Test and Production Environments.

* Hands on experience in Backing up and restoring the database, Monitoring and optimizing the performance of the database, Controlling and monitoring user access to the database

* Hands on Experience as Core Production Support MS-SQL SERVER DBA for Databases ranging from 100 GB to 5 TB.

* Extensive experience in handling DBA duties such as Installation, up gradation of MS SQL Server software on Windows Platforms, Database Creation, Database Auditing, and Production Database Support & Maintenance, enhancement, automation, tuning and optimizing databases for high Availability, Encryption, Performance and Security.

* Expertise in setting up and troubleshooting Database Clustering in Active-Active and Active-Passive Mode on a 3 node and mount point storage cluster

* Experienced in SQL Server Replication, Mirroring, Table Partitioning and Log Shipping.

* Experience in creating Jobs, Alerts, SQL Mail Agent, linked servers to run distributed queries between SQL servers

* Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.

* Involved in Database Design, Data modeling, Development, Administration, Implementation, and Reporting (SSIS) in SQL Server 2000/2005/2008/2012

* Knowledge in Application Development Analysis, Requirement Analysis, Scoping, Developing, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.

* Developed & supported various mission Critical issues by handling Database requests for various application development teams involving complex business logic, functionality

* Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs.

* Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.

* Experience in Diagnosing and Troubleshooting performance issues in SQL Server Databases by analyzing execution plans.

* Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, Query Analyser, SQL Profiler, and Windows Performance Monitor for optimal Performance.

* Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS).

* Experienced in working with Proficient using DMVs, DMFs, Wait-States & Performance Monitor Counters to quickly find the Root Cause of performance slow-downs.

* Test & Deploy code across various environments like DEV, TEST, UA/UT, and Production.

* Extensive knowledge of Designing, Developing, Atomization and deploying various kinds of reports using SSRS using relational and multidimensional data.

* Expertise in creating Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.

Technical Specification

* Operating Systems : Windows All Versions and Windows Server

* Programming Languages : C, C++, Visual basic, T-SQL, PL/SQL, ADO.Net

* RDBMS/Database : MS SQL Server 2012/2008/2005, Oracle 8i, Oracle 9i, MS Access

* Database Tools : SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Database Engine, Informatics, Tuning Advisor, Business Intelligence Development Studio, Toad

* Web Technologies : HTML, CSS, XML, VB Script, Java Script

* Web Servers : SharePoint, IIS

* Multimedia : Adobe Photoshop, Corel Draw

Experience

NKBA, Hackettstown, NJ

October 2012 to Current

Sr. SQL Server DBA

The National Kitchen & Bath Association (NKBA) is a not-for-profit trade association that promotes the professionalism of the kitchen and bath industry with more than 60,000 members across North America and Canada.

Responsibilities:

* Installed and maintained SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.

* Developed and modified stored procedures, functions, triggers and supporting objects according to dynamically changing requests.

* Analyzed the complicated processes to improve the performance.

* Building Cluster servers for SQL Server environment.

* Configuring and setting up Replication.

* Involved in physical and logical database redesign and migration from SQL Server 2005 to SQL

Server 2008 R2 platform.

* Evaluating data modeling, database administration, and database backup and recovery tools and

make recommendations.

* Managing database storage for optimal use.

* Facilitating multi-user transactions avoiding blocking and deadlocks

* Checking and minimizing the fragmentation in the database.

* Running update statistics, index rebuild, dbcc checkdb on periodic/scheduled basis

* Using SQL profiler, DMV for database performance monitoring

* Utilized various recovery models and recovered the database during the event of crash on several

occasions. The Recovery was done to Point-in-time

* Automating the Backup and Maintenance of user databases using SQL Server Agent.

* Configuring Alerts to be fired in the event of failed backups or performance issues.

* Involved in table redesigning with implementation of tables and indexes compression.

* Analyzed user requested proposed changes to bring new functionality into programs.

* Worked closely with QA team.

* Developed reports on daily and monthly basis

Software: MS SQL Server 2008 R2, SQL Server 2012, SQL Server Management Studio, .Net

Redcats, New York, NY

June2009 to September 2012

SQL Server DBA

Redcats is a group of commercial companies deals in Fashion, Sports and Home decor products on the web. Redcats represents a portfolio of 17 European and American brands for men, women and children.

Responsibilities:

* Managed SQL Server instances, monitor server performance tuning, backups and recovery.

* Implementation of SQL Roles & Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

* Server/Instance Level Configuration Check, I/O distribution Analysis, SQL Server Resource Wait Stats Analysis, Index Analysis, TempDB Space Review, Fragmentations and Defragmentation, DBCC Best Practices Implementations as precautionary measures

* Worked with other enterprise teams to coordinate deployment, configuring services, applying patches and hot fixes.

* Performed migration processes to upgrade SQL Servers (SQL Server 2005 to 2008 R2).

* Provided database design assistance for system enhancements and new systems development, including logical data modeling, normalizing, de-normalizing, and physical table design.

* Developed stored procedures, functions, triggers, traces, DTS/SSIS Packages and utility jobs.

* Provided on-call support for the systems and the associated software products when needed.

* Developed multiple Cost Reduction automated processes and scripts to reduce manual efforts.

* Experienced in Performance Tuning, Query Optimization, using Performance Monitor and SQL Profiler.

* Monitor SQL replication on live environment and troubleshoot errors within timeline

* Designed various custom and ad-hoc reports.

* Migrating some databases to cloud computing (AWS).

* Setup and maintenance of appropriate database and application monitoring.

* Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.

* Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.

* Set naming conventions for objects based on SQL standards.

Software: MS SQL Server 2005,2008; VB.NET;

AGADIA, Parsippany, NJ

Jan 2007 to May 2009

SQL Server DBA / Developer

Agadia is a medical product based company deals in softwares for doctors and insurance companies for prescription drugs.

Responsibilities:

* Creating and maintaining databases

* User accounts creation and roles management

* Created Stored procedures through PL/SQL for data entry and processing.

* Review of pheysical and logical database design;

* Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.

* Developed triggers for auto processing.

* Created Indexes and views as required by the application.

* Database backups, recoveries and restorations

* Database tuning and performance monitoring

* SQL server 2000 & 2005 Installations and related service Packs

Software: Visual Basic 6; VB.NET 2005; MS SQL Server 2005; MS Access, Excel.

Education

* Masters of Computer Applications ( 2006-2007)

* Masters of Science (Information & Technology) (2004-2006)

* Bachelor of Computer Applications (2001-2004)

Contact this candidate