SUMMARY

• Over 8+ years of experience in Database Administration/Design/Migration and software architecture, Development, Maintenance, Support, Enhancement, Testing and Implementation
• Successfully completed 11g OCP certification - Oracle 11g Certified professional
• Technical Strengths include Oracle (10g/11g/12c) DBA, PL/SQL on Windows & Unix environments
• Experience in both Development and Production DBA
• Expertise in Installation, Configuration, Upgrade, Implementation
• Expertise in Partitioning, Database sizing, Indexes, Views, Stored Procedures, Triggers, Packages, Export, Import
• Created and maintained all databases required for development, testing, education and production usage.
• Managed and supported 24X7 Oracle 9i/10g/11g production databases as well as development databases to ensure maximum availability of database for various applications.
• Well versed with SQL and Functions, Procedures, and Packages of PL/SQL.
• Involved in application development teams for app. development, testing, system acceptance, implementation and migration to production.
• Experienced in PL/SQL stored procedures, Functions, and Triggers for implementing business specifications
• Experience in Goldengate,Oracle dataguard
• Experienced in logical and physical database design, modeling.
• Experienced in Unix Shell scripting
• Experienced in database Analysis, design, creation, maintenance and upgradation.
• Exposure in Oracle ASM, Grid Control, ADDM
• Exposure in Backup/Recovery and disaster planning using User Managed/RMAN, export/import
• Exposure in Project Lead/Management
• Exposure in lead large team with different level of expertise
• Leadership Traits, Good Management & Team work skills, Good communication & presentation skills
• Possesses strong technical, analytical and problem solving skills with keenness to facts and details.
• Have demonstrated ability to increase operational efficiency, generate cost savings and contribute to business profits
• Analyzing and managing SQL execution plans using SQL plan management.
• Managing and capturing SQL plan baselines.
• Exposure on Data guard and FSFO configurations.

TECHNICAL SKILLS

• Oracle 8i/9i/10g/11g/12c
• Oracle RAC DB (Real Application Cluster)
• SQL Server, My SQL, MS-Access
• Toad, SQL Loader, SQL Developer, PL/SQL Developer, iSQL*PLUS, Oracle Enterprise Manager, Oracle 10g DB console
• C, C++, Shell & Perl Scripting, pl/sql developer Visual Basic 6.0, Oracle Forms 6i/9i
• RedHat Enterprise Linux 4.0,IBM AIX 5.3,Windows 98/NT/2000/XP/2003, Linux, HP-UX,Solaris

PROFESSIONAL EXPERIENCE

Confidential, Seattle,WA

Oracle DBA

Tools: Oracle 10g/11g/12c, Shell scripting, Linux, My SQL,PL/SQL Developer, SQL Developer, TOAD

Responsibilities:

• Set up Oracle 12c DB, Tuning, Oracle GG installation, configuration and setup.
• Design and implement oracle RAC.
• Experience in shell scripting,perl.

Confidential, Seattle,WA

Oracle DBA

Tools: Oracle 10g/11g/12c, Shell scripting, Linux, My SQL,PL/SQL Developer, SQL Developer, TOAD

Responsibilities:

• Provides World Class Customer Service to internal and external customers
• Support the creation, maintenance and implementation of procedures regarding how problems are identified, received, documented, distributed and corrected
• Ensures project documents are complete, current and stored appropriately
• Manages day-to-day project and scope changes
• Communicates and coordinates database schedule, backups, and downtime to users
• Reviews reports, files, and messages to identify instances of possible security infractions
• Responds to inquiries regarding database security, policies, and procedures
• Participates in the planning, communication, testing, and implementation of disaster recovery procedures
• Goldengate configuration and replication on production and test databases.
• Resolving goldengate replication issues(extract,pump and replicat process issues)
• Collects and analyzes server and memory utilization
• Analyze the data stored in the database and to make recommendations relating to performance and efficiency of that data storage
• Administer existing enterprise databases, and analyze, design and create new databases
• Proactively monitor systems for optimum performance and capacity constraints
• Establish standards and best practices for SQL
• Interact with and coach developers in SQL scripting
• Perform database backup and recovery
• Provides 24x7 support to the enterprise database systems
• Install and configure database software and other software related to database management systems.
• Work closely with the system administrator to perform software installations, and to configure hardware and software so that it functions optimally with the Database Management Systems
• Monitor and administer DBMS security.

