SUMMARY

• 7+ years of experience in Database Administration, Development and Design with SQL Server 2008/2005/2000 in banking, services and manufacturing sectors.
• Experience in managing Windows 2000/2003/2008 servers in a clustered environment.
• Experience in supporting Very Large (VLDB) and highly transactive databases and troubleshooting the performance bottle necks SQL Server Profiler and Perfmon.
• Experienced in high availability SQL Server solutions, including SQL Server Log shipping, Mirroring and SQL Server clustering.
• Experience with SQL Server 2008 New concepts like Hot - Add CPU, Hot-Add Memory.
• Familiar with SQL Server 2008 concepts like Data Compression, Backup stream compression.
• Experience withSQLserver 2008 new index types like FILTERED indexes.
• Familiar with Database Encryption and NewSQLserver 2008 Data types like Date, Time,GEOMETRY and GEOGRAPHY data types.
• Experience in Installing and Configuring and supporting 2-node (A/A, A/P) and 4-node (A/A/A/P, A/A/P/P) Clustered Environment.
• Experience in Replication - Snapshot and Transactional and extensive knowledge in Merge replication
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects using RAID levels.
• Implemented Data portioning Technique introduced inSQLserver2005.
• Very strong DBA skills such as backup and disaster recovery, performance monitoring and improvements & daily preventive maintenance of multiple SQL
• Experience in enterprise-scale relational Data Models and Data Warehouse, including both relational and dimensional models and the use of standard data modeling tools, preferably ERWin.
• Extensively worked on 32 bit, 64 bit and i64 clustered and standalone server environments.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Expert in implementing business logic by using TSQL, Stored procedures, triggers (DDL, DML and DCL) and functions (Inline & Multivalued Table functions).
• Implemented 2005 new concepts like online indexing and DDL TriggersForBetter performance.
• Expertise in writing Complex Multi Dimensional Expression (MDX) Queries, Data Mining Extension (DMX) queries, XMLA Queries.
• Experience in Backup tools like SQL Safe and LITE SPEED for fast and efficient database backups.
• Experience with other 2005 new concepts like DMV’S, DMF’S, and performance dash board.
• Experience with Normalized and de-normalized database design.
• Experience in Business Intelligence (BI) development on Teradata and administration environment using MSTR for SQL server reporting (SSRS) and integration services (SSIS) 2000/2005.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert from heterogeneous databases like Oracle, MS Access, and DB2.
• Extensively worked on RDBMS concepts to design Relational Database model as per Business requirement
• Extensively worked on VMware and SAN network and Implemented SQL Server 2000/2005.
• Experience in developing Crystal Reports to generate reports often to check the status
• Rebuilding the indexes at regular intervals for better performance, managing the VERITAS net backups.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Trouble shooting on network issues with TCP/IP and all other std protocol, also responsible for client configurations
• To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging above 2 TB to achieve maximum performance and uptime in production environment.
• Experience with version control systems like Microsoft Visual Source Safe (VSS).

TECHNICAL SKILLS

Operating Systems: Windows ME/NT/2000/XP/Vista/2003/2008, UNIX, DOS, LinuxMainframes (z/OS)

Databases: MS SQL Server 2008/2005/2000/7.0/6. x, MS Office AccessOracle, DB2, Sybase

ETL Tools: MSTR, DTS (Data transformation services), Integration ServicesCrystal reporting, Teradata

Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, Import/ExportSSAS, Replication server, OLAP Services, SQL Agents, SQL AlertsSQL Mail, Microsoft IIS 6, VSS, SQL Client Configuration utilityReplication Tools.

Languages: T-SQL, HTML, XML, C, C++, PL/SQL, JCL, COBOLPERL & VB scripting

Backup and Monitoring Tools: Lite speed, VERITAS Net Backup, Spotlight, MOM, IP Mon.

PROFESSIONAL EXPERIENCE

Confidential, Edison NJ

SQL Server DBA

Responsibilities:

• Installed SQL Server 2008/2005 on windows 2003/2008 on clustered environment.
• Worked on 32 bit, 64 bit clustered environments
• Performed Node Injection for the enhancements of hardware in the Clustered environment.
• Installed and configured and maintained failover clustering for SQL SERVER 2005
• Migration of databases from SQL Server 2000/2005 to SQL Server 2005, 2008.
• Monitored Log shipping as high availability solution.
• Configured Server Memory for maximum Performance and effective utilization.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Integrated Performance monitor and SQL traces to have better graphical analysis to find system bottlenecks. system bottlenecks.
• Primarily involved in providing production support of DB2 UDB databases on AIX and Linux servers.
• Extensively used Filtered indexes to improve query performance and lower storage and maintenance costs.
• Experience in performing Compression Backup for efficient utilization of disk space in SQL Server 2008.
• Designed and implemented comprehensive Backup plans and disaster recovery strategies
• Migrated DTS packages to SSIS packages
• Developed several 2008 SQL Reporting Services, with Visual Studio and supporting Stored Procedures.
• Experience in analysis, design, development, reporting, testing, and debugging of business applications using MS Access 2003 and Excel
• Used Error handling and Error logging techniques to capture data in SSIS in various ETL solutions.
• Worked on Data portioning for high availability of data
• Used Dynamic Management Views (DMV) for monitoring the performance of the server
• Maintaining the database consistency with DBCC at regular intervals
• Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Created Maintenance Plans that helped in effective disk utilization and index maintenance.
• Effectively managed disk space using LITE SPEED for Data base Backups
• Configured Database Mail for SQL Servers for the Positive Mail Notification.
• Export all Maintenance Packages and brought them under Source control
• Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.
• Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Worked on multiple instances of SQL server using VM Ware
• Extensively worked on Production support and involved in trouble shooting SQL servers in various levels.

