Professional Work Summary

• Over 8 years of extensive experience in Oracle and SQL server database
• Administration and 9 years in IT Industry.
• Administration 11g/10g/9i/8i on UNIX, AIX, SUN Solaris and Windows2000/NT.
• Expertise in performance tuning, crisis management and high availability to increase reliability, maximize productivity and introduce system efficiencies.
• Extensive knowledge of Oracle Architecture and experienced in the technical areas of Oracle Installation, Upgradation, RMAN Recovery/Backup, Database Monitoring, Cloning, Auditing, RAC, PL/SQL and Performance Tuning.
• Worked as a Database Administrator in several Companies ranging from Pharma, Insurance, Banking to Retail.
• Experienced in Full Life Cycle of Database administration in Oracle. Worked both as a Development and Production Support DBA in Oracle.
• Extensively used 11g, 12c Oracle Enterprise Manager OEM for maintaining and monitoring databases.
• Experienced in Installation, Configuration and deployment of Oracle 10g, 11g database and Real Application Clusters RAC on different nodes with Automatic Storage Management ASM .
• Installation of 10g, 11g Real Application Clusters RAC /Clusterware on UNIX.
• Experienced in RAC Upgrades from 10g to 11g.
• Extensive Experience in supporting OLTP, Peoplesoft, Data Warehouse database applications.
• Extensively used PL/SQL Stored procedures, triggers, packages , SQL PLUS, SQL LOADER, Explain Plan, and SQL tuning of Oracle database.
• Extensive Experience with Unix Shell Scripting and Perl Programming
• Set up data replication using Oracle Streams and Oracle Golden Gate date replication technologies.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio
• Extensive experience in Data Integration and Data Management.
• Designed and implemented backup and recovery strategies. Extensively used conventional and RMAN for backup and disaster recovery. Experienced in advanced recovery methods like PITR and TSPITR. Logical backup using and full/ partial export/import and Data Pump.
• Good experience in working with Oracle, Sybase and SQL server.
• Experienced in Capacity Planning and Forecasting Database growth.
• Expert in Performance Tuning, SQL Tuning and interpreting AWR and ADDM reports.
• Provided Production support to the applications on a 24x7 basis. Ability to work beyond regular hours.
• Excellent communication, interpersonal and business interaction skills.
• Experienced with Oracle security technologies such as Audit Vault, Database Vault and Fine Grained Auditing.

Employment Summary

Roles and Responsibilities:

• Upgraded databases from 10g to 11g.
• Migrated databases to Exadata RAC platforms.
• Installed and configured Goldengate Streams to replicate data and to maintain Zero downtime for Data Migration Go Live.
• Set up 8 node Exadata database clusters for DEV, UNT and LOD environments.
• Set up 3 node database clusters for Production environments.
• Worked on Exadata DR Solutions.
• Set up OEM 12c grid control and monitoring.
• Installed new databases for high security projects.
• Optimized Application performance and tuned long running queries.
• Monitored Load testing for projects and provided suggestions for Performance improvements.
• Supported Peoplesoft, OLTP and Datawarehouse environments.
• Maintained SQL Server database based applications.
• Set up RMAN backup jobs.
• Refreshed DEV, UNT and LOD from Prod databases.
• Automated day to day database administration jobs.

Roles and Responsibilities:

• Developed database solutions for Oracle Customer Care and Billing application and Smartgrid application.
• Installed and upgraded versions of Oracle10g to 11.2.0.2
• Installed Oracle work flow monitor.
• Worked on the installation, configuration and upgradation of multi node RAC database on ASM Automatic Storage Management .
• Upgraded RAC databases from 10g to 11g.
• Worked on Cross Platform migrations using RMAN Conversion and Transportable tablespaces.
• Cloned databases across the environment using RMAN and export/import utilities.
• Installed and configured Goldengate Streams.
• Worked on RMAN backup and recovery scenarios.
• Worked on Oracle Database Vault and Audit Vault.
• Installed and upgraded 11g Oracle Grid Control.
• Setting up alerts and warnings using Oracle Grid Control.
• Participated in production On Call 24x7 support.
• Configured Oracle Dataguard to ensure successful replication of primary database to standby site in VCS cluster configuration in a maximum availability mode.
• Developed PL/SQL code for creating and maintaining stored procedures, packages, triggers, sequences for appropriate business functionality.
• Tuned long running batch jobs.
• Worked with developers to optimize long running SQLs and suggested performance tuning hints.
• Designed schema objects, integrity constraints and database links between upstream and downstream systems to interact with the core applications.
• Scheduled UC4 and UNIX Cron jobs to collect table, index statistics to enhance SQL performance, fine tune the database.
• Trained junior database analysts, developers in database aspects of the application.
• Documented troubleshooting techniques for various database alerts and PL/SQL errors.

