OBJECTIVE:

I seek an Oracle database and ETL position in the NYC financial industry using my excellent 12c/11g database, Oracle ODI, GoldenGate, Business Intelligence, and financial industry skills.

SUMMARY:

• Expert Oracle and SQL server DBA with excellent MongoDB, Teradata skills; and very good data integration experience using Oracle Data Integrator, Informatica, SSIS, and DataStage
• Built major Enterprise Data Warehouse from small prototype to production system for large state Bank, system architect for award winning Bank's data vault as replaced all data systems
• Have held senior positions with a history of excellence in finance and environmental IT with Confidential, the Confidential, Confidential, software industry, and major banks
• Recognized internationally, winning awards including from MacArthur Foundation, Utne, and Google, for “visionary” use of IT and networked databases for the environment
• Published ecological science proposing new theories on biosphere based on data science

WORK EXPERIENCE:

Vice - President, Oracle Development DBA

Confidential, New York, NY

Responsibilities:

• Developed complex Oracle SQL queries and PL/SQL stored procedures, obfuscated data, reviewed and helped create data models, and optimized Java code's access to data. Peer reviewed SQL code and led database deployments coordinating a large global team.
• Responsible for troubleshooting complex production database issues using Oracle AWR and ASH data, identifying problems including with schemas and RAC clustering, and providing solutions. Proficient in Oracle Advanced Queue. Good knowledge of GoldenGate, Oracle NoSQL, and Oracle Big Data SQL.
• Worked with Splunk, MongoDB, and Oracle NoSQL; and independently learned Python, Hadoop, Kafka, Spark, and blockchain. Familiar with corporate action and compliance datasets. Tracked developments and learned new skills in the Oracle ecosystem, data science, machine learning, and Fintech. Prepared for Oracle certification exams, to be taken shortly.

Lead Oracle Database Administrator

Confidential, Honolulu, Hawaii

Responsibilities:

• Architected, setup, and managed two new Oracle 2-node 12C RAC clusters with Disaster Recovery using RMAN and Avamar. Well versed in setup and use of Enterprise Manager, RAC, Grid Control and Data Guard technologies. Knowledge of GoldenGate replication.
• Successfully architected large enterprise SQL Server cluster using Hyper-V to create a private cloud containing all current SQL Server versions leading team under a tight deadline. Strong expertise in SQL Server AlwaysOn and Windows Clustering across all versions.
• Lead DBA in the building of a new Data Vault, including optimizing the databases and marts as supported Oracle ODI and InfoSphere DataStage ETL, data modeling, and other processes. Set up two new Teradata appliances implementing massively parallel processing for a large marketing data mart. Provided data science inputs for use of Experian credit data.
• Supported databases for numerous reporting platforms including MicroStrategy, Business Objects, Microsoft Reporting Services, and Oracle BI Enterprise Edition. Managed and supported database back-ends for hundreds of financial applications including Microsoft Sharepoint and Dynamics CRM databases. Learned Linux administration.

Senior Database Administrator

Confidential, Madison, Wisconsin

Responsibilities:

• An expert using Microsoft SSIS, and excellent skills with Informatica. Staged and loaded data warehouses specializing in Oracle and SQL Server integration. Conceived and built OLAP analytical cubes including a loan origination star-schema using SSAS. Created and supported risk models, and reporting on marketing and Bank reserves for fast self-service BI.
• Microsoft SQL Server and Oracle database administrator and developer, designing complex data views and stored procedures. Programmed complex queries and views, and stored procedures in T-SQL. Used PowerShell, .NET, Sharepoint and basic Java programming.
• Tableau software administrator and developer. Worked extensively with business to match business requirements with existing data systems, designed views into data joined from numerous systems, creating dashboards and data visualizations with Tableau and SSRS. Profiled and integrated industry-standard investment databases. Highly proficient in the financial industry business IT needs, including major vendor banking systems.
• Project managed migration to new SQL Server 2012 servers for the EDW, feeding 3rd party data from there into the Bank's core. Designed, updated, and managed SQL Server hosts. Setup and automated data into a Windows based Oracle database. Experience with Sybase.

Data Scientist

Confidential, New York, NY

Responsibilities:

• Constantly learn and implement new technologies. Developing big data products including a Nutch based search engine using Hadoop Streams with Python, Spark, MongoDB, ElasticSearch, Kafka, HBase, Sqoop and Hive. Use Oracle ODI for ETL, having migrated from version Oracle 11i to Oracle 12c. In past used SQL Server 2014 and VB.Net. Five years of experience using AWS cloud with high proficiency.
• Internationally recognized as leader in the use of the Internet for communication that facilitates ecological conservation outcomes. Long history of innovation in advocacy on behalf of climate and forests on the Internet including establishing the Internet's first blog.
• Publish ecological science. Carry out international public information campaigns on behalf of environmental sustainability; write press releases, feature articles and blogs.

Database and Network Administrator

Confidential,, Madison

Responsibilities:

• Project managed the redesign of the Wisconsin State Herbarium's legacy databases into SQL Server, a web based botanical information system with online GIS, including supervising large team of programmers and database design for this massive and complex dataset.
• Responsible for all aspects of IT and network infrastructure and configuration for this large University department with 400 users and 8 servers; including departmental online and web-enhanced course development, web design, and Oracle database support.
• Planned, implemented and maintained department web sites and Windows servers, IIS and large Active Directory. Designed, built and managed new server farm, switches and routing, and Ethernet wiring. Managed network security and provided technical support.

Project Manager

Confidential, Washington, DC

Responsibilities:

• Supervised, wrote terms of reference, and integrated output from two-dozen consultants; wrote briefing documents for government ministers, prepared complex project technical documents, and negotiated with civil society, government and industry. Managed production of PNG's Biodiversity Conservation Strategy and Action Plan.
• Raised and managed over $18 million in funds for project design and implementation. Established a trust fund for landowner conservation. Successfully brought forest conservation project through Bank board approval.

GIS Researcher

Confidential, Madison

Responsibilities:

• Researched and developed methods to map forests, biodiversity and other ecological elements for land use planning and biodiversity protection in the Great Lakes bioregion.
• Researched and implemented methods to interactively display GIS maps over the Internet.
• Required expert GIS, SQL Server administration, and network administration skills.