SUMMARY:

• Oracle Database administrator (DBA) with extensive experience designing, coding, testing and supporting next - generation database solutions in Oracle enterprise and Nosql environments.
• Strong understanding of DBA, Data Warehouse/Data Mart Design, Data Modeling, ETL, BI, OLAP,
• Oracle 10g/11g Database Administration
• Performance Tuning & Capacity Planning
• Data Security, Backup & Recovery
• Pl/Sql Development
• Oracle RAC & ASM Administration
• GoldenGate Installation
• Standby/Failover Administration
• Shell Scripting

TECHNICAL SKILLS:

RDBMS: Oracle 12c, 11g RAC, 10g, 9i, MySQL, NoSQL, Cassandra, MongoDB.

Operating Systems: Solaris 9/10, Linux RHAT, HPUX, Microsoft Windows

Tools: ASM, Data Guard, Grid Control (OEM), Statspack, AWR, ADDM, ASSM,Oracle SQLDeveloper, TOAD, RMAN,Export/Import,DataPump(expdp/impdp), SQLLoader.

Reporting Tools: Aptare,Custom Dashboard,Highcharts,Cognos,OBIEE

Data Warehousing: Informatica 9.1/8.6/7.1.2 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor)

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables

Backup Tools: Veritas NetBackup, NetApp, HP DP, TSM,EMC

Programming Languages: Asp.Net, XML, HTML, Python, C#,Java,SQL, PL/SQL, UNIX Shell Scripting

Standards & Methodology: SCRUM, Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential

Associate Data Architect

Responsibilities:

• Architecting & implementing enterprise & business segment BI solutions.
• Architecting & implementing enterprise & business segment OLTP solutions.
• Expert level production & development database administration - all platforms.
• Logical and physical database design, modeling & implementation of enterprise. Customer and household profitability data warehouse.
• Defining, designing, developing & optimizing ETL processes for enterprise data warehouse 24×7 supports (including Oracle multi-master & trigger based replication).
• Expert level stored procedures development in Oracle.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models
• Gather the various reporting requirement from the business analysts.
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
• Developed the required data warehouse model using Star schema for the generalized model
• Telecommunication,Billing,Payments,Mobile,Analytical domain experience.

Oracle DBA

Responsibilities:

• 24x7 Production database and applications support.
• Installed, configured and maintained Oracle 10g and 11gR2.
• Upgraded databases from Oracle 9i, 10g to 11g.
• Involved with installation and maintenance of Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Applied CPU patches.
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Performed block recovery using RMAN.
• Moving data between databases using Data Pump.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Partitioned large tables for better performance and manageability.
• Installed and configured GoldenGate for replication.
• Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
• Implemented Golden Gate for data recovery and data migration for Oracle 11gR2 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild and abend.
• Responsible in configuring and backing up database using RMAN, Hot backups,Cold backups and Logical backups.
• Migrated databases from Sun Solaris, HPUX to IBM AIX, and Windows to Linux.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Worked with Data Pump to take the logical backups of databases.
• Experienced in performing PointinTime Recovery.
• Performed Capacity Planning and Benchmarking
• Load and Transform data using SQL*Loader & External Tables
• Logical and Physical Database Design
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables
• Experience in FlashBack Technology
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.
• Excellent Communication skills, coordination and communication with system administrators, business data analysts and development teams.
• Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.
• Experience in Capacity Planning and BenchMarking.

Oracle Developer /DBA

Responsibilities:

• Involved in Requirement Collection Design and Developing.
• Developed next generation software tools and products.
• Developed Stored Procedures, Functions, database Triggers and created Packages to access databases from front end screens.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.