Objective: To reach a Challenging Position where I can effectively contribute my Skills and experience for the growth of the Organization.

Experience Summary

• Over Eight Years of IT experience in Oracle DBA 8i/9i/10g/11g,Oracle 10g AS, Oracle Web logic Servers, Oracle Grid 10g/11g/12c,Oracle 10g/11g RAC, SQL Server 2005/2008 Administration, performance tuning, database backup and recovery, Oracle patch sets, Quarterly CPU Patches and programming.
• Obtains strong skills in the development of UNIX Shell scripting, SQL, PL/SQL procedures, functions, triggers and package programs. Expertise in the functionality of Oracle 10g and 11g Real Application Cluster RAC , 10g AS, SSO-OID integration with Windows AD, testing, and training.
• Specialized in tools such as OEM, TOAD, Erwin, DBCA, GoldenGate and Proficiency with utilities such as Export, Import, SQL Loader, Expdp, Impdp, RMAN and External Tables.
• Skilled in logical and physical database design. Experience in using Data Modeling tool Power Designer and Problem resolution tool Remedy Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Expertise in Oracle Installation, migration, Backup, Recovery, Systemdesigning, development, Performance Tuning, Monitoring, Net8 configuration and maintenance of Databases.
• Used the SRVCTL utility to manage, start, stop Oracle Database and services.CRS STAT to collect statistics of nodes and services running on Clustered Database. Installed Oracle 10g Application Server Fusion Middle tier and deployed the EAR and WAR files in OC4J Fusion Middle tier.
• Extensively used Table partitioning using various partitioning methods like Hash, List and Range Partitioning with local indexes. Experience in finding Performance bottlenecks using TATSPACK, UTLBSTAT, UTLESTAT, EXPLAIN PLAN, SQLTRACE, AWR, ADDM and TKPROFF.
• Involved in Relational and Dimensional Database Design for Warehouse Database and experience in Using ERWIN Tool for Logical and Physical Data models. Created logical and physical structures like Database tables, indices, views, table spaces, synonyms, sequences, indexes, constraints and Oracle Jobs.
• Experience in giving software Training. Experience in working independently and as a part of team. Extensive knowledge of multiple databases and RDBMS concepts. Well experienced in Database schema design and Normalization concepts.
• Strong interpersonal and excellent communication skills with the ability to adapt quickly to new and challenging environments, hunger to learn new skills. Provide on call support 24 7 365 for all the production Databases. Proficient in different flavors of UNIX and LINUX, which includes Solaris,HP-UX, Tru64, AIX, Red Hat, Mandrake, Slack ware.
• Experience with MySQL Workbench provides a visual console to easily administer MySQL environments and gain better visibility into databases. Developers and DBAs can use the visual tools for configuring servers, administering users, and viewing database health. .
• Experience with Sybase Databases for data management solution for fast, efficient performance in different environments and for specific uses

Technical Skills

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Performing all aspects of Oracle System Administration for development, test and production Environments.
• Participating in the design, creation, and maintenance of relational databases.
• Diagnosing and debugging complicated performance, connectivity, and security issues involving Critical applications.
• Performing UNIX administration required for Oracle setup system parameters, format drives, Performance monitoring of UNIX .
• Determining and implementing best practices for Oracle setup. Provide DBA support such as proactive performance tuning and monitoring, trouble-shooting,
• Back-up and recovery, partitioning, installations and configurations. Adhering to database security standards recommended by Oracle.
• Applying Quarterly security Patches CPU/PSU and applying Patch set and One-off Patches. Performance tuning for long running queries using STATSPACK, AWR reports, analyze, DBMS STATS,
• SQL trace, explain plan. Re-designing of tables into partitioning tables. Analyzing existing table structures and fine tuning if required.
• Extensively used Erwin forward engineering of the data models to create DDL scripts for the purpose of Generating metadata, keys, constraints, indexes of the existing database for the purpose of data analysis and mining.
• Installed and configured Oracle binaries in test, QA environments. Involved in construction of DR sites for all the Production environments.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design tablespaces, datafiles, extents, redo logs, archive logs and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage. Extensive experience in RMAN recovery testing, RAC and stand alone database.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster RAC Databases.
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
• Monitoring Day-Day Backups, Log's recovering them as per the requirement. Utilized LOG MINER Technology applied Application Database Transactions on other Databases.
• Successfully implemented Backup Recovery using RMAN which includes hot backups and Cold backups.
• Management of SQL Servers, databases, storage management for databases sizing from 25GB to 40GB.
• Responsible for General Database Administration and Performance. Data Migration from legacy to master tables using DTS-import and Export wizard.
• Trouble shooting Problems by using SQL server profiler.

