Professsional Overview

• Around 10 years of hands-on experience in Software Development including Design, Development, Testing, Deployment and Maintenance.
• Involved in Extraction, Transformation and Loading ETL of large volume of data into Data Warehouse
• Performed tuning of PL/SQL code by using Explain Plan and TKPROF
• Well-versed with Database design, Entity Relationship Diagrams ERD , Schema building, Data Modeling and Dimensional Modeling
• Expert in Oracle 10g/11g, PL/SQL and SQL
• Knowledge in Oracle Applications ERP E-Business Suite 11i/R12 with RICE components, Order Management OM , Accounts Payables AP and General Ledger GL modules
• Contributed in customizing back-end scripts using Unix shell scripting
• Domain knowledge in Banking, Transport Distribution, Insurance and Telecommunication
• Analyzed and involved in solving Post Production Issues and Tickets
• Involved is writing Functional MD50 Technical Design Document MD70 .
• Engineered design and creation of PL/SQL code, Oracle Forms and Oracle Reports.
• Proficient in Oracle Tools such as TOAD, SQL Developer, UTL FILE and Informatica
• Experience in Data Migration across different Relational Database Management System RDBMS .
• Strong experience in building Materialized Views for complex queries
• Strong skills in Business/Data Analysis, Applications Programming and trouble shooting
• Designed Online Transaction Processing OLTP for various client modules
• Architected simple and complex SQL queries, Stored Procedures, Triggers, Functions, Packages, Joins and Indexes
• Good team player with excellent work ethics, self-motivated and quick leaner.

Technical Skills:

• ERP: Oracle Applications 11i/ R12 E-Business Suite
• OPERATING SYSTEMS: Windows 98/2003/2000/XP, UNIX
• DATABASES: Oracle 9i/10g/11g
• LANGUAGES: SQL, PL/SQL, UNIX Shell Scripting, HTML, XML
• DESIGN TOOLS: Oracle Forms Reports 6i/10g/11g
• TOOLS: TOAD 9/10, SQL Developer, Informatica 8i/9i

Professional Experience

Confidential

Role: Oracle PL/SQL Developer.

Responsibilities:

• Constant interaction with Java Developers for tuning of SQL statements, embedding them in Java code using SQL and for unit testing and other test sequence comparisons.
• Used ERWIN for Logical and Physical database Modeling.
• Creating Materialized Views for replication of the actual data present over a DB Link.
• Create database partitions on the tables to improve the performance.
• Compare database versions and produce a merged version. As the databases are compared, the user would be prompted to intervene in the database merge and make choices about which of the two competing versions would be put into the output version.
• Prepared Test Plans for various functionalities developed and assisted the testers in creation of test scripts that are used in testing the Oracle stored procedures.
• Detected and corrected bugs during system integration and user acceptance testing UAT .
• Experience of Oracle 11g Development conversion
• Issue that rise, once a customer has customized their database tables and assist customer to merge their customizations into newer versions.
• Worked on SQL Tuning with Query optimization techniques for SQL statements.
• Extensively worked on Performance tuning by using Explain plans and various hints.
• Large scale parallel processing using Oracle in a clustered environment.

Environment:

Oracle 11g, Forms Reports 10g, MS SQL Server 2005, SQL Loader, PL/SQL, XML, Korn Shell Scripting, TOAD, Erwin.

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

• Analyzed Business Documents, Internal External Source systems and Requirements to develop Enterprise Data warehouse Star Schema Logical and Physical Model Facts and Dimensions and Business Process Model.
• Worked with Business Analysts and clients, Analyzing and assessing the business specifications and designing and developing the POPS and Equifax applications.
• Involved in Extraction, Transformation and Loading ETL of the data from the Heterogeneous databases.
• Extensively used SQL Loader and UTL FILE methods to load the fixed length, csv and pipe delimited flat files from Mainframe and DB2 into the Oracle database.
• Used UNIX Shell scripts KORN for Extracting and Parsing data from the files. FTP process is extensively used to send and receive the flat files.
• Developed stored procedures, functions, packages and DB triggers extending the functionality and for retrieving the data from the database for solving complex queries.
• Created Stored Procedures, functions and Packages in Oracle 11g using SQL and PL/SQL for the Audit Trail using Oracle 11g as backend.
• Involved in debugging and tuning the PL/SQL code, tuning queries, optimization for the Oracle database using Explain Plan, hints and also worked on Partition tables using Range method.
• Worked on table partitioning Range and List and deploying local indexing on portioned tables.
• Creating Test scripts for the generated final Reports.
• Provided the Production and Technical support the users.
• Prepared technical documentation of all modules for user level and system level maintenance.
• Created promotion scripts and documents for migrating objects from once database instance to other instances.

