SUMMARY:

• SENIOR ORACLE DBA whose strengths are performance tuning, optimization, troubleshooting & problem solving on mission - critical 7.3.4 - 12.2.0.1.1 databases on Linux, Unix & Windows (SQL Server) platforms. Possesses excellent technical, business, communication & writing skills with an in-depth knowledge of the Oracle database architecture who collaborates well with all levels of management.
• Installs, configures, creates, refreshes & backs up databases. Monitors diskspace. Maintains, migrates, upgrades, patches & clones databases. Uses ASM on all database layouts. Uses OEM/Grid Control to maintain all databases 9.x and above. Configured RAC & Goldengate to maintain high availability.
• Enhances & maintains security, backup (RMAN), recovery/DR. Familiar with data loading (ETL). Scales & develops best practice plan. Mentors & teaches junior staff. Knows virtualization concepts. Implements, & maintains the infrastructure, models & db design. Does capacity planning & follows a daily, nightly, weekly & monthly DBA checklist. Contacts MOS if and when necessary.
• Available after hours, on-call for downtime management. Worked on databases ranging in size from 100G - 100T.

TECHNICAL SKILLS:

DATABASE ADMINISTRATION: Oracle 7.3.4 - 12.2.0.1.1 release 2, Goldengate 12.2.0.1.1 , Sharplex/HVR), Dataguard, RMAN (hot, cold backups, datapump imp/exp), OEM Grid Control, Oracle SQL, PL/SQL, Statspack, Oracle EBS, SQL Tuning & Access Advisor, Segment & Memory Advisor, ADDM, AWR, ASH, AMM, V$ tables, SQL TRACE 10046, TKPROF, Erwin, Power Designer, Informatica, Toad Data Modeler and Oracle SQL Developer Data Modeler, Certified Oracle TUSC Instructor (SQL & Oracle Database Performance Tuning)

SYSTEM ADMINISTRATION: Solaris, HPUX, AIX, VMWare, Linux and Windows 2008, shell scripting on all projects (bash, ksh, csh, cronjobs), manage swap space, avoid overloaded CPU, excessive memory swapping or disk I/O bottleneck using TOP, Glance, sar iostat, sar, vmstat & scripts, modifies Oracle kernel to meet installation requirements

NETWORK ADMINISTRATION: TCPIP & Oracle Net Services (Oracle Net, Net Listener, Connection Manager, Net Configuration Assistant and Net Manager), Networking and Data Center Fabric Products, Enterprise Communications & Virtualization

EXPERIENCE:

Senior Oracle DBA

Confidential, Hampton, NH

Responsibilities:

• Monitor and maintain Oracle and SQL Server databases (production, development and QA) for performance and operability, including patching and upgrades.
• Usage of Recovery Manager (RMAN) for backup and recovery of Oracle databases.
• Experience with Oracle Golden Gate for replication and high-availability (future state).
• Provide technical support to IT development staff and power users as appropriate regarding SQL tuning and performance.
• Ensure data security, privacy and integrity across all database platforms.
• Strong analytical and problem solving skills.
• UNIX shell scripting
• Participate in yearly remote disaster recovery testing.
• Provide off hour support as necessary.
• Solid understanding of ASM for Oracle database file systems and working with both RAW devices and ZFS File Systems.
• Knowledge of Oracle Enterprise Manager (OEM) tool for monitoring purposes.
• DBMS: Oracle 10G/11G/12C, SQL Server 2008+
• OS: UNIX (specifically Sun Solaris a plus), Windows 2003, 2008, 2012
• Programming Languages/Skills: SQL, PL/SQL, Shell Scripting (Korn, Bash), Perl, AWK, SQL*Loader, Data Pump, Data Encryption.
• Ability to keep current with new technology.
• Ability to train others in Oracle and SQL Server issues.
• Database size: 500G
• Maintain High Availability, Dataguard, RAC (Real Application Clusters), ASM, Goldengate, Cloning Production database to Test & Development, Tuning, Troubleshooting and Problem Solving Database issues, Backup and Recovery, Upgrading to Oracle 11g Release 2 & 12c, Physical Database Layouts and Storage Management, Monitoring Space Usage, Security and Auditing on Windows, Linux and UNIX operating systems, shell scripting
• Install, patch, create and maintain all Oracle software, database releases 10 & Oracle 11g Release 2 and application server release 10…RHEL5 & Windows platforms
• Making sure the following systems are up 24x7 other than scheduled downtime for Maintenance: Oracle EBS, EDI/SPSCommerce, Forms, Apache, Reports, Concurrent Manager, Apps Listener, Prod DB, DB Listener, VNC GUI (PDF), Workflow Mailer, Aventx Email & Fax, ShipConsole, Mwa, Dataguard DB & Listener and Autotime7 App & DB,
• Develop, implement, administer and maintain policies and procedures for ensuring the security and integrity of the company physical & VM databases
• Setting up printers on Oracle, Ship Console & Loftware, Leads and directs the work of other technologists, Preserve, protect & defend all Oracle Databases & software,
• Tune all (prod/test/dev) Oracle instance components including SQL and PL/SQL for maximum efficiency, Problem solving, troubleshooting& implementing changes of all database issues using OEM Grid Control, Toad & scripts,
• Present & implement all production schema changes via change control,
• Present and implement changes to database design using Designer 2000
• Control all migrations of Oracle schema objects,
• Design and implement a backup & recovery system for all databases,
• Implement Oracle failover technology, ie, Dataguard, Data modeling and Oracle database design, Data interface protocols,
• Managing data security, capacity & disk space issues,
• Managing development projects, Predicting future Oracle trends for hardware usage and user load, Autotime7 Terminal & Service Monitoring, Autotime7 upgrading & patching,
• Analyzing business requirements, recommending technical solutions, and writing technical specifications and/or requirements,
• Leading/coaching DBA, Sys Admin, and/or Network Admin teams, Write detailed and thorough technical documentation, Design, provision, deploy, maintain, and tune n-tier applications,
• Domain knowledge to include Manufacturing, Order Management, eCommerce including EDI, an Credit Card Processing, Excellent understanding of multiple development stacks including LAMP, Java, JBoss, Weblogic, .NET, Oracle EBS 11.5,
• Manage multiple projects simultaneously, Adapt to changing priorities,
• Extremely detail-oriented work ethic,
• Excellent verbal and written communication skills,
• Demonstrate work experience by providing examples and/or samples.