Environment: SQL Server 2008/2005, Windows 2008 /2003 R2 ,Oracle 11g/10g/9i, Toad, Linux X86 64 3/4/5/6, Sun Solaris, HP UX, Oracle 11g/12c Grid, Oracle 10G R1 RAC, Oracle 10g R2 RAC, Oracle 11g R2 RAC, ASM, Data Guard, Exadata, Golden Gate , BMC Remedy Service Desk, VERITAS cluster, Auto Sys, Cron Schedule, Backup and recovery.

Confidential

Sr. Database Administrator: Hartford, CT

Responsibilities:

• Installation and configuration of Oracle 11g/10g/9i on Linux, HP UX, Sun Solaris and Windows.
• Installed and configured Oracle binaries in test, QA environments. Involved in construction of DR sites for all the Production environments.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design tablespaces, datafiles, extents, redo logs, archive logs and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Extensive experience in RMAN recovery testing, RAC and stand alone database.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster RAC Databases.
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
• Monitoring Day-Day Backups, Log's recovering them as per the requirement. Utilized LOG MINER Technology applied Application Database Transactions on other Databases.
• Successfully implemented Backup Recovery using RMAN which includes hot backups and Cold backups.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Provided 24x7 on call support for mission critical databases. Co-ordinate with Offshore and On-site team.
• Applying Quarterly security Patches CPU/PSU and applying Patch set and One-off Patches.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g/11g.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Writing and modifying shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
• Using MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. The SQL Editor provides color syntax highlighting, reuse of SQL snippets, and execution history of SQL.

Environment: Oracle 11g/10g/9i, Toad, Linux X86 64 3/4/5, Sun Solaris, HP UX, Oracle 9i/10g AS, Oracle Label Security, PROD deployments, Oracle 10g/11g Grid, Oracle 10G R1 RAC, Oracle 10g R2 RAC,Oracle 11g R2 RAC, ASM, Data Guard, Exadata, Golden Gate , BMC Remedy Service Desk, VERITAS cluster, Auto Sys, Cron Schedule, Backup and recovery.

Confidential

Oracle Database Administrator

• Installed, configured, migrated, upgraded and conducted troubleshooting of various Oracle products, including Oracle database servers and Oracle application servers. Installed and administered 4- node Oracle10g RAC architecture in Linux.
• Provided technical support for all application administrators and users. Applied critical patches to Oracle databases and application servers. Installed Oracle Cluster ware Software to set up 4-nodes in a production environment. Upgraded an Oracle 10g RAC Release 1 4-node set up to an Oracle 10g RAC Release 2 database and PROD releases.
• Implemented the changes to the production environments based on directions received from the development team in order to upgrade the applications from the development/test environment to the production environment. Applied the Quarterly CPU Oracle patches to the development, test and production databases and oracle application servers.
• Reviewed the application and database design documents developed by development team. Implemented and Monitored RMAN and export/import backups everyday in the production, test and development databases.
• Developed script for moving tables and/or indexes to move from one table space to another to manage the space in table space. Upgraded an Oracle 10g RAC Release 1 4-node set up to an Oracle 10g RAC Release 2 database. Implemented Oracle Label security by using the row level label security.
• Rebuilt a 2-node RAC databases due to a SAN crash and recovered the 4-node production database after the SAN recovered with latest RMAN backups. Designed, developed, and implemented database security management, backup/recovery strategy, monitoring methods, and performance tuning. Provided technical support for all application administrators and users. Applied critical patches to Oracle databases and application servers. Installed Oracle Cluster ware Software to set up 4-nodes in a production environment.
• Installed the Oracle APEX 4.0 in the LINUX 4.0 and windows standalone machine. Upgraded Oracle 10g R1 to Oracle 10g R2 in the RAC environment. Applied quarterly CPU patches to the DEV, TEST and PROD databases and Application Server. Upgraded the Oracle Application server from 10g R1 to 10g R2. Worked with oracle support if we have any application or database issues.
• Install and configure Oracle GoldenGate. Debugging GG issues such as abend Oracle Streams and Golden Gate for site to site replication. Proficiency using Oracle Golden Gate and CsScan utility.

