SUMMARY

• I have twenty - five years of professional IT experience out of which more than FIFTEEN years as a Senior Database Administrator in Architect level, FIVE years as LEAD Database Administrator successfully managing Multi-Terabyte size of Oracle and MS SQL Server Databases.
• Configuration and Administration of Oracle 12cR2 and 11gR2 Real Application Cluster (RAC) environments for multi-nodes based database by configuring Oracle registry, Oracle Clusterware and RAC. Working on Cluster Verification Utility (CVU). Administering Oracle SCAN listener and server to & from cluster monitoring. Starting and stopping cluster monitoring of the instance and listener thereby checking the status of Oracle cluster resources.
• Implemented Physical standby database (Data Guard) for production database with Dataguard broker. Setup and successfully performed active fail over in the event of production failure. Monitoring Redo Transport services, Log apply services and Role transitions. Handing issues with Network tuning for Redo Data Transmission.
• Administering SQL Server High Availability and Disaster Recovery strategies. Experience in DR processes including Log Shipping and Database Mirroring. Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Implemented the new SQL Server 2016/2012/2014/2K8 mechanisms like data compression, online indexing, Contained Databases, security principals and Always-On Availability Groups (AAG) and HA/DR Troubleshooting.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning. Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs. Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon. Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
• Experience working on Oracle 12cR2/11gR1 OEM Grid Control for the effective DB administration. Administration of Oracle files using Automatic Storage Management (ASM) in a Storage Area Network (SAN).
• RMAN configuration using Recovery Catalog/no-catalog for databases running on ARCHIVE/NOARCHIVE and managing more than 100 plus instances. Restore and DB Cloning from RMAN new features.
• Installation and Configuration of Oracle Apps 10i/11i in different operating systems for VLDB in OLTP & Data Warehouse environments. Implementation of Oracle 12cR2/11gR2 New Features such as Segment Advisor, SQL Tuning Advisor, SQL Access Advisor, MTTR Advisor, Flash Recovery Area, Automatic Database Diagnostic Monitor (ADDM) and export/import Data Pump utilities of various type of Data Loads and enhanced securities for HA database. Data loading using SQL*Loader direct and parallel options and Oracle Wallet.
• Monitoring and optimising the Database Performances through Database Tuning such as AWR and ADDM, Tuning of SGA and Memory, System Tuning, Application Tuning and SQL query plan using Explain Plan, Tkprof and prefstat.
• Writing UNIX/Linux Ksh/Bash/Perl shell scripts for scheduling of jobs in Crontab for Database monitor.
• Oracle and SQL Server DB patching, cloning, troubleshooting issues/errors; collaborate with Oracle support for bugs and creating TAR. Designed SOPs, responsible for 21 CFR Part 11, SOX regulatory compliance audits.
• Experience on Logical & Physical Designing of Databases using tools such as ErWin for effective Data Modelling for DWH and OLAP systems satisfying Database Normalization.
• Worked as a Cloud Database Administrator and involved in PEOPLESOFT based Oracle 12cR2 environment migration to Amazon Web Services (AWS). Involved with issues for PeopleSoft application to run effectively.
• Configuration and Administration of GOLDENGATE v10.4 and GG Director for UNI/BI-DIRECTIONAL replication. Configuration of GG Veridata v3.x for comparison between Source and Target after replicating the processes for online Transaction Logs from Source DB to Target DB.
• Involved in SDLC process, going thru Waterfall model using Agile software development. Promoting database application environments going thru a Change Management process. Carrying out candidates’ performance review appraisal and involved in hiring best resources for the team. Certified ITIL professional.

PROFESSIONAL EXPERIENCE

Confidential

Network Administrator/Programmer

Responsibilities:

• Leading the efforts of managing mission critical DoD USPTO databases for United States Department of Commerce in a very large complex database design and delivery projects. Managed database administrators and operations teams on different database environments across multiple sites.
• Configured Oracle VM with OCFS and shared storage pools. Configured VMWare with Oracle 11gR2 RAC. Setup VCS on Solaris for Oracle RAC supporting Lawson v10 application including Web products and its Security.
• Participated in quarterly meetings with Senior Management to discuss technical infrastructure. Managed change control meetings ensuring that changes to production environments are validated and thoroughly tested. Supported overall IT control practices, remediation, action plan execution, QA, Production and systems certification as part of SDLC process. Directed and provided guidance in solutions for deployments, integration, testing, remediation and re-engineering efforts in Production. Conducted performance reviews, goal settings for DBA team members, attracting and retaining the best talent.
• Installation and configuration of Oracle 11gR2 Real Application Clusters and Active Standby and 12c databases for Production, Development and QA on Oracle Solaris v11 and RedHat Linux and IBM zLinux meeting the SOX Compliance. Production Support for HA and MAA DBs. Installation, Configuration and Maintenance of Oracle Real Application Cluster 11g (RAC) for multiple nodes in IBM Z/OS, IBM iSeries and RedHat Linux.
• Implemented RMAN new features including compression algorithm to minimize database backup and restore size and time effectively. New procedure for faster database duplicate/cloning process by implementing Oracle 11gR2/12cR2 new feature. Datapump for schema and objects backup in Development and QA environment.
• Installation and maintenance of MS SQL Server 2012 and 2014 and 2K8. Maintaining the database systems ensuring successful backups, resolving system issues by effective tuning and performance analysis, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, Query Optimization, Physical DB design, updating system documentation, system and database recovery. Refresh data in QA-Test environments for testing of new builds and deployments.
• Administering SQL Server High Availability and Disaster Recovery strategies. Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations. Implemented new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG. Created DTS package for data transfer between Oracle and SQL Server environments. Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Leading a team of DBAs for multi-terabyte database sizes. Designed and implemented change management procedures and processes for the engagement resulting in a more structured and manageable project. Prepared statement of work (SOW) for custom projects to help with billing efforts to generate additional revenue for the organization
• Installation and configuration of Oracle 11gR2 and 12c databases for Production, Development and QA on Sun Solaris v10 and IBM AIX meeting the SOX Compliance. Production Support on 24X365 basis for HA and MAA DBs.
• Installation, Configuration and support of Oracle Real Application Cluster 11g (RAC) for multiple nodes. Monitored and administered and backing up RAC instances. Used the Oracle Flashback Query options such as Flashback database for recovering the whole database to a point in time, Flashback table for restoring the state of a table to a certain point in time and Flashback Drop.
• Implemented Automated Oracle Tuning feature. Configured ADDM for bottleneck problems, memory related issues, DB Configuration problems, Space related issues, application/SQL tuning issues etc. Used AWR snapshot reports for ADDM to analyze data for performance bottlenecks. Implemented Oracle Automatic SQL Tuning procedure for enabling SQL Tuning. Tuning of SGA, memory allocation and I/O Tuning such as reducing Disk I/O Contention.
• Designed and Implemented Database Cold and Hot backup strategy using RMAN. Database backup implementation using EMC BCV and Veritas NetBackup. Export/Import of database using Data Pump Utility was configured.
• Created and configured the Oracle Standby databases. Configured Data Guard for Physical, Logical and Active Data Guard providing HA of DBs. Monitored DB growth and activities and Exception notification procedures thru Emails.
• Database automation for Crontab script using UNIX ksh and Dynamic SQL scripts for administration purposes and integrate data load scripts using SQL Loader. Administration of Oracle DB instances using OEM 10gR2 Grid Control.
• Designed Dimensional data models (Snowflakes, Star Schemas), which consisted of both fact and dimension tables. Maintained code tables, materialized views and fact tables being loaded on a daily basis from various sources. Logical and Physical Database design using ERWin. Working with ETL tools such as Data Stage and Informatica for Data masking to protect customer info and implemented Row-Internal Synchronization, Table-Internal synchronization and table-to-table Synchronization and Encrypting the data by Nulling Out Or Deletion.
• Applying Oracle Patches when/as required. Contacting Oracle Support using METALINK. Responsible for writing SOP for the DB server implementation procedure and mentoring Junior DBAs includes Offshore in Europe and Asia.
• Installed, configured Oracle EBS R11i and applied patches.
• Expert in SQL Server data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations. Linked Servers between SQL Server 2012/2008 R2 & Oracle 10g/11g. Also created DTS package for data transfer between the two environments.
• Tuned MS SQL database 2012/2014, optimizing complex SQL statements for best possible performance.
• Experience in using MS SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA). Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions. Expert in implementing the snapshot isolation and DDL triggers. Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE). Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Administer multiple Oracle Databases on Linux OS using Banner ERP front end. Installed and implemented Oracle Data Warehouse and Banner's Operational Data Store. Installed and implemented Banner's Degree Works product for the Registrar's office.
• Lead a team of DBA’s on a large complex database design and delivery projects. Managed database administrators and operations teams on different database environments across multiple sites and offshore team.
• Participated in quarterly meetings with Senior Management to discuss technical infrastructure. Managed change control meetings ensuring that changes to production environments are validated and thoroughly tested. Supported overall IT control practices, remediation, action plan execution, QA, Production and systems certification as part of SDLC process. Directed and provided guidance in solutions for deployments, integration, testing, remediation and re-engineering efforts in Production. Conducted performance reviews, goal settings for DBA team members, attracting and retaining the best talent.
• Lead database compliance effort in accordance with 21 CFR 11, SOX, HIPAA regulations and participate with internal and external audits resulting in fulfilment of FDA regulations and requirements.
• Oracle 11gR2 Real Application Cluster (RAC) installation, configuration and support for Multi-node on Red Hat Linux and Solaris OS for Production, Development and QA environment. Implemented Oracle 11gR2 new features for advanced compression and column level expression, Concurrent statistics gathering, and parallel query management, Oracle Flash Cache, Automated SQL Tuning, Automatic Memory Management, and Adaptive Cursor Sharing, Patching of Oracle RAC Databases.
• Installation and configuration of Oracle 11gR1 Oracle Enterprise Manager Grid Control to administer RAC and non-RAC databases, Administration and support of EPIC Systems, AMISYS database environments in 24X7. Upgraded to 12cR2 OEM for Prod Servers.
• Implemented a strong DR policy for all the critical applications servers which have been appreciated by the management. Data Guard High Availability Databases as a Disaster Recovery (DR) Plan.
• Implemented RMAN new features including compression algorithm to minimize database backup and restore size and time effectively. New procedure for faster database duplicate/cloning process by implementing Oracle 11gR2 new feature. Datapump for schema and objects backup in Development and QA environment.
• Mentoring DBAs and developers. Effective SQL and PL/SQL coding and scripting including ksh, csh for effective DBA management scripts, Implemented SOP, DBA best practices for effective database management. Working with Network and Storage Administrator for effective configuration for Oracle High Availability environment. Duties included a combination of infrastructure and technical support, build implementation, capacity and monitoring planning and setup from database admin capacity.
• Data Architect responsibilities includes logical and physical data modelling, data analysis and definitions, database design and engineering, database architecture/set-up, security, standards development and implementation. Designing and implementing DW logical data model.
• Trouble shooting and fine-tuning of SQL Server 2K8/2012 databases for its performance and concurrency. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through SQL Server DTS, SSIS. Analyse long running slow queries and tune the same to optimize application and system performance. Set up SQL Server configuration settings for better server management. Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
• Deployment of Oracle database using Amazon RDS. Backing up database in cloud using Amazon S3 thru OEM.
• Installation of Oracle 12c fusion middleware including Weblogic server, Oracle application server, Oracle coherence, Oracle JDevelopr on Amazon Web Services (AWS) on Cloud. Applied Oracle EBS patches in IBM Z/OS.
• Implemented Oracle 11gR2 New Features in Automatic Storage Management (ASM) for storage and administration of Oracle files under SAN. Administered ASM Disk Groups and backed up ASM managed files. Other features such as Case Sensitive Passwords, Data Recovery Advisor, Database Replay, Query Result Cache, Secure Files, SQL Access Advisor, SQL Performance Analyzer, SQL Plan Management, Statistics Collection Enhancements, Table Compression Enhancements, Tablespace Encryption and Temporary Tablespace Enhancements etc.
• Setup, Configuration and administration of Oracle 11gR2 and Oracle Apps 10i databases for Prod, Test and Development environment. Implemented Secure Shell (SSH) tunnelling as a way of Oracle Network traffic. Implementation of Fine Grain Access Control (FGAC) for Oracle Data Encryption and Oracle Data Masking.
• Configured and Administered multi-nodes Oracle RAC databases for different environments. Implementing SOX standards to meet the customer requirements. Using cloning and replication procedures, backup and recovery procedures, export/import scripts, datapump scripts, and RMAN scripts. Setup RMAN scripts for backup/recovery for all environments. Maintained and support DataGuard for production instances. Configured Oracle Enterprise Grid Control for centralized monitoring, executing scripts, patches, status reports, backup reports, log reports, statistics reports. Planning and installing Oracle patches (quarterly) across the Business.
• Meeting project managers to discuss projects, implementations, impacts on the Business systems, updates, plan maintenance windows, plan installations. Understanding Business Needs, implementing new products that will help save money and improving on time and effort throughout the Business.
• Installation and Administration of MS SQL Server v2K8/2K5. Database design, creation of user Databases, Installation of MS SQL Clients. Use SSIS to transfer millions of rows of data to and from heterogeneous data sources.
• Using DTS for import/export and transform data in support of tasks such as data consolidation, archiving, and analysis, FTP task, the Execute Package task, the Dynamic Properties task, and the Message Queue task.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application. Performance monitoring and tuning of SQL servers.
• Conversion from MS SQL Server to Oracle using Oracle SQL Developer, SSIS and DTS.
• Designing and Implementing the Filters that can be applied in different modules based on the individual requirements of the modules, which helps the users in restricting or browsing through the Data, they actually require.
• Installed, configured and administered Oracle 11gR2/R1 and 10gR2 High Availability databases for Production, Development and QA environments on Sun Solaris v10, IBM AIX, Linux. Lead the team of Production Support for 600 end users, Lead the Migration efforts in DB upgrade from 10.2.0.4 to 11.1.0.6 using Migration Utility and implemented New Features.
• Installed/configured Oracle Golden Gate v10.4 replications in a Real Application Clustered Environment on Solaris v10. Responsibilities include Running an Initial Load, Mapping and manipulating data, Customizing GG processing, monitoring processes, managing the Oracle DDL replication environment and performing administrative processes,
• Backup and recovery strategies of Oracle GoldenGate. Tuning of Oracle GoldenGate server for optimal performances. Installation and configuration of the GG Veridata v.3.x for comparing objects between Source and Target DB. Publishing the report on the web. Configuration of GoldenGate Director Server.
• Configured Data Guard Broker using DGMGRL and Data Guard Manager GUI via EM Grid console to monitor and manage physical/logical standby databases. Configured physical standby database for Maximum Availability protection with fast-start failover using data guard broker on Solaris v.10. Configured Flashback Recovery Area for all the 11g production databases. Monitoring Redo Transport services, Log apply services and Role transitions.
• Configured 11gR1/10gR2 Enterprise Manager Grid Control for effective Database maintenance and monitoring. Configured Templates, User Defined Metrics, Rules etc. for Alert generation and receiving EMAILS to DB monitor. Also effective configuration, maintenance, and administration of Oracle Text in an Mainframe environment.
• Configured 10g2RAC for two nodes with ASM/SAN storage on Red Hat Enterprise Linux Failover testing and implementation of TAF Migration, Load balancing, Up-gradation and RAC database patching using rolling upgrades.
• Responsible for performance tuning of corporate databases. Used Database Features like Mean time to recovery (MTTR), Flashback Query, LogMiner. Identifying the poorly performing queries using Explain Plan, TKPROF, AWR reports and assisting the DB developers in optimizing and tuning the SQL and PL/SQL code using SQL trace & SQL Tuning Advisor. Administration of Oracle database supporting Oracle 11i EBS apps.
• Designed, Configured and Implemented centralized database backup solution using 11gR1/R2 RMAN compression utility ZLIB algorithm, Catalog database repository for 100+ databases. Database export and import data pump utility for loading data into DWH and OLAP environments.
• Installation and Configuration of typical Fail Safe configuration and deployed in managing Unplanned group failover and Planned failover. Efficiently managing Independent workloads and Load balancing.
• DBA Support on Oracle Apps 10i Databases. Applying patches, DB Tuning, backup and restore etc. Unix Ksh scripting for DBA and also reviewing/using PERL scripting for Administration automation.
• Perform database Capacity Planning and growth projection by monitoring DB space and ensuring disk space availability for various end-user applications accessing the database. DB size is >25TB and users are >600.
• Leading a team of DBAs for multi-terabyte database sizes. Designed and implemented change management procedures and processes for the engagement resulting in a more structured and manageable project. Prepared statement of work (SOW) for custom projects to help with billing efforts to generate additional revenue for the organization
• Installation and configuration of Oracle 11gR1 and 10gR2 databases for Production, Development and QA on Sun Solaris v10 and IBM AIX meeting the SOX Compliance. Production Support on 24X365 basis for HA and MAA DBs.
• Installation, Configuration and support of Oracle Real Application Cluster 11g/10g (RAC) for multiple nodes. Monitored and administered and backing up RAC instances. Used the Oracle 10gR2 Flashback Query options such as Flashback database for recovering the whole database to a point in time, Flashback table for restoring the state of a table to a certain point in time and Flashback Drop.
• Implemented Automated Oracle Tuning feature. Configured ADDM for bottleneck problems, memory related issues, DB Configuration problems, Space related issues, application/SQL tuning issues etc. Used AWR snapshot reports for ADDM to analyze data for performance bottlenecks. Implemented Oracle Automatic SQL Tuning procedure for enabling SQL Tuning. Tuning of SGA, memory allocation and I/O Tuning such as reducing Disk I/O Contention.
• Designed and Implemented database Cold and Hot backup strategy using RMAN. Database backup implementation using EMC BCV and Veritas NetBackup. Export/Import of database using Data Pump Utility was configured.
• Created and configured the Oracle Standby databases. Configured Data Guard for Physical, Logical and Active Data Guard providing HA of DBs. Monitored DB growth and activities and Exception notification procedures thru Emails.
• Database automation for Crontab script using UNIX ksh and Dynamic SQL scripts for administration purposes and integrate data load scripts using SQL Loader. Administration of Oracle DB instances using OEM 10gR2 Grid Control.
• Designed Dimensional data models (Snowflakes, Star Schemas), which consisted of both fact and dimension tables. Maintained code tables, materialized views and fact tables being loaded on a daily basis from various sources. Logical and Physical Database design using ERWin. Working with ETL tools such as Data Stage and Informatica for Data masking to protect customer info and implemented Row-Internal Synchronization, Table-Internal synchronization and table-to-table Synchronization and Encrypting the data by Nulling Out Or Deletion.
• Administering Oracle 10i EBS DBs. Backup and restore process for the DBA best practices and tuning the server.
• Applying Oracle Patches when/as required. Contacting Oracle Support using METALINK. Responsible for writing SOP for the DB server implementation procedure and mentoring Junior DBAs includes Offshore in Europe and Asia.
• Working on Remedy ticketing tool to handle online queries of developers / users and resolving them remotely and providing them solutions. Database size is >20TB and administered >80 DBs.
• Installation, configuration and administration of Oracle 10gR2/9i databases for Production (24X7), Development and QA on environments such as Sun Solaris v10, IBM AIX v5.3 and Linux.
• Configuration of ADDM for analyzing data in the Automatic Workload Repository (AWR) to identify potential performance bottlenecks. Configured Automatic Storage Management (ASM) for effective storage and administration of Oracle files, Configured ADDM for bottleneck problems, memory related issues, DB Configuration problems, Space related issues, application/SQL tuning issues etc. Used AWR snapshot reports for ADDM to analyze data for performance bottlenecks. Enables fine grained Auditing.
• Administration of Oracle 10gR2 Real Application Cluster (RAC) based nodes. Configuration of 10G OEM Grid Control to administer Production/Development Servers. Configuration of OEM GIRD 10gR2 for DB monitoring.
• ONLINE HOT database backup of Production database followed by OFFLINE COLD backup of TEST and QA databases mostly using RMAN. DB Cloning and restore from RMAN backup.
• UNIX K-sh Shell Scripting mostly in order to achieve scheduled backups and data loading and Crontab jobs. Implemented the scheduler in the production environment. Configured Veritas Netbackup v6.5 for Data Protection and Disaster Recovery plan. Used Oracle Flashback Option for DB Recover. Supporting Oracle 10i Apps Server for Development and Test environments including Mainframe environment.
• Tuning of SQL structured queries, Database Tuning for improving database performance using STATSPACK, Hints and Oracle Automated Tuning Procedure. Writing complex codes using Dynamic SQL. Designing and implementing DW logical data model (ODS, Star/ Snowflakes Models). Worked on Informatica v8.6.
• Used Materialized Views (snapshots) for replication of data. Worked on optimizing new and existing SQL queries by creating indexes and materialized views. Managed Standby DB for disaster recovery, locally managed tablespaces, Function Based Indexes, Global Temporary Table. Configuration and installation and support of OBIEE.
• Validating Models created in ErWin and structuring DDLs according to the business/client requirements. Used Advance Oracle features such as MERGE, Analytical function and dynamic SQL for the migration scripts.
• Applying Oracle Patches and raised the issues/concerns creating TAR in METALINK.
• The Geo Database was provided by ESRI. The Geo Databases in ArcGIS was stored in "ArcSDE Geo Database". It was used for City of Philadelphia’s urban planning on SPATIAL Database.. Database size is 8 TB.
• Installation and configuration of ORACLE 9.2.x for AIX 5.2 and Sun Solaris 8 according to OFA.
• Database is running on ARCHIVELOG mode. Database backup mode is ONLINE HOT BACKUP. Export/Import of the databases at users/table levels. Oracle9i/8i back up and restore/recover using Recovery Manager (RMAN) utility to locate, back up, restore, and recover data files, control files, and archived logs. Planning Backup/Restoration Strategy, Executing Shell Scripts using Corn jobs, Planning and scheduling Backups. Configure and Administration of OLAP DB
• Data load using SQL*Loader across Oracle databases. Export and Import utility across the oracle DB instances. Production Support on 24X7 bases. PL/SQL Debugging for SQL Tuning. Used Data Stage and Informatica.
• UNIX Ksh scripting to accomplish several objectives according to the application requirement. Implemented the scheduler in the Production environment. Dynamic PL/SQL Scripting and DD reconciliation.
• Responsibilities includes logical and physical data modelling, data analysis and definitions, database design and engineering, database architecture/set-up, security, standards development and implementation, data modelling tools evaluation, logical modelling consultation and advanced SQL and SQL constructs consultation and use, SQL and PL/SQL coding and scripting, database programming specifications, functional specs and user requirements. Designing and implementing DW logical data model (ODS, Star/ Snowflakes Models)
• Performance tuning using STATSPACK and UTLSTAT reports, third party tools, Explain Plan and monitoring Alert logs. Carry out Capacity planning; generate capacity reports to monitor space utilization, collecting and diagnosing performance event traces like 10046, 10053 etc. Expertise in handling ORACLE INTERNAL ORA-600 and ORA-7445 issues. Reviewed the issues & incorporate assessment for UTF-8 character set for effective DB Administration.
• Oracle Advanced Security features such as fine grained access control (FGAC), application context and global application context. Role Based access control in accessing secured customer data. Secured Enhanced Auditing and Database Risk management, Configuration of Oracle Data Masking out for Data Sensivity.
• Worked on Oracle Streams and Data Guard in a Test and Development environment. Configured Oracle 9i Data Guard for High Availability and Disaster Recovery. Administered for Data Protection for better performance and Streams AQ scalability. Worked on Oracle Streams for Message Queuing, the Data Replication and Event Management and Notification. Applying Oracle patches as and when released by Oracle Corp..
• Oracle SQL Tuning, Parallel queries, database tuning, OS tuning required for Oracle database in Production and Development environment. Tools such as STATSPACK, Analyze etc. Database table partitioning. Working in a SAN environment. Database size is 10TB.
• Installation and configuration of Oracle 9i and 8i databases on Multi-OS environment such as IBM v.5.2 and Windows 2K3/XP/2000 meeting the OFA standards. Administering and troubling shooting the database problem.
• ONLINE HOT database backup of Production databases and OFFLINE COLD backup of TEST and QA databases. Shell Scripting using Ksh mostly in order to achieve scheduled backups and data loading. Export and Import of databases in different OS. Configured Oracle 9iAS Web Portal.
• Tuning of SQL structured queries for improving database performance. Tools such as Analyze, SQL Trace, Hints, STATSPACK etc. Writing complex codes using Dynamic SQL. DB modelling for OLAP environment and configured following the guidelines.
• Configuration of Oracle Transparent Gateway for data load from MS SQL Server 2K/2K5 into Oracle 9i database. Configuration of Oracle Enterprise Manager (OEM) for administering Multi-OS based Oracle databases. Provide assistance w/troubleshooting Oracle Database Gateway for Distributed Relational Database Architecture.
• Administered SQL Server db 2K/2K5. Configured OWB for Data warehouse DB and Data load from different sources.
• Validating Models created in ErWin and structuring DDLs according to the business/client requirements.
• Applying patches released by Oracle and raised the issues/concerns creating TAR in METALINK.
• Installation and configuration of Oracle 9iAS Infrastructure portal database. Trouble shooting of any database problems and applying Oracle patches as and when required. Working on Oracle Business Intelligence (OBIEE)
• Working on Oracle Internet Directory based on LDAP based directory server. Administered LDAP directories by giving access to LDAP users for accessing the databases. Using LDAP to pursue High Availability, better securities, integration of multiple directories etc. Oracle Advanced Security and Audit trail of Databases.
• Migration of Oracle 8i to Oracle 9iR2 on LINUX and IBM AIX.Database Size is 2TB.
• Responsible for supporting application developers on best possible implementation of database schema/objects and data integrity. Design and development of PL/SQL scripts for data extraction, data transformation and data migration. Created Users/Roles, granted/revoked Permissions/Roles, defined quota on Tablespaces for users, and effective management of Locally Managed Tablespaces, Dictionary-Managed Tablespaces, and Temporary Tablespaces.
• Installation and configuration of ORACLE 9iR2 on Sun Solaris v5.8 and HP-UX 11.x for Production, Development and Test Environment according to OFA standard. Working on a database that meets the “HIPAA regulations”. Production support of the databases on 24X365.
• Data loading using SQL*Loader across Oracle databases. Script writing in Ksh to accomplish several objectives according to the application requirement. Physical and Logical database modelling using Erwin v4.x Data Modeler.
• Database backup using RMAN for HOT online backup and scripts written for COLD offline backup. Database availability is 24X7 bases. Database size is 6TB.
• Federal and Adhoc Report generation using Oracle Reports and guiding the developers to incorporate the technology for Crystal Reports v9/8. Experience using Dynamic SQL. Supporting the application written in PRO*C.
• Installation and configuration of ORACLE 9i v9.0.1.1/ v8.1.7 on Sun Solaris v5.8 and LINUX for Test Environment according to OFA standard. Oracle Client Installation 9i/v8.1.7.0.0 and Oracle Developer 6i on Solaris and Windows.
• Export & Import of Databases from one server/schema to another server/schema. Export/Import of Partitions with compressing the export/import databases.
• Installations/Configurations of Oracle Parallel Server (OPS) according to OFA structure to administer multiple instances that are connected to every single Online Transaction Processing (OLTP) databases.
• Database Backup mode is RMAN for database operating mode is ARCHIVELOG / NOARCHIVELOG mode for 24X7 activities. The environment was configured using Veritas Net backup procedure.
• Server Performance of Database. Tuning of SGA viz. Shared Pool by Tuning of Library Cache, Dictionary Cache, and Buffer Cache, Tuning of OS by Reducing Paging/Swapping, Tuning of SGA and Tuning of memory allocation. Tuning of I/O, which includes Separating of Data files and Redo log files on different locations, Striping of table data, and Separating of tables and indexes on different locations. Reducing Disk I/O Contention etc.
• Configuration/Installations of Oracle Enterprise Manager Console v2.04, Performance Pack, Diagnostic Pack and Tuning Pack to monitor database activity and schedule routine jobs, and increase database performance to automate the DBA activities on Production databases.
• Data Modeling, Database Design and identifying entities, normalization/de-normalization, Table Design and Functional Design using Erwin v4.x/3.x. ETL tools such as Informatica and DataStage.
• The system is designed to support Replication and Multi-Mater Replication applied. Implementing version control on an application system and freezing previous versions.
• Responsible for System Design, Templates, Object Libraries and PL/SQL Libraries, develop program using Oracle forms & reports, Oracle Workflow Builder, Oracle Mail, File Upload, PJC, PL/SQL Packages, Triggers, Schema Management, Replication & Testing, Database size was 6TB.
• Installations and configurations of ORACLE 8I viz. v8.1.5.0.0 (Production Server) on Solaris/HP-UX v11.x Configurations of it according to ExpressTrak Application that met MARIMBA requirement
• Installations/configuration of Oracle Developer/2000 (Forms and Reports 6i) on Windows NT 4.x Server. Installations of Report Server (v.6.0.8.10.1) to publish the reports on the web on each one-hour time frame.
• Migration of Windows NT based Oracle Server v8.0.5 to HP-UX/Sun Solaris based Oracle v8.1.5.
• Database is running on ARCHIVELOG mode and availability is 24X7. Database backup mode is ONLINE HOT BACKUP. Export/Import of the databases at user/table level. Oracle8i back up and restore/recover using Recovery Manager (RMAN) utility to locate, back up, restore, and recover data files, control files, and archived logs.
• Installations of Oracle Designer 6I and creation of repository. Installations and Configuration of Oracle Application Server (OAS) 4.0.x, Web DB, Oracle JServer. Installations/Configurations of Oracle Parallel Server (OPS) according to OFA structure. Understanding JCL codes on Mainframes.
• Configurations of Oracle Replication Server between two Production servers according to Optimal Flexible Architecture (OFA) on Production environment.
• Contacting Oracle for Patch demands and Problem resolution and Creation of TAR in Oracle METALINK. Database Size is more than 10TB consisting of 10 Databases.
• Installation and configuration of ORACLE v8.0.5 and Database Creation. Space Management, Security Policies, managing users and profiles, Creation of Roles. Monitoring of Database storage and user activities.
• Responsible for database Backups (ONLINE) using backup scripts. Database mode is ARCHIVELOG. Recovery of Database in the event of crash or corruption. Oracle7 back up and restore/recover using Enterprise Backup Utility (EBU) utility to locate, back up, restore, and recover data files, control files, and archived logs for Oracle v7.3.4 DB.
• Database Server Performance, Tuning of Shared Pool by Tuning of Library Cache, Dictionary Cache, and Buffer Cache, Tuning of OS by Reducing Paging/Swapping, Tuning of SGA and Tuning of memory allocation. Tuning of I/O, which includes Separating of Data files and Redo log, files on different location, striping of table data, and Separating of tables and indexes on different locations? Reducing Disk I/O Contention etc. Applications tuning using HINTS, EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE etc.
• Generating Erwin Metamodel to create data dictionary which stores information about data structures used in Erwin models. Use of Erwin for ODBC software to access the Database.
• Installed different software and hardware as per requirements, and administered their servers. Managed and configured existing network design to facilitate customer usage. Assisted in customizing the network as per requirements by adding new applications and programs to existing networks. Ensured that the installed applications and network functioned properly and sorted out minor issues such as insufficient speed and crashes.
• Security and documentation: Ensure data integrity and security through administration hierarchy, denying external unauthorized access. Documented reports on network architecture and functioning - Maintained and delineated important equipment needed for network operations and tasks.