Environment: Oracle 11g,Forms Reports 10g, SQL PLUS, PL/ SQL, SQL Loader, XML, Korn Shell Scripts, MS-Excel, TOAD.

Confidential

ROLE : Lead DBA

• RESPONSIBILITY :
• Implemented Oracle Enterprise Manager Grid Control 11g and Enterprise Manager Cloud Control 12c for monitoring, alerting, troubleshooting, tuning and reporting
• Upgrade Oracle databases from Oracle 9i to 10g, 10g to 11gR1 and 11gR1 to 11gR2 using different approaches like export/import, manual process with upgrade scripts and database upgrade assistant DBUA
• Work on Application, Database and SQL tuning problems using Oracle EM, Oracle DBA Hist and Oracle Workload Repository views, Explain Plans and other UNIX tools utilities like SAR, TOP, VMSTAT, RAC Check, OS Watcher etc..
• Review and recommend Oracle security and CPU PSU patches for different environments
• Review Test Oracle new features and recommend suitable new features for implementation like Oracle 11g Advanced Compression, Active Data Guard, etc.
• Work a System DBA as well as an Application DBA. Work with developers to promote new releases in dev, test, QA, pre production and production environment
• Designed and implemented partitioning scheme on monthly basis for big tables and Indexes of data warehouse databases tera bytes in size .
• Work as a Lead DBA for AT T Messaging which includes logical and physical design of application schemas/databases, Develop business logic in PL/SQL, implementation administration of Development as well as Production Oracle 10g/11g RAC databases, monitoring and tuning of Oracle databases, define backup/recovery policies, design implement scalable, high available, fault tolerance databases solutions for APIs
• Participate as a consultant and a lead in deciding right database for APIs like Oracle, Open source RDBMS MySQL, Postgres and NoSQL Databases Cassandra, RIAK which includes installation and developing prototypes for different database options
• Work as a Lead DBA on Oracle databases of AT T's one of most critical applications U-Verse, CIM, LS, IDIS where a small outage counted for millions of dollars to business. Also work on AT T Mobility databases for messaging and content management services and API data warehouse
• Support AT T's high availability databases 7 x 24 using Oracle 9i/10g/11g, RAC, ASM, Data Guard on Linux and Solaris platform for U-Verse, IDIS, DSL, Light speed, CRAMER, CIM, NRS Network Reporting Services , Digital Locker, Speech, Encore/Messaging products as a Lead DBA
• Involve in projects and implementations as a Senior Consultant for design, High Availability, Tuning, Implementation, testing, backup recovery, DRP for different 9i/10g/11g Oracle databases using RAC, ASM, Data Guard, RMAN, Streams, SQL Backtrack, OEM 11g/12c, Golden Gate, Veritas Netbackup, EMC Avamar
• Work with Oracle support engineer and Oracle Insight team for performance issue, RAC and Interconnect related issue
• Participate in Application architecture team and provide suggestion related to database functionality and features to make application more efficient and productive. Review, install, implement, test and provide opinion on open sources technologies like MySQL, Postgress, Riak, Cassandra, Hadoop, HBase, Apache Hive, Apache Pig for different projects with considering different application and business requirements like cost, scalability, consistency, data distribution across multiple data centre, data growth, handling of unstructured data. Also provide comparability between Oracle, Open source databases and No SQL Databases
• Do Knowledge transfer and training to junior and offshore DBAs for daily operations and new Oracle features.

Confidential

Role: Oracle Developer

Responsibilities:

• Design, configure and plan run of performance tests, collect performance data, profile the code, design architecture and change code to improve performance, implement code changes or work with other developers to implement changes as appropriate.
• Applied Database Tuning and Optimization, Normalization in the new database design.
• Proposed SQL Tuning within applications for optimized database access.
• Wrote Queries, Stored Procedures, functions and triggers.
• Creation of users, roles, schemas, tables, indexes etc.
• Wrote programs in Forms 6i Developer 2000 .
• Created reports maintained other existing programs.