SUMMARY

• Over 7 years of experience as SQL Server database administrator in Production, Test, and Development Environments.
• Experience in installating, configuring and managing of MS SQL Server 2008, 2005, 2000.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups.
• Upgrade/Migration of MS SQL Server 2000 to MS SQL Server 2005 or MS SQL Server 2005 to MS SQL Server 2008 using any suitable approach
• Experience in high availability/contingency solutions - Replication, Log shipping & mirroring.
• Knowledge with SQL Server Storage Structures, Index and Security Architecture.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Experience with Create and Maintain enterprise databases, Backup & Recovery, Security, Performance monitoring and tuning.
• Deep knowledge in Relational Database Management (RDMS) concepts.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Experience with DTS, SSIS, SSRS, and SSAS for various BI purposes.
• Experience in supporting Large Databases and Troubleshooting database issues.
• Extensive experience with Storage Capacity Planning, including system storage allocation, on-going capacity analysis and planning future storage requirements.
• Optimized the Disk space for performance using RAID and SAN.
• Intensive experience in Monitoring and Tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizar, Windows Performance Monitor and MDW.
• Experience in Active directory, group policies, and various SQL Server Security Administration
• Expertise in Security management and auditing the databases
• Extensive experience with data modeling, logical and physical database design
• Good Knowledge in Oracle 8i/9i/10g.
• Experience in designing, implementing, maintaining and documenting complex database applications.
• Experience working with Production 24/7 and Development Environments.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Hands on experience in Experience in writing and debugging stored procedures and triggers.
• Excellent problem-solving skills and good communication skills.

TECHNICAL SKILLS

Operating Systems: Win 95/98/NT /2000/XP/2003, MS DOS, UNIX, Red Hat Linux

Languages: SQL, PL/SQL, Basic of .net, C, C++, Confidential -SQL, XML, HTML, Shell Script

Databases: Access 2000, Oracle 9i,10g, MS SQL 7.0/2000/2005/ 2008 , Sybase

Database Technologies: ODBC, OLE DB, DTS, Cross Database Data, Transformation/Exchange, BCP, Data Modeling, Schema and Metadata creation and design, Maintenance Plans, Backups and Recoveries, Disaster Recoveries, OLTP

Protocols: HTTP, TCP/IP, FTP, SFT, SSH, TELNET

Networking: Servers: NT/2000/2003

Web Tools: ASP, HTML, Java Script, XML

DB Tools: TOAD, ERwin 4.0, ER Studio, Lite Speed, SQL Profiler, Performance Monitor, IIS, Microsoft Visual Studio, SQL Server Business Intelligence Development Studio (BIDS)

ETL Tools: DTS Packages, SSIS

Documentation Tools: Source Safe, Word Processor, PowerPoint, Excel & Access.

Reporting Tool: SSRS, Crystal Reports

DB Design Tools: Kalido 7.1, Visio, Smart Draw

Disaster Recover Tools: MSCS Fail over Clustering Services

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior SQL Server DBA

Responsibilities:

• Configuring, Installing, Managing, Monitoring and Troubleshooting SQL Server 2008 Database Servers and updated latest Security updates involving Service Packs and Security patches
• Performed upgradation of SQL Server 2005 to SQL Server 2008. Setting up new SQL Servers and configure required users
• Involved in configuring 2-node Clustering Configuration (Active/Passive) in SQL Server 2005.
• Installed, configured and maintained MS SQL Server Replication for production servers to provide High Availability.
• Setup SQL Server 2005 Database Mirroring to maximize availability of PROD databases
• Used new features like row and page compression mechanism, Data Compression, Backup compression and Transparent Data Encryption
• Regular monitor of servers, which includes Backup Job monitoring and troubleshoot all the issues on regular basis.
• Automating administration tasks, managing SSIS packages, managing security, monitor server performance and activities.
• SQL Server Administration, service start, pause, stop, failover.
• Resolving various performance issues and running DBCC commands, SQL Profiler and NT monitoring tools.
• Monitored database status including CPU, Memory, I/O, space and Dead Lock using SQL Server Utilities
• Import/export data, backup restore database, managing servers, managing clients.
• Managing databases, tables, indexes, views, stored procedures, enforcing business rules with triggers and user defined functions.
• Perform Full Backups and Transaction Log Backups. Restore them whenever necessary; creating back up strategies and scheduling them for execution.
• Plan and Schedule the Online/Offline Backups.
• Creating alerts, schema management, database reorganization, data loading, database maintenance, and optimization.
• Managing SSIS packages/DTS packages.
• Modified SSIS ETL package for changed business requirements to load data from different source files to SQL Server tables in data warehouse.
• Used Online Indexing and online Restoring in SQL 2005
• Designed and generated simple, custom and complex reports against the new cubes using SQL Server Reporting Services (SSRS) 2008
• Design and develop BCP and SSIS (ETL) packages for loading data from Oracle 10g and Flat files to SQL and Oracle Data base.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard, Dynamic Management Views (DMV) in SQL Server 2008.
• Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Used BCP Command line tools to Import/export the table data into Flat Files and Flat files to tables.
• Managing SQL Server nodes on Cluster.
• Managing backups using Litespeed.
• 24/7 On-call support and production support.

