SUMMARY:

Senior Database Administrator, a technical expert on RDBMSs focusing on Oracle products, Application Servers, Data Warehousing, Dimensional Modeling, PL/SQL Programming and Tuning, Oracle Architecture, Data Architecture, Database Design and E-Discovery. Currently pursuing CISSP certification in enterprise-level security with the goal of attaining the status of a CISSP certified professional. Completed training in MongoDB a NOSQL type database and Big Data from 10Gen.

SOFTWARE:

• Languages: PL/SQL, SQL, Java, Perl, T-SQL, SAS, XML, HTML, XSQL, R.
• Databases: Oracle 8.0.3-11gR2 11g R1/R2 RAC, Admarc, ADP, PeopleSoft, MongoDB, PostgreSQL, MySQL, SQL Server 2000, SQL Server 2005.
• OS: Solaris 7-10, RHEL, Windows NT, 2000, 2003, 2008.
• Tools: Oracle 9i-10g AS, PeopleTools 8.45, SQL Navigator, SQL Developer, JDeveloper 3.1-11g, RMAN, Discoverer, Oracle Data Integrator, Oracle Enterprise Manager, DB Control, Grid Control, SQL Server Management Studio, Warehouse Builder 9i-10g, Forms and Reports 10g, Designer6i-10g, Toad DBA Suite 10, E/R Studio, ERWin, Visio, Rational ClearCase, TKProf, Curam, VMware, Navisphere, SAN Copy, Mirror Copy, Crystal Reports, Business Objects, UDDI, XML, MS Project, Backup Exec 8.6, Jasper BI, Big Data, Exadata, MongoDB, Hadoop, RStudio.

EXPERIENCE:

Confidential

• Senior DBA for DHS/Enherent during the migration of all DHS Master Data legacy systems to an Oracle 11g R2 RAC-based system using a Java front-end and using Jasper for BI reporting. Developed and implemented a project plan for the migration of the CTS RAC 11g R1 system and its .Net applications to 11g R2 RAC/Curam/Java system. Worked on a daily basis with Oracle 11g R1 RAC to monitor and resolve issues, one of which was ORA 4030 problem.
• Fully documented the CTS production job system. Traced every production batch job showing data exchanges, tables used, described formats of data exchanges and created a reference document for management.
• Used ERwin and Toad DBA Suite to implement schema extracts from all production servers to document the ER models and the client's business applications. Implemented a Master Data Management System for the cleaning ETL and restructuring of agency data for migration.
• Researched and implemented the installation of Oracle10g R2 on a VMware Windows 2003 virtual machine. I found various workarounds to solve the issues to successfully install and configure the Oracle 10g R2 on Windows 2003 R2 VM VMware Virtual Machine .
• Worked with SQL Server 2005, the Management Studio and Oracle Management Server Grid Control for the CARES migration project to move legacy data to the new Oracle 11g R2 RAC/Curam/Java system.

Confidential

• Senior DBA/Systems Administrator for software vendor that administers interstate toll-collection systems for the MTA and the State of New York. Responsible for the design and performance tuning of ad hoc queries using AWR/ASH, the monitoring of Solaris and RHEL database servers via online applications, Oracle Management Server and DB Grid Control.
• Developed and implemented a plan for the load monitoring, software installation, configuring and testing of Sun Fire 490/Clariion CX3-40 systems and their I/O signature testing for maximum throughput. Configured the CTR Servers and the Navisphere Manager to monitor operations. Evaluated backup plans using RMAN and EMC Navisphere snapshots.
• Worked with Rational ClearCase and ClearTool software to create enhanced versions of stored Forms and Reports, DDL and DML programs. Integrated Rational ClearCase software with Oracle IDS suite for use with Oracle Forms and Reports 10g R2.
• Collaborated on the design of the new CTR data warehouse that is a transactional repository and replacement for TRX over 4.5 TB . Employed ERwin, Oracle 11g, 10g/10g RAC, Exadata evaluated , Forms and Reports 10g in the design and rollout of the CTR Data Warehouse.
• Developed a Metadata Repository in order to implement schema extracts from all production servers for Master Data Management using ERwin and Oracle Designer.

Confidential

• Senior Database Administrator responsible for the day-to-day management of the PeopleSoft financial database system using Grid Control. Managed the following components of PeopleSoft: GL, AR, AP, E-Pro and AM. Validated and tuned PL/SQL and SQL queries, procedures and objects that were added to the PeopleSoft system and other databases.
• Developed methodology for the exchange of data between Oracle 10g R2/10g RAC and SQL Server 2005. Developed procedures, objects, triggers and tables on both databases for the migration of data into the .NET Enterprise Reporting System.
• Implemented adherence to security standards for access to financial systems. Developed and implemented a methodology for successful audit compliance review by Ernst Young.

Confidential

Developed a project plan for the migration of the insurance premium application. Migrated the Oracle 9i R2 insurance premium application from Windows 2000 AS to RHEL. Installed Oracle 9i R2 on RHEL on Dev, UAT and Prod server environments using ERwin. Implemented schema extracts using ERwin, created and documented the ER models.

Confidential

