SUMMARY

• Over 10 years of SQL Server Database Administrator Experience in IT, Pharmaceuticals, Insurance, Commercial, Banking and Finance environments.
• Over 3 years of Oracle Database Administrator experience on Oracle 10g /11g.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/ 2005/2008/2008 R2/2012.
• Solid experience and outstanding knowledge of high availability SQL Server solutions including Always on, Log shipping, Replication, server mirroring and SQL Server clustering
• Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments.
• Proficient with SQL Server Management Studio / Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential and log backups.
• Experience with establishing and maintaining security integrity controls in conjunction with the applications and security groups and assist in the design and implementation of development, testing, QA, production and Disaster Recovery (DR) environments.
• Experience with Create and Maintain enterprise databases, Backup & Recovery, Security, Performance monitoring and tuning.
• Experience with analyze, upgrade and support SQL Server 2000/ 2005/2008/2012 databases and database engine.
• Solid experience with creating alerts, schema management, database reorganization, data loading, database maintenance, and optimization.
• Hands on experience using SSIS for data Extracting, Transforming, and Loading (ETL) from various sources to SQL Server such as raw file, XML file, Oracle, DB2, Excel sheets and Access database.
• Hands on experience with SQL Server and T - SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Extensive experience with SQL scripts, stored procedures, triggers, functions, SQL Performance tuning and transactions analysis, thorough understanding of indices and statistics.
• Excellent report creation skills using Microsoft Reporting Services, SSRS 2005/2008/2012
• Hands on experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Full working experience on Production Environment and On-call support (24x7).
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill.

TECHNICAL SKILLS

Operating Systems: MS-DOS 6.22, Win 2008/2003/2000/ XP/9x/NT

Programming Language: T-SQL, C, C++ and DOS Programming, Unix, Linux

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Profiler, Query Analyzer, SSIS, SSRS and Export & Import

RDBMS Package: MS SQL server 2012/2008 R 2/2008/2005/2000 , ORACLE 10g/11g, Microsoft Access

Reporting Tools: SSRS, Crystal Report, VB Data Report

Other Tools: SQL Safe, Lite Speed, SQL Admin toolset, RedgateData Compare & SQL Compare, Guardium, Delphix and Idera SQL virtual databaseMSOffice 95-2007and Adobe Photoshop

Awareness: VBScript, VB.Net Programming

PROFESSIONAL EXPERIENCE

Confidential, Lebanon, NJ

SQL DBA/Oracle DBA

Responsibilities:

• Offering production support for 250+ SQL Server Database servers using server tools such as Management studio, Profiler, Query Analyzer, Business Intelligence tools including Integration and Reporting services according to Industry Compliance standards; Code, test and execute programs using T-SQL
• Worked as Oracle DBA to install oracle software and created oracle databases as per New York Life standards in Solaris and Linux environments. Created / cloned the users and grant access, created directory objects, add / expanded the data files in response to the requests and alerts
• Installed and configured SQL Server 2005/2008/2008 R2/2012 on stand alone and cluster Servers in Production, Test and Model environments.
• Supporting Blackberry, Agent messaging, Pedestal, Client Management, Ares, team foundation and SharePoint application databases.
• Designed, implemented and configured SQL Server high available technologies such as Always On, Database mirroring, replication and Log shipping.
• Developed and implemented on demand dash board reports on multi servers using SQL Server Reporting services along with SQL Server Integration Services.
• Created and Installed Tempdb monitoring script which collects the session information proactively on predefined frequency and send email alert to DBA Team when disk space reaches the threshold value. Implemented optimization techniques for Tempdb database.
• Hands on experience on Disaster Recovery of SQL Servers between datacenters.
• Check OS event logs and SQL Server logs for unusual events. Periodically monitor performance using PerfMon, Profiler and third party tools. Used Management Studio, batch scripts and Power shell for monitoring SQL Servers and create alerts to notify potential problems.
• Resolve incident tickets and respond to new requests as per SLA. Work with application teams to tune SQL queries and stored procedures, implement code release using change management system. Apply service packs and security patches.
• Involved in upgrading / Migrating the SQL server 2000/ 2005/2008/2008 R2 to SQL 2005/2008/2008 R2/2012
• Hands on experience with third party software such as Guardium, Delphix, Idera SQL virtual database, Spotlight and Foglight

Environment: Windows 2000/20 R2/2012, SQL Server / R2/2012, ORACLE 10g/11g, Visual Studio 2005/2008, VB, C#, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, Upgrade Advisor, Delphix, Guardium, Idera SQL virtual database

