SUMMARY

• 8+ years of IT experience as an Oracle Database Administrator on a variety of UNIX, Linux and Windows platforms with Oracle (12c/11g/10g/9i/8i/7.x). 11gRAC, Streams, Data Guard, Advanced replication, Installation, Configuration, Migration, Capacity planning, Performance Tuning, Backup and Recovery, Space Management, Disaster Recovery Solutions, Patch Management Security, OracleDatabaseVault, Oracle Audit Vault, Replication, Memory Management, RAC, Auditing, Goldengate, Data Pump, Troubleshooting. Good experience of setup & configuration, implementation of (Oracle 11gR2 RAC two - node and four-node on Linux with ASM).
• Proficient in installation, administering and managing Oracle 12c,11g, 10g, 9i, & 8i on SUN SOLARIS, HP-UX, IBM-AIX, WINDOWS, RHEL and REDHAT-LINUX.
• Software Installation, Upgrade, Patch implementation on Oracle versions 10g 11g & 12c and on all operating platforms including Linux, Solaris.
• Oracle DBA, providing 24/7 support for both development and production databases on various platforms. Responsible for round-the-clock database operations and offering solutions for Production/Development of database applications.
• Experience in configuring Database Vault and Key Vault to meet security compliance.
• Hands on experience in Mongo DB along with Web services skills
• Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.
• Exposure to several industry sectors - Finance/Mortgage, Internet/Web advertising, Telecom, State, Retail, Power, Banking/Credit card processing, Federal and Manufacturing.
• Experienced in installation and configuration of Oracle cluster ware and Automatic Storage Management (ASM) in RAC environment.
• Experience on Data Replication using GoldenGate and Oracle Streams. Hands on experience on setting up the environment for unidirectional, bidirectional propagation in Oracle Streams.
• Installation and configuration of 11g Oracle Enterprise Manager (OEM) grid control for Performance, Administration and Maintenance of Databases. Deployed agents on various targets.
• Experienced in applying patches including Patchsets and CPU/ PSU, One-Off patches on Standalone, RAC and Standby Databases using Universal Installer and OPatch Utility.
• Skilled in performing Logical backup using Traditional export/import and Datapump export/import.
• Professional experience architecting/operating solutions built on Amazon Web Services (AWS).
• Experience with Real Application Testing (RAT).
• Performing database reorganizations, statistics and other applicable utilities to ensure proper database function and performance based on Oracle best practice methodology
• Experienced in Space Management, Resource management and Capacity Planning.
• Configured and administered replication using Oracle Streams and Oracle GoldenGate technology.
• Implemented GoldenGate for data recovery and data migration for Oracle 11gR2 RAC multi nodes on IBM AIX and debugging issues such as extract, replicate and rebuild
• Proficient in working with Data Guard for production system in case of disaster recovery, maintained primary and standby databases, Data Guard Broker.
• Configuration of Oracle 10g OEM Grid Control, 12c Cloud Control to monitor database.
• Experience in performance tuning using STATSPACK, EXPLAIN PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
• Experience with applying version controls on databases using Flyway and GIT.
• Good understanding about PERL Scripting language.
• Performed and tested crash recoveries using conventional hot & cold backups and RMAN, cloning databases backups, performing PITR using RMAN
• Proficient in Exadata maintenance/support/backup/recovery.
• Experienced in using Oracle's Transportable Tablespace (TTS) feature allows users to quickly move a user Tablespace across Oracle databases.
• Experience in automate frequent mundane tasks.
• Expertise in performing Hot and cold backups with and without RMAN. Automated RMAN scripts using cron job and implemented VERITAS NetBackup to perform daily backups.
• Expertise in working with the tools like OEM, TOAD, Export/ Import, SQL * Loader, SQL Analyzer and managed system events and jobs using OEM.
• Experience in Oracle 11g services and architecture, database management techniques, data architecture and design techniques and SQL programming.
• Experience supporting Oracle R12 E-Business Suite application.
• Expert in Cloning and Manual creation of Oracle Databases.
• Strong oral and written communication skills. Ability to communicate effectively with support peers, end users, and all levels of corporate management. Manage vendor communication and create/host presentations.

TECHNICAL SKILLS

Operating Systems: UNIX (Sun Solaris 8/9/10/11), HP-UX 10.x/11i v3, AIX 5.3/6.1/7.1, RHEL 3/4/5/6, Windows NT/2000/2003/XP/2008, Oracle Linux.

