Resume of Shan
PROFESSIONAL SUMMARYAccomplished IT professional with 9+ years of experience in managing various databases including Oracle, DB2 and SQL Server2000 of sizes varying from 100 GB to 40 Terabytes; Responsibilities include design and implementation of the logical & physical database. Configure Replication, Data Guard, Multithreaded server and Oracle Enterprise Manager. Install, configure and upgrade Oracle, DB2 and SQL Server2000 databases. Extensively worked with RAC databases; Apply application patches and fixes; Establish and maintain sound backup & recovery policies and procedures. Design, Implement and perform backup & disaster recovery using ARCServe, Net Backup and RMAN. Monitor & tune the database and application program. Provide technical support to various departments regarding database configuration and utilization issues. Troubleshoot database and network problems. Establish, document and maintain standard Oracle practices. Estimate and plan database growth and changes.
TECHNICAL SUMMARYOPERATING SYSTEMS / AIX 4.3, AIX 5L ,HP-Unix, Windows 2003, Windows 2000, XP, Windows NT 4.0, Windows 95/98, Sun Solaris 7, Sun Solaris 8, OS/2, Novell 5.1
LANGUAGES /
C, COBOL,SQL, PL/SQL, VGL and JCL
DEVELOPMENT TOOLS
/ Forms 4.5, Reports 4.5, CICSRDBMS / Oracle7.3/8/8i/9i/10G, UDB V6/V7/V8 , SQL Server7/2000, MS-Access
CERTIFICATIONS
/ 1. Oracle7.x Certified DBA2. Oracle8.x Certified DBA
3. Oracle9i Certified DBA
4. IBM Certified Specialist (DB2)
5. Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition (Microsoft Certified Professional)
OTHERS
/ Oracle9i RAC, SQL Loader, Fast unload, TSM, Net Backup, TSM, HTML, ArcServe, Backup Exec, Info maker, SAP, ODBC, ChartRunner, TOAD PSP, Abinitio and Informatica.EDUCATION
/ Bachelor of EngineeringCurrent Salary : $70000 USD
Required Salary : Qatar’s Market Rate
WORK HISTORYDiaspark Inc , Oracle Data warehouse DBA, NY (Oct 04-Current)
Clients include: JP Morgan Chase/Bankone (Fortune 25)
Environment
/ AIX 4.3, AIX 5L(RS6000 ), Red Hat Linux, Oracle9i RAC, Oracle8i, Oracle10G, SQL, PL/SQL, SQL*Plus, OEM, Windows 2003,Windows 2000, Net backup, TSM, Abinitio, SQL Loader, Fastunload, Data guard, PSP , HACMP, Solaris 8q Provide 24X7 on call support to DW databases
q Archive data using Fastunload
q Use STATSPACK to tune the database
q Distribute I/O across VSD’s
q ETL Design/ Development / Support
q Use hints to tune SQL statements, detect Cartesian joins.
q Monitor and maintain Oracle9i RAC databases over 8 nodes.
q Configure, Manage and maintain standby databases.
q Implement partitioning, materialized views, spreading the I/O burden across as many disks, using bitmap indexes and index-organized tables
q OLAP Reporting
q Modified the existing RMAN Backup and recovery scripts.
q Participate in the disaster recovery process.
q Perform Oracle database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning.
q Develop and communicate Oracle database standards and procedures.
q Follow-up TAR’s on a regular basis
q Create users with appropriate roles and levels of security.
q Design and Implement database security
q Implement Oracle9i new features such as resumable space
q Install Oracle software and patches using Opatch
q Re-org tables and indexes.
q Used SQL*Loader to load data from flat files
q Perform code migration and database change management
q Carry out systematic problem identification, analysis, and resolution
q Analyze and reduces complex problems into simple, manageable components
q Chart various processes, procedures and workflows accurately
q Utilize decision-making techniques successfully
q Wrote UNIX scripts and defined Cron jobs to monitor Oracle databases for failure and disk space utilization
q Evaluate process performance challenges and recommends solutions
q Focuses on problem at hand without impacting or re-engineering entire process
q Interact with business users diplomatically without confrontation.
q Accommodates work schedule and works extra hours to meet crucial project deadlines when required.
Technical Consultant/DBA, Microhard , Oak brook, IL (May 99 –Oct 04)Clients include: Crompton Corporation (Fortune 500), Uniroyal Tires, Motorola (Fortune 500), GISSI, Examsonline
Environment
/ Oracle9i, Oracle8i, Oracle8, DB2 V7, DB2 V8, SQLServer2000, SQL, PL/SQL, SQL*Plus, OEM, Windows 2003,Windows 2000, Windows NT 4, Novell 5.1, Sun Solaris 8, Solaris 9, ARCServe, Backup Exec, Info maker, SAP, VGL, ChartRunner, Red Hat Linux 8.0Responsibilities
q Provide direction and leadership in the Client Server & OS Environment, by incorporating new technology, define new standards, collect and document business rules.
q Provide technical support, gather user requirements, propose solutions, and develop proposals for pre-sales activities.
q Install and configure SQL Server 7.0/2000, Oracle 8/8i/9i and UDB-DB2 7/8 databases.
q Backup, recover and tune Oracle, SQLServer2000 and DB2 UDB databases.
q Experience with OLAP/Data Warehousing applications. Knowledgeable in Star Schema of Data Warehouse, Facts, Dimensions &Variables, design and architecture of warehouse, Data modeling, and normalization techniques
q Configured partitioning, materialized views, spreading the I/O burden across as many disks, using bitmap indexes and index-organized tables
q Thoroughly tested database migration from Development to Production
q Tuned the application program with SQL trace, TKPROF and Explain Plan.
q Migrated Oracle database from Novell 4.1 to Windows NT.
q Modified the existing Backup and recovery scripts to suit Windows NT environment
q Integrate the data from Oracle Applications, SAP and other applications.
q Wrote UNIX scripts and defined Cron jobs to monitor Oracle databases for failure and disk space utilization
q Designed and implemented a disaster recovery system with documentation detailing every step to re-build a production SQL server
q Used Performance Monitor/Profiler to solve Dead Locks/Long running queries
q Migrated SQL Server 6.5 to SQL Server 7.0/SQL Server 2000.
q Successfully engineering a DTS package to move a table with 100 million rows to another SQL server.
q Developed and maintained database structures, procedures, functions, and packages.
q Migrated data to Oracle and SQL Server databases using SQL*Loader and DTS packages.
q Upgraded SQL Server 7.0 to SQL 2000 version and applied to SQL server service pack and security patch
q Wrote store procedures and transact-SQL code to accomplish varying tasks
q Managing SQL Server Security
q Diagnosed and corrected problems with data movement from and to databases
q Define and update DB2 configurations parameters according to instance and database tuning requirements.
q Used db2look, db2move and import/export utilities to move structure and data between databases.
q Worked with third party vendors specially Oracle, LIMS and Chart Runner
q Collaborated with personnel in all levels of the organization to understand business requirements for new application development and improvements to existing applications.
q Configure Windows 2000 server and clients.
q Developing and customizing Oracle Applications using Oracle Reports, Oracle Forms, and PL/SQL.
q Provide technical training in various subjects which includes SQL , Performance Tuning, Oracle DBA , Backup & recovery, DB2 DBA , JCL , COBOL , C , Unix, CICS and SQL server2000
q Implement project timelines for proposals and contract fulfillment. (Clients include Cook County Hospital Chicago, Fidelity Information services)
q Conduct educational discussions with clients on our products and service offerings.
q Prepared practice questions for www.examsonline.com, certquest
Oracle DBA , Microhard, Bangalore (Oct 98-Apr 99)Environment: / Oracle8, Oracle7.3, SQL Server 6.5, DB2 V6, Windows NT, Windows2000 Solaris 7, SQL, PL/SQL, SQL*Loader, Forms4.5 and Reports4.5, ArcServe, Backup Exec
Responsibilities
q Sole DBA on staff responsible for administration, installation, configuration, migration, upgrades, and support of all Oracle7.3 and 8 databases on NT/2000 platforms.
q Provide technical training in various subjects which includes SQL, Performance Tuning, Oracle DBA, Backup & recovery, DB2 DBA, JCL, COBOL, C, UNIX and CICS.
q Established, documented and maintained standard Oracle practices.
q Tuned the application program extensively with SQL trace, TKPROF and Explain Plan.
q Devised new backup and recovery strategies using ArcServeIT and RMAN.
q Monitor and troubleshoot the database for any potential problems.
q Detected and Resolved locking conflicts.
q Configured the intelligent agent through Oracle management Server.
q Scheduled the jobs using Oracle Management server.
q Tested and migrated the database from Oracle 7.3 to 8.0.5.
q Designed, developed and administered the development and training instance.
q Recommended and implemented changes to database design to maximize database performance
DBA, Boston Management Consultants, Bangalore (Nov 97–Oct 98)
Environment: / Oracle8, DB2 V6, MVS, JCL, CICS, OS/2, Novell, SQL, PL/SQL, SQL*Loader, Forms4.5 and Reports4.5Responsibilities
q Provide technical training in various subjects which includes SQL, Performance Tuning, Oracle DBA, Backup & recovery, DB2 DBA , JCL , COBOL , C , Unix and CICS.
q Designed and developed the Replication databases.
q Tuned the application program with SQL trace, TKPROF and Explain Plan.
q Troubleshoot and monitor the database for any potential problems.
q Developed interface programs for loading and validating data into Accounting System from spread sheets and flat using SQL *Loader and PL/SQL.
q Defined SQL queries and updates using SQL Navigator and Toad.
q Facilitated meetings with clients to develop user interfaces and business processes
q Monitored and relocated potentially large segments.
q Resolved fragmentation and disk contention.
q Detected and Resolved locking conflicts.
q Resized oracle tables and rebuilt indexes.
q Wrote scripts to automate daily tasks.
q Established, documented and maintained standard Oracle practices.
q Forecasted database growth and implemented the required action.
q Installed and configured SQL*Net/Net8 and ODBC drivers.
q Managed users with roles, profiles, privileges, and synonyms.
q Used SQL*Loader to load data from flat files.
q Tested backup and recovery strategies.
Programmer Acetech Info systems, Bangalore (Jan 96-Feb 97)
Environment: / COBOL, MF COBOL, Oracle7.3, SQL, PL/SQL, Forms4.5, Reports4.5 and Windows NTResponsibilities
q Developed batch programs in COBOL and DB2.
q Developed CICS screens using COBOL
q Tested all new and modified code for creation of database objects, including tables, triggers, stored procedures and functions.
q Used Joins and correlated Sub-queries.
q Created and maintained Database Objects like Stored Procedures, Functions, Triggers, Database Link, Roles, Privileges, Tables, Constraints, Views, Indexes, Sequence, and Synonym in Oracle
q Monitored and relocated potentially large segments.
q As per the application requirements, wrote the stored procedures, triggers, rules for objects in the database
q Forecasted database growth and implemented the required action.
q Installed and configured SQL*Net and ODBC drivers.