SUMMARY:

• 12+ Years of IT work experience with 10+ years as Oracle DBA in providing 24/7 production & development support of 12c/11g/10g/9i databases on different platforms like HP - UX, SUN SOLARIS, AIX, Red Hat Linux and Windows
• Hands on experience in Oracle 11g/10g RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid Installation)
• Strong experience in implementing and monitoring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Proficient in capacity planning, space management, database security, troubleshooting, Auditing, UNIX shell scripting and documentation
• Extensive experience of PSU patching and bug fixes on the top of Oracle RAC/Non-RAC Production/Non-Production databases.
• Expertise in upgrading Oracle Development and Production databases from 9i to 10g & 11g, 10g to 11g and to 12c.
• Excellent experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports
• Extensive experience in design, deployment and administration of databases of sizes ranging from 200 GB to 4 TB plus in large enterprise environments
• Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB
• Setup Oracle Enterprise Manager (OEM) 12C/11G/10G for database monitoring/performance/diagnostics
• Expertise in RDBMS Tools like SQL Loader, Import/Export, Data Pump, RMAN, OEM Grid Control
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)
• Good experience in SQL, PL/SQL programming, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design
• Experience in using Golden Gate to support data replication in the Oracle database environment
• Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments
• Willingness to learn new technologies, openness to new ideas and ability to learn very quickly

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i,Oracle RAC 11g/10g, SQL Server, DB2

Platforms: Solaris, Red Hat Linux,AIX, Windows

Languages: C, C++, Java, SQL, PL/SQL, SAS

Web Development: C#, ASP.NET ADO.NET, XML, HTML, DHTML

OLAP/Reporting Tools: Informatica power center, Cognos

DBA Tools: Oracle RMAN, ADDM,AWR,ASH,OEM, Data pump, Statspack, SQL Trace, TKPROF

Others: UNIX Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Oracle Tech Lead

Responsibilities:

• Lead / Mentor Oracle DBA team both On-site and Off-shore teams.
• Gather client Projects and requirements and administer to complete the projects in time.
• Share and off-load work to On-site and Off-shore team.
• Provide solutions to engineering teams to help integrate applications on Cloud .
• Install/Upgrade Oracle 11g Database from 9i and 10g to 11g, and 11g to 12c.
• Migrate Databases running on HP-Unix and Solaris to AIX .
• Work with Business leads/Managers and provide Database solutions according to their requirements.
• Performance Monitoring and Tuning of Oracle 9i through 11g Databases.
• Install, Configure, Upgrade and Troubleshoot MySQL databases
• Configure MySQL replication for High Availability using virtual IP.
• Migrate MySQL to Maria DB for Inter Database applications and Upgrading MySQL 5.6 to 5.7.
• Performance monitoring and Tuning of MySQL / Maria DB database using MySQL Workbench.
• Performance tuning using Oracle tools STATSPACK,EXPLAIN PLAN,TKPROF,AWR,ADDM,ASH,10g/11g OEM and 12c OEM, OS Watcher
• Use vmstat, iostat, sar, topas, top tools for performance monitoring and tuning at O/S level.
• Experience in configuring OEM 12c cloud control load balancing by adding additional OMS using F5 Service Load Balancer(SLB).
• Configure and Troubleshoot Shareplex Database Multisite Bi-Directional Replication.
• Configure and maintain Goldengate Bi-directional Replication
• Migrated 11g databases to different server using Goldengate with minimal down time.
• Troubleshoot Physical Standby databases running on 9i and Dataguard for Oracle databases running on 10g and 11g.
• Develop and document Proof of Concepts (POCs) for Exadata .
• Resolved the issues for Conflicts between Source and Target Goldengate Databases
• Troubleshoot Goldengate collision issues and Goldengate DLL Replication
• Perform Database refresh from Production to QA and Dev environments, using RMAN and Storage Snap backup.
• Create Procedures, Packages, Function and refresh Materialized views..
• Enforce adherence to IT Processes including SDLC, Change management, and other fundamental processes.
• Work with Development team on designing standardized data models, and standard and optimal PL/SQL code.

Environment: Oracle 9i/10g/11g, Oracle 10g/11g RAC, Dataguard, Shareplex, MySQL 5.6,MySQL Workbench Toad for MySQL,HP-UNIX,SUN Solaris, AIX, RMAN, IBM Tivoli TSM, IBM Power 6/7 e-series servers, SAN Storage, TOAD, Oracle SQL Developer, Autosys.

Confidential, California

Database Administrator

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Supporting 30+ databases ranging from 30gb to 2tb running on 15 servers
• Successfully set up a four-node RAC on Linux using ASM/OCFS2
• Implemented new features of Oracle 11g like Automatic Memory Management, Automatic SQL Tuning, AWR Baseline Enhancements, Case Sensitive Passwords, Data Recovery Advisor, Database Replay, Read-Only Tables, SQL Access Advisor, and SQL Performance Analyzer
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance
• Successfully planned, executed and lead several disaster recovery tests
• Upgraded databases from Oracle 9i, 10g to 11g
• Involved with maintenance of oracle 11gr2 Standby databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose
• Identify poorly performing SQL’s through OEM and AWR reports and check the execution plans and optimize those queries
• Implemented Oracle database backup & recovery solutions using RMAN
• Load and Transform data using SQL*Loader and External Tables
• Performed large batch jobs, and tuning of SQL queries and database systems
• Administered and managed ASM and troubleshot various connectivity and space issues
• Design data security and/or backup/recovery specifications that meet security requirements
• Partitioned large tables for better performance and manageability
• Analyze database requirements for Developers and Systems Analysts
• Provided technical support to development teams with code tuning and number of diverse requests
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, ISOSTAT and TOP
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries
• Extensive uses of Oracle Data pump utility for moving data among the servers.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports
• Documented and executed steps in support of different planned production maintenance

