SUMMARY:

• Having 8+ years of experience as Sr. Oracle Database and Postgresql Administrator.
• Having 2+ years of experience in managing No Sql databases MongoDB and Cassandra.
• Extensive experience of working on Oracle 9i, 10g and 11g on Sun Solaris, UNIX, IBM AIX, HP - UX, Red Hat Linux, and Windows and Postgresql databases from 8.4 to 9.4 versions.
• Install Configure and deployment of Oracle 11g database and Real Application Clusters (RAC) on different nodes with ASM (Automatic Storage Management) on RHEL 5 & HP-UX Setup physical stand by database using Data Guard for disaster recovery.
• Has installed Postgresql Database software of various versions till 9.4 and maintained databases and related software packages.
• Experience in installation and configuration of Oracle GoldenGate replication between Oracle-Oracle databases.
• Experience in full life cycle of database administration. Worked both as a development and Production Support DBA.
• Experience developing Oracle database code using SQL and PL/SQL.
• Laying out database tables and database schema design, startup and shutdown of Databases.
• Hands on experience in Managing Tablespaces, segments, extents, and indexes.
• Good Knowledge in Setting PFile & SPFile parameters, maintaining Data Files, Control Files, and Redo Log Files.
• Managing Oracle Net Configuration, monitoring Alert Log Files, Listener Log, Redo Log status, and Trace files for the database.
• Expertise in Oracle OEM 12c implementation and operations in an enterprise scale.
• Monitored and tuned Rollback segment, temporary tablespace, redo log buffer, sort area size
• Maintained Users and Roles with Appropriate Privileges and Profile.
• Designed and implemented Backup and strategy using RMAN (Recovery Manager)
• Experience in advanced recovery methods like PITR using Flashback.
• Logical backup using and full/ partial backup export/import and Data Pump in Oracle 10g.
• Experience in Upgrade and Migration of oracle database and RAC to higher version installing patches.
• CPU Patch installation using Opatch utility.
• Solid experience on Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Communicate with Oracle, generate RDA Report and Web conference for TAR Support.
• Efficient in SQL query optimization using explain plan, TKPROF reports, gathering statistics, pinning the objects.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM).
• Database Administration of Medium to Large size database (100 GB to 5 TB).
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Experienced in 24x7 Environments
• Excellent communication and interpersonal skills, Good team player, analytical and presentation skills with strong aptitude towards learning new technologies.
• Coordinated with software development teams for fixing technical issues and database errors.
• Assisted in designing and management of PostgreSQL database schemas and tables.

TECHNICAL SKILLS:

RDBMS: Oracle 12c, 11g, 10g, 9i

OS: SUN SOLARIS 8/9/10, HP-UX Itanium 11.31, Red Hat Linux 4/5, AIX 4.3, 5.2

Tools: OEM, TOAD, SQL Developer, F-Secure client, Hummingbird, Smart FTP,Cute FTP, Putty, Cygwin, MAXIMO IBM, SM7 for ticketing.

DB Utilities: SQL * Loader, Exp/Imp, Datapump Utilities, RMAN, Tkprof

Language: SQL, PL/SQL for Oracle, Shell programming (Unix - Korn, Bourne, Bash)

Web Technology: VB, VB.Net, ASP, ASP. Net, ADO. Net, HTML, XML, AJAX Toolkit, Silver lightApplication, WPF Application, MVC Application, WCF Service, WorkflowService, SharePoint, SOA ( Using SOAP and WSDL)

Scripting language: HTML, XML, VB Script, VB.Net Script, Java Script, C# Script

Shell script: Shell Script (Bourne shell & Korn Shell)

Enterprise: J2EE, JSP, JDBC, ODBC

Technologies: Oracle DBA, Oracle Apps DBA, Postgresql DBA

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Database Administrator

Role and Responsibilities:

• Has strong experience on Implementation of golden gate replication for new tables, support, patching.
• Architect Golden Gate data replication processes.
• Developed Golden Gate system macros, analyze applications for GG suitability.
• Strong in Identifying data synchronization issues, Remediate Data synchronization issues, Golden Gate replication solutions design.
• Strong experience in Oracle RAC 11g and onwards.
• Good working experience RMAN configuration, Job maintenance and backup & recovery
• Hands-on experience on installation and configuration and trouble shooting of Oracle products and patches, including RAC, ASM, Clusterware, Data Guard, OID, Grid/Cloud Control.
• Strong knowledge of OEM 11g/12C grid monitoring configuration.

