Database Developer Resume
TECHNICAL SKILLS:
Software Languages: SQL, PL/SQL, UNIX/Linux shell scripting, Python, XML, C, C++, HL7.
Software Tools: Oracle RDBMS 9i/10g/11g, Oracle RAC, ASM, SQLPlus, Oracle Data Pump, OEMRMAN, TOAD, Oracle SQL Developer, Amazon Redshift, Amazon S3, PostgreSQL, Vertica, AWS Pipeline, Talend, Tableau, Visual Studio C++, Access, Eclipse, VMWare, WinCVS, SharePoint.
PROFESSIONAL EXPERIENCE:
Confidential
Database Developer
Responsibilities:
- Create and maintain test and production AWS Redshift and PostgreSQL databases
- Utilize AWS Pipeline for ETL of Amazon S3 data to Redshift
- Create database views to interface with Tableau and internal reporting tools
- Troubleshoot database and ETL data integrity issues
- Assist development teams with writing queries, views and SQL commands
Confidential
Database Developer
Responsibilities:
- Designed and modeled database structures for data analytics
- Installed and maintained test and production PostgreSQL databases
- Created and executed ETL jobs connecting Talend to databases
- Created database views to interface with Tableau reports
- Wrote Python scripts to augment ETL process
- Global Knowledge May 2013 - Sept 2014
- Oracle Database Administrator
- Applied patches and executed Oracle 11g upgrades to 9i and 10g databases
- Created and modified PL/SQL packages, procedures and functions
- Troubleshot databases and query performance issues
- Wrote CRON jobs in bsh on LINUX for Oracle database
- Created SQL queries and Cognos reports for Project Management
Confidential
Oracle Database Administrator
Responsibilities:
- Executed Oracle imports, exports, backups and installs
- Diagnosed and correct problems with Oracle Advanced Replication
- Used SQLPlus and SQL Developer for daily duties
- Performed database upgrades and clone development and ASM databases.
- Created LINUX shell scripts for RMAN database backups
Confidential
Oracle Database Administrator
Responsibilities:
- Lead DBA on Thomson Reuters’ Charge Capture project
- Maintained standalone and Oracle RAC test and production instances
- Added nodes to RAC clusters and troubleshot RAC issues
- Designed, wrote and modified Oracle database tables, views and procedures for new and existing company products
- Created and maintained database builds
- Installed, maintained and tuned inhouse development databases
- Performed Oracle imports and exports dictated by development needs
- Collaborated with crossfunctional teams within company using Agile software development methodology
- Internally supported test and production environments using Red Hat Linux servers
- Utilized Oracle Job Scheduler to load data and Oracle monitoring to monitor data and compile information
Confidential
Database Administrator/Developer
Responsibilities:
- Installed and maintained more than 200 production and test databases for external customers
- Responsibilities included daily monitoring of customer databases installing Oracle software and patches creating databases for new customers and performing database tuning to maintain performance benchmarks.
Implementation Engineer
Confidential
Responsibilities:
- Integrated Confidential software with existing Hospital Information Systems
- Wrote Python and C++ functions to enable integration of new customers’ systems.
Customer Support Engineer
Confidential
Responsibilities:
- Lead engineer on Confidential Customer Support team. Diagnosed and repaired customerreported problems with software and database configurations.
Confidential
Software Engineer
Responsibilities:
- Level 3 support of Confidential ’s NetView and Tivoli Decision Support
- Fixed C++ bugs reported by Level II support
- As Database Interface Engineer for Tivoli Decision Support, installed, maintained and tuned Oracle, DB2, Sybase and Informix databases on AIX and SUN Solaris platforms