Environment: Windows 2000/2003/2008, MS SQL Server 2000/2005/2008, MSCS, DB2 Microsoft IIS 6, Microsoft.NET, SSAS, MS Office Access 2003, MS Visio Pro 2002.

Confidential, Columbus, GA

SQL Server DBA

Responsibilities:

• Involved in upgrading the instance of development environment of SQL Server 2005 to SQL Server 2008.
• Designing/ Implementing Backup policies for databases.
• Creating, maintaining the users, roles and granting privileges.
• Scheduling the Database Backup and Differential Backup of Transaction Logs
• Completely responsible for restoring the SQL database at critical time Zone
• Ensuring availability and performance of the databases that support the system.
• Rebuilding indexes on various tables.
• Problem solving and issue resolution on production stand alone and cluster databases.
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments
• Responsible for all data clean up, optimization, performance tuning and all backups.
• Implemented Log-Shipping as high availability solution using both Enterprise and Standard SQL Server 2005 editions.
• Optimized the performance of queries with modifications in T-SQL queries.
• Automated manual data processes of collection of data to several MS Access databases by the use of VBA MS Access forms and SQL inserts, updates and queries.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Writing stored procedure and SQL Queries.
• Created database objects like tables, views, indexes, stored-procedures, triggers and cursors.
• Designing the Logical and Physical databases and development of SQL Server Database.
• Database testing, maintaining the data and writing the procedures.
• Fine tuning the Database Settings as well as the Server Settings.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.

Environment: Windows 2003, MS SQL Server 2005/2008, Microsoft.NET, SSIS, MS Office Access 2003.

Confidential, Killeen, TX

SQL Server DBA

Responsibilities:

• Installed SQL Server 2005 on windows 2003.
• Installed and configured and maintained failover clustering for SQL SERVER 2005
• Perform SQL Server service pack and Windows Service pack upgrades.
• Designed and Implemented SQL Server 2005 Integration Services (SSIS) Packages to load data from heterogeneous data sources.
• Migration of databases from SQL Server 2000 to SQL Server 2005.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Evaluated reporting products and recommended Microstrategy (MSTR) Reporting Services
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• As part of a team, established security policy using windows domain accounts and implemented a security strategy to protect against threats and attacks following the PCI standards of information security.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Worked on SQL Server 2005 Reporting Services (SSRS)
• Involved in implementation of replication like Snapshot, Transactional.
• Performed data partitioning for efficient management of database tables and indexes.
• Implemented new T-SQL features added in SQL Server 2005 that is Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Managed Disk space, memory and User connections.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Experience in using VERITAS for database backups
• Export or Import data from other data sources like flat files using Import/Export through MSTR, DTS, SSIS.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Data migration using bulk copy program (BCP) and DTS from Oracle Databases to Flat files.
• Performed low-level scripting, fixing of codes and software enhancement process.
• Working on different environments and a key resource for deployment of modified objects to production environments.
• Worked on multiple instances of SQL server using VM Ware
• Having experience onSANandRAIDlevels and building SQL Cluster servers on SAN Environments.
• Manage day to day operations and maintenance of all RDBMS throughout the Enterprise
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Environment: Windows 2000, MS SQL Server 2000/2005, MSTR, Microsoft.NET, SSIS, Crystal Reports, Oracle 8i/9i, MS Office Access 2003, MS Visio Pro 2002.

Confidential, Seattle, WA

SQL Server DBA

Responsibilities:

• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning, and optimizing SQL Server 2000.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Performed high-speed bulk data loads using DB2 load utility.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Designed and analyzed databases.
• Performed DML operations through PERL/ CGI
• Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Respond to trouble tickets assigned to me and fix any database issues promptly. Update and work on projects that I have been assigned to as a resource from the Database Management team.
• Primary on call support duties for a week every month, which include monitoring servers hosting SQL Server and customer’s SQL Server databases and work with network operations resolving any production problems
• Proactive and Reactive tuning of databases in every stage of the project.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: Windows NT, Microsoft SQL Server 2000, UNIX, PERL/CGI, Microsoft Excel, SQL Query Analyzer, SSRS, DB2, Crystal Reports.

Confidential, Raleigh, NC

SQL Server DBA

Responsibilities:

• Installed SQL Server 2000 on windows NT/2000.
• Involved in migrating data from DB2 environment to SQL sever
• Worked on mainframes Z o/s using JCL/COBOL in DB2 and monitored the databases
• Developed stored procedures and triggers in SQL server 2000
• Optimized SQL queries for efficiency and the front end developer with their queries and procedures.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Logical and Physical design of database for projects on basis of user requirements using ERWIN
• Reporting on a weekly basis to the project manager.
• Determine the SQL Server Installation options. Install SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and Restored the Database.
• Fine tuning of database objects and server.
• Job Monitoring and making sure all jobs ran successfully every night
• Configured Server for sending automatic mails to the respective people when a job is failed or succeed.
• Moved the entire phase from the Staging to the Production.

Environment: Windows NT, Microsoft SQL Server 2000, Crystal Reports, Mainframes Z o/s

Confidential

MS SQL SERVER developer/DBA

Responsibilities:

• Logical and Physical design of database for projects on basis of user requirements using Erwin.
• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Coded Stored Procedures, functions and triggers at High level.
• Executed SQL server stored procedures from PERL/CGI.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Participated in User Acceptance Testing (UAT) for different modules.
• Implementing user Training and providing technical support.
• Prepared proper backup and recovery plans.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• DBA activities like creating users, roles and granting and revoking privileges.
• Merging data into a single server for achieving better control, consistency & security of data

Environment: Windows 2000, MS SQL Server 2000, SQL, PERL/CGI, UNIX, T-SQL, SQL Query Analyzer, Profiler.