We provide IT Staff Augmentation Services!

Oracle - Db2 Database Administrator (dba) Resume

SUMMARY

  • Over 20 years of IT experience, including 2 years as a DB2 DBA in production environments on z/OS platforms and 2 years maintaining Oracle 10/11g on Linux platform.
  • Ensure database management systems operate efficiently.
  • Familiarity with several SDLC methodologies for database architecture and design.
  • Equally effective working on self - managed projects or as a team member.
  • Recognized as a practical problem-solver willing to assume increased responsibility.
  • Ability to adapt quickly to challenges and changing environments.
  • Project Planning and Management training.
  • Knowledgeable in Help Desk/end-user.
  • Ability to coordinate multiple projects.

TECHNICAL SKILLS

Databases: DB/2 10 & 11, Oracle 10g, 11g & 12c, SQL Server 2000 & 2005, MS Access

Programming Languages: JAVA 2, HTML, PL/SQL, T-SQL

Environment: s: Windows 95, 98, NT, 2000, XP, Vista, 2007, Windows 2000, 2003, 2008 Server, UNIX, Red Hat Enterprise Linux 4 & 7 and z/OS

Applications: Visio, Oracle Enterprise Manager, Microsoft Office Suites Pro/SBE(Word, Excel, PowerPoint, Access, Project, Outlook) Front Page, Label Matrix, Gentran, EDI Bridge, HP Jet Admin, Vantive, AS 400, BTS Tracking, Cisco VPN 5000 Client, Platinum SQL ADM 6.02, eBackOffice v7.25 & eWarehouse v7.25 by Epicor Software Solutions, WinPaK & Pro-Watch (Security Software), Windows® Powered Pocket PC, Loftware, Ipswitch’s IMail Server v7.13, MS Exchange 2003 & 2007, Crystal Reports 10, Veritas Backup Exec v8.60, McAfee ePolicy Orchestrator, Symantec Ghost 8.0, IBM Data Studio

Tools: Oracle Enterprise Manager, BMC Tools, IBM Tools and Utilities, TSO/ISPF, SPUFI, RMAN, ASM

Networking: TCP/IP, DNS, DHCP, WINS, VPN and Active Directory Administration

PROFESSIONAL EXPERIENCE

Confidential

Oracle - DB2 Database Administrator (DBA)

Responsibilities:

  • Responsible for implementing Oracle 12c Data Guard and Data Guard Broker as part of Disaster Recovery plan.
  • Instrumental in the upgrade and migration of data from Oracle 11g to Oracle 12c.
  • Instrumental in researching the security processes for Oracle 12c Database Vault.
  • Responsible for installing and configuring Oracle 11g ASM and Oracle 11g Databases within a test environment during Oracle Database Vault testing.
  • Effective in utilizing OPatch tools to ensure all Oracle databases were properly patched.
  • Query Oracle database structures utilizing SQLPLUS, PuTTY and Oracle SQL Developer tools.
  • Responsible for implementing Oracle 12c Transparent Data Encryption (TDE) Tablespace Data Encryption as a security measure in protecting sensitive data.
  • Coordinate customer requests for project support on Mainframe DB2 databases, working successfully to manage all facets of assigned database creation or modifications.
  • Utilize JCL, TSO ISPF, BMC Tools and IBM Data Studio as a means for analyzing database design and maintenance.
  • Effectively manage the control, integrity and accessibility of database file structures.
  • Effectively manage the support for project implementations.
  • Responsible for approving database design specifications, providing physical data modeling, and design services.
  • Create and maintain entity relationship diagrams to support new business processes and customer requirements.
  • Perform basic tuning of SQL queries running on DB2 for z/OS utilizing BMC SQL explorer and IBM Data Studios.
  • Monitor production JCL jobs utilizing IBM tools and utilities such as EJES and $AVRS.
  • Query DB2 database structures utilizing BMC’s Catalog Manager and SPUFI.

Confidential

Security Officer

Responsibilities:

  • Effectively provide excellent customer service by assisting the customer with numerous tasks over the telephone and in person.
  • Adept at handling emergency situations effectively.
  • Responsible for patrolling the premises of buildings to detect suspicious activity, assist tenants, and ensure the safety of occupants.

Confidential

Oracle Database Administrator (DBA)

Responsibilities:

  • As coursework, effectively performed RMAN backups, recovery procedures and performance monitoring of Oracle database 11gR2.
  • As coursework, efficiently multiplexed and maintained Oracle control files, redo log and archived log files.
  • As coursework, configured and created ASM disk groups for Oracle DB install.
  • As coursework, installed packages, procedures and functions.
  • As coursework, designed and maintained Oracle database within a RHEL 4 environment.
  • As coursework, planned and implemented all facets of backup and recovery utilizing RMAN as well as the recovery catalog.
  • As coursework, created and modified database components to include tablespaces, tables, listeners, indexes and user accounts.
  • As coursework, utilized Oracle Enterprise Manager as well as the command prompt to monitor database performance and query the database.

Confidential

Technical Support Engineer

Responsibilities:

  • Effectively performed database conversions (i.e. Access to SQL) for mid-size to large customers.
  • Effectively performed data imports on various database platforms (i.e. Access, SQL, and Oracle) using a variety of database tools (i.e. SSIS, DTS, Oracle Datapump) to assist customer with loading data.
  • Adept at setting up and configuring customer databases - Oracle, SQL, or Access - and import data for setup.
  • Coordinated customer requests for technical support on software and hardware, working successfully to manage all facets of assigned customer installations.
  • Used Crystal reports to create and modify simple to complex reports for various database platforms.
  • Managed all facets of assigned customer installations.
  • Imported/restored dump files to Oracle 10g R2 table spaces.
  • Monitored, maintained and provided basic administration for several SQL 2005 replication severs.
  • Queried Oracle, SQL and/or Access databases during troubleshooting.
  • Documented all support tickets in our application, including corrective action, closure comments.
  • Responsible for adding information to the online Knowledge Base.
  • Assisted Junior Technical Support Engineers with support calls.
  • Trained clients on the CribMaster software creating necessary training documentation for each client.
  • Modified, tested and delivered custom Crystal Reports to customers.
  • Worked with development to test CribMaster software and report any needed enhancements and/or bugs.
  • Worked with sales to help define technical requirements for installations or custom CribMaster designs.

Confidential

Network Administrator/Desktop Support

Responsibilities:

  • Ensured constant availability of company resources including servers, workstations, laptops and printers.
  • Administered, installed, configured multi-server Windows NT/ 2000/2003/2008 LAN.
  • Administered, maintained and configured 3Ware SATA Raid Controller.
  • Administered, maintained and configured PC workstations and printers.
  • Maintained and applied appropriate security patches and upgrades.
  • Maintained and configured Cisco 7940 VoIP Telephones.
  • Configured, maintained and supported Linksys Wireless Access Points.
  • Administered, maintained and configured SonicWall Firewall.
  • Configured, maintained and supported Netgear GS748T Switches.
  • Installed Oracle 10g R2/11g R1, creating table spaces, tables and user accounts.
  • Installed/configured SQL Server 2000/2005.

Hire Now