Environment: Oracle 11g/10g/9i, Toad, Linux RHEL AS 3/4 Update 4, PVCS, Version Tracker, Oracle 9i/10g AS, Oracle 10g AS R2/R3 , XML-RPC, Oracle Label Security, PROD deployments, Oracle 10g Grid, Oracle 10G R1 RAC, Oracle 10g R2 RAC,Maven, OBIEE, Windows NT, Business Objects, Documentum, J2EE, OID, Apache, Portal, Power Builder, OC4J,Lotus Notes, Oracle APEX, Erwin, Oracle 11g R2 RAC, ASM.

Confidential

Role: Oracle DBA

• Created and maintained all databases required for development, testing, and production usage. Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. Provided technical support to application development teams.
• Created several procedures, functions, triggers, and packages to implement functionality in PL/SQL. Created database indexes, integrity constraints, and triggers. Participated in creating a database a model, and normalized and documented using Erwin. Migrated the database from Oracle 8i to Oracle 10g, and created backups by using RMAN. Created user table spaces, indexes, and database links. Conducted performance tuning, disk space monitoring, and file transferring using FTP.
• Database management include physical storage management such as data files, control files and redo log files in DEV and UAT environment. Good understanding of database cloning using either Oracle export utility or using cold backup.
• Performance Tuning for long running queries using STATSPACK, AWR reports, analyze, DBMS STATS, SQL trace, explain plan. Re-designing of tables into partitioning tables. Analyzing existing table structures and fine tuning if required.
• Implemented automatic database backup procedures on Windows platform using cold backup strategy as well as using Oracle Export utility. Daily monitoring of Oracle trace files for any Oracle errors, checking and resolving database locks.
• Providing for Sybase Databases data management and synchronization technologies for applications outside the data center

Environment: Oracle 8i/9i/10g, TOAD, Linux, Erwin, SQL Loader, PL/SQL, KSH Script, SQL Server 2000, WS FTP, Windows

Confidential

Role: Mid level Oracle DBA

Responsibilities:

• Understanding of high level requirements business functional , Subject area diagrams related to Next Generation System, Sales Decision Support, Pricing Revenue Opportunity Model, Event Satisfaction Survey.
• Developed shell scripts and Oracle PL/SQL procedures for generating .zip files and automatically populating data in to the tables as and when requested.
• Created several Procedures, Functions, Triggers and Packages to implement the functionality in PL/SQL. Created SQL Load Scripts to load data from flat files to ORACLE 10g.Created Indexes, Integrity constraints, Triggers on the database. Used EXPLAIN Plan, TKPROF, SQL Trace for tuning SQL Queries.
• Writing the Unix Scripts to automate the process to load the data from upstream systems to oracle. Enabling the cronjob to refresh by monthly, weekly snapshots. Writing the Perl scripts to load the data from upstream system to oracle. Creating the jobs and process new files to main frame system by using the Unix Shell Scripts.
• Walked through the Logical and physical Data Models of all source systems for data quality analysis. Extensively used Erwin forward engineering of the data models to create DDL scripts for the purpose of generating metadata, keys, constraints, indexes of the existing database for the purpose of data analysis and mining.
• HTML scripting, including the ability to run Oracle stored procedures from passing and returning parameters. Analyzed on database structure, space requirements, data growth, delta of Change and Generated database minimum requirements. Conducted meetings and reported projects status to Manager and Business Leads.

