Experience Summary

• 8 years of progressive experience in the field of Information Technology as an Oracle DBA in Oracle Installation, Database configuration, Database Tuning, SQL Tuning, Backup and Recovery, Database Migrations, Standby database setup, and troubleshooting of issues in various Oracle Products/versions working on several OS platforms and 7.3 years of proven experience as SQL and PL/SQL developer and 3 years of Experience in IBM Big Insights 2.1 Big Data and IBM Netezza DBA
• Experience in Database Design, Database Development, Database Administration and Software Development.
• Managing Database Structures, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges and Database Auditing.
• Experience in Installation, Configuration, and Migration Oracle databases.
• Experience in Data Loading using SQL Loader.
• Experience in refreshing data from Production to Development databases and Reorganization of Databases using Export/Import. Experience in Data Pump.
• Expert experience in Monitoring Oracle Databases using Oracle Enterprise Manager, and TOAD
• Experience in Backup Recovery with RMAN and without RMAN
• Experience with Dataguard environment, Physical Standby Databases and Logical Standby Databases.
• Created and configured a Physical Standby database to meet Disaster Recovery.
• Experience in troubleshooting and Problem Solving.
• Experience in Database design including creations, modification, and deletions of table spaces, data-files, rollback segments and schema's, Create Schema Tables, Indexes, views, sequences, synonyms, roles, and users .
• Hands on Unix Shell Scripting for automating the DBA tasks.
• Effective and efficient team player with excellent interpersonal skills, analytical problem solving skills.
• Strong experience in configuration of RMAN, Planning and scheduling Backups using CRONTAB and CONTROL M.
• Excellent experience with Oracle Real Application Cluster 11gR2 and 10gR2 with ASM on IBM AIX 6.1/RHEL-5,6, Oracle 9i on heterogeneous operating systems including Windows and Red Hat Linux.
• On call 24x7 Production Support Worked beyond regular hours.
• Experience in using oracle features - FLASHBACK RECOVERY, ADDM, ASSM, ASMM and 10g/11g Grid Monitoring, SQL Tuning advisor.
• Excellent experience in Performance tuning of oracle databases using AWR, ADDM, STATSPACK, and tuning of SQL scripts using SQL Trace, TKProf, Explain Plan, and Hints.
• Experienced in upgrading Oracle Databases from 9i to 10g and from 10g to 11g.

Technical Skills

Assignments

Confidential

Role: Oracle DBA/IBM Netezza Admin and IBM Big data Big insights 2.1 Admin/Developer

Responsibilities

• Administered ORACLE 11gR2 RAC and standalone databases on IBM AIX 6.1.
• Monitoring productions servers through Oracle Enterprise Manager OEM, also to manage databases and diagnosing database problems.
• Performed DBA daily activities including user management creating users, synonyms, privileges, roles, quotas, tables, indexes, sequences etc. , space management tablespace, rollback segment , and monitoring.
• Successfully implemented oracle 11gR2 Physical Standby database using Oracle Data Guard in High availability configuration.
• Responsible for upgrade migrating databases from 10g to 11g.
• Setting up and managing RMAN, Hot and Cold Backups, Exports
• Refresh the test and development databases from the source production databases on a regular basis using datapump utility.
• Involved in coordinating and helping development team in designing there code and migration there code changes from nonproduction environment to production environment.
• Involved in Performance Tuning, proactive monitoring, bottleneck elimination.
• Maintained production databases of around 640TB and implemented changes in production through Enterprise Change management.
• Diagnosed Oracle bugs by coordinating with Oracle support to resolve them in timely manner.
• Applied patches to fix identified bugs and make Application environment up to date.
• Created, scheduled database maintenance tasks, such as tables/indexes analysis, index rebuild, materialized views refresh, database exports and disk rebalances.
• Managed CRONTAB and universe, rescheduling the failed jobs due to errors , changing timings for the scripts to run if the job fails and adding new jobs
• Dealing with database security and auditing by enabling the auditing as per the business requirements and pulling auditing information whenever required.
• Monitoring table space usage, adding disks to ASM when required and performing disk group rebalance.
• Involved in configuring services for load balancing and for failovers.
• Involved in creating Materialized views to perform refresh in OLTP database and OLAP databases.

Hadoop Responsibilities

• Using IBM Info sphere Big Insights tool for Maintenance of the following services and nodes
• Maintenance of the following nodes and services:
• Name Node, secondary Name Node and 8 Data Nodes
• Map/Reduce Functions
• HDFS
• JAQL server
• HBASE
• HIVE
• BIGSQL Internal to IBM big insights and an alternative to HIVE
• Using Hive Hive Query languages.
• Using IBM Big SQL in OLAP environment.
• Using Sqoop tool to import and export data from Hadoop File system HDFS .
• Importing data from Oracle databases and IBM Netezza databases to HDFS using sqoop.
• Using Database import IBM big insights tool to import and export data from Hadoop File system.
• Developed java map and reduce functions and deploying the application using IBM BigInsights Tool
• Doing Proof of concepts on Informatica Power Exchange for Hadoop.

IBM Netezza database Responsibilities

