SUMMARY

• To pursue a responsible, rewarding and growth oriented career position in a professionally managed organization that provides challenging opportunities of Oracle Core database technology like EXADATA, RAC.
• Performance tuning and Database Administration also having expertise in Microsoft SQL server various version, SQL cluster and SQL log shipping. Having sound knowledge of cloud administration and migration.
• Having 17 years plus experience as Oracle Database consultant with Oracle10g RAC,11g RAC,12c RAC 12c and oracle version 10g,11g,12c, 9i & 8i (OEM)

TECHNICAL SKILLS

Operating System: Linux Red Hat, HP - UNIX, IBM AIX 4.5 UNIX 6.1 & Windows 7, 8, 2003 & 2008

RDBMS: Exadata on Oracle 12c, 11gR2, 10g RAC, ASM, & Apex Admin Microsoft SQL Server

Monitoring Tools: OEM 12c, Idera, Scripts

Migration/Replication Tools: Golden Gate, Data Guard and Oracle Advanced Replication

Oracle Tuning Tools: DBArtisian, TOAD and Database Performance Analyzer and SQLT.

Hardware: Exadata x2 V2 to x6, SUN Ultra 250/450 Servers, SUN E3500 with RSM 2000 Storage

Scripting: UNIX Shell Scripting and PowerShell

Backup Tools: Netvault, HP Dataprotechtor, Veritas

Cluster: Oracle RAC, Sun Cluster, Windows

Cloud: Microsoft Azure Cloud, AWS

Other Technologies: Remedy, Service Now, PUTTY, VNC.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Playing a key role in the member of enterprise architect group.
• Takes a lead position (non-management) in complex initiatives of strategic importance (e.g., cross functional/ cross geographies), including implementing the most appropriate data solutions for individual applications.
• The company “go-to” resource for all technical data engineering questions and consulting (e.g., physical database design, performance tuning and implementation).
• Researches and evaluates tools and opportunities to support cross-domain needs
• Applies advanced technical capabilities within own discipline to coach and develop technical talent and project teams
• Forward thinking infrastructure automation and scripting skills.
• Requires little supervision while identifying tasks associated with responsibilities
• Collaborates with other DBAs, participates in internal projects, and leads some initiatives.
• Provide DBA suggestions and input on direction for database domain strategy.
• Demonstrates an understanding of Data Architecture’s role in supporting business processes.
• Demonstrates ability to participate in cross functional teams for estimating, application designs, and implementation strategies
• Responsible for the database architecture, engineering, and administration of all Oracle platforms
• Including the installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery
• Utilizing network troubleshooting tools and techniques
• Responsible for database monitoring and applying resolutions to database issues
• Expertise in database performance tuning by using various tool of oracle like AWR, SSH, ADDM reports.
• Expertise SQL Tuning, End-user tuning and troubleshooting using various tools like SQLT,EXPLAIN PLAN, AUTOTRACE, SQL TRACE, TKPROF, STATSPACK, AWR, ADDM, ASH, v$performance views.
• Good understanding about the SQL-T report analysis.
• Expertise in analyzing database hung situation and provide the solutions.
• Worked on various oracle trace event in order to optimize the database performance issue.
• Experience in fixing the SQL plan by using the SQL profile, Outline etc.
• Experience of tuning database by using multiple event like 10046, 10053 etc.
• Create and maintain documentation for database architecture.
• Designed, implemented and administered a database system for SAP applications.
• Experienced on Implementation/Administration of Oracle 10g, 11g, 12c RAC (Real Application Clusters) on Linux and Windows, including all options for storage. Install.
• Server side and Client-side fault tolerance achieved by configuringSERVICESandTAF(Transparent Application Failover).
• Implemented Client side load balancing in cases where Server side Load Balancing is not possible.
• Monitoring cluster and Databases using CRSCTL and SRVCTL.
• MigratedOS file system storage to ASM with minimal downtime and administered ASM disk groups and instance.
• Configured Metrics and thresholds for Exadata, cluster and Databases..
• Monitoring Exadata Db-Servers and Cell-Servers, PDUs, InfiniBand and Admin Switches using OEM, ILOM, ExaCLi, ExaDCLi, CellCLI and DCLI and running Health check, ExaChk, OSWatcher OEM13c, OEM 12c, and Sun DIAG Reports.
• Converted flash Cache from Write through to Write Back and maintain Performance tuning exadata Cell Disks and Raising SR if Disk falls to POOR PERFORMANCE state & identifies data queries are using Smart Scan or not.
• Implement EXADATA monitoring by ILOM, KVM and using Oracle Enterprise Manager Cloud Control 12c & 13c and identified problems on cell nodes.
• Patching for ESS patching, cell nodes & INFINIBAND patching and network maintenance tasks and understanding of EXADATA smart storage capabilities, HCC, smart flash cache intelligent caching.
• Implemented server and component backups for Exadata using RMAN Backup. & DISK and TAPE (D2D2T).
• Performed Zero downtime Migration and upgrade at same time using Standby.
• Configured Active & Snapshot Datagurd with Real-Time apply for several RAC Databases to Implement Datagurd Broker. Performed Switchover and Failover Testing of Datagurd. Implemented Snapshot Standby Database for quarterly DR drills. Monitoring Datagurd and daily basis and occasional DR sync.
• Experience in UNIX Shell Scripting for automating the DBA tasks like User maintenance, Performance Monitoring of CPU, Disk and Memory usage, and File system monitoring.
• Experience in resolving complex restore and recovery issues using RMAN.
• Good knowledge of High Availability (HA), Always On and Disaster Recovery (DR) options for MSSQL Server.
• Maintenance and support of SQL server Mirroring, Log shipping, Clustering, and other methods of disaster recovery.
• Designing and running system load/stress testing; escalating application problems to vendors.
• Install, configure and deploy MS SQL Server. Perform capacity planning, performance turning, monitoring, troubleshooting and optimization of the databases
• Perform SQL administrative tasks including installing and upgrading SQL server products, creating maintenance plans, and creating database objects
• Installed, Configured, and Maintained SQL Server 2014, 2012, and 2008 R2 in development, test, and production environment
• Configured and Maintained Fail-Over Clustering using SQL Server 2012
• Experience in AlwaysOn environment
• Maintained server and database security including database encryption (TDE)
• Installed and Configured SQL Server Reporting Services (SSRS)
• Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability.
• Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2000/2005 to 2008 R2 and 2008 R2 to 2012
• Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues
• Performed database and SQL/TSQL Performance Tuning
• Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications
• Create and managed different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check)
• Manual, on Demand and setup jobs for Database Backup, and design backup strategy
• Deployed and Restored database including Point in Time Recovery
• Monitor Server Activity, Error Log, space usage and solving problem as needed

