SUMMARY:

• Having over 10+ years of experience in IT Industry as Database Engineer in Designing, Installing, Managing database products namely Oracle and Microsoft SQL Server on Unix/Linux, Solaris & Windows environments
• Expertise includes Oracle installations, Upgrades, Migrations, Configuring logical/physical architecture, Design and Creation of high volume OLTP and OLAP databases, Security and Auditing.
• Performed Full range of Oracle DBA activities like monitoring of mission critical databases, troubleshooting performance issues, backup and recovery, Configuring database security, Database tuning, Capacity planning, Production support and documentation.
• Experience in SQL, PL/SQL, Database procedures, triggers & packages.
• Performing tuning of application using ADDM, AWR, ASH, SQL - Tuning Advisor, statspack, Explain Plan and Oracle Enterprise Manager Cloud Control 12c
• Domain knowledge such as Insurance, Utilities & Ecommerce.
• Oracle RAC Database Administration including Installation, Configuration, Analysis, Design, Backup and Recovery.
• Experienced with tools/utilities: OEM, RMAN, TOAD, Embarcadero DB Artisan, SQL* Loader & Data Pump and Strong understanding in Oracle Architecture
• Extensive experience in configuring Active Data guard and RAC on UNIX/LINUX environments for High Availability with ASM and storage on EMC SAN.
• Extensive performance tuning activities like SQL Tuning and Database/Instance Tuning. Implemented data replication through materialized views.
• Experience with Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Setup, Configured and Maintained Oracle Active Data Guard to control Primary and Standby Databases and ensure Disaster Recovery using various data protection modes.
• Installed Oracle Enterprise manager Grid Control agents on UNIX and Windows platforms and configured the TARGETS in the Repository for efficient monitoring of the mission critical Production databases.
• Performed SQL Server DBA duties including: Installation, Configuring, Maintenance, Patching, Configuring Security, database backups, restores, performance tuning, and capacity analysis.
• Data modeling activities include designing the database to support various applications of the client by developing logical and physical models using Designer/ERWIN based on the requirements specified by the client.
• Creating and reviewing documentation for change management, implementation plan and proof of concept (POC).
• Having experience in Vendor management.
• Efficient in communicating and coordinating with other groups during implementation of change.
• Successful in Providing 24x7 On-call Support for Production databases on rotation basis.
• Extensive interaction with Business Analyst, Managers, Developers, QA and End Users, having strong Communication Skills
• Highly adapt to new environments achieved as teamwork
• Strong analytical & logical abilities in Business Analysis and Technical documentation

TECHNICAL SKILLS:

Oracle: Oracle 12c, Oracle 11g RAC, Oracle 10g RAC, Oracle 9i

Microsoft: SQL Server 2005, 2008, 2012

Operating systems: Red Hat Linux, SUSE Enterprise Linux, Sun Solaris, Windows, Amazon EC2

Languages & Scripting: C, SQL, PL/SQL, Shell Scripting

Tuning Tools: Explain Plan, Staspack, AWR, ADDM

Tools: & Utilities Data Guard, RMAN, RAC, OEM, GoldenGate, Data Pump, SQL Loader

Administration Tools: Oracle 12c Cloud control, Oracle Enterprise Manager, SQL Developer 17.2.0, ER/Studio Data Architect 10.0.2, Embarcadero DB Artisan XE6, Toad 12.10

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

• Created DB upgrade architecture design & DB upgrade strategy.
• Reviewed existing DB dependencies, testing cycles for applications, application dependencies, existing Service Level Agreements, Performance requirements for applications, existing data load and workload management strategies for production DB.
• Implemented DB upgrade of Oracle DB version 11.2.0.3 to Oracle DB version 11.2.0.4 on both non-production and prod environments.
• Performed DB upgrade implementation, dry-run testing, performance testing & post-upgrade validation of DBs
• Assisted with DB related aspects of functional testing.
• Provided Oracle 11.2.0.4 DB tuning and troubleshooting assistance based on the outcomes of functional testing.
• Installed and configured Data Guard on production primary environment and standby environment:
• Configured Oracle flashback on Data Guard primary and standby environments.
• Instantiated the Data Guard standby DB.
• Configured the Data Guard broker & validated the Data Guard and broker configuration
• Testing of Data Guard switchover using the configured Data Guard broker.
• Testing of failover using the Oracle snapshot standby procedure.
• Performing DB upgrade dry-run testing and validation for production DB.
• Assisting with DB related aspects of User Acceptance Testing (UAT).
• Providing Oracle DB tuning and troubleshooting assistance based on the outcomes of UAT, performance, load testing & post go-live assistance
• Preparing an engagement summary that will provide description of the work accomplished, findings and recommendations.

Environment: Oracle 11g/12c, DataGuard, OEM Cloud Control 12c, RMAN, ASM, Linux RHEL 6.6, TOAD 12.10, Shell Scripting, PL/SQL, MS SQL Server 2008 R2/2012

