| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Maple Ridge, BC, Canada V2W 0H4EMAIL AVAILABLE PHONE NUMBER AVAILABLE LINKEDIN LINK AVAILABLE Senior ORACLE DBA Stabilize DB Systems | Reduce Costs | Improve ProcessesExtensive experience and track record of success in Oracle databaseadministration. Highly adept at providing and supporting high availabilitydatabases of various sizes, versions, and platforms. Completed anddelivered HA new database environments for a number of migration / upgrade/ new projects within challenging timelines.Collaborative and client-focused with strong analytical and problem solvingskills. Known for being very task oriented and productive with greatattention to detail. Able to learn new concepts and processes quickly andwork well under pressure.Expertise in: Project Planning | Implementations | DB Performance Troubleshooting | High Availability DB Maintenance Technical Skills|Operating |UNIX Linux / Solaris / HP / AIX | Windows ||Systems | ||Languages |SQL | PL/SQL | UNIX shell scripting | AcuCOBOL | FoxPro | Pascal||| |Clipper | Modula-2 ||RDBMS |Oracle 8/8i/9i/10g/11g ||Technologies |Grid Infrastructure | RAC | ASM | DataGuard | RMAN Backup, || |Recovery || |NetApp SMO | Veritas NetBackup | DDomain ||Tools |OEM 11g/12c | TOAD | FogLight ||Additional |Trained in Oracle12C and GoldenGate, Knowledge of MS-SQL | Professional ExperienceTELUS COMMUNICATIONS INC., Burnaby, BC 2006 - 2016Senior Database Administrator, Operations and Application Development2011 - 2016Supported 60+ existing RAC / standalone databases and built new databaseenvironments for various vendors and internal applications. Performed GI /RDBMS installations, database creations / migrations, backups, recoveries,OEM monitoring, DR standby databases configurations, performance tuning,patching, and upgrading. Participated in on-call rotation. . Implemented interval partition on a fast growing table in Home Device Management (HDM) system application and developed auto maintenance mechanism to keep database size stable at approximately 600GB (from growing 1.2TB), resulting in improved performance. . Tuned full database backup of ~10TB Subex's Nikira Fraud system standalone database to complete in 7 - 8 hours, compared to 4+ days prior to changes. . Implemented and documented 'ASM Swing' method to migrate SAP BPC / BW RAC databases to new servers. Document was followed by DBA team members for other database migration projects, saving implementation time and maintaining a consistent process. . Tuned SQLs, improving efficiencies. For example: in TV orders system database, tuned SQLs resulted in running a query twice as fast; in HDM database, reporting process completed in 5 - 10 minutes (from being never completed after 3.5 hours); in SAP BPC / BW database, data loading process was completed in 52 minutes (from 10+ hours).Candidate's Name EMAIL AVAILABLE Page TwoTELUS COMMUNICATIONS INC. (Continued) . Was one of first members of DBA team to explore NetApp technology, successfully implementing NetApp SMO for HDM and later TOCP application databases. Set up backup notifications for emails, enabling full database backups to be completed within 5 minutes (regardless of size). . Set up complex database recovery of old HDM production databases within critical deadline, allowing peers to continue monitoring recovery until successfully completed and production database resumed in active mode.Senior Database Administrator, Technology and Operations 2006 - 2011Supported operational database administration tasks for external clients,including databases maintenance, patching, backups and recovery, andperformance tuning. Participated in various upgrade projects, includingApplication, Oracle RDBMS, and O/S upgrades. . Audited setups and fixed missing parts to stabilize database environments for high profile client ENABIL, reducing after-hour tickets volume by 29%. . Achieved result of 97.8% satisfaction score for overall response performance in DBA support. . Prime DBA role in successful migration of all POIM databases (supported by Ministry of Management Services of BC) to new environments supported by TELUS. Also, transferred knowledge of POIM databases to peers for ongoing support after migration. . Troubleshot ENABIL's databases' performance and developed a performance analysis template that helped team members follow procedures and create clear reports on database performance. . Upgraded ENABIL's databases to newer release of Oracle 10g, eliminating issues the application encountered related to previous release.TELUS SOURCING SOLUTIONS, Victoria, BC 2001 - 2006(Formerly Payroll Operations and Information Management, Ministry ofManagement Services, BC)Team Lead 2003 - 2006Senior Database Analyst / Oracle DBA 2001 - 2006Coordinated and supported database administration functions for PeopleSoft,Kronos, and J2EE applications and databases, including Oracle upgrading,patching, database refreshes, resolving application issues (databaserelated), developing and planning database resource strategies, policies,methods, and standards. . Re-designed data files' layout of POIM's PeopleSoft databases, improving performance by 20-30%. . Planned and coordinated PeopleSoft database upgrade activities in collaboration with application support team, contributing to seamless upgrade for application and databases. . Coordinated with Kronos resources to successfully create and implement new database environments for Kronos application. Education / Professional Development - Bachelor of Science (BSc), Major, Computer Science; Minor, Mathematics, SFU, Burnaby, BC - Oracle GoldenGate 12c Fundamentals, Exit Certified, Vancouver, BC - Oracle Database 12c: New Features for Administrators, Exit Certified, Vancouver, BC - Oracle EM 12c Grand Tour | Oracle Database 12c Upgrade | Oracle Security Hands-On Workshop | Oracle Database In-Memory, Oracle, Vancouver, BC - Oracle 11gR2: RAC and Grid Infrastructure Administration Accelerate, Exit Certified, Vancouver, BC - Oracle Database 11g / 10g: New Features for Administrators, Exit Certified, Vancouver, BC - Learning MS SQL Server 2014 from Oracle Experience, Microsoft, Vancouver, BC - Optimizing Oracle SQL - Intensive, Hotsos, Vancouver, BC - Oracle Certified Professional 8, 8i |
