SUMMARY OF EXPERIENCE:

• Oracle DBA with 10+ year experience working on 10g,11g,12c and 19c Database in Oracle
• Microsoft Certified SQL Server DBA with 8+ experience in MS SQL SERVER 2016/2014/2012/2008R2/2008/2005 Database Administration in Production, Test and Development environment.
• Expertise in installation and configuration of MS SQL Server 2012/2008R2, 2008 & 2005 in different 32/64 bit environments.
• Expert in Installing, configuring and maintaining multi node (2 - node, 4-node) clusters running SQL Server 2016/2012/2008R2/2008/2005 in Active/Active/Active/Passive and Active/Passive mode.
• Expert in configuring DR sites using Database Mirroring technology on SQL server 2016/2012/2008R2/2008/2005 with a witness server or without witness server to configure automatic failover along with always on.
• Experience in upgrading SQL server and applying service pack and hot fixes.
• Expertise in database migration from one SQL server version to other.
• Expert in Database Backup, Restore and Disaster Recovery procedures and document disaster recovery drills
• Expert in working with third party backup tool like TDP (Transparent data encryption) SQL Lite speed to improve performance of backup and recovery
• Expertise in implementing Log Shipping as backup solution for MS SQL Server 2000/2005/2008 databases.
• Highly Experienced in SQL Server performance tuning, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC and DMV’S
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Expert in job, sending alerts using SQL Mail/Database Mail and customized extended procedures
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Plan.
• Expertise in using tools like SQL profiler, windows performance monitor and performance counter for monitoring and tuning MS SQL server performance, SCOM.
• Highly experienced in implementing Replication Models such as Transactional, Snapshot and Merge in SQL Server
• Experience in implementing the new features of MS SQL Server 2016/2012/2008R2/2008 such as Policy Based Management, Backup Compression,Always on and Transparent Data Encryption (TDE).
• Expertise in identifying, troubleshooting issues and documenting root cause analysis.
• Experience in configuring and managing Linked Server, Data transfer between SQL Server and other RDBMS.
• Experience in BMC Remedy, Magic ticketing tool for Incident management and Change Request.
• Knowledge of SQL server Integration Services(SSIS) and Reporting Services (SSRS)
• Experience supporting oracle core database and EBS application.
• Experience in providing good production support for 24x7 being on call system schedule overnight and weekends
• Excellent communication and interpersonal skill, Have good Problem Solving ability and Work well in groups

TECHNICAL SKILLS

RDBMS: MS SQL Server 2016,2014,2012,2008R2, 2008, 2005, 2000 OOracle 10g,11g and 12c, 19c

Operating Systems: Windows server2012, 2008R2, 2008, 2003, Windows 2000, Windows NT 4.0, Windows XP,Linux 6.5,Linux,HPUX

C Cluster Solution: Microsoft Cluster,RAC for Oracle and Data Gaurd

T Technologies: RAID, SAN

V Version Control Tools: Visual Source Safe, Source Gear Vault

O Third Party Tools: BMC Remedy, TDP, Lite Speed, Idera’s SQL Diagnostic Manager,SCOM,Foglight, Perfomance Anylizer, Cloud Control for Oracle Databse

L Languages: C, C++, T-SQL

WORK EXPERIENCE

Confidential, Cleveland OH

Responsibilities:

• Installed SQL Server 2016/2014/2012/2008R2/2008/2005 in production and development environments.
• Responsible for MS SQL Server 2016/2014/2012/2008R2/2008/2005 management and configuration.
• Apply Service Packs and Hot Fixes to the SQL servers.
• Performed all aspects of database administration including documentation, security, stability, capacity planning, performance monitoring, backups andrecovery.
• Additionally, designed and implemented a disaster recovery plan for production servers.
• Successfully upgraded from SQL Server 2005 to SQL Server 2008R2 and 2012 on Development and Production Environments.
• Performed SQL Server 2005 to SQL server 2008R2 and 2012 Migration.
• Administered and managed 2- node Active/Active and Active/Pasive Clustered Environment
• Successfully implemented Database Mirroring in SQL 2012/2008R2 and 2005.
• Maintained documentation of all T-SQL, SQL jobs, maintenance procedures, management in production and non-production environments and their audit plans.
• Maintained Database Security by limiting access from domain admins for all databases, centralizing and securing database administration access and maintenance jobs.
• Restricted SA access to DBA only and not to applications and established database level access for various application groups.
• Documented concrete list of actions developing teams performing in non-production or production environments.
• Performed Capacity Planning making sure that the databases are sized correctly so far as disk, CPU and memory capacity are concerned.
• Configured server parameters not exceeding any internal database thresholds and proactively resize database infrastructure before they hit the upper capacity thresholds.
• Regularly ran database consistency checks and stats for any database record corruptions.
• Managed database alerts sent by production and non-production databases and servers.
• Involved in Performance tuning, optimization of stored procedures and queries.
• Rebuilt or Reorganize indexes on tables using various SQL Server commands to reduce fragmentation.
• Developed SSIS Packages to transfer the data between SQL Server and other database and files. Created and scheduled daily running Jobs.
• Used SQL Profiler and Windows Performance Monitor to monitor the server performance, debug T-SQL and slow running queries.
• Used 3rd party tool Foglight and Perfomance Analyzer for performance monitoring of SQL servers.
• Collect performance statistics for all production instances.
• Creating Logins and Roles with appropriate permissions.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Configured Mail Profile for sending automatic mails to the respective people when a job fails
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Preparing the reports for the day-to-day as well as weekly/monthly purposes.
• Expert supporting oracle core database and EBS application.
• Expert troubleshooting performance issue in oracle database 11g,12c and 19c.
• Expert upgrading database from 11g to 12.2 and 19c version
• Expertise working on backup recovery and data pump for migration and point in time recovery
• Expertise working on 10g,11g and 12c Database in Oracle.
• Working on Oracle code change and user request for core and EBS database.
• Available for working in 24x7 production environment.

Environment: Microsoft SQL Server 2012/2008R2/2008/2005, Windows 2012/2008/2003 server,Linux server,Oracle 10g & 11g,12c,19c SQL Profiler, Foglight,Perfomance Anylizer.

Confidential, Cleveland OH

Responsibilities:

• Installed SQL Server 2008R2/2008/2005 in production and development environments.
• Responsible for MS SQL Server 2008R2/2008/2005 management and configuration.
• Apply Service Packs and Hot Fixes to the SQL servers.
• Performed all aspects of database administration including documentation, security, stability, capacity planning, performance monitoring, backups andrecovery.
• Additionally, designed and implemented a disaster recovery plan for production servers.
• Successfully upgraded from SQL Server 2005 to SQL Server 2008R2 on Development and Production Environments.
• Performed SQL Server 2005 to SQL server 2008R2 Migration.
• Administered and managed 2- node Active/Active Clustered Environment
• Successfully implemented Database Mirroring in SQL 2008R2 and 2005.
• Maintained documentation of all T-SQL, SQL jobs, maintenance procedures, management in production and non-production environments and their audit plans.
• Maintained Database Security by limiting access from domain admins for all databases, centralizing and securing database administration access and maintenance jobs.
• Restricted SA access to DBA only and not to applications and established database level access for various application groups.
• Documented concrete list of actions developing teams performing in non-production or production environments.
• Performed Capacity Planning making sure that the databases are sized correctly so far as disk, CPU and memory capacity are concerned.
• Configured server parameters not exceeding any internal database thresholds and proactively resize database infrastructure before they hit the upper capacity thresholds.
• Regularly ran database consistency checks and stats for any database record corruptions.
• Managed database alerts sent by production and non-production databases and servers.
• Involved in Performance tuning, optimization of stored procedures and queries.
• Rebuilt or Reorganize indexes on tables using various SQL Server commands to reduce fragmentation.
• Developed SSIS Packages to transfer the data between SQL Server and other database and files. Created and scheduled daily running Jobs.
• Used SQL Profiler and Windows Performance Monitor to monitor the server performance, debug T-SQL and slow running queries.
• Used 3rd party tool Foglight and Perfomance Analyzer for performance monitoring of SQL servers.
• Collect performance statistics for all production instances.
• Creating Logins and Roles with appropriate permissions.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Configured Mail Profile for sending automatic mails to the respective people when a job fails
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Preparing the reports for the day-to-day as well as weekly/monthly purposes.
• Available for working in 24x7 production environment.

