SUMMARY:

• Oracle Certified Database Administrator with Informatica/Talend/Netezza experience spanning over 8 years in planning, analyzing, designing, coding, testing and implementing database structures with hands on exposure to database administration, PL/SQL Development, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Proficient in planning, scheduling and implementing database changes while ensuring no impact to users including database migration across the different OS versions
• Proficient in troubleshooting issues with discovering hosts and adept atADDM installation and configuration down to the host and network device level with familiarity with TPL language.
• Strong in using Oracle Apps workflow builder tool. Experience in customizing Account Generator Workflows,
• Also administer various Workflow processes and troubleshoot the error workflows.
• Extensive knowledge in the installation and administration of Oracle E - Business in production environments.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g & 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems
• Working experience with Very-Large databases (VLDB) up to 120 terabytes, data migration against Oracle
• Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g and 11g in HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g
• 24*7 production database support with Support to developers & end-users
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 10g RAC environment
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD
• Well versed in performing SQL Queries/ Application and Database performance monitoring/ tuning using various tools like ADDM, AWR
• Experience in Identifying performance bottlenecks on high volume transaction systems, Analyzing SQL statements, reorganize database objects and design indexes to improve response of queries, Tuning heavy data loads, Monitoring and Performance tuning
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup
• Experienced in using Oracle's Transportable Table space (TTS) feature allows users to quickly move a user Table space across Oracle databases
• Database replication using snapshots, materialized views and advanced replication methods
• Experience in applying security patches to the databases
• Effective troubleshooting of database and Performance problems.
• Good experience in Data Migration using export/import
• Management of Objects, Schemas, Partitioning the tables and Indexes. Knowledge of Oracle Support Process for Technical requests using Meta-link and other support procedures
• Expertise in developing SQL and PL/SQL codes through various procedures, functions and in Oracle packages to implement the business logics of database.
• Migrated single instance databases to multimode 10g RAC, 11g RAC environment for high availability and load balancing.
• Hands-on experience of tuning database queries and database managing and monitoring using Oracle Enterprise Manager (OEM).
• Worked on an Oracle Apps DBA team focused on highly advanced proactive maintenance and support and sophisticated database systems highlighting high availability and world class support
• Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i/8i/7X, Oracle 10g (RAC, Data Guard & Streams, and (Golden Gate).

Operating Systems: HP-UX 10.x, 11.x, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP

Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, Bash and Perl Scripting.

Software sApplications& Tools: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, SQL*PLUS, SQL*LOADER, EXP, IMP, Oracle Apps R12, Data Pump (expdp, impdp), Fast clone/Fast Reader, TOAD, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM, Talend 5.6.1, Talend MDM, SVN, Visual SVN Server.

Web Tools: HTML.

PROFESSIONAL EXPERIENCE:

Confidential, Scottsdale, Arizona

Oracle DBA/Talend Administrator

Responsibilities:

• Security configuration for users, projects, roles (SVN, TAC, working with security group)
• Keep current with emerging software enhancements, security patches and bug fixes
• Monitor application server performance and respond appropriately
• Modifies, installs, and prepares technical documentation for system software applications
• Monitors systems capacity and performance, plans and executes disaster recovery procedures, and provides Tier 2 technical support.
• Document the Installation, Deployment, administration and operational processesofTalend MDM Platform (production, Pre-Prod, test30, test 90 and development) environments for ETL project
• Best practices for Application Server maintenance
• Document Security configuration - SVN, TAC, Job Server, MDM Server
• Document disaster recovery procedures and technical support
• Work with the development staff to determine project requirements for dev/test/pre-prod/production environmentsLinux
• Experience to work at the highest technical level of all phases of applications server activities

Confidential, Louisville, Kentucky

Oracle DBA /Informatica ETL Consultant

Responsibilities:

• Create tables, table spaces, and data objects, setting privileges, indexes, user & password, management, Security administration.
• Creating and installing databases according to clients request for business standard/Requirements
• Data modeling using a variety of popular tools like the Erwin Data Modeler
• Database and table design and implementation for data warehouse and related ETL processes.
• ETL architecture and full software life cycle development across numerous software and hardware platforms in a variety of industries as well as SAS ETL developer with expertise in design and development of Extract, Transform and Load processes for data
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Strong experience in Data Warehousing and ETL using Informatica Power Center 9.1.0 as well as the new Data Integration Hub(DIH) installation, support and maintenance.

Environment: Oracle 11g, Sun Solaris, Informatica Power Center 9.1.0 to 9.6.0, SAS 9.1, 9.2 SAS B1 Suite, SAS Management Console, SAS/SQL, SAS/CONNECT, SQL Server 2005.

Confidential, Harrison, NJ

Oracle Database Administrator

Responsibilities:

• Installing Oracle Database Software 10g/11g also cluster management and verifying cluster process to ensure smooth operations.
• Analyzing, designing, coding, testing and implementation of database structures such as Oracle 10g Database upgraded to Oracle 11g Database
• Carrying out EXPORT and IMPORT operations on Oracle Database, and monitoring the performance of the database using of OEM (Oracle Enterprise Manager),
• Monitoring and maintaining 2/3 node RAC database. Providing support to the development team and handling release schedules. Data protection and availability with tools like Data Guard and Grid Control with a more flexible replication mechanism using Golden Gate.
• Creating clone databases on same node and also on different server nodes using custom shell script with hot and cold backups of source database.
• Using SQL Loader extensively to extract data from flat files and loading into the new application.
• Performed SQL Queries/ Application and Database performance monitoring and tuning using various tools like ADDM, AWR.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab scheduler

Environment: Oracle 10g/11g, Sun Solaris 5.10, Linux, Windows XP professional, Oracle Enterprise Manager, Quest Toad, RMAN, Putty, PL/SQL developer. SQL*Loader, SQL*Plus, Oracle Developer.

Oracle Database Administrator

Confidential, NJ

Responsibilities:

• Responsible for Database Growth and Space management, capacity planning, table partitioning; distributing the tables, redo logs, archived redo logs and rollback segments on different disks to optimize data retrieval.
• Involved in logical backup using and full/ partial export/import and Data Pump, Backup and recovery.
• Completing Hot, Cold and Logical backups also performed backup validations using RMAN.
• Excellent experience of SQL and PL/SQL Developer and Unix Shell scripting also maintaining UNIX scripts for monitoring and backup.
• Maintaining 24 X 7uptime for the database while carrying out the activities.
• Performing tuning of PL/SQL Developer and SQL.
• Monitoring System Resources, understanding and troubleshooting Database issues in Production Environment
• Experience on Net-back up client with RMAN to automate the backups to tape as per company standards.
• Creating the database, tables, table spaces, and data objects, setting privileges, indexes, user names & passwords, management, Security administration.
• Upgraded Oracle binaries in the development environment and production environment.
• Creating Users and Roles with appropriate privileges and roles.
• Performing regular Backups and Recovery as per Organization Strategy to support the database and Trouble shooting with restoring and recovery (Instance, media).

Environment: Oracle 10g/11g, Sun Solaris 5.10, Linux, Windows XP professional, Oracle Enterprise Manager, Quest Toad, RMAN, Putty, PL/SQL developer. SQL*Loader, SQL*Plus, Oracle Developer

Confidential

Database Administrator

Responsibilities:

• Responsible for tuning database queries and database managing and monitoring using Oracle Enterprise Manager (OEM)
• Upgraded Oracle Database to monitored application related jobs/ data replication activities
• Implemented and maintained the database design also created database objects (tables, indexes).
• Used PL/ SQL performance tuning.
• Write database procedures, functions and triggers also assisted developers with database activities

Environment: Oracle 9i/10g, Sun Solaris 5.10, Linux, Windows XP Professional, Oracle Enterprise Manager, Quest Toad, RMAN, Putty, PL/SQL developer, SAS/BASE, SAS/SQL, SAS/MACROS, SAS/CONNECT, SQL Server 2005