Sr Developer/DBA

Aix

_____

Summary

Experience working with various domains like educational, financial, telecom, manufacturing to deliver new products, upgrades. Resolve application problems to maintain high level of customer satisfaction

Total IT Experience of Eight Plus years which includes Six plus years as ORACLE DBA in US.

Database performance tuning (Oracle 9i,10g), SQL tuning (using v$ tables, STATSPACK, TKPROF, OEM).

Worked in High Availability 10g RAC environment.

Installed and implemented Physical Standby Dataguard.

Worked on different kind of storages like ASM,OCFS2.

Installed,configured 2,3 node 11g RAC cluster on ASM.

Migrating Databases from 9i,10g to 11gR1,2.

Responsible for, both manage and support all Production, Development and Staging instances of Oracle Version 8.x,9.x,10g,11g.

Experience implementing Streams on Oracle 10g server.

Experience working in Oracle Application Server using oracle 10g (10.1.0.4).

Maintaining data integrity and tune database for optimum performance and availability

Backup and recovery using RMAN, change management, Data Modeling, scripts for various database activities, troubleshooting etc.

Used advanced queuing to process the on line jobs.

Writing scripts for informing the DBA’s regarding the status, performance and Space Management.

Extensive performance tuning experience, specializing in instance tuning, and SQL optimization

Creating Oracle complex stored procedures and views for ETL process, creating SQL*Loader scripts and Oracle external tables

Maintain and improve high availability and disaster recovery

Knowledge of shareplex for replication of Database.

Strong skills in PL/SQL procedures, packages, triggers and replication

Worked with development and operations staff in resolving problems quickly and efficiently.

Clear communication and documentation of technical specifications

Implemented backup and recovery strategies for archiving and non-archiving databases.

Participated in planning and implementation of off-site Disaster Recovery planning and testing. Monitor databases for performance and tune accordingly

Design and Development of DB Objects like Materialized View, Views, Tables and Associated objects like Indexes and Triggers

Strong Knowledge of 10g advanced features like ASM, AWR, ADDM, FLASHBACK

Have written, tested and implemented Unix shell scripts to monitor database status, start and stop the database, retrieve database statistics for analysis, periodic executions of stats pack utility.

Developed RMAN scripts for database back up and recovery including hot and cold backup options for both RAC and stand alone instances. Configuration of Oracle OEM (Oracle Enterprise Manager) to monitor database and report on events as defined by the DBA group.

Created custom Statspack scripts and implementing to databases for automatic periodic statistics gathering and reporting.

Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.

Documented most critical procedures and trained backup staff to run them.

Experience in working high transacted OLTP systems.

Monitored indexes and analyzed their status for performance tuning and query optimization

Implemented proactive monitoring scripts for production databases.

Experience in creating different kinds of partitions on tables and indexes for managing large tables.

Good knowledge in implementing oracle server security through roles, profiles and privileges.

Managed Undo Segment in order to avoid Snapshot too old

Wrote SQL scripts to monitor tablespaces and extents growth

Oracle setup, migration, standardization, documentation, monitoring, tuning and testing of databases.

Experience with AIX, HP-UX, Solaris, Linux and Windows NT.

Thoroughly proficient in Korn shell scripting on Unix platforms.

Wrote SQL*Plus scripts to automate Oracle procedures and to speed up testing and conversion

Have applied oracle patches for DST, Upgradation and migration of databases.

Implemented table partitioning to improve performance and data management.

Installation, configuration and management for Oracle CMAN.

Installation and Configuration of Oracle 9i and 10g Real Application Clusters (RAC) with multiple nodes.

Poses analytical, presentation, problem-solving and excellent communication skills as well as keen interest in the emerging technologies.

Migration of Oracle databases from Sun Sparc to Solaris x86.

Extensive working on Oracle 10g on Solaris Netfiler for using shared binaries.

Skill Matrix

Category Technology

Database Skills Oracle 8i/9i/10g,11g,Sql Server

SQL, PL/SQL

Backup planning and implementation

Performance Monitoring, Analysis and Performance Tuning

Database Recovery (DR) strategy planning and implementation

Capacity Planning and implementation

Partitioning, Replication, and Standby Database Administration

Installation, Patch, Upgrade, & Migration,Reorg.

Real Application Cluster,RMAN.

Operating Systems UNIX(Sun Solaris 8/9/10,Sparc,Opteron - AIX4.3), Red Hat/Fedora Linux, HPUX-11.23.

Windows NT/2000/2003/2008.