Confidential, Lake Forest, IL

Sr. Database Engineer

• Involved in Proof of Concept for planning and migrating the multi-terabyte oracle databases to Amazon AWS
• Installed & configured the Oracle 11gR2 databases on Amazon EC2
• Documenting the database backup and recovery procedures that support business continuity.
• Migrated multi-terabyte database from Oracle Exadata to Amazon EC2
• Involved in Database migration using RMAN duplicate and Schema level refresh on AWS environment for testing Purposes.
• Migrated Oracle RAC database from ASM to file system & Single instance databases using RMAN
• Exposure with Project planning which includes effort estimation, documentation on technical tasks and issues
• Extracted the data from SQL Server databases to flat files using SSIS package.

Environment: Oracle 11g/12c, Amazon Elastic Compute Cloud (Amazon EC2), Open VPN, OEM Cloud Control 12c, RMAN, ASM, Linux RHEL 6.6, TOAD 12.10, Shell Scripting, PL/SQL, MS SQL Server 2008 R2/2012

Confidential, West Des Moines, IA

Sr. Database Administrator

• Installed, configured and maintained Oracle 11g/12c Databases on Linux, UNIX Platforms.
• Maintain database backup and recovery procedures that support business continuity.
• Worked with different teams for application releases in Dev, QA, UAT & Prod environments by deploying the database changes.
• Migrated single instance Oracle database to RAC database
• Configured and Administered Golden Gate replication
• Scheduled RMAN scripts to automate backups of RAC/Standby/single instance databases
• On call production support (24x7)
• Performed Databases Refresh using RMAN duplicate and Schema level refresh from Production to UAT and DEV Environments for testing Purposes.
• Performed monthly partition maintenance like truncating partitions and adding new partitions.

Environment: Oracle 11g/12c, OEM Cloud Control 12c, RMAN, ASM, Linux RHEL 5.x/6.x, Windows, Sun Solaris, TOAD 11.6, Shell Scripting, PL/SQL.

Confidential, Rye, NY

Sr. Database Administrator

• Involved in the complete SDLC, Database design, System analysis, design and development.
• Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.
• Installation and Configuration of 11g Grid Control/Cloud Control 12C agents.
• Setup and maintain RMAN backup and recovery strategy of mission critical databases
• Performed application Query tuning using utilities ADDM, AWR, explain Plan, SQL Tuning Advisor and suggested the best access path for the SQL queries.
• 24X7 production support and on call rotation
• Participated in development and implementation projects
• Expertise in preparing power point presentations of technical information for both technical and business users.
• Applied latest patches as per evaluation requirement.
• Performed Databases Refresh using RMAN duplicate and Schema level refresh as per the user requests from Production to UAT and DEV Environments for testing Purpose’s.
• Performed monthly partition maintenance like truncating partitions and adding new partitions.
• Installed and patched SQL server 2008 R2/2012 servers.
• Performed Refresh of the SQL Server databases as per the customer request to support the testing.
• Troubleshoot system issues, scheduled maintenance jobs of SQL Server databases.

Environment: Oracle 11g/12c, MS SQL Server 2008 R2/2012, OEM Cloud Control 12c,, RMAN, ASM, AIX 5.x/6.x, Linux RHEL 4.x/5.x, Windows, Sun Solaris, TOAD 11.6, Shell Scripting, SRDF, PL/SQL.

Confidential, Trumbull. CT

Sr. Database Engineer

Responsibilities:

• 24x7 production support of Oracle & Microsoft SQL Server databases
• Performed Oracle upgrades, script-writing, routine task automation, security, backups/recovery, database monitoring.
• Performed capacity planning, space management, database upgrades/migration.
• Worked with application teams in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ER Studio & Power Designer
• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Performed in place upgrade of all Oracle Dev/QA databases from oracle 10gR2 to 11gR2 & migrated all Prod databases to new hosts from 10gR2 to 11gR2 & upgraded few databases to Oracle 12c
• Handling database releases in Dev, QA, UAT & Prod environments by deploying the database changes.
• Installation and configuration of Oracle 11g2 RAC on VMware 5.x Virtualization technology
• Migrated Oracle RAC databases from ASM to file system & Single instance databases using RMAN
• Involved in Oracle 11g RAC administration including Patching, Upgrading and Monitoring
• Performing data management tasks as required - loading, editing, restoring and removing data at the requests of clients in accordance with data retention policies.
• Installed & configured Oracle 11gR2 Dataguard in Trumbull (Primary site) & Ashburn (standby) for fail over purposes.
• Providing solution to the client in setting up Oracle servers in particular clusters as per the license compliance.
• Exposure with Project planning which includes effort estimation on technical tasks and issues
• Developed RMAN Backup, Restore Scripts
• Performing SQL*Loader jobs for loading data from claim data files.
• Performing Database refresh jobs to load data from Production to Dev/QA databases using data pump jobs
• Creating Users, Roles, Profiles and grants based on the Role of the user.
• Testing of Backup’s and Documenting backup strategies.
• Maintain database backup and recovery, database refresh procedure on Sybase databases
• Install, configure, maintain and restore 2008 & 2012 SQLSERVER databases
• Upgraded MS SQLSERVER 2008 to 2012.
• Scheduled maintenance plans like daily & weekly backups, rebuild indexes, update stats, shrink databases, check database integrity etc. via SQL Server management studio
• Maintain database backup and recovery procedures that support business continuity.
• Performed tuning on system and Production databases.
• Worked in 24x7 production environment and provided on-call and day-to-day support.