Roles and Responsibilities:

• Responsible for maintenance and administration of a 10 Terabyte Data Warehouse database application.
• Installed and upgraded database from Oracle10g to 11g on DEV, QA, UAT and Production on a Linux platform.
• Maintained the physical standby database using Dataguard to ensure high availability.
• Failover/Switchover to DR for database maintenance.
• Installed and maintained a 4 node RAC using Oracle Grid Architecture.
• Tuning memory parameters best database performance.
• Day to day performance through OEM grid and operating system tools.
• Worked on RMAN backup and recovery scenarios
• Performed Point in time recovery of tablespace/table following user errors.
• Tuned long running sqls using sql profiler and xplain plan for optimal performance.
• Implemented advanced partitioning methods on large historical tables to improve performance.
• Worked on AES encryption methods to phase out historical and store in disks.
• Created partitioned tablespaces using list partioning and range partitioning methods.
• Performed year end tasks involving archival of old data using encryption methods, dropping old partition tablespaces, creating new tablespaces.
• Created partitions on various data warehouse data mart tables as per functional requirements.
• Deployed Fine Grain Auditing FGA as per security requirements and SOX guidelines.
• Worked with the application team to suggest application improvements.
• Worked with the Change Management Team to implement database changes and deploy code from UAT to PROD.

Role and Responsibilities:

• Installed, migrated, upgraded, patched, tested different versions of Oracle and SQL Server.
• Installed and upgraded databases from Oracle9i to 10g and from Oracle 10g to 11g on DEV, QA, UAT and Production.
• Installed, configured and tested Oracle 11g version in a testing environment.
• Tuned the batch jobs on a 1 Terabyte database to decrease nightly batch job run time.
• Maintained documentation on root cause analysis on database performance issues.
• Worked with the development team to tune high resource consuming sqls.
• Technical Lead for Implementation of Oracle Database Vault and Oracle Audit Vault across all Applications supported by the DBA team.
• Created different Realms for different User groups according to the guidelines of Sarbanes Oxley Act.
• Trained onsite and offshore teams in US and India on the Administration of Database Vault and Security Realms.
• Installed OEM grid hosting over 80 databases
• Physical and Logical Design of database, database creation, tablespace creation, table and index creation and partitioning and also mapping of different objects with disks
• Migrated database schemas across servers of same application, across different databases as Data pump and Export/Import utilities.
• Installed, configured and tested Oracle Streams/Multimaster replication on IBM AIX server as a proof of concept.
• Installed, created, administered, and monitored a Real Application Clusters database with Automatic Storage Management ASM .
• Upgraded RAC from 10g to 11g.
• Performed patching of the RAC instances in a Rollover fashion.
• Configured RAC Backup and Recovery Using EM.
• Performed cloning from a single instance database to a Multi Instance RAC system.
• Worked with Development team to write standards for logical modeling and the deployment of the ERWin data modeling tool.
• Provided database support for large databases of size more than 1 Terabyte which includes OLTP and Data Warehousing applications.
• Tuned the OLTP and Data warehouse databases for optimal performance.
• Used Enterprise Manager OEM to monitor stress testing of the applications by the testing and the development teams and made suggestions for query tuning.
• Extensively worked in tuning ad-hoc SQL queries with both OLTP and data warehouse databases.
• Created partitions on various data warehouse data mart tables and OTLP tables as per functional requirements and for performance related issues.
• Installed, configured and used the reports of Orasecure, an in-house Oracle Security Administration and user auditing tool.
• Configured and managed Physical standby database using Data Guard for disaster recovery on a different node for different production servers
• Performed Data guard switchover/failover as per the requirements.
• Created monitoring scripts for monitoring and alerting space and out of sync issues.
• Cloned databases on same node and also on different server nodes using custom shell script with hot and cold backups of source database
• Converted and migrated databases from Solaris to AIX servers both on source and target servers.
• Installed, configured, administrated and maintained SQL Server databases on Wintel Servers.
• Used SQL Server Management Studio for Database Administration.
• Installed, configured and administered using windows cluster service and SQL Server Cluster services 2 node cluster using SAN storage devices.
• Installed, configured and used Quest Light speed for backing up SQL Server databases.
• Configured standby database for disaster recovery of SQL Server 2005 production databases using database mirroring and log shipping.
• Performed switchover/failover of SQL Server production databases to standby databases.
• Used database tuning advisor and SQL Profiler for performance optimization.
• Extensively used T-SQL for application development and database related activities
• Setup of automated jobs, alerts using SQL Server Agent
• Designed and implemented backup strategies for SQL Server databases
• Tuned T-SQL queries using SQL Server Management Studio, Query Analyzer, SQL Profiler, Index Analyzer
• Wrote PL/SQL blocks, stored procedures and packages for performing tasks related to few of the tools that are used for administrations such as DB Check list etc.
• Resolved database connectivity issues from application servers, users with Oracle 9i and 10g databases.
• Interacted with customers for specifications, data gathering, trouble shooting, testing and SQL tuning.

