SUMMARY:

• Eighteen years of Oracle database administration and design, excellent written and oral communication, extensive experience in project handling and teamwork
• Extensive experience in physical and logical database design, documentation, 24x7 production support, performance tuning, installation, configuration, upgrades, patches, backup and recovery, cloning, space management, database security, access control, data centre migration

TECHNICAL SKILLS:

Oracle: Oracle (11g, 10g, 9i, 8i, 7, 6), RAC, Real Application Testing, Golden Gate, Shell Scripted Hot Backup, RMAN, NetBackup, ASM, DataGuard, Partitioning, Advanced Replication, Kerberos Authentication, 10g Grid Control, 12c Cloud Control, Oracle Advanced Security, Audit Vault, Database Vault, Transparent Database Encryption, Virtual Private Database, NetApp Snap Manager for Oracle, CA Unicenter Monitoring

Languages: PL/SQL, SQL, Korn Shell, PowerBuilder, Developer/2000, Visual Basic, FoxFro, Clipper, C, COBOL

Operating Systems: AIX, Solaris, HPUX, Windows, Netware

PROFESSIONAL EXPERIENCE:

Senior DBA

Confidential

Responsibilities:

• Key resource for upgrading all databases from Oracle 9i, 10g to 11gR2
• Key resource for completing corporate data centre consolidation after several major acquisitions on aggressive timeline
• Wrote and presented to group detailed administration manuals for new environments as part of deliverable before system go - live which allowed for effortless hand-over of environments to operations team
• Developed and applied standards to database and operating system during data centre consolidation resulted in 80% reduction in production incidents and 50% reduction in administration effort post go-live
• Streamlined procedures for adding new external clients to a VPD in reporting databases with detailed documented steps and scripts resulted in significant time savings and error elimination
• Received written accolades from client for streamlining client environment upgrade procedures with accurate steps and scripts resulted in zero incident upgrade and unprecedented client satisfaction
• Successfully installed and configured production RAC environment for major Canadian bank (CIBC)
• Supported 24x7 production environment and assumed on-call responsibility on rotational basis
• Performed software installation, backup, restore, recovery, sizing server hardware, user security management, physical design, production system monitoring and tuning, process documentation, access control, security(database hardening)
• Worked with Change Advisory Board by adhering to ITIL standards in implementing production changes
• Participated in application design and SQL tuning
• Participated in development life cycle from functional requirement to production release
• Liaised with vendors, end users, developers, management and other support group
• Cloned production environments and participated in testing in each upgrade cycle
• Participated in upgrades of databases from version 7, 8i, 9i,10g to the current 11g version

Confidential

Responsibilities:

• Developed backup program using UNIX scripting with robust configurable options, error handling and notification. Eliminated disparate backup methods that required extensive manual intervention.
• Developed automated monitoring system using Unix scripting and SQL that alerts DBA in 24 by 7 which helped reduce downtime and eliminated tedious manual checking
• Developed script library for billing group to allow controlled SQL execution in order for company to meet security audit
• Developed staging environment for billing group to allow secure updating of product pricing with audit trail to allow company to meet security audit
• Worked on project to replicate data among three manufacturing databases in real time using Advance Replication
• Worked on project to Web enabled order entry in area of Data Modelling and on-going data synchronization
• Developed automated standby database log apply using Unix scripting for Oracle 7.3.4
• Wrote PL/SQL procedures and packages in collaboration with development team where required
• Automate business tasks using UNIX scripting in conjunction with SQL and PL/SQL
• Developed and administered data extract and transformation modules between different functional areas

Senior DBA

Confidential

Responsibilities:

• Performed software installation, backup, restore, recovery, sizing server hardware, physical design, production system monitoring and tuning
• Configured Unix machines(AIX, HPUX, Solaris, DGUX, SCO) in preparation for Oracle installation
• Participated in upgrade of all client databases from Oracle 6 to Oracle 7
• Liaised with clients, developers and management

DBA/Programmer/Analyst

Confidential

Responsibilities:

• Created new database in Oracle7 for migration from Oracle6 to Oracle7
• Completely redesigned database structures as part of migration using export and imports
• Designed and maintained security system for flexible and easy administration
• Extensively remodeled and tuned system data which resulted in much improved performance
• Implemented database triggers to enforce critical business rules
• Worked with end users to produce functional specifications
• Employee expense recording and reimbursement in multiple currencies
• Created Invoice module for billing in any number of currencies
• Converted character based application into GUI
• Turned application from single currency into multiple currency system

Confidential

Programmer/Analyst

Responsibilities:

• Unlimited flexibility in applying rules to the claims and adjudication engine
• Allow for setup of different benefit groups within an organization
• Automated cheque printing and explanation of benefits
• Direct deposit into client bank accounts
• Flexible reporting of financial and statistical data by way of ad hoc querying
• Automated generations of billings and commissions
• Payments reconciliation

Programmer/Analyst

Confidential

Responsibilities:

• Commission program for securities brokers
• Program to analyze relationship between price, yield, and duration for bonds
• Program for determining gains/loss from securities trading for individual client accounts
• Program to chart the price, volume, moving average and relative strength for individual stocks
• Helped developed an institutional client tracking program for use by traders to better manage activities of clients’ accounts and therefore reduce errors and maximize profits.

Programmer/Analyst

Confidential

Responsibilities:

• Developed Client functions for Client/Server System using RBASE(SQL)
• Designed and implemented Relational Data Files, Data Validation Algorithms, Selections Menus etc...
• Developed Management System using Clipper and dBASE
• Implemented inventory tracking and reporting capabilities
• Developed service call tracking system for on-call technicians
• Provided on-going maintenance and improvements