Lead Database Engineer Resume

SUMMARY

Over 20 years of software engineering and database administration. Strong experience in Client - Server technologies, Object Oriented Analysis and Design, Internet and Intranet applications. Strong technical background in logical and physical data modeling, database development and administration, data warehouse planning and analysis.

TECHNICAL SKILLS

Databases: ORACLE 12c/11gR2/10g/9i, MS SQL Server 2008, PostgreSQL

Operating Systems: AIX 5L, Linux, CentOS v.4, Solaris 8, 9, Windows NT/2000/XP

Design Tools: ErWin, Rational Suite (Rational Rose, etc.)

Languages: PL/SQL, Python, JAVA, C/C++, XML, Unix shell

ETL Tools: Informatica, SQL Loader, Oracle external tables

Admin Tools: Toad DBA Suit, OEM,SpotLight

PROFESSIONAL EXPERIENCE

Lead Database Engineer, Cloud Architect/Developer

Confidential

Responsibilities:

As Lead DB Engineer re designed and handled existing financial application to comply with Money Market reform, which is set of rules issued by SEC for the management of money market funds to enhance the stability and resilience of all money market funds. Implemented software changes required for money market funds to move from a fixed $1 share price to a floating NAV.
Worked with product managers to give work estimates and advised on design.
Currently in charge of full functionality of Content Technology Group servers included calculation engine, data collection server (Oracle DB) and data points application used by Fund Research team.
Design and build cloud based software applications of Content Technology Group servers. Perform migration of existing software infrastructure to hybrid cloud solutions.
Developed scalable architecture for migration existing Oracle database and applications into AWS cloud based platform.
Optimized database model and SQL queries; identified database applications to migrate to NoSQL platform, increasing overall application performance.
Designed and developed serverless Lambda - based Python application.
Developed IAM custom policies to increase security controls.
Designed and applied secure network VPC architecture.
Provided DirectConnect setup between AWS and company datacenter and established backup/recovery strategies for hybrid cloud environment including AWS Storage Gateway and different tiers of S3.

Oracle 11g DBA/Developer

Confidential

Responsibilities:

As Oracle developer designed and created new modules for centralization of financial report system. Worked with product managers to give work estimates and advised on design. Fixed bugs and implemented enhancements within tight deadlines.
Created logical backup using Oracle Data pump utility. Optimized and modified the triggers, complex stored functions, procedures, packages etc. Experienced with full life cycle software design and development on OLAP systems, Oracle ETL and performance tuning. Provided SQL statement analysis and tuning, created jobs to automate repetitive tasks.
Provided storage analysis and allocation.
Developed object models and class diagram for major components of billing system.
Design and implementation of new product databases
Initial build script development and maintenance Implementation into production database

Oracle 11g DBA

Confidential

Responsibilities:

As DBA developed scripts for embedded installation and configuration of Oracle 11g Real Application Cluster with ASM storage on Linux 64-bit environment. There are 3 Node clusters that support 10k connections.
Backups, exports and imports, archiving old records and verification of such processes
Periodic trimming of Oracle system log files and removal of old redo log archives
Backup and recovery via RMAN scripts and troubleshooting Monitoring of Oracle database; automated error notification
Gathering of cost-based optimizer (CBO) statistics for tables with stale statistics (performance tuning)
Developed object models and class diagram for major components of billing system.

Oracle DBA/developer

Confidential, New York

Responsibilities:

Going through the clients' requirements and coming up with database design and financial application architecture. Created materialized view for data warehouse purpose.
As Oracle developer migrated various legacy system data to Oracle by analyzing requirements, preparing specifications, designing, coding and testing. Project completed ahead of schedule.
Provided system support to a highly customized procedures and packages in order to deliver Oracle data to programs, systems and reports.