TECHNICAL SKILLS:

OPERATING SYSTEM: RHEL,AIX 5L,Linux, Sun - Solaris, Windows 2012, Windows XP, DOS, Windows 2008

DATABASES: AWS Cloud Architect/Glacier/S3/EC2/IAM, Oracle 12c, Oracle 11g, Oracle 10g RAC environment, Oracle 10gR2, Oracle 9i, Oracle 8i, Oracle 8.0, Sybase 12.0, MS Access, MySQL, Microsoft MS-SQL server, Timesten,Hadoop, Bigdata, datawarehouse

TOOLS: Goldengate, Foglight, Netflow, DB Artisan, Rapid SQL, Visio, BMC Patrol, Clearcase, SQL Loader, Oracle export/ import utilities, Awk, OEM/ OMS, RMAN, Erwin, Informatica, Foglight, VSS, Star Team, Toad, Veritas Netbackup, Netapp- filers, Dynamips, Boson . Goldengate,Ms Project, Tivoli, VM ware,Veridata, GoldenGate Director, Hadoop, Bigdata, Pig Hive,Big data, etc

LANGUAGES: PL/SQL Programming, SQL, Shell Scripting, Sybase Stored Procedures, Perl, Awk, Pig,Hive, Java

Networking Skills: Sound knowledge on Networking side working on Cisco routers/switches. Key Skill sets and strengths include:

Networking Protocols: OSPF, BGP, EIGRP,RIPV2,IPV4, IPV6, DHCP, DNS, Active Directory,Domain Controller.

Other Networking Skills: Multicasts, MPLS, QOS,VPN, NAT, Unicasting, ACLs,troubleshooting, etc

Layer 2 expertise: STP, VLAN, VTP,Ethernet,Frame relay,HDLC, PPP,DHCP, etc

PROFESSIONAL EXPERIENCE:

Confidential, New York

Project Architect/Manager

Responsibilities:

• Set up AWS (Amazon Web Services) Virtual Private Cloud infrastructure for the customer
• Configure AWS instances for EC2 as well as Storage S3 for research project.
• Configure Cloudwatch for alerts monitoring/alarms,etc
• Create various policies using AWS Policy Generator and attach them to IAM roles as required.
• Enabled cross-account access using IAM roles to give users access across AWS accounts when they need it.
• Enabled Multi-factor authentication (MFA) to AWS account and to individual IAM users for extra security.
• Confiigure access management via IAM and security set up via NACLs and Security groups. Configured DNS route53 settings for the custoner.
• Provided DHCP High Availability Solution for the Customer via Hot Standby feature of Windows 2012 at enterprise level.
• Moved Legacy 2008 system to DHCP failover cluster with Domain Controller on Windows 2008
• Led VLAN consolidation at the Core level for the customer.
• Managed and Lead Infrastructre and Replication projects for the Customer.
• Collapsing Core Routing and Access Layer into Collapsed Core Model using layer 3 switching.
• Plan and Document effort including Network diagram, topolgy, port mappings,etc.
• Managed projects involving Building Development Network for research activities at the Customer Site.
• Including Planning and Implemention of Goldengate Monitor for Production environments.
• Implemented Goldengate Heterogeneous replication amongst DB2/ MySQL / MS SQL server /Oracle.
• Worked on setting up infrastructure for the customer over AWS S3/EC2 instance and platform.
• Set up AWS VPC (Virtual private cloud) for the customer.
• Worked on Sybase support including setting up Sybase replication server for fault tolerance.
• Worked on Install/Setup of DB2 database for the customer.
• Worked on backup and other production support activities for the customer.
• Worked on Heterogeneous replication from DB2-UDB to MS SQL server using Sybase replication server.
• Deployed Golden Gate replication in production and stage environments.
• Deployed GoldenGate in high availability environments with failover capability.
• Deployed Foglight for Customer for monitoring the infrastructure including databases and network.
• Deployed Foglight NMS for Customer in different environments.
• Worked with System and Network administrations and set up reports from Foglight to do health check and performance troubleshooting.
• Oracle Exadata Support for Production and Non Production environments.
• Worked on performance tuning Oracle exadata environment.
• Worked on building huge RAC Clusters for different customers at client site .
• Migrate data from non partition to partitioned format using database redefinition for internal properties.
• Production support of some critical properties including Exadata support, Grid Control, Backup/Recovery as required at the customer site.
• Build data warehouse for customer using replication tools for ETL including goldengate and informatica.
• Manage the team of people mentoring them on technical side and architectural side.
• Set up brand new RAC clusters using ASM storage.
• ETL mappings using goldengate tools and informatica to transform and load to the target environment.
• Installing Oracle 12c in Production and other lower environments.
• Performing Backup/Recovery using RMAN
• Troubleshooting performance issues as and when required.
• Implementing OEM (Oracle enterprise Manager) to monitor Oracle production and standby databases.
• Also configuring OEM/OMS to monitor production and stage environments.
• Deployed GoldenGate Monitor in production environment.
• Worked on exadata for Stage and Production environment.
• Worked on VMWare Virtual environment supporting database and application.