Databases: RDBMS Oracle 8i/9i/10g/11gR1/11gR2/12c, MySQL (2005/2008/2012 ), SQL SERVER 2008 R2, Sql Server 2012, Sql Server 2014, Mongo DB ( NO SQL), Cassandra.

Tools: & Utilities: SQL*LOADER, GoldenGate, ASM, AWR, ADDM, QOPATCH, NID, DBVERIFY, SRVCTL, CRSCTL, ASMCMD, DBCA, ADRCI and DBUA, Oracle Enterprise Manager(OEM), Export/Import, Data Pump, Oracle Universal Installer, Database Configuration Assistant, Database Upgrade Assistant, Recovery Manager RMAN, Virtual Private Database, cloning, Spotlight,, VERITAS Cluster/Net backup, SQL expert, TOAD, Oracle Grid Control, SQL Navigator, Erwin, Commvault, Statspack, Oracle Cluster ware, Quest Live Reorg Tool, Oracle Partitioning, Real Application Testing (RAT).

Languages: SQL, PL/SQL, C, Java Minimal, UNIX Shell Scripting, PERL Scripting

Replication: Goldengate, Data Guard, Streams, Transportable Tablespace, Materialized views.

High Availability Solutions: Oracle Real Application Clusters (RAC), DataGuard, VM box, Automatic Storage Management (ASM), Database Mirroring, Log Shipping, Golden Gate, Exadata Storage, Dell Power edge, Sun STOREDGE.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Oracle DBA

Responsibilities:

• Design, Implement and support multiple scalable, highly available, zero downtime, multi-site load balancing Oracle based 50+ TB Oracle Database systems using Oracle 10g/11g/12c including RAC and ASM, Goldengate
• Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 10TB to 30TB on a 2 to 6 node RAC.
• Playing vital role in streamlining all the databases on Linux.
• 24*7 Production Technical Support and Hardware Support.
• Responsible for Implementation of Oracle 12.2.0.4 Grid Control and configured nodes for proactive monitoring and auditing.
• Responsible for installation and configuration of Oracle 11.2.0.4 for 3 Node RAC & Standalone machines.
• Configure unidirectional replication using Oracle Goldengate
• Installed and configured oracle 10g and 11g OEM Agent (silent and Agent push) and configure it on grid control.
• Installed and configured Oracle 12c GI and RDBMS software, and Responsible for upgrading Oracle 10g RAC to 11g RAC and 11g to 12c.
• Implemented and monitored 11g RAC Logical Standby database for reporting.
• Installed oracle 11g Data Guard Physical Standby at DR site for production nodes.
• Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g, and exadata servers.
• Disaster recovery of Exadata Dataguard Physical Standby. Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafile testing
• Created shell and Perl scripts for automated tasks.
• Performance tuning of oracle databases using Sql Access Advisor, Sql Performance Analyzer, Sql Tuning Advisor.
• Upgraded oracle 10g databases to oracle 11g R1 (11.1.0.6, 11.1.0.7) and 11g R2 (11.2.0.4).
• Performed Migration and Upgrade of databases to 10g and 11g.
• Upgraded oracle RAC databases from 10g to 11g.
• Installing agent 12c on the server. Adding high Available database with CRS, scheduling Backups through OEM12c.
• Implemented RMAN Image Copy Backup Strategy for very large Databases in minimizing the downtime for recovery.
• Applied version control using GIT and Flyway
• Mentor SQL, PL/SQL and performance tuning to Wide range of audience across the organization.
• Experience on working with Database Monitoring tools like TOAD, BMC PATROL.
• Setup and monitoredmulti node RAC to RACData guardwith real time applyfor DR and offload backups.
• Implemented and administered Oracle GoldenGate (v10) for Database Replication between production and reporting node, by using Oracle Streams in parallel to secure data and having the availability of the database during regular the upgrade or maintenance operation.
• Worked on oracle 11g New Features for Administration and Tuning.
• Reconfigured and restored OCR and Voting Disks for changing the bonding on 4/6 node RAC.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
• Responsible for Capacity Planning and Upgrade of Hardware and storage Arrays.
• Patching and Upgrades of Oracle 10g, 11g databases to protect from VTM.
• Worked on 10g and 11g oracle ASM management.
• Using RAT(Real Application Testing) to Capture production work load and replay in a test system and SPA(SQL performance Analyzer) - to identify performance divergence between workloads on source and target platforms
• Implemented the Security using Oracle Database Vault.
• Daily maintenance of Database firewall protection and file security
• Working on several databases across development, QA, UAT and PROD environments via use of command line and Oracle tools Oracle Enterprise Manager Cloud 12c.
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Responsible for monitoring and administering EMC Storage Arrays using Navisphere.
• Plan and design database changes necessary for data conversion, tool configuration, data refresh or migration or other initiatives related to large application development project.
• Troubleshoot or confer with others troubleshooting errors or production problems involving databases to determine causes and proposed solutions.
• Created MongoDB Binary Interchange and Structure Object Notation objects in the collection
• Created replica set primary to the secondary to copy the datasets.
• Troubleshooting issues on replication.
• Created schemas as per the user requirement on MongoDB, joins and complex aggregation.
• Worked on MongoDB profiler to resolve the performance issues.
• Set and document standards for use of databases with objectives of data integrity, data security, efficient operation, Oracle Audit Vault requirements, and the like.
• Used PL/Sql Tables, Ref Cursors and Varrays to process huge volume of data.
• Used Erwin for requirements analysis and database design of custom developed information systems, including databases of Transactional Systems and Data Marts.
• Migrating Oracle Database to Amazon Web Services (AWS).
• Managing AWS RDS databases.
• On call Production Support ON Shift Basis.

