SUMMARY:

• Sr. SQL Server DBA Over Nine years' of experience in SQL Database Administration, System Analysis and Design, Development & Support of MS SQL Server2000, 2005, 2008 and 7.0 in Production, Development & VMware Environments.
• Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, backup/recovery, running DBCC Commands.
• Experience in SQL Server performance monitoring, through FOG light/SQL DTA, Profiler, Spot light and performance monitor - Analyzing the performance of queries
• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC Utilities, Database Tuning Advisor, Hardware I/O Operations, Recompiling Stored Procedures and Index Maintenance.
• Design, Maintain and Administration SQL server Integration Service (SSIS) packages including Data Migration and Redesigning SQL Server 2000 DTS Package into SQL Server 2005 SSIS (ETL).
• Proficient with SQL Server Reporting Services, Analysis Services.
• Experienced in developing Drill down reports, Drill through reports using SQL Server Reporting Services, Crystal Reports, and Excel spreadsheet.
• Knowledge of SQL Server Clustering, Log Shipping and Setting up Migration to SQL Server 2005
• Devised data models with ER/Studio, and tuned queries and designs and implements backups and restore database policies.
• Experience in implementing many types of High availability and Disaster Recovery solutions like Clustering, Database Mirroring, Cold Standby, Warm Standby, Log Shipping, and Replication.
• Good SQL Server Administration skills including user authorizations, Database creation, Creating Roles, Tables, indexes and Clusters creation.
• Setup, Reconfigured, and Monitored log shipping of production databases and also carried out role changes, role reversals, and positioning the monitor server
• Performed physical database analysis and feasibility requirements. This involves performance, security, archival, maintenance and recovery requirements.
• Experience working with Production (24 x 7) and Development environments
• Created Database users, controlling access to SQL Server and making sure right people get access to right data and looking after security issues.
• Experience in Dimensional Modeling, ER Modeling with hands on ERWIN tool.
• Good Knowledge and Administration skills of Databases like Sybase, Oracle, and DB2.
• Excellent interpersonal, analytical and communication skills.
• Authorized to work in the US for any employer

TECHNICAL SKILLS:

Platforms: Windows 95/98/Me/XP/NT/ server/Vista, Linux, UNIX

Languages: C, C++, T-SQL, PL/SQL, HTML, ASP, PERL, VB Script.

RDBMS: Microsoft SQL Server MS Access, Analysis Server My SQL, Oracle

IDE: Microsoft Visual Studio

SQL Server Tools: Enterprise Manager, Management Studio, SQL Profiler, DTS (ETL), Database Tuning Advisor (DTA), SQL* Plus

Backup Tools: Litespeed, VERITAS, TOAD, SQL Loader, IDERA

Case Tools: MS Office MS Excel MS Outlook MS Visio, MS Project

WORK EXPERIENCE:

Sr. SQL Server DBA

Confidential - Charlotte,NC

RESPONSIBILITIES:

• Managing SQL Server 2012\2008\2005\2000 in cluster and non - cluster environment.
• Providing 24/7 on-call support for SQL Server.
• Performing Database tuning with application teams to isolate and resolve performance issues.
• Working with change control systems to coordinate changes across teams
• Handling of Severity 1 tickets and performed root cause analysis for the High critical tickets.
• Supporting database structure changes and data changes for Application development/testing/deployment
• Designing and taking part of DR drill.
• Implemented and troubleshooting clustering and Log Shipping as high availability solutions in 2008, 2008R2 & 2012 servers.
• Performing day-to-day operation based on ITIL process: Configuration Management, Incident Management, Problem Management, and Change Management.
• Configuring, maintaining and troubleshooting Native SQL Transactional Replication along with external replication tools like Oracle Goldengate & Attunity.
• Automating Cluster Node availability, error log, blocking, backup Verification\Validation and Connectivity check monitoring for all servers.
• Installing and configuring SQL Sentry.
• File and filegroup alignment and partitioning the tables.
• Prepared database growth, used for capacity planning.
• Thorough code review before applying any changes in PRD environment.
• Assessing of database security, and perform necessary action to protect database such as Security patching, Remove unnecessary privilege, and get the customer to sign Risk Acceptance Form.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from other sources to SQL databases.

ENVIRONMENT: MS SQL Server 2014/2012/2008 R2/2008/2005, T-SQL, MS SQL Server Services, (SSIS) SQL Agent, SSRS, SQL Profiler, Windows 2012/2008/2003 server, Visual Studio, .Net Framework, & Quest Lite Speed backup tool and Oracle Golden Gate & Attunity Replication.