Confidential, New Jersey

Principal Architect

Responsibilities:

• Deployed Foglight at customer enterprise network including OS, Databases,Network,etc.
• Build Dashboard/Foglight reports from tool for Health check.
• Deployed NMS Foglight for monitoring the network and troubleshooting database bottlenecks.
• Manage projects including Planning and Implemention of Goldengate Monitor for Production environments.
• Manage and lead team of people and Implemented Goldengate Heterogeneous replication amongst DB2/ MySQL / MS SQL server /Oracle.
• Worked on Sybase support including setting up Sybase replication server for fault tolerance.
• Worked on Heterogeneous replication from DB2-UDB to MS SQL server using Sybase replication server.
• Deployed Golden Gate replication in production and stage environments.
• Deployed GoldenGate in high availability environments with failover capability.
• Worked on building huge RAC Clusters for different customers at client site .
• Migrate data from non partition to partitioned format using database redefinition for internal properties.
• Production support of some critical properties including Exadata support, Grid Control, Backup/Recovery as required at the customer site.
• Build data warehouse for customer using replication tools for ETL including goldengate and informatica.
• Manage the team of people mentoring them on technical side and architectural side.
• Set up brand new RAC clusters using ASM storage.
• ETL mappings using goldengate tools and informatica to transform and load to the target environment.
• Upgrading databases to 12c from 11g starting with development all the way to Production.
• Troubleshooting performance issues as and when required.
• Implementing OEM (Oracle enterprise Manager) to monitor Oracle production and standby databases.
• Also configuring OEM/OMS to monitor production and stage environments.
• Deployed GoldenGate Monitor in production environment.
• Worked on exadata for Stage and Production environment.
• Worked on Hadoop setup and setting up Name Node and slaves.
• Using Pig/Hive to pull data from HDFS Hadoop cluster 1.x
• Deployed GoldenGate Director and Veridata at customer site.
• Defining backup policies including RMAN and export backups for production and non production environments.
• Developed Shell/Perl scripts to monitoring goldengate replication.
• Deployed Oracle gateway for connectivity with DB2 and MS Sql server
• Deployed Oracle ODBC connectivity to pull data from DB2 databases.
• Performance tuning of Slow queries in the databases.
• Supported Oracle and SQL server databases for the customer.
• Deployed Heartbeat monitoring for goldengate set up in production environments.
• Performance tuning and troubleshooting issues in Production and non production.
• Designing architecture for production databases to support multiple kind of failures like switch failure, nic failures, host failures, power strip failures as well as colo failures.
• Implemented Standby database/ Data Guard for Production database as a full proof disaster recovery solution. Tested smooth switchover/failover with Data Guard.
• Performance tuning and troubleshooting as and when required in RAC and non RAC environment.
• Worked both as a Senior Architect as well as a team player, acted as mentor for Junior Oracle DBA’s.
• Monitoring of databases via OEM tool integrating all the database monitoring under the grid control.
• Develop detailed design document for customized solution, defining standards, develop service specific road map for development and implementation.
• Worked with project managers and architects, participating in SDLC, design, testing, reviews and demonstrations.
• Automatiion of changes across via shell scripting.
• Currenlly working on setting up Hadoop cluster v1.1 for pilot implementation.
• Build high level and physical design document including infrastructure specifications, software versions and configurations.
• Tier 3 support responsible for product implementation, design and integration.
• Participate in project planning and release management.
• Review infrastructure side and operations side of the product and improve/customize the design.
• Lead various goldengate projects at the customer site. Co-ordinate with the team and ensured timely delivery of the projects.
• Play key role in designing application and review all changes done via change management.
• Cordinate with application team, network team and storage group to ensure correct infrastructure build for the project.
• Mentor junior members and direct them to achieve SLA and meet the goals and objectives.
• Coordinating performance testing, work with various teams during enhancements, tracking issues, deployments and troubleshooting as and when needed.
• ETL-Informatica for data handling and transforming.
• SQL server support including creating new databases/backup for the projects.
• Manage data warehouse for the customized reports. Deployed Oracle Virtualbox for testing and QA activities.