Confidential

Sr.Database Administration

Responsibilities:

• Monitoring Exadata Db-Servers and Cell-Servers, PDUs, InfiniBand and Admin Switches using OEM, ILOM, ExaCLi, ExaDCLi, CellCLI and DCLI and running Health check, ExaChk, OSWatcher OEM13c, OEM 12c, and Sun DIAG Reports.
• Experienced on Implementation/Administration of Oracle 10g RAC (Real Application Clusters) on Linux and Windows, including all options for storage.
• Experienced on Implementation/Administration of Oracle 11g RAC (Real Application Clusters) on Linux and Windows, including all options for storage.
• Install and configure Oracle 11G on Active/Passive Sun Cluster.
• Installed and Configure Oracle data guard on oracle9i and 10g.Configure Oracle data guard for Oracle RAC using RMAN.
• RMAN configuration Including TSM
• Directed the Oracle Upgrade and completed before time.
• Database Upgrade oracle 9i to oracle10g and oracle 10g to oracle 11g Oracle Patch Implementation.
• Designed, implemented and administered a database system for SAP applications.
• Developed and implemented a comprehensive Disaster Recovery Plan for the Oracle Databases at the division.
• Setup and managed replication among several databases.
• Database Installation on SUN Solaris, Linux, HP-UNIX and windows O/S
• Design Database backup and recovery strategy using RMAN with HP Data protector.
• Maintain physical and logical backups using User Managed Backup procedures.
• Performance Tuning Application/OS level.
• Database refresh up to 3 TB through RMAN (clone) and Manual procure.
• Trouble shooting at Oracle RDBMS as well as application level.
• Developed procedures to load data using SQL loader with Direct/ conventional/ parallel modes
• Delivering projects related Database setup and implementation for clients.
• Break/fix activity pertaining to monitoring, troubleshooting and resolving customer related issues.

Database Administration

Confidential

Responsibilities:

• Experienced on Implementation/Administration of Oracle 10g RAC (Real Application Clusters) on Linux and Windows, including all options for storage.
• Install and configure Oracle 11G on Active/Passive Sun Cluster.
• Installed and Configure Oracle data guard on oracle9i and 10g.Configure Oracle data guard for Oracle RAC using RMAN.
• RMAN configuration including Netvault.
• Managed a team of 6 DBA for Design, Development and Production support
• Administered 150+ Oracle databases totaling 5000 GB, both OLTP and data warehouse.
• Directed the Oracle Upgrade and completed before time.
• Database Upgrade oracle9i to oracle10g, Oracle Patch Implementation.
• Designed, implemented and administered a database system for SAP applications.
• Developed and implemented a comprehensive Disaster Recovery Plan for the Oracle Databases at the division.
• Setup and managed replication among several databases.
• Database Installation on SUN Solaris, Linux, HP-UNIX and windows O/S
• Design Database backup and recovery strategy using RMAN with HP Data protector.
• Maintain physical and logical backups using User Managed Backup procedures.
• Performance Tuning Application/OS level.
• Database refresh up to 3 TB through RMAN (clone) and Manual procure.
• Trouble shooting at Oracle RDBMS as well as application level.
• Developed procedures to load data using SQL loader with Direct/ conventional/ parallel modes
• Working in Technical Support Group (TSG) of Confidential ., Delhi And providing Level-2&3 support to complete northern region
• Delivering projects related Database setup and implementation for clients.
• Break/fix activity pertaining to monitoring, troubleshooting and resolving customer related issues.
• Providing DBA Training to our site engineer and supervise their activities in a 24 x 7 production environment.
• SQL Server database installation & configuration.
• SQL Server file & file space management.
• SQL server database backup & Restore.
• SQL server database performance and analysis management.
• SQL server database user management.
• SQL database monitoring, troubleshooting and resolving day to day issue.
• Ensuring smooth application running.

Database Administration

Confidential

Responsibilities:

• I was the member of technical architecture team and production Support DBA.
• Installation & Configuration of Oracle 10g RAC with Windows, Sun Solaris and Linux.
• Installation & Configuration of Oracle 10g On HP-UX Active/Passive Cluster
• Installation & Configuration of Oracle 10g On SUN Solaris Active/Passive SUN Cluster
• Installation and maintaining Oracle Server 9i, Sun Solaris 9, Linux 7.2, Win 2000 Server.
• Oracle Datagurd Implemented on RAC environment.
• RMAN Implemented on RAC environment.
• Developed procedures to load data using SQL loader with Direct/ conventional/ parallel modes.
• Database administration, managing table spaces, objects, disk space.
• RAMN Backup by using HP Data protector Software.
• Providing the DR Solution with Oracle Standby Server.
• Patching Oracle Database.
• Analyzed and rebuilt backup and recovery strategy.
• Trouble shooting at Oracle RDBMS as well as application level.
• Creation of oracle users, oracle roles, granting privileges and profiles etc.
• Data modeling and database design for Purchase, Stores and Invoicing applications.
• Maintain physical and logical backups using User Managed Backup procedures.
• Trouble shooting at Oracle RDBMS as well as application level.
• RAMN Backup by using Veritas NetBackup Software
• Managed Database on SAN Environment & STK l -40 Automated Libraries.

Confidential

Database Administration & Software developer

Responsibilities:

• Modeled, designed, implemented and administered the Professional ERP. I was the member of the Technical Architecture Team and Production Support DBA.
• Developed procedures to load data using SQL loader with Direct/ conventional/ parallel modes.
• Analyzed and rebuilt backup and recovery strategy.
• Maintain physical and logical backups using User Managed Backup procedures.
• Trouble shooting at Oracle RDBMS as well as application level.
• PL/SQL & query designing for purchase & Inventory application i.e. (FIFO, LIFO, Stock Ledger).
• Integration & Development of VB 6.0 application to oracle9i database.
• Building complicated Reports using crystal Report 8.0 with oracle9i.