Environment: Oracle11gRAC, Oracle12C/11g/10g, Dataguard, LINUX, SUN SOLARIS, GoldenGate 11g

Confidential, Charlotte, NC

Database Administrator

Responsibilities:

• Analysis, design and creation of new databases
• Managing more than 100 production databases and 250 test and development databases
• Upgrade and Migration of Database’s from 10.2.0.5 to 11.2.0.2 and applying patches whenever required
• Performance Tuning of Databases, Oracle instances, and Applications.
• Responsible for maintaining Every Day Backups and also to maintain ASM and Disk Space
• Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE,TKPROF, ASH, AWR, ADDM
• Implemented backup strategy to achieve recovery up to the point of failure
• Developed SQL and UNIX scripts to automate DBA functions. Diagnosed problems and implement corrective actions
• Applying Quarterly patches and Version change patch bundles
• Used Oracle backup utility RMAN to implement Oracle backup and performed disaster recovery
• Designed, developed, tested, deployed and maintained database security and audit solutions
• Created scripts and scheduled backups in cron for RMAN database backups and recoveries
• Defined Storage Management and maintenance of various database objects
• Established naming conventions for the logical and physical objects as well as the constructs used in the design, development, implementation and maintenance of Oracle systems
• Tuned & trouble shooted PL/SQL stored procedures, functions and triggers
• Coordinate tasks and issues with Team Lead and Project Manager on daily basis

Environment: Oracle 11g/10g/9i, Sun Solaris, PL/SQL, Java, Toad, RMAN, Import/Export, Statspack, Erwin, OEM

Confidential, Jersey City, NJ

Database Administrator

Responsibilities:

• 24x7 Production database and applications support
• Installation, Configuration and Administration of Oracle 11g RAC and Oracle 10g RAC
• Installed & Configured Oracle 10g Grid Control for monitoring over 35 Prod / Non Production hosts
• Configured and maintained huge OLTP databases
• Installation, Configuration and Administration of Oracle 11g/10g databases includes Database cloning for test environment and applying patches, tuning etc
• Identify poorly performing SQL’s through OEM and AWR reports and check the execution plans and optimize those queries
• Create Database maintenance plans, including updating statistics, re-indexing, structure modification, and index. Maintenance of system Documentation
• Responsible for the Database Builds on Test, Development databases and Monitor Production database during builds
• Diagnosed and troubleshot database problems such as errors and bugs, performance problems, runaway processes, connectivity problems, poor SQL statements, etc
• Created scripts to monitor and manage the databases
• Performed Database Migrations and Upgrades on the same platform and across platforms.
• Effectively communicate and assisted offshore developers with various requests
• Mentoring the DBA team (off shore) and imparting various DBA trainings .Helping in day to day activities.
• Used SQL* Loader and External Tables to Load data from flat files to database
• Utilized OEM for performance analysis and handled alerts in a timely basis
• Implemented DATAGUARD for high availability/disaster recovery purpose
• Writing Batch scripts to load data from Text files into Oracle tables through SQL Loader
• Performing database tuning by using various tools, like Oracle Enterprise Manager and AWR, ASH reports
• Handled numerous tickets generated by Service Manager in a timely manner
• Partitioning of large tables for better performance and manageability
• Analyzed and helped speeding up long running queries
• Created a separate Recovery Catalog on a 11g database and registered all other databases
• Migrated new releases from QA to production
• Applied several quarterly security patches as well as bug fix patches
• Writing UNIX shell scripts for backup and recovery, Import and export procedures

Environment: Oracle11g/10g RAC, Oracle 11g,10g,9i,SQLSERVER, HP-UX, REDHAT LINUX, SUN SOLARIS, ASM,OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader, GoldenGate

Confidential, Lincolnshire, IL

Application Developer

Responsibilities:

• Created Data Models and helped in enhancing Entity-Relationships
• Recoded inefficient SQL and PL/SQL to handle exceptions and error handling
• Copying schemas from one database to another through Transportable Tables paces
• Extracted and loaded data using Oracle SQL*Loader and Export/import
• Ensured database integrity through various constraints and business rules
• Transfer of large volumes of data using Bulk Copy Program (BCP) and Data Transformation Services (DTS)
• Monitored MS SQL Server activity, file growth, NT event logs, Memory, and CPU utilization
• Performed Query optimization to enhance performance of a Visual Basic Application
• Coded SQL Server stored procedures
• Prepared various reports based on user requests and requirements using Crystal Report
• Installed SQL Server Client components on users workstations

Environment: SQL Server, Oracle 9i, Windows NT, PL/SQL, Visual Basic Crystal Reports, Oracle Forms

Confidential, Jersey City, NJ

Database Administrator

Responsibilities:

• Managed transfer of bulk data from flat files to oracle tables using SQL *Loader utility
• Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding
• Improved database performance by identifying and resolving row chaining
• Managed security by creating appropriate roles and privileges to users depending on the user activity
• Analyzing and resizing objects for Production Database
• Synchronized test and development areas with production and performed database design and re-design activities as necessary to support all projects
• Responsible for system/process analysis
• Created SQL scripts for monitoring free space and fragmented spaces in the database
• Performed SQL tuning to increase the response time of SQL statements
• Conducted performance assessments Using EXPLAIN PLAN, TKPROF & STATSPACK to collect statistics and tuning of database processes (Application, Memory, I/O and hardware) to optimize
• Utilization of system resources and help remove bottlenecks

Environment: Oracle 10g/9i, Windows NT, SQL *Loader, Informatica, Java, Cognos, TOAD