OBJECTIVES

Oracle certified database administrator and Sun certified Solaris system administrator with solid experience on Exadata X2/3, Oracle RAC, DataGuard, ASM, RMAN, GoldenGate, OEM, ODI, OID, VCS, BCV/SRDF, Sun Cluster, Shareplex, Performance tuning seeking a challenging position to support business requirements with my expertise on database installation, upgrade, migration, administration, tuning, monitoring, programming, data modeling, Shell and Perl scripting, Unix/Linux system administration.

EXPERIENCE

Present Senior Oracle DBA, Confidential

• Coordinate with Operation team, Project team, Architecture team, System admin team, Network team, Storage team and other teams across the globe to provide regular and 24x7 on-call Support for more than 400 databases with size up to 30TB running on Exadata, Solaris, RHEL, Zlinux and Window platforms.
• Plan and implement consolidation of databases from Solaris, Linux and Window to
• Exadata platform. Migration of 20TB database from Oracle 10g on VCS to 11g RAC on Exadata X3-2 with GoldenGate. Implement partition, compression and encryption strategy on Exadata. Setup database services and resource plan to manage workload.
• Perform DG switchover to support data center migration and database patching. Setup snapshot standby database to support DR test.
• Install and configure OEM Grid Control 10g, 11g, 12c. Install and configure OEM agents on different platforms. Configure OEM and plugin to monitor Exadata databases, storage cells and ZFS Storage appliances. Setup and implement firm wide security standard for Oracle and SQL server databases. Setup and document database and object naming standard.
• Setup and perform RMAN backup and restore using TDPO and DDBoost. Automate test database refresh from production using RMAN duplicate.
• Diagnose and tuning performance issues at system, database and sql level using OEM, AWR, ADDM, ASH, SQLT, SQL Profile, SQL Baseline.
• Install and configure Oracle Data Integrator ODI 10g to support data replication and transformation. Plan and support upgrade from ODI 10g to 11g to improve stability and performance. Provide primary support to upgrade autosys from R10 to R11 and migrate Autosys database to Exadata.
• Support migration of PeopleSoft HR database from DB2 on MVS to Oracle 10g on Solaris and upgrade of PeopleSoft to use Exadata database. Provide support for firm wide SQL Server databases.
• Develop and implement shell and Perl scripts for database backup, analyze, monitoring and many other jobs.

Oracle Database Analyst, Confidential

Oracle DBA Consultant, Confidential

• Communicate with project manager, system admin team, SAN storage team, application development team and product support team to resolve all database related issues in the database migration project.
• Resource planning and architecture recommendations for a project to upgrade the databases from Oracle 8i OPS to 10g using Shareplex replication tool.
• Develop Unix shell scripts for file system monitoring, RMAN hot disk and tape backup, archivelog backup, export, statistics collecting and reporting, log switch, alert log monitoring, alter log recycling, dump file cleanup, listener log file cleanup, backup file cleanup, audit file cleanup etc for more than 100 production, UAT and development databases.
• Implement HA solutions for Oracle databases with Veritas Cluster Server and Sun Cluster.
• Design and implement DR solution for production databases with Oracle Standby database, Data Guard and SRDF.
• Setup 10g Grid Control OMS and agents to monitor database status. Implement autoticketing system with OEM grid control.
• Interact with application development team to fix performance issues and code issues in PL/SQL triggers, functions, procedures and packages.
• Provide 24 X 7 production on call support for more than 500 databases.

Senior System Engineer DBA, Confidential Oracle DBA Consultant, Confidential

• Set up backup to disk and tape with RMAN. Develop shell scripts to recover database under different situations.
• Set up OEM to monitor database performance. Provide 24 X 7 support for production databases.
• Development Perl scripts, shell scripts and PL/SQL functions, stored procedures to automate the data loading process from data forms.
• Participation in technical analysis, database design and data modeling for various projects.
• Support application development team for database schema design, schema change, and SQL tuning.

Web Application Developer, Confidential

• Participation in business and technical analysis, implementation of logical data modeling and physical database design with Erwin.
• Move data between production, testing and development environments by hot and cold database cloning.
• Tuning database based on database performance ratios. Using STATSPACK to identify high-impact SQL statements and tuning SQL statements by hints, index and rewriting.
• Development of Oracle database functions, stored procedures, triggers and packages using PL/SQL.
• Administration of users, disks, drivers, NFS, DNS, NIS, TCP/IP networking in Sun Solaris system.
• Develop web applications using PERL, TCL.

CERTIFICATES

• Oracle Certified Professional Database Administrator.
• Sun Certified System Administrator for the Solaris Operating System.