SAGAR PATIL
http://oracledbasupport.co.uk	42-44 THURLOE STREET SW7 2LT
sagar@oracledbasupport.co.uk
Nationality: British	Availability : Immediate
Mobile : 079 620 840 79	SC Clearance : SC1834/08 to Level SC

Oracle Certified DBA offering over 12 years of experience as a Database Architect and Oracle & SQL DBA.

Proven technical background in enterprise database architecture, systems and requirements analysis, data modelling, database administration and development.

Management background includes leading and mentoring project teams; team building and coordination; project management, quality assurance and full life-cycle (SDLC) exposure; designing and conducting trainings; client presentations, client coordination and communication.

Experience working in Financial Services and Telecom domain with large companies.

ROLES & RESPONISBILITIES

· Expert in building Oracle 10g RAC systems as well as RMAN, Data Guard backup and recovery strategies for production, test and development systems.

· Instructor for developers on Oracle architecture, Oracle9i/10g features, tuning methodologies, database replication, PL/SQL and Oracle HTTP Server.

· User of Statspack, SQL Trace, OEM Performance Manager, Quest Central, Quest Foglight, Quest SQL Impact, Benchmark Factory, Quest SQL Optimizer, TOAD and custom scripts.

· Writer of standards & practices for Oracle installation/upgrade/tuning/backups, PL/SQL.

· Analyst, developer, designer & implementer of disaster recovery backup procedures.

• Leader on major projects through all phases of development, testing and support.

CHARACTER ATTRIBUTES

· Love the challenges of problem solving and the joy associated with providing the right working solutions.

· Proactively involved in preventing the problems and provided logical, scalable and innovative solutions to existing critical issues by applying the knowledge gained by first-hand experience and also utilizing the knowledge of others.

· Believe in synergy and that the collaborative efforts of a good team can achieve much more than an individual hence as a team leader always focused in building a right team for a job and maintained a healthy team environment by cooperation, coordination and motivation.

EDUCATION

· Bachelor of Engineering in Computer Technology (B. Sc.), 1996

• Diploma in Digital Electronics and Software Technology, 1993

CERTIFICATIONS, COURSES & TRAININGS

· Oracle 10g New Features for Administrators

· 11i System Administrator Fundamentals

· Install, Patch & Maintain Oracle Applications 11i

· Oracle 9i New Features for Administrators

· Oracle 8i New Features for Administrators

· Oracle Database Performance & Tuning Concepts

· SQL Tuning

· Oracle Backup & Recovery

· Oracle 8i Administration

· Oracle Database Administration Fundamentals

· Oracle PL/SQL Workshop

TECHNICAL SKILLS

Databases	Oracle 11g/10g/9i/8i/8/7.3, SQL Server 2008/2005/2000/7, Sybase 12
Operating Systems	Solaris 8/10, HP UX 11, Red Hat Enterprise Linux (RHEL), Windows Vista/XP/NT
Languages	SQL, PL/SQL, TSQL, Unix Shell Script, PowerShell, Oracle Spatial
Tuning Tools	STATSPACK, AR/ASH, 10g Grid, SQL Trace, OEM Performance Manager, Quest Central, Quest Spotlight, Quest SQL impact, Benchmark Factory, Quest SQL Optimizer, SQL Profiler
Backup Recovery	RMAN, Data Guard
High Availability	Oracle 10g Real Application Cluster (RAC), Oracle Data Guard, SQL Server Log Shipping, Replication, Mirroring & Clustering
Application Server	Oracle Internet Application Server, IIS, BEA Weblogic 7.0
Monitoring Tools	Oracle 10G Grid, 9i OEM, BMC Patrol, Quest Foglight, NAGIOS
Case Tools	Microsoft Visio
WorkFlow Tools	Oracle WorkFlow 2.0/2.6, Staffware
Source Control	Visual Source Safe, MKS Toolkit, OpenSource SVN,AllChange
Virtual OS Tools	VmWare Workstation, Vmware Server, VMware ESXi, VMware vCenter

PROFESSIONAL EXPERIENCE

Engage Mutual Assurance(www.engagemutual.com), Harrogate, UK

(A spin-off from Bradford and Bingley Bank , currently leading society offering range of savings, investment and life insurance products )

Oracle Virtualization migration project DBA (Oct 2009 - 15 Dec 2009)

Database Administrator

