PROFESSIONAL SUMMARY

• Over 20+ years of work experience as Lead Developer
• Specialized in
• Advanced Oracle Database Administration 10g, 11g & 12C
• Oracle PL/SQL (12 Years)
• Oracle Forms 10g, Reports 10g Development / customization
• Advanced PL/SQL Scripting
• Stored Packages, Procedures & Functions
• SQL Performance Tuning
• UNIX Shell Scripting
• Interface development
• ETL(Data Extraction, Transformation & Loading),
• Data Migration,
• Complex Query Writing and Performance Tuning
• Excellent experience and maintaining database including database security, Capacity monitoring and performance tuning (I/O, Memory & SQL Tuning etc.) Using Statspack, Explain plan, Analyze, ADDM, AWR Report and so on. Gathering and analyzing AWR report for troubleshooting purposes.
• 5 - year experience in Real Application Cluster RAC including setting up 10g and 11g RAC.
• Good experience in regular Security patching on oracle products and interim patching for various bug fixes on database products.
• Great working experience in writing SQL for creating views, functions, stored procedures, creation of database etc.
• Expertise in efficient database performance, implement performance optimized recommendations, fix issues and problems. Configuring and creating databases using DBCA.
• Extensive experience implementing backup and recovery strategy for disaster recovery using Hot/Cold Backups and using the Oracle backup utility such as RMAN.
• Experience in a variety of hardware platforms including; MS-Windows 2000, 2003, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX.
• Excellent knowledge of SQL*Plus, SQL*Net, SQL*Loader, Enterprise Manager & Performance Tuning Pack.
• Great working knowledge installing, patching, maintaining and upgrading all Oracle software (10g to 11g) and (11g to 12c).
• Extensive knowledge on database backup/recovery strategy (RMAN, Export/Import & Datapump), Capacity Planning, Replication (Streams) standby databases, Oracle configuration management, Database Cloning, Refresh, and patch management.
• Documentation of the work assigned in the environment and stored for the future use.
• Strong emphasis on organization and documentations. Excellent interpersonal and strong communication skills (including Presentations). Customer-service oriented attitude and self-motivated, dedicated in any work environment.
• Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, coding, and configuring servers.
• Worked on Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.
• Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.
• Extensive experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
• Experience in Implementing FLASHBACK technology and its various features in Oracle 10g/11g.
• Configured physical and logical Standby Database (Data Guard) and tested for business continuity/Disaster recovery plan.
• Expertise on Installation/Configuring/Maintenance of Oracle Streams for replication, integration and transmission of data between different databases and applications.
• Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
• Wrote scripts to inform the DBA team on the status, performance and space management of the database.
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing.
• Worked with development and operations staff in resolving problems quickly and efficiently.
• Resolve the bottlenecks in all the database environments.
• Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers.
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database.
• Experience in Logical backup using and full/ partial export/import and Data Pump.
• Extensive work experience in a database migration project team, serving in both an advisory and technical capacity.
• On call technical support for 24x7 mission critical production databases. Willing to work beyond regular hours.
• Domain Exposure: Banking & Financial Systems, Supply Chain Management, Credit Card Dispute Management, Hire Purchase, Leasing, Bill Discounting, Fixed Deposits, Billing Systems.
• Technical Expertise: Strong Technical Development skills (PL/SQL), Leading Technical Team, Mentoring, Project Planning Analysis Design implementation, Process Implementation and Liaison with Client. Proficient with MS Project; highly trained in full life cycle development from project proposal to project closeout. Integrating SAP & Oracle System, JD Edwards & Microsoft Portals. Migrating Oracle systems from older versions to the latest versions.
• Excellent Communication, Technical and Management skills.
• Extraction, Transformation & Loading
• Infrastructure Management Solutions: Software Migration, Software Conversion, Data Migration, and Product Implementation, Development & Customization.

SKILLS:

Operating Systems: DOS, Novel NetWare, Sun Solaris, Winix, HP UX, Linux.

Languages: BASIC, COBOL, FORTRAN, C.

