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, 2014, 2016.
• Responsible for multiple migrations from SQL server 2000&2005 to SQL server 2005,2008, 2008 r2, 2012, 2014, 2016.
• Installing, configuring, administering of MS SQL Server and securing Production servers.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability include Always On, Replication (Snapshot, Transactional and merge), Clustering (Active - Active and Active Passive ), Log shipping and Database Mirroring (Sync and Async)
• Expertise in configure, monitor and troubleshoot SQL server Always on High Availability in between the data centres and participated in DR test.
• Perform and oversee day-to-day database activities related to check sql server errorlogs, backups, restores, integrity checks, job failures, 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.
• Experienced in Troubleshoot and resolve issues relating to database integrity, database performance (deadlock, locking, blocking, etc.) server performance (CPU, memory, I/O, network).
• Used Perfmon and DMVs to analyze the performance issues and resolve issues relating to database integrity, database performance.
• Experience in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Extensively worked on DCC commands,Dynamic Management Views (DMV's) and Dynamic Management Functions (DMF's).
• Closely worked with development teams to assist them in various performance issue, problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.
• Experience in Database Security and Management.
• Experience in Service Packs, Security Patches & Hot fixes install and management (schedule-install)
• Created maintenance plans to perform Index De-Fragmentation, Re-Indexing and update the Index Statistics
• Working with Application teams to troubleshoot, manage and resolve issues SharePoint, SCOM, SAP ERP, 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 before pre-build to follow 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. SSRS.

Databases: - MS SQL Server 2000,2005,2008,2008 R2, 2012, 2014, 2016 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, Manage now, Service now, Control M, Citrix, SCOM, Tivoli Data base Monitoring, and WS FTP.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. MSSQL SERVER DBA

Contribution:

• Handling all the infrastructure projects ongoing and new with building new sql servers in private cloud environment, VMware environments and windows clusters.
• Migrating the databases and other database objects from sql 2000, sql 2005 to 2012 and 2014, 2016.
• Supporting the projects during the UAT, SAT and troubleshooting the data issues from database end.
• Database refresh and other database related support during application deployments.
• Configuring and resolved issues related to Always on Availability group (HADR) in both SYNC and ASync modes, mirroring for the newly build servers for high availability.
• Using ticketing tools like remedy and service now to support day to day activities.
• Helped with performing tuning for batch job delays and long running queries during the uat and sat testing. Applied patches and service packs to keep the database at current patch level.
• Responsible for backup, restoration, maintenance plans and databases security.
• Scheduling, managing jobs and engineering the database maintenance activities.
• Developed SSIS package to copy the data from other sources.
• Involved in Datacenter migration and Database migrations from end to end.
• Optimization and tuning by setting up appropriate indexes and regular data maintenance
• Fixed several SQL Query performance issues by examining execution plans, tuning indexes, creating plan guides, adding hint words.
• Monitored SQL Servers to examine top resource consuming queries and tuned them to reduce the server load.
• Created unattended installation packages for SQL Server Service Packs and/or hot fixes.
• Worked extensively on monitoring the databases, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases.
• Experience in T-SQL stored procedures, tables, and triggers.
• Implemented SQL Server hardening on newly builds Servers to comply with Corporate Security Standards.
• Created SQL Server Security Assessment and Remediation document for all the SQL Hardened Servers.
• Implemented table and index partitioning to resolve performance issues for Instant Credit application.

Environment: SQL Server 2016/ 2012/2014/2008 R2/2005, Windows 2K/2003/2008 R2/2012, SQL Profiler, Networker, SSIS 2012/2008R2, SSRS 2012/2008 R2, IIS 6.0,TSQL

Confidential, CA

Sr. MSSQL SERVER DBA/TEAM LEAD

Roles &Responsibilities:

• Provided infrastructure support for data hosting and database architecture and administration.
• As a member of the team and lead, 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.
• Work included heavy migrations, upgradations (Upgrade from lower to higher versions), system architecture planning and implementation of new environments (2012, 2014) for 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
• Worked on configuring mirroring and troubleshooting the mirroring issues.
• Installed multiple SQL 2012,2 014 cluster setup for active-passive cluster and configured SSRS to work even when failover happens.
• Responsible for checking the Alerts coming from Scom and sql errorlogs
• Configured Always On with three replicas for providing HADR(Always on).
• 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 databases to SQL server for using WS FTP Tools.
• Responsible for overseeing 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.

Environment: SQL Server 2012/2014/2008 R2/2005, Windows 2K/2003/2008 R2/2012, SQL Profiler, Query tuning advisor, Symantec, SSIS, SSRS,2012/2008R2, SSRS 2012/2008 R2,SCOM,TSQL.

MSSQL SERVER DBA

Roles & 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 for supporting 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 sql cluster 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 ongoing 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 .

Environment: SQL Server 2012/2008 R2/2005, Windows 2K/2003/2008 R2, SQL Profiler, Query tuning advisor, Symantec, SSIS 2012/2008R2, SSRS 2012/2008 R2,SCOM,TSQL.

Sr. MSSQL SERVER

Roles &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 for supporting 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 SCOM, careful and consistent change management, and immediate response to any problem.
• Assist development in the 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.

Environment: SQL Server 2008 R2/2005, Windows 2K/2003/2008 R2, SQL Profiler, SSIS 2008R2, SSRS 2008 R2, SCOM, T SQL.

MSSQL SERVER DBA

Roles &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 for supporting 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 ongoing performance tuning, administration, upgrades, service packs, hotfixes, re-creating indexes, backups, dumps, recovery, and restores of all mission critical databases

Environment: SQL Server 2008 R 2/2005/2008/2000, Windows 2K/2003/2008 R2, SQL Profiler, Query tuning advisor, Symantec, SSIS 2008R2, SSRS 2008 R2.

SQL Server DBA

Roles &Responsibilities:

• Responsible for supporting 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 ongoing performance tuning, administration, upgrades, service packs, re-creating indexes backups, dumps, recovery, and restores of all mission critical databases.

Environment: SQL Server/2005, 2000 Windows 2K/2003, SQL Profiler, TSQL.

SQL Server DBA

Roles &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 & DETACH 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.

Environment: SQL Server/2005,2000 Windows 2K/2003, SQL Profiler, TSQL.