Environment: Oracle 12c,11g R1,11g R2, SUN SPARC, Dell Power edge, Sun STOREDGE 6140, 6130, 3500, EMC Storage, VERITAS NetBackup, Solaris 10, 9, 8 AIX 5.2, 5.3 BMC Patrol, 11g OPS center, Amazon Web Services (AWS), Exadata, Goldengate, Mongo DB ( No SQL).

Confidential, Cary, NC

Sr. Oracle DBA

Responsibilities:

• Technical and physical design, development, and maintenance of Oracle Server databases; including data analysis and modeling, programming, implementation, performance monitoring, tuning, cloning/refreshing, planning, problem resolution, and data dictionary administration.
• Installed and configured Oracle 10g, 11g RDBMS binaries and created databases of sizes 200 GB to 4 TB sizes on Linux servers.
• Worked as Oracle DBA consultant supporting CHW’s Oracle 11g and 10g databases.
• Patched Production as well as Test RAC environments to fix Oracle bugs.
• Performed Migration and Upgrade of databases to 10g and 11g.
• Worked on Adding a new node to an existing 4 node Production RAC Database.
• Patched databases using OPatch on 5 node production RAC database.
• Installed Oracle Cluster ware and created RAC databases on 10.2.0.4.0 on Linux Platforms with ASM.
• Creation of database structure change build and deployment in various environments and coordinating with release management teams with the help of Flyway Tool
• ASM Setup and maintenance on RAC databases.
• Oracle streams setup and performance optimization for replicating data from production RAC databases to reporting databases.
• Implemented Asynchronous Change Data Capture (CDC) on RAC to replace the replication mechanism which used triggers on the RAC.
• Used RMAN for backup and recovery to take the backup of databases.
• Configured and managed Data Guard for Production databases.
• Grid Control OMS and agent installation and Deployment.
• Replication and Extracting data and applying on production database's using GoldenGate
• UNIX Shell scripts for monitoring the processes, sessions, transactions on Production RAC database after migration.
• Implemented Real Application Testing (RAT), RMAN new compression algorithm and tested active standby data guard.
• Exadata Database machine administration and patching.
• Focusing on Exadata administration on Full rack, Half Rack and Quarter Rackand incorporated Dataguard for maximum Availability.
• UNIX shell scripts for partition maintenance.
• Providing database support for development and deployment of database scripts in Development, Test, Pre-Production and Production environments.
• Responsible for implementing ITIL roles, and was the point of contact and responsible for coordinating all change functions.
• Resolved Database Firewall error received during validation when installing Oracle on server.
• Documentation for Cluster ware installation, RAC installation, RAC Database creation, Grid Control installation, ASM setup, Agent Deployment and so on
• Worked independently with oracle support to resolve outstanding issues or bugs under the supervision of the team lead.
• Experience in replication using GoldenGate and Materialized Views
• Range, Range-Hash, Hash partitioning on Production databases.
• Guided Production support teams while patching Oracle RAC production databases.
• Implemented Live Reorg tool in production environments and mentoring Production support teams.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Created Cursors, Collections and DB Triggers.
• Utilized PL/SQL nested tables for conditional trafficking of data within ETL process.
• Filtering of data by developing reusable PL/SQL functions.
• Worked on Oracle E-Business suite EBS-12.2.3 release.
• Extensive PL/SQL programming including Development of new backend packages, procedures and functions to in corporate advanced modules.
• Experience in upgrading and migrating various versions of Mongo database on different platforms.
• Migration of data from Customer datacenter to Amazon Web Services (AWS).
• Execute test and oracle audit vault strategies for backup, security, and disaster recovery of Oracle Server Databases.