Sr. SQL SERVER DBA/Architect

Confidential, Charlotte,NC

RESPONSIBILITIES:

• Responsible for Installation, Configuration and Administration of MSSQL Server 2008/2008 R2/2012 on windows 2003/2008 Servers.
• Monitoring and Troubleshooting jobs in Production, QA and Development environment.
• Responsible for upgrades, patches and fixes.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Assisted in the design and development of the data warehouse
• Design and implement Backups and Restore database policies.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper - based and interactive Web-based reports.
• Responsible to implement and monitor security for the SQL Server Environment.
• Monitoring and Troubleshooting jobs in Production, QA and Development environment.
• Setup Deadlock and Blocking chain monitoring alerts for critical OLTP systems.
• Provided on call 24/7 Support on weekly basis.

ENVIRONMENT: MS SQL SERVER 2005/2008 R2, SharePoint, Red Gate, Windows 2000/2003/2008, SAP EnvironmentSr. SQL Server DBA

Confidential -Atlanta, GA

RESPONSIBILITIES:

• Involved in performance testing and optimization of a 4TB OLTP Database
• Helped in Query optimization and improving the overall performance.
• Monitored and troubleshooting of Database Buffer Latch contention.
• Worked with tools like Lite speed for Backups and SQL Sentry Tool for monitoring the servers.
• Helped in improving the number of Transaction per second (TPS) writing to a database without any high impact of latches or CPU usage.
• Migrated SQL Server Production Databases using Log Shipping with minimal downtime
• Installed on configured Attunity Replication Tool for replicating data from one server to other using CDC change data capture
• Used and Maintained Golden Gate Replication for SQL Server and resolved the replication issues raised.
• Helped in setting up Archival process for Production DB tables which has more than 200 Million records of data

ENVIRONMENT: MS SQL SERVER 2005/2008 R2/2012, SharePoint, Attunity, Golden Gate, Litespeed, SQL Sentry, Red Gate, Lisa Simulation Tool, Windows 2000/2003/2008 .

Sr. SQL Server DBA/Architect

Confidential -Wayne, PA

RESPONSIBILITIES:

• Plan, Design and Developing the Implementation of Databases Re - Architecture.
• Provide 24/7 support in Monitoring, Maintenance and Planning of the database servers and their availability.
• Helping out with creating, recommending and defining tools, standards and best practices all over the enterprise.
• Planning and Implementing High Availability and Disaster Recovery solution without interruption.
• Designing and planning on Implementing Virtualization (V-Block) to reduce IT cost and improve productivity.
• Designing process flow and creating templates for each and every service used and provided.
• Helping the client in creating and deploying a stable database domain.
• Installed and Configured SQL Server 2008 R2 on Windows server 2008.
• Installed and Configured OEM 12C for monitoring Oracle and SQL Server Databases from one centralized location.
• Installed and configured Net backup Tool to perform backups for SQL Server Databases.
• Worked with Microsoft Team to run RAAS assessment tool and make sure all configuration policies and standards are followed.
• Developed Standard Operation Protocols (SOP) to be followed by Operational DBA's of SHIRE.

ENVIRONMENT: MS SQL SERVER 2005/2008, ORACLE 11G, Oracle Enterprise Manager OEM12C, SharePoint, RMAN, NET BACK-UP, Windows 2000/2003, Mantis, V-block.

SQL Server DBA / Designer

Confidential -Chicago, IL

RESPONSIBILITIES:

• Installed and configured MS SQL Server 2005. Edited the server registration properties, Created Logins, Managed the object level permissions and security issues of the server.
• Involved in Design and development of the Application database which help to calculate Rebate Payment to clients.
• Supported Engineering on approach of various solutions on implementing Quarterly and Annual based Rebate calculations.
• Responsible for Performance Tuning to analyze and optimize costly queries to reduce logical disk I/O for effective performance using SQL server native tools.
• Documented several standards and calculations existed in the database and saved them to SharePoint.
• Involved in setting up the Backup and Restore strategy for production and other development environments.
• Worked on Database schema, table creation, Index creation. Written Stored Procedures, Triggers and functions for effective data integration for business log.
• Involved in designing and developing of several internal reports using SSRS.
• Built and modified several SSIS packages using BIDS tool.
• Involved in Managing and scheduling daily maintenance jobs related to data transfers, Index update, backup and Recovery.
• Developed, Produced, Maintained structural design of various systems, applications, and databases for database - driven websites based on business requirements.
• Worked closely with Business Analyst (BA) and Business teams in analyzing and approving various changes and updates to database.
• Involved in SQL Server 2000 and 2005 service pack and hot fix installations.
• Supported to develop, maintain and administer standards for Data, Data bases and Data models.
• Involved in Data Modeling for the application and created ER diagram using ERWIN.
• Experienced configuring and working Microsoft SQL server 2005, Microsoft SQL Server 2008 on VMware Environment.
• Worked Closely with Application developer and engineers to ensure Integrity and performance analysis of DBMS.
• Created different user level groups and assigned appropriate permission level to the database users and maintained Security.
• Developed high level design documents DLD's working closely with BSA to help engineering to understand and implement the code with out any discrepancies followed.

