SUMMARY

• 17+ years extensive experience as a Senior SCOM Admin and SQL Server DBA in Database Design, SCOM/SQL Server software Installations/configurations, Database Maintenance, Database Migrations, Database Administration and 24/7 SQL Server production support and SQL DBA for Database application development projects.
• Experience with MYSQL, Cassandra, Postgres, Greenplum and Oracle databases
• As of now I have installed and configured 5000 SQL Servers and supported and maintained many SQL Servers and designed and supported more than 10,000 databases
• Worked on around 10 TB size of larger databases environment.
• Worked on High availability clustering environment
• Worked on DR environments using (Log shipping/ Mirroring/replication)
• Very good working experience with SAN/WAN network storage drives
• Very good experience with SSIS/SSRS/SSAS/DTS administration work
• Extensive experience as a SQL Server Sys DBA, Application DBA, and Lead DBA for Application development team
• Extensive experience in SQL Server 2014/2012/2008 R2/2005/2000 SQL Servers
• Experience in Always ON/mirroring/Azure technologies/Clutering
• Extensive experience in Power shell, Windows scripting, VB Scripting, SQL scripting
• Very good experience in ERP related applications SAP and People soft
• Extensive experience in Database - migration process projects (SQL Server to SQL Server, Oracle to SQL Server, SQL Server to Oracle, MS Access to SQL server, MYSQL to SQL Server, Postures to SQL Server)
• Good Experience in Database high availability environments like SQL Server Clustering Services (Active and passive), SQL Server replication process and Database Mirroring process, Database snapshot mirroring.
• Working experience in Oracle DBA, MYSQL DBA, postgres DBA/ Cassandra DBA and SQL/PL Programming using procedures, Functions, Cursors, Packages, and Triggers.
• Working experience with Experience with Double Take software

TECHNICAL SKILLS

SCOM Tools: SCOM, SCOM 2012

Database SQL Servers: SQL Server 2014,2012, SQL Server 2008 R2, SQL Server 2005

Database Oracle Server: Oracle 11i, Oracle 10g and Oracle 9i

Open source Databases: GreenPlum, MYSQL 5.x, PostGres SQL, Cassandra, Ingres and MS Access

SQL Server BI tools: SSIS, SSRS, SSAS

Database Tools: Quest Performance Analysis, Tivoli, Toad, Erwin, TSQL

Database monitoring tools: Quest Performance Analysis, MAAP, BMC Patrol, LitespeedPerfmon Confidential RAP, Performance Tuning/Counter

Database Netback up tools: VERITAS and Tivoli storage Manager

Database Programming: SQL Server SSIS, DTS, T-SQL and Oracle SQL / PL SQL

Database Migration Tools: SSIS, DTS, SQL and Oracle Migration Services, PL SQL, MYSQL

Database Access tools: SQL, Quest PA, Erwin, Toad, and DBArtisan

Database storage: SAN / WAN storage

Database High availability: Clustered environment, mirroring, log shipping, replication

Web programming tools: ASP.NET, ASP, PHP, HTML, DHTML, XML, XSLT, Java/VBA

Languages: VB.Net, C#, VB6, VBA,WS script, Power shell script

Reporting tools: Crystal Reports XI, Crystal Analysis pro, Crystal Enterprise and MS Access Reports

Networking: LAN, WAN, VPN and all networking Active X (Middle layer) COM, COM+, DCOM, MTS and MSMQ

Macro programming (VBA): MS Word, MS Access, MS Excel and outlook

Scripting Languages: Power shell, Windows scripting, WMI,Java script, VB scriptjscript, Perl script

Servers: IIS BizTalk, Crystal enterprise, MTS, LDAP and Site server

Operating Systems: MS-Dos, Windows 2008/2003, Linux, Tru64 and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. SCOM Admin/SQL Server DBA (Production Support)

Responsibilities:

• Working on 27/7 SCOM Admin/SQL Server Production DBA support on Rotation basis
• Installed SCOM /SQL servers on Azure technologies and supported.
• Configured always on mirroring
• Installed and configured SCOM Admin/sql server failover clustering environment
• Working on Service now oriented structural support from operations on SQL server issues
• Worked on Design new SQL Server Installations & Configurations
• Maintained the existing Production SQL Servers and Databases.
• Communicating with Application owners Business teams on SQL Server requirement.
• Created many SQL Server Databases.
• Worked on VM ware tools VMConverter for migrations from Linux/Unix to VMware
• Working on supporting SQL Server related applications (Trading, Financial, Trust projects)
• Resolved the performance issues with very large SharePoint application databases
• Supported the existing databases.
• Worked on SQL Server Reporting services
• Working on Regular production SQL Server maintenance jobs, backup jobs.
• Worked on SOX Security Audit related to SQL Server databases
• Worked on resolving regular SQL Servers and databases problem incident tickets.
• Worked on SQL Server and databases Service manager tasks to perform the activities.
• Worked on Databases Backups & Recovery Planning process
• Worked on Database Backup & Recovery Implementation & Testing and fixing issues
• Worked on Backup Maintenance plan execution and scheduling process
• Worked on Install SQL Server Instances & Database Level Security process
• Worked on SQL-Server Client Installs and Database Connectivity.
• Worked on Database data files, log files, backup files and trace files Space Management
• Worked on database Document Intent and Expectations
• Worked on Security process using database scripting, windows scripting and VB scripting
• Worked on Database Application Object Planning, Object Creation
• Worked on Database Application Access & Performance Planning
• Worked on Database application usage trace files Profile Planning and creation
• Worked on Database Application Security Planning (Roles) and creation of Database User Accounts(ID’s) Assigning of Roles to User Accounts
• Worked on database Application Security Implementation
• Worked on Database Application Client Software Deployment
• Worked on Database Application Migration/Upgrade Planning and implementation
• Worked on database Application Migration/Upgrade Code/Script Creation/Test
• Monitor Database Uptime per Requirement (7x24..etc)
• Worked on Monitor and Inform Application Owner of Perf. Issues
• Worked on database tune Instance Parameters for Performance Issues
• Worked on database tune Database Parameters for Performance Issues
• Worked on Database Maintain reasonable History (Quest PA) for Trend Analysis
• Worked on Document Database Change Control Database changes, Patches and Upgrades
• Worked on database Production Database Problem Support
• Worked on database Defect Resolution
• Worked on SQL-Server Services if any issues and change SQL services passwords.
• Worked on SQL Server Database execution of System Backup Processes and System Recovery process
• Worked on DTS /SSIS management and execution and deployment
• Worked on database maintenance jobs Creation and execution of Job requests
• Data management ( statistics, indexes)
• Creation of Admin User Accounts (SA only)

Confidential, IL

Sr. SCOM Admin/SQL Server DBA

Responsibilities:

• Worked on Design new SCOM Admin/SQL Servers Installations & Configurations
• Worked on SQL server2012 clustering Widows 2012
• Maintained the existing SQL Servers and Databases.
• Communicating with Application owners Business teams on SQL Server requirement.
• Created many SQL Server Databases.
• Worked on VMconverter
• Resolved the performance issues with very large SharePoint application databases
• Supported the existing databases.
• Worked on SQL Server Reporting services
• Worked on resolving regular SQL Servers and databases problem incident tickets.
• Worked on SQL Server and databases Service manager tasks to perform the activities.
• Worked on Databases Backups & Recovery Planning process
• Worked on Database Backup & Recovery Implementation & Testing and fixing issues
• Worked on Backup Maintenance plan execution and scheduling process
• Worked on Install SQL Server Instances & Database Level Security process
• Worked on SQL-Server Client Installs and Database Connectivity.
• Worked on Database data files, log files, backup files and trace files Space Management
• Worked on database Document Intent and Expectations
• Worked on Security process using database scripting, windows scripting and VB scripting
• Worked on Database Application Object Planning, Object Creation
• Worked on Database Application Access & Performance Planning
• Worked on Database application usage trace files Profile Planning and creation
• Worked on Database Application Security Planning (Roles) and creation of Database User Accounts(ID’s) Assigning of Roles to User Accounts
• Worked on database Application Security Implementation
• Worked on Database Application Client Software Deployment
• Worked on Database Application Migration/Upgrade Planning and implementation
• Worked on database Application Migration/Upgrade Code/Script Creation/Test
• Monitor Database Uptime per Requirement (7x24..etc)
• Worked on Monitor and Inform Application Owner of Perf. Issues
• Worked on database tune Instance Parameters for Performance Issues
• Worked on database tune Database Parameters for Performance Issues
• Worked on Database Maintain reasonable History (Quest PA) for Trend Analysis
• Worked on Document Database Change Control Database changes, Patches and Upgrades
• Worked on database Production Database Problem Support
• Worked on database Defect Resolution
• Worked on SQL-Server Services if any issues and change SQL services passwords.
• Worked on SQL Server Database execution of System Backup Processes and System Recovery process
• Worked on DTS /SSIS management and execution and deployment
• Worked on database maintenance jobs Creation and execution of Job requests
• Data management ( statistics, indexes)
• Creation of Admin User Accounts (SA only)

Confidential, IA

Sr. SQL Server 2008/2005 DBA

Responsibilities:

• Worked as a Sr SQL Server DBA for Wells Fargo Database Technology group for production systems and Development systems
• Worked on SQL Server Reporting services
• Worked with GreenPlum database on data importing and exporting from sql server
• Worked closely with Management on communicating with the production servers status
• Worked on regular production issues and fixing the customer related data issues
• Worked on production servers maintenance issues
• Worked on fixing the software related issues on database servers
• Worked on Design new SQL Servers/MYSQL Installations & Configurations
• Maintained the existing MYSQL and SQL Servers Databases.
• Communicating with Application owners Business teams on SQL Server requirement.
• Created many SQL Server Databases.
• Worked on data transformation services from source systems
• Resolved the performance issues with very large SharePoint application databases
• Supported the existing databases.
• Worked on resolving regular SQL Servers and databases problem incident tickets.
• Worked on SQL Server and databases Service manager tasks to perform the activities.
• Worked on Databases Backups & Recovery Planning process
• Worked on Database Backup & Recovery Implementation & Testing and fixing issues
• Worked on Backup Maintenance plan execution and scheduling process
• Worked on Install SQL Server Instances & Database Level Security process
• Worked on SQL-Server Client Installs and Database Connectivity.
• Worked on Database data files, log files, backup files and trace files Space Management
• Worked on database Document Intent and Expectations
• Worked on Security process using database scripting, windows scripting and VB scripting
• Worked on Database Application Object Planning, Object Creation
• Worked on Database Application Access & Performance Planning
• Worked on Database application usage trace files Profile Planning and creation
• Worked on Database Application Security Planning (Roles) and creation of Database User Accounts(ID’s) Assigning of Roles to User Accounts
• Worked on database Application Security Implementation
• Worked on Database Application Client Software Deployment
• Worked on Database Application Migration/Upgrade Planning and implementation
• Worked on database Application Migration/Upgrade Code/Script Creation/Test
• Monitor Database Uptime per Requirement (7x24..etc)
• Worked on Monitor and Inform Application Owner of Perf. Issues
• Worked on database tune Instance Parameters for Performance Issues
• Worked on database tune Database Parameters for Performance Issues
• Worked on Database Maintain reasonable History (Quest PA) for Trend Analysis
• Worked on Document Database Change Control Database changes, Patches and Upgrades
• Worked on database Production Database Problem Support
• Worked on database Defect Resolution
• Worked on SQL-Server Services if any issues and change SQL services passwords.
• Worked on SQL Server Database execution of System Backup Processes and System Recovery process
• Worked on DTS /SSIS management and execution and deployment
• Worked on database maintenance jobs Creation and execution of Job requests
• Data management ( statistics, indexes)
• Creation of Admin User Accounts (SA only)