Environment: Oracle 11g/10g, 10gR2 RAC, Oracle Cluster ware, RMAN, Oracle 10g Grid Control, Oracle 10g Streams, Data Guard, Sun Solaris, NetAPP Filer, Korn Shell scripting, Amazon Web Services (AWS), ASM, Quest Spotlight for RAC, Exadata, Mongo DB, Oracle Change Data Capture (CDC), Quest Live Reorg Tool, Oracle Partitioning.

Confidential, Louisville, KY

Sr. Oracle DBA

Responsibilities:

• Supported 50+ databases including RAC Production database, a data warehouse database and lot of Development and Test databases.
• Planning, Migration, Implementing and Validating various versions ofOracle Databases to 10gR2(10.2.0.4,)& 11g R1 (11.1.0.7)&11gR2 upgradeson all the environments (in a procedural approach Dev, TestStage and Production) also planning of back out procedures like downgrades/building parallel environments and also working on proof of concept forOracle 11g upgrades
• Responsible for administration and supporting Oracle 11g, 10g RAC databases in DEV, QA, UAT and Prod environments.
• Responsible for maintaining Oracle 11g R1 using SRVCTL, Oracle Enterprise Manager (OEM)
• Grid Control, maintaining Oracle Cluster ware using CRSCTL.
• Implemented Data Guard/Standby solution for Disaster Recovery.
• Scheduling and maintaining RMAN (Recovery Manager) backups to the FRA.
• Downsizing and defragmenting the Large Databases by export/import, cloning those using
• RMAN duplicate features and then upgrading them to Oracle 11g.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Proactive database monitoring using 11g grid monitoring tool.
• Experienced in PL/SQL programming to resolve various problems.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas
• Applied PSU patches to Oracle Databases and Oracle Applications.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM.
• Upgraded from 10g to 11g.
• Implemented Goldengate on Exadata X2 server machine.
• Designed and developed Oracle Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Performed an extensive POC with Oracle Exadata by migrating existing database and using Real Application Testing (RAT) in order to see how much of a performance improvement would be expected.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Monitoring and resolving tickets in different environments.
• Export and Import of database objects to copy from one database to another database between different environments.
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical
• Backups (with Export/Import Data Pump utilities).
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Created UNIX shell scripts to automate batch jobs through Cron.
• Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases.
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Environment: Oracle 11g, 10g, Oracle RAC (11g), Oracle Enterprise Manager (OEM), IBM-AIXSun Solaris RMAN, Import/Export, ASM, AWR, STATSPACK, TOAD, Unix Scripting, GoldengateSQL*Plus, PL/SQL.

Confidential, Westbury, NY

Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle Database Software 10g on Sun Solaris and Linux-4x, 5x.
• Installed, Configured and Managed Oracle 10g on HP-UX and IBM-AIX environments for production, test and development.
• Upgraded databases from Oracle 9i to 10g. Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
• Involved in creation of Data Warehouse database (Physical Model, Logical Model) using Erwin data modeling tool.
• Involved in logical backup using full/ partial export/import and Data Pump.
• Installed, configured, supported and troubleshoot databases on Veritas Cluster on top of Solaris 9.
• Performing the capacity planning for databases.
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Tuned SQL statements using explain plan and Tkprof. Monitoring and Performance tuning.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Installed and controlled Grid Control to monitor RAC and Non RAC instances patched and upgraded the grid control.
• Installed, configured and managed OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Configured initial and incremental load using GoldenGate.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios using RMAN.
• Involved in NoSQL and relational data modeling.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Scheduling Automatic scripts for GoldenGate reboot.
• Configured and troubleshoot ASM Cluster File System (ACFS) for Grid/RAC cluster.
• Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.
• Created and maintained materialized views.
• Modified and debugged stored procedures and triggers.
• Monitor database activity and file usage, and ensure necessary resources are present, so that databases function properly by removing or deleting old or obsolete files.
• Performing all the Database Administration activities like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Performed Table space Management and Rollback table space Management.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Converting single instance database to Real Application Cluster (RAC).
• Conducted Real Application Testing (RAT) for major database upgrades.
• Created Dimensional and Relational Physical & logical data modeling fact and dimensional tables using Erwin.
• Transaction Management and Security Management.
• Plan, coordinate, and implement network security measures.
• Interacted with the users and Troubleshooted the problems related to the privileges & resources
• Provided System support for both development and 24*7production environments.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Majority of the work was done in UNIX environments, including Sun Solaris, IBM AIX, HP/UX, and Linux. Sysadmin work often included O/S install, config, user administration, disaster recovery planning, network support and custom scripting with tools such as ksh, bourne, bash, perl.