Environment: Microsoft SQL Server 2008R2/2008/2005, Windows 2008R2/2008/2003 server, Oracle 10g & 11g SQL Profiler,Linux, Foglight,Perfomance Anylizer.

Confidential

SQL Server DBA

Responsibilities:

• Install and configure SQL server 2008/2005.
• Migrating and upgrading SQL instances from SQL 2005 to 2008 in dev/test/production environments.
• Migrating from ORACLE to SQL
• Planned, installed, configured and maintained the SQL Server 2008 in Environment of Active/Active Cluster.
• Experienced in implementing Database Mirroring for disaster recovery in SQL Server 2008.
• Optimization and Performance tuning using SQL Profiler, Performance Monitor.
• Optimization of Stored procedures, Slow running Queries and indexes.
• Tuning of SQL Server Memory structures and troubleshooting the existing issues with Buffer Pool and Paging
• Schedule SQL Agent jobs in shrinking fast growing log files, deleting junk records or old logins, updating statistics, and checking integrity of databases.
• Extensively involved in database backups and restore.
• Implementing Policy Based Management, Backup Compression and Transparent Data Encryption.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Actively involved in capacity planning/requirement analysis and I/O capacity
• Experience in load Testing and implementing the changes to Staging servers and Production servers.
• Preparation in Weekly, Monthly system maintenance report for Database backups.
• Providing 24 X 7 supports for production environment.

Environment: Microsoft SQL Server 2008R2/2008/2005, Windows 2008/2003 Enterprise server, SQL Profiler, Performance Monitor, Idera SQL Diagnostic Manager, Idera SQL Safe, Veritas Backup Exec, ITSM, Business Intelligence Development Studio

Confidential

SQL Server DBA

Responsibilities:

• Coordinated with business users to understand their requirements and specifications and also during the data center move,
• Actively involved in Capacity Monitoring and short and long-term Capacity planning in collaboration with development resources, System Administrators and System Architects.
• Installed and configured Active/Passive SQL cluster with SQL Server 2008 R2 for high availability of SharePoint 2010.
• Installed and configured 4-node cluster using SQL 2008 with 3 active nodes and 1 passive node.
• Setting up DR environment between the 3 instances clustered nodes with Mirror servers at another data center.
• Setting Replication and mirroring between databases on the various data center during the data center move to provide HA and availability for clinical and no-clinical apps.
• Provide support for SQL Server databases running clinical apps.
• Installed and configured standalone SQL Server 2008R2/2008 and setting HA/DR solutions (like replication and. mirroring) across data centers.
• Created Individual/group logins and granted appropriate role to access database instance.
• Actively involved in SharePoint 2010 backend support and configured SQL Server databases as per application requirement.
• Performed database migration from SQL Server 2005 to 2008 and also migrated databases from 2008R2 to 2008 using import/export wizard.
• Troubleshoot performance issue with SQL Server databases and improved database performance.
• Scheduled and monitored existing/new jobs on production environment.
• Identified issue with failed SQL jobs and resolved it in a timely manner.
• Monitoring event log and Server error log to troubleshooting purpose.
• Configured Management Data Warehouse (MDW) in SQL Server 2008R2/2008 and generated report on report server.
• Performed database refresh as per application requirement to support development work.
• Identify and resolved Blocking and Locking issue using DMV (Dynamic Management View) and Activity Monitor.
• Configured and monitored Maintenance Plan for daily and weekly maintenance activity.
• Identified data fragmentation and performed Index reorg or Index rebuild when required.
• Applied Microsoft Security patches on standalone as well as on cluster servers.
• Monitored Server disk space and took corrective action if required.
• Worked with SQL Server profiler to identify and troubleshoot most expensive query using user created template.
• Worked on linked servers to run distributed queries between SQL servers
• Installed and configured Oracle client 10.2.0.4 and 11.2.0.2 on SQL Database server to setup linked server between SQL Server databases and Oracle databases
• Created and maintained Guideline and SOP as part of Good Documentation Practice.

Environment: Windows server 2003/2008, Windows XP Professional, MS SQL Server 2008R2/2008/2005, SSIS, SSRS, SQL Server Business Intelligence Development Studio, Oracle 10g,11g