Roles and Responsibilities

• Designed and implemented database security using Oracle roles and privileges.
• Created physical database design models from object and data models.
• Involved in the development, care, and maintenance of logical and physical ERWIN data models, along with corresponding metadata, to support Novellus Systems Online Applications.
• Troubleshooted Database performance issues using Automated Workload Repository AWR and Automatic Database Diagnostics Monitor ADDM . Tuned database for optimum performance.
• Analyzed the database to allow Oracle optimizer to choose best plan in executing the queries
• Tuned wait events slowing down the database performance.
• Automated UNIX Scripts for manageability, management and monitoring of databases using Shell Programming and SQL Plus.
• Troubleshooted backup and purge scripts for backup/purge failures.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database de fragmentation.
• Installed Oracle 9i databases, upgraded Oracle 9i databases to Oracle 10g database and performed DBA tasks in a 24x7 environment.
• Upgraded the database from Existing Oracle 9i version to Oracle 10g.
• Created and configured Oracle 10g database.
• Configured physical standby database using Oracle Data guard feature for High availability configuration.
• Performance Tuning, coding and Monitoring for Oracle Application Clusters, Oracle Management Server, OEM on RedHat Linux Advanced Server with 4 nodes server side load balancing using Automatic Storage Management.
• Configured Oracle Streams Advanced Replications and exchanged data between two databases in remote locations.
• Installed 10g Real Application Clusters RAC on Linux based platform
• Added and Deleted nodes in a RAC environment.
• Used Oracle replication as databases for read only snapshots to maintain local copy of master tables in OLTP systems. Also done Patches for upgrading Oracle and DBMS software.
• Worked with Dev team to create Data models for various applications using ERWin modeling tool.
• Modeled Data with extensive normalization activity and Data warehousing
• Developed UNIX scripts to set up monitoring alerts on the databases.
• Transported tablespaces and data exports from production and staging databases. Tuned SQL queries to pull data from Data warehouse tables.
• Designed and Implemented Back up Recovery strategies.
• Done Capacity planning for databases and provided database space calculations for the supported database environments.
• Proactively managed the databases, set up alarms for managing any exceptions in day-to-day management of the database.
• Cloned Hot and Cold Production Database for reporting and analysis purposes.
• Worked in advanced recovery methods like PITR and TSPITR.

Roles and Responsibilities

• Responsible for Oracle 9i/8i logical and physical database design, implementation and maintenance on UNIX.
• Developed UNIX Shell scripts to automate database operation and database monitoring.
• Configured oracle database software and assisted creation of database and schema.
• Created Database Objects, Database Triggers, Procedures and Functions.
• Designed, coded and implemented backup scripts.
• Expanded Physical Data Model PDM for the OLTP applications using Erwin.
• Implemented locally managed tablespaces. Modified the existing scripts used for backup.
• Provided database related services to their development and QA environments.
• Transported tablespaces and data exports from production and staging databases. Tuned SQL queries to pull data from data warehouse tables.
• Worked extensively on Dataguard for high availability.
• Tuned SQL statements using EXPLAIN PLAN. Tuned memory System Global Area, Shared pool area, Data Buffer Cache and Library Cache , I/O, Contention, modified parameter file and rebuilt indexes according to the requirement for performance.
• Used Oracle backup utility RMAN/EBU to implement Oracle backup and performed a number of times of disaster recovery.
• Installation and configuration of Statspack and analysis of Statspack. Performance report and subsequent tuning of production database.
• Developed UNIX shell scripts, Ant scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, Unix error messages, disk space availability, segments with greater than 10 extents, segments nearing max extents, checking for errors in alert logs and trace files, etc.
• Worked on Quest Shareplex for replication and high availability.
• Restored and Recovered old data using Recovery manager
• Scheduled maintenance and health check of the applications and databases.