Bioinformatics Software Engineer / Principal Database Analyst Resume

SUMMARY

15 years experience in different aspects of Oracle administration
Certified Oracle 8/8i/10g/11g/12c Database Administrator.
Certified Oracle 11g Associate.
Certified Sun Solaris 7 Administrator.
Successfully completed ITIL v3 Foundation, ITIL Service Operation certifications.
3 years experience in software development, maintenance and support.

TECHNICAL SKILLS

Operating environments: Sun Solaris, Linux Red Hat, AIX, Windows, MVS.

DBMS: Oracle 7 - 11,, MySQL, MS Access, DB2.

Languages: SQL, PL/SQL, bash, VB, perl, C.

Tools: RMAN, Patrol, Toad, OEM, Data Pump, SQL*Loader, SQL Trace, PuTTY, AWR, DBArtisan, ER/Studio, Change Manager.

PROFESSIONAL EXPERIENCE

Confidential, Durham NC

Bioinformatics Software Engineer / Principal Database Analyst

Responsibilities:

Proficient in performance evaluation/tuning and troubleshooting
Identified and resolved performance issues across the federated and distributed database infrastructure ( applications, queries, ETL, materialized view refresh, dml ).
Installed, configured and maintained Oracle databases (7.2 through 12.1) on Solaris/Linux/AIX platform.
RMAN backups ( NetBackup, EMC DD, NetApp): configuration, monitoring, troubleshooting. Performed database cloning, recovery, refresh, relocation.
Data Guard: configuration, monitoring, troubleshooting.
Managed databases upgrades and patching.
Performed ITCP testing for mission critical databases.
Databases on RAC, SIO Clusters: creation, configuration.
Installed and configured Transparent Gateways to MS SQL Server s databases.
Developed and implemented UNIX scripts to perform monitoring and reporting tasks.
Performed schema reorganization, capacity planning, resolved capacity issues ( including archiving errors).
Maintained high support levels for Core product releases, including schema design, review, and management.
Designed and managed Oracle Text, Private Virtual database, Multi - Master Replication, Workspace Manager, Oracle partitions, materialized views.
Took part in reviewing logical models of in-house created applications and implemented physical models.
Developed PL/SQL code to satisfy business rule requirements for projects coding (functions, packages, triggers).
Managed corporate security system (including FGA) and auditing.
Performed migration/transformation schemas from other DBMS (Sybase, PostgreSQL, and MySQL) to Oracle.
Performed installation and upgrades third-party products: Sequenom, Nautilus, Galileo, NuGenesis
Provided support for the other third party products, including: NuGenesis80, Aesop, eTrack, eLNB, PACE, Oracle Clinical.
Performed numerous presentations for R&D users.

Confidential, Raleigh NC

Software Engineer

Responsibilities:

Maintained and administered Oracle 8.1. 7.x on UNIX platform for Confidential .
Took part in creation of logical and physical models for new applications (using ER/ Studio).
Created new, managed existing schema’s
Performed databases monitoring and tuning (using DBArtisan, DBA scripts, and scheduled cron jobs).
Performed tuning SQL statements and SQL, PL/SQL coding. Assisted with writing effective sql and pl/sql.
Created number of DBA scripts cron jobs for databases monitoring.
Performed troubleshooting for production.
Performed installation third-party products: Applied BioSystems Sequence Collector, GCG SeqStore.
Performed Oracle schemas migration from 7.3.4 to 8.1.7.
Schemas reorganization, capacity planning, actual space consumption for tables, partitions, IOT.

Confidential

Programmer/Analyst

Responsibilities:

Participated in development Accounts Receivable System for Nortel Telecom in Easytrieve 6.2: JCL, coding, testing, documentation, created macros.
Participated in development of medicine studies system for Lilly in Visual Basic 6.0, Oracle 7.3: customer information collection system (creating forms, data validation, database building).
Took part in expansion project for Merrill Lynch: COBOL (online), BMS maps, JCL (modification, testing).
Took part in several internal projects using Java and Smalltalk.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship