Jeff Mcdevitt Email & Phone Number

Baltimore, Maryland Area

Baltimore, Maryland Area

• Senior Database Administrator Provided global support of 150 Oracle databases for hosted student information systems supporting universities in foreign countries. Provided implementation and production support for.
• Improved performance and reliability by migrating a major universities’ infrastructure from Mexico to our U.S based data center. Provided ongoing production support for legacy infrastructures on much older Oracle.
• Supported various migration efforts, by accepting system intake from other foreign universities, and implementing them on our system. Implementations were done using RMAN backups and datapump extracts.
• Responsible for the successful implementation of corporate business information systems on Oracle 12c RAC including Oracle Hyperion and Business intelligence. Provided life-cycle deployment with performance tuning and.
• Provided full backup support to all database systems, including RMAN backups as well as media management including Oracle Secure Backup and Amazon AWS. Performed database cloning using RMAN to accomplish application.
• Performed other Unix/Linux admin tasks including storage provisioning, and file system backups.

• Principal/Lead Database Administrator, managing a staff of 5 for various implementations of Oracle10g-11g, MySQL, and Vertica environmentProvided mentoring and leadership for a global team of 6 for various.
• Restored lost revenue by leading the Europe DBA through the stabilization of their unreliable Oracle RAC system. Thoroughly researched and determined that RAC was not suitable for their system requirements migrated the.
• Saved the company thousands of dollars in software licensing by migrating a major media planning system from Sybase to Oracle. Hired and directed staff to execute the database changes needed. Collaborated with.
• Worked to assure that the team was thoroughly involved with implementations during project lifecycles, including development, quality assurance, pre-production, beta, and production. Assured that my team collaborated.
• Maintained a highly stable, high performance database environment by planning and executing Oracle upgrades, hardware, and data center migrations using standard Oracle accepted metrologies, while minimizing downtime.

Baltimore, Maryland Area

• Provided complete Oracle database management for 100+ instances installed on various Linux, and Sun Solaris servers, utilizing EMC storage and Veritas Clusters. Databases range in size from 100MB to 4 TB. Total size of.
• Saved company numerous hours of QA time by implementing procedures to duplicate production environments down to QA. Utilized RMAN to meet the requirement to duplicate a 500GB database in less than 3 hours. Increased QA.
• Designed implemented backup and recovery solutions utilizing Oracle RMAN interfaced with Veritas NetBackup. Collaborated with UNIX SA to improve backup performance, as databases increase in size.
• Monitored and maintained over 700 automated jobs implemented via UNIX cron to accomplish data replication between database environments, partition maintenance, and perform other miscellaneous database maintenance.
• Established and maintained materialized views between database environments using refresh groups to assure data consistency. Devised other methods for replication of corporate data to various data repositories using.
• Improved efficiency of application developers by providing consulting support for query and application tuning, utilize tools such as TOAD and Oracle OEM to analyze query plans, offer suggestions for improvements by.

Owings Mills, Maryland

• .Provided database support for Oracle instances ranging from 10-200GB installed on UNIX and Windows servers. Applications included Insurance, Accounting, Document Imaging/Workflow, Management Reporting, Oracle Designer.
• Designed/implemented Disaster-Recovery database architecture using custom-tailored shell scripts to insure database availability in the event of Data Center or server failure. Configured this solution to provide DR.
• Designed/implemented backup and recovery solutions utilizing Oracle RMAN interfaced with Veritas NetBackup. Developed backup and recovery standards document for corporation.
• Worked in conjunction with various application teams to design and implement major releases of application system upgrades. Designed and executed scripts, as well as back out procedures.
• Monitored/tuned database and server performance using tools such as Oracle OEM, and custom tailored shell and SQL scripts problems.
• Worked with developers to provide support for nightly batch processing streams utilizing SQL, PL*SQL, and UNIX shell scripting that manage data feeds between various application systems

Baltimore, Maryland Area

• .Served as Database Administrator for a company-wide implementation of Oracle7 databases on HP-UX, Digital-Alpha w/clustered Parallel Server, and Windows.
• Provided database and server support for 90 Oracle instances installed on 30 servers. Supported a variety of Corporate system solutions including Marketing, Power Distribution, GIS, HR/Payroll, Automated Work.
• Monitored/tuned database and Unix performance using tools such as Platinum DBVision, HP/GlancePlus, and custom-tailored shell/SQL scripts.
• Installed and evaluated various versions of Oracle Software for server and client. Served as a technical liaison to Oracle corporation, with regards to resolving Oracle software bugs, and patch fixes.
• Provide full support of Oracle SQL*NET, including resolution of connectivity issues between client and server.
• Designed/implemented enterprise-wide backup and recovery solution utilizing hot-backup methods to ensure 24x7 availability of critical systems. Recovered failed databases using point-in-time recovery to assure minimal.