Environment: MS SQL Server2005/2008, Windows 2003, DTS, Confidential -Sql, ER Studio 7.5, ERWIN, SQLLite Speed, Litespeed backup, BCP,OSQL, Surface Area Configuration, Sql Profiler, SSIS, Reporting Services.

Confidential, Framingham, MA

SQL Server DBA

Responsibilities:

• Responsible for installation, configuration and maintenance of SQL Server database on different platforms.
• Providing 24x7 production support for SQL Server databases with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Upgraded the database SQL Server 2000 to SQL Sever 2005 and migrated DTS objects to SQL Server 2005 (SSIS) Integrated Services environment.
• Created DTS packages to import and export data from SQL Server to Access, Text and Excel files.
• Set up the DTS for Exchange of data between different data sources (SQL Server, Oracle and DB2).
• Worked in Active passive cluster environment.
• Setting up, Configuring and troubleshooting Log Shipping for databases on Disaster Recovery (DR) servers.
• Created proper back up strategy using Full, Transaction and Differential to minimize data lose and Simple, Full and Bulk-Logged Recovery models to restore and recover the data.
• Involved in generating the reports for a variety of topics using Crystal Report and SQL Server 2005 Reporting Services.
• Successfully implemented Database mirroring in SQL server 2005 for disaster recovery and monitor databases involved in mirroring session
• Set up, configure, and administer Transactional Replication and execution of real-time and delayed data replication across the enterprise.
• Performed Index Tuning, Query Tuning for better performance.
• Ran SQL Profiler to identify expensive queries and used database Tuning Adviser.
• Monitored database performance and rebuilt indexes on tables using index tuning wizard to return quicker response time.
• Configured SQL Server 2005 in-built log shipping from primary server to standby server and generated Reports.
• Designed and created Views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Created and modified database objects, including tables, indexes, views and store procedures.
• Experience in Schema Creation and Maintenance.
• Worked with SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Involved in design and generation of reports for different data source, performing transformation and loading that data into another data sources.
• Worked on shell scripting in UNIX environment.
• Imported and mapped the data to create tables and temp tables to research issues.
• Created and managed logins, roles, assigning rights and permissions to the users.
• Data modeling using ERWIN data model tool.
• Experience in using OLTP and OLAP Technology.
• Utilized various replication methods to synchronize data Confidential multiple targets.
• Created and modified Jobs on day to day basis, and set up the email notification on unsuccessful Jobs using SQL mail.
• Managed VERITAS net backups and Litespeed backups.
• Experience in Database Designing, Business System Analysis and Involved in Documentation.

Environment: SQL Server 2005, Windows 2003, Unix, Enterprise Manger, Management Studio, Veritas, SQL LiteSpeed backup, MS Reporting Service, MS Integration Service, Data Transformation service, SQL Profiler, ERWIN, Confidential -SQL

Confidential, GA

SQL Server DBA

Responsibilities:

• Extensively worked on migrating from SQL 2000 to SQL 2005 for web applications.
• Provided production support for the automated meeting logistics management system for field use.
• Perform and schedule administration tasks like Backup and Restore Database.
• Database space management, Monitoring Performance and Alert Management.
• Involved in Clustering SQL Server in case of fail-over and to achieve high availability of database.
• Monitor and manage transactional and snapshot Replication
• Trouble shooting the issues incurred while executing the Jobs.
• Creation of New user Logins and grant privileges to users/Groups and objects.
• Installing software upgrades for SQL Server.
• Worked with Database engine
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools SQL Trace, TOAD and Oracle Enterprise Manager.
• Database health check, pinning of objects, Monitoring the Database Growth and increasing the table space sizes, Reorg of Table spaces, Identifying and Recompiling invalid schema objects.
• Created roles and managed security on Oracle databases.
• Involved in reviewing and designing table additions, changes, deletes according to the Database Change Request form.
• Involved in Data Modeling using Data modeling tool ERWIN.
• Involved in Database Designing and Writing Stored Procedures, Views by using Confidential -Sql
• Maintained repository for the SSIS Packages, .NET applications, scripts, documentation etc.
• Installed and configured Internet Information Services (IIS) on the new box for side by side migration.
• Involved in Database Designing and Writing Stored Procedures, Views by using Confidential -Sql
• Involved in Database Migration from MS SQL Server .
• Designed various DTS packages to import/export data from heterogeneous files.
• Involved in Creating SSIS packages to integrate the data coming from various data sources.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Implemented and maintained snapshot and transactional replication.
• Merge replication configuration for SQL Server 2005 CE subscribers
• Involved in distributed transaction processing via linked server.
• Implemented Database Mirroring, Log shipping.
• Monitored Connections, Locks and Performance of SQL Server 2005.
• Worked on capturing the events running against the database using Profiler trace and analyzed them using the tool Database Tuning Advisor.
• Document all database changes and follow and enforce change and release management processes using Visual Source Safe.
• Managed VERITAS net backups.
• Created Full Text search Indexing for fast and flexible key word base Query
• Used multiple database connectivity protocols like ODBC and DAO to handle MS SQL Server licensing issues.
• Experience in using OLTP and OLAP Technology.
• Merge replication configuration for SQL Server 2005 CE subscribers.
• Working in active 24x7 on call support.
• Monitoring various Jobs for Program Completion Tasks, Task Management and Reconciliation Process running Confidential specified Schedules

Environment: SQL Server 2000/2005,Oracle 9i,10g,Windows Server 2003, SQL Server Enterprise Manager, Confidential -SQL, Sybase,SQL Server Profiler, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL Server 2005 Reporting Services (SSRS).

Confidential

SQL Server DBA

Responsibilities:

• Database planning in relation to physical and logical data architecture
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data using ERWIN.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.).
• Designed and facilitated the implementation of data warehouses required by application systems.
• Developed and maintained data methodologies, procedures, and standards. Performed data impact analysis. Properly maintained core or control application tables.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Configured SQL Server 2005 in-built log shipping from primary server to standby server and generated Reports.
• Worked with Database Engine Tuning Advisor.
• Created the DTS interfaces to vendors in which records were loaded daily, also to other data resources such as Excel, Access, and XML in order to create and maintain a centralized data warehouse.
• Review of all new software and 3rd party tools.
• Published the databases from old servers to new servers using snapshot replication.
• Updated the statistics info for both the old and new servers.
• Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipate technological innovations.
• Supported development effort by providing Confidential -SQL statement tuning and optimize data loading processes.
• Assisted with various ad hoc query requests.

Environment: SQL Server 7.0/2000, Enterprise Manger, Confidential -SQL, Active Directory, Windows 98/2000, OLAP, DTS, PWS, performance tuning.

Confidential

Junior SQL Server DBA

Responsibilities:

• Installed new hard ware on SQL Server and upgraded SQL sever 7.0 to SQL Server 2000.
• Designed a relational database on students and staff Confidential Kean University utilizing ID number, city, student major, important dates, staff number and department.
• Performed daily Backup and Restore on routine basis.
• Created student ID and password as a Junior DBA.
• Extensive knowledge of Relational Database Management Systems.
• Creating logins, groups, users, roles, database devices, databases, checking for database consistency, monitoring error logs, database space allocations.
• Created Tables, Store Procedures, Function and Triggers to perform task.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Create operator to be notified by email, net send or pagers for any issues.
• Create alert to notify the operators after executing the packages, also create packages to raise an alert when an event or severity of the error occurred.
• Created DTS packages for various data feed from different schools on campus.

Environment: SQL Server 7.0/2000, Enterprise Manger, Confidential -SQL Windows 98/2000