SUMMARY

• Over twelve years of Professional IT experience, which includes MSSQL database administration, successful strategies, designs and implementations of various Database solutions.
• Experience in SQL Server versions MSSQL Server 2005, 2008,2008 R2, 2012.
• Experience in migration server to AWS cloud based environnement
• Experience in Configuring & administering the standby servers through log shipping and Mirroring.
• Responsible for multiple migrations from SQL server 2000 to SQL server 2005,2008, 2008 r2, 2012.
• Installing, configuring, administering of MS Sql Server and securing Production servers.
• Responsible for installing Configuring sql server cluster and troubleshoting issues with sql cluster.
• Responsible for migrating PostgreSQL database to SQL server for using WS FTP Tools.
• Basic administration experience on postgre database.
• Perform and oversee day - to-day database activities related to backups, restores, integrity checks, optimizations, refreshing reindexing, performance Tuning and troubleshooting.
• Develop, establish, and maintain overall database standards, processes related documentation and workflows necessary for production using DTS packages, stored procedures, batch jobs, and system reports.
• Using T-SQL for Creating databases, tables, stored procedures, triggers, indices, and other objects within the databases based on requirements from developers.
• Used T-SQL for Troubleshoot and resolve issues relating to database integrity, database performance (deadlock, locking, blocking, etc.),serverperformance (CPU, memory, I/O, network).
• Experience in using SQLServerIntegration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Provided technical support toSQLServer/PDW (Parallel Data Warehouse).
• Configured Always On for providing HADC in both Synchronous and Asynchronous modes as per Application requirements
• Extensively worked on Dynamic Management Views (DMV's) and Dynamic Management Functions (DMF's).
• Working with Application teams to troubleshoot, manage and resolve issues SharePoint, SCOM, SAP and other application and their related databases.
• Upgrading and upsizing databases from earlier versions to the latest versions.
• Proficient in system Migrations and guiding client through effective and facilitating decisions on best practice procedures.
• Performing basic audits as per application team requests.
• Experienced in handling DR servers and in stimulation the DR servers from production.
• Participation in escalation and support activities (being on-call).
• Diagnose low-level SQL Server bottlenecks by using SQL Profiler, interrogating internal system tables and using various other utilities
• Expérience working with Tools like Control M Scheduler for scheduling the database maintenance jobs
• Worked with backup team to configure backups and restore with Symantec net backup Tools.

TECHNICAL SKILLS

SQL Server Tools: - Enterprise Manager, Query Analyzer, Export & Import (DTS & SSIS), SQL Server Profiler, Management Studio, Toad for SQL Server, Tuning Advisor.

Databases: - MS SQL Server 2000,2005,2008,2008 R2, 2012, PostgreSQL, Oracle

Languages: - T-SQL, C++,Core Java

Operating Systems: -Windows 2003, Windows 2000, NT 3.5X & 4.0, Windows 95/98, Windows Workgroups 3.11Windows XP, 7, 8.1 Windows 2000/2003/2008 R2, 2012 Server

Tools: - Remedy/Smart, Maximo, Managenow, Control M, Citrix, SCOM, Tivoli Data base Monitoring, and WS FTP.

PROFESSIONAL EXPERIENCE

Sr. MS SQL SERVER DBA/TEAM LEAD

Confidential, CA

Responsibilities:

• We provided infrastructure support for data hosting and database architecture and administration.
• As a member of the team I was tasked with varying and challenging assignments for key clients.
• Supported a 24x7x365 rotation base global support for about 350 SQL servers, and over 2000 SQL databases.
• SQL Database system implementations were from a couple gigabytes to multi-terabytes systems.
• Provided technical support toSQLServer /PDW(Parallel Data Warehouse)
• Work included heavy migrations (Upgrade from lower to higher versions), system architecture planning and implementation of new environments for a diversified outsourcing client databases, ranging from small OLTP applications to farm clusters for multi-purpose operations.
• The completion of projects included the interaction with global customers and management systems for approvals, diverse change management system and ticketing systems like Remedy and Service Manager and client proprietary reporting methodologies
• Migrating server’s amazon web services from standalone servers.
• Worked on configuring mirroring and troubleshooting the mirroring issues.
• Installed multiple sql 2012 cluster setup for active passive cluster and configured SSRS to work even when failover happens.
• Configured Always On with three replicas for providing HADR.
• Configured Always On in both Synchronous and Asynchronous modes as per Application requirements
• Worked on configuring mirroring and troubleshooting issue in mirroring.
• Experienced in handling DR servers and in stimulation the DR servers from production.
• Worked on migrating PostgreSQL databses to SQL server for using WS FTP Tools.
• Responsable to oversee day-to-day database activities related to backups, restores, integrity checks, optimizations, refreshing reindexing, performance Tuning and troubleshooting.
• Responsible for Creation of logins and users and providing required permissions according to the requests.
• Worked on space issues because of Transaction log growth as well as data file growth.
• Worked on Creation and Configuration of New databases and database refreshes

MS SQL SERVER DBA

Confidential, New York

Responsibilities:

• Responsible for MSSQL Server 2012,2008 R2 2005, 2000 and installations, upgrades, configurations, administration, optimization, maintenance of mission critical databases systems.
• Provides leadership on all aspects of enterprise wide database administration and database related projects across all business areas.
• Provides technical guidance and hands-on support for corporate SQL databases environment. Supports internal developers and 3rd party database applications. Support includes help in the creation of new databases, performance tuning, and troubleshooting existing applications.
• Responsible for SQL Server2000 migrations to 2008 R2.
• Responsible to support 24x7 over 120 production SQL Servers, over 600 databases across U.S, Average sizes of the databases are 200GB-1TB. Provide database support and assistance to developers, end-users.
• Configured Always On for providing HADR
• Monitors DB performance and ensure stable, high performing environment. Provides leadership/ownership on business continuity as it relates to database related applications.
• Performed on-going performance tuning, administration, upgrades, service packs, hotfixes, re-creating indexes, backups, dumps, recovery and restores of all mission critical databases.
• Work with IT support staff to ensure all client machines have necessary SQL functionality.
• Responsible for daily backup checks and space issues and Job failure
• Responsible for checking the Alerts coming from Scom and Tivoli Tool
• Responsible for Creation of logins and users and providing required permissions according to the requests.
• Worked on space issues because of Transaction log growth as well as data file growth.
• Worked on Creation and Configuration of New databases and database refreshes worked on multiple Database Migration (Planning and Implementation ) project from SQL SERVER 2000 to SQL SERVER 2005
• Installed SQL SERVER 2005 64 bit on a cluster and migrated databases from standalone to cluster.

Sr. MS SQL SERVER DBA

Confidential, Ohio

Responsibilities:

• Responsible for MSSQL Server 2000 and 2005 standalone/cluster installations, upgrades, configurations, administration, performance monitoring, tuning, optimization, maintenance, upgrade/migrations of mission critical databases systems.
• Provides leadership on all aspects of enterprise wide database administration and database related projects and production support across all business areas.
• Ongoing support and administration of existing production, staging, QA and development database environments.
• Responsible to support 24x7 over 75 production SQL Servers, over 425 databases, Average sizes of the databases are 50GB-1TB
• Achieved close to 100% uptime through good design, thorough monitoring, careful and consistent change management, and immediate response to any problem.
• Assist development in design of database systems and staged implementation of changes.
• Implemented Microsoft Gold Partnership program with JDA.
• Implement effective backup and recovery procedures and solutions.
• Manage projects and deliver on time with periodic status reports to management.
• Provide support off-hours and remotely when needed and on pager rotation basis.

MS SQL SERVER DBA

Confidential, Illinois

Responsibilities:

• Provides leadership on all aspects of enterprise wide database administration and database related projects across all business areas.
• Provides technical guidance and hands-on support for corporate SQL databases environment. Supports internal developers and 3rd party database applications. Support includes help in the creation of new databases, performance tuning, and troubleshooting existing applications.
• Responsible for SQL Server2000 migrations to 2005.
• Responsible to support 24x7 over 120 production SQL Servers, over 600 databases across U.S, Average sizes of the databases are 200GB-1TB. Provide database support and assistance to developers, end-users.
• Monitors DB performance and ensure stable, high performing environment. Provides leadership/ownership on business continuity as it relates to database related applications.
• Performed on-going performance tuning, administration, upgrades, service packs, hotfixes, re-creating indexes, backups, dumps, recovery and restores of all mission critical databases

SQL Server DBA

Confidential

Responsibilities:

• Responsible to support 24x7 over 500 Production Sql Servers, over 2500 databases across Malaysia, Hong Kong, Singapore, Thailand Vietnam, Cambodia, and Argentina. Average sizes of the databases are 350-450 Gigs. Provide database support and assistance to developers, end-users.
• Developed, implemented and maintained client/server database developments, standards and policies.
• Responsible for capacity planning, monitoring, and performance tuning.
• Responsible for all production, test and development servers.
• Responsible for technical support, troubleshooting of all SQL Server databases related issues for 3000 to 6500 users nationwide and abroad.
• Setting up standard database policies and procedures including security and integrity of the databases. Maintaining security of high standards across all database servers.
• Performed on-going performance tuning, administration, upgrades, service packs, re-creating indexes backups, dumps, recovery and restores of all mission critical databases.

SQL Server DBA

Confidential

Responsibilities:

• Performed Database Administration and Management activities in a safe, recoverable Installed SQL Server 2005 on windows 2000 server along with service pack 2
• Database backups and restoration, scheduling backups.
• Created schedules for Backups and Replication
• Performed Database Administration and Management activities in a safe, recoverable
• Worked on migration and maintenance of data using various utilities like DTS, EXPORT & IMPORT and ATTACH & DETTACH Databases.
• Performed Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments
• Performed Data Integrity by using Constraints, Data Types and Triggers
• Export and Import data from text file to SQL Server 2005 using Bulk Copy Insert utility.

SQL Server DBA

Confidential

Responsibilities:

• Installed SQL Server 2005 on windows 2003 advanced server.
• Implementations of SQL logins, roles and authentication modes as part of security policies for various categories of users
• Designed and implemented comprehensive Backup plan and Disaster recovery strategies implemented
• Involved in performance tuning of database
• Designed and created databases, tables, views, stored procedures and triggers
• Exported and Imported data from text files to SQL Server using Bulk Copy Insert utility
• Scheduled Alerts and Jobs Using SQL Server Agent
• Involved in database backups, restore and Scheduling backups
• Maintained high availability of databases using Replication and Mirroring
• Performed regular Backup and Restore