OOPS: Exposure to Java.

Scripting: Advanced Unix Shell Scripting.

GUI: VB Basic 4.0, Visual Basic 6.0, Visual Studio 2003, Developer/2000, Power Builder.

Web Applications: HTML, ASP, CGI-Perl, JSPServlets, Web logic.

RDBMS: Oracle 7.x, 8.x, 10g, Sql*Forms 3.x, 4.x, 6.x Forms 10g, Forms 6i, Reports 6i, Sql*Report Writer 1.1, 2.x, Reports 10g, Pro*C & Sql*Menu 5.0, SQL, and PL/SQL, SQL Server 6.5, SSRS, Crystal Reports, PostgreSQL V6.5, 7.0, Sybase.

Exposure: VB.NET, ASP.NET.

Data/Database Architect: DFD, Logical/Physical Data Models, ERD, HLD, LLD, ERWIN Tools.

Data Warehouse & BI: AWS(Analytic Workspace Manager), Discoverer Plus, BI Publisher.

Database Tuning: Query Tuning (Explain Plan, Hints, TKprof).

Oracle BI: AWS & Discover Plus.

Software Quality: Code Reviews, Unit Testing, Integration TestingPerformance Monitor Tools Enterprise Manager, SQL Analyzer and Quest (Toad).

Project Management Tools: Microsoft project.

Presentation Tools: Power Point, Visio, Excel.

Version/Source Code Control: PVCS, Visual Source Safe

EXPERIENCE:

Confidential, Atlanta GA

Lead Database Administration Consultant - Oracle DBA/ PLSQL

SKILLS: Strong Skills in Advanced Database Administration and Oracle PL/SQL, Performance Tuning in Oracle & Oracle Bulk collect operations.

Responsibilities:

• Managing and coordinating various DBA projects in 200+ database (Oracle 12c, Oracle 11g, goldengate) environment.
• Providing 24/7 database administration support to production (More than 420 servers with more than 2500 databases), staging and QA databases in 4 data centers.
• Responsibilities include supporting The Boeing company database systems in a large complex RH LINUX, HP-UX, AIX and Windows environment.
• Support in the Migration of Oracle 11g database between datacenters.
• Responsible for all aspects of the RDBMS schema internals, involved in logical RDBMS configuration and support, tuning at the logical RDBMS level (tablespaces, tables, indices)
• Responsible for examining trace, alert, metrics, and log files, both at the database and grid infrastructure points of view
• Working with numerous application groups to coordinate dba driven maintenances (upgrades, patching, and migrations) as well as accommodate application owners’ requirements and goals.
• Planning, coordinating and performing upgrades and patching for more than 200 oracle databases for numerous applications/projects
• Planning, coordinating and performing other database supporting activities like database cloning, migration, replication, etc.
• Working with System Administrators to migrate production and non-production environments to a new hardware, coordinating migrations with application groups, choosing the best strategies for database migrations.
• Successfully solving problems and finding solutions in a variety of complex projects and tasks. Participate in team and special projects like Data Masking with OPTIM.
• Performance tuning: query optimization and troubleshooting (analyzing addmrpt, awrpt reports, etc), Database tuning - tuning applications, memory tuning and tuning disk usage.
• Maintain databases with company's monitoring and reporting scripts, in-house RMAN and expdp/impdp procedures, DB and OS space monitoring, etc.
• Environment: Oracle 10g,11g, OEM, RMAN, DBUA, TOAD, Oracle Grid Control, AWR, UNIX, Sun Solaris, Red Hat Linux, AIX
• Provide design and support to newer application for the Railway Systems
• Maintain and monitor Production applications
• Production support for Billing application
• Advanced PL/SQL Coding & Oracle performance Tuning.
• Creating packages, stored procedures, stored functions
• Domain Expertise on Railway transport systems
• Advanced Shell scripting
• Work with large group of Java developers and provide database solutions to the team
• Performance Tuning in SQL/PL SQL (Bulk processing)

Environment: Oracle PL/SQL, Oracle12c, Linux