Environment: Oracle 10g/11g/12c, Oracle Enterprise Cloud 12c, SuSe Linux Enterprise Edition 11SP3, SQL Server 2008/2012,Windows Server 2008/2012,SQL Developer 4.1,ER/Studio Data Architect 10.0.2,Embarcadero DB Artisan XE6, Sybase ASE 15.5

Confidential, Dallas, TX

Senior Oracle Database Administrator

Responsibilities:

• Monitoring / Scheduling / Planning backup & recovery strategy
• Worked on data retention project by creating and purging table partitions by developing stored procedure and Packages for partition maintenance.
• Configured and Administered GoldenGate replication
• Creation and maintenance of database objects (tables / views as per client requirement)
• Performed Oracle 10g to Oracle 11g migration and upgrade
• Refreshing schema using exp/imp, expdp & impdp
• Calculated optimum values for database parameters such as amount of computer memory to be used by databases.
• Resolve database performance issues, database tuning AWR, ADDM, database capacity planning, replication, and other distributed data issues. Installing, upgrading and Managing Oracle GRID control, Extensively used Oracle GRID infrastructure
• Implemented effective Patching strategy on top of 10gR3 RAC database to provide stability, reliability and performance and resolve critical issues proactively.
• Developed RMAN scripts to automate backup of RAC/Standby/Single instance databases
• Implemented Oracle RAC and Standby Database (Active Data Guard) for high availability/ disaster recovery purpose.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Developed stored procedures, functions, packages and triggers.
• Coordinating with the Development team to create efficient Queries, Indexes, Views, and Stored Procedures and triggers.
• Troubleshooting Data Guard issues related with configuration and Operations.
• 24*7 on call support on database.
• Designing & developing Shell scripting.
• Tuning of forms and reports for better performance
• Supporting large databases with OLTP and batch activities

Environment: Oracle 9i/10g/11g, SQL Plus, Oracle Enterprise Manager (OEM), UNIX, Linux Enterprise Edition, SQL Developer, Windows Server 2005/2008,TOAD 11.0

Confidential, MI

Oracle Database Administrator

Responsibilities:

• Involved in Data Archival project
• Installing Oracle and recommending kernel parameters.
• Configured Grid Control agents to collect database and instance level metrics and specific metrics to monitor RAC configurations
• Created database objects like tables, views, indexes, Partitions, Materialized Views.
• Maintained separate RAC database for testing and cloned production database
• Added new RAC 10g nodes for existing RAC clusters on Linux Itanium servers
• Creating users and Creating Roles, and assigning roles, privileges and profiles to users.
• Developed Shell Scripts to create DB objects for, Automate backup and monitoring and testing scripts.
• Monitoring of data guard in the production environment
• Monitoring the alert logs, listener logs and trace files regularly
• Monitoring the table space usage and Index usage regularly.
• Storage management, sizing the database objects, monitoring Disk usage.
• Monitoring the Backup Status. (Exports, Cold Backup, Hot Backup )
• Debugging the bugs in SQL using toad and troubleshooting end users problems.
• Monitoring RMAN jobs and events by using OEM.
• Compared schema objects, databases, tablespaces for better understanding of databases between test and production environment.
• Supported Development Team for Informatica and Cognos Performance Issues.

Environment: Oracle 9i/10g, Oracle Enterprise Manager (OEM), Linux 10, PL/SQL, Microsoft Server 2003, Toad 7.0.

Confidential

Oracle Database Administrator

Responsibilities:

• Installation & Configuring of Oracle Database
• Creating users and maintaining database security.
• Designing and enforcing standards and naming conventions.
• Implemented Backup/Recovery Strategies.
• Testing of Backup’s and Documenting backup strategies.
• Writing UNIX shell scripts for backup and recovery.
• Performance monitoring and tuning
• Creating stored procedures, packages and database triggers.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Moved data between databases using export/import and network links.
• Developed stored procedures, functions, packages and triggers.
• Restore databases from production to Dev/Test environments.
• Performed alteration and modification of tables, table-spaces, indexes and other database objects.
• Monitoring the alert logs and trace files regularly
• Monitoring the Table space Usage and Indexes usage regularly.

Environment: Oracle 8.0.1, exp/imp, SQL*Loader, Oracle Enterprise Manager (OEM), Linux Enterprise Edition 5.2, UNIX, Windows Server 2005, TOAD 10.5