Confidential, Maryland

Sr. SQL Server 2005 DBA

Responsibilities:

• Installation and Configuration of Confidential SQL Server 2008/2005/2000.
• SQL Server 2008/ 2005/2000 Database Administration.
• Migration from SQL 2000 to SQL 2005 and migration of DTS packages to SSIS.
• Extensive experience in Database mirroring.
• Backup and Restoration of user and System Databases.
• Managing SQL Server Security and Applying Business rules.
• Applying patches and new service packs closely with the respective application teams.
• Maintaining Maximum Server availability by proactively monitoring and resolving the issues.
• Database Tuning to achieve optimum performance and tuning recommendations for the application teams.
• Planning and Recommending the capacity growth and changes for SQL Server architecture.
• Proactively monitored and analyzed system performance.
• Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities.
• Involvement in a Project life cycle right from Envisioning stage thereby working as a role of consultant, suggesting the technologies to use, then helping the developers to develop them, reviewing the code to check that the
• Created and developed the stored procedures, triggers, views, and user-defined functions to handle complex business rules, activity log, error log, and audit analysis.
• Used SQL Profiler for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers and testers.
• Participated in on-call support.
• Analyzed and resolved database and application issues affecting SQL Server environments.
• Tested and implemented new releases of SQL Server-related software.
• Configured securities and access to product databases in SQL Server 2000, Windows 2003 Server.
• Used SQL Profiler for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers and testers.
• Participated in on-call support.
• Provided back-up DBA support for DBA team members.

Confidential

SQL DBA

Responsibilities:

• Involved in troubleshoot performance issues and perform restores
• Perform routine maintenance including restores, disaster recovery, performance tuning
• Support with multiple SQL Servers and named instances and server security worked in an enterprise 24x7x365 operation, large (20+GB) database management, clustered SQL Servers, SAN technology
• Maintained document and implement Disaster recovery models
• Production support role to keep existing system stable and available, and to resolve end user issues as they arise
• Analyzes business procedures and problems to refine data for database management
• Designed logical and physical databases
• Calculated optimum values for database parameters
• Test and correct errors and refine changes to databases
• Using Utility program to monitor database performance. Perform performance tuning
• Working with application developers and users
• Implemented data models and database designs
• Enabled applications with efficient back-end access and processing
• Resolved database performance issues, database capacity issues, replication, and other distributed data issues
• Created ETL scripts for Datawarehoue servers
• Provided high availability, security and integrity of assigned databases

Environment: SQL Server 2005, People Soft, ASP.NET, C#, Oracle 10g, Crystal reports XI, Share point Portal 3.0, IIS 6.0, Visual Studio. NET, Java Script, PL/SQL and LDAP.

Confidential

Sr. SQL Server DBA and Team Lead

Responsibilities:

• Installation and Configuration of Confidential SQL Server 2008/2005/2000.
• SQL Server 2008/ 2005/2000 Database Administration.
• Migration from SQL 2000 to SQL 2005 and migration of DTS packages to SSIS.
• Identify for performance enhancements and implement appropriate solutions
• Work done within Development to identify potential points of improvement in process design and data access
• Tune and Optimize Data Access.
• Optimized and troubleshoot SQL Server system activity.
• Designed a Security Plan
• Created database structures which support functional business applications
• Extensive experience in Database mirroring.
• Backup and Restoration of user and System Databases.
• Managing SQL Server Security and Applying Business rules.
• Applying patches and new service packs closely with the respective application teams.
• Maintaining Maximum Server availability by proactively monitoring and resolving the issues.
• Database Tuning to achieve optimum performance and tuning recommendations for the application teams.
• Planning and Recommending the capacity growth and changes for SQL Server architecture.
• Proactively monitored and analyzed system performance.
• Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities.
• Involvement in a Project life cycle right from Envisioning stage thereby working as a role of consultant, suggesting the technologies to use, then helping the developers to develop them, reviewing the code to check that the

