SUMMARY:

• Certified hands - on senior PostgreSQL, ORACLE, MySQL, and MS SQL Server Database Administrator and Architect with 10+ years of full life cycle database administration and development experience in OLTP and Data Warehousing, on-premises and in-cloud environments.
• Experienced in database conversion from Oracle and SQL Server to PostgreSQL and MySQL.
• AWS Certified Solutions Architect with experience in RDS and EC2 environments.
• Advanced expertize in database migration to AWS cloud infrastructure.
• Certified Systems and Network administrator with cross-industry and cross-functional training and experience in large multi-platform environments (LINUX, SOLARIS, AIX, HP-UX, IBM VM/ESA, WINDOWS).
• Outstanding analytical and problem solving skills.
• Able to work independently and as part of a team. Result oriented, meets deadlines and works well under pressure.
• Extensive experience in the areas of Data Management & Data Warehousing, Software Engineering, Financial and Mortgage Industry, Telecommunications, Manufacturing, Warehousing, Electric Utilities, Medical Research and Government.
• Special interest and experience in AWS cloud infrastructure database migrations, Postgresql and converting existing ORACLE and MS SQL Server databases to PostgreSQL, MySQL and Aurora.

WORK EXPERIENCE

Sr. Database Engineer

Responsibilities:

• Provided guidance and implemented Postgresql database solution in AWS (Amazon Web Services) EC2 & RDS environments.
• Configured and built EC2 CentOS database servers for hosting Postgresql databases and monitoring software.
• Installed and configured Nagios monitoring tools for host and database monitoring.
• Migrated Postgresql and MySql databases from on-premises to AWS EC2 and RDS environments.
• Monitored and maintained EC2 & RDS databases using Nagios and CloudControl
• Guided and migrated Postgresql and MySql databases to AWS Aurora
• Provided PostGIS install and support for the corporate Postgresql GIS databases.
• Provided on-call 24x7 database support and troubleshooting for on-premises and in-cloud/AWS Postgresql, MySql and MS SQLServer databases.

Environments & Tools: Postgresql 9.5/9.6, MySql 5.6/5.7, MS Server 2008, 2012 & 2014, Aurora, AWS, EC2 & RDS, Nagios, LINUX, WINDOWS

Lead PostgreSQL and Oracle DBA

Responsibilities:

• Provided support and database administration and tuning of various GIS, SAP, Water Regulation and other Production/QA/Development databases.
• Provided Postgres, Oracle and MS SqlServer installation, patching, cloning, configuration, migration, upgrade, and capacity planning.
• Configured, managed and ensured database security and integrity.
• Upgraded Development/Test and Production databases. Regularly applied database patches.
• Installed, configured, managed and upgraded database monitoring and management software, as a framework for centralized, integrated management of all database products in the enterprise.
• Converted Oracle and SQLServer databases to Postgresql and MySql.
• Provided on-call 24x7 database support and troubleshooting.

Environments & Tools: ORACLE 12c/11g/10g, SOLARIS0, LINUX, WINDOWS, NetBackup, VCS, Oracle Middleware Fusion, 10g, 12c & 11g Oracle Grid Control, RMAN, SQLServer 2008 , 2012 and 2014 , Postgresql 9.4.1, MySql 5.6, PL/SQL, Java, Quest Tools

Oracle & MySQL DBA

Responsibilities:

• Provided remote Oracle and MySql database administration and support in Production and Test environments for all Scripps Florida databases. Ensured 100% database availability
• Implemented and maintained database backup and recovery procedures
• Provided database installation, upgrade, and patching. Performed database loading and refresh
• Assisted Application developers in resolving application performance and other database related issues
• Provided database availability, space usage and capacity planning reports to management
• Installed configured and managed Oracle Grid Control 10g for database monitoring and administration
• Provided 24x7 remote database monitoring and support

Environments & Tools: ORACLE 10g, MySql 4/5, SOLARIS 10, LINUX, WINDOWS, Veritas NetBackup, OEM & Oracle Grid Control, RMAN, PL/SQL, Quest Tools, Remedy

Oracle DBA, Production/QA

Responsibilities:

• Provided on-site and remote Oracle database administration and support for Production, QA and Test databases for United Natural Foods, Lancaster, TX.
• Interacted by phone, email and in-person with user community, developers, other on-shore & off-shore DBA-s, and management regarding database issues and support.
• Implemented and maintained NetBackup and RMAN database backup and recovery procedures for client’s Oracle databases.
• Managed database access and security. Performed database refresh.
• Provided database support for application roll-outs and implementation.
• Analyzed and tuned SQL code. Recommended and implemented measures and modifications for performance improvement.
• Used Statspack to monitor database performance and resolve the performance bottlenecks.
• Provided 24x7 on-call database support.

Environments & Tools: ORACLE 11g, AIX, Veritas NetBackup, RMAN, PL/SQL, Statspack, OEM, Quest Tools

Lead Oracle DBA

Responsibilities:

• Provided support and database administration and tuning of various Oracle Production/QA/Development databases, in SOLARIS, LINUX and WINDOWS environment, for the South Florida Water Management District (SFWMD).
• Provided Oracle 11g, 10g and 9i installation, patching, cloning, configuration, migration, upgrade, and capacity planning. Configured, managed and ensured database security.
• Upgraded hundreds of Oracle Dev/Test and Production databases to 11g and 10g. Regularly applied Oracle Security and other patches to all the databases in the organization.
• Analyzed and tuned SQL and Java code. Identified performance bottlenecks and recommended specific measures to optimize and significantly improve the performance of various database applications.
• Installed, configured, upgraded and managed Oracle Application Server.
• Actively participated in analyzing and establishing the organization wide backup and recovery strategy. Implemented comprehensive backup and recovery strategy and procedures for CERP databases. Performed database backup and restore using Veritas NetBackup and RMAN.
• Installed, configured, managed and upgraded Oracle 10g Grid Control
• Provided on-call 24x7 database support and troubleshooting.

Environments & Tools: ORACLE 11g/10g/9i, SOLARIS 10/9, LINUX, WINDOWS, NetBackup, Oracle Application Server, RAC, OEM & Oracle Grid Control, RMAN, Statspack, PL/SQL, Java, Quest Tools.

Sr. Oracle DBA

Responsibilities:

• Provided support and database administration and tuning of over a hundred Oracle databases, in SOLARIS, LINUX and WINDOWS environment for SFWMD.
• Provided Oracle 10g and 9i installation, patching, cloning, configuration, migration, upgrade, and capacity planning.
• Configured and managed database security.
• Upgraded Oracle Dev/Test and Production databases to 10g.
• Reviewed existing database performance monitoring and tuning methodology, and recommended and implemented efficient procedures to significantly improve the database performance in high demand service oriented environment.
• Provided on-call 24x7 database support.

Environments & Tools: ORACLE 10g/9i, SOLARIS 9/8, LINUX, WINDOWS, Veritas NetBackup, Oracle Application Server, RAC, OEM & Oracle Grid Control, RMAN, Statspack, PL/SQL, VMware, Java, Quest Tools

Boca Raton, FL 

Sr. Oracle Data Warehouse DBA

Responsibilities:

• Provided support and database administration for some of the world’s largest (27+ TB) Oracle 10g/9i/8i Production, QA and Development databases, in LINUX and very large SOLARIS environment. Supported On-line production databases with thousands of concurrent users.
• Set up and managed partitioning, master-to-master and snapshot replication.
• Provided technical guidance on database design to the development community. Tuned the databases and SQL code to optimize the access, movement and load of multi-terabyte datasets.
• Provided Oracle 9i and 10g installations and upgrades. Converted 10g databases from Solaris to Linux OS using RMAN and transportable tablespaces.
• Provided ETL PL/SQL scripts and support to ETL department.
• Performed database backup and recovery using NetBackup and RMAN.
• Actively participated in interviewing and hiring senior Oracle DBAs.
• Provided 24-hours on-call operational database support and troubleshooting, ensuring 100% database availability.

Environments & Tools: ORACLE 10g/9i/8i, RH & SuSE LINUX, SOLARIS 8, Informatica, Veritas NetBackup, Quick I/O, Grid Control, RMAN, PL/SQL, Tora, VMWare, Informix, Perl, DBI, MySql, WINDOWS 2000/XP

Beach, FL

Sr. Oracle Performance DBA

Responsibilities:

• Conducted Performance Analysis and Tuning of ORACLE Production and QA Databases & Applications in UNIX and Windows environment.
• Provided review and evaluation of existing and new Database Monitoring Strategies and Tools.
• Established permanent effective and proactive performance monitoring of ORACLE Production databases using Statspack and other ORACLE Database Performance Monitoring Software and Utilities.
• Analyzed and resolved Production Performance Issues, making specific recommendations to significantly increase the performance and reliability of ORACLE based systems and applications.
• Provided detailed Daily, Weekly and Monthly performance evaluation and reports to the Management for various Production & QA Databases. Identified performance bottlenecks and tuning opportunities for Oracle Databases and Applications, in both UNIX and Windows environments.
• Provided 24x7 daily care and performance related measures to maintain ORACLE Database Systems SLA-s. Ensured 100% database availability.
• Conducted tuning and optimization of Applications’ SQL code, Stored Procedures and Functions.
• Performed logical & physical design of ORACLE databases. Used ERWIN for data modeling.
• Provided ORACLE installation, patching, cloning, configuration, migration, upgrade, and capacity planning.
• Reviewed existing DBA Documentation and Procedures, following Sarbanes-Oxley requirements. Designed and created DBA Operational Standards & Guidelines and Templates.

Environments & Tools: ORACLE 10g/9i/8i, IBM AIX 4.3.3/5.2, HP-UX 11, SOLARIS 8, RH LINUX 7.x & RH Advanced Server, OEM, RMAN, Statspack, PL/SQL, Embarcadero Tools, Quest Tools, ERWIN, WINDOWS 2000/XP

Mill Valley, CA

Sr. Oracle DBA

Responsibilities:

• Responsible for daily administration and troubleshooting of high-volume transactional On-line Production, Stage & Standby ORACLE 8i/9i mission critical financial databases, in 24x7 fast paced High Available HP-UX Cluster (Service Guard) environment.
• Provided strategic recommendations related to database configuration, improvements, upgrades, storage, high availability, backup & recovery and data protection. Provided backup & recovery, using SAN/NAS storage, Hot Backup and RMAN.
• Performed comprehensive analysis of existing database initialization parameters and configuration. Recommended and implemented measures and modifications for performance improvement.
• Monitored and tuned database systems. Ensured maximum efficiency and 100% system availability. Managed security and provided capacity planning.
• Performed database conversion, loading & refresh. Migrated production databases from Raw Devices to UNIX file system.
• Reviewed Disaster Recovery scenarios and provided appropriate strategy. Provided expertise and implementation of ORACLE 9i Data Guard for High Availability & Data Protection of Production Databases. Configured, managed and maintained local and remote Standby ORACLE databases.
• Worked closely with developers and QA engineers to resolve issues and make enhancements. Created and managed policies, procedures, and standards related to database management, troubleshooting, backup & recovery, auditing, and resource utilization in a collaborative manner to support the advancement of enterprise applications.
• Provided on-call 24-7 support and troubleshooting.

Environments & Tools: ORACLE 8.1.x/9i, HP-UX 10.2/11, HP Service Guard, OEM, RMAN, 9i Data Guard, Statspack, PL/SQL, Other ORACLE Tools & Utilities, Quest Tools, WINDOWS 2000/XP

Redwood City, CA

Sr. Database Architect/DBA

Responsibilities:

• Performed analysis, logical & physical design, installation, configuration, patching, cloning, and migration of ORACLE databases.
• Performed partitioning, data loading, refresh, logical & physical backup and recovery. Provided capacity planning.
• Configured and managed database security and integrity.
• Set up and maintained distributed and standby ORACLE databases. Configured and managed database replication.
• Developed and followed database installation and maintenance procedures.
• Assisted application developers with all aspects of development that interface with the ORACLE databases. Provided design, SQL and PL/SQL reviews, making specific recommendations to optimize the performance and reliability of ORACLE applications.
• Monitored database performance and performed comprehensive performance analysis of high-volume transactional ORACLE databases.
• Identified the performance bottlenecks, recommended specific measures and significantly improved the database performance.
• Provided needed database related shell scripts.
• Provided on-call 24x7 support and troubleshooting.

Environments & Tools: ORACLE 7.x - 8i, SUN SOLARIS 6/7/8, OEM, RMAN, Statspack, PL/SQL, NetApp, Other ORACLE Tools & Utilities, Quest Tools, WINDOWS NT/2000

Toronto, ON 

Sr. Applications Developer

Responsibilities:

• Provided analysis, modifications, development, data synchronization and support for Systems and ORACLE Applications in various environments, using SDLC methodology and procedures.
• Provided technical expertise and leadership for the company's Datawarehouse and Data Marts. Created and automated the procedures for data extraction, transformation and loading (ETL), using PL/SQL, stored procedures, functions and triggers.
• Designed and built end-user reports and templates.
• Coordinated system releases and ensured smooth transaction of supported applications and databases from the development to acceptance and production environment.
• Designed, developed and supported Financials Interfaces from various VM and UNIX applications to ORACLE Financials (GL & AR).
• Designed and developed Visual Basic ActiveX components.
• Provided technical expertise and leadership for installation, modifications, administration and support of Remedy AR System and Remedy applications.

Environments & Tools: ORACLE 8.x/7.x, SUN SOLARIS, IBM VM/ESA, PL/SQL, Pro*C, POWER BUILDER, Visual Basic, ORACLE Forms & Reports, Other ORACLE Tools & Utilities, ORACLE Financials, Remedy AR System, COGNOS, ERWIN, WINDOWS NT.

Mississauga, ON 

DBA, Developer/Analyst

Responsibilities:

• Performed database analysis, logical and physical design. Extensively used ERWIN for data modeling.
• Created and maintained databases in HP-UX and WINDOWS environment.
• Managed database access and security for Development and Production databases. Established refresh, backup & restore procedures.
• Ensured smooth operation and optimal performance of 6 databases.
• Conducted performance analysis and identified inefficient code and queries. Tuned and modified SQL code and improved the performance and database access of existing applications and modules from 2 to 50 times.
• Provided systems analysis, developed new modules, modified and significantly improved existing corporate applications, using Gupta Centura/SQLWindows and ORACLE.
• Evaluated features of ORACLE Applications and worked with application vendor to define implementation and upgrade procedures.
• Analyzed, extended and customized ORACLE Applications using Developer/2000, database triggers, stored procedures and functions.
• Designed and developed the interface between ORACLE Business System and Digital Encoder System for the Programming Department using ORACLE DBMS Pipes, ORACLE Forms, ORACLE Reports, PL/SQL and Pro*C.
• Provided on-call 24x7 database and application support in development and production environment.

Environments & Tools: ORACLE 7.x, HP-UX, PL/SQL, Pro*C, Gupta SQLBase & Centura/SQLWindows, ORACLE Forms & Reports, Other ORACLE Tools & Utilities, ORACLE Financials, ERWIN, WINDOWS NT