SUMMARY

• Having more than 14 yrs of experience in Information technology with a strong success record in Database Administration, System Analysis & Design,SDLC and Software Development.
• Strong knowledge and experience with Oracle 11g/10g/9i/8i/8.x/7.x RDBMS on UNIX/Linux/ Windows environment.
• Excellent knowldege using Oracle Forms Developer 6/6i and Reports 6/6i.
• Ability to grasp and adapt new technologies and systems quickly. A commited team player.
• Knowledge and proven domain expertise in Energy & Utility areas and Policing.
• Certified Oracle 9i DBA, Certified Oracle Forms Developer Release 6/6i.
• Worked on more than 1 TB of Data.
• Installation, upgradation and maintenances of Oracle RDBMS on UNIX/Linux and Windows platforms.
• Backup of database Logical and Physical (hot and Cold) Procedures and also using RMAN.
• Recovery of database in case of database crash, disk /media failure etc.
• Database desing and Implementation.
• Implement and maintain database security (create and maintain users and roles, assign privileges ).
• Perform database tuining, application tuning and performance monitoring using STATSPACK, EXPLAIN PLAN ,TKPROF,AWR,ASH,ADDM report.
• Create and maintain documentation and standards.
• Capacity planning, capacity monitoring and management.
• Work as a part of team and provide 24x7 support when required.
• Load and extract formated data in and out of database (ETL).
• Perform general technical troubleshooting and give consultation to development teams.
• User requirement study
• Creating libraries for standard reusable procedures & functions.
• Prototype devlepment based on the design specification.
• Designing various data entry forms.
• Design various custom reports and essential lexical reports.
• Installation and setting up the software for run time environment.
• Training the end users.
• Sytsem support modifications according to the user request.
• Writing data conversion procedures.
• Integrated testing of application.
• Implementing and Managing RAC.

Professional Certification / Special Training and Education:

• MSCIS (Ms in computer information system)
• Oracle Certified Professional (OCP) 9i – Database Administrator.
• Oracle Certified Professional (OCP) 6i – Internet application developer, Oracle forms Developer Release 6/6i.
• Graduate in Commerce
• Post Graduate Diploma in Computer Studies
• Microsoft Certified Systems Engineer
• Sun Solaris 8.0 from Karrox Technology
• Linux Administration 7.1 from Aptech
• Training on oracle PL/sql tuning
• Oracle 8i / 9i database
• Visual Basic 6.0 fr
• Clipper 5.0
• Arcview GIS
• Oracle Developer 6i ADT
• Oracle Database Administration 9i
• Oracle Database Administration 10g
• VB.NET boot camp certification
• Oracle Developer 9ids
• CISSP (Certified Information Systems Security Professional )

TECHNICAL SKILLS:

RDBMS : Oracle DB 10g / 9i / 8i / 8.0 / 7.x, SQL Server 2000 / 7, MS Access
Middleware : Oracle 9iAS, Oracle Weblogic Server 10.3.3
Operating System & Sys Admn : Sun Solaris 10 / 9 / 8; Red Hat Linux 7.1 / 9.0, Novell Netware 4.x, Windows 2000
Programming : PL/SQL, Shell Scripts (ksh,csh), perl scripting.
Tools : TOAD, OEM 10g, Oracle Developer Suite, Nimsoft, Unicenter.
Hardware : Sun Fire, Sun Enterprise, Compaq, DELL Enterprise servers,
IBM minis
CASE Tool : Designer 2000 R 6i (Knowledge of Process Modeler,
ER Diagrammer,Database Transformer, Application
transformer, Design Editor and Design Capture), power designer

PROFESSIONAL EXPERIENCE:

Confidential, VT Dec 2007 – Till date

Sr. Database Analyst

CVPS was established in August 1929 by the consolidation of eight electric companies including those serving Bradford,Claremont (New Hampshire), Middlebuy, Rutland, and Windsor. CVPS is an independen, investor-owned, vertically integrated electric transmission and distribution company that provides energy and energy-related services to customers througout Vermont. CVPS is the largest utility company in Vermont serving more than 151,000 customers. Its transmission and distribution system is highly reliable with a low environmental impact.

Responsibilities:

• Installed and Upgraded Oracle Databases 10.1 to 10.2 on IBM AIX 5.3, RHEL 5, SLES 10 on dev/QA/production Servers,
• Installed and Upgraded Oracle Databases 10.1 to 10.2 on Win 2k Development /Production servers.
• Oracle Upgrade, Patch installation.
• Troubleshooting the performance issues for oracle database and fixing the issues. .
• Importing / Exporting schemas on development/QA/production servers , IBM AIX
• Configuring kernel parameters in Solaris and Oracle Init Parameter file to start multiple instances.
• Implemented Oracle Internet Directory , Single Sign on for CVPS, which had drastically reduced the call to help desk and support saving time. By implementing OID the users are able to login to applications using their network id and password where oracle is the backend.
• Implemented Oracle RAC 10g on SLES 10 on 2 node production environment, storage used is compellent.
• Actively involved in performance and tuning for all the Oracle 11g RAC databases with 2 nodes and 2 instances on each node, storage used is compellent.
• Managing all sybase ASE 12.5.4 servers on development,QA, production environment.
• Managing all SQL server 2005 databases on Dev/QA/production environment.
• Good knowledge of using BRBACKUP and BRRESTORE tool for SAP systems where backend is ORACLE.
• Preparing documentation/runbooks for all the processes when migrating, new requirements or moving the changes to production.
• Any projects carried out has a project management documentation prepared.

Environment: Oracle Database 10g, IBM AIX 5.3 , Redhat linux AS 5, SLES 10, TOAD ver. 9. Sql optimizer ver. 7. Sybase , OEM 10g Grid, Sybase replication, SQL server 2005/2008

Client – Confidential, Dallas, TX Mar 2007 – Nov 2007 Sr. Oracle DBA

INFOR i is the world’s 3rd largest provider of enterprise software, with approximately $2.1 billion in revenue and the 10th largest software company in the world that provides integrated enterprise solutions such as enterprise resource planning, supply chain management, dataware housing, customer and supplier relationship management, asset management, product lifecycle management, financial and performance management as well as business intelligence solutions.

Responsibilities:

• Installed and Upgrade Oracle Databases on Sun Solaris
• Migrated Development license model Databases from Solaris 9 to Solaris 10.
• Oracle Upgrade, Patch installation.
• Extract , transform and load data to the devlopment license model.
• Installed 10g Rel 2 database ver. 10.2.0.2 , Patched the database to patch set 2 (10g rel 2 -10.2.0.3 ), preparing document for db creation and db patch.
• Importing / Exporting license model database.
• Configuring kernel parameters in Solaris and Oracle Init Parameter file to start multiple instances.
• Provide 24 x 7 Production Support and day to day DBA activities.
• Configuring xmail on Sun Solaris 9
• Installation of resin 3.1.0 ( application server ) on solaris 9.
• Installation & configuring of GNU C compiler 3.4.6 , apache 2.2.4, sunstudio 11 and Install jdk ver. 1.6.0.01 on solaris 9./ 10
• Troubleshooting the problems in the production database , web server and license model database.
• User creation and implementing security procedures /roles.
• Create and update operational procedures and IT project documents
• Designing the backup strategy and implementing the optimal backup procedures to ensure that data are securely protected against a system failure.
• Creating databases that is in compliance with the logical and physical database layout standards.
• Perform system auditing, capacity planning and ensuring security policies are implemented.
• Configuring and integrating pc-miler, cygwin, czar to the Transport management system
• Managing RAC and Dataguard instances.
• Installed and implemented Oracle enterprise manger 10g Grid control on sun solaris 10.
• Implemented New Features of 10g like Auto SGA (Auto Space Management). Tune Database Performance
• RMAN Implementation for Development/QA/production database
• Scheduling shell scripts for Physical and logical backup of Oracle Databases
• Very recent project was implementation of OID 11g ( Software /components used to configure and setup to successfully execute this project were , weblogic server 10.3.3, Oracle database 11g rel 2 , Repository creation utility for Fusion middleware 11g, patch for fusion middleware 11g ( 11.1.1.4), Oracle password filter 11g ,configuring Oracle directory service manager,configure the domain mapping rules and attributes)
• Setting up Nimsoft monitoring tool to monitor oracle alert logs, tablespace checks, RAC instances, CPU, disk, I/O , network etc.
• Managing sybase replication server 15, sybase ASE 12.5, SQL Server 2005,2008.

Environment: Oracle Database 10g, 9i, 8i , Sun Solaris 10 / 9 , TOAD, Sun Fire v210, 280R,V240, netra t1, netra t 1400/1405 ,OEM 10g Grid