Confidential, Seattle,WA

Oracle DB Administrator/oracle developer

Tools: Oracle RAC 11g database,Shell Script, Linux, Solaris, Oracle Dataguard

Responsibilities:

• Installing, creating and configuring of Oracle RAC 11g database with 4 nodes on Linux and Solaris operating systems.
• Responsible for maintaining production and QA database servers for the CSAB application.
• Developed PL/SQL Procedures, Functions, Shell scripts for implementing business specifications
• Setting up and monitoring disaster recovery site using oracle dataguard.
• Gathered system information, database information of each machines where database were hosted
• Created and maintained different database structures including tablespaces, data files, redo log files, rollback segments and renaming/relocating of datafiles on different servers
• Prepare Technical Documentation to support the actual implementation and methodology
• Design and implement oracle RAC.
• Script automation to gather database information and status/size of all tablespaces.
• MOP creation and execution along with the client.
• RMAN scripts to perform full database backup and archive log backup.
• Setup test environment to simulate the migration
• Applying Oracle software patches when required.
• Communicate with team to discuss daily activities and task assignment for next day
• Prepare Weekly Status reports,daily checks on the activities that were performed
• Prepare database migration document which will consist of the whole plan
• Effort estimation for Data migration for all the databases
• Prepare Project plan to make client understand the process and method by which different activities will take place Confidential what time
• Knowledge in Dataguard installation,configuration.
• Upgrading production and QA application servers to latest versions.
• Involved in Efficient Configuration of Access Policies through Roles and Privileges
• Backup and Recovery using RMAN.
• Export/Import of data using expdp and impdp methods.
• Test and Implement different physical and logical backup and Recovery methods like crash point in time recovery, Full/partial export/import.

Environment: SQL, PL/SQL, Cronjob, RMAN, Export/Import,PL/SQL writing, Procedure, Triggers, Functions. HP-Unix,Solaris, Linux Red Hat 9, MS Excel

Confidential, Seattle,WA

Oracle DB Administrator/oracle developer

Tools: Oracle 8i/9i/10g/11g,Shell Script, Linux, Solaris, Toad.SQL developer,PL/SQL developer

Responsibilities:

• Installing, creating and configuring of Oracle 10g.11g on Linux and Windows
• Using Optim tool to archive millions of data and restoring to a target database.
• Responsible for maintaining production and QA/Prod application servers and database servers for the NXP applications.
• Gathered system information, database information of each machines where database were hosted
• Setup test environment to simulate the migration
• Count of all database objects to ensure it is same after migration as well
• Communicate everyday with offshore team to discuss daily activities and task assignment for next day
• Prepare Weekly Status reports to update client on the activities that were performed
• Prepare database migration document which will consist of the whole plan
• Effort estimation for Data migration for all the databases
• Team management
• Prepare Project plan to make client understand the process and method by which different activities will take place Confidential what time
• Applying Oracle Software patches when required.
• Knowledge transition (Technical/functional) to the team
• Database migration from Oracle 10g to Oracle 11g
• Knowledge in GoldenGate installation,configuration.
• Upgrading production and QA application servers to latest versions.
• Involved in Efficient Configuration of Access Policies through Roles and Privileges
• Backup and Recovery using RMAN.
• Export/Import of data using batch method
• Test and Implement different physical and logical backup and Recovery methods like crash point in time recovery, Full/partial export/import.
• UNIX Shell scripting for automatic database startup/shutdown, backup/recovery, purges data and system monitoring.
• Create and managed database objects like dictionary managed and locally managed table spaces, Fact Table, Dimension, Materialized View, partitioned tables, indexes, rollback segments, views, synonyms, roles etc.
• Registered events for DB up/down, Node up/down, Disk full, Swap full, Failed Jobs, Archive full, Waits, Rollback contention, DBWR checkpoints etc.
• Creating table spaces, adding files to existing table spaces.
• Data refresh from production to test and development
• Extensive use of performance tools like AWR, ADDM, TKPROF and Explain plan for performance monitoring and troubleshooting.
• Good knowledge in 11g data guard, active standby and snapshot standby features
• Managing the transferring and application of archive logs on standby databases.
• Checking for the protections modes to ensure availability and performance.
• Strong knowledge in configuring 10g/11g RAC clusterware using shared storage.
• Administration of RAC instances (ASM & RDBMS) using SRVCTL utility.
• Working with RMAN to migrate a single instance database to RAC environment.
• Addition and removal of nodes to/from cluster system when ever required.
• Configuring Transparent Application Failover (TAF) to provide high availability option.
• Monitoring and managing ASM instances.
• Managing diskgroups by adding disks to them to ensure no space issues.