Confidential, Florida

Lead Database Administration Consultant - Oracle DBA/PLSQL

SKILLS: Strong Skills in Advanced Database Administration and Oracle PL/SQL, Performance Tuning in Oracle & Oracle Bulk collect operations.

Responsibilities:

• Working with other IT professionals for database designs and reviews; troubleshooting database issues, and deploying timely fixes; maintaining regular and proactive database patches, updates and performance enhancement.
• Ability to manage high availability solution centers using Oracle Real Application Clusters (RAC) with several nodes.
• Creating database that meet the constantly changing requirement and need of the company and clients.
• Configuring the Oracle Network environment including Oracle Net Services and Listeners, configuring and managing oracle network.
• Installing, patching, maintaining and upgrading all Oracle software (10g to 11g, 11g to 12c, goldengate) using DBCA; Performance tuning of all Oracle Instance components and assisting the application developers in testing and implementation stages of the application tuning.
• Performing constant and occasional database backup and recovery using RMAN, Data pump Import and Export utility, multiplexing the Control file etc. Using RMAN to clone database.
• Managing and securing the database by using appropriate proper authorization schemes, roles and privileges.
• Modifying database structures as required by developers due to business or application requirements, cloning development databases for testing and training.
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving. Monitor, optimize and allocate physical data storage for database systems.
• Sending daily operational report to the top management regarding the whole operation of the day, including any hitches and unusual situations.
• Identified, resolved, and provided recommendations to various instances of performance problems which include Database performance problems, I/O hardware performance problems etc. Provided a 24hr on call production support.
• Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.
• Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification.
• Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes that are used as standard script across all the databases.
• Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)
• Installed the Oracle software using silent feature and also created databases
• Worked on designing, installing & maintaining OCR, 11gRAC and Data guard components of Oracle.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate. .
• Implemented Stream, Golden Gates for Active-Active Replication between the Datacenter for High Availability.
• Strategic involvement with team for Server virtualization and manageability of infrastructure.
• Currently helping team to use existing infrastructure to achieve Maximum benefit to reduce cost and maximum performance.
• Writing SHELL SCRIPTS for the system and database for effective functionality and report generation
• Supported & maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supportedProvide design and support to newer application for the Railway Systems
• Advanced PL/SQL Coding & Oracle performance Tuning.
• Creating packages, stored procedures, stored functions
• Domain Expertise on Railway transport systems
• Work with large group of Java developers and provide database solutions to the team
• Performance Tuning in SQL/PL SQL (Bulk processing)

Environment: Oracle PL/SQL, Oracle12c, Linux

Confidential

Lead Technical Consultant - Oracle DBA/PLSQL

SKILLS: Strong Skills in Advanced Database Administration and Oracle PL/SQL, Performance Tuning in Oracle & Oracle Bulk collect operations.

Responsibilities:

• Identified, resolved, and provided recommendations to various instances of performance problems which include Database performance problems, I/O hardware performance problems etc. Provided a 24hr on call production support.
• Administered and maintained constant back up and archived data on tape.
• Assisted in database server tuning, application tuning, maintaining detailed documentation according to company’s policy, capacity planning and database security.
• Set up and manage database security by creating new users, roles, profiles, and provide required user privileges.
• Assisted in writing scripts for creation of users, analyzing space requirements and maintaining tablespaces, partitioning schema objects etc.
• Assisted in maintaining, analyzing, evaluating and updating database integrity and security for users and security access to databases.
• Responsible for the report of any issues to the Manager through daily ProSummary report, nightly production log, etc.
• Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Involved in defragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.
• Responsible for all database activities such as User management, space management, database security management.
• Implemented the resizing the online redo logs in production and in standby database.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2Presently providing technical services for Product implementation and Automation
• Advanced Unix Shell Scripting
• Advanced PL/SQL Coding & Oracle performance Tuning.
• Create packages
• Crate Triggers, Stored Procedures & functions
• Domain Expertise on Marketing Solutions.

Environment: Oracle PL/SQL 11g, Oracle11g, Linux