SUMMARY:

• Currently working as a technical lead database administrator supporting Oracle, Solr, Sqlserver and Hadoop databases.
• Over 10years of database production, development, testing experience in OLTP, Data warehouse and data center.
• Looking for a setting where utilize technical skills to contribute toward the success and progress of the company.

TECHNICAL SKILLS:

Language:  SQL, PL/SQL, Java.

Tools /Utilities:  Oracle 9i, 10g, 11g, 12c, RAC, Data guard, golden gate, Oracle Enterprise Manager (OEM), SQL*Plus, PL/SQL Recovery Manager (RMAN), SQL*Loader, Data Pump, AWR, ADDM, TKPROF, ASH, OracleVM Manager, Data Guard, RAC, ASM, Oracle Enterprise Manager Grid Control, and command - line tools. Oracle stream and data Replication, DBCA, NETCA etc, SQL Developer, TOAD, Erwin Putty, SSH. SQL* Navigator, SVN Client and Power Designer, SDM12, Solr, Tomcat, Unix/Linux, Hadoop, sql server

Quality Assurance tools:  HP Quality Center, Hp Unified Function, QTP, SOAP UI Professional 4.6.4,XML Spy and IBM Rational, MS Excel

Operating system:  Windows 8/7/XP/2003/2000, Linux/Unix, VM Box, VMware, Fusion 11(Solaris, AIX, RHEL, HP-UX)

Applications:  MS-Office I and II, MS-VISIO MS-Works, Photoshop, Adobe, Visio, MS Project, Notepad++

PROFESSIONAL EXPERIENCE:

Confidential

Lead Database Admin

Responsibilities:

• Co-ordination, analysis, implementation and monitor (PROD & Non-PROD) on Oracle, Hadoop and Solr database hosted on Unix, linux, and tomcat servers.
• Supporting more than 160 databases over 30 terabytes of data and 5000 thousand of users.
• Installing, designing and developing oracle databases for different environment.
• Ensure database related security policies, naming HDS compliance, operating procedures and best practices is maintained in all environments.
• Performance tuning; query tuning, system tuning, explain plan, indexing, table partitioning, compression, Outline, AWR, TKPROF, ASH, ADDM and more.
• Troubleshooting different applications to improve load performance and response time.
• Involved in daily SQL review and rewrite against performance tuning or to resolve database long session operations (Tuning Bad Queries).
• Proactively monitoring database activities to detect and resolve bottlenecks
• Research on failed jobs, missing data and Compiling invalid database objects
• Extensively use of OEM, Power Designer, Sql Developer, Sqlplus, Sql Navigator, Toad, Incident management, Service center, symphony, SDM12, and putty tools.
• Ensuring regular builds are accurate and promoting to QA and PRD (OLTP and Data warehouse)
• Developed new and existing database architecture process and diagram to maintain HDS compliance
• Hub scan extract process initial support for hub sortation
• Engage in data migration; Data pump (10g - 11gR2/12c), Patching (CPU/PSU), upgrading and database extract transform load - ETL process
• Data movement to test load performance for production database by using utilities like Export/Import.
• Application data import for data operation centers for US and Canada
• Database duplication/cloning and refresh on regular basis
• Monitoring and supporting PL/SQL/Linux Batch jobs and processes
• Maintain and Recompiling SQL, procedures, functions and triggers scripts
• Linux operations/commands to stabilize and maintaining oracle database
• Creating DDL, logical and physical database object/structure design and maintenance
• User management, database security and connectivity issues.
• Data replication development and implementation (Data guard, CDC and golden gate)
• Resolving CDC staging errors and data replication feed issues
• Oracle Data Guard 11g support and maintenance for disaster recovery
• Troubleshooting and resolving data guard issues (log gap and others)
• Stimulating failover on data guard as yearly maintenance routine and during inclement weather
• Multi node RAC database 11gR2 installation, maintenance and configurations
• Troubleshooting and resolving RAC issues (Cluster issues, node eviction etc.)
• GRID - ASM- RAC cluster configuration and management (CRSCTL, SVRCTL etc.)
• Backing and recovering data using Recovery Manager utility (RMAN)
• Provides physical and logical database backup for database recovery to ensure consistency and stability.
• Design Backup strategy for the client using Hot RMAN backup utility and Cold Backup Methodology
• Manual disaster recovery development and backup initiative against data lost.
• Review and implement backup solution for Sortation Machine System on centralize and decentralize databases.
• Hadoop user and permission user management on dev, staging and prod
• Monitoring Hadoop cluster master and slave server using ambari utility from Hortonworks
• Ensure all the requires hadoop cluster services are online functioning as expected
• Responding and resolving hadoop master and slave server space alert
• Monitoring data replication from active prod to standby prod using Wandisco Fusion.
• Engage in open source software spark, Kafka, Solr, Tomocat, lucene to enhance existing and future application operations.
• Installing and maintain Solr instance standalone and cloud version 3 - 6.
• Creating and maintaining Solr cores with different data set
• Configuring Solr instances on Tomcat servers
• Installing Solr and Tomcat on Unix/Linux serves
• Resolving Solr and Tomcat server issues

