SUMMARY:

• Over 7 years of IT experience as a Oracle Database Administrator on a different UNIX flavors Solaris, HP - UX, AIX, Redhat LINUX, Windows NT 4.0/2000/2003 with Oracle 7.x, 8.0.5, 8i, 9i, 10g, 11g, 12c and Performance Tuning, managing large databases, 10g/9i RAC/HA Databases, Streams, DataGuard, Advanced replication, Installation, Configuration, Migration, Security and Space management, Backup and Recovery, Performance tuning and Troubleshooting.
• Installation, configuration and administrating Oracle GoldenGate replication.
• Worked as a team member to provide 24x7 on-call production database support.
• Experience in HP-UX, AIX, SUN SOLARIS, REDHAT, UNIX, LINUX and WINDOWS environments.
• Excellent experience in installation and configuration of Oracle 8i, 9i, 10g and 11g in UNIX/LINUX and Windows environment.
• Experience in leading successful enterprise Oracle data warehousing efforts.
• Have great Knowledge of Oracle architecture.
• Extensive experience in developing applications using Struts Framework and different J2EE design patterns.
• Experience designing logical and physical architectures for Oracle data warehousing solutions.
• Experience in Oracle Data Integrator ODI, ORMA and Oracle PL/SQL Package.
• Good experience in SQL, PL/SQL, Shell Scripting, Parallelism, Partitioning, Data modeling, OLAP, Logical and Physical data model using ERWIN, Backup and Recovery procedures.
• Involved in meetings with data modelers, developers, and dba's.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data using external tables and SQL LOADER.
• Monitored all the 11g databases on Red Hat Linux environments by using OEM 11g and 12c.
• Database administration experience using DB2 UDB Version 9 or 10 on Linux
• Configured Oracle DataGuard in both models i.e. physical and logical model for backup and reporting.
• Design and develop ETL/ELT packages using Oracle Data Integrator ODI .
• Works with Oracle data warehousing including ETL and reporting Business Objects .
• Sr. Database Engineer / Administrator with experience in Production Database Management, Datamasking and scrambling - Ex: Oracle Data Masking Module
• Management of schemas, objects Partitioning of tables indexes.
• Worked in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Oracle data warehousing concepts and web design and development.
• Provide Mid-level operational support for the existing DB2 environment
• Installation, Configuration and Maintenance of Oracle 11g/10g RAC database, ASM, CRS on Linux.
• SQL Loader, Export, Import, datapump, PL/SQL, SQL Plus, SQL Net, BMC-SQL, Server Manager.
• Experience on Data Replication using Snapshot, Materialized views, import/export and Streams.
• Migrating and upgrading the databases to higher versions.
• Perform a risk assessment and design SOX infrastructure.
• Experience in using RMAN and DataGuard .
• Strong knowledge of Data Warehouse and data mining analysis.
• Knowledge in the ETL Extract, Transform and Load of data into a data ware house/date mart and Business Intelligence BI tools like Business Objects Modules Reporter, Supervisor, Designer, and Web Intelligence .
• Involved in different scenarios of OLTP as well as DSS Data warehouse databases.
• Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
• Excellent experience in Database cloning single instance
• Installation, Configuration and Maintenance of Logical/Physical standby database in DataGuard.
• Extensively used Database Administrative tools like Oracle Enterprise manager OEM Grid control, DBA Studio, SQL PLUS, TOAD, DBArtisan.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Back end Database Testing by writing SQL Statements and executing with Rapid SQL on Sybase servers. Senior level SQL query skills Oracle and TSQL in analyzing and validating SSIS ETL database data ware house processes.
• Ensure proper SOX documentation is kept up to-date for scoping,testing, and remediation of all key control activities
• Strong working experience in development and deployment of java/j2ee web components using Web Logic, Web Sphere, JBoss, and Apache Tomcat Servers.
• Tuning the application, memory, and disk using Oracle and third party utilities and initialization parameters including explain plans, tkprof and Statspack.
• Good knowledge of SQ SERVER.

OPERATING SYSTEMS:

HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

RDBMS

Oracle 12c, 11g/10g/9i/8.x/7.x,9i/10g Real Application Clusters RAC, SQLServer2005.

LANGUAGES:

SQL, PL/SQL, JAVA, J2EE, Pro C, C, C, XML, UNIX Shell Scripting.

TOOLS: /UTILITES

Recovery Manager RMAN, Real Applications Cluster RAC, STATSPACK, ERWIN, Clusters, VERITAS Net Backup, EMC Storage DMX4, Developer 2000, SQL Loader, TOAD 9.7/9.5/7.6/7.5, ER/Studio,Oracle Enterprise Manager, GoldenGate

