 |
Resume
Personal Summary:
Database specialist seeking to further experience as an Oracle Database Administrator (DBA) and/or Developer.
Proficient with database maintenance, database tuning, SQL tuning, SQL development, PL/SQL development.
Understands the needs and philosophies of the business. Considers many perspectives, focuses on efficient solutions.
Work Experience:
| Industry: Financial |
Job Title: Database & Network Analyst |
Responsibilities:
- Administer local Oracle 10g, SQL Server 2005 on Windows 2003. Maintain backups with Oracle RMAN and SQL Server backup.
- Maintain Oracle Production, UAT, and testing environments for transactional pension administration database. Apply vendor scripts, aid user's with testing scenarios, comparison of data.
- Administer Windows 2003 Network: Active Directory, Exchange 2003, Blackberry Enterprise Server (BES), file & print, IIS, Windows Server Update Services (WSUS), McAfee ePolicy Orchestrator antivirus; Windows 2003 servers, Windows XP desktops
- Administer CentOS linux (RedHat clone) servers running Apache, MySQL, Samba for internal intranet services, web site development
<--
- Administer VMware Infrastructure 3 Enterprise running ESX 3.5 hosts with iSCSI SAN
-->
Accomplishments:
- Upgrade transactional database from Oracle 8i to Oracle 10g
- Initiated and led project to move from physical server environment with local disks to a virtualized environment (VMware) with shared disk storage (SAN)
| Industry: Global Trade/Customs |
Job Title: Database Administrator & Developer |
Responsibilities:
- Administer local DBMS and OS for: Oracle 9i & 10g on Windows 2003 and Linux platforms, SQL Server 2000 on Windows 2003. Maintain backups for databases using Oracle's RMAN and SQL Server backup. Implement and test database and OS upgrades, testing first in development and promoting through to production.
- Coordinate all database related development (tables, indexes, constraints, procedural code, etc.), ensuring developers are aware of changes to shared database objects and help minimize impact on each other's projects.
- Build update scripts to update schema and data as needed when new application builds are released to clients. Clients run scripts on their own local database, so scripts need to be built to minimize errors, handle those that do occur gracefully, and allow for scripts to be executed repeatedly without error.
- Remotely support database components after deployment to client sites on Oracle 9i and SQL Server 2000.
- Develop and maintain all Oracle PL/SQL code.
- Develop SQL Server procedures as needed.
- Assist development team with SQL tuning and database tuning on both Oracle and SQL Server.
Accomplishments:
- Developed new database development processes to be followed by the development team which simplified database changes for individual applications. This allowed for each application to be developed independently of one another using it's own branch copy, and then merged back with the main tree when ready for release.
- Built framework for maintaining documentation of tables, columns, procedures. Worked with members of development team to populate and maintain the documentation.
| Industry: Music and Entertainment |
Job Title: Project Leader, Business Solutions, IS&T |
Responsibilities:
- Maintain and develop Oracle 10g Database server. OLTP & Data Warehouse (DSS) systems.
- Maintain several datafeeds in and out of the system with internal, corporate, and 3'rd party systems.
- Prioritize and manage multiple projects and tasks directly with departmental managers, executive team, and 3'rd party partners.
- Develop and maintain reporting tools (using SQL, Access, Excel, VBA, perl) for Sales, Marketing, Finance, Production and other departments.
- Maintain and develop several internal Access based databases including product catalogue, performance numbers, scheduling, and contacts.
- Manage Unix based servers (SUSE Linux, FreeBSD) and services (DNS, FTP, SMTP, Web)
- Support Network & Desktop team with technical support, monitoring, and troubleshooting for desktops, network, active directory, vpn, remote desktop, and all other infrastructure technologies.
- Point of Contact for company's B2B site for technical issues.
Accomplishments:
- Migrated Oracle 8i, MySQL, and Access databases to a single Oracle 10g platform.
- During merger process of Sony and BMG, brought together Sales, Catalogue Management, and Marketing Commentary tools into common reporting tools months before the backend systems were brought together.
- Heavily involved with merger of other local and worldwide systems including Intranet, label copy (extended product detail), production & distribution system, royalties and digital delivery.
- Introduced digital product concepts (think iTunes, cellular ring tones, etc.) to existing systems, adapting tools and training users on changes as appropriate.
- Received performance award for contributions towards upgrading store check procedures. Working with members of sales and a 3'rd party provider sales reps can now access up-to-date product and performance information on product while in stores with portable tablet computers.
- Identified need for an easy to use yet secure file transfer mechanism. Developed a secure website which makes it easy to transfer any size of a file (as opposed to email) and without any logins or passwords (as opposed to FTP).
- Received performance award for developing an in-house database solution to mirror selected information from company's data centre. Access and Excel based front ends were developed for reporting for fast data access and flexibility.
- Received performance award for developing company Intranet site with built in content management tools.
|
Education, Certification, & Professional Assocations:
Oracle - Oracle Database Administrator
Completed Oracle 10g Backup & Recovery Workshop in 2008
Oracle Database 10g Administrator Certified Professional (OCP) achieved in 2007
Completed Oracle Admin Workshop II in 2007
Completed Oracle Admin Workshop I in 2006
Completed Oracle SQL Tuning Workshop in 2006
VMware - VMware Administrator
VMware Certified Professional (VCP) achieved in 2008
Completed VMware Administration Workshop I in 2008
Mohawk College - Diploma Program
Computer Science Technician - Networking and Hardware 1998-1999
Primary Skillsets with Summary:
Databases
| Oracle (9i, 10g) |
4 years, DBA, developer, small installation with OLTP & Warehouse instances, 50 users, 20 gigs |
| Oracle tools |
4 years, SQL*Plus, SQL*Loader, exp, imp, datapump, listener, net services, OEM, TOAD, SQL Developer |
| MySQL |
9 years, DBA, developer, small warehouse instance, 50 users, 10 gigs |
| MS Access |
5 years, DBA, developer, most backends migrated to Oracle |
| SQL Server (2000, 2005) |
2 years, DBA, developer, supporting small database (1gig) for deployment to client's site |
| SQL Server tools |
2 years, Enterprise Manager, Query Analyzer, bcp, osql, sqlmaint, Jobs |
Languages/Development
| SQL |
9 years, SQL Tuning, Explain Plan, DDL |
| PL/SQL |
4 years, Triggers, Packages, Functions, Procedures |
| perl |
9 years, developed custom Intranet w/ CMS, mod_perl, batch jobs, Unix and Windows |
| shell |
9 years, including bash, csh, vbscript/cscript, dos batch, powershell (monad) |
| VBA |
5 years, Primarily DAO, check forms in Access, build custom reports in Excel |
| HTML |
8 years, HTML 3,4, XHTML, limited CSS, ECMAScript (JavaScript) |
System Administration
| Unix |
9 years server support w/ FreeBSD, SUSE Enterprise (SLES), CentOS (Redhat based), services include Tomcat, Oracle, MySQL, Subversion, Apache, netfilter, DNS, FTP, SMTP, packet filtering, NAT, networking monitoring (Nagios) |
| Unix tools |
8 years, vi, grep, pipes, bash, tcsh, perl, cron, nfs, samba |
| Hardware |
10+ years, x86, x64, RAID, SCSI, SAN, hardware based VPN, firewalls |
| Windows Desktop |
10+ years, Windows 9x through XP Professional, troubleshooting desktop issues, connectivity/network problems, MS Office 9x through XP |
| Windows Server |
5 years, networking, active directory, exchange, file and print; 2 years managing Windows 2003 server for database server, backups |
|
|
|