Confidential

Lead Oracle Database Consultant

• Troubleshooting, resolving backup and recovering issue for centralized and decentralized databases
• Linux operations/commands to stabilize and maintaining oracle database
• Creating logical and physical database object/structure design and maintenance
• Generating SQL (ddl etc) for development, testing and production environment
• Monitoring and supporting PL/SQL/Linux Batch jobs and processes
• Maintain pl/sql code for different applications
• Recompiling SQL, procedures, functions and triggers scripts
• Supporting Oracle database 11gR2- 12C (both OLTP and Data Warehouse)
• Installing oracle database both standalone and RAC cluster
• Installing and configuration of Oracle OEM agent on production and non production database
• SQL server database management using management studio tool
• Resolving RAC database issues (node eviction, listener, CRS issue)
• Database setup and configuration
• Performance tuning; query tuning, system tuning, explain plan, indexing, table partitioning, compression, Outline, AWR, TKPROF, ASH, ADDM and more.
• Migration data from one server to another using (Data pump, EDX etc)
• Oracle standby database setup, configuration and maintenance
• Resolving standby issue (log gap, MRP issue, network etc)
• Real time oracle golden gate monitoring
• Database patching and upgrade
• Weekend support during disaster and maintenance window
• Extensively use of OEM, Power Designer, Sql Developer, Sqlplus, Sql Navigator, Toad, Incident management, Service center, symphony, SmartSVN 7 and putty tools.
• Ensuring regular builds are accurate and promoting to QA and PRD (OLTP and Data warehouse)
• VDI (Virtual Desktop Interface) coordination and management for my Offshore team in India
• Developed new and existing database architecture process and diagram to maintain HDS compliance
• User management, database security and connectivity issues
• On-call weekend database operation and maintenance support
• Working as a technical onsite lead for Confidential /FedEx for onsite employee and offshore vendors
• Conducting regular training on database performance, architecture (RAC) and managements
• ICE request process for regular build and Replay all prod changes

Confidential

Oracle DBA

• Planned, designed, installed, configured, and managed Oracle database 11g on Linux.
• Database performance tuning; Query/SQL and system tuning (Oracle-DB2, MySql)
• Implementing table partitioning, compression, store outline to improve performance, data management and day to day database monitoring
• Perform daily performance monitoring of Oracle instances on many database servers using AWR, ADDM, TKPROF, ASH, SQL TUNING and all the advisories to maintain high database performance.
• Database date modeling to establish solid data layout, design, and to enhance database performance and data architecture.
• Shell scripting on linux  as needed
• Strong experience in shell scripting
• Install standby database for standalone and RAC database.
• Writing efficient coding to improve load performance in the database
• Configuring and monitoring database to detect and resolve bottlenecks and tuning poor performing SQL statement
• Troubleshooting and resolving database integrity, blocking and deadlocking issues.
• Extensively using DATAPUMP to move data and for logical backups.
• Strong experience with design, development, and testing of backup and recovery to ensure complete recoverability.
• Backup and recovery using (RMAN) catalog and scheduling set up of RMAN backups.
• Established backup and recovery strategy using daily hot backups, RMAN and weekly full backup.
• Configuring various RMAN parameters.
• Database duplication of using RMAN.
• Database Upgrades (10.1.0.2 Patchset to Patchset to 10.1.0.4.2/10.1.0. 10 g to 11g Patchset to11g2).
• Migrate from (DB2, MySql ) to Oracle
• Creating views, materialize views and other database objects
• Administering database user accounts. Create, modify and deactivate user accounts.
• Monitor user access rights by granting and revoking privileges to users and Roles.
• Monitoring user sessions and take appropriate action to kill the inactive sessions.
• Auditing the users to improve Authentication, authorization and safety management
• Customization and troubleshooting of Oracle database 10g and 11g on Linux and Windows OS.
• Monitor table spaces, memory structures, undo segments, logs and space allocation
• Managed and configure oracle database dataguard (standby database).
• Install, configure and maintain RAC on 5 nodes 11gR2
• Troubleshooting RAC servers and other components(CRSCTL, SRVCTL, ASMCMD and more)
• Administering vote disk and cluster registry
• Troubleshoot and resolved log gap in Data Guard Configuration.
• Stimulating failover on dataguard as yearly maintenance routine and during inclement weather.
• Handling Critical, Emergency Issues in all production environments and On Call Support over the weekend (24X7 assistance).
• Provided Oracle network troubleshooting, technical and administrative duties.
• Developed and enforced database related trainings, policies, standards, naming conventions, operating procedures and best practices.
• Developed a strategic plan for the database development that supports the organizations operational requirements.