Confidential, Englewood Cliffs, NJ

Senior Technical Lead/Architect

Responsibilities:

• Recommend and Review Storage Solution for some of the sensitive databases at Confidential - Pure Storage, Fusion ION and other storage solutions.
• Used Swingbench and Hammerora to review different storage solutions.
• Worked on building huge RAC Clusters for different customers at Confidential .
• Migrate data from non partition to partitioned format using database redefinition for internal properties.
• Production support of some critical properties at Confidential .
• Implementing OEM (Oracle enterprise Manager) to monitor Oracle production and standby databases.
• Also configuring OEM/OMS to monitor production and stage environments.
• Deployed Golden Gate replication in production and stage environments.
• Deployed GoldenGate in high availability environments with failover capability.
• Deployed GoldenGate Monitor in production environment.
• Deployed GoldenGate Veridata to resolve discrepancies.
• Worked on exadata for the customer in Prod and Non Prod environment.
• Set up of RAC and ASM on Prod and Non Prod environments.
• Deployed informatica for data loading activities.
• Worked on Hadoop/Big data/ Map-reduce jobs for analytical needs including Pig/Hive to write jobs for Hadoop cluster.
• Defining backup policies including RMAN and export backups for production and non production environments.
• Data modelling for designing the logical design.
• Deploying informatica for ETL needs for the project.
• Developed Shell scripts to monitoring goldengate replication.
• Deployed Oracle gateway for connectivity with DB2 and MS Sql server
• Deployed Oracle ODBC connectivity to pull data from DB2 databases.
• Performance tuning of Slow queries in the databases.
• Deployed Heartbeat monitoring for goldengate set up in production environments.
• Implementing Goldengate Monitor for Production environments.
• Implemented Goldengate Heterogeneous replication amongst DB2/ MySQL / MS SQL server /Oracle.
• Deployed Golden Gate replication in production and stage environments.
• Tuning of performance issues to support development activities.
• Deployed GoldenGate in high availability environments with failover capability.
• Worked on building huge RAC Clusters for different customers at client site .
• Migrate data from non partition to partitioned format using database redefinition for internal properties.
• Production support of some critical properties
• Implementing OEM (Oracle enterprise Manager) to monitor Oracle production and standby databases.
• Also configuring OEM/OMS to monitor production and stage environments.
• Deployed GoldenGate Monitor in production environment.
• Defining backup policies including RMAN and export backups for production and non production environments.
• Developed Shell/Perl scripts to monitoring goldengate replication.
• Deployed Oracle gateway for connectivity with DB2 and MS Sql server
• Deployed Oracle ODBC connectivity to pull data from DB2 databases.
• Backup and recovery of databases as required.
• Performance tuning of Slow queries in the databases.
• Deployed Heartbeat monitoring for goldengate set up in production environments.
• Performance tuning and troubleshooting issues in Production and non production.
• Designing architecture for production databases to support multiple kind of failures like switch failure, nic failures, host failures, power strip failures as well as colo failures.
• Implemented Standby database/ Data Guard for Production database as a full proof disaster recovery solution. Tested smooth switchover/failover with Data Guard.
• Worked both as a Senior Architect as well as a team player, acted as mentor for Junior Oracle DBA’s.

