SUMMARY

• Dynamic, result - oriented, and highly dedicated professional with 14+ years of experience as an Associate, Senior Consultant, and Principal Consultant (DBA).
• Oracle 9i DBA Certified Professional (OCP) and AWS Certified Solution Architect Associate (CSA).
• Proven track record in supporting Oracle Database 12c/11g/10g/9i/8i, Oracle Applications R12/11i, and Oracle Fusion Middleware 11g on on-premises and AWS cloud.
• Expertise in RAC, ASM, Advanced RMAN, DataGuard/Active DataGuard, Streams, OEM/Grid Control.
• Proficient in Monitoring, Performance Tuning of Database & Middle Tiers, including SQL, PL/SQL optimization using AWR, ADDM, ASH, TKPROF, Scripts, Alert Log, Toad, OEM/Grid Control, Statspack and SQLPlus.
• Proficient in implementation and support of complex integrated architectures on on-premises and AWS cloud.
• Expertise on Backup, Restore, Recovery, Cloning using user managed backups, RMAN, EXPDP/IMPDP and storage manager including SAN, HP Openview Data Protector.
• Accomplished cross platform migration, Patching, Upgrades, Migration, Data Centre relocation.
• Experienced in advanced Security and Audit using Transparent Data Encryption (TDE), Wallet, Triggers, Procedures, Roles, Views, RLS, VPD, SSL, Certificates, security groups and access control list (ACL).
• Skilled trouble shooter continually focused on identifying, isolating and resolving technical issues by following the best market practices.
• Mitigated bugs/errors of Oracle Databases, Oracle EBS Application, Oracle Fusion Middleware and AWS Cloud.
• Experienced in High availability (HAA) and Maximum Availability Architecture (MAA).
• Capacity, Scalability and Elasticity planning.
• Strong communication, verbal, writing, and interpersonal skills with the great ability to grow, sustain, and excel in a fast-paced working environment.
• Proficient in small to large volume data, OLTP, Hybrid, and Data Warehouse environments and DEV, TEST, UAT and PROD environment support.
• Skilled in Shell, SQL, PL/SQL Scripting.
• Strong knowledge of Unix Linux, Solaris and Microsoft Windows, including of Installation of Linux/Windows/Unix.

TECHNICAL SKILLS

Cloud: IAM, VPC, EC2, EBS, ELB, CDN, S3, EIP, KMS, Route 53, RDS, Glacier, Snowball, CloudFront, Schema Conversion Tool (SCT), Data Migration Service(DMS), DynamoDB, RedShift, AutoScaling, CloudWatch, ElastiCache, CloudFormation, DNS, DHCP, VPN, CloudTrail, Security Group, Network Access Control List(ACL) Network and Security.

RDBMS/DBMS: Oracle Database 12c/11g/10g/9i/8i (Clustering/RAC/Grid Infrastructure, ASM, Active DataGuard, RMAN(Cloning/Backup/Restore/Recovery), Streams/Replication, Security(RLS), ASH, ADDM, AWR, StatsPack, TKProf, Indexes, Hints, PL/SQL, Extract Transform Load (ETL)), Exadata 11g, MS SQL Server 2000, MS-ACCESS (2000)

Open Source Database: PostgreSQL 9.5

Applications: Oracle Application EBS R12/11i (Multi-Node, Install, Clone, Patch, Upgrade, User Management, Apache, Concurrent Manager, PCP, Forms, Reports, HTTP Server, JVM, Java, OC4J, OA Framework, Oracle 10iAS/9iAS), OFSAA, Visual Basic 6.0

Oracle Fusion Middleware: Oracle WebLogic 11g(10.3.6), Service Oriented Architecture(SOA) 11g, Repository Creation Utility (RCU) 11g, OBIEE 11g/10g, ODI 11g, WLST, JMS, JVM, Persistent Stores, JDBC, JNDI, Clustering

Operating Systems: Red Hat Linux (RHEL), IBM AIX, Solaris, HP-UX, UNIX, Windows 10/7/2003/2000 Server

Tools: /Technologies: Oracle Enterprise Manager(OEM)/Grid Control 12c/11g/10g, Oracle GoldenGate, Net Veritas Backup, HP Openview Data Protector, Storage Area Network(SAN), Toad, Lotus Notes, MS Office, VMPlayer/VMware, Virtualization, GitHub, Hudson, Jira

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA and AWS Consultant

Responsibilities:

• Proficiently installed, configured and supported complex integrated environments including Oracle database 12c/11g, Exadata 11g, RAC, ASM, RMAN, DataGuard, OEM 12c/11g, PostgreSQL 9.5, Oracle Application (EBS) R12, WebLogic 11g, OBIEE 11g and ODI 11g. Supported continuous evolving/Agile environments.
• Designed solution, installed, configured, supported Oracle Database 11g and Oracle Application R12 on AWS using IAM, VPC, EC2, EBS, S3, EFS, Route53, ELB (Elastic Load Balancer), CloudFormation for DEV and Testing purposes.
• Proactively monitored (using OEM/Scripts), Optimized Oracle Databases, Oracle Application R12/11i, Oracle Exadata 11g, including initialization parameter, SQL and PL/SQL optimization. Database performance reviews, health checks, troubleshot performance and other technical issues. Partitioning and regular quality improvement. Performance benchmarking on Exadata 11g compared to Oracle Database 11g on HP box.
• Capacity Planning. Root cause analysis and resolution within expected timeframe.
• Scrutinized and delivered technical consultancy of Oracle database on complex integrated architectures, and mitigated bugs/errors of Oracle Databases and Oracle eBS Application on on-premises and AWS cloud.
• Administered logical and physical architectures of the database.
• Automated tasks and procedures to drive efficiency of administration on on-premises and AWS cloud.
• Implemented, configured and supported security of Oracle Databases (Roles, VPD, RLS, Wallet, Transparent Data Encryption (TDE) and Oracle EBS application (certificates, SSL, user management, privileges), Security Groups and access control list(ACL).
• Large Data migration from IBM Mainframe to Oracle Database 11g and from Oracle Database to Oracle Exadata Database 11g.
• Upgraded Oracle Database 11g from 11.2.0.3 to 11.2.0.4.
• Migrated Databases from Single instance to Oracle RAC (Real Application Cluster) 11g or vice-versa.
• Recognized and sustained backup and recovery strategy of Oracle databases and applications, upgraded, regular security patching, interim patching on Oracle databases and applications and implemented best practices of Oracle.
• Backup, restored, recovered and cloned Oracle databases 11g, including large databases using RMAN/scripts, export/imports, expdp/impdp.
• Supported different life cycle of project from DEV-TEST-UAT to PROD.
• Code Migration.
• Handled multiple projects and deadlines across a diverse range of environments.
• Liaised with different teams and provided technical consulting at different stages of full lifecycle of the projects.

Environment: Oracle Cloud, AWS Cloud, Oracle Database 12c/11g (RAC, ASM, RMAN, DataGuard, VPD, RLS, Wallet, Transparent Data Encryption(TDE), Oracle Exadata Database 11g, PostgreSQL 9.5, E-Business Suite (eBS) R12, OBIEE 11g, ODI 11g, WebLogic 11g, OFSAAI, OAM ID, Linux (RHEL)

Confidential

Senior Consultant (DBA)

Responsibilities:

• Executed support of High Availability (HAA), Maximum Availability Architectures (MAA) and Load Balancing, Replication, monitored performance issues of Oracle Database 10g/9i/8i and Oracle eBS Application R12/11i and delivered technical consultancy of Oracle database and Oracle eBS Application R12/11i.
• Proficiently installed, configured and supported Oracle database 11g/10g, RAC, ASM, RMAN, DataGuard/Active DataGuard, OEM 10g, Oracle EBS R12/11i, OBIEE 10g, DNS and maintained security and access control.
• Administered logical and physical architectures of the database.
• Proactively monitored (using OEM/Scripts), Optimized Oracle Databases/Oracle eBS Application R12/11i, including initialization parameter, SQL and PL/SQL. Database performance reviews, health checks, troubleshot performance issues, Partitioning and regular quality improvement. Capacity Planning. Root cause analysis and resolution within expected timeframe.
• Data Centre migration/relocation.
• Automated tasks and procedures to drive efficiency of administration.
• Diagnosed and troubleshot firewall and load balancer issues.
• Migrated Databases from Single instance to Oracle RAC (Real Application Cluster) 11g or vice-versa.
• Skilfully established backup and recovery strategy of Oracle databases and delivered high availability for mission critical database and mitigated bugs/errors of Oracle Databases.
• Accomplished cross platform migration of Oracle databases, upgrade, relocation of Oracle databases, including Data center relocation. Oracle databases upgrade planning and execution from 8i to 9i, 8i to 10g, 10 to 11g.
• Recognized and sustained backup and recovery strategy of Oracle databases and applications, upgraded regular security patching, interim patching on Oracle databases and applications and implemented best practices of Oracle.
• Backup, restore, recovery, Database refresh, clone, creation of active standby database on large databases using RMAN/Manual Backups, exp/imp, expdp/impdp.
• Large Data migration to Oracle Database 10g.
• Installed, configured and supported Oracle Golden Gate 10g and Oracle Streams for Confidential .
• Supported different life cycle of project from DEV-TEST-UAT to PROD.
• Handled multiple projects and deadlines across a diverse range of environments.
• Liaised with different teams and provided technical consulting at different stages of full lifecycle of the projects.

Environment: Oracle Database 11g/10g/9i/8i (RAC, ASM, RMAN, DataGuard), Oracle eBS Application R12/11i, OBIEE 11g/10g, ODI 11g, WebLogic 11g, Service Oriented Architecture(SOA) 11g, Unix, HP-UX, AIX, Linux (RHEL), Windows

Confidential

Associate (DBA)

Responsibilities:

• Scrutinized and accomplished tuning of Oracle databases, patched, upgraded, migrated Oracle and MS SQL Server databases, as well as migrated SQL Server to Oracle Database in an efficient manner. Migrated SQL Server 2000 to Oracle 9i using Workbench.
• Troubleshot technical issues of Oracle Database 9i and MS SQL Server 2000.
• Cloned Oracle 9i database, backup, restore, recovery using RMAN, scripts, expdp/impdp, export/import. Regular DBA support using Remedy tickets.
• Enhanced capacity/scalability planning of Oracle databases, security audit/review, code migration, production support, and on call Support, Root Cause Analysis.
• Technical consulting to client or colleagues.

Environment: Oracle 10g/9i, MS SQL Server 2000, Windows 2003 Server, Red Hat Linux, Lotus Notes, Citrix

Confidential

Database Administrator

Responsibilities:

• Monitored and tuned using Monitoring Scripts, Alert Log, Toad, OEM, Statspack and SQLPlus.
• Installed, configured and supported Oracle Database 9i and MS SQL Server 2000.
• Troubleshot technical issues of Oracle Database 9i and MS SQL Server 2000.
• Cloned using RMAN and manual scripts using hot or cold backups.
• Backup, Restore and Recovery using User Managed, export/import, RMAN Backups and Net Veritas Backups or Oracle and MS SQL Server databases.
• Patched and Migrated Oracle and MS SQL Server 2000 databases.
• Technical Consulting to developers or colleagues.

Environment: Oracle 9i (9.2.0) / 8i (8.1.7), MS SQL Server 2000 Net Veritas Backups, HPUX (11i), Sun Solaris (5.8), Red Hat Linux, Windows 2003 Server

Confidential

Database Administrator (DBA)

Responsibilities:

• Installed, configured and supported Oracle Database 9i and MS SQL Server 2000.
• Monitored and tuned using Monitoring Scripts, Alert Log, Toad, OEM, Statspack and SQLPlus.
• Managed and Sized Logical and Physical Structures of Oracle Database 9i and MS SQL Server 2000.
• Backup, Restore and Recovery using User Managed, export/import, RMAN Backups and Net Veritas Backups.
• Troubleshot technical issues of Oracle Database 9i and MS SQL Server 2000.
• Technical consulting to client and colleagues.

Environment: Oracle 9i (9.2.0) / 8i (8.1.7), MS SQL Server 2000, Red Hat Linux, Windows 2003 Server

Confidential

Database Administrator

Responsibilities:

• Installed, configured and provided DBA support of Oracle Database 9i and MS SQL Server 2000.
• Backup, Restore and Recovery using User Managed Backups, Scripts and exports/imports of Oracle Database 9i and MS SQL Server 2000.
• Installed, configured and patched Red Hat Linux Sever and Windows 2000 Server. Configured Linux Kernel Parameters. Configuration of Banc724 application with Oracle and SQL database.
• Configured RAID devices.
• Troubleshot technical issues of Oracle Database 9i and MS SQL Server 2000.
• Access provisioning on Oracle database and MS SQL Server Database.
• Technical consulting to client and colleagues.

Environment: Oracle Database 9i, MS SQL Server 2000, Red Hat Linux, Windows 2000 Server