Environment: Oracle 8i/9i/10g, TOAD, HP UX, Erwin, SQL Loader, PL/SQL, KSH Script, Oracle XML, UNIX Shell Scripting, Teradata, Perl Scripting, Informatica 7.1

Confidential

Role: Oracle Programmer

Responsibilities:

CMA Customer Management Analytics : v Understanding of high level requirements business functional , Subject area diagrams related to Customer management, marketing, sales and forecasting. Involved in creating database model, normalizing and documenting using Erwin. v Wrote Fast Load scripts, SQL Queries to extract large volume data ETL from NCR Teradata Box. Created several Procedures, Functions, Triggers and Packages to implement the functionality in PL/SQL. v Created SQL Load Scripts to load data from flat files to ORACLE 9i.Created Indexes, Integrity constraints, Triggers on the database. Used EXPLAIN Plan, TKPROF, SQL Trace for tuning SQL Queries. Database involved minimum of 8 Gig of data in the smallest table and at least 30 mil rows in volume and maximum of 100 Gig of data in a table and at most 405 mil rows in volume for history of 24 months. v Creating the tables and loading the data by using SAS from Teradata to oracle and oracle to Teradata.Writing the Unix Scripts to automate the process to load the data from upstream systems to oracle. Enabling the cronjob to refresh by monthly, weekly snapshots. v Developed some reports by using the oracle reports 6i.Writing the Perl scripts to load the data from upstream system to oracle. Writing the Unix Scripts to automate the process to load the data from upstream systems to oracle. Enabling the cronjob to refresh by monthly, weekly snapshots. v Analyzed on database structure, space requirements, data growth, delta of Change and Generated database minimum requirements. Conducted meetings and reported projects status to Manager and Business Leads.

Environment: Oracle 9i, Teradata, DB2, Sun OS 5.8,LINUX, Query man 6.0, Erwin, Fast Load, KSH Script, SAS 9.1.0, Toad, SQL Loader, BTEQ, RMAN, ORACLE 9iRAC, Oracle XML, Oracle Tools.

Confidential

Role: Jr. Oracle DBA

Job Responsibilities:

• Understanding of high level requirements business functional , Subject area diagrams related to portfolio management, loans processing/monitoring, credit management, risk management and underwriting segments for decision making and reporting in the design of an integrated credit reporting system.
• Performed extensive data mining and analysis of metadata to test the integrity, consistency and appropriateness of the data to be brought into the centralized credit monitoring system from several heterogeneous source systems. Loans in Process, Risk Management, Commercial, Real Estate and Financial Analyzer systems .
• Creating and managing database objects such as tables, views, materialized views and indexes. Finding and re-validating invalid database objects using scripts. Involved in the design of tables, forms and reports. Extensively used Forms 5.0 used for designing Screens and Reports 3.0 for generating reports.
• Implemented business logic by PL/SQL Stored Procedures/Functions in the backend. Designer 2000 was used to business process modeling. Walked through the Logical and physical Data Models of all source systems for data quality analysis.
• Extensively used Erwin forward engineering of the data models to create DDL scripts for the purpose of generating metadata, keys, constraints, indexes of the existing database for the purpose of data analysis and mining.
• Extraction of Source systems tables 5 Oracle and 2 SQL servers and data into DQI environment for quality analysis and anomaly detection. Worked on data mining to alleviate data inconsistencies and data anomalies issues with validations of the keys, constraints, indexes and potential joins across schemas. Performed DBA activities includes creation of users table spaces, indexes, Creation of database Links, performance tuning, disk space monitoring and File transfers using FTP.

Environment: Oracle 9i 9.0.1 /8i 8.1.7.0.0 , Teradata, Windows2000, Erwin 3.5.2, TOAD, Data Quality Inspector 2.13,MS PowerPoint, Excel, SUN Solaris 2.7, PL/SQL Developer, Unix Shell Scripting, Ascential Data Stage 7.0, Linux.