Oracle Database Administration/Database Development

Responsibilities and tasks included:• Develop Extraction Transformation and Load (ETL) programs for data warehouse using SQL and Kornshell.• Database performance and tuning optimization.• Do analysis for logical/physical optimization. • Implement Tablespace and Datafile optimization (Logical and Physical Design). • Provide 24/7 DBA support for Oracle systems.• Develop UNIX Kornshell for monitoring, maintenance, and other automation.• Develop procedures, triggers, packages, and monitoring programs using SQL.• Develop dynamic/native SQL applications.• Perform data modeling analysis, transaction analysis, and recommendations. Build DB2 database instance, load scripts, and ETL programs.. Migrate DB2 database to an Oracle 9.2 instance.. Build Oracle load scripts, ETL programs, and automation.. Upgrade Oracle 9i to 10g. Upgrade Oracle 10g to 11g.• User and developer support.. RMAN backups and scripted Oracle backups.. Develop automated monitoring apps for security and space management.• Write technical documentation.Primary Software in Use:• Oracle 10g, 11g, PL/SQL, Sun Solaris (Kornshell), Windows 7, SQL Developer.

Responsibilities and tasks included:• Develop Extraction Transformation and Load (ETL) programs for data warehouse using PL/SQL and Kornshell.• Database performance and tuning optimization.• Do analysis for logical/physical optimization. • Implement Tablespace and Datafile optimization (Logical and Physical Design). • Provide 24/7 DBA support for Oracle systems.• Develop UNIX Kornshell for monitoring, maintenance, and other automation.• Develop procedures, triggers, packages, and monitoring programs using PL/SQL.• Develop dynamic/native SQL applications.• Implement re-vamps of coding and documentation standards.• Perform data modeling analysis, transaction analysis, and recommendations• User and developer support.• Provide assistance to Cognos developers in implementing reports for data warehouse.• Write technical documentation for knowledge transfer.Primary Software in Use:• Oracle 8.1.7 Oracle Enterprise Manager, Sun Solaris, Windows 2000, Erwin, DB Artisan, Spotlight, SQL Lab, SQL Navigator, XML, Java.

Responsibilities and tasks included:• Database performance and tuning optimization.• Do analysis for logical/physical optimization. • Implement Tablespace and Datafile optimization (Logical and Physical Design). • Provide 24/7 DBA support for Oracle systems.• Develop UNIX Kornshell for monitoring and other automation.• Develop procedures, triggers, packages, and monitoring programs using PL/SQL.• Develop dynamic/native SQL applications.• Implement re-vamps of coding and documentation standards.• Perform data modeling analysis, transaction analysis, and recommendations• User and developer support.• Develop replacement programs for Oracle startup and shutdown scripts to include notification and logging.• Provide assistance to Java developers in implementing Java within Oracle.• Train junior level DBA(s).• Write technical documentation for knowledge transfer.Primary Software in Use:• Oracle 8.1.6 through 9i, Oracle Enterprise Manager, RMAN, Sun Solaris, Windows NT, Windows 2000, Erwin, DB Artisan, XML, Java.

Responsibilities included:• Upgrade from Oracle 8.0.4 to Oracle 8.1.6. • Database performance optimization.• Do analysis for logical/physical optimization. • Tablespace and Datafile optimization. • Extraction Transformation and Loading of data (ETL).• Provide 24/7 DBA support for Oracle systems.• Develop backup programs using RMAN.• Unix Kornshell development.• Develop stored procedures and triggers using PL/SQL.• Perform data modeling analysis/transaction analysis and recommendations• User and developer support.• Train junior level DBA(s).• Design, implement, and maintain DBA web pages.Primary Software in Use:• Oracle 8/8i, Oracle Enterprise Manager, RMAN, HP UNIX, SUN UNIX, Windows 2000, Windows NT, DB Artisan, Erwin, Java, SQL Server 7/2000.