Confidential, Sunnyvale, CA

Senior Technical Lead/Architect

Responsibilities:

• Designing and setting up strong and robust infrastructure and architecture with Oracle 11g R2 RAC deployed for most sensitive properties like Confidential Answers, Personals and Hot jobs.
• Designing Network level architecture for critical properties like Personals, adding switch redundancy for fault tolerance and also power strip redundancy. This would help reduce point of failures.
• Worked on building huge RAC Clusters both for Pilot testing and production implementation for some critical properties like Personals and Search - submit, etc starting from its launch.
• Worked on VLDB environment and supported business needs in Production environments.
• Implementing Snap mirror technology during Confidential Answers support to refresh the reporting environment. Worked on having DUAL NIC support and VIF enabling for netapp filers to ensure there is enough redundancy to sustain NIC, Switch and power strip outages.
• Data modelling for designing the logical design.
• Deployed informatica for data transform/loading (ETL) activities.
• Set up Replication between DB2/AIX and Oracle using Goldengate.
• Production support of some critical properties like Confidential Personals, Confidential Answers, Confidential Hot Jobs, Search - submit, Confidential Photos, Confidential Personals, etc. Provide Oncall support for these properties.
• Implementing OEM (Oracle enterprise Manager) to monitor Oracle production and standby databases.
• Also configuring OEM/OMS to monitor Mysql hosts using mysql plugin.
• Deployed Golden Gate replication in production and stage environments. GoldenGate high availability solutions were deployed for the customer
• Deployed GoldenGate Hearbeat monitoring across various environments. Developed Shell/Perl scripts to monitor the environments.
• Worked on identifying bottlenecks in production systems and tuning of Databases to improve response time.
• Deployed GoldenGate Director and Veridata at customer site for comparison between source and target.
• Worked with different teams in troubleshooting database issues including hardware failure and Oracle- RAC issues.
• Worked in setting up Materialized view replication for some of the project.
• Tuning of database using ASH, AWR, OEM, indexing and partitioning techniques, etc.
• Worked on building Standby databases for different properties and testing backup strategies for databases and building two layer standby databases.
• Worked on Capacity Planning for important properties like Hot jobs/Self Serve submit and plan to build RAC clusters for new properties under Search submit.
• Worked on Mysql Version 5.0 support as well for application.
• Worked on developing Shell scripts for proper monitoring of databases and automatic alerts in case of any issues.
• Troubleshooting Oracle RAC issues and host hung problems during oncall support and all kinds of host related and hardware related issues on production boxes.
• Converting stand alone boxes to RAC clusters adding more power to the production boxes.
• Addition of Nodes to RAC clusters to add power to the production boxes.
• Memory upgrades, troubleshooting RAC node eviction issues, etc.
• Implementing Mat view replication for the production boxes based on client requirements.
• Debugging issues at host level during host outages including mining logs, working with Network and Storage team in troubleshooting root causes on Network and storage end, etc.
• Colo Migration for Oracle production boxes with minimal downtime.
• Worked with Netapp and Oracle on different scale and technical discussions/concerns/business needs, evaluating core products.
• Worked on Hadoop/Bigdata/HDFS/Map-reduce(Mapreduce) jobs for crunching and processing data for analytics doing parallel processing.
• Writing Pig and Hive jobs to pull data from the Hadoop cluster.
• Worked on 24 *7 Oncall support for Confidential core database environments like Confidential Personals, Confidential Local, Auction,etc
• Implemented Oracle 11g Grid Control for centralized monitoring of all Confidential oracle databases recently.
• Recently started working on upgrading all Oracle 10g databases to 11gR2. Pushing necessary patches on the environments to keep it upto date with regards to related bug fixes
• Working with Confidential Shopping team in understanding business requirement and designing Oracle database architecture to meet their needs. Also implementing DR site for BCP needs, managing backups.
• Worked on Netapp features like Snapmirror/Flexclone to refresh our staging environments.
• Supported Mysql project for internal Confidential properties and also oncall support.
• Implemented Oracle 11g RAC for development and production for new properties.
• Migration of data from Oracle to Sql server 12.0
• Resolving issues related to ODBC and other connectivity issues. Capacity planning for databases.
• Implementing and support Data Warehouse for Confidential Mart database. Performing ETL jobs to extract transform and load the data automatically. Built customized reports from the data marts.
• Worked on Sybase supporting few properties at Confidential .
• Did pl/sql scripting for supporting project activities
• Installing and upgrade mysql databases from 4.x to 5.x version.

Confidential, Nashville, TN

Production Database Administrator (Sr. DBA)

Responsibilities:

• Built RAC Clusters for Production Environment from Scratch over AIX 5L environment using SAN storage and Gigabit interconnect.
• Configured ASM storage for RAC databases and raw devices for Clusterware files.
• Built Disaster recovery solution for Production system with Standby Data-Guard support.
• Restored Stand alone DB’s to build and configure the Production RAC. Set up the backup and restore for RAC environment.
• Responsible for space management across RAC database supporting the Application, monitoring of databases and generating more space proactively.
• Cloning of database using RMAN as needed by the business.
• Tested TAF over RAC environment to justify the successful fail-over in situations like instance failure.
• Provided On-call support as well as support to users to entertain and resolve any issues with production and development boxes.
• Production support for SQL server based databases.
• Monitored issues escalated by Precise tool (a tool to escalate issues related to any application or database). Different issues had different priorities set and time slab to fix the same. Used Awk and shell scripts to generate and format the reports related to space/ listener / oracle alerts.
• Documented the process and database related policies defined for the Project and Prepared user manuals.
• Performing RMAN backups over tape periodically and preserving archive logs backup as well over the tape. Provided late hours support on rotation basis.
• Implemented Oracle streams for database replication. Also provided Sql server production support for the properties.

Confidential, Charlotte, NC

Senior Database Administrator (Sr. DBA)

Responsibilities:

• Responsible for implementing RAC over RHEL 4.0 environment using Fire-wire interfaces.
• Responsible for space management across RAC database supporting the Application, monitoring of databases and generating more space proactively.
• Testing TAF over RAC environment to justify the successful fail-over in situations like instance failure.
• Tuned production databases supporting the application using AWR.
• Provided Disaster recovery solution for Production system with Standby Data-Guard support.
• Developed backup and recovery strategy and tested it periodically.
• Implemented high availability options i.e. advance replication to ensure prompt response and support multiple users across the globe by maintaining multiple master sites and kept them tied up with Asynchronous replication.
• Checked on tablespace fragmentation and automatically prompted user in case of any issues with alert log files.
• Making PL/SQL programs for application development and report generation. Also involved in helping Developers on creation of tables, indexes, triggers, designing of database, etc.
• Provided On-call support as well as support to users to entertain and resolve any issues with production and development boxes.
• Monitored issues escalated by Foglight system (a tool to escalate issues related to any application or database). Different issues had different priorities set and time slab to fix the same. Used Awk and shell scripts to generate and format the reports related to space/ listener / oracle alerts.
• Documented the process and database related policies defined for the Project and Prepared user manuals.
• Performing RMAN backups over tape periodically and preserving archive logs backup as well over the tape. Maintaining source code versions in Star Team. Provided late hours support on rotation basis.

Confidential, Salt Lake City, UT

Senior Database Administrator (Sr. DBA)

Responsibilities:

• Responsible for upgrading Oracle databases from 9i to 10g. Installed Oracle 10g binaries and also created fresh 10g databases.
• Worked on RAC database support for FICL customers.
• Responsible for space management across development and production databases supporting the Confidential Application, monitoring of databases and generating more space proactively.
• Migrated Confidential schemas across different versions of Confidential application using BMC Patrol.
• Tuned production databases supporting the application using Statspack.
• Developed disaster recovery site i.e. Standby database for the primary database to ensure minimum downtime in event of crash or sudden crisis. Kept database in auto recovery mode to make online logs and kept the standby database up- to date in order to save time during disasters. Also got familiarized with Advanced Queuing to manage work-flow of work-items.
• Developed backup and recovery strategy and tested it periodically.
• Implemented high availability options i.e. advance replication to ensure prompt response and support multiple users across the globe by maintaining multiple master sites and kept them tied up with Asynchronous replication.
• Checked on tablespace fragmentation and automatically prompted user in case of any issues with alert log files.
• Conducted weekly meeting with junior DBAs and application development team to know any issues with the database and plans for the subsequent weeks for support group.
• Provided support to users to entertain and resolve any issues with production and development boxes.
• Monitored issues escalated by PACE system (a tool to initiate issues related to any application or database). Different issues had different priorities set and time slab to fix the same. Used Awk and shell scripts to generate and format the reports related to space/ listener / oracle alerts.
• Documented the process and database related policies defined for the Project and Prepared user manuals.
• Did production support for Microsoft SQL server database for small reporting applications.

Confidential

Senior Data Architecture (Sr. DBA)

Responsibilities:

• Responsible for designing of tables, indexes, constraints, views needed to meet the business requirements.
• Developed ERD and Database Design overview for the project and defined the flow of information.
• Responsible to propose backup strategy and maintaining daily backup of database.
• Periodically tested the database backups.
• Proposed physical and logical design of database, redo log files, etc.
• Tuned database using Statspack, Scripts based on V$ views and data dictionary to prompt for any contention for different resources like datafiles, DBWR processes, Memory structures like Buffer cache, Redo buffer.
• Developed PL/SQL Stored procedures, functions and packages to send the output to APIs built in VB.
• Understood the requirements and proposed the database design.
• Responsible for Tuning of PL/SQL Stored procedures, SQL’s used with the help of Explain Plan, Autotrace.
• Coordinated with front -end developers to discuss the application needs and the data structures necessary to develop the application.
• Configured user creation, their roles, system privileges and profile.
• Created ad-hoc queries to support development team requirements.
• Developed Shell Scripts to periodically load the text files received from DCS System into Oracle tables. Updated header tables with status of Process Order Events.
• Implemented the process to generate text files containing data from Staging PO events table and transferred the final data to SAP tables, purging of Staging tables and SAP tables.
• Responsible for archiving of SAP table contents periodically into Archive tablespace.
• Periodically maintained tablespace backups.
• Used Informatica to load Process- order related data from different sources into the database.

Confidential, Tampa, FL

Database Administrator

Responsibilities:

• Responsible for migrating specific data for specific tables from Sybase 12.0 to Oracle 9i
• Reframed tables structure and indexes for some of the tables involved in the migration.
• Worked with front end developers to understand the impact of structure changes to the application.
• Created new tables and indexes to support the migration of application on new system.
• Performed tuning of databases using Statspack, Scripts based on V$ views and data dictionary to prompt for any contention for different resources like datafiles, DBWR processes, Memory structures like Buffer cache, Redo buffer.
• Developed shell scripts to automate the data movement of transaction tables from Sybase to Oracle on daily basis. Used BCP in Sybase to generate flat files and Awk utility in OS to prepare the data for Oracle tables. Developed scripts to automate the process. Used SQL Loader to upload the data into the Oracle tables.
• Designed physical and logical structure of Oracle database, tablespaces to hold the application tables for migration.
• Designed tables in Oracle database and monitored resource contention in the production box.
• Automated the refreshing of transaction tables from production database to development box.
• Responsible for Development and Tuning of PL/SQL Stored procedures, SQL’s with the help of Explain Plan, Autotrace.
• Created flashback queries and ad-hoc queries, scripts to support development team requirements.
• Analyzed the business requirements. Interacted with Development team on a regular basis to discuss any issues.
• Proposed migration strategy for the project and tested it. Fixed issues related to migration.
• Tested the migration strategy on test server and implemented the same on production server.

