Experience

Garnet River

• United States
• Information Technology & Services
• 1 - 100 Employee

• SENIOR CONSULTANT

  • Dec 2007 - Present

  Lead DBA at the NYS Department of Environmental Conservation providing Oracle Database and Leadership Support for a team of 6 dbas. Primary DBA in supporting Oracle GEO Spatial Data running ArcSDE Databases that run up to 2TB in size. Performed major upgrades and server migrations. Lead DBA at the NYS Department of Environmental Conservation providing Oracle Database and Leadership Support for a team of 6 dbas. Primary DBA in supporting Oracle GEO Spatial Data running ArcSDE Databases that run up to 2TB in size. Performed major upgrades and server migrations.



IT DATA MANAGEMENT

• India

• TEAM LEADER

  • Jul 2005 - May 2007

  Drove strategy and IT direction for new and existing Data Warehouses with a focus on enterprise- based data models. Improved ETL strategies focused on cycle time reduction. Improved performance for critical business reports Managed the overall Data Warehouse, including the new development process with a goal of reducing the overall delivery time Managed a global team of on- and off-shore contractor resources responsible for developing the overall Data Warehouse solutions Tuned existing Data Warehouses to reduce load times and improve overall reporting performance through the use of existing Data Warehouse tools Responsible for Data Warehouse database architecture, as well as driving infrastructure upgrade projects across the Data Warehouse technology stack Upgraded Data Warehouse from Oracle 9i to Oracle 10g Operational Management for day-to-day Production Support of the Data Warehouse Loads Manage Disaster Recovery Processes and testing for all Data Warehouses



Keane Consulting

• Norway

• PRINCIPAL CONSULTANT

  • May 2000 - Jul 2005

  Lead DBA on 3 GE Application Systems; CASC, PAGE and Benefits Scorecard One of the primary DBAs for the GENESIS Peoplesoft project Installed and upgraded Peoplesoft on Sun and NT servers Installed Oracle IFS on Linux Installed and maintained PeopleSoft Application servers Performed upgrades and patch maintenance to Oracle/PeopleSoft software Created Disaster Recovery plan and documentation for PeopleSoft and CASC One of the primary DBAs for the Data Warehouse migration from Sun over to Linux Accustomed to working in a Global Environment supporting applications 24X7 Excellent multi-tasker working on highly visible, time-sensitive applications Extensive experience working with onshore and offshore resources Very strong interpersonal skills Able to communicate very well vertically and horizontally within the department (managers, developers, systems area and users) Configured servers to maintain Oracle instances and install Oracle software on Sun, HP, NT and Linux Servers Created and maintained data loads and data load scripts for Data Warehouse instances for the ETL process Secondary DBA for Global Quality Data Warehouse Created, cloned and maintained over 80 Oracle Instances Migrated Oracle instances to current Oracle software release Created, monitored and executed database backups and recoveries Created, maintained and altered database schemas Monitored database performance and provided db tuning as needed, including using Oracle Statspack Performed imports, exports and database refreshes as needed Migrated data and performed data loads using Sqlloader Provided technical assistance to developers Accustomed to working in an on-call rotation requiring off-hours support Created and maintained technical documentation Participated in new project evaluations Reviewed GE Oracle DBA procedures with new DBAs



New York State Senate

• United States
• Government Administration
• 500 - 600 Employee

• DATABASE ADMINISTRATOR

  • Mar 1992 - May 2000

  Installed and configured Oracle 8.x on SunSolaris, HP and NT Servers.Created and maintained Oracle 8.x instancesPerformed upgrades/apply patches to existing databases Evaluated Oracle features and Oracle related products including PVCS and Quest Software saving valuable time during the development process by reducing down time and allowing application teams to increase their efficiencyEstablished and maintained sound backup and recovery policies and procedures using AIX 4.2.1.1 scripts Participated in Database design and implementation, including data modelingImplemented and maintained database security including creating and maintaining users, roles and assigning privileges Performed database tuning and performance monitoring Planned for growth and changes including capacity planning Worked as part of a team and provided support whenever required Performed general technical trouble-shooting and consulted development teamsInterfaced with Oracle Corporation for technical support Maintained source code and performed production moves Created adhoc queries for users IQ Objects Administration: created reports for end users Instrumental in entire life cycle of conversion from Ingres to Oracle project

• DATABASE ADMINISTRATOR

  • 1992 - 2000