• Identifying software versions, Monitoring system states, SystemErrors, logs
• Management of Netezza Database users, Groups, Group limits
• Management of Databases, usertables, StoredProcecudes, Clustered base tables
• Management of Distribution keys,
• Data skew,
• Generating Database statistics
• Groom tables
• Session management
• Netezza optimizer and query plans, Query status and history
• Netezza database backup and recovery-Incremental backups
• Backup History report
• Database statistics after restore,
• Restore tables
• Incremental restoration
• Installation of Netezza database drivers JDBC, ODBC, OLE DB database
• Data Loading using Netezza
• Fast Reader configuration for Netezza databases

Fast Reader Activities

• Fastreader Manager to manage the execution of high-performance data unload, transformation
• and high-speed load
• Configure source database settings
• Configuring Connect Direct/Indirect loads
• Configuring Direct Path data unload
• Export / unload from entire schema for owner
• Select table partitions, Select Table Columns, Specify additional filtering for extracted data in WHERE clause
• Runtime Settings Format Settings
• Destination Database Loader Settings.
• Generate FastReader configuration file unload.ini
• Run FastReader from FastReader Manager
• Remote FastReader Configuration File Management
• Troubleshooting the connections

Environment: IBM AIX 6.1 TL5, 7.1, Sun Solaris, Linux, SUN Solaris, Java 1.4, 1.5

Oracle 10g database, Oracle Application Server 10.1.2, 10.1.3, Eclipse, TOAD, JDeveloper,

SQL developer

Confidential

Oracle DBA

Responsibilities

• Build support 10g 11gR2 standalone databases on different OS platforms AIX/Linux/Sun Solaris servers and different file systems raw, ASM, ocfs2 .
• Experience in 24x7 on call production support for mission critical production systems.
• Followed JPMCInsurance change management policies to implement critical changes in DEV/SIT/UAT environments validated them and carried them over to production systems.
• Configured and managed physical standby database using data guard for disaster recovery on a different production databases.
• Expert in query tuning, Explain plan, Tkprof, Wait Events, sql cost, locks and long operations.
• Experience in monitoring Memory/SGA Components, as per the database issues changing the SGA components as per Oracle Standards.
• Implemented Audit Security standards that are required for the banking systems to stay in compliance with federal policies. Implemented Guardium tool to audit the user access.
• Monitored OEM alerts, space alerts, alert log errors and performance issues on the production databases. Assisted application team in finding the hot blocks and tuning code so as not hit the hot blocks, monitored blocking users and dead locks.
• Configured database backups using Control-M/ Autosys and Net Backup, tested and Scheduled database backups using RMAN and data pump/export backups to disks. Worked closely with the netbackup team to setup the tape backups.
• Installed, configured and migrated OEM Agents on multiple servers to 11g and implemented standard monitoring and alerting procedures.
• Developed UNIX shell scripts SQL scripts to perform the daily Database OS monitoring, Server validation health check.
• Assisted application development team in query tuning optimization, partitioning, explain plan recommendations.
• Documented various implementation procedures for future needs and shared within the team.

Environment: Sun OS 8.0/9.0, AIX 5.3/6.1, Linux, Windows NT/2000/2003, Oracle 9i/10g/11g, SQL, PL/SQL, UNIX, SQL Plus, Putty, OEM, Oracle Universal Installer, Expdp/Impdp, RMAN, Data Guard, SQL Loader

Confidential

Oracle Database Administrator

Tata Teleservices is leading Indian Telecom Company having a large user base of potential customers. All the Database services across the company is being served by the single Data centre located at Hyderabad, which hosts about 100 Production Database instances serving the customers across the country. To minimize the loss of mission critical data, DR site is set up at Delhi which has copies of major production databases kept in sync with production databases using standard DR replication methods.

Projects Handled

Confidential

Electronic voucher Distribution: - Application used to Re-charge the pre-paid Vouchers online

Responsibilities

• 24 7 production Support for mission critical production systems
• Installation of Oracle 8i/9i/10g and database creation
• Installation of 10g Application servers and deployment of the applications
• Upgrading/migrating the databases from lower version to higher versions.
• Implementing Security features as specified by the Client's Security policy.
• Monitoring space, wait events, locks and long operations running on the database
• Monitoring the alert log for the database performance and resolving the performance issues.
• Partitioning big tables and Indexes for optimal performance
• Archiving the data from the tables and backing up the archived data for the Business requirement
• Generating statspack reports on regular basis to identify the database performance at peak load
• Implemented scripts to monitor and get information on free space, alert log errors
• Design developed PL/SQL Stored Procedures Database Triggers to Implement Business rules Security.
• Reorganizing the database objects by archiving the data and moving the tables within the tablespace, rebuilding the indexes.
• Managing Users, Monitoring sessions related to users specific, Sessions related to application specific for tuning the performance of the database.
• Configuring various cronjobs within the Oracle Server.
• Managing batch processes running against the database, Cron jobs placed within the oracle server.
• Design developed table structures, PL/SQL Stored Procedures Database Triggers to Implement Business rules Security.
• Reorganizing the database objects by archiving the data and moving the tables within the tablespace, rebuilding the indexes.
• Migrating the data from one database to the other using Export/Import Utility.
• Archiving the data from the tables and backing up the archived data for the Business requirement.
• Scripting the Backup of Development and End-To-End Environment using RMAN utility on to Disk / Tape.
• Migrating the databases from one server to the other using RMAN utility.
• Duplicating the databases using RMAN utility.
• Trouble shooting 24 7 production environment issues