Current location: Albany, NY
Relocate: East Coast only (NY/NJ/CT/PA/VA/MD/DC)
HOTLIST: Senior Certified Oracle DBA available immediately for opportunities in East Coast
Hi, Sr. Certified Oracle DBA available immediately - please email requirements and other details to sales@intelysys.com Experience Summary: - Over 8+ years of IT experience as Oracle Database Administrator for production, testing and staging Oracle databases.
- Experience in Database design, Functional design, ERD and Physical Design
- Installing, configuring, monitoring and maintaining Oracle Software 11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform.
· Strong background knowledge installing and configuring Oracle 10g R2 RAC (Real Applications Clusters) with ASM and maintaining other Oracle database products on Sun Solaris, Red Hat Linux, IBM-AIX, Windows environments. · Implemented Data Guard for production system in case of disaster recovery, maintain primary and standby databases. · Sound knowledge of setting up & administering Oracle Streams. Configured replication based on Oracle Streams. - Migration and Upgraded Oracle 8i to Oracle 9i/10g/11g database.
- Experienced in applying patches including Patchsets and CPU patches on Standalone, RAC and Standby Database.
- Hands on Experience in Space management, User management, Profile and Capacity Planning.
- Planning Backup/Restoration Strategy for 24x7 operation support.
- Refreshing the Production over the Dev, UAT and also keeping the Test Instances in sync with other instances.
- Enabled the flashback features and enabled auditing.
- Extensive experience in Configuration of RMAN, Planning and scheduling Backups using RMAN, Hot Backups and Logical Backups, Oracle utilities and tools like OEM, Import-Export, Data Pump, and DBCA.
- Extensive use of Oracle Enterprise Manager (OEM) Grid control for Performance, Administration and Maintenance of Databases.
· Managing Database Structure, Storage Allocation, Table partitioning, Table/Index segments, and Rollback segments, Constraints, Database Access, FGAC (Fine Grained Access Control), Roles and Privileges. - Experience with various Oracle Tools such as Oracle SQL Developer, TOAD, BMC Smart DBA, ERwin, DBArtisan, TORA, Oracle Designer and Developer 2000, SQL*Loader, LogMiner, SQL*Net.
- Configure networking for oracle databases, tnsnames.ora, sqlnet.ora, listener.ora.
- Performed Database Tuning by Optimizing SQL and PL/SQL scripts, SGA tuning. Also tuned several production databases using EXPLAIN PLAN, auto trace, TKPROF & trace events
- Strong experience in using various tuning Advisors like SQL Tuning Advisor, SQL Access Advisor, Memory Advisor, UNDO Advisor, ADDM, Segment Advisor and MTTR Advisor.
- Experience in programming using SQL*PLUS, PL/SQL.
- Experience in installing and configuring MS SQL server 2000 /2005 on Windows server.
- Strong experience in UNIX O/S and Shell programming and sound knowledge in Perl scripting.
- Automated the processes by using CRONTAB.
Certification: Oracle 10g Certified Professional (OCP) Education: Master in Information Technology, INDIA Bachelor of Science, INDIA Technical Skills: Operating Systems: Sun Solaris 10/9/8, HP-UX, IBM-AIX 5L, Red Hat Linux, Windows NT/2000/2003 Hardware Platform: Windows, Sun Solaris, HP-UNIX server, RHEL-AS 2.1, TCP/IP. Languages: SQL, PL/SQL, C, C++, JAVA, Perl, Bash & Korn Scripting. DBA Tools: RMAN, Import/Export, Data Pump, TKPROF, SQL*Loader, Oracle Enterprise Manager, Automatic Storage Management, ASMM, BMC SmartDBA, JDeveloper Monitoring Tools: TOAD, DBArtisan, OEM, 10g Grid Control, ADDM, ASH, AWR, 10g Tuning Advisory Framework, 9i Statspack RDBMS Tech: Oracle 8i, 9i, 10g,11g, 9i/10g RAC, Standby Database, MS Access, MS SQL Server. Data Modeling Tools: Erwin 4.1, Designer 2000, IBM Rational Rose 7. OLAP Tools: Cognos Tools (Impromptu, PowerPlay, PowerPlay Powermart), Informatica PowerCenter 7.1 and OLTP. Backup Tools: RMAN, Oracle Data Guard (failover, standby, disaster recovery), Flashback Database. ERP: SAP, Oracle Apps, PeopleSoft |
No comments:
Post a Comment