HARDWARE

HP-UXB. 11.23.0409 Itanium2, HPServiceguard A.11.16, SunFire6900, IBM eServer p5 Model 590.

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr. Oracle DBA

Responsibilities:

• Installation, configuration and administrating Oracle GoldenGate replication between oracle databases.
• Installation, configuration and maintenance of Oracle 10g/11g databases.
• Set up, configured and maintained oracle active DataGuard/Veritas Cluster primary and standby databases to ensure disaster recovery, high availability and data protection.
• Configured GoldenGate Active-Active replication with CDR Conflict Detection and Resolution .
• Performed day-to-day DBA jobs for managing Production/Development databases.
• Excellent experience in Opatch and Oracle upgrades.
• Developed Extensive sub queries, PL/SQL procedures, Dynamic SQL, DML AND DDL functions, database triggers and Packages.
• Gathered the client's requirements for developing an updated ITIL based Configuration Management System including process, procedures and integration with discovery and real time service status modelling tools.
• Skilled in use of ODI to code ETL programs and test the same.
• Be prepared to to support non EBS database environments, with technologies including but not limited to Oracle Database, DataGuard, RAC, partitioning, etc.
• Monitored all the 11g databases on Linux environments and also monitored their performance by using OEM 11g and 12c versions.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Installations for DB2 ESE on AIX/Linux environment and Migrating DB2 UDB version 9.1 to DB2 UDB V9.5 and V9.7 and V10.
• Experience in Performance Tuning I/O, Memory SQL Tuning etc by using tools/utilities by
• Automated Workload Repository AWR, Automatic Database Diagnostics Monitor ADDM .
• Support Maintenance of Production, Development and Test Databases on various servers Solaris and HP.
• Creating and managing users with appropriate tablespaces and Indexes, public and private database links.
• Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance.
• Strong technical skills with all Oracle data warehousing technologies e.g., ETL, ODS, DBMS, and BI .
• Experience with deployment of ODI Web Console.
• Extracted data from disparate sources by SAS/ACCESS.
• Worked on Automatic Storage Management ASM for managing data in SAN.
• Manage users, privileges, profiles, schemas using Oracle Grid Manager, Oracle Enterprise Manager OEM and SQL.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Hands on experience in projects related to Oracle Data Masking and data scrambling tools
• Owned the entire reporting process. Interacted with the ETL team, developer s, management, and account holders to get the requirements, document them, design templates, and write specifications.
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server 2000.
• Worked on import/export and datapump export/import
• Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table Index Size.
• Experienced on installation, configuration with Oracle OEM 10g to 12c .
• Proficient in gathering and converting User Requirements into Business Requirements and Functional Requirement Specifications FRS and use Modeling tools like Rational Rose and Microsoft Visio for requirements modeling.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Oracle data warehousing, Websphere and Cognos.
• Develop and maintain the SOX framework/guidance
• Experience in Pharmacy Benefit Manager PBM and managed care.
• Used Quest live re-org and IONS for database tuning.
• Configured shell scripts for job/process automation.
• J2EE Design Patterns: Front Controller, Composite View, Business Delegate, Session Fa ade, DAO, Command Pattern, Singleton pattern, Service Locator.
• Utilized ITIL methodologies to assist accounts in SLA management including incident /change management. Responsible for developing Business Requirement and Functional Requirement Documents
• Knowledge in Planning, Designing, developing and deploying Datawarehouses with experience of both relational multidimensional database design using Data Modeling tools Physical and Logical data models
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• On call DBA and provides 24X7 supports for production problems.
• Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server 2000 database. Well versed in project management tools like MS Project for project planning, Project scheduling.
• Worked with Access Manager Administrator to provide security for Cognos applications
• Excellent experience in moving databases to different servers and schemas to different databases.
• Used MS-Visio for flow-charting, process model and architectural design of the application.
• Excellent experience in managing space for tablespaces with physical and logical standby databases in place.

Environment: Oracle 12c, 11g/10g/9i/, DataGuard with physical and logical standby databases, Sun Solaris 10 on M5000/M3000, HP servers, Oracle Enterprise Manager, SQL, TOAD, AWR, ASH, ADDM, TPROF, Explain plan, STATSPACK, and Oracle GoldenGate replication from oracle to oracle databases.

Confidential

Role: Oracle Database Administrator.

Responsibilities:

• Part of the team for database upgrade from 10.2.0.2 to 10.2.0.4 with logical and physical standby in place.
• Performed day-to-day DBA jobs for managing Production/Development databases.
• Provided 24X7 supports for production problems
• Supported 17 production/development databases.
• Migrating and upgrading the databases to higher versions.
• Excellent in designing business models using UML diagrams such as use case diagrams, class diagrams, activity diagrams, sequence diagrams and collaboration diagrams using Rational Rose and MS Visio.
• Part of the migrating team responsible for up gradation from Oracle 9i to Oracle 10g.
• Worked on Opatch and Oracle upgrades.
• Expertise in configuring GoldenGate, Oracle Streams Unidirectional Table Level between homogenous databases.
• Installation, Configuration of Oracle DataGuard for Physical and Logical mode.
• Installed and administered Real Application Cluster 10g RAC environments adding and removing nodes to the cluster and handled performance tuning using AWR.
• Knowledge using database administrative tools such as Oracle Enterprise manager OEM Grid control and Cloud 12c, SQL PLUS and TOAD.
• Responsible for installing, upgrading and configuring the Oracle server.
• Performed upgrades of Oracle 11gr1, 10gr2, 10gr1 databases on production, test and development environment on Solaris 10, AIX and Linux boxes.
• Worked in release management involving database components.
• Support Maintenance of Production, Development and Test Databases on various servers.
• Oracle security and familiar with database vault.
• In-depth knowledge of Oracle data warehousing concepts including star schema, fact, dimension, slowly changing dimensions, granularity, single vs. multi-grain fact, additive, non-additive, and semi-additive facts.
• Implemented Logical, Physical and Conceptual Data Modeling using ERWIN Data Modeler to visualize data structure to effectively organize, manage and moderate data complexities.
• Worked with ETL team during the upload process.
• Creating, monitoring and maintenance of oracle database replication and integration by materialized views and streams.
• Experience with ODI configuration management.
• Developed UML Use Case model for the application using Rational Rose and assigned to prepare the detailed work flow diagram based on the proposed enhancement for the system. Prepared PowerPoint slides of all the outcomes with the focus on defects and presented to the team. Designed and developed Use Cases and UML models using Microsoft Visio. Identified as well as documented data sources and transformation rules required to populate and maintain data warehouse content. Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models. Team created test scenarios, requirements traceability, test data, executions of test cases, tracking results and defects following ITIL methodology.
• Creating users, tables with appropriate table space and Indexing, database links.
• Manage users, privileges, profiles, schemas using Oracle Enterprise Manager OEM .
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Set up Grid Control to monitor databases.
• Used Informatica to extract and transform data from various DB2 database to the data warehouse.
• Installed Maintaining database and middleware Automation environments
• Worked as a User/Customer advocate and negotiated with user as well as the technical team and management staff to resolve any outstanding requirement conflict during the whole SDLC process.
• Created SAS programs that are used for data validation, statistical report generation and program validation and automated the Edit Check programs using Macros.
• Worked on import/export, export datapump/import datapump and SQL- loader.
• Backup/Restoration, scheduling Backups, taking Logical Backups
• Setup backup, recovery and testing backups and procedures using RMAN.
• Automation of job scheduling by crontab.
• Ability to manage multiple teams on a Oracle data warehousing engagement.
• Extensive experience in Sybase Database Servers, developing and maintaining automated software used to monitor the database
• Tuning the Databases for optimization using STATSPACK, Explain Plans and TKPROF, Estimating Table Index Size.
• Translated Business Requirements and user expectations into detailed specifications employing Unified Modeling Language UML, MS Visio.
• Database Tuning Tuning Applications, Memory Tuning and Tuning Disk Usage.
• Partitioned large tables to increase the performance.

Environment: Oracle 12c, 11g, 10g/9i, HP-UX, Windows NT/2000, Sun Solaris 10, Oracle Enterprise Manager, SQL, TOAD, Erwin Data Modeler, RMAN, GoldenGate, TPROF, Explain plan, STATSPACK, I3agent, J2EE, SQL Loader

Confidential

Role: Oracle Database Administrator.

Responsibilities:

• Installed 9i, applied patches in various environments and upgraded databases from 9i to 10g.
• Set up, configured and maintained oracle DataGuard primary and standby databases to ensure disaster recovery, high availability and data protection.
• Performed day-to-day DBA jobs for managing Production/Development databases.
• Provided 24X7 supports for production problems.
• Management of table spaces for different users by granting quota on Default Temporary tables paces.
• Estimated Storage capacity for database objects.
• Backup and Recovery, Cloning, Replication, Space Management and Database Security with Oracle Software 11g/10g/9i Versions.
• Monitored the growth of the database objects UNIX Shell and Perl scripting. Implemented for capacity planning.
• Strong experience with Business Intelligence and Oracle data warehousing design principles and industry best practices. Expert knowledge of the MicroStrategy suite of analytical tools. OBIEE, SAS, other BI tools is a plus.
• Design and develop ETL/ELT packages using Oracle Data Integrator ODI
• Created UNIX shell and Perl scripts to automate batch jobs through Crontab.
• Extraction of data from different flat files into Oracle Database using SQL Loader and automated the process by using Basic Replication using materialized views and streams.
• Business Intelligence/MicroStrategy Developer will be part of Pharmacy Data Warehouse team responsible for developing and deploying business intelligence and Oracle data warehousing reporting.
• Utilized SQL loader and data pump import to load data into tables.
• Utilized Oracle Enterprise Manager OEM to manage users, privileges, profiles, schemas.
• Database Administration and Planning including logical design, physical design, backup recovery.
• Took a logical backup of the entire database using import/export utility.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
• Exposure on Cognos development Software development kit like SDK in order to customize reports.
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.
• Have worked on backup/recovery, performance tuning.
• Tuning test and production database by altering the parameters.
• Implemented JDBC Java Database Connectivity . nvolved in Logical Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Prepared Demo on SharePoint for various Business to get new approvals like the Therapist and Nursing divisions.
• Executed all efforts within the SDLC parameters of the IT organization leveraging existing technologies, proven system architectures and management team
• Gathered and documented requirements for Pharmacy benefit managers PBMs for health insurance carriers.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.

Environment: Oracle 10g/9i, HP-UX, AIX, Sun Solaris, Red Hat Linux, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, Erwin Data Modelar, RMAN, TPROF, Explain plan, SQL Server, STATSPACK, SQL Loader, Windows NT/2000

Confidential

Role: Oracle Database Administrator.

Responsibilities:

• Installing and configuring Oracle 9i/10gRAC database on Windows Platform.
• Installation and maintenance of Oracle 9i application server.
• Installation and configuration of 32 bit and 64 bit 9i/10g RAC on Linux.
• Installation and configuration of Sql-sever 2000 and 2005.
• Used SSIS to migrate data from Sql-server to Oracle.
• Configuration of SGA and Client server configuration.
• Installation of Oracle 9i DataGuard.
• Strong experience with business system analysis in a complex Oracle data warehousing environment running on UNIX or Windows platform.
• Implemented Oracle Streams for setting up reporting server.
• Involved in database design using Erwin and Relational/OLTP Modeling.
• Worked with DBA Team of 8 members and 24 7 Support
• Maintained instances of around 1.5TB having around 3500 Users and 80 Production/ Development instances.
• Researched and documented As-Is processes, defined To-Be processes, identified gaps and impacts to different groups and systems. Utilized ITIL methodologies to assist accounts in SLA management including incident /change management.
• Use of Oracle Advanced Security for Data Protection.
• Monitoring includes Oracle Enterprise Manager, Grid Control, and Quest Fog light.
• Capacity Planning: Allocate system storage and plan future storage requirements.
• Database move from one node to other and Reorganize.
• Database Schemas Creation based on the logical models.
• 24 X 7 on call support of all production environments in --group supported by our team.
• Utilized Various Raid levels such as mirroring and stripping with parity.
• Monitoring and maintenance of multiple databases for production, development, testing and
• Staging purposes using utilities like OEM and Toad.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Fetching, Analyzing and Loading data into the tables using Perl Scripts.
• Experience in migrating data from Oracle to Sql server databases.
• Written Shell Scripts for the digitization of the Process
• Wrote Perl Script and ksh script to schedule multiple load tests during off-peak hours.
• Primarily responsible for 12 applications databases and for all applications supported by the team While in on call.
• Develops and executes a backup / disaster recovery plan for all databases and performance tuning of the database as and when required.
• Taken Backup and Recovery using RMAN.
• Involved to review and improve a VERITAS Net backup system.
• Controlling database changes and ensuring synchronization amongst different environments.
• Maintain database security Oracle business intelligence and adhere to security policies designed by the client.
• Develop UML diagrams like Use Cases and Use case Narrative, Activity Diagram, Sequence Diagram, class diagram and coloration diagram using MS VISIO 2010
• Develop and Implement robust backup and recovery strategies for production as well as
• Development databases, which includes hot backup, cold backup, and export backup.
• Design and Developed the Framework Manager models and Published into Cognos Portal.
• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures.
• Extensive knowledge of all phases of the software development life cycle SDLC and the iterative Rational
• Unified Process RUP .
• Tuning the database performance through STATSPACK/AWR/ADDM report.
• Guiding the application team to understand how the database works with their application.

Environment: Red hat Linux 4.x, Windows 2003, Oracle 10gRAC/9i, SQL-Server, Tru32 and 64 bit, Oracle Streams, DataGuard, Toad 7.6, RMAN, SQL Server, OEM Grid Control, and ERWIN.