• Total 8 years of IT Experience primarily in the area of Oracle Database Administration 11gR2, 10g, 9i, 8I, 8, 7.x on HP UNIX, AIX, LINUX and Windows NT operating systems.
• Proficient in using Oracle Tools SQL Loader, Srvctl, Export/Import , Oracle Enterprise Manager OEM , SQL Plus, SQL Server Enterprise Manager.
• Proficient in Data Replication using Materialized Views and Data Steams.
• Proficient with special focus on Oracle Database Administration and RAC installation, maintenance and administration.
• Install configure 10g Grid control manageability monitor for RAC Non-RAC databases
• Experience in performance tuning using Grid control, AWR
• Experienced with Dataguard 10.024 for creating standby databases.
• Implemented HA High availability for oracle Databases RAC, Data Guard
• Experience with Oracle 11g/10g/9i - Installation Configuration of Oracle databases on Linux and Windows
• Design and manage backup and recovery procedures using RMAN and Conventional Backup Hot/Cold , Recoveries, RMAN Scripting
• Expertise in Database Installations, Configuration, Monitoring, Maintenance, Patches, Data Migrations, Database Upgrades Database Security and Supporting 3 Terabyte Databases and DB Applications.
• Experience in PL/SQL Programming, PERL and Shell Scripting
• Hands experience in Grid Control/OEM, Data Pump, Export, Import, Scheduler, Jobs, UNIX CRON and SQL Loader utilities.
• Proficient in experience as of the Data Warehouse Architecture, Star Schema, and Lookup tables, Summary and Aggregate tables using Erwin.
• Possess good analytical, technical and interpersonal communication skills, good leadership abilities and strongly believe in teamwork.
• Ability to learn very quickly and apply new skills to existing problems.

Development Tools and Platforms:

Professional Experience:

Confidential

Sr. Oracle DBA

Confidential

Responsibilities:

• Worked on database capacity planning and physical and logical data modeling.
• Analyze business requirements to create and maintain logical data models. Create, tune, document and maintain physical databases and database applications.
• Implemented databases including installation, configuration, monitoring of the databases.
• Installed, configured DataGuard for creation of standby database.
• Installed configured Oracle 10g/11gR2 on various Centos 6.2 platforms.
• Involved in database designing, created Logical and Physical Models using Erwin.
• Schema migration from Dev to QA, STG and Production after successful testing.
• Fetched the expensive SQL from ADDM and perform query tuning for Performance Tuning.
• Cloned production database to the test environment using Recovery Manager RMAN .
• Involved in database Upgrade from 10.2.0.4 to 11 g in RAC environment node by node.
• Daily review Automated Workload Repository AWR and Automatic Database Diagnostics Monitor ADDM report for Performance Tuning.
• Performance tuning of the database, Stored procedures using AWR reports, Statspack reports, TKPROF, Explain Plans, HINTS, SQL Trace, Wait event statistics.
• Involved in installation and configuration of Real Application Clusters RAC running on 2 node clusters.
• Configure Monitoring databases and create new alerts and thresholds in OEM.
• Responsible for configuration and implementation of backup strategies using RMAN
• Monitored and tuned Rollback Segment, Temporary Table space, Redo Log Buffer, Sort Area Size, and Flash Recovery Area.
• Communicated 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.
• Implemented the Admin Functions, security planning, and creation of database, Physical Database configuration and Disk Space Layout planning.
• Carried out upgrade of Oracle Clusterware and Oracle RAC Database from 9i to 10g.
• Ongoing database administration tasks including tablespaces archiving, database reorganization, oracle patches, capacity management and data pump.
• Written PERL and Shell Scripts to automate business process.
• Managed database objects like table spaces, tables, indexes, views, synonyms.
• Created PL/SQL complex stored procedures for data extraction
• Handled database server tuning, application tuning, maintaining documentation, and capacity planning and database security.
• Installed, migrated, supported Customer Databases onsite and remotely.
• Served as a primary and secondary support contact as part of a 24x7 rotational schedule.

Environment: Oracle 11gR2/10g, RAC, AWR, ADDM, Dataguard, VERITAS Volume manager, RMAN, OEM, Centos 6.2, PERL Shell scripts, HP-Unix.

Confidential

Sr. Oracle DBA Application Production / Data Analyst

Responsibilities:

• Database Installation, silent Installation and embedding oracle base software into the product on multiple platforms.
• Installed, configured Oracle Real Application Clusters RAC on ASM Clusterware, Configured and supported Dataguard.
• Designed and implemented the backup procedure and recovery of databases using RMAN. Tested and successfully recovered databases on various critical scenarios data files corruption, object lost, system errors and human errors
• Database Design, Schema Design, Performance Monitoring, Tuning.
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98 of the time.
• Installed, migrated, supported Customer Databases onsite and remotely.
• Automated database administration/data management since the product is a packaged product for a 24x7 production support of database with features like partitioning with PL/SQL calls to collect stats, Index maintenance Database replication.
• Installation Configuration of Oracle RAC, 10g/11g - databases on Linux and Windows platforms. Implement the Admin Functions, security planning, and creation of database, Physical Database configuration and Disk Space Layout planning.
• Responsible for database monitoring and maintenance Grid control and custom monitoring tool
• Responsible for apply oracle patches evaluate, QA, prepare documents on install guide and test cases through control change board.
• Work with oracle SR for internal errors and follow up for quick fixes, other vendors on third party product on escalation.
• Using Toad compare the AWR report for proactive database activity.
• Configure and manage the ASM disk spaces, providing clear and best methods to handle space issues in ASM.
• Configure and manage oracle 10G Data guard and physical standby.
• Manage and troubleshoot standby and DG in RAC environments.
• Recovered QA databases to point in-time from various critical scenarios using flash back transaction guarantee check point avoid backup and restore
• Used PERL and Shell scripts to automate business process.
• Troubleshoot and fix the golden gate EXTRACT and REPLICAT issues.
• Analyzing the SQL queries and recommending the right usage and identifying the execution plans.
• Configure Monitoring databases and create new alerts and thresholds in OEM.
• Work closely with development and application team to provide constant consistent support on database side.
• Administer, maintain, develop and implement policies and procedures for Managing DB Security and alert log entries.
• Resolve database performance issues, database capacity issues, and distributed data issues.

