SUMMARY:

• Over 23 Years of total IT experience in Software Systems Design & Development, responsible for developing customized business applications, database design, database administration, Leading Projects and building large public domain databases. Out of which 18 years in Oracle (Windows/Linux) DataBase Administration (Proficient in Oracle Database Administration Activities) and 10 years in DB2 UDB (Linux & Windows) and 10 Years in SQL Server as a database administrator with all the activities of installation, configuration, creating database instances, RMAN, Data Guard, Oracle streams, Backup and recovery and moving databases from Windows to LINUX/UNIX vice versa.
• Good/Excellent teamwork and problem - solving skills.
• Managing teams achieve team and individual targets, addressing any issues of concern regarding performance of team members, monitoring performance, coach, counsel and develop people competencies with in the team etc.
• Installations and configurations of Oracle Servers (11g,10g,9i,8i, 8.0 & 7.x) on Sun Solaris, SCO-Unix/LINUX and Windows 2000/NT servers in production and development
• Experience as On-Call 24x7 production DBA support, application/development DBA, system administrator; handle business service requests using Helpdesk Service Management/Call centre.
• Experience with database backup, recovery, and disaster recovery procedures.
• Backup and recovery procedures using RMAN.
• Configuring Oracle Data guard for oracle 11g Configuring three node oracle RAC
• Configuring ASM installation and adminstaration.
• Experience in all facets of the systems development lifecycle, from requirement development, architecture design, testing, and post implementation revisions.
• Strong knowledge of Oracle releases 10g, 9i, 8.x, 7.x new features, Initialization parameters, configuration settings. Strong Knowledge on 10g release and top 20 features.
• Experience in Database Administration in Oracle versions 8i, 9i and 10g on the HP-UX operating system.
• Installation, configuration, creation, upgrades Oracle environments (9.x, & 8.x) using OS via. Sun Solaris, SCO-Unix and Windows NT/2000 servers.
• Strong in data (system) analysis, DBA support of phases of Software Life Cycle (design & development, implementation) in large-scale multi-user (systems) environments.
• Strong in knowledge of oracle data-dictionary, configuration of Oracle Enterprise Manager (OEM) tools.
• Good understanding of Oracle maximum Availability Architecture (MAA) Best practices with minimizing unplanned & planned outages and optimum resources utilization.
• Involved in replication setup, configuration and maintenance of replication process.
• Strong knowledge in SAP R/3 Basis and BW and Star Schema architecture.
• Building ad-hoc queries/ complex SQL queries Report development,
• 5-yrs troubleshoot/monitor script, packages & script, develop scripts for SQL*Loader, Export, Import, PL/SQL,
• Aqua Data Studio 4.0.1 - Advanced Query Tool for ( oracle, db2, sql server, sqlserver, sybase, pointbase, mysql, postgres, postresql, informix, table, column, tuple, schema, tablespace, trigger, sequence, database, sql, jdbc, backup, dba, tuning, db, query, referential, integrity, dbms, pl/sql, t-sql ).
• Hands on experience of database backups and Recovery strategies using RMAN, Export, and Transportable Tablespace, Recovery disaster recovery and Tivoli Storage Manager (TSM) for monitoring and backing up the Oracle databases.
• Experience in Cosmos’s Data Junction (Repository Explorer 8.2 for data mapping and loading data (Extraction, Transformation & Loading - ETL process using Pentaho Kettles tool) and cognos.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
• Monitoring and optimizing the Performance of the database, turning Management, Change Management, capacity planning, create new technologies and SQL tuning.
• Working experience with Very-Large databases (VLDB) up to 2 terabytes, data migration, against Oracle & other databases such as MS Access, Lotus Notes.
• Experience on Oracle Real Application Clusters (RAC) on LINUX and AIX servers.
• SQL Server 2000/2005/2008R2 database administration for development & Production Systems including hosting.
• DB2 database administration for various development and Production systems including hosting.
• Understanding on Windows Security, Windows Active Directory & Networking.
• 3 years of software development experience using Developer-2000 (Forms, Reports), FoxPro & ‘C’.
• Practical solutions to problem solving with creative ideas, identify patterns, linkages and underlying situations, consider customer needs in evaluation of solution.
• True team player; maintain client/customer relationships by providing timely, superior quality products and services; understanding of client/customer needs opportunities and satisfaction criteria.
• Involved in moving the production data centre from LightEdge (Moline, IL) to QTS (Servigistics/PTC, Atlanta) for Oracle, DB2 and SQL server instances.
• Experience in data guard setup (standby database solution) for high availability, data protection and disaster recovery, log shipping and replication of SQL Server.

TECHNICAL SUMMARY:

Hardware: PC(Windows 3.1, Windows 95, Windows NT), E10K, QS/2, Pentium Systems, AT - 486, AT- 386,NEC S - 1000.SUN Solaris 450, 4500 Sun Enterprise 10000 & Sun Sparc 1000, HP 9000 Servers, Dell servers, IBM F50/H70Compatible and Pentium IBM compatible PCs as clients.

Operating Systems: Windows 2003 Server, Windows NT, SCO-Unix, UnixWare, Xenix, ACOS-6, SUN Solaris v5.8/5.6, AIX HP-UX v11.x/10.x, AIX v4.3, Windows 2000/NT 4.0/98/95, HP-UX, LINUX, Sco-UNIX Open Server.

RDBMS/GUI/Tools: Oracle DBA, Oracle 10g, Oracle 9I, Oracle 8I,Oracle Financials 11i, Oracle 8.0.5, Oracle 8.0.4, Oracle 8.0.3, Oracle 7.3.4, Oracle 7.2, Oracle 6.0, Forms 4.5, Forms 3.0, Power Builder 5.0, Reports 2.5, AllFusion Erwin Data Modalar 4.1.4, Oracle 9i viz. v9.2 & 8i viz. v8.1.7/8.1.6, Oracle 8 viz. v8.0.6/8.0.5 & Oracle v7.3.4.

Languages: COBOL, FORTRAN, PASCAL, C, Pro *C, INQ( EPL/EQL),PL/SQL, Logic Works Erwin 3.0, PL/SQL, Shell Scripting, Oracle 9iAS, Oracle Client, Power Builder 5, Developer/2000 (Forms & Reports), SAP Basis Administration, SAP BW & Crystal Reports.

Networking/Backup: Oracle 9iAS, Apache Server (SSL) etc., Veritas Net Backup/VERITAS Backup Exec., Recovery Manager (RMAN), Enterprise Backup Utility (EBU), Oracle Enterprise Manager (OEM), SQL*Plus, SQL*Loader, EXP/IMP, ERWin v4.x,.

PROFESSIONAL EXPERIENCE

Confidential,WI

Senior Database Administrator/Database Architect

Environment / Technologies: Oracle 11g, Oracle 10g, DB2 UDB 9.X, MS SQL Server, WSAD, Web sphere / Java, JSP, JDBC, MQSeries and, Windows, PostgreSQL DBA.

Responsibilities:

• Managed database design, creation and configuration, space management and other database maintenance procedures in a multiple production and development environments for Oracle, DB2 UDB and SQL Server.
• Experience as Primary and Secondary DBA, Production support 24x7 and mentoring the data team of size 15.
• Installation of Client & Server, configuration, creating databases instances using CODESET IBM-1252 & UTF-8, configuring the database instance parameters, backup and restoration of the instances in Windows to LINUX/UNIX and vice versa for versions IBM- DB2 v7.0 & v8.1 for various clients at 4CS environment and at Client site environments.
• Experience as Primary and Secondary DBA. And Production support 24x7.
• Management, Maintenance and Administration of Oracle Databases.
• Managed database user and security administration.
• Configuring Oracle Enterprise Manager (OEM).
• Backup and Recovery using RMAN.
• Configuring Oracle Enterprise Manager (OEM).
• Experience in configuring and maintaining Data guard.
• Configuring three node Oracle RAC.
• Configuring ASM installation and administration.
• Performance tuning, Backup and restore, Database monitoring.
• Installing and maintaining Oracle 8i, 9i and 10g databases, including installing patches, and performance tuning.
• Used Aqua Data Studio 4.0.1 - Advanced Query Tool for ( oracle, db2, sql server, Sybase, mysql, postgres, postresql, Informix, table, column, schema, table space, trigger, sequence, database, sql, jdbc, backup, dba, tuning, db, query, referential, integrity, dbms, pl/sql, t-sql ).
• Maintaining database models (Data Modeling) for Oracle, UDB DB2, SQL Server and OS/390 using Power Designer 11/15 and Erwin.
• Experience in installing Oracle and performing problem determination and resolution activities on Oracle, DB2, Sql Server.
• Support for UDB DB2 database support, including creating databases, Backup & Restore and performance tuning, Q replication process, WebSphere MQ installation and Configuration.
• Monitoring and optimizing database performance.
• Controlling and monitoring user access
• Experience with Pervasive Cosmos Repository Explorer - Data Junction for data loading/mapping.
• SQL Server database administration.
• Experience with BMC - Smart DBA tool for database performance tuning.

Confidential, IL.

Senior Database Administrator/Database Architect/DBM

Environment / Technologies: Oracle 11g, Oracle 10g, DB2 UDB 9.X, MS SQL Server, WSAD, Web sphere / Java, JSP, JDBC, MQSeries and, Windows, PostgreSQL DBA.

Responsibilities:

• Experience as Primary and Secondary DBA, Production support 24x7 and mentoring the data team of size 15.
• Installation of Client & Server, configuration, creating databases instances using CODESET IBM-1252 & UTF-8, configuring the database instance parameters, backup and restoration of the instances in Windows to LINUX/UNIX and vice versa for versions IBM- DB2 v7.0 & v8.1 for various clients at 4CS environment and at Client site environments.
• Experience as Primary and Secondary DBA. And Production support 24x7.
• Management, Maintenance and Administration of Oracle Databases.
• Managed database user and security administration.
• Configuring Oracle Enterprise Manager (OEM).
• Backup and Recovery using RMAN.
• Configuring Oracle Enterprise Manager (OEM).
• Experience in configuring and maintaining Data guard.
• Configuring three node Oracle RAC.
• Configuring ASM installation and administration.
• Performance tuning, Backup and restore, Database monitoring.
• Installing and maintaining Oracle 8i, 9i and 10g databases, including installing patches, and performance tuning.
• Used Aqua Data Studio 4.0.1 - Advanced Query Tool for ( oracle, db2, sql server, Sybase, mysql, postgres, postresql, Informix, table, column, schema, table space, trigger, sequence, database, sql, jdbc, backup, dba, tuning, db, query, referential, integrity, dbms, pl/sql, t-sql ).
• Maintaining database models (Data Modeling) for Oracle, UDB DB2, SQL Server and OS/390 using Power Designer 11/15 and Erwin.
• Experience in installing Oracle and performing problem determination and resolution activities on Oracle, DB2, Sql Server.
• Support for UDB DB2 database support, including creating databases, Backup & Restore and performance tuning, Q replication process, WebSphere MQ installation and Configuration.
• Monitoring and optimizing database performance.
• Controlling and monitoring user access
• Experience with Pervasive Cosmos Repository Explorer - Data Junction for data loading/mapping.
• SQL Server database administration.
• Experience with BMC - Smart DBA tool for database performance tuning.

Environment: Oracle 11g/10g/9i/8i, UNIX, Windows NT/2003, DB2 UDB (8/9/95/9.7 on Linux/Windows, AIX and z/OS), SQL Server 7/2000/2005/2008/2008R2