SUMMARY:

• To excel in the IT industry by utilizing my, experience and potential skills in an environment that encourages continuous learning and creativity.
• Seeking a challenging position in database administration that requires active participation and induction of experience for the realization of organizational and professional growth
• High level of enthusiasm, drive and commitment to achieve results as per the scheduled policies and procedures.
• Proven selling skills within the service industry.
• Demonstrated leadership skills.
• Effective verbal and written communication.
• Positive approach to change in the workforce.
• Strong merchandising skills.
• Availability to work throughout all trading hours, including weekends.
• Ability to liaise with people on a multitude of levels, and dynamic phone manner.
• Business experience.
• Proven communication and interpersonal skills.
• Customer focused.
• Willing to embrace change.
• Eager to build new opportunities.

TECHNICAL SKILLS:

Programming Languages: C, C++, Java, Visual Basic 6.0, PHP, SQL, PL/SQL

Operating Systems: Windows NT 4.0/XP/2000/2003/ME/95/98, UNIX,Sun Solaris 2.x, OS 390/AS 400

RDBMS: SQL Server 7.x, MS Access 7.x, Oracle 9i/ 10g/11g RAC

Web Technologies: HTML, XML, JavaScript, VBScript, ASP

Tools: Dream weaver 4.0, Flash 6.0, Microsoft Visio, SQL *Plus, OEM, TOAD, RMAN, Exp / Imp,Expdp/Impdp, SQL, PLSQL Profiler.

Testing Tools Scripting: Win Runner s TSL, Load Runner s TSL, SQABasic

Networking Protocols: TCP/IP, RIP, UDP, OSPF, BGP, BOOTP, DHCP,SMTP

Application Servers: Oracle Application Server, Tomcat and Apache WebServer, Weblogic, Websphere,CRM, Data warehousing, Business Intelligence

PROFESSIONAL EXPERIENCE:

Confidential

Senior DBA

Environment: Oracle 10g/9i, Linux/HP - UX/AIX/Solaris & windows 2000, RAC, AWR, ADDM, EXP/IMP, Data pump, Data Guard, Golden Gate, Streams, SQL * Loader, STATSPACK, MViews, Partitions, TOAD, SQL Trace/ TKPROF, PL/SQL, Shell Scripting, cron jobs, Precise

Responsibilities:

• Involved in all phases of the project; requirements gathering, Impact Analysis, design, coding, unit testing, performance testing, UAT and Pilot
• Install, configure & upgrade Oracle software and related products in a UNIX environment
• Create and implement backup & recovery methods and disaster recovery methods using RMAN & third party backup tools ( Data Protector from HP)
• Database tuning for optimal performance to meet Business SLA*s
• Oracle APPS Rel 11.5.9 production support, applications & database upgrading, performance tuning & optimization, DR and Business continuity design/implementation.
• Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions.
• Duties includedDatabase performance monitoring and tuning includes Instance tuning, Query (SQL) Tuning using Tkprof, AWR, ADDM, and ASH, general troubleshooting, script development, documentation and DBA .
• Experience in Migrating databases from file systems to ASM, Data from Non-production to production databases.
• OEM 10g Grid Installation and Oracle Application Server installation, maintenance, performance tuning (JVM Sizing, HTTP tuning, Report tuning etc...) and Weblogic Administration.
• Experience in handling Oracle App 11i Stack applications.
• Provided Golden Gate support 24/7 in production environment.
• Experience in design and implementation of Streams in 10gR2 and Golden Gate technology.Good Understanding of other RDBMS products like Sql Server, DB2 on UNIX.
• Establish effective database performance monitoring procedures. Execution plan analysis, tuning and optimization. Proficient in influencing data access paths via SQL hints and physical changes (indexes, partitioning, init parameters and SGA)
• Ensuring that all server environments (development, QA, production) are synchronized with respect to software release levels
• Performance tuning of custom application schema, provide security recommendations, and storage management. Modify database structure to support applications and data growth.
• Create, replicate, clone and upgrade environments (Oracle Software and DB) to support implementation activities as required.
• Synchronizing the Development, System Test and Production Like databases with Production DB dumps using exp and imp and data pump & Steams technologies.

Confidential

Senior Oracle DBA

Environment: Oracle 10g, 9i, SQL, PL/SQL, TOAD 9.0, OEM 9.0.2, RAC, Developer 2000, RMAN v9.2.0.2.0, DBA Studio, Windows XP, SQL *Report, SQL * Forms, SQL*Loader, Windows 2000, UNIX Shell Scripting.

Responsibilities:

• Provide primary DBA design and support services for establishing, upgrading and maintaining the Oracle software environments, which support the company.
• Create, maintain and refresh required Oracle instance for development, test and production environments.
• Monitor security breaches, error logs, database and log space, user activity and resource utilization of production environment.
• Installed and configured Oracle Enterprise Manager to monitor the Databases.
• Implemented an Effective Backup and Recovery strategy for hot backup, archive logs backup and logical backups.
• Applied code modifications and enhancements to production database with minimum downtime.
• Provided 24x7 On Call production support including remote support.
• Monitored the database growth and forecasted the disk storage requirements.
• Created primary database objects like tables, views and indexes.
• Created schema users with appropriate roles and privileges.
• Ensured latest bug fixes and patches are implemented at the earliest.
• Handled oracle DBA jobs and have experience with SQL and PL/SQL
• Created different types of Indexes (B tree, reverse key, IOT and Bitmap etc), different types of partitions (List, Range, Hash, Composite etc) on different tables.
• Managed undo space management, Oracle DBMS tuning.
• Understanding of table space layout, volume layout, RAID striping techniques.
• Implemented the Advanced Snapshot Replication.
• Performing database modification function against production applications, such as altering table support for non-production status applications as requested by the support staff
• Analysis and management of Oracle problems/defects using TARs and or Metalink with Oracle Corporation and installation of patches
• Manage DBA projects related to database upgrades, platform changes, and/or new technology deployment and provide status reports to IT management. Handle off-hours on-call responsibility on a rotating basis to resolve critical problems as they arise.
• Participate as part of a team ensuring daily system operations are smooth, this may include following daily checklists, participating in status meetings as well as being on-call.
• Wrote scripts for indexes, snap-shots and Database Objects as per the oracle standards.
• Helped migrate (export/import) the database from old oracle 9i to new oracle 10g
• Done performance tuning using SQL application tuning using TKPROF, SQL TRACE for session, STATSPACK, Explain plan.
• Provided tuning support for SGA (shared pool, buffer pool and log buffer pool etc).
• Handled the tuning using the explain plan deciding based on disk, CPU, SGA and undo load.

Confidential

Senior Oracle DBA

Environment: Oracle 9i, Oracle 10g, SQL, PL/SQL, TOAD 9.0, OEM 9.0.2, RAC, Developer 2000, RMAN v9.2.0.2.0, DBA Studio, Windows XP, SQL *Report, SQL * Forms, SQL*Loader, Windows 2000, UNIX Shell Scripting.

Responsibilities:

• Install, configure & upgrade Oracle software and related products in a UNIX environment
• Create and implement backup & recovery methods and disaster recovery methods using RMAN & third party backup tools ( Data Protector from HP)
• Database tuning for optimal performance to meet Business SLA*s
• Design, test and implement Oracle high availability solutions
• Establish effective database performance monitoring procedures. Execution plan analysis, tuning and optimization. Proficient in influencing data access paths via SQL hints and physical changes (indexes, partitioning, init parameters and SGA)
• Responsible for operations of all Oracle databases, and all database servers including performance management, capacity planning, operational stability/reliability
• Setting up automated routine tasks such as monitoring, alerts, backups, and replication
• Ensuring that all server environments (development, QA, production) are synchronized with respect to software release levels
• Maintain a current awareness of technological developments and trends as it relates to the administration Oracle ( and tools)
• Perform in database design and development of new structures and code as required.
• Allocate systems storage & develop plans for future storage req.(Capacity planning)
• Set up and maintain documentation and standards.
• Proactively monitor and report key system performance metrics, using the wait interface, tools, stats pack and Symantec Precise.
• Performance tuning of custom application schema, provide security recommendations, and storage management. Modify database structure to support applications and data growth.
• Create, replicate, clone and upgrade environments (Oracle Software and DB) to support implementation activities as required.
• Synchronizing the Development, System Test and Production Like databases with Production DB dumps using exp and imp and data pump & Steams technologies.
• Act as information resource for questions about the RDBMS (andrelated software) to developers, management, operators, and users.Should be able to provide information concerning SQL code duringtuning of stored procedures and triggers.
• Proactively build good relationships with business partners and otherpersonnel for solving work-related issues.
• Rotational On-call support

Confidential

Oracle DBA

Environment: Oracle 8i, SQL, PL/SQL, TOAD 5.0, OEM 4.0.2, DBA Studio, Windows XP, SQL *Report, SQL*Loader, Windows 2000, UNIX Shell Scripting.

Responsibilities:

• Administered and provided production & development DBA support to the several databases (Oracle 8i, Sybase ASE & SQL Servers) of Business Objects Technical support team.
• Provide expert assistance in setting up instances, tablespaces, tables, indexes and views. In conjunction with programmer/analysts, define new objects or modifications to existing objects.
• Provide expert assistance in SQL statement tuning to improve performance. This includes, but is not limited to, re-writing SQL statements, creating new indexes and altering existing indexes
• Setting up database environments for reproducing and resolving the customer issues and exporting and importing the customer dump files to the databases
• Serve as primary DBA support for mission-critical or problematic databases, and own problem resolution from end-to-end
• Daily and intraday monitoring of database health - availability, reliability, performance, capacity planning, server clustering, replications, DR implementations e.g. log shipping, and connectivity, with timely production issue remediation
• Performance tuning: Indexing, compression, drive distribution, load-balancing, replication
• Coordinate with and provide support for applications programmers, system programmers, users, administrators, and IT personnel where databases are concerned.
• Install DBMS patches as supplied by the vendor as needed, in coordination with systems administration and Firm security policy, as well as ensuring all server builds and patches are current
• Responsible for design procedures for business continuation planning (daily backup and recovery as well as backup integrity checks) as required by system-availability/SLA agreements for each application
• Providing consultation and development support for the physical database design for database applications in production and development environments
• Responsible for maintaining and providing DBA-level access as required for all production-status applications on production and support/staging environments (DBA-level access in a development environment is shared with the development staff)
• Providing database device configuration data (hardware and software) for systems administration, such as disk usage, memory, etc