SUMMARY:

• DBA (Oracle, MySql, Sybase Sqlserver, Db2UDB,, ) System Administration (Solaris, HP, Linux, Win) and database developer with 20 years IT experience in various industries including higher education, insurance, airlines, and retail.
• Managed full life cycle development/deployment of complex system including web technology, client/server applications and packaged solutions.
• Extensive experience in capacity planning, performance evaluation/optimization, disaster recovery planning with scripts & RMAN.

TECHNICAL SKILLS:

Database: Oracle 7 - 12c. MySql, SQL server, Sybase ASE, Dataguard, RAC, Replication, installation/Configuration, Performance Tuning, Data Migration, Security Issues, Tivoli, context option, Data Warehousing, Data Modeling, Logical/Physical design, DataMart, Designer, Brio.

Applications Oracle: Apps11, Oracle Express, OLAP, Informatica/Cognos, Discoverer, Oracle

Gateway, Business Object

Systems: Solaris/ Enterprise Server, Aix, HP - UX, Linux, Net Backup, WINDOWS, Sun Clusters, Vxfs, Vxvm, SAN, AIX HACMP, Shell/Perl Scripting, Networking (TCP/NFS/NIS), Firewall Issues

Development: PL/SQL, JDBC, DBI, shell, Perl, XMLOthers IBM MQ, WebLogic, Websphere, Oracle 9iAS, Dataguard, Oracle context, iPlanet, Peoplesoft HRMS BMC Tools, OEM, ERWin, TOAD, DBArtizen, Veritas, EMC, SRDF, Apache, DNS Server, jumpstart, Sun cluster 3.0, Veritas Volumemanger 3.1.

WORK EXPERIENCE:

Confidential, New York

SR DATABASE ADMINISTRATOR

• Provided architecture design and implementation of databases, backup and contingency recovery strategies for OLTP/ Data Warehouse databases in the Confidential .
• Designed and implemented disaster recovery plan using standby databases with data guard.
• Quarterly Disaster Recovery Exercise.
• Created scripts for Regular database backup, recovery, monitoring.
• Installed all Oracle databases and OEM/Dbartisan tools on Unix/Linux and Win environments.
• Installed Oracle software and implemented database and applications on the server.
• Responsible for monitoring and troubleshooting the database environment.
• Analyze the database performance and performed database performance tuning utilizing Oracle ADDM .
• Developed /Maintained full cycle database duplication process using Rman duplication and Materialized view.
• Enforced security for data with TDE and SSL technology.
• Regular patching and upgrade of databases.
• Migration of databases and applications to CI (VMware) infrastructure.

ENV: Linux, Solaris, AIX, Win, Oracle(12, 11, 10, 9), MySql, RAC, pl/sql, Shell, Perl, OEM, DBartisan, Toad, TSM, RMAN, Dataguard, Mviews Vmware, Nfs.

DATABASE ADMINISTRATOR

• Creation of Oracle 9i/10g databases on SUN/AIX/Win servers,
• Administration and maintenance of production and development environments in RAC as well as single instance DB I/C. Plan and size databases. Implement security using Oracle FGAC, Roles. Plan and develop failover and standby databases, Dataguard option, and upgrades. Regular DBA tasks such as performance tuning, monitoring system health, applying patches. Development of backup & recovery strategies using RMAN and shell script.
• Installed and support Oracle RAC,
• Implement and maintain advanced replication environment.
• Maintain Oracle Apps server 9ias,10g for a web based application
• Monitor application on 24/7 basis for application and data transfer/loading using script, pl/sql.
• Migration database to different version.
• Maintaining scripts with Oracle SCM.

ENV: Solaris, AIX, Win, Oracle(10g, 9x, 8x), RAC, OAS(9ias,10g), pl/sql, Shell, Perl, OEM, TSM, RMAN, Dataguard, Replication, Vxvm,

DATABASE ADMINISTRATOR

• Creation of Oracle 9i/10g,Sqlserver 2k databases on SUN/HP/Win/Linux servers,
• Administration and maintenance of production and develpments environments in RAC and single instance DB I/C. Planned and sized of the database. Implemented security using Oracle FGAC, Roles. Planed and developed failover and standby databases, Dataguard option, upgrades. Regular DBA tasks such as performance tuning, monitoring system health, applying patches. Development of backup & recovery strategies using RMAN, Shell and perl
• Implemented, maintaining advanced replication environments.
• Maintained Oracle Apps server 9ias,10g for an web based application
• Installation, configuration and support of Application Server, Web server.
• Monitored application on 24/7 basis for application and data transfer/loading using script, pl/sql.
• Migration database to different version.
• Maintained scripts with Oracle SCM.

ENV: Solaris, HP, Win, Oracle(10g, 9x, 8x), RAC, OAS(9ias,10g), Sqlserver, pl/sql, Shell, Perl, OEM, RMAN, Dataguard, Replication, Vxvm,

