Oracle DBA team lead Resume

SUMMARY

He has over 19+ years of IT experience working in different capacity.
He has assumed various roles working as a consultant the roles include Application developer, Sr Oracle DBA, Oracle Exadata Machine administrator, Linux Admin, Network administration, Application Architect, Infrastructure Architect, Architect business solutions, Design and develop IoT embedded systems, Project Management experience on a large project.
He has worked for top MNC companies.
He has diversified industry experience with different functional areas which include Software development, Finance, Marketing, Health care, payroll, Energy companies, Oil and Gas, Telecom sectors to name a few.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA team lead

Responsibilities:

Lead on-site and off-shore team.
Exadata machine administration X5-2 manage DB nodes, Exadata cell,
+ASM, Infiniband, Cisco switch, OEM 12c / 13c, ILOM, ASR, Platinum gateway & PDU
Install configure golden gate 12c setup bidirectional replication
Oracle peoplesoft DBA (HR & Finance) on 11gr2, 12
Setup configure active dataguard and backup & recovery using RMAN
Patch Oracle Exadata infrastructure
Database best practices and performance tuning in exadata X5-2 environment

Confidential

Oracle Exadata SME

Responsibilities:

Installing configuring Exadata X6-2 using OEDA (Oracle exadata deployment assistant)
Exadata machine administration Exadata cell, Infiniband, Cisco switch, PDU, ILOM configuration, Oracle ZFS, Platinum gateway
Configuring ASR for Exadata X6-2 machine
Setup SNMP traps on ILOM for ASR
Install configure Oracle Enterprise Linux 6 servers
Oracle golden gate configuration on Oracle database and SQL Server 2000
Upgrade Exadata cell servers to 12.1.2.2.1
Upgrade DB node OS (LINUX from 5 to 6 )
Upgrade Infiniband firmware
Orchestrate patching of Exadata machine using patchmgr and dbnodeupdate
Patch exadata RDBMS and clusterware
Administer/configure databases on Oracle ODA machines

Confidential

Oracle Exadata SME

Responsibilities:

Architect solution for data loads using Warescape ETL tool on Oracle Exadata X4-8 using Oracle parallel servers, PL/SQL and Shell scripting.
Performance tuning of Oracle Exadata database of size 30 TB
Partitioning large tables of size 1 TB and tuning SQL statements for hash joins
Tuning PGA / SGA of exadata for direct path reads
Configure database resource manager (DBRM)
Tuning for exadata cell offloading activity
Performance tuning of SQL statements issued by COGNOS reporting tool.

Confidential

Oracle database architect

Responsibilities:

Architect data warehouse solution using Informatica ETL tool on Oracle 11gr2 and Neteeza databases .
Tune Informatica ETL processes running on Oracle 11gr2 databases using parallel servers.
Programming using PL/SQL and Shell scripting
Middle ware administration using JBOSS, Oracle JDBC and OCI. JVM configuration and administration.
LINUX administration and data encryption.
Install / Configure /Administer SQL Server 2000

Confidential

Sr Principal Consultant

Responsibilities:

Architect Oracle RAC HA solutions using Oracle technology to support mission critical website like confidential
Install configure Oracle 11gr2 clusterware and RDBMS on LINUX platform, Configure RAC for high availability HAIP etc.
Performance tuning of Oracle RAC databases for tyer-1 production databases using AWR, ADDM, ASH reports
Provide database architecture and solutions for Oracle 12c database infrastructure along with Oracle Weblogic
Database migration and upgrade projects for ERP applications like PeopleSoft, Oracle EBS
Install configure Oracle golden gate 11gr2 classic and Integrated capture
Configure Dataguard for high availability in RAC 11gr2 and Weblogic 11gr2 environment
Tune ETL processes running on Oracle 11gr2 Databases using parallel servers