Confidential, Falmouth, ME

Oracle developer

Responsibilities:

• Written & Verbal communication skills - putting together documentation, In-depth knowledge of database technologies and tools, including Oracle, Familiar with and experienced working with Dimensional Data Modeling working on Financial/Banking databases, UNIX/LINUX experience, led technical projects, currently a 11g OCP Candidate, has a solid background in Oracle, shell scripting, troubleshooting & problem resolution, performance tuning, and SQL/PL SQL, has demonstrated experience, someone who can give you environment details, meshed well with the team, works independently with minimal supervision, worked with a team, but took action and was proactive at all times, interpreted requirements; walked tasks through to completion and has a strong follow through of established procedures very well and keeping track of multiple moving parts.

Confidential, Ipswich, MA

Oracle DBA

Responsibilities:

• Unix Scripting is necessary, application profiling, when Ebsco releases a new application to connect with the Oracle Database, based on what is seen, I wrote up findings, explain plan, code, etc, managed, monitored, & maintained the database & Application environments, ensured Backup, Recovery & Business Continuance for database & Applications, active hands-on member of database team, reviewed all migration scripts and performance test results prior to deployment into production. this pertains to all applicable applications, operating systems, and hardware to ensure departmental migration standards are followed, responsible for all database server configurations, capacity and performance planning and reporting, specified, select and order related hardware and software as required or directed, evaluated and recommended different technologies that helped EBSCO become more competitive and efficient, created and established security profiles and authentication rights based on application and end user requirements, monitored day to day database activities and reports exceptions to the management team, created, executed and maintained comprehensive plans for database server software, upgrades and patches in conjunction with system owners and within the department guidelines, established and maintained multiple database environments including Development, Test, and Production and ensures database management policies and procedures are established and communicated to the department staff for all relational database applications, Daily, weekly, monthly and annual monitoring and fine tuning of all relational database backups, maintenance plans and disaster recovery services.
• Responsible for testing of these plans, provided technical assistance and serve as a resource to technology staff, coordinated issue resolution and prevention plans with internal Customer Satisfaction group.

Confidential, Stratham, NH

Responsibilities:

• Direct responsibilities to administer and oversee all the (8/9i/10g/ Oracle 11g Release 2) internal Oracle databases, install/upgrade of Oracle databases to new versions and apply patches as required, configuration and deployment of oracle databases; capacity planning and performance tuning; database backup and recovery, database migration, imports, exports and resets; system storage allocation, creation of database storage structures and modifying and altering database storage parameters applies knowledge, experience and skills to diagnosis issues and improve processes, develop and manage user security privileges within Oracle Database environment, design, install, configure and maintain and provide support of database for performance, availability and security, purge and archive databases as deemed suitable for the business, monitor and optimize system performance using index tuning, disk optimization and other methods using automated tools, manage and maintain the QA, PROD and DEV database instances and perform periodic refreshes as required, work with the business users and IT programmers in developing solutions, provide 24x7 on-call troubleshooting and problem resolution, analytical/Problem
• Solving: Intellectual capacity and ability to gather, sort and analyze data and then develop logical conclusions; critical thinking skills; familiar with problem solving tools / techniques and able to communicate options, conclusions, and recommendations to both the business and the technology teams.

Confidential, Burlington, MA

Responsibilities:

• Installed, upgraded & supported Oracle databases, 8i-11g, 9i-11g, 10g- Oracle 11g Release 2 on Unix systems, supported existing and future OLTP and Data Warehouse systems, performance tuning, created & enhanced new and existing programs according to specifications, created high level design specifications, wrote detail specifications pertaining to enhancing and replacing existing OLTP data warehouse systems, provided general DBA support to various other systems, managed job ticket activity related to supported databases, ensured database uptime and availability per service level agreements, supported managers, project managers, and developers for core projects defined by IT, ensured that customer facing (internal colleagues and external customers) applications are fully available per service level agreements, worked with other DBAs in a team environment to maintain defined Oracle standards, develop improvements to standard operations such as performance tuning, backup and recovery, and general availability of systems, worked with managers and developers to deliver defect free projects on schedule, maintained established turnaround time for Two Coast job tickets, helped to develop then maintain project schedules, responded to emergencies (including off-hours emergencies) in a timely and professional manner, maintained service level agreement standards for system availability.
• Database size: 10T

Confidential, Chevy Chase, MD

Responsibilities:

• Provided development, installation, deployment, operations, and maintenance of C4I systems planned technological advancements to the Confidential (RSAF)
• Lead and provided full life cycle database support for an enterprise level environment,
• Installed and upgraded the Oracle 9i/10g server to Oracle 11g Release 2 and server application tools,
• Planned, designed, and maintained the logical and physical structure for database systems,
• Created primary database physical and logical storage structure and primary objects.
• Allocated system storage and plan future storage requirements for the database system.
• Monitored, tunes, and optimizes database performance. Loads, migrates, and connects data from external source into the database,
• Designed and implements data security measures,
• Designed and maintained database backup and recovery strategies as well as database security solutions,
• Supported end users and application developers, managed and monitored Oracle Real Application Clusters (RAC), Wrote PL/SQL packages, procedures, and triggers to modify or implement new programs.
• Provided regular status reports to the management team and generate incident reports as necessary,
• Interacted with management team, application developers, systems operations team, and end-users in enterprise level database administration for Oracle systems and system administration/engineering for both Windows and UNIX (HP-UX and Sun Solaris) systems,
• Familiar with database design and structure, optimization and performance tuning, as well as security and troubleshooting, worked effectively with all levels of an organization including the end users.
• Database size: 500G

Confidential, Augusta, ME

Responsibilities:

• Migrated a Oracle database on an Solaris Mainframe to Oracle 11g Release 2 running on a Windows Server 2008 platform and the conversion of batch processing code from COBOL to Java running on Oracle Application Server.
• Provided DBA support for the Confidential project using Oracle 11G on Windows 2008 & HPUX 11,
• Installing, creating, support project development, testing and production activities, setup and configuration of Oracle Grid and RMAN, database tuning, and troubleshooting application connectivity and authentication requirements,
• Assisted with Oracle databases migration activities using a migration tool called SQLWays, assisted the Confidential Team with application and performance testing activities,
• Provided middle tier Oracle Application Server administration guidance and tuning support of batch processing performance expectations by identifying performance issues and bottlenecks in the db,
• Provided off hours and on call Oracle database support to the Project when required for application and migration testing and during final production migration cutover for the data conversion of database to the Oracle environment.
• Database size: 15T
• Performed Healthcheck on clients Oracle10Gr2 database on RHEL (Linux) server that included the following: Executive Summary, Database/Application Observations, Security, Backup and Recovery, Core Configuration, General Maintenance Activities, Daily Procedures, Weekly Procedures, Quarterly Procedures,
• Infrastructure Checks, User Management, Performance Tuning, Monitoring, DB Configuration, DB Specific, Resource Intensive SQL Analysis, Database Wait Analysis, Architecture Scalability, Database Tier, Recommendations, Architecture Availability, Use of Data Guard, Backup and Recovery, PS Performance Tuning Tips, Server Performance, Web Server Performance,
• Java Performance Management, Tuxedo Performance Management, Application Performance, Database Performance, Indexes, Performance Monitor, Storage Performance, CPU Performance, Queries, Tempdb, Servers and Memory Allocation
• Database size: 500G
• Installed Oracle 10.2 in the development environment, Applied all current patches,
• Migrated copy of production data into development environment,
• Provided documentation of all installation and patch steps.
• Performance tuned & setup backup & recovery schemes.
• Database size: 250G
• Implemented 10gR2 on SuSe Linux to help setup, knowledge sharing and migration of 200GB database to their development environment.
• Provided documentation of all installation and patch steps.
• Performance tuned & setup backup & recovery schemes.
• Database size: 200G
• Tuning, troubleshot Oracle10g databases Data Warehouse provided documentation of all Oracle10g installation and patch steps.
• Performance tuned, setup backup & recovery schemes & tuned poor performing SQL statements.
• Database size: 100T
• Assisted the Lead DBA at Harvard to resolve Windows Scheduling problems, FASIT group
• Database size: 500G
• Customer is migrating database from Sybase to Oracle.
• Wrote a discovery document that detailed the process to convert 9 Oracle Tables along with Stored Procedures from Sybase to Oracle using shell scripts. Included in the Discovery Document was the resources & number of hours and timelines to complete the migration. Platform is Oracle9i/10g & Sun Solaris (UNIX).
• Database size: 750G