Confidential, Tampa, FL

Database Administrator / Developer

Responsibilities:

• Responsible for developing tables, indexes, etc for the application.
• Developed Stored Procedures in Sybase using Cursors, Hash tables.
• Interacted with front - end developers to understand the business and application requirement.
• Used DB Artisan, Rapid SQL for development of Stored Procedures.
• Performed Tuning of Stored procedures to reduce the response time of the application.
• Responsible for fixing Production problems directly in production database.
• Provided late hours support for mission critical (24*7 hours) database.
• Generated ERD’s for any design change and change in system design documents.
• Responsible for testing of Stored Procedures with the Confidential application. Replicated production problem on development box.
• Implemented the changes in tables, indexes design on changes in requirements of the business.
• Maintained different versions of the code in VSS to maintain the consistency.
• Performed system testing of application and fixed the bugs related to stored procedures.
• Implemented changes in production box and estimated the design changes.
• Entertained Customer production related issues with Spark (a ticketing system with priority defined for issue raised by the agent and timeframe in which it needs to be fixed).

Confidential

Responsibilities:

• Responsible for the development of Confidential tool for project management needs, gathered requirements from Quality group and analysis of the requirements.
• Responsible for the design and development of database and its objects i.e. tables, indexes, tablespaces, rollback segments.
• Properly sized rollback segments and redo log files to prevent contention for resources.
• Built and configured database to support connectivity of thousands of users concurrently.
• Developed scripts to monitor resource contention, wait events and system statistics.
• Developed stored procedures, packages and functions to provide output for various reports related to defects found in different project, causal analysis report and reports to track employees who have not filled their timesheets for timely billing to clients.
• Tuned database to support connectivity of many users using Statspack, home made scripts against dynamic performance views.
• Maintained daily Hot and Cold backup using NT scheduler during and after peak hours.
• Maintained archive of database on different servers to withstand any failures to database.
• Recovered database during instance failure and disk failure. Recovering against corruption of control file and data files.
• Performed incomplete recovery in case of user errors. Used RMAN to maintain backups and managing backup scripts in recovery catalog.
• Timely verified backups by testing them periodically on test server. Defining backup strategy for the project.
• Worked with front - end developers in designing of application and database.
• Implemented OFA for physical tuning of the database and improved the response time.
• Partitioned huge tables and developing Outlines, materialized views and Clusters to improve the response time of the application.
• Monitored user access by timely monitoring and auditing.
• Responsible for setting up proper privileges and roles for the users to maintain database security and managing profiles. Controlled resource by Resource Manager.
• Worked on distributed databases, database links to centralize multiple instances mapping to different centers at a single location.

Confidential

Responsibilities:

• Built Shell scripts to decode the flat files to differentiate the data pertaining to specific hub. The relevant data is uploaded at the receiving hub and any erroneous data is sent to another flat file and placed in configurable location at corporate server.
• Properly Sized rollback segments and redo log files to prevent contention for resources.
• Built and configured database to support connectivity of multiple number of users concurrently.
• Developed scripts to monitor resource contention, wait events and system statistics.
• Developed stored procedures, packages and functions to provide input to various reports related to transfer of package through Ship and the current status of the package.
• Monitored database using scripts against dynamic performance views.
• Maintained daily Hot and Cold backup using Cron job scheduler after peak hours.
• Maintained and cleaned archive logs of database on timely basis.
• Performed database recovery during instance failure and disk failure, recovery against corruption of control files / data files and complete recovery in case of user errors.
• Verified backups by testing them periodically on test server. Defined backup strategy for the project.
• Interacted with Oracle World Wide Support through Metalink and timely fixed database related issues.
• Responsible for Physical tuning of database using OFA to improve the response time of database access.
• Partitioned huge tables and developed Outlines and Clusters to improve the response time of the application.De-centralized information to different hubs periodically.
• Re-organized tables and indexes during instances of row migration to improve the performance of tables and indexes. Used shell scripts to automatically prompt the user during occurrence of row migration.