_________________________________________________ Here's the brief profile of our Sr. Oracle DBA with over TWELVE years of Oracle Database Administration experience on Installation, Upgrade, Monitoring, Performance Tuning, Database Backup and Recovery on Sun Solaris, Linux, AIX and Windows environments.
He is located at Santa Ana, CA and available immediately for projects nationwide. Please contact me for further information. Thanks, Swapnil Modi- Alliance Sales cyberThink Inc Tel : (877)-223-7153 ext 624 mailto:[email protected] <[email protected]> ------------------------------------------------ Brief profile of our Sr. Oracle DBA ------------------------------------------------ SUMMARY OF QUALIFICATIONS: • Over TWELVE years of Oracle Database Administration experience on Installation, Upgrade, Monitoring, Performance Tuning, Database Backup and Recovery on Sun Solaris, Linux, AIX and Windows environments. • Expert on Oracle 11g/10g/9i/ 8i and performed Physical and Logical database design, Development, Oracle Installation, Performance Tuning, Monitoring, Partitioning, Advanced Replication, Backup, Disaster Recovery, PL/SQL, Security, UNIX Shell Scripting, and Trouble Shooting Oracle Databases. • Proficient in Real Application Cluster (RAC), Veritas Cluster Server (VCS) and Netback up. Experience in designing and implementing backup and recovery strategies. Extensively used conventional and RMAN for backup and recovery. • Experienced in writing Stored Procedures, Functions, Packages, Handling Exceptions, creating database triggers using SQL and PL/SQL in Oracle 10G Grid control/DB control through Oracle Enterprise Manager. • Tuning the Databases for optimization using STATSPACK/AWR reports. Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring databases. • Efficient in SQL query optimization using explain plan, TKPROF, auto trace reports, gathering statistics, pinning the objects, running scripts. • CRS (cluster ready service) installation and new database creation for 10g RAC and Managing and administrating CRS Clusters for HA. • Trained ggs fundamentals and advanced replication with Golden Gate Software, Inc and Oracle corp at Sprint and ATT working on ggs over FOUR years on installation, configuration, troubleshooting, problem fixing, advanced replication Golden Gate streams databases, working with apps teams to resolve ggs issues and on Experienced administration of Shareplex stream databases. • Installation of patches for bugs fixing and security administration, cloning/refresh schemas and preparing Mops. Space/storage management and job scheduling using cron, dbms, oem, autosys. • Managed and supported mission critical database running 24X7 Oracle 9i / 10g/11g Production databases Database Cloning on Test servers from Cold and Hot backups of Production Database. Oracle 9i DBA Certified Professional. Sun Certified System Administrator (Solaris 8). TECHNICAL SKILLS: Hardware: Pentium, Sun Ultra 3k, 450, Sun E3500, Sun Fire 6800/6900, 880R, 480R, 280R. Languages: Java, C, COBOL C++, SQL, PL/SQL. Scripts: UNIX Shell Script, Java Script, VB Script. RDBMS: ORACLE 8, 8I, 9I, 10G, MS-Access. GUI: Developer 2000, Visual Basic 6.0. Operating Systems: Sun Solaris, UNIX/Linux, Win 98/NT/2000. Networking: TCP/IP Socket Programming. Web Technologies: HTML, XML. Microsoft Web Tools: FrontPage 98. Environment: Oracle 8i/9i, 10G, UNIX, Widows, Patrol, Putty, Terminal Service, pcanywhere, RAC, Data Guard, RMAN, VERITAS Net Backup 4.5, SQL*Loader, Oracle 9iAS (Release 1 & 2), OC4j, OEM, Sun Cluster, Citrix Servers, Golden gate, SharePlex. AIX, Linux, TOAD, OEM Grid. PROFESSIONAL EXPERIENCE: Jul ‘11 - Present Deloitte Senior Oracle DBA Santa Ana, CA Responsibilities: • 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues. Performed database cloning to setup test and development database. Conducting sizing & capacity planning for Oracle databases. • Upgrading production and development databases to Oracle 11g. Installation, Configuration and Administration of Oracle 11g R1 and R2 RAC and ASM, Oracle OEM Grid control. Applied patches to Oracle Databases and Oracle Applications. Applied Oracle Applications and database patches. • Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing. Responsible for optimizing the queries and application tuning. Perform SQL tuning and assist developers with coding PL/SQL. • Provided support to Application Database Administrators in designing the database. Installed and Implemented Backup & Recovery procedures. Build the streams Core to Replication staging, Replication staging to Portal, Replication staging to ETL, Portal to ETL and maintenance, managing streams. • Installed Golden Gate and maintenance, trough shooting ggs production issues. Data guard configuration administration, troubleshooting, switchover, failover as per the management approvals. • Bug fixes and applying patches, opening Oracle SR’s as a point of contact, uploading required files, take the necessary actions, proactive steps to prevent the outages. • Security management and auditing, restore and recovery actives using Rman. Used RMAN for backup and recovery. Performed backup validations using RMAN. Implementation of Hot, Cold and Logical backup plans. • Involved in taking Backups using Oracle RMAN (Recovery Manager) and TSM (Tivoli Storage Manager). Customization and development of Korn shell scripts. • Management of schemas, objects partitioning the tables & indexes. Automation of data load using Korn shell scripting and SQL*Loader. Responsible for setting and managing user accounts, Granting required privileges to users. • Defining and Implementation of backup and recovery strategies. Perform other regular DBA activities including space management and performance monitoring. • Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN. Continuous monitoring of database performance during peak and non-peak loads using STATSPACK. Implemented the replication of data between multiple databases using Streams. • Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters. -- You received this message because you are subscribed to the Google Groups "Exact Match" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/exact-match?hl=en.
