SUMMARY

• Over 9 years of extensive experience as Oracle DBA. Working extensively on maintaining highly available, highly transactional, large scale Oracle Database on SaaS model for healthcare industry in the United States.
• Expertise includes SQL programming, infrastructure development, capacity planning, Backup - Recovery plan, Performance Tuning, Replication and Security maintenance in live production data servers.
• Have a good experience on ETL, OLAP system, Data warehouse implementation including Business Analysis using the latest Business Intelligence (BI) technologies.
• Experience on Logical and physical Database Design, Documentation, Database Architecture planning and Requirement Analysis in Oracle and SQL server Database on MS-Windows, NT Server, UNIX/Linux, Sun Solaris and RHEL server Operating System.
• Oracle 8i, 9i, 10g, 11g and 12c Database Administration including Installation (using DBCA and manual), Configuration, Patch Installation, Migration, Upgrades, Backup & Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring, Tuning, Grid Control in very large scale database environment and mission critical large OLTP and OLAP systems.
• Experience as On-Call 24x7 production DBA support, application/development DBA.
• Installed and configured oracle GoldenGate classic and Integrated capture on Linux and Solaris server.
• Installed and configured oracle DataGuard, Active DataGuard on Linux and Solaris server.
• Upgraded database from 11.2.0.3 to 12.1.0.2 on Linux.
• Experience in Oracle 11g RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid control Installation.).
• Migrated databases from SQL server to Oracle 11gr2 using SQL developer for small sized databases.
• Extensive experience in DataGuard configuration, implementing and monitoring standby databases.
• Hands on experience on Performance Tuning and cost optimization; Tuned various large critical OLAP and OLTP databases of Tera bytes size using various tools like STATSPACK, AWR, SQLTrace, Tkprof, Analyze, ADDM and Explain Plan Methods.
• Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) for database monitoring, performance checking and diagnostics.
• Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
• Good experience in PATCHING and UPGRADATION. Expertise in upgrading Oracle Development and Production databases from 9i to 10g & 11g.
• Hands on experience on Data Warehouse setup using OBIEE and customized ETL system development. Relational and Dimensional Modeling, OLTP to OLAP system building, RDBMS to Star schema conversion.
• Proficient in SQL, PL/SQL, Shell scripting, Procedures, Functions, Cursors and Triggers; and extensively used TOAD and SQL Developer for querying databases etc.
• Exposed to Data Warehouse assignments in various domains like Medical services, Sales, Insurance, Financial & Bank, Inventory Distribution, and Production Data warehouses.
• Experience in Large Data Migration projects.
• Extensive experience in configuring and implementing Flash-Back Technology and Log Miner.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN), Network Attached Storage (NAS) and NetApp.
• Database cloning with RMAN, Capacity Planning, Database Refresh and patch management.
• Experienced in maintaining databases on large Production, Testing and DEV environments.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Hands on experience on Oracle Advance Security implementation including Datamasking, TDE, Wallet.
• Raising TAR with Oracle Support, using Metalink to resolve the bottlenecks in the database.
• Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams.
• Experience on Strategic planning, Team development and US Client interactions.

TECHNICAL SKILLS

Database: Oracle 9i, 10g, 11g, 12c; MS SQL server, MySQL, MS Access

Operating System: UNIX, Sun Solaris (5.10), Solaris 10 x86-64, RedHat Enterprise Linux 6.5 Server, Oracle Linux 6.0, CentOS, Ubuntu and Debian, MS-DOSMS Windows (NT, 2000, XP, 2003, Vista, 2008, 2010), Windows Server

Programming Language: C, C++, Visual Basic, Developer 6i and Java.

Scripting Language: SQL, PL/SQL, Shell script

Data Access Tools: Toad, Tora, SQL Plus and SQL developer

DB Monitoring Tool: Oracle Enterprise Manager (OEM) 10g, 11g and 12c

Data Backup and Recovery: Recovery Manager (RMAN), DataPump and Export-Import

SQL Tuning and monitoring Tool: TKPROF, Explain Plan, ASH, AWR, ADDM, SQL Trace, Statspack

Data Loading: SQL Loader, Oracle Direct Path Loading

Oracle Replication: GoldenGate, Streams, DataGuard, Materialized View

MS SQL Server Replication: Transaction, Merge and Snapshot

Database Security: Data Masking, Advance Database security, TDE, Data ReductionDatabase Vault, Audit Vault and Database Firewall, Key Vault

Database clustering tool: Oracle RAC

Data Warehouse and BI: OBIEE 11.1.1.7, Oracle BI Administration Tool

ETL: Oracle Data Integrator, Pentaho KETTLE

Project Management Tool: JIRA

Source code management system: GIT, Gerrit

IDE: IntelliJ IDEA

Server Monitoring Tool: Catci

Web Servers: Oracle WebLogic Server

Domain management service: Microsoft Active Directory

Data Modeling Tool: Erwin 4.0, Visio, SQL developer, Oracle BI Admin Tool

Virtualization: VMware, VirtualBox

Others: Putty, SSH, SCP

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Senior Database Administrator

Responsibilities:

• Manage SQL/Oracle Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Develop, update and maintain Healthcare relational databases in ORACLE, SQL server on distributed Unix environment (Solaris, RedHat Enterprise Linux, Oracle Linux).
• Provide support on a wide range of database administration functions including Performance Tuning and optimizing cost, running and test SQL queries using SQL*Plus, SQL Developer, troubleshooting database problems, maintaining version control of database entities, advising customers on new database features, and leading studies to evaluate the effectiveness of current database methods and procedures, investigation of issues arising from data loss and corruption.
• Provide support of development database and schema design. Provide support in accessing, manipulating, and preparing data within Healthcare system, maintaining FDB database, investigating data structures and analyzing data to attach meaning and value.
• Regular investigation on high database load, locks, blocks using OEM, ASH, ADDM and AWR.
• Troubleshooting on Production database, Replication maintenance using GoldenGate.
• Performing backup and recovery operations using DataPump and RMAN.
• Alert log Monitoring for critical databases every day in the production environment.
• Creation of materialized Views and gathering necessary statistics on objects.
• Install, configure and upgrade of software including code deployment.
• Participates in systems planning, scheduling and implementation.
• Maintaining Existing third-party and in-house developed scripts and databases.
• Work with internal and external customers to develop new value-added programs and data solutions with existing data warehouse structure. Participating in lead technical meetings.
• Research and evaluate alternatives and recommend solutions for business issues.
• Create ad-hoc reports utilizing various data sources.
• Maintain current knowledge of relevant technologies.

Confidential, Connecticut

Senior Database Administrator

Responsibilities:

• Oracle Database 9i, 10g, 11g and 12c administration and managing multiple large scale environment databases in production, development and test environments for OLTP Databases. Running on Linux and Solaris Operating System. Sizes of DBs varied from 1 TB to 20 TB.
• Supporting all environment builds, Design, capacity planning and ongoing Monitoring.
• Design logical/physical data modeling.
• Perform database-related Performance Tuning and Optimization to improve the performance of the system using view, Materialized view, local and global Partition, Index, Index rebuild.
• Responsible for all of the Server and Database Security for all environments.
• Create necessary Server and Active Directory groups in order to provide the required access to customers. Audited the servers to ensure continued compliance.
• Database Security maintenance using Data Masking, Oracle advance Security, Wallet, TDE, Database Vault, Audit Vault and Key Vault.
• Database Load analysis and resolving complex or ambiguous database issues.
• Regular investigation on locks, blocks, deadlock using OEM, ASH, ADDM and AWR.
• Troubleshooting various problems of Production database using Alert log and Trace file processing.
• Install, configure, patch apply and upgrade of different software.
• Participates in systems planning, scheduling and implementation.
• Migration script checking, preparing and running in production including downtime estimation.
• Preparing large and complex SQL, PL/SQL, Function, shell scripts and Cronjobs.
• Assists with data conversion and normalization. Create and maintain database documentation.
• Data Backup, Restore and Recovery using Oracle DataPump, Hot/Cold Backup and RMAN.
• Database Replication Maintenance, Trouble Shooting and Monitoring using Oracle GoldenGate.
• Modifying the Database structures as and when required.
• Data warehouse implementation, R&D on developing ETL system.
• Implement data storage, archiving, database/Schema comparison.
• Identify user roles and controlling access permissions and privileges accordingly.
• Data conversion, mapping and related coding (java). Data migration from excel to oracle database.
• Oracle Clusterware setup and configuration, RAC installation using ASM, Grid control Installation.
• Perform MYSQL and SQL Server database administration activities.
• Provide assistance with technical support to developers and analysts.
• Provide weekend and after hours coverage for all systems as needed. Training new users on how to use the database system.
• Communicate regularly with technical, applications and operational staff, to ensure the database integrity, security and to meet the project deadline.
• Writing complex SQL, PL/SQLs using SQL Plus, SQL Developer for the Custom Reporting tool.
• Requirement analysis, Database Design using Oracle Database, documentation and schema design on Linux and Solaris platform.
• Client communication and Project management using JIRA.
• Giving guidelines to Developer and SQA team to find the exiting database design bug and re-designing plan.
• Installation, configuration and administration of the Oracle 11gR2 database on Solaris 10 x86-64.
• Installation, configuration and administration of the Oracle Business Intelligence Enterprise Edition (OBIEE) 11gRelease 1 (11.1.1.7) on RedHat Linux 6.5 server platform.
• Ensuring Replication using GoldenGate.
• Defining facts, dimensions, hierarchies and developing Star Schemas.
• Gathering reporting and analysis requirements, documenting the report specifications, implementing the Metadata layers including Physical Layer, Business Model and Mapping and Presentation layer.
• Designing and developing of the Metadata Repository (rpd) using Oracle BI Administration Tool.
• Designing customized interactive dashboards using drill down, guided navigation, prompts, filters and variables.
• Creating Analysis using OBIEE Answers/Analysis/ Oracle Database to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Developing Hierarchies, Level Based Measures and adding multiple sources to business model.
• Creating executive reports with BI Publisher integrated with OBIEE.
• Giving guidelines to the statistics team to design complex analysis; Regular meeting with clients, sales and marketing people and other module owners.
• Real-time replication of the database using GoldenGate.

Confidential

Database Programmer

Responsibilities:

• Database Designing & Re-designing using SQL SERVER bit and MS Access for School Management System and Inventory Management System.
• Programming with Visual Basic and writing SQL, T-SQL, Stored Procedures and Reporting on Crystal Report.