SUMMARY

• Total 5+ years of experience in Oracle Development, Enhancement and Maintaining applications in Oracle 9i/10g/11g using SQL, PL/SQL in Windows 9x/NT/2000/XP and UNIX/Linux environments. Knowledge in Oracle Architecture, Data Dictionary and DBMS Packages. Knowledge in Oracle utilities SQL*Loader. Core DBA experience.
• Substantial development experience in creating Procedures, PL/SQL Packages, Triggers, Functions, Cursor and Exception Handling.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Working exposure on RMAN utility, backup of database, restoration of database through RMAN utility.
• Refresh / Cloning of database on same servers as well as on other server
• Working Experience on Oracle Enterprise Manager (OEM) and Automatic Storage Management (ASM).
• Good practical knowledge in Data pump Utility
• Experience in query optimization, Performance Tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Developed PL/SQL blocks using collections like Nested Tables, VARRAYS and Associative arrays.
• Used DBMS HPROF package to analyze the PLSQL performance.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Extensive knowledge in Transact - SQL (DDL, DML, DCL)
• Proficient in Tuning T-SQL queries to improve the database performance and availability.
• Developed a Java application for user to reduce the incident and created GUI using eclipse and NetBeans.
• Worked on many java enhancement projects and have an experience in multi threating.
• Excellent analytical & problem-solving skill. Excellent team worker. Self-motivated and quick learner. Adaptable to a fast growing and changing environment.
• Developed UNIX shell script to automate regular activity (Database health check, database refresh and report generation) and monitor system health check and schedule job using crontab.
• Good hands on experience on Tableau 9 and 10.
• Certified on Tableau 10 A-Z: Hands-On Tableau Training For Data Science in Udemy.
• Developed effective and interactive Dashboards using Parameters and Actions, Sets and groups, LOD calculated fields, Animation.
• Expertize with the tools in Hadoop Ecosystem including Pig, Hive, HDFS, MapReduce, Sqoop, Spark,Hbase,Flume, Yarn, Oozie, and Zookeeper.
• Experience in MARC - Warehouse Management System product and its functionality.
• Strong domain experience and Functional knowledge in warehouse management system.
• Positive attitude with keen interest to learn new technologies. Passionate about my goals and desire to perform consistently.
• Accomplished professional with a unique blend of Management, Technical, Functional and Qualitative skills; keen to develop/upgrade the skill set through experience.
• Have excellent communication, presentation and interpersonal skills, with the ability to develop team and Client interaction expertise. Very amiable and extrovert, can interface well with people from various backgrounds.
• Developed two independent websites using HTML, CSS, JQuery, Javascript, BOOTSTARP, PHP, Mysql.

TECHNICAL SKILLS

Languages: SQL,PL/SQL,T-SQL,UNIX/LINUX shell scripts,C,C++, Core Java, Batch Programming.

Databases: Oracle 8i/9i/10g/11g/12c, MySQL, Progress Database, SQL server.

Tools: Tableau 10, SQL Loader, SQL Developer, Oracle import export, F - Secure, Putty, Exceed.

Functional Areas: Retail - Warehouse Management System and Operations.

Other Application: MARC Application and Design 32.

Big Data: HADOOP HDFS, MapReduce, PIG, Spark with scala,kafka, Hive,sqoop, HBase, Zookeeper, Flume.

Web Technologies: HTML5, CSS3, BOOTSTARP, JQUERY, PHP, MYSQL, WordPress.

PROFESSIONAL EXPERIENCE

Confidential, Hillsboro, OR

Responsibilities:

• Mentoring the team members and managing the work allocation amongst the team.
• Providing estimations for assignments to the seniors.
• Requirement Analysis, Preparation of Functional and Technical Specification.
• Creating Database Tables, Views, Functions, Procedures, Packages as well as Database Sequences, Triggers and database link.
• Written SQL queries for retrieving the required data from the database.
• Developing and customizing complex views and materialized views.
• High proficiency in developing Oracle PLSQL.
• Tested and Debugged Oracle PL/SQL packages.
• Developed an end to end interface flat file in PLSQL.
• Have worked on the UNIX to Linux upgrade project.
• Tune the long running SQL script using Explain plan, and hints
• Extensive knowledge in Transact-SQL (DDL, DML, DCL)
• Proficient in Tuning T-SQL queries to improve the database performance and availability.
• Used MS access dumb file to load MS SQL database.
• Worked on MS SQL backup and restore activities.
• Developed UNIX shell script to automate regular activity and monitor system health check.
• Developed Shell script to automate database refresh and post and pre request check.
• Developed procedure and functions to monitor and automate the manual work.
• Developed package to create an interface file in PLSQL which contain all the customer order detail.
• Driving the process improvement, incident management activities.
• Reviewing code and performing quality analysis.
• Impact analysis due to any cross functional dependency
• Root cause analysis for existing production issues, and providing long term fixes for the same.
• Providing P1/P2 support for 24*7.
• Resolve the Incidents with high Quality and client satisfaction by meeting SLA’s.
• Handling monthly change requests by coordinating with multiple teams for smooth releases.
• Interaction with Clients regarding functional and Technical issues.
• Ensuring on time defect free deliveries.
• Fixing the production data and code as per business requirement.
• Have developed a batch program to monitor the windows service.
• Have developed shell script to reduce the daily tasks and manual work.
• Translated business into technical requirements.
• Worked on UNIX self-patching.
• Create business report using Tableau.
• Developed effective and interactive Dashboards using Parameters and Actions
• Expertise in working with data building Groups, Hierarchies, sets, LOD, Tableau 10 animation.
• Developed a Java application for user to reduce the incident.
• Developed a standalone java application using NetBeans and oracle database to fix the recursive issues.
• Worked on many java enhancement projects.
• Worked on Oracle forms and reports to add new column in existing screen and worked on oracle report enhancement.
• Developed and incorporated a new screen in an existing oracle form application.
• Provision of access to new users.

Environment: Oracle 11g, SQL Server, Progress Database, Unix/Linux, Windows XP, Windows 2012 R2, F-secure, SQL developer, Open Text Exceed, SQL Loader, SQL, PL/SQL, T-SQL, Shell script, Batch Programming, Oracle Forms and Reports,java.

Confidential

MSONS DBA SUPPORT

Responsibilities:

• Patch Analysis where there is a patch needs to be applied (Both Application patch and database patch).
• Patch Application as per schedule.
• Cloning as per schedules.
• Backups and issues related to them.
• Query response time and other Performance Issues.
• Work with Oracle Support by raising SRs on several issues.
• Worked exposure on RMAN utility, backup of database, restoration of database through RMAN utility.
• Monitoring Standby Databases and resolve respective issues.
• Regular database maintenance activities (tablespace management, data pump, purging log file)
• Code Migration Support to Functional Consultants
• Experience in Oracle development tools such as Oracle SQL Developer and SQL PLUS.
• Worked on the oracle installation
• Worked on Automatic Storage Management (ASM)
• Managed the flashback space and performed recovery of dropped tables and data using flashback recovery.
• Developing Database Triggers, Views, Functions, Procedures, Packages.
• Used new features like Bulk Collects and FOR ALL to improve performance
• Worked on export/import in test Database for schema refresh.
• Have clone the database from source to target system
• Worked on the deployments.
• Have loaded huge amount of data into database using SQLLOADER.
• Have applied oracle application patch.
• Developed a shell script to monitor the database.
• Developed shell script to automate and reduce the manual works
• Work with other support teams to resolve the incidents/problems
• Used adadmin utilities to apply application patches.

Environment: Oracle 11g, Unix/Linux, Windows, Putty, SQL developer, SQL-Loader, database export and import, SQL, PL/SQL, Shell Script, Oracle Apps 11i E-Business suite, Core DBA, SOA Suite.