SUMMARY

• 5 years of IT Experience as MS SQL Server Database Administration and Developer in Database Design, Testing and business intelligence of Microsoft SQL Server 2000/2005/2008/2008 (R2)/2012 in Development and Production Environments with various business domains like Financial, Healthcare, Manufacturing and Insurance services.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2012/2008R 2/2008/2005/2000.
• Expertise in core DBA tasks likeInstallation, Maintenance, Configuration, Backup & Restore, DR, Database Security and, Database designing.
• Extensive experience in managingMS SQL Server on Windows 2000, 2003 and 2008 Servers.
• Creation and maintenance of Databases, creatingRoles and managing userpermissions, resolving Blocks and Deadlocks
• Experience in using tools likeSQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance, Idera Diagnostic Manager
• Creation ofJobs Schedules, Alertsusing SQL Server Agent and Notifications usingSQL Mail and Database Mail.
• Experience in Creating and Updating Clustered and Non - Clustered Indexes to keep up the SQL Server Performance.
• Very good T-SQL Programming skills. Used SQL Profiler, Execution Plan, Performance Monitor to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Developed Drill Down, Cascading, Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users.
• Experience in enhancing and deploying the SSIS Packages from development server to production server by using package configurations.
• Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP). Worked with Data mining and slowly changing dimensions.
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Involved in DBA activities such as backups, restores, replication and creating Logins, Roles on different databases.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
• Experience on database design forlarge databases.(terabyte databases)
• Good understanding ofchange control process
• Available for24*7productionsupport in mission critical environment.
• Goodinterpersonal, analyticalandcommunicationskills.

TECHNICAL SKILLS

Database: MS SQL SERVER / 2005, MS Access 2013/2010.

Operating Systems: Windows, Linux.

Programming Languages: Transact SQL, C, and Macros.

Web Technologies: XML.

Productivity Applications: MS Word, MS Excel, MS Access.

DB Tools: SQL Server Management Studio, SQL BIDS, SQL Server Data tools, SQL Profiler

ETL Tools: DTS, SSIS.

Reporting Tools: MS Access, MS SQL Reporting services (SSRS), Crystal Reports, and Microsoft Excel.

Data Modeling Tool: ERWIN, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Liberty Corner, NJ

MS SQL Server DBA

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect.
• Installed, Configured and Administered SQL Server2008R2/2008/2005Servers in Production, QA and UAT Environments.
• Migration ofSQL Server2005 to SQL Server2008, SQL Server .
• Migratedsome databases from Oracle 11g to SQL server 2008R2
• Worked closely with application team, manager and other DBA’s forplanningandimplementationof themigration.
• Involved withchange control boardto ensure proper approvals and meet the timeline fordatabase migration.
• Successfully implementedDatabase Mirroringin SQL Server 2005/2008R2 forhigh availabilityon twoVMware servers.
• Createddatabases, Logins, Roles and grantedappropriate permissions.
• ConfiguredDatabase Mailto send out notifications
• Managing SQL server usingPower Shell scripts
• InstalledSQL Safeon all the database servers.
• ConfiguredLog Shippingfor high availability on SQL 2000
• Configure and manage database maintenance plansfor update statistics, database integrity check, backup operations and indexing updates
• Installed and Configured 2- node High availability SQL Active/Passive clusters.
• Created documentation to install SQL Server 2005, applyservice packs,hot fixandclustering installation.
• Database refreshes fromprod to stage, test and developmentenvironments.
• Performed Administrative tasks in SQL Server usingPower Shell
• Conducted databaseperformance monitoringandtuning
• Proven experience in maintenance of SQL Server in aVLDB environment & experience in troubleshooting and resolving problems.
• Installed SQL server instance onVMware server.
• Createdjobs, alerts, activity logs, error logsto capture any possible errors.
• Creating andmanaging schemaobjects such as tables, views, index, and procedures.
• Good Knowledge of usingVMware Servers.
• Experience in working withITGticketing system.
• Experience in providing excellent24X7Production support.

Environment: Microsoft Windows Server 20 /64 bit, MS SQL Server 2008 R2/2005/2000, Idera SQLSafe, T-SQL.

Confidential

MS SQL Server DBA

Responsibilities:

• Installed and configuredSQL Server 2005inproductionanddevelopmentenvironment.
• Upgraded SQL Server2000to SQL server2005/2008in 32 and 64 bit environment.
• Active involvement in installing and managing multiple2node failover clusterset up inactive/passive environmentas a High Availability mechanism.
• Successfully implementeddatabase mirroringwithhigh availabilitymode in SQL Server 2005.
• Configuredtransactional Replicationfrom multiple subscribers for reporting purpose.
• Involved inperformance tuning, optimizationof stored procedures and queries.
• Worked with customers to resolve the connectivity issues
• Set up linked servers in SQL 2005
• Estimated disk storage requirements for database software, database files.
• Monitoring and troubleshootingperformance during peak periodswith concurrent connections.
• Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates.
• Use custom scripts so as to help automate routine tasks such asMaintain operators, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Created automated procedure for daily, weekly and monthly system maintenance tasks such asdatabase backup, replication verification, and database integrity verification and indexing updates.
• Good Knowledge onSQL Lite Speeda Backup solution for MS SQL Server.
• Good Knowledge of usingVMware Servers.
• Experience in providing excellent24X7Production support.
• Experience in contacting Microsoft forproductandtechnicalsupport.

Environment: Microsoft Windows Server 20 /64 bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft SQL Server 2008 and SQL Lite speed, spotlight, DELL power edge.

Confidential

MS SQL Server DBA/ Developer

Responsibilities:

• Involved in Optimization and Performance Tuning of SQL Server usingSQL Profiler and Performance monitor
• Developbackup and recoverystrategy
• Configuring Microsoft Cluster on the Servers (4 node Active/Active cluster with 5 instances)
• Managing the use ofdisk space, memory and connections. Running DBCC consistency checks, and fixing data corruption in application databases
• Involved in replication setup, configuration and maintenance in transactional replication for student scheduling and Grade reporting application
• Troubleshooting Replication Errors and handling Logs
• Manage databaseusers/profiles and security
• Implementing SQL Server and Database security policies
• Creating and managing database objects such astables, views, clusters, indexes, procedures, triggers and maintained Referential Integrity
• Maintaining SQL Script for creation of Database Objects
• CreatedStored Procedures and Triggersfor the Application
• Optimized SQL queries for efficiency and provided queries and procedures for the front-end application
• Involved in scheduling tasks and Setting Alerts, Managing Task Scheduling, setting up a SQL mail, managing alerts, monitoring and tuning SQL Server, SQL Performance monitoring, monitoring and tuning memory and monitoring locks

Environment: Windows 2008 Server, SQL server 2012, Event Viewer, SQL Profiler, T-SQL.

Confidential

SQL SSIS DEVELOPER

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS)
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Involved in installation and configuration of SQL Server 2000 and SQL Server 2005 with latest Service Packs.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Tested queries to optimize the procedures and triggers to be used in production.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Created documentation as required.

Environment: MS SQL Server 2005, T-SQL, DTS.