• required to assist performance and ensure maximum uptime of the database.
• Using third party softwares Quest Spotlight, TOAD, OEM.

Confidential, Jan 2003 – Nov 2006

Oracle DBA / Analyst developer

This system has been implemented at all the police directorates which record the all the necessary information of reporter, offender, victim, suspects , crime location, arrest location, action taken, imprisonment details etc. Every month the backup is taken from all the police directorate and consolidated at the central server located at Planning & Organization directorate after that various statistical and graphical reports are generated based on the Minister's , Undersecretary's and senior officials request , following are the reports generated from the criminal record database.

• Top 3 crime blocks for bahrain
• Top 3 crime blocks for each directorate
• Total no. of offenders for the month
• Total no of crime by crime category
• Total no. of crimes by directorate etc.

The database is integrated to GIS to produce crime analysis report graphically.

Responsibilities:

• Responsible for the complete system design, development and implementation of the system.
• Responsible for installation of oracle 9i production database.
• Script written for consolidation of the data received from all the police directorates.
• Setup Backup and recovery procedure using RMAN.
• Responsible for creating statistical reports from the Criminal records database.
• Monitor performance, backup and recovery, error logs etc.
• Responsible for creating triggers, procedure and functions using PL/SQL.
• Responsible for object management and performance and tuning, storage management.

Environment: Oracle 9i , 8i, windows 2003/winXP

Confidential, Feb 2002 – Dec 2002

Oracle DBA / Analyst developer

This system comprises of 6 modules namely - Manpower, Correspondence, Inventory/Stores, Armoury , Duty Distribution & Vehicle Distribution and Maintenance. This system keeps track of the various activities of the Special Security force Directorate (Ministry of the Interior). The software records details such as Personel Details of the employees and maintains Arms and Ammunition Issues and receipts. Various customized reports are developed based on the directorates need.

Responsibilities:

• Responsible for the complete system design, development and implementation, testing support and new enhancement of the system.
• Responsible for installation of oracle 9i production database.
• Monitoring Oracle system tablespaces, application tablespaces and other system resources for space allocation, table extents utilizing OEM.
• Implemented Backup Strategy.
• Performed database queries and wrote monitoring scripts using SQL*Plus and PL/SQL.
• Loaded data using SQL*Loader, validated integrity of of loaded data.
• Managed Users and their privileges, monitored and rebuilt indexes.
• Data collection and reporting using PL/SQL stored procedures.

Environment: Oracle 8i,9i, DBArtisan, Windows 2003/WinXP

Confidential, Ministry of the Interior, Kingdom of Bahrain. Apr 2001 – Jan 2002

Oracle DBA / Analyst developer

This system records information of the cases received from various directorates and other ministries for any kind of specimen examination. The information of the case such as date , time , location of crime, specimen collected from the scene of crime etc. are recorded, later the specimen is sent to the respective sections such as toxicology, chemistry, physics, biology etc. later the specimens are segragated and sent to the subsection under each section for the test/analysis. The tests are carried by various instruments in a particular section based on the specimen receieved or collected which are then analysed for various results. This system is incorporated with summary, statistical and detail report for the cases registered, sections and sub-sections. The main objective of the system is to determine the no. of cases recevied during a particular period , the type of cases, the no. of specimen and the type of specimen received in each section and subsection, analysed for what and the result if it is negative or positive, the cost involved in analysing the specimen by each instrument etc.

Responsibilities:

• Responsible for the complete system design, development and implementation, testing, support and new enhancement of the system.
• Responsible for installation of oracle 9i production database.
• Implemented backup Strategy.
• Perform monitoring, troubleshooting, maintenance and tuning of database.
• Use TOAD, SPOTLIGHT on Oracle, OEM tools.
• Responsible for creating database triggers, procedures and function.
• Installed, upgraded and patched oracle database and oracle develper 6i.

Environment: Oracle 9i / 8i, windows 2000, oracle forms developer 6i, reports 6i, TOAD,OEM

Confidential, Jan 2000 – Mar 2001

Oracle DBA / Analyst developer

This system records information of the applicants who applies for Bahraini Nationality, and the Bahraini Passport issued. The system is based on the 5 legal general categories. The detail 17 legal categories are based on 5 legal categories which can assess the applicants chances to get the bahraini passport. The information of applicant , spouse, child and relative of the applicant who is holding bahraini passport are entered. A summary and detail report states the current status of the information of the applicant, spouse and children who applied and received bahraini passport.