Applications Tool SQL Navigator

PL/SQL Developer 7.0, SQL *PLUS

Oracle Enterprise Manager (OEM)

Oracle Utilities (Import / Export, SQL*Loader, 10g Data Pump)

Quest Toad 8.5, BMC, Weblogic, Oracle BI Publisher, Oracle BI Discoverer,Tomcat,Apache,SunONE,SVN.

VERITAS Netback up 5.3/6.0, Netapp Filer,Sql Ways,VTL

Erwin 4.1, Hummingbird, Tivloi.

Protocols FTP, SSH, Telnet, TCP/IP,VNC Viewer

Languages UNIX Shell Scripting, SQL, PL/SQL, Perl

Certificate of Excellence from Oracle (OCA)

Brainbench Certified Associate PL/SQL Certification.

Oracle Certified Associate DBA

Brainbench Certified RDBMS Concepts

Professional Experience:-

Verizon Feb 2008 – Till Date.

Sacramento,CA.

Oracle DBA

Verizon Business is one of the leading provider of IT, Communications, Security & Network Solutions to enterprises and governments around the world. Main projects at the sacramento location were related to DMV emissions program and fish & game licenses for states.

Responsibilities:

Provided 24/7 production DBA and Application Management support.

Worked on mostly government owned projects..

Proactive tuning and health monitoring for all production databases.

Implemented DATAGUARD (physical/logical) on standalone production databases.

Installed, configured and used Advanced Replication to replicate data from production to standby DB’s.

Implemented scripts and performed switchover/failovers with DATAGUARD as required.

Created 10gR2 RAC database in shared as well as Dedicated servers.

Database monitoring with OEM, HPOV and custom made scripts.

Tuned database servers by using new 10g features ADDM, AWR, tune recovery time, SQL trace & TKPROF reports.

Oracle Streams configuration and performance tuning using Oracle 10g.

Actively involved in Change Management team activities also.

Planed and Implemented disaster recovery system using RMAN and custom written shell scripts.

Performed the migration and upgradation of Oracle databases by using import/export, oracle datapump, transportable tablespaces.

Hands on experience for creating Materialized Views.

Performed various database migrations, refreshes as per requirements.

Applied CPU patches each quarter to keep the databases up to date.

Moved all the dba jobs to dbms_scheduler.

Migrating,Upgrading Databases from 9i,10g to 11gR1,2

Implementation and support of 10g RAC instances

Converted tablespaces on all the production databases to LMT from DMT.

Installing and setting Oracle Enterprise Manager OEM Grid Control.

Pro-actively monitoring and performance tuning databases including partitioning and creating MATERIALIZED VIEWS & Loaded bulk data with SQL*Loader.

Works on multiple ERP related business systems for support, enhancement, upgrade and customization.

Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection.

Performed database performance tuning, STATSPACK reports automation, stress test on production copy for scalability, resolving production performance issues.

Worked with Oracle support to resolve various issues with the database by opening SR’s.

Done tablespace reorg to avoid contention and for better performance and management of databases.

Done critical implementations testing on standby production databases using snapshot standby feature.

11g production Database Upgrade testing on standby’s using Guaranteed restore points.

Regular basis Database implementations in Production,Staging,Development environments.

Generated working documentation for the DBA team use.

Oracle Installation, Database Creation and Re-configuration,patching.

Sql Server 2005 implementations and support activities.

Installations of Oracle Binaries,Agent,Oracle Client,CMAN etc. for various versions.

Worked for Application management implementations and support.

Environment: Oracle 9i/10g, Quest Toad Version 8.5, SQL*Loader, Windows XP, Solaris Sparc/Opteron 5.9, 5.10, Oracle Enterprise Manager, Oracle Portal,Sql Server 2005,Subversion,HPOV,OEM ( Oracle Enterprise Manager),Oracle 9i/10g/11g,RAC,RMAN,BMC Remedy 7.0.

Vectormax Corporation May 2007 – Jan 2008.

Jersey City, NJ

Oracle DBA

Description :-

VectorMAX Corporation is a leader in the ever evolving market for real time and on demand video solutions for the enterprise and the Web. VectorMAX currently delivers 10 business channels for Time Warner Cable business customers over an IPTV network, using its TVAnywhere™ solution. TVAnywhere, which uses VectorMAX technology to broadcast live content such as news, training or corporate communications via LAN, WAN or Internet connections. TVAnywhere offers robust, reliable and easily scalable low-latency video encoding.