Confidential

Sr. SQL Server DBA

Responsibilities:

• Installation and Configuration of MS SQL Server.
• Configuring Replication, Publishing & Managing Subscriptions.
• Backing Up & Restoring System and User Databases
• Transferring Data using BCP, DTS and using some proprietary Tools etc.
• Using Indexes, Views, Indexed Views, Triggers Instead of and After, Stored Procedures
• Developing Security administration, DDL, DCL, DML Script generating and maintenance plans.
• Creating, Debugging/Troubleshooting Stored Procedures and applying new business rules.
• Managing SQL Server Security, Managing Database Permissions.
• Applying patches and new Service packs to the servers and smoke testing for any impacts.
• Involved in Training New hires and documenting process guidelines.
• Installed and Configured Clarify Client and SQL Database Client

Environment: SQL Server 2000, Oracle9i, ASP.NET, C#, Crystal reports, IIS 5.0, Visual Studio. NET, Java Script, PL/SQL and LDAP.

Confidential

SQL Server DBA

Responsibilities:

• Installation and configuration of SQL Server 7.0/2000 and windows 2K/2003
• Create the database and manage the database location files and size.
• Up-gradation of SQL databases from 6.5, 7.0 to SQL Server 2000.
• Support a 7 x 24 SQL environment for SQL 7.0, SQL Server 2000.
• 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
• Created, developed, and modified data model for the complex client ordering and information, inventory administration, shipping and supplying database applications
• Maintained database dictionaries, monitored overall standards and procedures, and integrated enterprise systems through database design
• Created logical and physical database design, data structures, and implemented large databases using Erwin
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis
• Developed, modified, and optimized complex queries to data retrieval and modification
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using SQL Server Management Studio.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Generated database SQL scripts and deployed databases including installation and configuration
• Automated and enhanced daily administrative tasks including space management, object alteration, database backup and recovery
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity
• Scheduled and monitored all maintenance activities of SQL Server 2000 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 2000, 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
• Generated the weekly, monthly, and quarterly report by using Crystal Report
• Competent to work at the highest level of all phases of database management
• Developed distributed transactions to access database.
• Worked with Application development team and other vendors to maintain maximum availability.

Environment: SQL Server2000, PL/SQL, ASP.NET, Oracle, Crystal reports and IIS 5.0

Confidential

Sr. SQL Server DBA

Responsibilities:

• Supporting 24x7 for production systems.
• Build Scheduled-jobs to migrate data from flat files to UAT database
• Backup and restore large-scale SQL Server databases
• I have done SQL Server installations
• Database Migration and configure database Recovery if necessary
• Support and Clearing the database logs everyday
• Auditing database configurations and security configurations
• Performance monitoring and tuning T-SQL and database engines
• Created Database scripts (DTS) for migration
• SQL Server DBA to support Enterprise SQL Server Databases
• Support Windows Clustering for the multiple databases
• Auditing database configurations and security configurations
• Supporting 24x7 for production systems.
• Build and maintain the Database with high-performance
• Backup and restore large-scale SQL Server databases
• Performance monitoring and tuning T-SQL and database engines
• Created Database scripts (DTS) for migration

Environment: SQL Server2000, PL/SQL, ASP.NET, Oracle, Crystal reports and IIS 5.0

Confidential

Sr. SQL Server DBA and Team Lead

Responsibilities:

• SQL Server DBA to support Enterprise SQL Server Databases
• Support Windows Clustering for the multiple databases
• Auditing database configurations and security configurations
• Supporting 24x7 for production systems.
• Build and maintain the Database with high-performance
• Backup and restore large-scale SQL Server databases
• Performance monitoring and tuning T-SQL and database engines
• Created Database scripts (DTS) for migration
• Designed entity and functional relationships in logical data models and develops physical data models. Transforms physical data models.
• Monitor and evaluate performance of existing databases
• Identify for performance enhancements and implement appropriate solutions
• Work done within Development to identify potential points of improvement in process design and data access
• Tune and Optimize Data Access.
• Optimized and troubleshoot SQL Server system activity.
• Designed a Security Plan
• Created database structures which support functional business applications