Responsibilities:

• Responsible for the complete system design, development and implementation of the system.
• Responsible for installation of oracle 8i production database.
• Migration of the database from 8i to 9i.
• Monitored and improved database performance by changing the allocation of resources.
• Monitoring standby database availability, maintaining schema referential integrity.
• Monitorinng Storage availability and SQL statement performance.
• Performed capacity planning , backups and troubleshooting.

Environment: Oracle 9i/ 8i, Windows 2000, Windows NT, oracle forms 6.0 and reports 6.0

Confidential, Jan 1999 – Dec 1999

Oracle DBA

This system captures all the police cases and the information is sent to Legal affairs directorate and Court based on the crime types. Also this system captures the application request for verification certification of an individual, generate verification certificate( Good conduct Certificate ) for individual for whosoever request for it , for eg. Organization where an individual has applied for job, overseas companies etc. The information is cross checked if the indivual is involved in any cases based on the finger prints , CPR , Name etc.

Responsibilities:

• Responsible for the partial development and complete implementation of the system.
• Responsible for installation of oracle 8i production database.
• Migration of database from 8i to 9i.
• Developed database stored procedure and triggers.
• Performed re-organization of tables and indexes to improve performance.
• Managed support for CRO database including monitoring backups , monitoring tables growth statistics.
• Moving production statistics data to testing database.
• Monitoring SQL Statements performance.
• Used OEM and TOAD for the health check of the database.
• Customised report generation using report builder 6.0

Environment: Oracle 9i/ 8i, IBM AIX 4.3 , CA Datacomb, SNA server, Windows 2000, Windows NT, TOAD,OEM, oracle forms 6.0 and reports 6.0.

Confidential, Sept 1997 – Dec 1998

Oracle DBA / Analyst developer

System consists of four different Modules namely - Registration, Investigation, Administration (Inventory Control System, Manpower Information System, Correspondence Information System) and System Utilities. The objective of the system is to issue permit cards,owner ship cards , track the renewal of the permit cards, information of the boat owners, persons or company registered to a particular boat etc. the voyage information, the accident information etc. track the information instantly to check if the driver is holding a valid permit by calling the control room at the CGD head quarters. The various dynamic and static reports are incorporated to the system helping the management to make the right decision at the right time.

Responsibilities:

• Responsible for the complete system design, development and implementation of the system.
• Responsible for installation of oracle 8.0 production database.
• Migration of the database from 8.0 to 9i.
• Responsible to configure and connect CGD database to ID works software to print Boat Permit and Registration cards.
• Analysed the performance of the database and performance tuned the database.
• Setup backup and recovery procedures using RMAN.
• Porting the data from mainframe system ( Harbour Master system , Customs and Ports directorate) to Oralce 9i .

Environment: Oracle 9i/ 8i, Windows 2000, windows 2003,TOAD,RMAN,sql loader, oracle forms and reports 6.0/6i

Other Ministry of the Interior, Kingdom of Bahrain , Projects full time involvement / support

• Detention & Juvenile System for Women Police Directorate.
• Good Conduct Certificate system for General Directorate of Criminal Investigation.
• Interpol system for General Directorate of Criminal Investigation.
• Prisoners Account Management system for Correction & Rehabilitation Directorate.
• Minor Accident system for General Directorate of Traffic.
• Suspicious Transaction Record system for Anti Economic Crimes Directorate.
• Recruitment System for Under Secretary’s office.
• Correspondence system for Minister’s office Affairs.
• Casuality Bureau system for Civil Defence & Fire Service Directorate.
• Revenue Accounting system for Finance Directorate.
• MOI ID Card system for Planning & Oraganization Directorate.
• Telephone Accounting system for Telephone Section – HR Directorate.
• National Committee for Facing Disaster system for Chief of Public Security.
• ID Card System for Agents for General Directorate for Nationality , Passports and Residence.
• Statistics/Questionnare ( Arrival/departure passenger suggestions ) for GDNPR.

Configuring workstation at Control Room(999) to connect SNA server at CID to access Central population registration system (similar to SSN) information from Central Informatics Organisation, Juffair.

Migration of Data/Application Foxpro 2.6 data ( Arabic – nafitha interface) to Oracle 8i

• Clipper 5.1 data to Oracle 8i.