SUMMARY:

• Successful Senior Oracle DBA with the skills to drive small, medium and large scale cross functional projects to successful completion.
• Ability to communicate clearly to all levels of project contributors from executives and project sponsors to development and implementation team members.
• Coordinates project objectives, tasks and timelines, in support of organizational business objectives and strategic goals.
• Consistently utilizing a structured system development life cycle to assure quality and consistency of project deliverables.

TECHNICAL SKILLS:

Languages: Oracle SQL, Oracle PL/SQL, T - SQL, UNIX shell, Active Server Pages, vbscript, javascript, HTML, Visual Basic, SuperNova 4GL.

Databases: Oracle, SQL Server, IMS.

Operating Systems: Solaris, AIX, HP, Linux, Windows 95 and NT, MVS.

Tools: Toad, DB Artisan, Oracle Enterprise Manager, Tidal Scheduler, vi, awk, sed, Microsoft Project, Visual InterDev, Front Page, Wise Install. Oracle 12c New Features for Administrators. Training: Oracle RAC and GRID Infrastructure, Oracle 10g New Features for Administrators, Oracle 9i Database Performance Tuning, Oracle 9i New Features for Administrators, Oracle 8 for Administrators, Oracle Database Architecture and Administration, Oracle Database Tuning, Oracle 7 Backup and Recovery, SQL*NET Client Server Implementation, Oracle for Developers, Oracle PL/SQL, Oracle Advanced SQL, Data Modeling and Relational Database Design, Visual InterDev 6, Visual Basic, UNIX, C language, Shell commands, Object Analysis and Design, Functional Design, Introduction to PeopleSoft.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Senior Oracle DBA

• Responsible for multiple RAC and non RAC databases (40G to 20TB, non-production and production environments), running Oracle 12.1.0.2 and 11.2.0.4 on Linux Red Hat, Solaris and IBM AIX servers, using EMC VMAX, Symmetrix, Clariion and Hiatchi storage devices, in support of multiple mission critical Java based and 3rd party vendor supplied applications, in a 24x7 environment, using SharePlex for data replication. Use of RMAN, SQL Backtrack and EMC snapshot technology for backup and recovery.
• Responsible for partnering with application architects, developers and end users, to collect and define database requirements, and implement database solutions.
• Responsible for the implementation of DataGuard, in support of the company’s DR solution.
• Responsible for the planning, testing an implementation of the Oracle GRID infrastructure and databases from 11.2.0.4 to 12.1.0.2.
• Lead weekly meetings between DBA, application and UNIX SAs team members, to review current and future projects.
• Responsible for migrating databases from on premise servers to the Amazon cloud.
• Lead DBA on 5TB data warehouse. Tested and implemented the use of ASM. Tested and implemented the use of RMAN to migrate a database from file systems to ASM.
• Leveraged the use of partition exchange, to reduce the time needed by the ETL team to load new data. Performed SQL tuning, ensuring all the needed structures (PK, FK and bit map indexes), were in place to allow the Oracle optimizer to choose a star transformation. Implemented the use of Resource Manager, working with the application and business to define the proper resource plans and consumer groups.
• Responsible for the implementation of Transparent Data Encryption, to meet client requirements for encryption at rest.
• Technical and project lead for the Oracle 10g upgrade project. Responsible for the planning and coordination of the 10g upgrade across multiple applications and supporting the application DBAs on the actual implementation.
• Conducted the first Oracle 10g install and database upgrade. Evaluated different methodologies up upgrading (using dbua vs running manual scripts). Produced step by step documentation for standardized procedures.
• Evaluated 10g new features and made recommendations to management and DBA team on what new functionality to go live with.
• Evaluated the resource (i.e. memory, disk), impact of upgrading to Oracle 10g.
• Performed 9i vs 10g performance tests, to evaluate the impact to application top SQLs.
• Responsible for the planning, coordinating, and implementation of application required database changes across all database environments, as well as the installation and patching of Oracle 11g databases.
• Part of an Oracle triage team, called in help assess the database health, and identify any performance impacting issues, during all application slowdowns. Improved database performance by tuning SQL (rewrites, use of profiles and hints, new indexes), and database parameters, based on an analysis of AWR reports.
• Introduced to the DBA group the use of Oracle Log Miner to track both DML and DDL database changes.