Sr. Oracle Database Administrator

Role and Responsibilities:

• Installation and configuration of Oracle 11g Database and Client.
• Installed, Configuration and deployment of Oracle 11g database and Real Application Clusters (RAC) on different nodes with ASM (Automatic Storage Management) on Linux RHEL & HP-UX Itanium. Installed and administered Real Application Cluster (10g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Upgraded 3-Node 10gR2 RAC database on ASM to 11gR1 RAC using rolling upgrade whereas 10gR2 RAC database will need outage and the total downtime has been minimized by using Logical Standby Database in the upgrade process.
• Migrating the database from Solaris platform to Linux from Non RAC to RAC and non ASM to ASM.
• Monitored and evaluated database usage in oracle and POSTGRESQL DB's to determine present and future database requirements.
• Upgraded databases from POSTGRESQL 8.4 to POSTGRESQL 9.1,9.2,9.3 versions.
• Worked on various versions of MongoDB like 2.2,2.4,2.6,3.0.
• Experience in configuring, managing MongoDB replica sets and sharing.
• Installation and setting up of MongoDB, mongos (Process), config-server (mongo instances), mongo-database (MongoDB instances) with 3 nodes - 1 primary and 2 replica
• Has implemented best practices and considerations for the operations of MongoDB instances and deployments.
• Has managed High Availability and Disaster Recovery for Postgresql DB's.
• Has experience in Installing and Configuring Oracle Virtual Directory 11g R1.
• Has experience in Integrating Oracle Internet Directory, Oracle Unified Directory and Microsoft Active Directory.
• Manage LDAP, Database, Local-Store, Join View and Custom Adapters.
• Can Integrate Oracle Virtual Directory and Enterprise User Security.
• Knowledge and experience in Open Source solutions to include vetting patches, applying patches to the database and the open source tools, libraries, and daemons
• Supported technical team members in installation, configuration and maintenance of Postgresql Databases.
• Expert in Oracle performance tuning, SQL tuning and monitoring for high availability and having performance tuning experience, specializing in instance tuning, Oracle RAC tuning and SQL optimization.
• Expert in the functional and technical aspects of Oracle E-Business Suite/ Applications 9i, 10g and 11i deployment Requirements, Coding/Development, Customizations, Testing, and Functional User Training. Played team role in application set-ups, implementation, conversions, interface development, testing and end-user training.
• Expert in Oracle performance tuning, SQL tuning and monitoring for high availability and having performance tuning experience, specializing in instance tuning and sql optimization.
• Has ability to understand the functioning of Library Cache / Waits / Latches in Oracle Databases for troubleshooting Locks / Performance in Oracle DB.
• Has analyzed Ebiz Suite application Concurrent Requests / Database Jobs and create/suggest proper SQL Profile / Index for Performance gain.
• Has knowledge in SQL & PL/SQL tuning - Analyzing Codes / Indexes / Joins / Hints / Parallelism.
• Hands on experience in implementing 11g Oracle Golden Gate.
• Setting up schedule RMAN Backup using CRONTAB.
• Database Cloning for Physical Standby server.
• Started working on new 12C databases and its new features by involving in POC’s.
• Using Flashback for Point-in-time Recovery.
• Experience in Toad (Tool for Oracle Application Developers) for database maintenance tasks.
• Memory management to increase performance of database.
• Communicating with Oracle to get the necessary patches required to fix up the database changes needed using TAR support.
• Working for RDA Reporting for TAR Support.
• Database upgrade from 10.2.0.3 & 11.1.0.6 to 11.1.0.7
• Applied CPU patches using OPatch utility for database patch maintenance.
• Wrote shell scripts for taking backup using Export/Import and Data pump Utilities.
• Worked on UNIX Shell Scripts, PL/SQL Stored Procedures, Functions and Triggers.
• Wrote Different Shell Scripts for Data Refresh for Development environment.
• Data models into Physical Structure.
• Creating and Managing Users, Roles and Privileges.
• Tuning SQL statements using EXPLAIN PLAN.
• Monitoring Alert log files and other process of the Databases.
• Database Administration of Large size database (5 TB).
• Responsible for data integrity and concurrent data, locks and deadlocks.
• Providing 24 * 7 productions supports for different environment

Environment: Oracle 11g/10g, 12c, Red Hat Linux 4/5, HP-UX Itanium 11.31,Sun Sloaris,AIX, GoldenGate, RAC, Data Guard, RMAN, Exp/Imp, Data pump, Putty.

Oracle Database Administrator

Role and Responsibilities:

• Installation and configuration of Oracle Database Software 10g, Creation and configuration of database.
• Involved in the project of implementing and configuring Real Application Clusters (RAC) on Oracle 10g Automatic Storage Management (ASM).
• Strong experience in OEM (Oracle Enterprise Manager), Oracle Data Guard, SQL* Net, SQL Loader and SQL*PLUS, STATSPACK, Explain Plan and TOAD.
• Has Managed Postgresql Databases of various versions.
• Configured backups and perfomed recoveries as needed like PITR in Postgresql databases.
• Experience in reading and editing the configuration file settings for PostgreSQL and other UNIX/Linux related programs.
• Can utilize internal Postgres tools to diagnose and possibly report potential/ongoing database issues (pg stat, pg locks, etc.).
• Implemented Fast Start Failover in Dataguard to maitain High Aavailability.
• Perfomed data collection at the server level by using OSWatcher Black Box to capture operating system metrics that way performance of the server has been monitored and adjusted and for trouble shooting crs / cssd related logs.
• Used Flashback for the Point In Time Recovery (PITR).
• Installation of 12c OEM and customize it to our needs.
• Wrote shell script to perform hot backup and schedule it with crontab.
• Use Export/Import and Datapump utilities for full/partial backup.
• Replication and extracting data and appling on production using Golden gate.
• Also wrote a shell script for taking backup using Export/Import.
• Upgrading database from Oracle version 9i to 10g and migration of data.
• Communicating with Oracle to get the necessary patches required to fix up the database changes needed using TAR support and coordinating the patches and implementing the necessary changes.
• Optimize SQL queries for better performance.
• Carried out Optimizing performance and Query tuning using Statspack, Tkprof
• Use Explain Plan for monitoring the query execution.
• Configure and administer Oracle Goldengate for schema/database migration and Disaster Recovery solution.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Performance tuning by doing partitions.
• Responding and working with Application Development teams.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.

Environment: Oracle 10g/9i, 12c, SUN Solaris 10, GoldenGate, Data Guard, RMAN, Exp/Imp, Datapump, Putty

Oracle Database Administrator

Roles and Responsibilities:

• Organizing Oracle Database operations, installation, creation, configuration of Databases
• Laying out database tables and database schema design, startup and shutdown of Databases Setting Pfile parameters, maintaining Data Files, Control Files, and Redo Log Files.
• Managing Tablespaces, segments, extents, materialize view and indexes.
• Create Users and Roles with suitable privileges.
• Experience in implement a variety of solutions for improving the availability, accessibility, performance, and integration of critical data across the enterprise with GoldenGate.
• Monitored and tuned Rollback segment, temporary tablespace, redo log buffer, sort area size, Flash Recovery area.
• Have worked on backup/recovery, performance tuning.
• Managing Oracle Net Configuration, monitoring Alert Log Files, Listener Log, Redo Log status, rollback segments and trace files for the database.
• Monitored Alert Log Report and system Error Logs.
• Create User and Roles and grant appropriate roles, privilege and profile.
• Create User Profile and assign to appropriate user.
• Administered Hot/Cold Backups on a regular basis.
• Design and implement database backups using RMAN and perform recovery when needed.
• Carrying out Export/Import and Datapump operations on Oracle Database
• Team member of Backup and Recovery Group (consist of 4 DBAs) responsible for Disaster recovery and implementing Physical Standby Database using Dataguard.
• Refreshing development/test database from production using Export/Import. This is done so that the latest data is available in the development/test database.
• Data Refresh from test Environment to Production Environment.
• Up gradation, Migration and Installation of different patches.
• Wrote UNIX shell script for taking daily backup using crontab.
• Monitoring of the queries with high response time and high disk reads per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF, Auto trace.
• Use Partitioning features for better performance.
• Resolve performance issues by using AWR and ADDM.
• Wrote a shell script to load a data from a flat file to database using SQL * Loader.
• Supported test and development environments to ensure smooth transition of applications into production.
• Served as Oracle DBA in a 24x7 Production environment managing several Database instances.

Environment: Oracle 9i/10g, Sun Solaris 8, Import/Export, Datapump, OEM, RMAN, Dataguard, Statspack, Tkprof, Hummingbird.

Oracle Database Administrator

Role and Responsibilities:

• Creating database files and Tablespaces based.
• Create users & roles and give appropriate privileges and roles.
• Create tables, indexes, views and materialize view.
• Laying out tables and define constrains regarding to business application.
• Analyzing STATSPACK Report at regular intervals to ensure good database performance.
• Tuning the Databases for optimization using STATSPACK and Explain Plans, Estimating Table & Index Size.
• Create Indexes by analyzing and rebuilding of Indexes for better performance.
• Actively worked on SQL and Physical database tuning resolving fragmentation and disk contention.
• Explicitly use of Explain plan and Tkprof Utility for better performance.
• Use Partitioning feature of Oracle 9i to improve performance.
• Actively participated in Application Tuning, which includes SQL Tuning, Database design tuning and tuning at Instance level.
• Implemented physical database design after sizing tables and indexes and locally managed Tablespaces were used which track all extent information in the tablespace itself. This results in improved performance.
• Data loading from the flat file Using SQL * Loader.
• Upgraded and patched Oracle software, Setup brand new machines including Oracle software installation.
• Migrated and upgraded databases from version 8i to 9i.
• Upgrading from 9.2.0.1 to 9.2.0.6 and 9.2.0.6 to 9.2.0.8 Database and also apply critical patches update (CPU) for latest versions.
• Use RMAN Utilities for taking hot backup.
• Implemented database refresh with the hot backup using DUPLICATE or full export.
• Used EXPORT/IMPORT to do table level and full database defragmentation.
• Developed or modified some Oracle backup and recovery scripts.
• Cloning from production instance to test & development instances.
• Doing the regular activities like monitoring the alert logs. Redo log status, listener. Log, v$session and checking the space for normal segments, rollback segments.
• Applied interim patches using OPatch utility on RAC RDBMS HOME
• Doing the regular activities like monitoring the alert logs. Redo log status, listener. Log, v$session and checking the space for normal segments, rollback segments.
• Taking daily On-line backups, weekly off-line backups and frequent exports.
• Supporting the development team and supporting production Environment.

Environment: Oracle 9i, HP-UX 11.20, Import/Export, RMAN, SQL * Loader.

Oracle Database Administrator

Role & Responsibilities:

• Design and creation of client Database instances per requirements including production and test environments.
• Organizing Oracle Database operations, installation, creation, and configuration of Databases.
• Configuration of Oracle Instance with SGA, PGA and Background Processes.
• Managing Logical objects like Tablespaces, segments, and extents.
• Maintaining indexes and performing management of Undo Data.
• Estimating table sizes, table spaces.
• Create Users and Roles with appropriate privileges and roles.
• Also define Database level authentication and OS level authentication using password file.
• Create user profiles and assign to appropriate user.
• Performing regular Backups and Recovery as per Organization Strategy to support the database and Troubleshooting with restoring and recovery (Instance, media).
• Taking the backup of the databases using RMAN, Logical, Cold and Hot Backup procedures.
• Created new user accounts, profiles, roles and assigned them to different users and enabled auditing to monitor system privileges and roles granted.
• Setting up of RMAN on the database to perform necessary back-up.
• Integrated the Backup Status Reporting for all the databases using shell script in Korn Shells.
• Extensive use of Export and Import for full database backup, schema level backup, Table level backup and metadata.
• SQL query optimizing using CBO (cost base optimizer), bind variable, Explain Plan, TKPROF, stats pack and instance as per company’s requirement for high tuning.
• Performance tuning for Oracle Day-to-day maintenance and management of the several different databases in development, test, and production environments.
• Reorganizing the database at regular intervals to remove fragmentation in the database using export and import utilities.
• Create tables, views, and materialize views, private and public synonyms.
• Working with management system like DBMS and RDBMS with specific functions, database tools and utilities.
• Managed and resolved design issues during development.
• Load Data from flat file to the Database using SQL * Loader.
• Also maintain 24 X 7 uptime for the database while carrying out the activities.

Environment: Oracle 9i, Sun, TOAD.