SUMMARY:

• 6years of experience working as production Oracle Database Administrator on version 10g, 11g and 12c databases.
• Extensive knowledge of providing on - site support on backup/recovery using RMAN, datapump export/import.
• Expert in performance turning using Automatic Work Load Repository (AWR ) and Automatic Database Diagnostic Monitor (ADDM ).
• Successfully configured a two node RAC (real application cluster) for high availability and Dataguard for disaster recovery. Provided 24/7 on call support on production databases. Excellent documentation and communication skills.
• 6 years of IT experience in the field of database administration working with Red hat Linux enterprise 6, Windows 2008, RHEL, Oracle 12c/11g/10g/9i,8i, Oracle RAC, DataGuard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, Putty, MS SQL Server, TOAD, SQL*Plus/SQL, MS SQL Server, Exp/imp/Data pump, Performance Tuning.
• Experience in troubleshooting, Installing and configuring high availability technology RAC and Dataguard for disaster recovery
• Implement Oracle Enterprise Manager Grid Control (OEM 11g/10g) for centralized monitoring and administration
• Assisted a team of DBA’s in database upgrade from version 10g Release 2 to oracle 11g Release 2
• Applied Critical patch update (CPU) for security and patch set update (PSU) for security and bug fixes
• Use OEM, Toad and SQL Developer in managing and monitoring databases
• Installed red hat Linux, Solaris, Windows 2008 from scratch, configured them for Oracle Installation and created oracle databases using DBCA, used netca to configure the listener and tnsnames.
• Scheduled jobs for various purposes like backups and Database notifications like job failures, disk issues, critical events
• Extensive knowledge on Hot/Cold backup, database Recovery and Cloning using RMAN with VERITAS NetBackup
• Responsible for creating User, Groups, Roles, Profiles and assigning the users to their groups and grant necessary privileges
• Provided 24x7 production support for Oracle 12c/11g/10g/9i/8i databases on various platforms
• Maintain the Oracle 10g/11g/12c RAC environment and troubleshoot performance problems.
• Deploying code in production databases in times of release activities or any maintenance tasks.
• Proficient in all DBA responsibilities such as Installation, Configuration, Perform Oracle Upgrades from 10.2.0.3 to 11.2.0.3 for DEV, Stage & Production environment, Patches, Performance Tuning, Backup, Recovery, Cloning, Space management.
• Upgrade the production and development databases from 10.2.0.1 to 10.2.0.4
• Set up Oracle Data Guard on Oracle 10g/11g for high availability, data protection and disaster recovery, also manually created physical standby database using data guard.
• Use Oracle Enterprise Manager (OEM) to monitor the database, cloning and many more

TECHNICAL SKILLS:

Tools: Sun solaris, Red Hat Linux, AIX, oracle 10g, 11g, AWR, ADDM, Explain plan, statspack, EOM, Toad, Sql developer, DBCA, Datapump, Service Now (Snow)

Remote Tool: Cisco VPN, VNC, Remote desktop, VMware virtualization.

PROFESSIONAL EXPERIENCE:

Confidential

Database Administrator

Responsibilities:

• Proactively m onitoring databases and systems using Nagios monitoring tool; troubleshooting every error that comes up from the database and system
• Perform data pump Exports/Imports of schemas requested by end users and developers.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (oracle Enterprise Manager).
• Performing cloning of the database for end users to test certain applications on it or for our clients upon request.
• Performed Logical backup of critical application databases using EXPDP/IMPDP with a scheduled job (Cron Job).
• Worked with Sys. Admins, Network Admins and Q/A's to establish a productive and friendly work environment.
• Monitored the oracle instances, users, tables, tablespaces, segments and rollback redo logs, archived logs, and alerts.
• Experience in maintaining database security regulations and procedures.
• Troubleshoot issues from Linux, oracle, windows 2008, RAC, Data Guard and RMAN
• Prevented unforeseen events by checking Alert Log Files, Trace Files, and System Event Logs.
• Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes
• Performance and tuning of Microsoft SQL Server instances.
• Provided 24 X 7 Production & Development database support and administration.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Maintain the Oracle 10g/11g/12c RAC environment and troubleshoot performance problems for multiple clients
• Controlled and monitored user access to the database.
• Created databases, users, rollback segment, views, profiles, privileges, tables, stored procedures, triggers, indexes and other objects within the databases based on requirements from developers.
• Installed and maintained Oracle 2 nodes Real Application Clusters (RAC) on Linux systems.
• Configured Oracle Grid Control systems and Enterprise Manager(OEM) for database diagnostics and monitoring.