Confidential, Bridgewater, NJ

SQL DBA+ Oracle DBA

Responsibilities:

• Design and implement process and scripts for automation of tasks to confirm backups, monitor disk spaces, verify successful running of jobs and collect performance statistics, Max concurrent users on all SQL Servers on multi-server environment over 100+ servers and generate reports and email notifications for DBAs. Scheduled and monitored all maintenance activities of SQL Server 2008/2005 including database consistency check, and index defragmentation.
• Implement X-Factor, BI application developed by Parallax Life Sciences Consulting and Everest Field Technologies for Sanofi-Aventis.
• Build and deploy Ad-hoc reports on business activities for ‘MEET’ (Meeting Enhancement Efficiency Tool) Project.
• Track and document any changes made to servers including validated and SOX-compliant servers using change management System.
• Installed and configured SQL Server 2008 R2 /2005/2000 stand by and active-active/passive node cluster. Applying patches on SQL Servers when needed.
• Implemented policy based management by creating different facets to enforce security and standards of the company. Implemented database mirroring and replication technologies according to business requirements.
• Installed and configured SQL server and it’s components in Development, QA, Production and Disaster Recovery environment.
• Performed migration of databases from MS SQL server, MS Access and to MS SQL server 2008.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications
• Designed, implemented, maintained, and managed complex databases with all database aspects including access methods, validation checks, access time, protection and security, device allocation, database organization, documentation, and statistical methods.
• Designed and developed DTS packages in SQL 2000 and SSIS packages, SSRS and SSAS in SQL .
• Perform update statistics, integrity checks, index tuning and rebuild indexes periodically on SQL Servers by creating maintenance plans.
• Designed and Created table structure with normalized and de-normalized forms with the help of database diagrams a component of SQL Server. Created Entity Relationship Diagrams (ERD) to successfully design a flexible database.

Environment: Windows 2000/2003/2008 , SQL Server / R2, Visual Studio 2005/2008, VB, C#, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, Upgrade Advisor, DTS Designer Tools.

Confidential, Charlotte, NC

SQL DBA

Responsibilities:

• Involved as an MS SQL Server 2005/2000 Administrator/Developer and responsible for requirement analysis, design, document, development, enhancement and support of MS SQL Server databases.
• Involved in Architectural design for the databases and database tables and capacity planning.
• Installed and configured SQL server 2005 in Development, QA, Production and Disaster Recovery environment.
• Hands on experience on Migration of databases from MS SQL server 2000, Oracle, MS Access to MS SQL server 2005.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications
• Designed, implemented, maintained, and managed complex databases with all database aspects including access methods, validation checks, access time, protection and security, device allocation, database organization, documentation, and statistical methods
• Maintained database dictionaries, monitored overall standards and procedures, and integrated enterprise systems through database design
• Automated and enhanced daily administrative tasks including space management, object alteration, database backup and recovery
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency check, and index defragmentation.
• Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach
• Configured securities and access to product databases in SQL Server 2005, Windows 2003 Server
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Competent to work at the highest level of all phases of database management
• Worked with Application development team and other vendors to maintain maximum availability.
• Support a 7 x 24 SQL environment for SQL 2000, SQL Server 2005.
• Developed T-SQL stored procedures as a part of database maintenance plan for new SQL Server 2005. Used system stored procedures and DBCC commands.
• Designed and developed DTS packages in SQL 2000 and SSIS packages, SSRS and SSAS in SQL 2005.
• Worked in Clustered environment.
• Implemented log shipping for high availability. Set up snapshot and transactional replication.
• Extensively involved in Developing and Enhancing of Custom Queries extracting data from Source System and wrote required enhancements on Existing DTS Packages.
• Involved in database and log backups & restoration, backup strategies, scheduling.
• Backing up master & system databases and restoring them when necessary.
• 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.

Environment: MS SQL Server 2005/2000, T-SQL, Win 2003, IIS, FTP, DTS, SSIS, VB, ASP, XSL, XML Web Services, VBScript, JavaScript, CSS, IIS 6.0 and MS SQL Reporting Services.

Confidential, Carlstadt, NJ

SQL DBA

Responsibilities:

• Experience in migration and support of databases for Production, Integration and Development environments ( Dedicated & Shared Databases)
• Migration of databases from MS SQL server 2000, Oracle, MS Access to MS SQL server 2005.
• Experience in Implementation of Production, Integration and Development environment, Hardware requirements and support
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005 and MS SQL Server 2000 databases/ servers.
• In migration process involved into PAR Review, Migration Review, preparing documentation for reviewing process and migration, request for backup, migration, providing active support after migrations.
• Implementation of Point in time Backup and recovery plans of all databases and maintain documentation. Schedule the Administrative Tasks (like database integrity checks and maintenance plans).
• Working with MS DTC for the windows server 2003 and in cluster environment.
• Migrating DTS Packages into SSIS using Upgrade Advisor and DTS Designer.
• Creation and maintenance of Users security permissions and Migrating the entire database objects from one server to another server.
• Extensive exposure to creation of databases, objects, stored procedures, triggers, security, DTS (i.e. Import and Export), BCP, Transact-SQL, and SQL Server Agent and SQL Server profiler.
• Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers. Used Log Shipping Technique for warm backup solution for MS SQL Server databases.
• Very good experience in the maintaining production servers, monitoring performance issues, trouble shooting and solving production issues.
• Monitor database status on CPU, memory, I/O, space, paging and dead-locks using performance monitor and SQL Server Profiler.
• Created logical and physical database model, table definition, table constraints, stored procedure and function definition for new businesses logic with Erwin.
• Transform tables, views, constrains and triggers to handle business rules from the existing server
• Wrote Stored Procedures and user-defined functions (UDF) to support web application request
• Designed new report layout with SSRS and Crystal reports. Created dropdown, depending dropdown, drill through and search enabled reports.
• Performed tuning query performance on Cluster index and non-Cluster index
• Performed tuning query performance and scalability on full-text search applications and catalog capabilities
• Created, deployed, and scheduled SSIS packages to run SQL tasks and make data transfer
• Created master pages, Win forms and created new custom controls in visual studio 2005.
• Implemented lite speed to save disk space.

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server, Visual Studio 2005, VB, C#, ASP, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, Upgrade Advisor, DTS Designer Tools.

Confidential, Richmond, VA

SQL DBA / Developer

Responsibilities:

• Successfully Designed, Implemented, and Administered Microsoft Windows Server 2003 Cluster.
• Creating and Maintaining Databases, Adding Users, Roles, and Groups and assigning privileges according to the project needs.
• Created Database Maintenance plans, Managed Database Structures, Disk Spaces, DTS packages, scheduling Database Backups, Restoring Databases and Maintained data accuracy and consistency.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Setup transactional and snapshot replication, Implemented log shipping technology. Worked on Data partitioning and performance tuning.
• Analyzed, fine-tuned and optimized MS SQL Server Applications by using Performance Monitor, setting up traces using SQL Profiler.
• Created Reports using Reporting services and Crystal Reports.
• Provided support to the Data Center team in their development and truncated the transaction logs to check the space of the exponentially expanding databases.
• Performed upgrade of OS, Applications & file system expansions as and when required.
• Managed the production database servers Taking daily backups by using VERITAS Net backup.
• Daily basis reviewed performance monitoring and Windows and SQL Event Logs and System Logs.
• Worked on Network connectivity issue and troubleshooting between systems.
• Performed troubleshooting and maintained H/W and networking problems

Environment: MS SQL Server 2000, Windows 2003/2000 Servers, IIS, FTP, SQL Profiler, VERITAS, MS MOM 2005 Server, ASP.Net, C#.Net, ADO.Net, XML, XSL, XML Web services and Network Support.

Confidential, Stamford, CT

SQL DBA

Responsibilities:

• Created and maintained databases tables, Indexes, Views and used Stored Procedures, DTS packages, BCP for updating Servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Involved in trouble shooting and fine-tuning of databases for its performance and high availability.
• Maintained Reporting services on MS SQL 2000 platform and created reports according to documents prepared by BA.
• Set up disk storage layout, implemented data partitioning, moved temp db and transaction logs for performance. Set up email send/receive with SQL Server. Set up replication and automate statistics.
• Maintained Ms Access databases and migrated to SQL Server 2000.
• Performed performance monitoring, reviewing Windows and SQL event logs and system logs.
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Implemented and Scheduled Replication process for updating our parallel servers
• Automated Backup and Recovery processes throughout the environment.
• Setup transactional and snapshot replication. Performed daily database backup and restored on disaster recovery.
• Day to Day basis reviewing Performance monitor and Event logs on all SQL Servers.

Environment: MS SQL Server 2000, MS Access 2000, Windows 2000/2003, IIS, FTP, Siebel, ASP.Net, C#.Net, ADO.Net, XML, XSL, XML Web services, JavaScript, CSS, IIS 6.0 and Crystal Reports.