Confidential

Oracle Database Administrator

• Install, manage and configure Oracle database plus Mongo database.
• Develops web content and maintains the mango.org site using the content management system, including page creation and updates
• Installed and applied several Oracle critical patches
• Monitored, optimized and allocated physical data storage for database systems.
• Installed and configured relevant network components to ensure database access as well as database consistency and integrity
• Performed various RMAN, cold and hot backups.
• Created PL/SQL procedures
• Created triggers to fire before and after DML operations as needed.
• Worked on PL/SQL Stored Procedures, Functions, Packages, Package bodies, and anonymous blocks
• Troubleshoot and resolved various Oracle problems such as connectivity problems, backup and performance issues.
• Created and managed documentation on the configuration and support of the Oracle Databases
• Cluster Database Installations and Upgrades (10.1.0.2 to 10.1.0.4.2/10.1.0. 10 g to11g2).
• Performed bulk load into the database using SQL Loader
• Tuned a database and performed applications for faster and better performance; also performed Goal-oriented tuning as necessary.
• Performed Oracle database Upgrade and Migration from Oracle  10g to 11g
• Managed oracle automatic storage management (ASM)
• Configured Real Application Cluster (RAC) and Data guard.
• Managed Real application cluster RAC
• Oracle Clusterware/Grid Infrastructure on a multi-node cluster to include Active/Passive failovers (RAC); software tuning.
• Managed RAC databases using CRSCTL, SRVCTL and grid control
• Install, manage and configure oracle database data guard (standby database).
• Troubleshoot and resolved log gap in Data Guard Configuration.
• Stimulating failover on data guard as yearly maintenance routine and during inclement weather.

Confidential

Oracle Database Administrator/Developer

• Maintained full responsibility for Oracle  9i,10g, 11g logical and physical database  design, implementation, and maintenance
• Maintained full responsibility of handling database server tuning, application tuning, maintaining documentation, capacity planning and database  security.  - Provided a 24/7 availability and coverage of technical assistance through the use of emails, cell
• Retrieved data from very large Database (VLDB).
• Upgrade from 9i to 10g and 10g t0 11g
• Provide database administration on production, testing and development database servers.
• Planning, installation, configuration, management and troubleshooting of Oracle 10g and 11g database on Linux and Windows servers.
• Created and manipulated tables, indexes and views.
• Displayed data from multiple tables
• Worked on PL/SQL Stored Procedures, Functions, Packages, Package bodies, and anonymous blocks
• Created PL/SQL procedures and functions
• Ability to handle multiple projects with deadlines to meet SLAs and have good coordination skills with management, development teams, vendors and systems administrators.
• Worked in tandem with developers  to define the overall Database design, Database modeling, and Normalization along with capturing it in the form of Entity Relationship Diagrams (ERD) using ERWIN and Toad Data Modeler.
• Created triggers to fire before and after DML operations as needed.
• Managed Real application cluster RAC
• Oracle Clusterware/Grid Infrastructure on a multi-node cluster to include Active/Passive failovers (RAC); software tuning.
• Managed RAC databases using CRSCTL, SRVCTL and grid control.
• Oracle Export and import (Datapump).
• Problem identification and consulting; database backups and recovery using RMAN; and the application of software maintenance provided regularly by vendors.
• Implemented the use of Oracle Recovery Manager (RMAN) using rman catalog to back up the databases.
• Performance tuning, using ADDM, AWR, Optimizer, Explain, SQL Advisor; using Enterprise Manager to tune databases.
• Member of Infrastructure team and performed Upgrade of Oracle 10gR2 to Oracle 11g and 11gR2.
• Applied quarterly Critical Patch Updates (CPU) and Patch Set Update on various platforms to ensure a stable and robust Oracle environment.
• Developed, implemented and performed backup and disaster recovery strategy.
• Installed and managed Oracle database using Grid and database control on 10g and 11g.
• Maintained stored procedures, functions, triggers, packages and views used by the database instance.
• Documented database structure, changes, problems, issues for future reference.
• Managed and configure oracle database dataguard (standby database).
• Troubleshoot and resolved log gap in Data Guard Configuration.
• Stimulating failover on dataguard as yearly maintenance routine and during inclement weather.