Confidential

Database Administrator/SQL DBA

Responsibilities:

• Perform troubleshooting and resolving databases and systems problems
• Use Nagios to monitor databases, applications and operating systems.
• Performed Database administration including monitoring and tuning, job automation, maintenance task, backup recovery, analyze database performance.
• Installation and configuration of SQL Server 2012, 2014, 2016.
• Configured the SQL mail/DB Mail to send email alerts to the operators.
• Work with DataGuard, RAC, Linux, RMAN, Toad, putty, Windows 2008 and many more
• Troubleshoot issues from Linux, SQL Server, oracle, windows 2008, RAC, DataGuard and RMAN
• Installed and configured oracle RAC and Data Guard for our clients
• Installed, Configured, and Administered SQL Server Reporting Services (SSRS), and Developed, Deployed and Managed Reports for associates and upper management using SSRS, Crystal Reports and Report Builder.
• Experienced in monitoring\capturing SQL Server performance issue by using Windows Performance Monitor\Task Manager/ SQL native Monitor/SQL profiler.
• Created and Managed Jobs, Setup Alerts, SQL Mail Agent and Scheduling SSIS Packages.
• Use data pump to export schemas to another database for developers to use for testing purposes
• Supported day to day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting long-running queries, locks, deadlocks
• Operate 24/7 production support
• Create indexes, index management, objects, table space, Schemas and statistics
• Management of table spaces, logs, grants, roles, users, and indices, apply patches, upgrade, manage storage.

Confidential

Database Administrator/SQL DBA

Responsibilities:

• Used data pump to export schemas to another database for developers or end users for testing purposes
• Did Performance Tuning and Optimization (PTO), using monitoring and troubleshooting tools
• Perform backups, restores and recovery models for SQL server databases, oracle and MySQL
• Performed installation of SQL Enterprise 2005 64bit version on Windows 2003, 2008 servers and VM ware servers on Enterprise systems of Clustered and standalone servers in enterprise data center Patch applications
• Provided Database supports for multiple applications in development, test, and production environments.
• Configured database mirroring as part of disaster recovery solution, clustering as high availability solution and replication to achieve scalability of databases and to improve read performance.
• Create indexes, index management, and statistics
• Work with DataGuard, RAC, Linux, RMAN, Toad, putty, Windows 2008 and many more
• Designed and created database objects like tables, stored procedures, views, triggers, user defined data types and functions
• Monitored SQL Server error logs, job history logs, space usage, customer complaints, tickets, optimizing queries, tracing long running queries and deadlocks.
• Performing troubleshooting in all our servers including databases and application servers
• Proactively monitoring all our database, systems and applications servers
• Operate 24/7 production support

Confidential

Oracle Database Administrator/SQL DBA - Junior

Responsibilities:

• Managed all our RMAN backups, restore and recovery
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Managing day-to-day SQL Server operations in SQL Servers 2005/2008/2008 R2
• Managed all our daily and weekly backups
• Troubleshooting, monitoring, and tuning SQL Server and databases performance using SQL Profiler, System Monitor.
• Checking the Configuration and performance of the existing databases including data file allocation, index, fill factor, fragmentation;
• Analyzing potential problems, e.g., Response Delay, Locking, SQL down time, for Optimization of performance.