SUMMARY

• 7 years of experience asOracle DBA, providing 24/7 support of both development and production 11g/10g/9i/8i databases on Various Platforms.
• Excellent experience in Installation and configuration ofOracle 8i, 9i, 10g, 11g in UNIX/LINUX and Windows environment.
• Designed and implemented OracleReal Application Clusters (RAC)on Solaris for anOLTP applicationwith TransactionApplication Failover andhigh transaction volume
• Hands on experience withInstallation, Configuration, Migrations, Oracle Data Guard,Backup and Recoveryusing RMAN, Disaster Recovery and Patching, upgradingand administering40 Terabytesof Oracle Databases on Oracle11g/10g/9i.
• Installation,configuration,upgradeandperformancetuningof OracleRAC.
• Experience with SQL,PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, Logical and Physicaldatabase design.
• Management of schemas, objects &partitioningthe tables & indexes.
• Worked on AdvancedReplicationincluding synchronous and asynchronous scenarios
• Experience with Oracle 10g features: Flash - Back Recovery,Data pump, ASM, ASH, AWR,
• ADDM, ASSM, ASMM, Automatic Undo management, Grid Monitoring and Recycle Bin.
• Expertise in supporting replication withsnapshots, Materialized Views and Streams.
• Solid experience with Oracle technologyarchitecture,Oracle and Real Application Clusters.
• Expertise inmaintaining Database Securityusingauditing.
• ConfiguringDB Linksfor users located remotely.
• Knowledge of Data transfer betweenSQL Server and Oracle.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Excellent analytical and problem-solving skills.
• Result oriented, self-motivated, team player, ability to work independently.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS

Databases: Oracle 8i / 9i / 10g, SQL Server, MS Access

Operating Systems: UNIX, Windows NT/2000

Programming Languages: PL/SQL, UNIX Shell Script

Database Tools: Toad, OEM, DBA Studio

ETL Tools: SQL Loader, Erwin

Version Control Tools: Visual Source Safe

Telnet Tool: Putty, Hummingbird Connectivity (9.0)

PROFESSIONAL EXPERIENCE

Oracle/SQL DBA

Confidential, MA

Responsibilities:

• Implementation of High Availability solutions withOracle 10g RAC,Physical and Logical StandbyDatabases(Data Guard)andReplication using Golden Gate.
• Developed back-end logic for business applications, e.g.views, procedures/functions, triggers.
• Developedscripts and reportsusing SQL, PL/SQL andPerl.
• Designed and implemented OracleReal Application Clusters (RAC)on Solaris withEMC Storagefor anOLTP applicationwithTransaction Application Failoverandhigh transaction volume.
• Established best practices and best procedures for database administration. Responsible for Software life-cycle support to include migrationof all custom application changes through four different instances to production.
• Working alongside programmers and contributing to the development process; Enabling and analyzingtrace files
• Performing monitoring and performancetuning.
• Defining and Settingbackup and recoveryprocedures.
• Performed and tuned using AWR, OEM Grid etc.
• Tuningthe database usingstats packand custom scripts
• Responsible for continuous database monitoring and reorganization for ensuring performance
• Tuningand balancing I/O by monitoring file system and tablespace I/O statistics.
• Experienced inTuning SQLstatements usingExplain Plan, SQL Trace, TKPROF and STATSPACK
• WritingShell Scriptsfor managing day-to-day activities andautomation of backup.
• Optimal Space utilizationin tablespace by avoidingfragmentation.
• Usage ofPartitionsto improve the queryperformance and manageability.
• Installation ofOracle RDBMSserver software andversion upgrades.
• Backup of Database(Making Backup Schedules depending upon Business Strategy: DailyBackup, weeklyBackupetc.)
• SQL and PL/SQL Programming.
• Installation and configurationof Oracle Client software and Tools.
• Analyzed the user requirements anddesigned partitioned tablesfor improving performance of Data marts.
• Analyzed the user requirements andDesigned views using STAR schemafor improving performance of Data marts.

Oracle/SQL DBA

Confidential, MA

Responsibilities:

• Currently helping client to use existing infrastructure to achieve Maximum benefit to reduce cost and maximum performance.
• Actively working with client for Server Consolidation & Database Consolidation.
• Changes were made dynamically whenever possible to fulfill high-availability requirements.
• Enforced need of regular data purging processes from production, design and development, to deployment.
• Implemented and maintained Oracle 10g Data Guard/standby databases for fail-over purposes.
• Propagation from primary to standby via automated scripts, and sometimes uses standby databases to immediately restore primary database.
• Experience with ‘graceful’ switchover and switchback between primary and standby databases.
• Replicated to a disaster recovery site for increased server manageability and availability.
• Participated in development of enterprise-wide security standard methodology, and ongoing deployment.
• Installation of RAC and Managing RAC Environment efficiently
• Proficient in RAC Performance Tuning.
• Create and maintain materialized views.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Monitored the production Oracle alert logs for database errors.
• Monitored system resource availability and responded to system memory and data issues.

Oracle/SQL DBA

Confidential

Responsibilities:

• Installing 9i database.
• Study and Analysis of Business requirements
• Interacted with the Technical Design team and contributed in impact analysis and creation of the Technical specifications.
• Consistently delivered work assignments within given timeframe, with high quality and zero defect work which was highly appreciated by the client
• Was involved in database design and implementation.
• Participated constructively to help and enable team members with their challenges
• Provided technical assistance to the testing team to understand and setup the testing scenarios and to execute technical intervention test cases.
• Upgraded oracle 9i /10g.
• Creating stand by database.
• Extensively worked on Real Application Cluster (RAC).
• Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
• Automated hot backups using a combination of incremental, differential and full RMAN backups.
• Maintaining archive data on appropriate storage devices.
• Tracing, troubleshooting with database performance and tuning issues.
• Export/Import of oracle databases.
• Tuning SQL queries.
• Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
• Analyzing and validating database objects.
• Monitoring of database size and disk space in Production, Staging & Development environments
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers in SQL server 2005.
• Performed Production support and on Call duties.
• Created monitoring scripts to alert for production issues.
• Migrated Databases from MySQL, Oracle, and SQL Server.
• Coordinating with team members.

SQL Developer

Confidential

Responsibilities:

• Design, develop and implement database systems based on customer requirements.
• Prepare design specifications and functional documentations for assigned database projects.
• Develop database tables and dictionaries.
• Ensure data quality and integrity in databases.
• Create complex functions, scripts, stored procedures, views and triggers to support application development.
• Participate in database design and architecture to support application development projects.
• Optimize database systems for performance efficiency.
• Perform data back-up and archival on regular basis.
• Test databases and perform bug fixes.
• Develop best practices for database design and development activities.

Environment: PL/SQL, Oracle 10g, Eclipse, PL/SQL Developer, Application Server, JDBC, MYSQL, MSSQL