Environment: SQL, PL/SQL, Toad, Pl/SQL Developer, Cronjob, OEM, RMAN, Export/Import, SQL Loader, PL/SQL writing, Procedure, Triggers, Functions. HP-Unix, Linux Red Hat 9, MS Excel, SSMS,BMC Monitoring tool, HPOV, JMeter, Irfanview

Confidential, Seattle,USA

Oracle DBA/Developer

Tools: Oracle 10g/11g/12c, Shell scripting, Linux, My SQL, Window 2003, PL/SQL Developer, SQL Developer, TOAD 8.5

Responsibilities:

• Installing, creating and configuring Oracle 12c/11g/10g on Linux and Windows.
• Developed Stored Procedures, Functions, and Triggers for implementing business specifications
• Setup and maintained Oracle disaster recovery site using Data guard
• Assisted in designing both physical and logical models for new databases
• Performing user and security administration activities, such as enrolling users, granting privileges to users, and maintaining system security
• Troubleshooting the instance and database server
• Performing export/ import of different database Objects/Schemas using Oracle Datapump utility
• Created and maintained different database structures including tablespaces, data files, redo log files, rollback segments and renaming/relocating of datafiles on different servers
• Performing tuning using various tools including 10g Tuning set, Diagnostic pack, TOAD
• Resolving performance issues using Oracle utilities including EXPLAIN PLAN, TKPROF, SQL Trace and AWR/STATSPACK
• Performed Database Security - creating users & defining roles & privileges for them
• Gathering statistics of data objects using Analyze and DBMS STATS
• Performing the OS level tuning ( I/O tuning, Service Tuning, restricting user access), Database tuning ( Physical design & SGA configuration)
• Performing data loading using SQL*Loader Direct path loading methodology
• Backup/Recovery and disaster planning using User Managed/RMAN, export/import
• Wrote backend triggers and stored procedures using pl/sql

Environment: SQL Developer,Putty, Star Team,Visio,Slick Edit,SQL Loader, RMAN, Export/ImportHP-Unix, Linux Red Hat 9, pl/sql, shell scripts, pro*c,VI Editor

Confidential

PL/SQL developer

Tools: Oracle 10g/11g, Shell scripting, Linux, My SQL, Window 2003, PL/SQL Developer, SQL Developer, TOAD 8.5

Responsibilities:

• Installed, configured and managed oracle 10g on Linux
• Management of Tablespaces (Small file & Big File).
• Creation & Administration of Database users which includes setting the Default & Temporary Tablespaces, assigning TS Quotas, necessary Roles, Privileges and Profiles to the users.
• Space management and instance health check.
• Backup configuration and management with Oracle RMAN.
• Maintained oracle networking and database link creation and materialized views creation.
• Cloned production databases for testing to various environments.
• Setup logical backups of database using EXPORT/DATAPUMP features.
• Physical standby database setup, troubleshooting, maintenance, switchover and switchback operations.
• Monitored database/SQL performance using TKPROF, SQL Trace and Explain plan utilities, identified performance issues and tuned the application.
• Partioning of very large oracle tables.
• Implementation of Data Guard for Disaster Recovery Physical as well as Logical Standby.
• Architecting the Alert systems for Database activities.
• Extensive use of performance tools like AWR, ADDM, TKPROF and Explain plan for performance monitoring and troubleshooting.
• Designed and implemented Backup and Recovery policies.
• Detect Data Block Corruption on system running DB Verify utility, Validate Structure Cascade Command and troubleshoot errors.
• Test and Implement different physical and logical backup and Recovery methods like crash point in time recovery, Full/partial export/import.

Environment: Oracle,sql developer,shell scripts,pl/sql,sql loader, Oracle Enterprise Manager