ENVIRONMENT: MS SQL SERVER 2000/2005/2008, MS Visual Studio TFS, SharePoint 2010, SQLServer 2008 BIDS, ERWIN, SSAS, MS WORD 2007, EXCEL, DTS.

SQL Server Production DBA

Confidential -South Bend, IN

RESPONSIBILITIES:

• Involved in planning and documenting the migration of the Data center.
• Responsible for Migrating SQL Server Databases from version 2005 to 2008 using side by side migration.
• Experienced in maintaining Spotlight tool for monitoring and troubleshooting issues and alarms raised.
• Experienced in setting up Failover Clustering and helped in maintaining and troubleshooting the cluster environment.
• Involved in configuring and monitoring Transactional Replication for reporting purpose.
• Experienced on working and answering Incident management and Change management tickets On BMC Remedy and IT Service Management ITSM.
• Experience working with TSM Tivoli Storage Manager and UC4 scheduler for backups.
• Experience working on DMZ servers.
• Involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re - index and update statistics in databases.
• Experience in improving SQL Server performance by using Index tuning wizards, performance tuning methods, execution plans and SQL Profiler.
• Responsible for SSRS Installation and configuration.
• Involved in Performance tuning of slow running SQL queries and stored procedures and helped in redesigning them.
• Individually responsible for monitoring and maintaining the Clustered servers.
• Provided 24/7 dedicated support for deployment in Development and Production environment.
• Worked with several users and vendors from Mexico/Germany/Brazil and India supporting their Application Database issues 24/7.

ENVIRONMENT: MS SQL SERVER 7.0/ 2000/2005/2008, MS VISUAL STUDIO TFS, SHARE POINT, VSS, Remedy Tool, UC4 Scheduler, Tivoli Storage Manager (TSM), PowerShell.

SQL Server DBA

Confidential - Elizabethtown, KY

RESPOSIBILITIES

• Installed configured and maintained SQL Server 2008 on windows server 2008.
• Involved in developing Logical and physical design, and Architecture of a financial database for PAYROLL BILL PAY system.
• Installed configured and developed Internal Reports using 2008 SQL Server Reporting Services in a Data warehouse environment.
• Implemented configured and maintained Transactional replication successfully in SQL Server 2008 environment.
• Implemented purge process for the data on transactional servers.
• Involved from scratch in Designing, Developing and Change Management of the financial website Application.
• Individually Responsible to verify and analyze all the SQL scripts and to store them in VSS.
• Created DB objects like Tables, Views, Indexes, Complex Stored procedures & triggers using T - SQL.
• Implemented a DBA maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space).
• Provided 24/7 dedicated support for deployment in Development and Production environment.
• Migrated databases to other servers, created logins, set up database mail, alerts and maintained overall security.
• Perform day to day Database Maintenance tasks Database Monitoring, Backups, Space Management, Resource Utilization for performing object migration between all production database Servers.
• Responsible for installation of patches and hot fixes for SQL Server 2008.

ENVIRONMENT: MS SQL SERVER 7.0/ 2000/2005/2008, VISUAL STUDIO, SHARE POINT, Red Gate, Lite Speed, Windows 2000/2003.

SQL Server Production DBA

Confidential

RESPONSIBILITIES:

• Working on BSC Remediation project to maintain security all over SQL Server platform for Implementation data. BSC (Baseline Security Configurations).
• Installed configured and maintained SQL SERVER 2005 on windows server 2003.
• Involved in writing several Batch Files and C++, shell scripts which helps in maintaining Securities, Standards and restricting invalid access to SQL Server by sending an e - mail to DMSS Audit on multiple servers.
• Experienced in monitoring servers using System Centre Configuration Operation Manager (SCOM) 2007.
• Expertise in using Windows Script Host and converting VB script to Batch Files.
• Experienced working on Remedy Ticket system for solving issues and concerns of ETL and development Teams.
• Working on creating and Implementing Standard Operation Protocols (SOP's) for SQL Server and documented them in clear case.
• Experienced with working and using Clear Case and Clear Quest tools.
• Involved in upgrading SQL Server 2000 to SQL Server 2005 and converted all remote servers to Linked servers except those involved in Replication.
• Involved in Performing Backups for development and production databases and automated the process using AUTOSYS.
• Experienced in setting up SQL Jobs, Operators, Alerts, Notifications, Database and SQL Mail Profile. Used Autosys for scheduling the jobs.

ENVIRONMENT: MS SQL Server 2000/2005, ORACLE 11g, Clear Case, Clear Quest, Remedy, DTS, SSIS, .NET Framework, C#, Windows 2000/2003, SharePoint.

SQL Server Production DBA

Confidential -Alexandria, VA

RESPONSIBILITIES:

• Installed and configured SQL Server 2008 on windows server 2008.
• Migrated SQL Server 2005 databases to MS SQL SERVER 2008.
• Worked on a large database which is of 4TB in size.
• Worked on moving schema and data between remote servers which are not in a network using VISUAL STUDIO 2008.
• Experienced working on Microsoft Visual Studio Team System 2008 (Data Dude).
• Implemented stored procedures for fielded search lookups.
• Created Logins. Managed the object level permissions and security issues of the server.
• Worked on synchronization of schema in QA and DEV databases those are not in a network.
• Created complex DTS and SSIS Packages for Data Migration and Transformation from one server to another server.
• Created different user level groups and assigned appropriate permission level to the database.
• Provided 24/7 dedicated support for deployment in Development and Production environment.
• Helped and assisted the development team in Puerto rico providing 24/7 support.
• Implemented and Maintained security all over the organization.
• Worked on improving the performance of stored procedures by creating indexes and updating statistics.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005/2008.

ENVIRONMENT: MS SQL Server 2008/2005, Data Dude, .NET Framework, DTS, SSIS, ASP .NET, SharePoint Server, SSRS, SVN, C# .NET, SSL, IIS 6.0/7.0, Windows 2008/2003, Erwin, Excel, SQLPrompt.

SQL Server Production DBA

Confidential -New York, NY

RESPONSIBILITIES:

• Installed and configured SQL Server 2005 on windows 2003, and applied service packs.
• Involved in migrating SQL server 2000 databases to SQL Server 2005.
• Created groups, roles, users and assigning access privileges to users.
• Created User defined data types and added them to model database for future purpose.
• Setting up database backup and recovery procedures for Production, QA and Development servers.
• Involved in Data Migration from legacy to master tables using DTS - Import and Export wizard.
• Implemented the required optimization and fine-tuning of databases. Utilized SQL Profiler to monitor database activity
• Installed, configured and maintained SQL Server Clustering on two nodes and multiple nodes and performed the failover process from active to passive nodes.
• Production experience in Microsoft Cluster Services (MSCS), including Active/Passive, Active/Active, and Network Load Balancing clusters.
• Responsible for Query optimization and Performance tuning, SQL queries using Show Execution Plans.
• Generated Transactional replication, pulled subscription and defined edition to transfer data from branch to head office and vice versa.
• Acted as an Independent lead database architect for the ETL process design

ENVIRONMENT: MS SQL Server 2000/2005, Linux, ORACLE 10g, .NET Framework, VSS (Visual Source Safe), DTS & SSIS, Windows 2000/2003, Erwin, VB Script, SQL Prompt.

SQL Server DBA/Developer

Confidential, PARSIPANNY/NJ

RESPONSIBILITIES:

• Migrated SQL Server 2000 to SQL Server 2005.
• Actively involved in creation of database, modified tables, DDL triggers, and store procedures to clean and validate the data to meet the company specifications.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Designed new SSIS packages as per needs, Resolve the problems.
• Created Backups Strategies for databases and automated the process.
• Experienced with vertical partitions, horizontal partitioning, subscriber options, and types of replication scenarios, Central Publisher, Central Publisher using remote distributor, Central Subscriber and replication topology.
• Incorporating business logic in SSIS packages while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the relationship.
• Data migration between different environments and Third Party Databases.
• Written stored procedures for automatic scripting to backup transaction logs, log file, maintain archive of objects and so on.
• Experienced in writing C++ scripts for performing backups and to maintain the automation of jobs on multiple servers.

ENVIRONMENT: SQL Server 2005/2000, .NET Framework, ADO.NET, ORACLE 10g, Visual Studio, Windows (2003, 2000/4.0), SSL, IIS 5.0, SQL Server 2000/7.0, UNIX.