Commack, NY *****
Tel: 631-***-**** (Cell)
OBJECTIVE: To seek a part time position for oracle DBA.
Over 18+ years of experience in Oracle Database Administrator, design, installation, patches, upgrades,
migrations, configuration, database security, capacity planning, space management, data modeling, backup and recovery, cloning,
auditing, SQL, PL/SQL, troubleshooting and documentation.
Supporting large dynamic production databases in 24x7 environments.
Strong knowledge of Oracle architecture and internal tool functionality.
Strong troubleshooting and problem-solving skills.
Proficient at Oracle DBA in the Oracle19c,12c, 11gR2 (11.2), 11gR1, 10gR2, 10gR1, and Oracle9i Database Administration in an Architect roll, Tuning, development, analysis, installation, patch, maintenance, configuration, backup and recovery; implement DB security, standby database, RAC, ASM, RMAN, Partition, Basic file/Secure file, Veeam backup, Oracle 13cR2/12c data grid control (OEM), Data Guard (DR), OID, Data gateway, and Advance Replication, RAC, OFS, Data loading, export dump, export and import.
Proficient at SQL server 2016, 2012 and 2008 software installation, patch, maintenance, configuration, backup, and recovery; implement DB security.
Experience in Oracle Form/Report Application Server 11gR2, and 10gR2 software installation, maintenance, and configuration,
Experience in programming in Visual Studio 2010 mvc4.0, C#, LING, jQuery, Visual Basic 2010, SQL, PL/SQL script, Oracle Form/Report and using Versata Logic Suite 5.6 to modify Java application. Intensive experience in Client/Server application development.
One years of work experience using Business Objects BO 4.2R2 Designer, CMC, Info view, Web-Intelligence, Import Wizard, Publishing Wizard, Metadata Manager, ETL loading to data warehouse.
Responsible for Oracle Database administration, maintenance, turning, configuration, backup, and recover in the AIX Unix, Window 2019,2016 2012, 2008, Window 2003, Window 7 and Cluster environments(RAC); Building new database; Migration database to latest version; Creating backup and recovery database scripts using RMAN utility; Creating, configuration OID database and replication each OID database; Creating a Physical and Logical Standby database (Data Guard) in the 12c, 11g and 10g ; Creating SQL scripts and procedures to database; Data loading; Creating report, views, triggers, functions and packages for applications, processing and analyzing data; implement DB security Create Unix shell scripts;
Responsible for many Oracle Application server 9i, 10g and 11g software installation, maintenance, turning, configuration for oracle web application (Oracle Form, report and sql_mod).
Responsible for configuration Oracle Network and ODBC Drive in the Unix AIX, Window server / professional, window XP, and window 7 server / workstation environments; Configuration Oracle Fail Safe in the window cluster. Building and configuration Real Application Cluster (RAC9i and 10G) in the window 2003 environment. Created RMAN script backup all the databases; Building and configuration two OID database (Replication each other).
Responsible for developer new script to monitoring of oracle performance. Build batch file for oracle nightly job.
Worked on transactional, data warehouse, standby database, and disaster recovery on window environment.
Managed and supported database partitions, materialized views, Database links and database objects in database environment. Gathered system, schema, table, index, and partition statistics. Created partitions, sub-partitions, large tables and merged, split partitions based on business requirements.
Responsible for third party company’s application analysis, installation, testing, troubleshooting, documentation, and maintenance,
Independently planning, analysis, designed, developed and implemented one application:
* A Wide Area Network request form which keeps tracks of County Government equipment usages, bills, payments, credits and charge back records etc. The project was developed used Visual Studio 2010 mvc4.0, C#, PL/SQL script, LING, JQuery, ADO controller, Entity framework and Crystal Report utilizing a two-tier environment.
08/2019 ~ Present System & Database Coordinator (Grade 31) Suffolk County Government
Leader and managed Oracle DBA team.
Responsible for designed database architectures, solutions, developer, implement and manager for the Suffolk County Government Clerk department.
09/2006 ~ 08/2019 Database Manager (Grade 29) Suffolk County Government
Leader and managed Oracle DBA team.
Responsible for designed database architectures, solutions, developer, implement and manager for the entire Suffolk County Government -- ITS department.
07/2000~ 01/2006 Programmer Analyst (Grade 24) Suffolk County Government
Responsible for analysis, design, coding, testing, installation, troubleshooting, documentation and maintenance of complex application on an N tier relational database environment, providing end user support for new applications and coordinating and training technical staff to meet support and maintenance requirements for the system.
Independently designed, developed, and implemented:
* A Telecommunication system, which keeps tracks of County Government phone usages, bills, payments, credits, and employee’s phone records etc. The project was developed used VB 2010 & 6.0, Oracle9i, 10g, 11g, SQL, ADO controller, Entity framework and Crystal Report utilizing a two-tier environment.
* A SURVEY system, which keeps tracks of surveying a many number of positions within an agency. Project was developed in a three-tier environment using VB.net, Oracle9i, SQL, PL/SQL, ODBC, OLE, JDBC controller and Crystal Report.
09/1998 ~ 07/2000 Programmer Catalog Makers, Inc.
Responsible for Install and Maintain Network System; Install and configure hardware, Drive, PC network card, hubs, modems; Setup, configure, and troubleshooting of network printers; Install and maintain various software applications.
Responsible for Paradox Database administration, maintenance, turning, configuration, backup, and recover.
Responsible for Designing and Implementing Distributed application with Visual Basic 5.0, Access, SQL
Designed, implemented, and developed a complete computer programmer for Catalog Order System and Catalog Credit System. They use Visual Basic 5.0 for graphical user interface and using ADO connect Access Database.
M.S. Computer Science, University of Bridgeport, Bridgeport, CT.
IMMIGRATION STATUS: USA Citizen
WORKING STATUS: Flexibility.