Sr. Database Developer Resume
2.00/5 (Submit Your Rating)
OregoN
TECHNICAL SKILLS
- MS Office tools,
- Oracle pl/sql, Postgres PGSQL,OOPL, Visual Basic, Unix tools, T - SQL
- Jira, MS Project
- Oracle 6-12, PostgreSQL, MS SQL Server
- GIT, Stash, Jenkins, Oracle Apex, Crystal Reports, Business Objects, Informatica, Tidal,Datastage,Siebel
- Unix, MS Servers
- Agile, Waterfall, Scrum, Software Development Life Cycle, Kanban
PROFESSIONAL EXPERIENCE
Confidential, Oregon
Sr. Database Developer
Responsibilities:
- Stepped into other roles as needed to get teamwork done .
- Refactered DDL to take advantage of the differences between the two RDBMSS.
- Maintained Oracle system wif changes while developing the Postgresql one.
- Systems ran in parallel before switching over.
- The PostgreSQL Environment is active/active data centers vs Oracle wif Datagauard. o Designed and implemented Monitor Database and processes for Reporting system in an active/active environment. Proactive alerts, pinpointing of issues, and historic process time monitoring decreased response time to potential issues wif few false positives .
- The queueing system did not guarantee delivery in the same order to the two data centers. Designed a system to detect messages that made it to one data center but not the other while keeping false alarms - out of order messages - to a minimum.
- Implemented other monitors - historic process times, queue failure and sub-performance monitoring.
Technical Environment: Centos, Oracle RDBMS, PostgreSQL,Stash, GIT, Jira, Confluence,Oracle OEM,sqitch, pgtap,PagerDuty
Confidential, Portland, Oregon
Sr. Database Application Developer
Responsibilities:
- Used Oracle Advanced Queueing to level OLTP workload. Improving customer’s web experience.
- Created internal support/reporting applications wif Apex - Developers could concentrate their resources elsewhere enhanced Support and Management productivity and access to vital information.
- Enabled sales people to research comparables to increase sales.
- Encapsulated business logic using Oracle’s object types and collections to separate service and presentation layers from schema changes. Enhanced Java Engineer’s Productivity. o Worked on “Buy it now” and “Make an offer” functionality.
- Added additional channels to sell domain names. Enhanced sellers appeal to our platform.
- Database side of for the workflow for customers to submit names for live auctions.
- Sales to review etc. Increased revenue and company competitiveness. o
- On Call Rotation
Technical Environment: Oracle 10,11. Solaris x86, Centos. Subversion, pl/sql, Java, Oracle Apex, Oracle OEM, Oracle ASM, Oracle RAC.
Confidential, OR
Productivity and Support Engineer
Responsibilities:
- Investigated, determined root cause, and identified fix. Critical performance issue.
- The issue prevented medical personnel from using the system for extended periods of time.
- The fix took 4 man hours and improved system performance 4 X. reduced system resource usage by two thirds.
- Allowed co-branding of our application.
- Multiple language installation support.
- Simplified Oracle DB install to allow non-technical personnel to install in an ambulatory care environment.
Technical Environment Netware, MS NT Server, OS2,, Oracle 6 - 7, Toolbook, InstallShield, Visual Basic, DOS, C/C++, PL/SQL .OOPL internal language (WYSCRIPT), FORTRAN 77
