Senior Oracle DBA

Employment History Position: Senior Oracle DBA CapGemini North America, IBM Global Services, Loblaw Toronto, Ontario Environment: Oracle 11g, Oracle 11g RAC, Oracle 10g, ASM, Oracle 9i, Oracle 9i RAC, Data Guard, AIX, Linux, VMware, Hitachi Storage, BMC Patrol SC2013 is Loblaw enterprise-wide multi year project, 50M per year initiative which consists of dozens of projects Billing, Warehouse Management, Order Management, Transportation deployed simultaneously under very tight deadlines. Number of servers and systems deployed is measured in hundreds. Team size was couple of hundreds of members DBA Team size alone is about 100 including IBM, client, offshore . I developed Gold standard templates for mass database deployments in file system based, Oracle RAC and virtual environments. I provided DBA support and became part of Design team to help develop deployment blueprints for new systems. I installed Oracle RAC databases for production, mission-critical, enterprise bus custom built messaging system and scheduling system Autosys . I provided support for all newly built environments and helped client to support legacy production and lower environments. I worked actively with monitoring development team to deploy monitoring agents to new servers and provided ticket resolution for servers in our domain. I did extensive Disaster Recovery testing failover, recoverability for newly built systems, helped design and produce runbooks and related documentation. I worked with Oracle support to resolve critical Service Requests. Deployed database changes as requested by various parties mostly by vendors or client's internal Design Team . I also provided support to client's production systems high throughput OLTP systems and data warehouses when they faced critical issues. My expertise was referenced and utilized during the toughest challenges client faced when dealing with emergencies and critical issues related to production databases system outages primary site SAN failure which implied failing over to DR, then rebuilding primary databases , performance problems and organizational problems. Position: Senior Oracle DBA Confidential Environment: Oracle 11g, Oracle 10g, ASM, Oracle 9i, Oracle 9i RAC, HP-UX, Linux, NetApp Lafarge is a Fortune 500 company - global provider of construction materials. Environment consisted of approximately 500 database servers. I provided production database support for JD Edwards OLTP database with 12000 concurrent sessions, as well as other mission critical systems. Restored databases when file systems got corrupt or disks crashed. Provided SQL tuning, troubleshooting and configuration support to developers. I provided production database support in 7x24 on call rotation environment. Position: Senior Oracle DBA Confidential Environment: Oracle 10g, Oracle 9i, Oracle 9i RAC, Sun OS, EMC storage, PL/SQL I helped client to deploy mission critical applications on tight deadlines. I developed and deployed new solutions for automated database partitioning split, exchange, merge partitions . Took active part in deploying multiple simultaneous, mission critical projects. I developed and implemented database synchonizing solution for Very Large Databases that utilized disk mirroring split mirror based on Hitachi Shadow technology. Position: Senior Oracle DBA Confidential Environment: Oracle 10g RAC, Oracle ASM, Oracle 9i RAC, Sun OS Provided performance tuning and administration services for Oracle RAC database. Performced advanced performance tuning -RAC specific global cache tuning, high-speed interconnect tuning. Performed capacity planning activities based on historical storage usage. Performed backup and recovery activites, as well as SQL, PL/SQL tuning. Created Oracle 10g Streams Replication setup. Position: Senior Oracle DBA, Consultant Confidential Environment: Oracle 9i, Oracle 8i, Oracle Advanced Replication, Erwin, AIX HACMP , Windows NT, Tivoli TDP, TSM , RMAN As Senior DBA for Technical Architecture group I performed requirement analysis and deployment options that would best fit client environment. I evaluated new technical features. I created and deployed read-only materialized views replication setup. I configured and deployed advanced security option. I planned and performed upgrade/migration from Oracle 8i to 9i. I planned and performed capacity planning activities. Created backup and recovery strategy and scripts. I performed performance tuning activities in large environment. Position: Senior Oracle DBA, Consultant Environment: Oracle 9i, Oracle 8i, interMedia, RMAN, OEM, PL/SQL, Erwin, UML, Rational Rose, Sun Solaris, WebLogic, JSP, J2EE I created and implemented data partitioning strategy. Evaluated new products to make sure they would fit project requirements. I performed monitoring and performance tuning activities, as well as RAID setup. I designed and implemented disaster and recovery procedures Position: Senior Oracle DBA, Consultant Confidential Environment: Oracle 8i, RMAN, OEM, Advanced Replication, Standby database, Sun Solaris Clusters, Veritas File System, I provided production DBA support in fast paced Silicon Valley culture standby database creation and maintenance, performance tuning, database replication materialized views, multimaster replication shell scripting as well as database migration to highly available HA, clustered environment. Position: Senior Oracle DBA, Consultant Confidential Environment: Oracle 8i, Oracle8, Oracle Advanced Replication, Sun Solaris, shell scripting, Rational Rose I deployed Oracle database on raw devices. I created multimaster replication setup implemented conflict resolution, notification methods. I performed performance tuning, monitoring and developed object oriented database design using UML method. Position: Senior Oracle DBA, Consultant Confidential Environment: Oracle 8i, Oracle 8, Sun Solaris, Java, AIX, Windows NT, Oracle Application Server, OEM, BMC Patrol, Erwin, Oracle Parallel Query, Multi-threaded Server I performed database tuning, monitoring backups, recovery. Created logical, physical database design. Created and maintained data processing routines. Position: Oracle DBA, Consultant Confidential Environment: ORACLE 7, AIX UNIX , Windows NT, Intranet, AIX Clusters HACMP I was development and production DBA in fast-paced, multi-project environment I performed database monitoring and tuning, SQL optimization. I performed systems analysis interviewing, data flow diagrams , enterprise data modeling using relational and object oriented paradigms. I was technical lead on data warehousing subproject loading strategies, data aggregation, optimization I conducted job interviews for full time and Consultant DBA positions Position: Oracle Consultant Confidential Environment: ORACLE 7 Pro C, C , SQL DBA, Erwin CASE , ODBC API, UNIX HP-UX I performed systems analysis using interviewing techniques and data flow diagrams. Performed enterprise data modeling using ERD's IDEFIX1 method I performed logical and physical database design and implementation using relational and object oriented paradigms. Performed regular DBA activities database creation, users management rollback segments, tablespaces security backup and recovery . I participated in tools and methods evaluation. Confidential Environment: ORACLE7, SQL DBA, Erwin CASE , UNIX AIX , DB2 distributed database Defined business requirements. Facilitated data modeling sessions. Performed Logical, physical database design ERD's defined application meta data repository. Conducted database tuning defined security roles. Transformed specs written in 3GL style to specs suitable for event driven programming. Position: Oracle Consultant Confidential Environment: ORACLE 7 SQL DBA, Pro C, SQL, PL/SQL, SQL Forms, SQL Plus, ORACLE Utilities , UNIX SunOS Consulted on database performance optimization recommended indexing strategy for fast retrieval. Evaluated tools and techniques for data processing team adviser for bottlenecks in production process and for SQL optimization . Wrote data processing procedures large tables to improve execution time. Conducted testing wrote technical documentation. Performed network software installation. Position: Oracle Programmer Analyst, Consultant Confidential Environment: ORACLE 7 Pro C, C, SQL Forms, SQL ReportWriter, SQL Plus, SQL Net , UNIX SunOS , OPEN WINDOWS, SUN SPARCstation client-server environment Wrote software modules to transfer formatted radio, TV survey data from ORACLE 7 database to XEROX DOCUTECH device. Communicated with DBA and database modeler to help provide optimal database design for data retrieval. Position: Oracle Programmer Analyst Confidential Environment: ORACLE 6 SQL Forms, SQL ReportWriter, SQL Plus, PL/SQL , UNIX Performed systems analysis using interviewing techniques and data flow diagrams - ORACLE CASE Designer - Data flow Diagrammer . Performed system design activities using ERD's ORACLE CASE Designer - Entity - Relationship Diagrammer system implementation logical and physical database design .