Responsibilities:-

Experience in writing scripts proactive monitoring like monitoring the disk usage and the memory usage of the server and monitoring tablespaces.And mailing alerts when required.

Experience in RMAN backups, Hot backups and Cold backups.

Created and configured Dataguard using physical Standby database on a fresh server starting from Oracle Installation.

Extensive use of Crontab in UNIX environment for scheduling routine tasks.

Good Knowledge of Automatic Workload Repository(AWR).

Used dbms_schduler to schedule the jobs.

Implemented two Node Oracle RAC 10g using ASM on Linux 64 Bit Operating System.

Automated many common tasks using crontab including: Backups, exports and imports, archiving old records and verification of such processes.

Used DBMS_STATS to gather the statistics along with analyze command.

Providing the data for the other teams for their development and testing.

Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora

Experience working with 24x7 production support.

OS Monitoring of CPU utilization and its performance using UNIX utilities like iostat, vmstat, netstat, sar, and top.

Installing and setting Oracle Enterprise Manager OEM Grid Control.

Have Applied Patches to existing versions.

Implemented scripts and performed switchover/failovers with DATAGUARD as required.

Created Materialized views to make query response faster and have written shell scripts to refresh them.

Created tablespaces and managed tablespaces adding/deleting/ resizing data files.

Experience in creating necessary Documentation for Change Control according to company's standards.

Upgraded the database from Oracle 10.1.0.3 to 10.2.0.1 on Linux platform.

Extensively Installed Oracle10g on Linux Platform.

Monitored growth of data and purged old records through automated scripts.

Configured OEM and Performed database monitoring using OEM.

Supported developers, end-users, creating reports using Business Objects.

Regular Analysis of alert log for error tracing

Environment: Oracle 10gR1 & R2,RHEL 3,RHEL 4,Putty, OEM ,RMAN,RAC, Microsoft Outlook, Toad,Tora,Sql Developer,Pl Sql Developer,SVN,Winscp,Buisness Objects XI.

Educational Testing Service Nov 2005 – Apr 2007

Princeton, NJ

Oracle DBA

Description:-

Educational Testing Service is the world's largest private educational testing and measurement organization and a leader in educational research. ETS develops and administers more than 12 million tests worldwide. All the database activities on the following applications. California High school Exit Examination (CAHSEE): The purpose of CAHSEE is to ensure that students who graduate from high school can demonstrate grade level competency in the state content standards for reading, writing, and mathematics. California Alternate Performance Assessment (CAPA): CAPA is given to students with significant cognitive disabilities whose disabilities prevent them from taking the California Standards Tests and the CAT/6. New Jersey Assessment of Skills and Knowledge (NJASK): The NJ ASK assesses student achievement in the knowledge and critical thinking skills defined by the New Jersey Core Curriculum Content Standards in language arts literacy, mathematics, and science. California Reading List (CRL): The List assists parents and students in selecting books written at a level of difficulty that corresponds with a child's ability to read. The List is drawn from California's recommended literature lists for students in kindergarten.

Responsibilities:-

Oracle 10g/9i installation and Configuration.

Apply Patches to existing versions.

Collect database performance statistics from production databases for trend analysis.

Hot Backups & Exports, Restores & Refreshes for regression tests.

Development support, Coding standards, application & database tuning.

Preventive Maintenance & re-orgs. Troubleshooting & tuning.

Ensuring successful & periodical Backup, Restoration & Tuning.

Develop, Implement and administer database policies and procedures

Migration from DB2 , Sqlserver to Oracle.

Creating 10gR2 RAC databases in shared as well as Dedicated servers.

Backup and recovery using change management, Data modeling, scripts for various database activities, troubleshooting etc.

Experience in using AWR for database performance and statistics.

Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems. Configuration and installation of 10gR2 RAC databases in dedicated server mode using ASM.

Configuration and installation of 10g RAC databases in dedicated server mode using ASM.

Strong skills in PL/SQL procedures, packages, triggers.

Perform database analysis, design, coding, testing and implementation of database structures.

Maintained several databases ranging between 250G to 700G.

Used Oracle backup utility RMAN to implement Oracle backup.

Finest granularity approach to Oracle implementation and defragmentation.

Maintained physical standby databases using Data Guard.

Capacity planning, capacity monitoring and management.

Perform transaction-sizing measurements.

Managed day-to-day production databases.

Possess a thorough understanding of Oracle fundamentals, concepts, utilities and applications.

Seasoned experience with UNIX and a strong ability with UNIX shell scripting.

