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