Environment: SQL Server2000, PL/SQL, ASP.NET, Oracle, Crystal reports and IIS 5.0

Confidential

SQL Server DBA and Oracle PL/SQL Programmer

Responsibilities:

• Installation and configuration of Windows NT/2000, SQL Server 7.0 and 2000.
• Database creation and location of database file.
• Up-gradation of SQL Servers database from version 7.0 to 2000.
• Managing SQL Server users/ NT users.
• Replication of SQL Server databases.
• Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
• Testing the application for deployment, functional and behavior testing.
• Updating Confidential patches/Service packs on SQL Server and Windows NT.
• Installation, configuration and supporting of IIS servers.
• Monitoring of SQL Server/NT performance/deadlock tracing.
• Helping application teams in query analyzing and its optimization. Coordinating with users for downtime and maintain the system 24X7 running.
• SQL Server database backups/restoration and recovery of NT server/SQL Servers
• Conversion of different code page (Collation) and sort order to single code page (consolidation of databases in single server)
• Coordinate with many sites for data migration using DTS.
• Implementation of Active directory, group policy in windows 2000.
• Look after virus issue and the virus patches applied to the servers.

Environment: SQL Server2000, PL/SQL, VB.NET, Oracle8.0, Crystal reports and IIS 5.0

Confidential

SQL Server DBA

Responsibilities:

• Installing and Configuring of SQL Server 2000/7.0 0n windows 2000/NT OS.
• Managing of databases objects like Tables, views, indexes etc.
• Implementing Backups and restoring when necessary.
• Used BCP utility to publish table output to text files.
• Developed DTS Packages to transfer the data between SQL Server database and files.
• Creation and management of database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Developed scripts for maintaining administration tasks
• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Responsible for Database Backups & Restoration, Backup strategies and scheduling Backups.
• Created and monitored Database maintenance plans for checking database integrity.
• Implemented the SQL login security for developers and users
• Created DTS packages to pull data from Oracle and Flat Files.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Involved in planning and monitoring Log Shipping.
• Planning, Implementing and trouble shooting Replication.

Environment: SQL Server7.0, PL/SQL, Asp, VB6.0, Oracle7.3, Crystal reports and IIS 5.0

Confidential

SQL Server DBA

Responsibilities:

• Experience in Migration of Database Objects, Packages, jobs and services.
• Involved in resolving Deadlock and Index Optimization.
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Worked on Query Optimization and Performance Tunning.
• Developed Stored Procedures, tables, queries, views, DTS packages.
• Implemented Data Transformation Services (DTS), BCP, Log shipping and Bulk Insert.
• Experience working with Production (7 x 24) Environment.
• Experinece in data Extraction, Transformation & Loading ETL .
• Experience in Database Modelling using Erwin/E-R modelling.
• Experience in SQL Diagnostic Manager for monitoring SQL SERVER.
• Experience in working with Perl scripts/shell scripting.
• Experience in working with Grant.SQL and CRM Applications.
• Maintained DB maintenance plans using SSIS packages.
• Analysed the SQL Server error log/SQL agent log file/Event log/Application log files and provided proper solutions.
• Experience in Hotfix/Patch installation
• Provided 24/7 Support on rotational basis.
• Experience in database connectivity tools like OLE, ODBC, JDBC & ADO.NET.
• Developed Grants and Expenditure reports using SQL SERVER Business Intelligence Development Studio/SSRS.
• Extensive experience in T-SQL/PL-SQL developments.

Environment: SQL Server7.0, PL/SQL, Asp, VB6.0, Oracle7.3, Crystal reports and IIS 5.0