• As Senior Database Administrator, managed the database department and was in charge of various projects including the management and installation of Oracle 9i R2, 10g R2, 10g AS, BI, IDS and evaluation of other RDBMs such as MySQL PostgreSQL and Goldengate. Created and managed multi-lingual databases on Solaris 8-9, RHEL, Windows 2003 servers. Validated and tuned SQL and PL/SQL queries, procedures and objects. Implemented Master Data Management and Reference Data Management for the indexing of business directory data.
• Designed and implemented the Business Directory Data Warehouse employing a multi-lingual-based Unicode for all company data sources and implemented this design on production systems using ERwin, Oracle 10g R2 and Solaris 9. Created a system of PL/SQL load programs and clean-up scripts for the ETL scrubbing process for the monthly/bi-weekly update processes for D B, INFOT Chinese database and Atrix Who Is Data data sources. Created a series of BI reports using Oracle Discoverer and SQL scripts for Accoona Toolbar adoption program. Created a backup schedule for the Org Data Warehouse using RMAN.
• Designed Oracle database models using ERwin/Visio for Data Architects/Oracle Designer both logical and physical to meet various business requirements. Created a Meta Data repository using ERwin and Oracle Designer, which allowed for multi-user access to the models and data. Formulated database structure using ERwin and generated business logical flow and Oracle DDL.

Confidential

• Worked on various projects for corporate clients using Oracle 8i-11i 11.5.5 , 9i AS and 9i DS. Implemented Oracle for both OLTP and DSS databases.
• Developed a project plan for the migration of the CAT database from a single-drive database to distributed databases using RAID 10 storage for development and production environments.
• Manually created several Oracle instances on two Sun servers running Solaris 9 and documented the process. Configured and migrated current databases to these instances.

Client:

Developed a project plan for the installation of Oracle 11i release 11.5.5 on a Windows 2000 advance server on a Dell 6450 four-way server with two storage arrays. Purchased, downloaded and staged required software on the target server. Installed prerequisite software Visual Studio 6.0, MKS Toolkit, GNU C Compiler and installed and configured Oracle Financials 11.55 on a Windows 2000 AS and Solaris platforms for a company client.

Confidential

• As Senior DBA, managed the database team, provided application and production support for many company and client databases. Monitored and backed up all database instances using RMAN. Tuned PL/SQL and SQL using Explain Plan, SQL Trace, OWI, SQL Analyze and Tkprof. Created Reference Data Processes for the import and incorporation into our databases.
• Designed an Employee Enrollment Application for the HR department to allow employees to sign up for company-sponsored classes using a web interface. Created and implemented logical and physical design of a Java browser-based Class Registration system for company employees using JDeveloper 3.1, Apache, Java, XSQL, ERwin, E/R Studio and Designer 6i-9i. Developed Oracle 9i AS and 9i R2 based infrastructure for the development of Java-based applications.
• Designed SearsTGI Data Warehouse using ERwin, PL/SQL tools and Oracle 9i R2. Led the team in the optimization of the SearsTGI database's PL/SQL load programs to increase the efficiency of the code and to bulletproof the update process. Created a Meta Data repository using ERwin and Oracle Designer, which allowed for multi-user access to both models and data.
• Developed a SAS Compiled Macro Library application and created documentation for this system based on KBM's CMS statistical modeling macros.
• Managed statistical software licensing for Wunderman North American offices.
• Created a SAS administrator contacts and product licensing database to facilitate communication between administrators.
• Led the database team that developed, installed and configured new database servers for Wunderman. Installed SAS 6.12, 8.0, 8.1 and configured SAS for remote submissions of SAS programs to the new servers.

Confidential

• Lead DBA responsible for the migration of ADABAS/Natural to Oracle. SAS and ADABAS/Natural Security Officer DBA for the MVS test environment. Responsible for the migration of ADABAS/Natural production data to a Windows NT/Oracle environment for preliminary data modeling of the CIF Data Warehouse. Created the SAS VM/CMS mainframe-based Daily Pension Funds report that allowed pension fund managers to know how much capital they could invest on a daily basis.
• Managed a team of eight programmers developing multi-user applications and supervised all projects and programmers assigned to it.
• Worked on the logical and physical design of CIF Customer Information Facility , a Data Warehouse designed to contain summarized data from all mainframe and client-server systems.
• Designed and implemented a Data Warehouse using ERwin and Oracle 8-8i on Windows NT/2000 and MVS/VM/CMS. Migrated data from corporate mainframe systems to Windows-based servers. Created migration jobs to move data from the mainframe to the CIF Data Warehouse.
• Created a SAS mainframe environment where SAS online applications were run against mainframe corporate data sets to generate reports and allow interactive full-screen access to corporate data. Migrated full versions of several medium-sized data sets to the PC using the SAS Connect product to offload mainframe congestion.

Confidential

• Statistician responsible for the creation of statistical models and analysis of applicant information with emphasis on income and geographic segmentation.
• Created and administered a PC/SAS environment where SAS programmers write code running against subsets of mainframe applicant data segmented geographically. Offloaded from the mainframe migrated full versions of several medium-sized data sets to the PC using the Connect SAS product.
• Used SAS on the mainframe extensively to generate reports using data from large financial databases this information was used to generate graphs using graphic stream files that were downloaded to a remote site.

Confidential

Actuarial Technician responsible for the creation of statistical models and analysis of premium ratios for various states. Developed models that were used by member companies to better predict losses based on historical client information.