SUMMARY:

• I have twenty three years of professional IT experience out of which more than FOUR years as LEAD Database Administrator, FIFTEEN years as a Senior Database Administrator, FIVE years as a Data Architect / Data Modeller
• 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.
• Configuration and Administration of Oracle 11gR2 and 10gR2 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.
• Installation and Configuration of Oracle Apps 10i/11i in different operating systems for VLDB in OLTP & Data Warehouse environments. Implementation of Oracle 11gR1/R2 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 option s. .
• 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.
• 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.
• Effective ways of writing stored procedures, functions, triggers and packages using PL/SQL. Writing UNIX Ksh shell scripts for scheduling of jobs in Crontab for Database monitor and PERL Scripting . Worked on Autosys for scheduling and monitoring jobs. Used packages such as DBMS JOB, UTL FILE, DBMS STATS, DBMS SQL, DBMS REORG and DBMS SCHEDULER.
• Performed Oracle DB patching, cloning, troubleshooting issues/errors; collaborate with Oracle support for bugs and creating TAR in METALINK . 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 . Experience in building Data warehouse environments with Star Schema and SnowFlake Architecture.
• Worked as a Cloud Database Administrator and involved in PEOPLESOFT based Oracle environment migration to Amazon Web Services (AWS). Involved with issues for PeopleSoft application to run effectively.
• Installations and Configurations of MSSQL Server v2K5/2K8. Installations and Configurations of Sybase Adaptive Server Enterprise (ASE) v12.5/11.x on UNIX and Windows. Performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks and troubleshooting.
• 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 form Source DB to Target DB.. Configuration of Oracle Replication Server for Advanced Multi-Master & Basic replication type in Oracle 9i/8i.
• Worked on EMC Symetrix DMX, EMC CLARiON NAS devices, Hitachi, IBM, DMX SAN storage devices.

PROFESSIONAL EXPERIENCES:

NC,

Responsibilities:

• 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 an d 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.
• 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.

Environment: Oracle version 11g/12c on RedHat LINUX. TOAD v8/9 & ErWin v6.x for data model design, MS Visio, SQL Developer, JAVA and EMC BCV etc.

Confidential,

Responsibilities:

• 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 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.
• 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, Oracle SQLDeveloper on Amazon Web Services (AWS) on Cloud. Applied Oracle EBS patches.

LEAD DBA/Data Architect,

Confidential, ME

Responsibilities:

• 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.

MS SQL Server DBA

Responsibilities:

• 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.

Oracle DBA / Consultant

Confidential, Philadelphia, PA

Responsibilities:

• 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 replication 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.

Environment: Oracle version 11gR1, 10gR2 Server on Sun OS 10, IBM AIX and Linux, TOAD v8/9 & ErWin for data model design, MS Visio, SQL Developer, JAVA, Tivoli etc.

Sr ORACLE DBA/Data Architect,

Responsibilities:

• 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 an d 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.

Environment: Oracle version 11g, 10g, 9i (v9.2) Server on Sun OS 10 and IBM AIX v.6.1, LINUX. TOAD v8/9 & ErWin v6.x for data model design, MS Visio, SQL Developer, JAVA and EMC BCV etc.