• The role was centered around the migration of a number of databases Oracle 8i/9i/SQL Server 20005 on varying hardware, which are all being migrated to Vmware ESXi virtualized cluster.
• Being traditional financial organization, Engage had number of processes struggling with performance issues. Worked to tune existing reporting procedures consuming more than 14 hours. After an upgrade, with right database statistics and indexes, I could drop the processing time from 14 hours to 40 minutes.
• Although my skills were mainly focused on traditional DBA tasks, I could be responsible for everything from the design, modeling, sizing and tuning of new elements to a database to advising on hardware, licensing issues and costs.
• Built number of 10g standalone/RAC databases on Windows platforms. Implemented Oracle RMAN, Data Guard disaster recovery procedures.
• I also took part in design workshops, advising on appropriate solutions surrounding the Oracle technology stack, and roadmap for the future. The environment necessitated the need to adhere to operational guidelines and security and ensuring database integrity, performance tuning, indexing, segmentation and database recovery; mentoring and developing other DBAs and liaising with support groups.

Environment: Oracle 8i/9i/10g RAC, Windows, Vmware ESXi, OEM, Data Guard, RAC, SQL Server 2005.

British Gas Group PLC (bg-group.com), UK

(A leading player in the global energy market having operations in 27 countries across five continents.)

Database Architect and Oracle & SQL Server DBA (Mar 2009 - Sep 2009)

Database Architect

· As a Database Architect currently working on consolidating vast number of Oracle and SQL Server financial trading systems and devising architecture to move these consolidated systems to Oracle RAC instances and SQL Server Cluster Farm.

· Designed Spatial Systems for BG's Geophysical & Geological exploration teams spread across globe

· Worked with platform people to successfully consolidate and port individual Oracle and SQL Server systems to VMware ESXi farm. Designed VMware systems to facilitate saving data centre space and server management. In this exercise ported more than 30 sensitive systems in a short period of time by carefully designing the strategies to backup and port Oracle/SQL databases to VMware with minimum downtime.

· Designed Oracle and SQL Server systems with third-party vendors to support BG's risk assessment and cash flow systems.

Database Administrator

• Designed and developed high availability solutions for Oracle using data guard standby, RAC, multi master replication and for SQL Server using log shipping, replication, mirroring.

· On Oracle DBA front working as a Lead DBA managing and mentoring the DBA teams across UK and USA. Providing technical leadership to BG group's UK data centre and involved in management tasks such as designing 24 X 7 support model, defining SLAs and assigning support shifts to DBA team.

· Installed & maintained Oracle Spatial databases used to track assets

· Defined end to end support model using 10G Grid Control and Remedy Ticketing System. An alert raised from Grid would be logged into change management which in turn automatically raises a ticket and assigns it to relevant support parties. This change can then be tracked by DBAs and support teams for escalation, notes and to verify SLA targets. These alerts are regionalized and 24 X 7 support was provided by routing email and voicemail calls across UK, USA and Australia.

• As a Senior SQL Server DBA working on production/development environment on SQL Server versions 2008/2005. Troubleshoot and resolved SQL Server performance, connectivity and security issues.
• Set the recommended standards for installation, security, disaster recovery & backend programming within Oracle 10g, MS SQL Server 2005 SP2 environment & implementation.
• Reviewed QA (Quality Assurance) for SQL/Oracle Server installation on Linux/Windows OS.
• Set up SQL Server Asynchronous Database Mirroring between sites and developed a step by step actions and scripts to manually fail back both primary and mirrored servers as needed by operations.

Environment: Oracle 11g/10g, Solaris 10, Windows, OEM, Data Guard, RAC, SQL Server 2008/2005.

O2 Telecommunications (o2.co.uk), Leeds, Yorkshire, UK

(A leading provider of mobile services to consumers and businesses in the UK.)

Database Architect and Oracle & SQL Server DBA (Sep 2008 - Mar 2009)

Database Architect

• Architected the migration project involving Oracle advanced replication and successfully planned, implemented, documented and tested the entire migration process.
• The project involved migrating 4 nodes in 9i advanced replication cluster at different geographical locations to 6 node replication cluster to build redundancy and performance.

In order to keep the downtime to minimum during this migration process designed a data guard standby at remote location and achieved almost no downtime while servers were disassembled and transported to a new location.

• Also designed and implemented 10g grid control alerting system and took lead in moving the 9i OEM monitoring system onto a new 10g grid platform.

Database Administrator

