SUMMARY

• 10+ years of experience in Oracle PL/SQL, Design, Development & Administration of Oracle Database 10g and 11g
• 1+ years of experience in Teradata and Teradata utilities
• Good knowledge of NoSql Technologies - Have hands on experience on Cassandra, MongoDB
• Good knowledge of replication techniques such as Oracle Golden gate and Data Guard.
• Good experience in Shell scripting
• Experience in Full range Oracle Database Administrative activities like monitoring and issue resolution of production databases, troubleshooting of performance issues, backup and recovery.
• Experience in database administration and monitoring using Oracle Enterprise Manager 13c
• Good Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table partitioning.
• Familiar with writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance of data access.
• Have extensive experience in developing, implementing and maintaining application systems under Windows/Unix operating systems using SQL, PL/SQL, Oracle Database and have good exposure in Oracle utilities such as Import/Export, SQL*Loader and SQL*Plus.
• Experience in working in both Waterfall and Agile methodology for software development
• Develop scalable reporting processes and querying data sources to conduct ad hoc analyses
• Experience in Telecom domain and well versed with Telecom terminologies
• Experience in working on 24*7 environments to provide production support.
• Experience in Version Control Tools like CVS and Tortoise SVN.
• Clear communication and documentation of technical specifications.
• Highly motivated, excellent team player, enthusiastic and quick learner of new technologies. Strong interpersonal and communication skills in dealing with clients

TECHNICAL SKILLS

Languages and Technologies: SQL/PLSQL, Java

Operating System: UNIX, LINUX

Databases: Oracle 10g,11g,Teradata

Tools: TOAD 12,Sql Developer, Putty, OEM

Version Control: Visual SourceSafe, CVS, SVN

PROFESSIONAL EXPERIENCE

Oracle Application DBA

Confidential

Responsibilities:

• Involved in application database administration, responsible for user security and roles
• Highly skilled in Performance tuning - analyzing query plans and SQL tuning using EXPLAIN PLAN and hints.
• Involved in analyzing Database reports - AWR, ASH and ADDM to identify performance issues and tune the code accordingly
• Worked along with developers to fix or improve database related issues.
• Worked on database management activities like reallocating tablespaces, partition maintenance.
• Performed database refresh activities using Data Pump utilities (expdp/impdp) and SQL Loader.

Environment: Oracle 11g, 12c, SQL Developer, Putty, Oracle PL/SQLOracle tools: Oracle Enterprise Manager 13c

Oracle Application DBA

Confidential

Responsibilities:

• Involved in application database administration, responsible for user security and roles
• Involved in applying oracle patches to the database Confidential periodic intervals
• Highly skilled in Performance tuning - analyzing query plans and SQL tuning using EXPLAIN PLAN and hints.
• Involved in analyzing Database reports - AWR, ASH and ADDM to identify performance issues and tune the code accordingly
• Have good experience in using OEM for database analysis and maintenance
• Developed Stored Procedures, Functions and Packages.
• Have good experience in materialized views
• Provide technical assistance and support to the end user community and application development teams related to database and applications.
• Performed database refresh activities using Data Pump utilities (expdp/impdp) and SQL Loader.
• Worked along with developers to fix or improve database related issues.
• Managing user accounts and security privileges, preparing backup and recovery strategies.
• Hands on experience in Oracle application maintenance activities such as trouble shooting user issues and code deployment

Environment: Oracle 11g, 12c, SQL Developer, Putty, Oracle PL/SQLOracle tools: Oracle Enterprise Manager 13c

Oracle Application DBA

Confidential

Responsibilities:

• Involved in application database administration, responsible for user security and roles
• Responsible for migrating database servers from Unix to Linux platform - Managed data migration and handled the server migration without any issues.
• Highly skilled in Performance tuning - analyzing query plans and SQL tuning using EXPLAIN PLAN and hints.
• Involved in analyzing Database reports - AWR, ASH and ADDM to identify performance issues and tune the code accordingly
• Developed Stored Procedures, Functions and Packages.
• Have good experience in materialized views
• Provide technical assistance and support to the end user community and application development teams related to database and applications.
• Performed database refresh activities using Data Pump utilities (expdp/impdp) and SQL Loader.
• Worked along with developers to fix or improve database related issues.
• Managing user accounts and security privileges, preparing backup and recovery strategies.
• Hands on experience in Oracle application maintenance activities such as trouble shooting user issues and code deployment

Environment: Oracle 11g, SQL Developer, Putty, Toad for Oracle, Oracle PL/SQL, Oracle tools: Oracle Enterprise Manager 11g

Oracle PLSQL Developer

Confidential

Responsibilities:

• Involved in system analysis design, coding, data conversions, development and implementation
• Created tables, Functions, Triggers, procedures and packages for implementing complex database intensive business rules
• Worked on migrating database server from Unix to Linux: managed data migration and replication setup using Oracle Streams.
• Developed procedures to run the SQL * Loader to load data from flat files into the target database tables
• Developed complex mappings to load data from Source System (Oracle) and flat files
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages.
• Performance tuning of the application programs using EXPLAIN PLAN and SQL TRACE
• Increased performance by creating Indexes and Hints.
• Support for the development, pre-production and the production databases

Environment: Oracle 10g (SQL, PL/SQL), SQL*Loader, Oracle Streams, TOAD, UNIX