Environment: Oracle 10g,9i,Sun Solaris 9, Linux-4x,5x, Windows, RAC, OEM, Oracle Streams, Golden Gate, RMAN, StatsPack, Export/Import, SQL*Loader, SQL and PL/SQL, Mongo db.

Confidential

Oracle DBA

Responsibilities:

• Installed, created and configured 9i and 10g databases and Clients.
• Installed and Configured 4 node RAC and plan to maintain the production environment
• RAC installation and configuration for 4 node cluster.
• Created 3 production physical standby databases and 9 non-production physical standby databases.
• Software installation and Database design done using ERwin and critical patches applied in LINUX.
• Installed OID to secure databases in the production, testing and development.
• Analyze root cause of the problems and resolve issues from production databases and find the best solution for it.
• Oracle parameter adjustment for the user increases and the Oracle memory management.
• Maintained Multi-terabyte DB high tractions volume in OLTP/Data warehousing environment.
• Frequently generating report for the day-to-day transactions.
• Performance tuning of queries consuming Excessive Resources or slow running queries by providing required Hints.
• Making sure all concurrent programs have managers and resolving pending jobs and long running jobs.
• Backup and recovery using RMAN. Cloning and refreshing the UAT and development databases using RMAN.
• Refresh database using import/export from production to UAT, SQL*LOADER used to load the data from flat files to oracle tables. ETL to extract the data from database and transform the data to different databases.
• Maintained existing SQL server databases and performed backup and recovery and check the performance of the databases.
• Implement policies to maintain database and to make sure the databases integrity and maximum availability.
• Automated Rebuilding indexes, Partition additions and space additions.
• Advanced replication using streams concept to get the production tables to the UAT. Production to production databases done in a two way replication.
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time consuming queries.
• Taking periodic backup of the database and the software.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
• Writing UNIX shell scripts for backup and recovery, Import and export procedure.
• Change request Procedure followed to do changes in the production database and document the changes for the reference.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Providing Solutions to the Problems Faced by end Users or Programmers.
• Installation document maintenance and scenario based trouble shooting for the databases.
• Performed significant unix admin duties on Solaris, with tuning, automation, Perl & shell scripting, monitoring, etc

Environment: Oracle 9i, 10g, RAC, RMAN, OEM grid control, Linux RHEL 4.0, HP UNIX, Solaris 8.0, Windows, UNIX shell scripts, SAN storage, Erwin, OID, TOAD, SQL*LOADER

Confidential

SQL Server DBA

Responsibilities:

• Involved in developing logical design, ER diagrams and mapping data into database objects.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained Referential Integrity.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Checked the coding standards followed by peers of the team.
• Developed Stored Procedures, Triggers, Cursors and Functions.
• Involved in Data Migration and Data Integration.
• Conducted the Performance tuning, indexes tuning, and Checked Deadlock Issues.
• Automated the routine Maintenance Tasks and Jobs.
• Managed Login and User: adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Involved in capacity planning in estimating and sizing of tables.
• Extraction, Transformation and Loading of the data using DTS packages.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Performed Backup and Restore and verified the Health of the Databases.
• Implemented Log Shipping for specified databases as High Availability solution.
• Monitored SQL Server Logs, OS Logs for Troubleshooting the Issues.
• Worked on Linked servers to run Distributed queries between SQL Servers.
• Experience in creating multidimensional cubes and Optimizing Cubes using SQL Server Analysis Services (SSAS).
• Involved in designing cubes in SSAS environment using Snowflake and Star Schemas
• Responsible for designing schema and finalization of naming and coding standards throughout project life cycle.

Environment: SQL Server 2000 / 7.0, Windows 2000 Server, SQL Profiler, HTML, Analysis Services (SSAS), T-SQL, SQL Loader, DTS, visual studio 6.0, Visual Source Safe and Replication.