· Worked as development and production Oracle DBA for Oracle 9i and 10g on Solaris and HPTrue64. Implemented and supported Real Application Clusters on Oracle 10g. Created and maintained 9i physical standby databases using Data Guard and RMAN. Developed several Korn and Bourne shell scripts for DBA operations.

• As a SQL Server DBA worked on implementation of a Disaster Recovery strategy by keeping Standby Ms SQL Server in sync with the live server in log shipment topology. Documented the steps to bring the standby server to act as the primary server in case of failure.
• Configured and rolled out enterprise level surface area, server and database facets using policy management. Used dynamic view and SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code.
• Worked significantly on high transactional and very critical (24/7) production SQL Server databases and involved in management, operations, maintenance, performance tuning and troubleshooting.

Environment: Oracle 10g, 9i Enterprise Edition, Solaris 10, HPTrue64, Windows, OEM, Data Guard, RAC, SQL Server 2005.

BT-NHS Spine Program, Saint Albans, Hertfordshire, UK

(The Spine is part of the NHS Care Records Service (NHS CRS). Having each patient's Summary Care Record stored on the Spine will mean that wherever and whenever a patient seeks care from the NHS in England, those treating them will have secure access to summary information to assist with diagnosis and care. This should provide safer, more joined up care)

Oracle & SQL Server DBA (Mar 2008 - Sept 2008)

Database Administrator

• Worked as a Lead Oracle RAC DBA, building, administrating 10g RAC on Solaris 10 platform for NHS Spine Program which was considered as one of the most complex systems in Europe.
• NHS spine was extremely complex system consisting of 122 - 3 node RAC databases having total database size around 55 Tera Bytes and was managed by team of mere 10 DBAs thus providing a very challenging environment to work in.
• Part of the project work was implementation of Oracle RMAN, Data Guard disaster recovery procedures on top of RAC cluster for critical production databases.
• Configured, deployed, tested, administered RMAN and Data Guard setup over RAC.
• Worked as an on-call support member in 24 X 7 environment performing ad-hoc as well as routine activities like database monitoring using OEM and shell scripts, fixing performance issues and working with Oracle Support.
• Planed, implemented, tested and documented Oracle Disaster Recovery Plan and Backup recovery scenarios.
• Resolved Oracle performance issues regarding indexes and locking. Used SET statement to enable the SHOW PLAN, STATISTICS TIME and STATISCTICS PROFILE options, manual or auto update statistics, performance counters for bottlenecks etc.
• Used Trace, Profiler to troubleshoot different problems with SQL Server.

Environment: Oracle 10g, 9i Enterprise Edition, Solaris 10, 10g Grid, 9i OEM, Data Guard, RAC, SQL Server 2005.

Teamsolve(teamsolve.co.uk), Derby, UK

(A leading Oracle DBA & Oracle E Business Suite consultancy)

Oracle & EBS DBA (Jan 2008 - Mar 2008)

Database Administrator

• Worked as a Lead Oracle RAC DBA and was involved in building 10g/11g RAC on Linux/Windows/Solaris platforms for the end clients like ICM hosting provider, Department of Finance, Getty Images etc.
• Implemented Oracle RMAN, Data Guard disaster recovery procedures on top of RAC cluster for critical financial databases.
• Analyzed, designed and implemented high availability Financial Trading system using RAC for prestigious client like J P Morgan, White Young, Green Consulting to name a few.
• Restored a crucial financial system using RMAN selective tablespace mechanism and recovered a crucial payroll data in a matter of hours.
• Worked on Oracle Application Server farming to achieve 99.99% availability on middleware and maximum throughput.
• Installed and maintained Oracle EBS Suite Release 11.5.10. Administered the instances using Oracle Applications Manager. Applied patches, done cloning. Handled the database recovery issues.
• Other daily activity included database monitoring using OEM and shell scripts, liaising with and advising junior DBAs on various issues and working with Oracle Support.
• Worked in 24 X 7 environment monitoring and supporting critical production databases ranging from 100 GB to as large as 7 Tera Bytes.

Environment: Oracle 10g, Solaris 10, Linux, Windows, OEM, Data Guard, RAC.

Yellow Pages (Yell.com), Reading, UK

(Global market leader in online advertising. I was lead member of SAP BASIS and Oracle DBA team)

Database Architect and Oracle & SQL Server DBA (Jan 2007 - Dec 2007)

Database Architect

• Worked as a core member of database practice on Database Architect and DBA roles and was involved in architecting and providing DBA support to a large enterprise database system involving SAP ERP modules such as order processing, payroll, finance and BW.

· Played a major role as a database architect and was involved right from the beginning of the project and carried out successfully key tasks in implementing and subsequently administrating and supporting the entire system.

· Worked close with business stakeholders and developers to gather and analyze system requirements as a whole and database requirements in particular.

· Prepared a detailed project plan for management review, including high level design, risk assessment, security considerations, recommendations for the software, hardware and storage systems.

· Coordinated with management, development and QA teams during the entire project life-cycle phases and updated the management on project tasks, milestones, status and issues.

· Architected the entire database system overseeing the needs for performance, scalability, maintenance and disaster-recovery issues and set up the standards for logical and physical database design.

· Also designed a web portal for monitoring the tablespaces, server volumes for database growth, DBA privileges on Oracle accounts, data guard standby logs, history of active transactions etc. The existing software (BMC Patrol) could not provide details on these database activities.

Database Administrator

• Helped SAP BW analysts to restore system performance which went down 4 folds after upgrading from one release of SAP to another. Optimized the number of SAP/Oracle background processes for quicker response times. Worked on configuring 10g RAC cluster for high availability on Solaris 10.
• Used VERITAS i3 for monitoring SAP transactions and hard hitting SQL sessions. Put tremendous efforts in tuning SAP database for maximum performance.
• Provided DBA support during development phase of several projects. Responsibilities included setting up development/Live databases and routine production refreshes for development and QA teams complying with organization/SAP standards and stringent security requirements.
• Provided 24 X 7 support to several live production systems having database sizes ranging from 100 GB to 4.2 TB.
• Responsibilities included proactively monitoring and tuning databases. SQL tuning in liaison with developers. Working with Oracle Support in resolving critical database issues. On-call support using remote database access for ad-hoc issues.
• Also worked with testing and QA teams in developing test plans, test cases, scripts for test automation for various tests like regression, performance, system, stress tests.
• Actively involved in coordinating with fellow DBAs on various activities like providing remote database support to development/test teams, primary patch analysis, patch application, scheduled cloning, production deployment, apps system admin, database performance tuning and health check.
• Key achievements included implementing Oracle Data Guard on a new server hardware for the critical financial database, configuring, deploying, testing and documenting the data guard setup and successfully conducting the switch-over to the new live system. Wring Unix shell scripts to raise alerts when "Standby" is not in step with "Primary". Writing number of RMAN backup/restore procedures for online, offline backups and to duplicate database from live/test servers to development environments. Handled the challenging situation of recovering the lost schema in critical database with point in time recovery using RMAN and user managed recovery procedures. Tuned an overnight PL/SQL process to drop execution time from 20 hours to 10 minutes.
• Worked as a SQL Server DBA and was involved in all aspects of DBA and development work including performance, security, maintenance, backup strategy etc. on production as well as development databases.

Environment: Oracle 10g/9i Enterprise Edition, Solaris (10/9/8), HP UX 11, Windows Servers, OEM, Data Guard, RAC, SQL Server 2005, SAP R3, BW 7.1, SAP CRM, Business Objects.

British Telecom PLC BTExact (bt.com), UK

Solutions Architect and Oracle & SQL Server DBA (Jan 2005 - Jan 2007)

Solutions Architect

• Worked as a Solutions Architect as part of the BT's ADSL/DSL flow stream team and designed the systems and databases to handle the challenges faced by BT in connection with sudden unanticipated business growth.
• Designed oracle spatial database systems to track mobile devices. The system was dependent on ability to locate parcels as it moves across different stages of the distribution network. An RFID system was used to locate movement of mobile devices based on Oracle Spatial.
• BT went a big way into market with groundbreaking ADSL/DSL/SDSL packages and the business exploded beyond anticipation and presented many challenges such as handling data uploads by third-party resellers, data security and performance issues. As a Solutions Architect designed the systems addressing these key issues and ensured a smooth business flow.
• Designed a system which provides much more functionality and flexibility than Oracle XML parser in handling XML data. The system was implemented by designing custom PLSQL XML parser with limited tag support.
• Designed a system to address the key issue of data security and provided a water tight security using Oracle HTTP Server and VeriSign digital certificates. The 2 way certificates guaranteed that client would only be able to connect if they have the signed certificates imported in their IE/Netscape browsers.
• The initial order handling system was not designed to cope up with the load of 15,000 orders/day as the business was not anticipated to grow in such a pace. The system was struggling and needed a expert review. Did a lot of database tuning to meet the performance demands and kept the system flowing 24 X 7. Suggested and carried out upgrade in terms of hardware where database tuning efforts failed to show any improvements due to software limitations and system load. Also improved the performance by splitting the databases vertically into separate applications on number of servers.
• Was also part of ADSL re-grade team which moved all BT ADSL circuits from 512 KBPS to 2 MBPS and later to 4 MBPS. Moved more than 5 million customers/year to new speed and new Alcatel ADSL exchanges. Worked and put forward a free source NAGIOS system monitoring for ADSL ports and used MRTG graphs for traffic shaping and to locate data flows between exchanges.

Database Administrator

• Worked as a Senior Production Support DBA responsible for database administration tasks like installation , up-gradation, backup, recovery, tuning and maintenance.
• Experienced challenges working in an environment with rapidly growing databases and incorporation of new technological advancements to the existing systems.
• Planned and documented steps to upgrade(migrate) SQL Server 2000 databases to SQL Servers 2005 on Windows 2003 R2.
• Migrated from SQL 7 on NT 4 Cluster to SQL Server 2000 onWindows 2003 Cluster.
• Managed (Archive/Delete) old backup and log files on live servers by using ROBOCOPY tool.
• Managed Very Large databases (VLDB) by partitioning, filegroups and multi device backup file across volume drives.

Environment: Oracle 10g Enterprise Edition, Solaris 8, Windows Servers, OEM, Data Guard, SQL Server 2005.

British Telecom PLC BT Retail (bt.com), UK

Database Architect and Oracle & SQL Server DBA (Jan 2003 - Jan 2005)

Database Architect

• Designed a back end system to compliment the main front office system developed using Siebel.
• Architected the internet order handling system using Oracle 9i, BEA Weblogic 7.0, J2EE infrastructure, Eclipse IDE, Staffware and Oracle Workflow 2.6.

Database Administrator

• Managed datacenter activities like installation and maintenance of Oracle databases and application servers, administration of the instance using Enterprise Manager, applying patches, cloning, raising TAR to resolve issues with Oracle Corporation, recovery of the databases, troubleshooting the ad-hoc issues, applying localization patches etc.
• Resolved many performance related issues. Designed automated way to rebuild fragmented indexes.
• Carried out Oracle Web Server and Weblogic Server management, BEA Weblogic installation, E-Business Apps installation and patch maintenance on Solaris/Linux/Windows platforms.
• Upgraded the systems form Oracle 8i to 9i and 9i to 10g for several clients.
• Was responsible for checking the backup logs to ensure backups were taken, monitoring the alert logs, general database housekeeping like data file maintenance, monitoring the logs of various parts of the product and third-party processes, creation of databases, setting up database options, databases deployment from development to production.
• Managed nearly 90 SQL Server version 7 and 2000 databases.
• Carried out migration from SQL Server 7/2000 to Oracle 9 using Oracle Migration Workbench.

Also migrated data from SQL Server 7 to 2000 handling different issues like TempDB size, @@servername, net-library etc.

• Designed and configured the replication of SQL Servers 2000 using Transactional Replication with Immediate Update through firewall.

• Identified and tuned expensive SQL Server queries; carried out loads of performance tuning and indexing with Lock Management and Profiler.

Environment: Oracle 10g/9i, Solaris 8, Windows 2000 Servers, OEM, SQL Server 2000.

Fasttrack PLC, UK

Database Architect and Oracle & SQL Server DBA (Jan 2001 - Dec 2002)

Database Architect

• Designed databases for Fastrack Broadband Systems used for provisioning the ADSL orders on BT systems.
• Was integral part of development/production team and used Oracle Web Server 4.0, Oracle 8i/7.3 and workflow 2.0 to design and develop a web based system for ADSL/DSL order management.
• Helped to define acceptable order limits of web based design, data build and data capture techniques and tuned system to accept 10,000 orders/day with no significant SQL code changes.

Database Administrator

• Progressed to the position of Lead DBA for BT's tactical broadband order gateway/XML system. Was responsible for creating and refreshing test databases for development, QA and testing teams, creating base product TAR, applying base product patches, applying localization patches, managing tablespaces, data files indexes, clusters, rollback segments, tables and constraints on ERP database.
• Performed data maintenance activities like hot and cold backup, import/export, data loading using SQL Loader, database recovery etc.
• Ensured that all the Fasttrack applications meet Y2K compliance.
• Put in place DBA procedures related to database health checks, backup and recovery.
• As a SQL Server DBA reviewed and optimized warehouse and production database server indexes.
• Documented daily DB activities through automated SQL Agent jobs (counters like db size, drive space limitation, file location for backups and job timings & results etc.) with alerts to operators.
• Automatedremote management techniques and alerts (events like more than 10% change in drive space or storage below 2 GB etc.).
• Designed system to predict when the database will run out of space based on projectedDB growth patterns.
• Reviewed & maintained security plans on all production servers and check withMicrosoft Baseline Security Analyzer.

Environment: Oracle 8i/7.3, Solaris ,Windows 2000 Servers, OEM, SQL Server 2000, Sybase Release 12.

Motorola Electronics Limited, Stratford, Hertfordshire, UK

Oracle DBA and Developer (Oct 1999 - Dec 2000)

Database Administrator and Developer

• Involved in systems analysis, database design and development.
• Designed physical and logical database models using tools like S-Designer and Erwin.
• Created primary database storage structures and various database objects.
• Developed backup and recovery procedures for Oracle 7.3 and Sybase 11.0.
• Developed Oracle PL/SQL packages, stored procedures, functions and triggers.
• Migrated code segments from Sybase Release 11 to Oracle 7.X.
• Resolved the tricky and challenging issue related to application performance. The issue was with terrible response time offered by one of the packages used to provide inputs to electronic robots on an automated assembly line. The robots required response from Oracle in less than 1 second to pick up right IC/Resister/Capacitor and other components to make up production belt requirement. Decided to optimize the database as SAN storage was not up to the mark those days. It was oracle 7.3 database with rule based optimization. Took initial decision to add few indexes and made some improvement but that was not good enough. Researched and analyzed the problem and finally came up with the idea of caching the tables into oracle SGA and moving many tables into a PL/SQL array (memory structures) while processing. The response time improved significantly from few minutes to less than 100 Milliseconds. It was a great achievement and was highly appreciated by the management.

Environment: Oracle 7.3, Sybase 11.5, Solaris 8, HP Unix Release 11

Bombay Stock Exchange & TCS Share Transfer Limited (tatashare.com), India

(A leading provider of share transfer & registry services in India)

Oracle DBA and Developer (Jun 1996 - Sep 1998)

Database Administrator and Developer

• Worked as a DBA/Oracle Lead for 2 years in a very challenging environment, learnt many tricks and trades by practically resolving the real world database problems, gained a great experience which is relevant & useful even today and which proved to be a firm foundation for the knowledge gained during the entire career as a database expert.
• Worked in a team responsible for migrating the entire Honeywell Mainframe based systems to Oracle open systems. The environment was oracle 7.1 with Forms 3.0 on Novell NetWare 3.10. The system was migrated to Oracle 7.3/8.0 and Forms 4.0 and subsequently to Forms 4.5 with Novell NetWare 4.11 & NDS (Novell Directory Structure). They had initially 16 database servers which were reached to 30 by the time of my leaving the organization.
• Also worked with BSE (Bombay Stock Exchange) through Tata Shares and was part of NSDL DMAT implementation team for electronic shares. Designed and developed Dividend Payment systems which would process data for tonnes of shareholders (about 20 million shareholders) and send them dividend cheques every 6 months.
• Resolved one of the tricky issues where Oracle couldn't manage the dot matrix printing feeds and often after 1000 cheques printing the figure would move outside the amount box on dividend vouchers which won't be accepted by banks. Developed a code in Pro*C and Oracle to make sure line feeds work well and cheques are printed absolutely spot on.
• When the system was migrated from mainframe, around 15-20% of shareholders' details went missing. Written scripts to cross verify the things with reference data supplied by mainframe vendor, a complicated data cleansing work which needed endless PL/SQL coding and writing PL/SQL procedures/triggers/packages which run well over 10,000 lines.
• Designed an automated standby database recovery system and designed central server under SCO Unix to monitor remote oracle databases 24 X 7 X 365.
• Gained a significant hands on knowledge working on various core DBA activities including server installation, database creation, backup/recovery, networking the Oracle database system, database and SQL performance tuning, user management, space monitoring and management, transaction management using rollback segments, security management using various authentication methods etc.

Environment: Oracle 8/7.3, Solaris, SCO Unix, Novell NetWare, SQL, PL/SQL, Pro*C.