Experience working in large database environments.

Hands on experience for creating Materialized Views.

Calculate disk space requirements.

Oracle’s Enterprise Manager (OEM), Statspack Reports, Explain Plan, SQL Trace and TKPROF.

Environment: Oracle 10g/9i/8i, Quest Toad Ver8.5,RAC,RMAN,BMC Remedy,WinScp,Scp, SQL*Loader, Windows 2003, Erwin4.14, AIX5.3, Solaris5.9

AstraZeneca Inc Jan 2004- Oct 2005

Delaware, Wilmington

Oracle DBA

Description:-

AstraZeneca is committed to enhancing patient’s health and helping them to live healthier lives. Innovative drug discovery and delivery. Its researchers continually work to help improve patient health with the creation of innovative medicines and other healthcare solutions. It has discovered some of today’s most important medicines including treatments for cancer, cardiovascular disease, mental health disorders, gastrointestinal diseases, asthma, and more. Reaching patients in their own communities. AstraZeneca is helping ensure that patients have access to the information, programs, and resources they need to make educated health decisions. An inspiring work environment. Our employees consistently contribute their best efforts and expertise to our mission.

Responsibilities:-

Responsible in Managing and optimizing transactional replication in OLTP environments.

Developed backup and recovery strategies for Oracle Server databases.

Handled database migration from 8 to 8i, 8i to 9i and 9i to 10g

Migrated from DB2 environment to Oracle .

Worked on monitoring and optimizing the database by performance tuning

Monitored indexes and analyzed their status for performance tuning and query optimization.

Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.

Responsible for taking logical backups of data using exp, Imp, expdp and impdp.

Responsible for taking HOT and COLD backups of the databases and also the individual tablespaces

Experience in Backup & Recovery techniques using RMAN and conducted disaster recovery drills.

Responsible for partitions on tables and indexes for managing large tables

Used STATSPACK for Database Monitoring and Database Performance

Maintenance & modification of Shell Scripts

Extensive use of Crontab in UNIX environment for scheduling routine tasks.

Creation and maintenance of test schema.

Sizing the database for future growth.

Responsible for maintenance and improvement of production, archive Oracle databases.

Monitoring of Oracle databases, automated error notification.

SQL statement analysis and tuning

Ensure High Availability of database at all times and resolve all problems within targets.

Environment: SQL Navigator, Oracle 8i, 9i, Sun Solaris, H.P, Windows2000, PL/SQL, Shell Scripts, ERWin4.0, TOAD.

Punjab National Bank June 2002– Dec 2003

New Delhi, India

Oracle Developer

Description:-

Bank has its Corporate Office at New Delhi and 26 Zonal Offices which in turn supervise 45 Regional Offices under which the branches function. The delegation of powers is decentralized up to the branch level to facilitate quick decision making. Punjab National Bank with 4497 offices and the largest nationalized bank is serving its 3.5 crore customers with the wide variety of banking services. Punjab National Bank Card user can buy goods and enable services from 45,000 merchant outlets in India and can withdraw cash from over 4500 ATMs with its own 450 ATMs.

Responsibilities:-

Involved in the application tuning of database by identifying the suitable indexes.

Creating users and privilege Management using roles and grants.

Managed and resolved design issues during development

Optimized and enhanced the existing procedures and SQL statements for the better performance

Maintained the data integrity and security using integrity constraints and database triggers.

Created Stored Program Units in the Form of Packages, Functions, Triggers and Procedures for implementing the database intensive business rules.

Extensively used Explain Plan, TKPROF and Statspack .

Used PL/SQL table to avoid mutating problem in database trigger

Using the Crontab in UNIX and Scheduler in windows for Automation of various Tasks.

Using SQL Loader for populating static tables and fact tables from CSV Files.

Upgraded and patched Oracle software

Used EXPORT/IMPORT to do table level and full database de-fragmentation

Worked on providing the backend support for the developers, stored procedures and functions, reporting, SQL query tuning and optimization, performance monitoring, resource usage and profiles.

Coded the stored procedures, Packages and functions and well tuned the SQL in the application.

Written the SQL*Loader scripts to load the external files into the Oracle Database (Monthly we load ZIP code database and Out of state Surrender title number and related information).

Creation of PL/SQL Functions, Cursors, Packages, Stored procedures, Database triggers.

Environment:-Oracle 8i, SCO UNIX, Toad, Windows 2000/NT, sqlplus, PL/SQL.

Contact this candidate