Responsibilities included: • Install Oracle 8.1.6. • Do analysis for logical/physical optimization. • Tablespace and Datafile optimization. • Extraction Transformation and Loading of data (ETL).• Utilized Oracle Native SQL for rapid implementation of numerous Tablespaces/Datafiles.. System migration using Oracle Transportable Tablespaces and SQL Loader.• Assisted in the loading of Terabytes of data into Oracle databases.• Designed and implemented database strategy.• Unix Kornshell development.• Trained junior DBA.Primary Software in Use:• Oracle 8i, Oracle Enterprise Manager, DB Artisan, HP UNIX, SUN UNIX, Windows NT.

Responsibilities included:• Technical Lead on Oracle to Tandem conversion project.• Extraction Transformation and Loading of data (ETL).• Develop CORBA/Java replication from Oracle Unix based database to Tandem based database. • Setup Oracle replication.• Setup Oracle job queues and job queue control programs including email notification from within Oracle.• Provide 24/7 DBA support for new Oracle system.• Unix Kornshell development.• Develop Java mail notification from within Oracle.• Develop stored procedures and triggers using PL/SQL.• Perform data modeling analysis/transaction analysis and recommendations• Analyst, user, and developer support.• Write technical documentation and train development team for knowledge transfer.Primary Software in Use:• Oracle 8i, Oracle Enterprise Manager, HP UNIX, SUN UNIX, Java, Erwin, Windows NT.

Responsibilities included:• Provide 24/7 DBA support for existing and new Oracle systems.• Help setup and maintain Oracle replication.• Heavy development with Unix Kornshell setting up automated diagnostics, statistics, and backups. . Develop monitoring scripts for Sun Clustering High Availability system.• Develop stored procedures using PL/SQL.• Perform data modeling analysis and recommendations• Analyst, user, and developer support.Primary software used:• Oracle 8i, Oracle Enterprise Manager, HP UNIX, SUN UNIX, RMAN, DB Artisan, Windows NT.

Responsibilities included:• Provide 24/7 DBA support for existing and future SQL Server systems.• Assist in design and deployment of SQL Server on 12 systems. • Set up automated diagnostics, statistics, and backups. • Develop stored procedures using SQL.• Set up replication from primary site to 11 client sites.• Perform data modeling analysis and recommendations• Evaluate and recommend software, and hardware purchases.• Analyst and developer support.Primary software used:• Windows NT, Microsoft SQL Server 6.5, Power Designer. DB Artisan

• Technical support

Responsibilities included:• Provide 24/7 DBA support for existing and future Oracle systems.• Design, Oracle database template for optimum sizing and performance. • Deploy 53 NT based Oracle databases using the above template.• Develop migration DDL to move existing AIX based Oracle database to new machine.• Develop automation processes using dynamic PL/SQL, UNIX Kornshell scripts, and Delphi 3.0 (PL/SQL scripts and procedures must run on NT, AIX, Oracle 7x and Oracle 8x)• Extensive development using SQL, PL/SQL, UNIX Kornshell.• Evaluate and recommend software, and hardware purchases.• Analyst and developer support.Primary Software in Use:• AIX UNIX, Windows NT, Oracle 7x-8x on Windows NT and AIX, DB Artisan, Access 97, SQL Lab Expert, PowerDesigner, Delphi 3.0

Responsibilities included:• provided 24/7 DBA support for 21 Sybase, 6 Oracle, and 3 Microsoft SQL Server systems on various UNIX platforms and on NT.• Design, creation, optimization, recovery and security over database systems.• Develop automation processes using dynamic SQL, PL/SQL, UNIX Kornshell, UNIX CRON, mailx, FTP scripts. • Extensive development using SQL, PL/SQL, UNIX Kornshell.• Evaluate and recommend software, and hardware purchases.• User support.Primary software used:• Sybase System 11.02 for HP UNIX, AIX UNIX, SUN Solaris UNIX, Digital UNIX, System 11 for Windows NT, Oracle 7x-8x, Microsoft Sequel 6.5, Netware, Windows 95, Windows NT Server 4.0, DB Artisan, Access 97, Sybase Power Designer, Delphi 2.0.