Environment: Oracle 11g, 10g RAC, 9i, Data guard, RMAN, Oracle Golden Gate, Red Hat Linux AS 4, PERL UNIX scripts, PL/SQL, ASM, Partitioning, Grid Control/OEM, Data Guard, RMAN, Shell Scripting.

Confidential

Oracle DBA Production Application

Qwest Communications International, Inc. is a large telecommunications carrier. Qwest provides local service in 14 western U.S. states. Qwest provides voice, backbone data services, and digital television. It operates in three segments: Wireline Services, Wireless Services, and Other Services. The Wireline Services segment provides local voice, long distance voice, and data and Internet DSL services to consumers, businesses, and wholesale customers, as well as access services to wholesale customers.

Responsibilities:

• Experienced with RAC database design and implementation.
• Configured and tuned Oracle Listeners in a multi-database environment using Oracle Net Net Configuration Assistant and oracle files
• Maintained users, roles privileges in Oracle database for development team users.
• Improved the performance of the existing system by re-sizing the Database objects such as Tables, Indexes and Rollback segments to performance at optimal levels.
• Created disaster recovery procedures and performed Backup/recovery.
• Perform capacity planning and space management.
• Performed recovery from instance and media failures.
• Implementing backup and recovery procedures including logical backup RMAN, EXPORT/IMPORT , Physical backup Online/Off-line and integrating the backup procedures.
• Provide support to development teams for the conversion like creating database objects, Schemas creation, tables, indexes, constraints etc.
• Administered Oracle 2- 3 node Real Application cluster RAC systems.
• Developing and Reviewing PL/SQL stored procedures.
• Worked on Storage Area Network SAN
• Provided Oracle installation support, database maintenance, backup using RMAN, version control for source code
• Have been a Primary DBA and provided 24x7 on call Production support to trouble shoot complex and sometimes cross-platform issues.
• Created physical standby database to use as reporting database and used as failover database.
• Supported oracle applications financial databases and different financial applications.
• Managed daily, weekly and Monthly backups.
• Assisted Project Manager in managing project and reporting status on activities on a daily basis.

Environment: Oracle 10gRAC, Red hat Advanced Server 3, SQL Loader, Toad, OEM, Shell Scripting,

Confidential

Oracle DBA / Data Analyst

KARVY Group, a pioneer in financial services in India, has forayed into the retail finance space with its Non Banking Financial Corporation NBFC Karvy Financial Services Ltd or Karvy Finance. Karvy Finance has a vision to be a leading loans provider delivering superior value to all stakeholders.

Responsibilities:

• Data modeler and systems integrator services to the data warehouse project within NCC with a focus on customer data extraction, data integration, key generalization, data scrubbing, and preparation for loading into the data warehouse.
• Responsible for collecting and documenting business requirements, developing normalized relational data models, modeling processes, writing program specifications, designing physical databases, and writing SQL queries for adhoc reporting.
• Re-engineer the existing database, to define relationships, Implement business rules as constraints and for normalization/ denormalization of entities.
• Data migration is carried out using SQL Loader from Legacy system to Client/Server environment.
• Created Stored Procedures to resolve backend Batch Processes. Worked on other Database objects like Functions, Database Triggers and Cursors, where ever they are found wanting in the Database development and for Auditing.
• Worked on integrating features such as data encapsulation, information hiding, overloading, and exception handling.
• Drawing of the Process Flow Chart and Strategy ER diagrams through Designer/2000 Case Tool, in the analysis phase. Final Design ER, Data diagrams in the design phase
• Loading data form the different extracts into the OFSA database using SQL loader.
• Importing and restoring tables across different generations
• Perform Oracle DBA activities on Development databases create schemas, tablespaces, referential integrity, data quality assurance, table creation, views, backups, etc.
• Worked on Database Security, Performance Tuning, Database Optimization
• Modified Control File for database cloning, reset logging and default archiving.
• Implemented hot and cold backups, online backups, export backups and restorations
• Loaded non oracle data into Oracle tables by using SQL-LOADER utilities
• Worked on resolution of various Database Recovery scenarios using RMAN
• Performance and tuning of long running queries and allocations
• QA reviews for the small projects as part of Project Life Cycle

Environment: Oracle 10g/9.2.0.5/8.1.7, UNIX Solaris , SQL Server, PL/SQL Developer, Oracle Enterprise Manager, SQL Navigator, TOAD, RMAN