TECHNICAL SKILLS:

Hardware: Exadata (2), ODA (2), Sun (12), HP (8), Various Servers (20+)

OS: RedHat (5), OEL (5), VMware (3), AWS (3), Solaris (12), HP - UX (3), Unix (20+), Windows (20+)

Databases: Oracle (30), SQL Server (3), MarkLogic (1)

Tools: SQL Developer(10), SQLPlus(25+), Toad(10), RMAN(15+), Legato(5), Netbackup(5)DB Boost (3), OEM (6), Oracle Wallet (3), Tomcat (5), ORDS (3), APEX (3)

Languages: PL/SQL (15), SQL (25+), Pro*C (8), C (10+), Linux and Unix Shell Scripts (20+), Perl (1), JSON (1), Xquery (1), Java Script (1), Basic (15), Fortran (15)

EXPERIENCES:

Confidential, North Chicago, IL

Oracle Contractor

Responsibilities:

• Responsible for as many 80 development, test, quality assurance and production databases, versions 10g to 12c as well AWS and MarkLogic.
• Tasks include but not limited to database creation using OEM, DBCA, RMAN duplication or scripts, patching using either OEM or manual process (opatch), database upgrade to higher versions, user and schema creation and security enforcement using Oracle Wallet, backup and refresh of lower environment databases using Rman, DBoost and Datapump and performance tuning using AWR, ADDM, ASH, SQL Tuning Advisor, Explain Plan, Tkprf and data dictionary views..
• Develop both Oracle procedures and Shell scripts that are used by the team to monitor, administer to and perform maintenance on Oracle databases.
• Installed Oracle software and configured databases on AWS in response to a high priority and fast moving project.
• Installed and configured Tomcat, ORDS (Oracle Restful Services) and APEX which were specific requirements for two (2) scientific applications.
• Acquired MarkLogic training from MarkLogic University to build and support NoSql databases.

Confidential, Chicago, IL

Oracle Contractor

Responsibilities:

• Responsible for the implementation and configuration of Oracle RAC databases, two (2), three (3) and five (5) nodes, from Production to Development, with Physical Standby for DR, on Exadata and Linux servers using tools like OEM, DBCA, Cluvfy, Crsctl and Srvctl.
• Configured and managed Oracle Services in RAC environments where preferred and available nodes were required to be designated.
• Provided support for GoldenGate unidirectional and bidirectional data capture and replication
• Worked closely with development team to create and maintain database objects (tables, indexes, views, mviews, sequences, database links, synonyms, types).

Confidential, Deerfield, IL

Oracle Contractor

Responsibilities:

• Performed as a core DBA with duties and tasks on 11gR2 single and RAC instances on Exadata, ODA and standalone Linux servers which included RAC creation (2 node) and configuration, performance tuning of databases on Exadata, RAC and standalone, Backup implementation using Rman and capacity planning.
• Work with Development teams in implementing new objects or modifying existing objects in the databases.
• Monitored and tuned database systems using tools like OEM, SQL*Developer, SQL Tuning Advisor, SQL Segment Advisor, AWR, ASH, ADDM, Tkprf and Explain Plan.

Confidential, Northbrook, IL

Oracle Contractor

Responsibilities:

• My experiences were acquired to guide and help junior level DBA implement newest release of database system.
• Designed and wrote PL/SQL procedures to perform Bulk Loads and Updates.
• Perform SQL and Database Performance tuning tasks on 11gR2 RAC databases on Sun servers running Solaris.
• Assist developers by implementing new and modified Schema Objects into lower level environments
• Develop both SQL and Unix shell scripts used in everyday database monitoring, tuning and Object deployment.

Confidential, Chicago, IL

Senior Oracle DBA

Responsibilities:

• Provided 24x7 Production support for Company’s 10g and 11g databases, initially running on Solaris and later on Linux OEL, using tools like OEM 12c, Toad, Rman, ASM, Data Guard, PL/SQL, SQLPlus and Unix shell scripts.
• Worked with Database Development team in turning Logical models to Physical models in both Development and Test databases, tuning SQL queries using tools like Explain Plan, Tkprf, DBMS SQLTUNE, SQL Tuning Advisor, and in 11g, SQL Plan Management.
• Developed server and database migration plan; first researching what servers / OS to replace current, old T2000 Solaris environment, presenting plan to CTO and acquiring approval, and then migrated 10g databases to 11gR2.
• Work with the CTO in determining future vision and direction of Oracle architecture, ensuring the wide range of needs of fast growing company are met with correct solutions.
• Built PL/SQL procedures and Unix / Linux shell scripts which are used in the monitoring and administration of the databases.
• Planned, configured and installed Oracle’s Enterprise Manager 12C.

Confidential, Deerfield, IL

Oracle Contractor

Responsibilities:

• Responsible for the build out of new Development and Test Oracle 11g databases for new Pharmacy Benefit System using Rman and both SQL and Shell scripts.
• Worked with developers to implement and maintain schema objects in newly created databases.
• Implemented backups, performed capacity planning, tuned database and queries, monitored and provided support for new Pharmacy Benefit System databases.

Confidential, Vernon Hills, IL

Team Mgr and Senior Oracle DBA

Responsibilities:

• Performed as a hands-on Senior Oracle Database Administrator and Team Lead on various Capital Markets systems consisting of both production and non-production Oracle and SQL Server databases
• Responsibilities included but were not limited to installing Oracle software on Unix servers, configuring development, test and production instances, database tuning, configuring backups and monitoring running systems.
• Achieved yearly savings of thousands of dollars for the Bank by persistent database administration and sql tuning of global investing system and by automating daily tasks using tools like DataPump and Unix shell scripts.
• Improved utilization of the Bank’s resources by implementing Disaster Recovery and Reporting databases using Oracle’s Physical and Logical Standby architecture on passive Veritas Cluster servers.
• Designed and developed many of the PL/SQL procedures and Unix shell scripts used in the online and batching processing environments.
• Provided technical expertise in the implementation of the Bank’s first implementation of Oracle RAC database system on a 2 node Linux cluster.
• Migrated Confidential database systems to JPMorgan Chase platform and performed performance tuning of new 11g databases.
• Recruited and managed a team of Oracle dbas in the development and administration of OLTP and Data Warehouse database systems.
• Responsibilities included day to day administration of production OLTP and Data Warehouse and systems totaling 15Tb in size.
• Achieved the processing of Bank’s Mortgage Portfolio in a 5 hour window through database and sql tuning of ETL process of Bank’s Data Warehouse database system.
• Developed and implemented PL/SQL Packages used across all Oracle 9i environments which performed tasks such as schema analysis, table partition maintenance and index rebuilds.
• Designed and implemented database backups using Rman and BCV technology.
• Provided technical knowledge and leadership to team of in-house and external developers.
• Developed and documented Department’s database standards and procedures.
• Developed and implemented database security standards and auditing.
• Worked along with Technical Architects to provide server sizing, capacity planning, disk architecture, technical recommendations and design.

Confidential, Lombard, IL

Senior Oracle DBA Consultant

Responsibilities:

• Provided remote database administration to more than 20 clients and numerous Oracle instances, versions 7.3.2 to 9i, sizes up to 1TB, running on Sun, HP, DEC Vax and Window servers.
• Wrote and presented whitepapers on different Oracle database functionality such as Oracle Text.
• Installed Oracle software for clients and configured databases.
• Installed and configured for clients Oracle Applications 11i (Financials and Discrete Manufacturing).
• Installed and configured for clients Oracle Internet Application Server (9iAS).
• Installed and configured for clients Oracle9i RAC and Physical DataGuard.
• Wrote PL/SQL procedures, functions and packages that supported client’s environments and used in their applications.
• Provided capacity planning, server and disk configuration recommendations.
• Developed shell scripts (korn, bourne, C) as well as DCL scripts for database maintenance and administration.
• Provided Unix and DEC Vax server performance analysis and tuning.
• Designed and implemented Database backup and recovery for clients using Recovery Manager, Veritas, Legato, EMC, hot backups and database replication.