Oracle Sql
Resume:
Alexei Sklyar
Hallandale Beach, FL 33009
******.******@*****.***
PROFESSIONAL PROFILE:
Proficient and dedicated MIS professional with experience in business application development. Able to work under deadline pressures.
SOFTWARE/ Environment:
ORACLE 6 /7.3.3/ 8i/9i/10g/11g/12c, SQL, SQL*PLUS, PL/SQL, ORACLE Forms 3.0/4.0/4.5/5.0/6.0/6i/9i/11, Reports3.0/6.0/6i PRO*C, SCO UNIX 5.0.5, MS Windows NT/2000/XP/2003, SQL*LOADER, RMAN, VERITAS Backup Exec 8.6, EMC (Legato) NetWorker 7.3.2, DataPump, FlashBack technology, QDesigner, Rational Rose, SQL Navigator, Spotlight On Oracle, BI Publisher, Application Express (APEX), OEM, Oracle Secure Backup (OSB), Automatic Storage Management (ASM), Active Data Guard, NetApp SMO 3.0.1, Oracle Enterprise Linux. RAC on Oracle Database Appliance Machine(ODA). Sun ZFS Storage NAS Appliance 7420,ZS3-2, Oracle Virtual Compute Appliance (OVCA), Oracle VM.
EXPERIENCE:
Tracintermodal Corporation, Princeton, NJ
Sr Database Administrator January 1999 - present
●Administer and manage more than 100 databases.
●Performed Production upgrade from 10GR2 to 11gR2 from NetApp SAN storage to 2 node RAC configured Oracle Database Appliance machine.
●Created NFS mounted clone databases using CLONEDB feature.
●Created NFS mounted clone databases using ZFS's snapshot technology.
●Performed Production database upgrade from Oracle 9iR1 to 11GR1 on ASM feature.
●Responsible for migrating Oracle 7.3.3 from SCO Unix 5.0.5 to 9i R1 on Windows/2000 platforms.
●Performed Production database upgrade from Oracle 8i to 10GR2.
●Created numerous packages, stored procedures, functions and database triggers for company specific security application allowing logging all database activities on demand to keep actual DML statement and all rows affected by it for defined users.
●Implemented Virtual Private Database to restrict user access to specific rows in tables.
●Implemented database versioning (Workspace Manager) for the specific projects.
●Responsible for Database/SQL/PL/SQL performance tuning.
●Defined and enforced PL/SQL standards for the company.
●Created and tested backup and recovery strategies for company’s need.
●Implemented Production Backup strategy using NetApp snapshot technology using SMO with conjunction with RMAN /EMC NetWorker/Oracle Secure Backup.
●Implemented Active DataGuard database.
●Extensively used data extraction from/to Oracle database using SQL*Loader, Export/Import and DataPump utilities.
●Responsible for managing users and roles for security purposes.
●Created multiple Interactive reports using Application Express.
●Responsible for migrating Oracle databases from Windows to Oracle Enterprise Linux.
Senior Developer August 1998 - January 1999
●Responsible for conversion Oracle Forms 3.0 to 4.5/6i/10g.
●Developed database triggers for security needs
●Developed PL/SQL database packages to support Oracle Forms.
PrincetonTeleCom Corporation, Princeton, NJ May 1997 – August 1998
Senior Programmer/Analyst
Responsible for creating, testing, managing database triggers, stored functions, procedures, packages and numerous forms for the company’s automated bill payments system known as Paybill-2 ( 1-800-PAYBILL ). Responsible for SQL, PL/SQL performance tuning.
Environment: MS WINDOWS 95, UNIX, Windows NT, ORACLE 7.3 engine, Novell Network with TCP/IP Protocol, SQL*PLUS 3.3, PL/SQL 2.3, Forms 4.5, SQL Navigator 1.1d - 2.0
Systems & Computer Technologies (SCT) January 1995 to May 1997
Malvern, PA
Programmer/Analyst
Responsible for design, programming, testing, implementation of brand new Electronic Approvals technology for 2.1.5 release of Worldwide Software Product BANNER HR. Created Packages, Database Triggers, Database Procedures and Functions for HR development department.
Environment: UNIX, MS WINDOWS 3.1.1, ORACLE 7.3 engine, Novell Network with TCP/IP Protocol, SQL*PLUS 3.1,PL/SQL 2.3, Forms4.0/4.5
EDUCATION:
Oracle Certified Professional.
MongoDb online training.
Seminars in ORACLE TOOLS, ORACLE FORMS 4.5.
Attended Oracle Open World Conferences: 1998 – 2014.
Contact this candidate