Senior Oracle DBA

• Responsible for multiple 100G databases (development, UAT and production), running Oracle 9.2 and Oracle 8.1.7 on HP N class servers, using EMC Symmetric and Clariion storage devices, supporting PeopleSoft HR and Portal applications in a 24x7 environment supporting 35,000 active users.
• Lead DBA on the PeopleSoft V8 upgrade project. Worked directly with the application leads, developers and management to plan and implement the required changes to the database based on the PeopleSoft upgrade process. Investigated the use of and implemented Oracle’s character set utility to advise management of the impact of converting from character set WE8ISO8859P1 to UTF8 during this upgrade.
• Partner with the development teams, PeopleSoft, UNIX and Windows Administrators and Network Operations Center across independent MMC operating companies in support of development, production, and disaster recovery initiatives.
• Designed a DR solution using an Oracle Standby Database. Created shell scripts to FTP the archive logs to the DR site, apply the logs, and notify the DBA team of any problems.
• Database performance monitoring and tuning thru the use of tools such as Statspack, Oracle Enterprise Manager and DB Artisan. Made changes to initialization parameters where needed, increasing the number and size of rollback segments, size of the data buffer and shared pool.
• Significantly improved SQL performance for both online and batch processes by working with the application developers to proactively review explain plans to identify performance issues.
• Created shell scripts (executed via Tidal software), to notify the DBA team (via email and pagers), of problems/potential problems with the production database (i.e. block corruption in datafiles, ORA- messages in alert log, trace files created by Oracle, archive directory full, security policies violated).
• Mentored development team members on data modeling techniques.
• Designed a process to track database space consumption at a tablespace, table and index level for storage planning.
• Investigated the use of and implemented Oracle’s transportable tablespace functionality to expedite the export/import of large benefit tables during open enrollment testing.
• Implemented the use of global temporary tables to reduce disk usage and redo log entries.
• Implemented the use of locally managed tablespaces to reduce data dictionary contention and recursive SQL.
• Installed Oracle 9.2 and upgraded 8i databases to 9.2.
• Responsible for evaluating the benefits of ‘skip scanning of indexes’ in order to reduce the number of indexes in the database.
• Evaluated the benefits of larger blocks sizes on indexes.
• Responsible for the development work and production support of one database running Oracle 8.1.7 on Windows 2000, supporting a web based employee stock purchasing application.
• Responsible for the production support of a SQL Server 2000 database running an Authoria Employee Advisor application on Windows 2000.

Oracle DBA

• Solely responsible for the development work and production support of four databases.
• Data modeling and database design.
• Database performance tuning (SGA buffer sizes, sizing of redo logs and rollback segments, initialization parameters). SQL performance tuning (use of indexes, hints).
• Design database backup and recovery strategies.
• Responsible for the installation and testing of Oracle on both NCR 5100 (Oracle 7.3), and HP N class (Oracle 8i), servers.
• Coordination of all databases from Oracle 6 to 7 and from Oracle 7 to Oracle 8i.
• Worked with HP consultant to create a blueprint for the file system layout of all databases on the server (12), in order to balance disk, fiber channels and controller utilization.
• Participant in a team formed to reevaluate the backup solution established for 8 HP N class servers and to establish a process for adding additional applications/databases to these servers.
• Trained and mentored new DBAs. Provide overview of new Oracle features to other DBAs

Project Leader/Programmer/Analyst

• Project leader for a web application that tracks the status of equipment being installed in Confidential offices in support of local and long distance service. Primarily responsible for the analysis of user requirements, design, coding, and testing of system modules for this application.
• This application was developed using active server pages, vbscript, javascript, remote scripting, design time controls and DHTML, connected to a SQL Server database.
• Primary customer contact for business group using this system.
• Created user documentation.
• Coordinated and supervised the work of three team members.
• Project leader for a client/server application that tracks projects developed to reduce Confidential access expense.
• Solely responsible for the analysis of user requirements. Contributed to the design of the user interface and the design, coding and testing of system modules.
• This application was developed using SuperNova 4GL and UNIX shells connected to an Oracle database.
• Coordinated and lead training sessions. Coordinated the work of two team members. Participated in all phases of the systems development process.