Senior Consultant For Oracle Database 12c, EXADATA and Data Integration Technologies Golden Gate
Oracle Corporation
Total years of experience :9 years, 8 Months
As a senior consultant at Oracle, I work closely with customers in attaining their Business Data Integration objectives. My tasks also extends to cover working closely with customer's during the lifecycle of their project journey. - Assist & lead customer project teams through their data integration discovery, scoping and design phases. - Design and devise framework for tighter integration, without having the need of changing/customising application code. - Work with customers on their project phases (Design, Build, Test, and Implementation) for Oracle Database 12c and Oracle DIS Technologies. - Work closely with customers in achieving complete end-to-end solution for 'real-time' EDW and BI environments. - I also assist customers in resolving Data integration related issues (Post Deployment). - Experienced in consulting and mentoring/coaching Oracle customers on Database & Application Integration best practices. - Provide technical workshops to customers, end users and service partners on data integration strategies and best practices implementations. - Keeping cost, simplicity, agility and best practices as forefront objectives in my solutions/activites. - Presenting technical workshops, white board sessions and demos to business and technical audience are part of my day-to-day activity. - Prepare and respond to RFI’s, RFP’s and RFQ’s. - Contribute to Oracle's customer experience for Oracle DIS integration technology adoption to ascertain better customer satisfaction. - Work with end-user technical teams on pre and post project implementation. - Provide hands-on technical sessions, knowledge transfer sessions and product update roadmaps to Oracle customers and partners.
Key Deliverables:
• Helped Western Australian businesses transform & embrace IT simplification using Oracle's end-to-end solution offerings (Engineered Systems).
• Evangelising Oracle Exadata technology at various IT consortiums, conferences and events.
• Developing Oracle brand awareness and highlighting Oracle product differentiators from other vendors.
• Assisting customers in Developing Database migration roadmap from single instance architect to Oracle high availability solutions on Oracle RAC (Exadata).
• Participating and preparing ‘proof of concept’ exercises for product evaluation, support and skills enablement services to Customer’s IT teams.
• Have prepared and present Oracle product value proposition, relevance to customer’s business requirements.
• As an ES Solution specialist I work closely with Oracle technical teams, partners, SI, ISV’s and customers to build and promote Oracle optimised solutions.
• At present I am driving couple of PoC engagements around Big Data, Cloud model/catalogue development using Oracle ES & OEM (DBaaS, IaaS, PaaS and SaaS).
Project: Have worked with a Western Australian Govt and Utility customers in building On-Premise Fast Provisioning Database Cloud services (DBaas) methodologies using Oracle Enterprise Manager Cloud Management and Database lifecycle management pack (DBLM) on Oracle Engineered System (Exadata).
Technologies: Oracle Exadata, Exadata Storage software, Oracle Database 11gR2, 10g, Oracle RAC, Oracle ASM, Oracle unbreakable Linux Kernel, Oracle OEM 12c Cloud Control, Oracle HA tools sets, Oracle Data integration products (ODI, GoldenGate) and have recently started to work on Oracle 12c in pre-prod environments.
As a Senior Database Administrator, I was tasked to manage & administrate heterogeneous application database environments; Hosting mission critical OLTP, OLAP and Data warehouse Systems on MS SQL Server & ORACLE
Position Held: Senior DBA, Infrastructure Support DBA, On-Call DBA & Project deployment DBA
Key Deliverables:
• Production support for VLDB’s, Database Administration, after hour’s
• On-Call support and Project based DBA deliverables for in-house software development.
• Adhere to CBA’s ITIL framework and best practices for managing Prod and Non-Prod Database Systems.
• As a Senior DBA at CommSec, I was responsible for various HA Production Database systems.
• The environment has more than 100+ Databases including Production, UAT, Test, Dev and Standby env.
• Key responsibilities covers 24x7 on-call support to CommSec infrastructure and provide DBA assistance for their in-house projects and application development databases.
• Provided support for OLTP and DW workloads; OLTP Applications example, Online Equity Trading Platforms, Portfolio Research Applications, CRM and BI/DW application database systems.
• Administrated highly available clustered Database environments running on Oracle and Microsoft SQL server.
• Install, Manage and Administrate Oracle RAC, ASM, ADG, RMAN, Oracle GoldenGate and Disaster Recovery Solutions (Active-Active and Active-Passive standby database systems), Materialized Views and Advance Replication systems.
• Prepared and maintained Database Backup & Recovery strategies for production and non-production RDBMS, which were spread over intelligent SAN systems and backed up by EMC & IBM Tivoli Tape management System.
• I have participated in a number of performance tuning projects. Performed application, SQL, and database instance tuning using Oracle AWR, ADDM, System/Session Tracing, TKprof, STATSPACK, DBMS Utilities, Microsoft Trasact-SQL, SQL trace and self-written scripts.
• Administrating & monitoring enterprise infrastructure for clients using several key technologies including UNIX shell scripts, third party and open source tools (Nagios), and in-house monitoring application using Java and SQL scripting.
• Strong commitment in performing day to day DBA tasks including application rollouts, application patching, database releases, database health checks, Oracle software upgrades, Backup & Recovery, System workload monitoring and Performance tuning.
• Ensure application availability by avoiding un-planned down time issues; issues like, disk quota, deadlock situations, archiving errors and other database related issues.
• Practicing in the Pro-active DBA culture for Enterprise Data centre using automated monitoring solution and defined procedures.
• Ensure maximum system availability and uptime to meet client SLA’s.
• 24x7x52 on-call Infrastructure support.
Environment: Oracle 11g, 10g, 9i, 8i & 7.3 RDBMS, Oracle 11gR2 Enterprise and RAC environment, Oracle ADG & DG, Oracle Application Server, Oracle Gateway for Sybase, Sybase DBMS ASE 15.x, 12.5.x, Microsoft SQL Server 2005, 2008 and 2012, Microsoft SSIS, Transact-SQL, SQL Trace, SQL Server Profiler, Sun Solaris, Oracle RMAN, Oracle Standby Database, Oracle Data Guard and Oracle Active Data Guard, Sun Solaris (LDOMS and Zones), RED HAT Linux Advance & Enterprise and Windows Server 2008.
Key Deliverables: Managing Oracle Database(s) for PROD, UAT, TEST and Dev environment • Assist the team of application developers. • Managed daily, weekly and monthly database releases for application support and development. • Managed version controls for application testing and code base deployment. • Designed customize Oracle database architectures for quick and easy deployments, using UNIX shell scripting. • Introduce new Oracle database features for application’s stream in-line development. • Designed and implemented high availability solutions using ORACLE HA features, e.g. (Real Application Cluster (RAC), Standby features and Data Guard features.) for business continuity. • Created and implemented enterprise wide monitoring for high availability production environments using UNIX and SQL scripts, monitoring encompasses (I/O, Storage, Sessions and CPU Utilization) • Capacity Planning and Object based monitoring for Large Objects. • Use Oracle RMAN for cloning, transporting & duplicating Prod/UAT and Test Databases. • Extensive experience in Refreshing database environments using Database duplicate and cloning tools. • Performed application, SQL, and database instance tuning using Oracle tools e.g. (ADDM, AWR, Statspack, extended SQL trace (event 10046 trace files), OEM Performance Manager, and custom scripts • Gathered Infrastructure Stats for performance and capacity planning using DBMS packages. • Have worked outside business hours to meet client expectations. • Documented company’s adopted standards for all Oracle database deployments. Outlined day-to-day DBA’s tasks, which covers standards for installing, upgrading and creating Oracle databases. Environment: Oracle 10g, 9i, Solaris, Red Hat Enterprise Linux & VERITAS Cluster, SAN Storage Solutions and Microsoft Windows 32-bit server with Oracle Database.
Key Deliverables: At Fujitsu, I was working as Oracle Database Administrator mainly Performance Tuning DBA.
Tune UAT/PROD Databases for Fujitsu clients, for both OLTP and DSS environments.
Tuned and optimized Oracle Report Server for optimum performance.
Performed session based tuning to identify poor SQL statements.
Took initiative and suggested the strategy of replacing Oracle conventional objects with new Oracle 9i enhanced features. E.g. (Table Partition features, Indexing & Oracle DB Archiving)
Achieved significant gain in access response time after the implementation of Oracle 9i new features.
Implemented new Oracle features with minimal application end changes.
Implemented the Use of DBMS_STATS features for gathering Database Stats.
Created and implemented the strategy to distribute data evenly across the servers.
Identified the Database bottle necks and rectified them with the use of Oracle performance stats pack.
Using Statspack, SQL tuning tools, and Oracle wait events interface, I have achieved significant improvements in response times for application.
Reduced I/O bottlenecks from the database using best practice Oracle SQL query operators.
Eliminate shared and exclusive object locks scenarios with the use of appropriate reference indexes on relational objects
Documented the changes and verify it against TEST - UAT environments prior to production implementation.
Key Deliverables: At BAE Systems Australia, my core task was to re-engineer the existing HR infrastructure application. Have worked in both capacities as a DBA and Oracle Developer Worked as Oracle DBA for the project lifecycle Technical lead for the entire project lifecycle - discovery, through post-production support. Performed requirements & gap analysis. Identified, designed and developed customisations including tables, views, forms and reports SQL and PL/SQL packages. Trace database sessions to perform application and database tuning. Designed and developed Oracle Application Reports for daily, weekly and monthly stats. Implemented Database security features using triggers and cursors. Documented business rules, functional and technical designs, test cases, and user guides. Coordinated quality assurance activities in projects. Generated designed and developed standards for the project to achieve (CMMI level-3)
Enterprise Computing, Distributed Systems, IT Governance and Business Functions.