Sr. System Support Engineer.

• Creation of Oracle 9i databases on SUN/Aix/win servers, i/c database for data warehousing.
• Development of backup & recovery strategies using RMAN, Shell and perl
• Installation and configuration and support of Application server, Web server.
• Monitored application on 24/7 basis for application and data transfer/loading using script, pl/sql.
• Support as Sql server backup DBA

SYSTEM ADMINISRATION

• Administration and maintenance of different Production Server i.e DNS server, mail server, database server, Solaris Development/Production servers
• User administration, space administration, backup administration with tape backup and Veritas Netbackup utility. 24/7 production support for system and applications.

ENV: Solaris, Win, Oracle(9x,8x), RAC, SQL server, pl/sql, Shell, Perl, OEM, RMAN, Oracle Express, Dataguard, Websphere, Vxvm, Netbackup, Business Object

Sr. DBA/Solaris System Administrator

• Installation, configuration and 24/7 maintenance of database server ( Oracle9x, Sqlserver 2k), i/c Database creation, schema generation, User management, setting security points, Wrote pl/sql, trigger, shell & perl script for enforcing business rules and job automation .
• Data migration from dbaseVI in SCO to Oracle and sqlserver (solaris and HP).
• Installed, configured and administered 9iAS
• Designed and generation of reports in OLAP environment for different business needs.
• Installed, configured and administered Solaris server.
• Support as SQL server backup DBA
• Administration of Veritas Volume Manager 3.1.1, Raid manager 6.1.1, Veritas Netbackup, Maintainance of ssh, sudo, tcpwrappers
• Experience in operational support (on call support), performance monitoring, backup management with shell scripts and RMAN scripts and end-user support. Knowledge of Firewall, Routers and Switches

ENV: Solaris, HP, Win, Oracle, Sqlserver, Sybase, pl/sql, Shell, Perl, OEM, RMAN, Discoverer, Websphere, Vxvm, Netbackup, Business Object, 9iAS.

Sr. Database / System Administrator

• Performed requirement analysis, capacity planning for databases and system infrastructure.
• Performed installation, configuration, deployment, migration and upgradation of various systems and database servers (Oracle, SQL server, DB2 UDB), system design, schema design, and data modeling. Implemented security standards, plans and policy.
• Developed stored procedure, packages, triggers, scripts (Shell, Perl, Sql), and C/java programs as required. Developed strategies for disaster recovery, backup with shell and RMAN scripts, testing, verification & validation, data cleansing.
• Used Cognos, Informatica for large Data warehouse Design and Analysis(OLAP). Installed, configured and administered oracle apps
• Installed, configured and administered 9iAS
• Installed, configured, and administered Peoplesoft Hrms, ATG DYnamo, Websphere, Oracle AS
• Installed and support Oracle RAC, Dataguard, multimaster replication system(production system).
• Used extensively Oracle advanced queuing, partitioning, Oracle intermedia etc.
• Was responsible for Data Migration from Oracle to DB2 and Sybase to Oracle.
• Using DB2PM Real-time monitor, and DB2PM EXPLAIN Report.
• Experience in Tivoli, EMC storage SRDF and Timefinder, SQL-Backtrck, Security packages, Firewalls
• Developed XML Applications (Data Presentation/ Exchange) using ORACLE Environment
• Solaris & Linux installation, configuration and setting up for the networks environment, Managed System Users, security and system monitoring .

ENV: Solaris, HP, Win, Oracle, DB2UDB, RAC, Sqlserver, Sybase, Shell, Perl, RMAN, ATG Dynamo, Vxvm, Netbackup, Dataguard, Informatica, BO, Cognos, 9iAS.

Oracle Developer

• Installation, configuration and support of Oracle 8x (Aix, HP, win 2K, Solaris), Parallel/Replication server environment, Hot Standby, Database design (Physical & Logical), Data modeling.
• Installed, configured solaris server for database server for e commerce environment.
• Analysis, schema generation and design for datamart, Terrabyte Data warehouse
• Implementation of 2-node OPS, utilities to automate the System & Database administration, Design and implementation of backup and recovery plan using Scripting and RMAN.
• Developed Stored Proc, SQL scripts, Triggers for Implementing Complex Business rules.
• Web page development with ASP and java script.
• Upgrading Operating systems (Solaris), Patch Update and managed User Accounts and groups.
• Installed and configured Application server, webserver, applications and security packages.
• Installation, support of Sybase ASE, DB2/UDB and SQLServer, SQL-Backtrack for various database.
• Analysis, querying and reporting using Informatica, BO and Oracle Express
• Was responsible for Data Migration from DB2 database through Oracle Gateway.

ENV: Solaris, HP, Win, Oracle, RAC, Sqlserver, Sybase, Shell, Perl, OEM, RMAN, Cognos, Oracle Express, Websphere, Vxvm, Netbackup, Business Object